eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_CCR_DATA_LOAD_PKG dependencies on FV_CCR_FILE_TEMP

Line 644: SELECT count(1) into dummy from fv_ccr_file_temp;

640: l_errbuf := 'Checking the info in Extract code';
641: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
642:
643: IF p_status ='Warning' THEN
644: SELECT count(1) into dummy from fv_ccr_file_temp;
645: IF dummy >=1 THEN
646: SELECT extract_code into l_extract_type from fv_ccr_file_temp WHERE rownum=1;
647: ELSE
648: retcode := -1;

Line 646: SELECT extract_code into l_extract_type from fv_ccr_file_temp WHERE rownum=1;

642:
643: IF p_status ='Warning' THEN
644: SELECT count(1) into dummy from fv_ccr_file_temp;
645: IF dummy >=1 THEN
646: SELECT extract_code into l_extract_type from fv_ccr_file_temp WHERE rownum=1;
647: ELSE
648: retcode := -1;
649: l_errbuf := 'Not even a single row was processed in Loader. Please verify';
650: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);

Line 670: SELECT count(1) into dummy from fv_ccr_file_temp;

666: l_errbuf := 'Checking the info in Extract code';
667: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
668:
669: IF p_status ='Warning' THEN
670: SELECT count(1) into dummy from fv_ccr_file_temp;
671: IF dummy >=1 THEN
672: SELECT extract_code into l_extract_type from fv_ccr_file_temp WHERE rownum=1;
673: ELSE
674: retcode := -1;

Line 672: SELECT extract_code into l_extract_type from fv_ccr_file_temp WHERE rownum=1;

668:
669: IF p_status ='Warning' THEN
670: SELECT count(1) into dummy from fv_ccr_file_temp;
671: IF dummy >=1 THEN
672: SELECT extract_code into l_extract_type from fv_ccr_file_temp WHERE rownum=1;
673: ELSE
674: retcode := -1;
675: l_errbuf := 'Not even a single row was processed in Loader. Please verify';
676: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);

Line 1193: FROM fv_ccr_file_temp fcft

1189: ,fcft.DOMESTIC_ULT_RECORD_DATE
1190: ,fcft.ALT_CERTIFIER_FAX
1191: ,fcft.ALT_CERTIFIER_EMAIL
1192:
1193: FROM fv_ccr_file_temp fcft
1194: order by rowid;
1195: ELSE
1196: l_errbuf := 'Copying info - Standalone / insert as N';
1197: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);

Line 1671: FROM fv_ccr_file_temp fcft

1667: ,fcft.DOMESTIC_ULT_RECORD_DATE
1668: ,fcft.ALT_CERTIFIER_FAX
1669: ,fcft.ALT_CERTIFIER_EMAIL
1670:
1671: FROM fv_ccr_file_temp fcft
1672: WHERE exists ( select 1 from fv_ccr_vendors fcv
1673: where fcft.duns = fcv.duns)
1674: order by rowid;
1675:

Line 2158: FROM fv_ccr_file_temp fcft

2154: ,fcft.DOMESTIC_ULT_PHONE
2155: ,fcft.DOMESTIC_ULT_RECORD_DATE
2156: ,fcft.ALT_CERTIFIER_FAX
2157: ,fcft.ALT_CERTIFIER_EMAIL
2158: FROM fv_ccr_file_temp fcft
2159: WHERE ( (p_xml_import = 'N' AND exists ( select 1 from fv_ccr_vendors fcv
2160: where fcft.duns = fcv.duns
2161: and fcv.ccr_status ='N'))
2162: OR p_xml_import='Y')

Line 2636: FROM fv_ccr_file_temp fcft

2632: ,DOMESTIC_ULT_COUNTRY
2633: ,DOMESTIC_ULT_STATE
2634: ,DOMESTIC_ULT_PHONE
2635: ,DOMESTIC_ULT_RECORD_DATE
2636: FROM fv_ccr_file_temp fcft
2637: WHERE fcft.duns = substr(p_duns, 1, 9)
2638: order by rowid;
2639:
2640:

Line 4894: delete from fv_ccr_file_temp;

4890: end if;
4891:
4892:
4893: -- purge the temporary tables
4894: delete from fv_ccr_file_temp;
4895: delete from fv_ccr_process_gt;
4896: delete from fv_ccr_process_report ;
4897: commit;
4898: