DBA Data[Home] [Help]

APPS.BIM_CAMP_COLLECTION dependencies on BIM_R_CAMP_COLLECTION

Line 294: -- EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_r_camp_collection';

290: l_fiscal_year := bim_set_of_books.get_fiscal_year(l_SYSDATE - 1, l_org_id);
291: l_fiscal_year_end := bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
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

Line 298: bim_r_camp_collection i

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,
301: schedule_area1,
302: schedule_area2,

Line 1214: bim_r_camp_collection i

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,
1217: business_unit_id,
1218: resource_id,

Line 1755: bim_r_camp_collection i

1751: ---------union all admin end
1752: --commit;
1753: -- FOR THE PERIOD TYPE QTR
1754: INSERT INTO /*+ append parallel(i,5) */
1755: bim_r_camp_collection i
1756: (schedule_area2,
1757: schedule_country,
1758: business_unit_id,
1759: resource_id,

Line 2292: bim_r_camp_collection i

2288: ---------union all admin end
2289: --commit;
2290: -- FOR THE PERIOD TYPE YEAR
2291: INSERT INTO /*+ append parallel(i,5) */
2292: bim_r_camp_collection i
2293: (schedule_area2,
2294: schedule_country,
2295: business_unit_id,
2296: resource_id,

Line 2895: --EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_r_camp_collection';

2891: l_fiscal_year_end :=bim_set_of_books.get_fiscal_year_end(l_SYSDATE - 1, l_org_id);
2892: l_fiscal_year_start :=bim_set_of_books.get_fiscal_year_start(l_SYSDATE - 1, l_org_id);
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

Line 2899: bim_r_camp_collection i

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,
2902: schedule_area1,
2903: schedule_area2,

Line 5832: bim_r_camp_collection i

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
5833: (campaign_area1,
5834: campaign_area2,
5835: schedule_area1,
5836: schedule_area2,

Line 8031: bim_r_camp_collection i

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,
8034: schedule_area1,
8035: schedule_area2,

Line 8676: bim_r_camp_collection i

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,
8679: schedule_area1,
8680: schedule_area2,

Line 9328: bim_r_camp_collection i

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,
9331: schedule_area1,
9332: schedule_area2,

Line 9977: bim_r_camp_collection i

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,
9980: schedule_area1,
9981: schedule_area2,

Line 10312: bim_r_camp_collection i

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,
10315: schedule_area1,
10316: schedule_area2,

Line 10646: bim_r_camp_collection i

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,
10649: schedule_area1,
10650: schedule_area2,