APPS.FV_CCR_BPN_LOAD_PKG dependencies on FV_CCR_CLASS_CODES

Line 127: insert into fv_ccr_class_codes(duns, codetype, code) values(duns_num,

123: if(ext_to-ext_from > 1) then
124: code := dbms_lob.substr(clob_buff,ext_to-ext_from,ext_from);
125: --field := dbsm_lob.substr(clob_buff,
126: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,'Inside CCR_CODES','Extracted code is ' || code);
127: insert into fv_ccr_class_codes(duns, codetype, code) values(duns_num,
128: codeType(field_counter+proc_count+1),
129: code);
130: else
131: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,'Inside CCR_CODES','Extracted code is NULL');

Line 236: -- delete from fv_ccr_class_codes;

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');
240: for rec in c_clob_data loop

Line 773: delete from fv_ccr_class_codes where duns = p_duns;

769: l_errbuf := 'Deleting the entries from fv_ccr_codes for Duns '||p_duns;
770:
771: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, l_errbuf);
772: begin
773: delete from fv_ccr_class_codes where duns = p_duns;
774: exception when others then
775: l_errbuf := 'Following exception encountered during deletion of codes and is ignored:'||SQLERRM;
776: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, l_errbuf);
777: null;