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.EDW_BOM_RES_M_C dependencies on EDW_LOG

Line 34: edw_log.put_line( 'The collection range is from '||

30: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
31:
32: l_push_date_range1:= nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
33: l_push_date_range2:= nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: edw_log.put_line( 'The collection range is from '||
35: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
36: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
37: edw_log.put_line(' ');
38: edw_log.put_line('Pushing Data');

Line 37: edw_log.put_line(' ');

33: l_push_date_range2:= nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: edw_log.put_line( 'The collection range is from '||
35: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
36: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
37: edw_log.put_line(' ');
38: edw_log.put_line('Pushing Data');
39:
40: Push_EDW_BRES_PLANT(l_push_date_range1, l_push_date_range2);
41: Push_EDW_BRES_PLANT1(l_push_date_range1, l_push_date_range2);

Line 38: edw_log.put_line('Pushing Data');

34: edw_log.put_line( 'The collection range is from '||
35: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
36: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
37: edw_log.put_line(' ');
38: edw_log.put_line('Pushing Data');
39:
40: Push_EDW_BRES_PLANT(l_push_date_range1, l_push_date_range2);
41: Push_EDW_BRES_PLANT1(l_push_date_range1, l_push_date_range2);
42: Push_EDW_BRES_RESOURCE(l_push_date_range1, l_push_date_range2);

Line 84: edw_log.put_line(' ');

80: l_push_date_range2:=p_to_date;
81:
82: /******************************************/
83:
84: edw_log.put_line(' ');
85: edw_log.put_line('Pushing EDW_BRES_PLANT');
86:
87: Insert Into EDW_BRES_PLANT_LSTG(
88: ALL_FK,

Line 85: edw_log.put_line('Pushing EDW_BRES_PLANT');

81:
82: /******************************************/
83:
84: edw_log.put_line(' ');
85: edw_log.put_line('Pushing EDW_BRES_PLANT');
86:
87: Insert Into EDW_BRES_PLANT_LSTG(
88: ALL_FK,
89: ALL_FK_KEY,

Line 135: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

131: from EDW_BRES_PLANT_LCV
132: where last_update_date between l_push_date_range1 and l_push_date_range2;
133: l_rows_inserted := sql%rowcount;
134:
135: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
136: ' rows into the staging table');
137: edw_log.put_line(' ');
138:
139: -- ---------------------------------------------------------------------------

Line 137: edw_log.put_line(' ');

133: l_rows_inserted := sql%rowcount;
134:
135: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
136: ' rows into the staging table');
137: edw_log.put_line(' ');
138:
139: -- ---------------------------------------------------------------------------
140: -- END OF Collection , Developer Customizable Section
141: -- ---------------------------------------------------------------------------

Line 173: edw_log.put_line(' ');

169: l_push_date_range2:=p_to_date;
170:
171: /******************************************/
172:
173: edw_log.put_line(' ');
174: edw_log.put_line('Pushing EDW_BRES_PLANT1');
175:
176: Insert Into EDW_BRES_PLANT1_LSTG(
177: ALL_FK,

Line 174: edw_log.put_line('Pushing EDW_BRES_PLANT1');

170:
171: /******************************************/
172:
173: edw_log.put_line(' ');
174: edw_log.put_line('Pushing EDW_BRES_PLANT1');
175:
176: Insert Into EDW_BRES_PLANT1_LSTG(
177: ALL_FK,
178: ALL_FK_KEY,

Line 224: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

220: from EDW_BRES_PLANT_LCV
221: where last_update_date between l_push_date_range1 and l_push_date_range2;
222: l_rows_inserted := sql%rowcount;
223:
224: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
225: ' rows into the staging table');
226: edw_log.put_line(' ');
227:
228: -- ---------------------------------------------------------------------------

Line 226: edw_log.put_line(' ');

222: l_rows_inserted := sql%rowcount;
223:
224: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
225: ' rows into the staging table');
226: edw_log.put_line(' ');
227:
228: -- ---------------------------------------------------------------------------
229: -- END OF Collection , Developer Customizable Section
230: -- ---------------------------------------------------------------------------

Line 260: edw_log.put_line(' ');

256:
257: l_push_date_range1:=p_from_date;
258: l_push_date_range2:=p_to_date;
259:
260: edw_log.put_line(' ');
261: edw_log.put_line('Pushing EDW_BRES_RESOURCE');
262:
263: Insert Into EDW_BRES_RESOURCE_LSTG(
264: AVAIL_24_HRS_FLAG,

Line 261: edw_log.put_line('Pushing EDW_BRES_RESOURCE');

257: l_push_date_range1:=p_from_date;
258: l_push_date_range2:=p_to_date;
259:
260: edw_log.put_line(' ');
261: edw_log.put_line('Pushing EDW_BRES_RESOURCE');
262:
263: Insert Into EDW_BRES_RESOURCE_LSTG(
264: AVAIL_24_HRS_FLAG,
265: CREATION_DATE,

Line 327: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

323: from EDW_BRES_RESOURCE_LCV
324: where last_update_date between l_push_date_range1 and l_push_date_range2;
325: l_rows_inserted := sql%rowcount;
326:
327: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
328: ' rows into the staging table');
329: edw_log.put_line(' ');
330:
331: -- ---------------------------------------------------------------------------

Line 329: edw_log.put_line(' ');

325: l_rows_inserted := sql%rowcount;
326:
327: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
328: ' rows into the staging table');
329: edw_log.put_line(' ');
330:
331: -- ---------------------------------------------------------------------------
332: -- END OF Collection , Developer Customizable Section
333: -- ---------------------------------------------------------------------------

Line 362: edw_log.put_line(' ');

358:
359: l_push_date_range1:=p_from_date;
360: l_push_date_range2:=p_to_date;
361:
362: edw_log.put_line(' ');
363: edw_log.put_line('Pushing EDW_BRES_RESGROUP');
364:
365: Insert Into EDW_BRES_RESGROUP_LSTG(
366: ALL_FK,

Line 363: edw_log.put_line('Pushing EDW_BRES_RESGROUP');

359: l_push_date_range1:=p_from_date;
360: l_push_date_range2:=p_to_date;
361:
362: edw_log.put_line(' ');
363: edw_log.put_line('Pushing EDW_BRES_RESGROUP');
364:
365: Insert Into EDW_BRES_RESGROUP_LSTG(
366: ALL_FK,
367: ALL_FK_KEY,

Line 411: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

407: from EDW_BRES_RESGROUP_LCV
408: where last_update_date between l_push_date_range1 and l_push_date_range2;
409: l_rows_inserted := sql%rowcount;
410:
411: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
412: ' rows into the staging table');
413: edw_log.put_line(' ');
414:
415: -- ---------------------------------------------------------------------------

Line 413: edw_log.put_line(' ');

409: l_rows_inserted := sql%rowcount;
410:
411: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
412: ' rows into the staging table');
413: edw_log.put_line(' ');
414:
415: -- ---------------------------------------------------------------------------
416: -- END OF Collection , Developer Customizable Section
417: -- ---------------------------------------------------------------------------

Line 447: edw_log.put_line(' ');

443:
444: l_push_date_range1:=p_from_date;
445: l_push_date_range2:=p_to_date;
446:
447: edw_log.put_line(' ');
448: edw_log.put_line('Pushing EDW_BRES_RESTYPE');
449:
450: Insert Into EDW_BRES_RESTYPE_LSTG(
451: ALL_FK,

Line 448: edw_log.put_line('Pushing EDW_BRES_RESTYPE');

444: l_push_date_range1:=p_from_date;
445: l_push_date_range2:=p_to_date;
446:
447: edw_log.put_line(' ');
448: edw_log.put_line('Pushing EDW_BRES_RESTYPE');
449:
450: Insert Into EDW_BRES_RESTYPE_LSTG(
451: ALL_FK,
452: ALL_FK_KEY,

Line 496: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

492: from EDW_BRES_RESTYPE_LCV
493: where last_update_date between l_push_date_range1 and l_push_date_range2;
494: l_rows_inserted := sql%rowcount;
495:
496: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
497: ' rows into the staging table');
498: edw_log.put_line(' ');
499:
500: -- ---------------------------------------------------------------------------

Line 498: edw_log.put_line(' ');

494: l_rows_inserted := sql%rowcount;
495:
496: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
497: ' rows into the staging table');
498: edw_log.put_line(' ');
499:
500: -- ---------------------------------------------------------------------------
501: -- END OF Collection , Developer Customizable Section
502: -- ---------------------------------------------------------------------------

Line 533: edw_log.put_line(' ');

529:
530: l_push_date_range1:=p_from_date;
531: l_push_date_range2:=p_to_date;
532:
533: edw_log.put_line(' ');
534: edw_log.put_line('Pushing data');
535:
536: Insert Into EDW_BRES_RESCAT_LSTG(
537: CREATION_DATE,

Line 534: edw_log.put_line('Pushing data');

530: l_push_date_range1:=p_from_date;
531: l_push_date_range2:=p_to_date;
532:
533: edw_log.put_line(' ');
534: edw_log.put_line('Pushing data');
535:
536: Insert Into EDW_BRES_RESCAT_LSTG(
537: CREATION_DATE,
538: DESCRIPTION,

Line 586: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

582: from EDW_BRES_RESCAT_LCV
583: where last_update_date between l_push_date_range1 and l_push_date_range2;
584: l_rows_inserted := sql%rowcount;
585:
586: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
587: ' rows into the staging table');
588: edw_log.put_line(' ');
589:
590: -- ---------------------------------------------------------------------------

Line 588: edw_log.put_line(' ');

584: l_rows_inserted := sql%rowcount;
585:
586: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
587: ' rows into the staging table');
588: edw_log.put_line(' ');
589:
590: -- ---------------------------------------------------------------------------
591: -- END OF Collection , Developer Customizable Section
592: -- ---------------------------------------------------------------------------

Line 622: edw_log.put_line(' ');

618:
619: l_push_date_range1:=p_from_date;
620: l_push_date_range2:=p_to_date;
621:
622: edw_log.put_line(' ');
623: edw_log.put_line('Pushing EDW_BRES_PARENT_DEPT');
624:
625: Insert Into EDW_BRES_PARENT_DEPT_LSTG(
626: CREATION_DATE,

Line 623: edw_log.put_line('Pushing EDW_BRES_PARENT_DEPT');

619: l_push_date_range1:=p_from_date;
620: l_push_date_range2:=p_to_date;
621:
622: edw_log.put_line(' ');
623: edw_log.put_line('Pushing EDW_BRES_PARENT_DEPT');
624:
625: Insert Into EDW_BRES_PARENT_DEPT_LSTG(
626: CREATION_DATE,
627: DEPARTMENT_CLASS_FK,

Line 671: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

667: from EDW_BRES_DEPT_LCV
668: where last_update_date between l_push_date_range1 and l_push_date_range2;
669: l_rows_inserted := sql%rowcount;
670:
671: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
672: ' rows into the staging table');
673: edw_log.put_line(' ');
674:
675: -- ---------------------------------------------------------------------------

Line 673: edw_log.put_line(' ');

669: l_rows_inserted := sql%rowcount;
670:
671: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
672: ' rows into the staging table');
673: edw_log.put_line(' ');
674:
675: -- ---------------------------------------------------------------------------
676: -- END OF Collection , Developer Customizable Section
677: -- ---------------------------------------------------------------------------

Line 708: edw_log.put_line(' ');

704:
705: l_push_date_range1:=p_from_date;
706: l_push_date_range2:=p_to_date;
707:
708: edw_log.put_line(' ');
709: edw_log.put_line('Pushing EDW_BRES_DEPT');
710:
711: Insert Into EDW_BRES_DEPT_LSTG(
712: CREATION_DATE,

Line 709: edw_log.put_line('Pushing EDW_BRES_DEPT');

705: l_push_date_range1:=p_from_date;
706: l_push_date_range2:=p_to_date;
707:
708: edw_log.put_line(' ');
709: edw_log.put_line('Pushing EDW_BRES_DEPT');
710:
711: Insert Into EDW_BRES_DEPT_LSTG(
712: CREATION_DATE,
713: DEPARTMENT_CODE,

Line 758: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

754: where last_update_date between l_push_date_range1 and l_push_date_range2;
755:
756: l_rows_inserted := sql%rowcount;
757:
758: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
759: ' rows into the staging table');
760: edw_log.put_line(' ');
761:
762: -- ---------------------------------------------------------------------------

Line 760: edw_log.put_line(' ');

756: l_rows_inserted := sql%rowcount;
757:
758: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
759: ' rows into the staging table');
760: edw_log.put_line(' ');
761:
762: -- ---------------------------------------------------------------------------
763: -- END OF Collection , Developer Customizable Section
764: -- ---------------------------------------------------------------------------

Line 795: edw_log.put_line(' ');

791:
792: l_push_date_range1:=p_from_date;
793: l_push_date_range2:=p_to_date;
794:
795: edw_log.put_line(' ');
796: edw_log.put_line('Pushing EDW_BRES_DEPT_CLASS');
797:
798: Insert Into EDW_BRES_DEPT_CLASS_LSTG(
799: CREATION_DATE,

Line 796: edw_log.put_line('Pushing EDW_BRES_DEPT_CLASS');

792: l_push_date_range1:=p_from_date;
793: l_push_date_range2:=p_to_date;
794:
795: edw_log.put_line(' ');
796: edw_log.put_line('Pushing EDW_BRES_DEPT_CLASS');
797:
798: Insert Into EDW_BRES_DEPT_CLASS_LSTG(
799: CREATION_DATE,
800: DEPARTMENT_CLASS,

Line 845: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

841: where last_update_date between l_push_date_range1 and l_push_date_range2;
842:
843: l_rows_inserted := sql%rowcount;
844:
845: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
846: ' rows into the staging table');
847: edw_log.put_line(' ');
848:
849: -- ---------------------------------------------------------------------------

Line 847: edw_log.put_line(' ');

843: l_rows_inserted := sql%rowcount;
844:
845: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
846: ' rows into the staging table');
847: edw_log.put_line(' ');
848:
849: -- ---------------------------------------------------------------------------
850: -- END OF Collection , Developer Customizable Section
851: -- ---------------------------------------------------------------------------