APPS.FV_CCR_BPN_LOAD_PKG dependencies on FV_CCR_FILE_TEMP

Line 216: field_counter number :=235; --Number of fields in fv_ccr_file_temp

212: procedure main is
213: --Get rows
214: cursor c_clob_data is select * from fv_ccr_bpn_clob_data where ccr_info not like '%BOF BPN COMPLETE%' and ccr_info not like '%EOF BPN COMPLETE%';
215: loop_counter number :=0;
216: field_counter number :=235; --Number of fields in fv_ccr_file_temp
217: from_index number :=1;
218: to_index number :=0;
219: clob_buff clob;
220: ccr_data new_data;

Line 235: delete from fv_ccr_file_temp;

231: ccr_data := new_data();
232: ccr_data.EXTEND(235);
233: --ccr_codes := new_codes();
234: --ccr_codes.EXTEND(235);
235: delete from fv_ccr_file_temp;
236: -- delete from fv_ccr_class_codes;
237: -- delete from fv_ccr_flags;
238: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_PROCEDURE, l_module_name,l_errbuf);
239: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'Inside Main','Entering for loop');

Line 304: INSERT INTO FV_CCR_FILE_TEMP(DUNS

300: end loop;
301: for i in 30..ccr_data.last loop
302: dbms_output.put_line('ccr_data(' ||i||') is :' ||ccr_data(i)||'::');
303: end loop;*/
304: INSERT INTO FV_CCR_FILE_TEMP(DUNS
305: ,PLUS_FOUR
306: ,CAGE_CODE
307: ,EXTRACT_CODE
308: ,REGISTRATION_DATE