csv文件上傳數(shù)據(jù)庫

《csv文件上傳數(shù)據(jù)庫》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在工程資料-天天文庫。

1、上傳界面：選擇按鈕：declareaccess_idnumber;l_server_urlvarchar2(100);l_parametersvarchar2(100);button_choiceinteger;l_file_idvarchar2(100);l_gfm_idinteger;BEGINaccess_id:=fnd_gfm.authorize(null);fnd_profile.get('APPS_WEB_AGENT',l_server_url);l_parameters:='access_id='

2、

3、access_id

4、

5、'l_server_url='

6、

7、l

8、_server_url;fnd_function.execute(FUNCTION_NAME=>'FND_FNDFLUPL',OPEN_FLAG=>'Y',SESSION_FLAG=>'Y',OTHER_PARAMS=>l_parameters);--Displayamodalmessageforusertoindicatefileupload--iscompleted.FND_MESSAGE.set_name('FND','ATCHMT-FILE-UPLOAD-COMPLETE');button_choice:=FND_MESSAGE.question(button1=

9、>'YES',button2=>null,button3=>'NO',default_btn=>1,cancel_btn=>3,icon=>'question');IF(button_choice=3)THENnull;ELSIF(button_choice=1)THENl_file_id:='';l_gfm_id:=fnd_gfm.get_file_id(access_id);:MAIN.GFM_ID:=fnd_gfm.get_file_id(access_id);IFl_gfm_idISNOTNULLTHENselectdecode(instr(file_name,'

10、/'),0,file_name,substr(file_name,instr(file_name,'/')+1))intol_file_idfromfnd_lobswherefile_id=l_gfm_id;ifl_file_idisnotnullthen:main.filename:=l_file_id;selectCUX_CE_STMT_S.nextvalinto:main.working_idfromdual;endif;ENDIF;ENDIF;END;上傳按鈕：DECLAREREQIDNUMBER:=0;l_exitBOOLEAN;BEGINIF:MAIN.FIL

11、ENAMEISNULLTHENFND_MESSAGE.SET_STRING('請選擇要裝入的數(shù)據(jù)文件。');FND_MESSAGE.SHOW;ELSE--setcursorbusy---------------------------------------------------Set_Application_Property(CURSOR_STYLE,'BUSY');SAVEPOINTsp_match_one_day;REQID:=FND_REQUEST.submit_request('CE','CUX_STMT_UPLOAD',NULL,NULL,FALSE,:MA

12、IN.statement_number,:MAIN.bank_account_num,--TO_CHAR(:MAIN.statement_date,'YYYY-MM-DD'),:MAIN.statement_date,:MAIN.bank_name,:MAIN.bank_branch_name,:MAIN.CURRENCY_CODE,'CUX_STMT_UPLOAD',:MAIN.GFM_ID,:main.file_cs,:main.DELIMITER,:main.working_id,CHR(0),NULL,NULL,NULL,NULL,NULL,NULL,NULL,N

13、ULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU