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.BIM_CAMP_COLLECTION dependencies on AMS_UTILITY_PVT

Line 296: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT INSERT START');

292: l_fiscal_year_start := bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
293: l_pre_fiscal_roll_year_start := bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);
294: -- EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_r_camp_collection';
295: /* START OF THE INCREMENT DATA INSERT */
296: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT INSERT START');
297: INSERT INTO /*+ append parallel(i,5) */
298: bim_r_camp_collection i
299: (campaign_area1,
300: campaign_area2,

Line 1210: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT INSERT END');

1206:
1207: --commit;
1208:
1209: /* END OF THE INCREMENT DATA INSERT */
1210: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT INSERT END');
1211: /* START OF THE MONTH, QUARTER ,YEAR DATA INSERT */
1212: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: Q/M/Y INSERT START');
1213: INSERT INTO /*+ append parallel(i,5) */
1214: bim_r_camp_collection i

Line 1212: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: Q/M/Y INSERT START');

1208:
1209: /* END OF THE INCREMENT DATA INSERT */
1210: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT INSERT END');
1211: /* START OF THE MONTH, QUARTER ,YEAR DATA INSERT */
1212: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: Q/M/Y INSERT START');
1213: INSERT INTO /*+ append parallel(i,5) */
1214: bim_r_camp_collection i
1215: (schedule_area2,
1216: schedule_country,

Line 2830: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: Q/M/Y COUNT UPDATE END');

2826:
2827:
2828:
2829: ---------union all admin end
2830: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: Q/M/Y COUNT UPDATE END');
2831: /* END OF THE MONTH, QUARTER ,YEAR DATA INSERT */
2832: EXCEPTION
2833: WHEN OTHERS
2834: THEN

Line 2835: ams_utility_pvt.write_conc_log( 'BIM_CAMP_COLLECTION:IN OTHERS EXCEPTION '

2831: /* END OF THE MONTH, QUARTER ,YEAR DATA INSERT */
2832: EXCEPTION
2833: WHEN OTHERS
2834: THEN
2835: ams_utility_pvt.write_conc_log( 'BIM_CAMP_COLLECTION:IN OTHERS EXCEPTION '
2836: || SQLERRM(SQLCODE));
2837: --dbms_utility.FORMAT_ERROR_STACK );
2838: END get_increment_mqy_data;
2839: -------------------------------------------------------------------------------------------

Line 2897: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT FIRST INSERT START');

2893: l_pre_fiscal_roll_year_start :=bim_set_of_books.get_pre_fiscal_roll_year_start(l_SYSDATE - 1,l_org_id);
2894: --commit;
2895: --EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_r_camp_collection';
2896: /* START OF THE INCREMENT DATA FIRST INSERT */
2897: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT FIRST INSERT START');
2898: INSERT INTO /*+ append parallel(i,5) */
2899: bim_r_camp_collection i
2900: (campaign_area1,
2901: campaign_area2,

Line 5826: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT FIRST INSERT END');

5822:
5823: /* END OF THE INCREMENT DATA FIRST INSERT */
5824:
5825: --commit;
5826: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT FIRST INSERT END');
5827: /* START OF THE INCREMENT DATA SECOND INSERT */
5828: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT SECOND INSERT START');
5829:
5830:

Line 5828: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT SECOND INSERT START');

5824:
5825: --commit;
5826: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT FIRST INSERT END');
5827: /* START OF THE INCREMENT DATA SECOND INSERT */
5828: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: INCREMENT SECOND INSERT START');
5829:
5830:
5831: INSERT INTO /*+ append parallel(i,5) */
5832: bim_r_camp_collection i

Line 8029: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT MONTH INSERT START');

8025: --commit;
8026:
8027: /* END OF THE INCREMENT DATA SECOND INSERT */
8028: /* START OF THE MONTH, QUARTER ,YEAR DATA INSERT */
8029: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT MONTH INSERT START');
8030: INSERT INTO /*+ append parallel(i,5) */
8031: bim_r_camp_collection i
8032: (campaign_area1,
8033: campaign_area2,

Line 8673: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT MONTH INSERT END');

8669:
8670: --commit;
8671:
8672:
8673: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT MONTH INSERT END');
8674: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT QTR INSERT START');
8675: INSERT INTO /*+ append parallel(i,5) */
8676: bim_r_camp_collection i
8677: (campaign_area1,

Line 8674: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT QTR INSERT START');

8670: --commit;
8671:
8672:
8673: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT MONTH INSERT END');
8674: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT QTR INSERT START');
8675: INSERT INTO /*+ append parallel(i,5) */
8676: bim_r_camp_collection i
8677: (campaign_area1,
8678: campaign_area2,

Line 9325: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT QTR INSERT END');

9321:
9322: --commit;
9323:
9324:
9325: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT QTR INSERT END');
9326: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT YEAR INSERT START');
9327: INSERT INTO /*+ append parallel(i,5) */
9328: bim_r_camp_collection i
9329: (campaign_area1,

Line 9326: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT YEAR INSERT START');

9322: --commit;
9323:
9324:
9325: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT QTR INSERT END');
9326: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT YEAR INSERT START');
9327: INSERT INTO /*+ append parallel(i,5) */
9328: bim_r_camp_collection i
9329: (campaign_area1,
9330: campaign_area2,

Line 9971: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT QTR INSERT END');

9967:
9968: --commit;
9969:
9970:
9971: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT QTR INSERT END');
9972: ---------------------------------------------------------------------------------------
9973: -- START OF CAMP SUMMARY DATA
9974: --------------------------------------------------------------------------------------
9975: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP MONTH INSERT START');

Line 9975: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP MONTH INSERT START');

9971: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY ACT QTR INSERT END');
9972: ---------------------------------------------------------------------------------------
9973: -- START OF CAMP SUMMARY DATA
9974: --------------------------------------------------------------------------------------
9975: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP MONTH INSERT START');
9976: INSERT INTO /*+ append parallel(i,5) */
9977: bim_r_camp_collection i
9978: (campaign_area1,
9979: campaign_area2,

Line 10310: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP QTR INSERT START');

10306:
10307:
10308: --commit;
10309:
10310: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP QTR INSERT START');
10311: INSERT INTO /*+ append parallel(i,5) */
10312: bim_r_camp_collection i
10313: (campaign_area1,
10314: campaign_area2,

Line 10643: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP QTR INSERT END');

10639:
10640:
10641: --commit;
10642:
10643: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP QTR INSERT END');
10644: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP YEAR INSERT START');
10645: INSERT INTO /*+ append parallel(i,5) */
10646: bim_r_camp_collection i
10647: (campaign_area1,

Line 10644: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP YEAR INSERT START');

10640:
10641: --commit;
10642:
10643: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP QTR INSERT END');
10644: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP YEAR INSERT START');
10645: INSERT INTO /*+ append parallel(i,5) */
10646: bim_r_camp_collection i
10647: (campaign_area1,
10648: campaign_area2,

Line 10973: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP QTR INSERT END');

10969:
10970:
10971: --commit;
10972:
10973: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP QTR INSERT END');
10974: EXCEPTION
10975: WHEN OTHERS
10976: THEN
10977: ams_utility_pvt.write_conc_log( 'BIM_CAMP_COLLECTION:IN OTHERS EXCEPTION '|| SQLERRM(SQLCODE));

Line 10977: ams_utility_pvt.write_conc_log( 'BIM_CAMP_COLLECTION:IN OTHERS EXCEPTION '|| SQLERRM(SQLCODE));

10973: ams_utility_pvt.write_conc_log('BIM_CAMP_COLLECTION: SUMMARY CAMP QTR INSERT END');
10974: EXCEPTION
10975: WHEN OTHERS
10976: THEN
10977: ams_utility_pvt.write_conc_log( 'BIM_CAMP_COLLECTION:IN OTHERS EXCEPTION '|| SQLERRM(SQLCODE));
10978: END get_summary_data;
10979: END bim_camp_collection;