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_HR_MVMNT_TYP_M_C dependencies on EDW_LOG

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

40: EDW_HR_MVMNT_TYP_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
41: END IF;
42:
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_MVMNT_TYP_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
47: edw_log.put_line(' ');
48:

Line 47: edw_log.put_line(' ');

43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_MVMNT_TYP_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
47: edw_log.put_line(' ');
48:
49: -- -----------------------------------------------------------------------------
50: -- Start of Collection , Developer Customizable Section
51: -- -----------------------------------------------------------------------------

Line 53: edw_log.put_line(' ');

49: -- -----------------------------------------------------------------------------
50: -- Start of Collection , Developer Customizable Section
51: -- -----------------------------------------------------------------------------
52:
53: edw_log.put_line(' ');
54: edw_log.put_line('Pushing data');
55:
56: l_temp_date := sysdate;
57:

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

50: -- Start of Collection , Developer Customizable Section
51: -- -----------------------------------------------------------------------------
52:
53: edw_log.put_line(' ');
54: edw_log.put_line('Pushing data');
55:
56: l_temp_date := sysdate;
57:
58:

Line 76: edw_log.put_line('Total rows inserted : '||g_row_count);

72:
73:
74: l_duration := sysdate - l_temp_date;
75:
76: edw_log.put_line('Total rows inserted : '||g_row_count);
77: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
78: edw_log.put_line(' ');
79: -- ---------------------------------------------------------------------------
80: -- END OF Collection , Developer Customizable Section

Line 77: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

73:
74: l_duration := sysdate - l_temp_date;
75:
76: edw_log.put_line('Total rows inserted : '||g_row_count);
77: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
78: edw_log.put_line(' ');
79: -- ---------------------------------------------------------------------------
80: -- END OF Collection , Developer Customizable Section
81: -- ---------------------------------------------------------------------------

Line 78: edw_log.put_line(' ');

74: l_duration := sysdate - l_temp_date;
75:
76: edw_log.put_line('Total rows inserted : '||g_row_count);
77: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
78: edw_log.put_line(' ');
79: -- ---------------------------------------------------------------------------
80: -- END OF Collection , Developer Customizable Section
81: -- ---------------------------------------------------------------------------
82: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2 );

Line 102: edw_log.put_line('Starting Push_EDW_HR_MVMT_MVMNTS_LSTG');

98: l_date1 DATE;
99: l_date2 DATE;
100: l_rows_inserted NUMBER :=0;
101: BEGIN
102: edw_log.put_line('Starting Push_EDW_HR_MVMT_MVMNTS_LSTG');
103: l_date1 := p_from_date;
104: l_date2 := p_to_date;
105: Insert Into
106: EDW_HR_MVMT_MVMNTS_LSTG@EDW_APPS_TO_WH(

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

145:
146:
147: l_rows_inserted := sql%rowcount;
148: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
149: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
150: ' rows into the staging table');
151: edw_log.put_line('Commiting records for EDW_HR_MVMT_MVMNTS_LSTG');
152: commit;
153:

Line 151: edw_log.put_line('Commiting records for EDW_HR_MVMT_MVMNTS_LSTG');

147: l_rows_inserted := sql%rowcount;
148: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
149: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
150: ' rows into the staging table');
151: edw_log.put_line('Commiting records for EDW_HR_MVMT_MVMNTS_LSTG');
152: commit;
153:
154: edw_log.put_line('Completed Push_EDW_HR_MVMT_MVMNTS_LSTG');
155: Exception When others then

Line 154: edw_log.put_line('Completed Push_EDW_HR_MVMT_MVMNTS_LSTG');

150: ' rows into the staging table');
151: edw_log.put_line('Commiting records for EDW_HR_MVMT_MVMNTS_LSTG');
152: commit;
153:
154: edw_log.put_line('Completed Push_EDW_HR_MVMT_MVMNTS_LSTG');
155: Exception When others then
156: raise;
157: commit;
158: END;

Line 166: edw_log.put_line('Starting Push_EDW_HR_MVMT_GAIN_1_LSTG');

162: l_date1 DATE;
163: l_date2 DATE;
164: l_rows_inserted NUMBER :=0;
165: BEGIN
166: edw_log.put_line('Starting Push_EDW_HR_MVMT_GAIN_1_LSTG');
167: l_date1 := p_from_date;
168: l_date2 := p_to_date;
169: Insert Into
170: EDW_HR_MVMT_GAIN_1_LSTG@EDW_APPS_TO_WH(

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

205:
206:
207: l_rows_inserted := sql%rowcount;
208: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
209: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
210: ' rows into the staging table');
211: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_1_LSTG');
212: commit;
213:

Line 211: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_1_LSTG');

207: l_rows_inserted := sql%rowcount;
208: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
209: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
210: ' rows into the staging table');
211: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_1_LSTG');
212: commit;
213:
214: edw_log.put_line('Completed Push_EDW_HR_MVMT_GAIN_1_LSTG');
215: Exception When others then

Line 214: edw_log.put_line('Completed Push_EDW_HR_MVMT_GAIN_1_LSTG');

210: ' rows into the staging table');
211: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_1_LSTG');
212: commit;
213:
214: edw_log.put_line('Completed Push_EDW_HR_MVMT_GAIN_1_LSTG');
215: Exception When others then
216: raise;
217: commit;
218: END;

Line 226: edw_log.put_line('Starting Push_EDW_HR_MVMT_LOSS_1_LSTG');

222: l_date1 DATE;
223: l_date2 DATE;
224: l_rows_inserted NUMBER :=0;
225: BEGIN
226: edw_log.put_line('Starting Push_EDW_HR_MVMT_LOSS_1_LSTG');
227: l_date1 := p_from_date;
228: l_date2 := p_to_date;
229: Insert Into
230: EDW_HR_MVMT_LOSS_1_LSTG@EDW_APPS_TO_WH(

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

265:
266:
267: l_rows_inserted := sql%rowcount;
268: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
269: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
270: ' rows into the staging table');
271: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_1_LSTG');
272: commit;
273:

Line 271: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_1_LSTG');

267: l_rows_inserted := sql%rowcount;
268: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
269: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
270: ' rows into the staging table');
271: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_1_LSTG');
272: commit;
273:
274: edw_log.put_line('Completed Push_EDW_HR_MVMT_LOSS_1_LSTG');
275: Exception When others then

Line 274: edw_log.put_line('Completed Push_EDW_HR_MVMT_LOSS_1_LSTG');

270: ' rows into the staging table');
271: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_1_LSTG');
272: commit;
273:
274: edw_log.put_line('Completed Push_EDW_HR_MVMT_LOSS_1_LSTG');
275: Exception When others then
276: raise;
277: commit;
278: END;

Line 286: edw_log.put_line('Starting Push_EDW_HR_MVMT_RCTMNT_1_LSTG');

282: l_date1 DATE;
283: l_date2 DATE;
284: l_rows_inserted NUMBER :=0;
285: BEGIN
286: edw_log.put_line('Starting Push_EDW_HR_MVMT_RCTMNT_1_LSTG');
287: l_date1 := p_from_date;
288: l_date2 := p_to_date;
289: Insert Into
290: EDW_HR_MVMT_RCTMNT_1_LSTG@EDW_APPS_TO_WH(

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

325:
326:
327: l_rows_inserted := sql%rowcount;
328: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
329: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
330: ' rows into the staging table');
331: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_1_LSTG');
332: commit;
333:

Line 331: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_1_LSTG');

327: l_rows_inserted := sql%rowcount;
328: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
329: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
330: ' rows into the staging table');
331: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_1_LSTG');
332: commit;
333:
334: edw_log.put_line('Completed Push_EDW_HR_MVMT_RCTMNT_1_LSTG');
335: Exception When others then

Line 334: edw_log.put_line('Completed Push_EDW_HR_MVMT_RCTMNT_1_LSTG');

330: ' rows into the staging table');
331: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_1_LSTG');
332: commit;
333:
334: edw_log.put_line('Completed Push_EDW_HR_MVMT_RCTMNT_1_LSTG');
335: Exception When others then
336: raise;
337: commit;
338: END;

Line 346: edw_log.put_line('Starting Push_EDW_HR_MVMT_SPRTN_1_LSTG');

342: l_date1 DATE;
343: l_date2 DATE;
344: l_rows_inserted NUMBER :=0;
345: BEGIN
346: edw_log.put_line('Starting Push_EDW_HR_MVMT_SPRTN_1_LSTG');
347: l_date1 := p_from_date;
348: l_date2 := p_to_date;
349: Insert Into
350: EDW_HR_MVMT_SPRTN_1_LSTG@EDW_APPS_TO_WH(

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

385:
386:
387: l_rows_inserted := sql%rowcount;
388: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
389: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
390: ' rows into the staging table');
391: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_1_LSTG');
392: commit;
393:

Line 391: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_1_LSTG');

387: l_rows_inserted := sql%rowcount;
388: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
389: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
390: ' rows into the staging table');
391: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_1_LSTG');
392: commit;
393:
394: edw_log.put_line('Completed Push_EDW_HR_MVMT_SPRTN_1_LSTG');
395: Exception When others then

Line 394: edw_log.put_line('Completed Push_EDW_HR_MVMT_SPRTN_1_LSTG');

390: ' rows into the staging table');
391: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_1_LSTG');
392: commit;
393:
394: edw_log.put_line('Completed Push_EDW_HR_MVMT_SPRTN_1_LSTG');
395: Exception When others then
396: raise;
397: commit;
398: END;

Line 406: edw_log.put_line('Starting Push_EDW_HR_MVMT_GAIN_2_LSTG');

402: l_date1 DATE;
403: l_date2 DATE;
404: l_rows_inserted NUMBER :=0;
405: BEGIN
406: edw_log.put_line('Starting Push_EDW_HR_MVMT_GAIN_2_LSTG');
407: l_date1 := p_from_date;
408: l_date2 := p_to_date;
409: Insert Into
410: EDW_HR_MVMT_GAIN_2_LSTG@EDW_APPS_TO_WH(

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

445:
446:
447: l_rows_inserted := sql%rowcount;
448: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
449: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
450: ' rows into the staging table');
451: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_2_LSTG');
452: commit;
453:

Line 451: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_2_LSTG');

447: l_rows_inserted := sql%rowcount;
448: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
449: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
450: ' rows into the staging table');
451: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_2_LSTG');
452: commit;
453:
454: edw_log.put_line('Completed Push_EDW_HR_MVMT_GAIN_2_LSTG');
455: Exception When others then

Line 454: edw_log.put_line('Completed Push_EDW_HR_MVMT_GAIN_2_LSTG');

450: ' rows into the staging table');
451: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_2_LSTG');
452: commit;
453:
454: edw_log.put_line('Completed Push_EDW_HR_MVMT_GAIN_2_LSTG');
455: Exception When others then
456: raise;
457: commit;
458: END;

Line 466: edw_log.put_line('Starting Push_EDW_HR_MVMT_LOSS_2_LSTG');

462: l_date1 DATE;
463: l_date2 DATE;
464: l_rows_inserted NUMBER :=0;
465: BEGIN
466: edw_log.put_line('Starting Push_EDW_HR_MVMT_LOSS_2_LSTG');
467: l_date1 := p_from_date;
468: l_date2 := p_to_date;
469: Insert Into
470: EDW_HR_MVMT_LOSS_2_LSTG@EDW_APPS_TO_WH(

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

505:
506:
507: l_rows_inserted := sql%rowcount;
508: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
509: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
510: ' rows into the staging table');
511: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_2_LSTG');
512: commit;
513:

Line 511: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_2_LSTG');

507: l_rows_inserted := sql%rowcount;
508: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
509: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
510: ' rows into the staging table');
511: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_2_LSTG');
512: commit;
513:
514: edw_log.put_line('Completed Push_EDW_HR_MVMT_LOSS_2_LSTG');
515: Exception When others then

Line 514: edw_log.put_line('Completed Push_EDW_HR_MVMT_LOSS_2_LSTG');

510: ' rows into the staging table');
511: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_2_LSTG');
512: commit;
513:
514: edw_log.put_line('Completed Push_EDW_HR_MVMT_LOSS_2_LSTG');
515: Exception When others then
516: raise;
517: commit;
518: END;

Line 526: edw_log.put_line('Starting Push_EDW_HR_MVMT_RCTMNT_2_LSTG');

522: l_date1 DATE;
523: l_date2 DATE;
524: l_rows_inserted NUMBER :=0;
525: BEGIN
526: edw_log.put_line('Starting Push_EDW_HR_MVMT_RCTMNT_2_LSTG');
527: l_date1 := p_from_date;
528: l_date2 := p_to_date;
529: Insert Into
530: EDW_HR_MVMT_RCTMNT_2_LSTG@EDW_APPS_TO_WH(

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

565:
566:
567: l_rows_inserted := sql%rowcount;
568: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
569: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
570: ' rows into the staging table');
571: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_2_LSTG');
572: commit;
573:

Line 571: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_2_LSTG');

567: l_rows_inserted := sql%rowcount;
568: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
569: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
570: ' rows into the staging table');
571: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_2_LSTG');
572: commit;
573:
574: edw_log.put_line('Completed Push_EDW_HR_MVMT_RCTMNT_2_LSTG');
575: Exception When others then

Line 574: edw_log.put_line('Completed Push_EDW_HR_MVMT_RCTMNT_2_LSTG');

570: ' rows into the staging table');
571: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_2_LSTG');
572: commit;
573:
574: edw_log.put_line('Completed Push_EDW_HR_MVMT_RCTMNT_2_LSTG');
575: Exception When others then
576: raise;
577: commit;
578: END;

Line 586: edw_log.put_line('Starting Push_EDW_HR_MVMT_SPRTN_2_LSTG');

582: l_date1 DATE;
583: l_date2 DATE;
584: l_rows_inserted NUMBER :=0;
585: BEGIN
586: edw_log.put_line('Starting Push_EDW_HR_MVMT_SPRTN_2_LSTG');
587: l_date1 := p_from_date;
588: l_date2 := p_to_date;
589: Insert Into
590: EDW_HR_MVMT_SPRTN_2_LSTG@EDW_APPS_TO_WH(

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

625:
626:
627: l_rows_inserted := sql%rowcount;
628: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
629: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
630: ' rows into the staging table');
631: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_2_LSTG');
632: commit;
633:

Line 631: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_2_LSTG');

627: l_rows_inserted := sql%rowcount;
628: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
629: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
630: ' rows into the staging table');
631: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_2_LSTG');
632: commit;
633:
634: edw_log.put_line('Completed Push_EDW_HR_MVMT_SPRTN_2_LSTG');
635: Exception When others then

Line 634: edw_log.put_line('Completed Push_EDW_HR_MVMT_SPRTN_2_LSTG');

630: ' rows into the staging table');
631: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_2_LSTG');
632: commit;
633:
634: edw_log.put_line('Completed Push_EDW_HR_MVMT_SPRTN_2_LSTG');
635: Exception When others then
636: raise;
637: commit;
638: END;

Line 646: edw_log.put_line('Starting Push_EDW_HR_MVMT_GAIN_3_LSTG');

642: l_date1 DATE;
643: l_date2 DATE;
644: l_rows_inserted NUMBER :=0;
645: BEGIN
646: edw_log.put_line('Starting Push_EDW_HR_MVMT_GAIN_3_LSTG');
647: l_date1 := p_from_date;
648: l_date2 := p_to_date;
649: Insert Into
650: EDW_HR_MVMT_GAIN_3_LSTG@EDW_APPS_TO_WH(

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

685:
686:
687: l_rows_inserted := sql%rowcount;
688: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
689: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
690: ' rows into the staging table');
691: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_3_LSTG');
692: commit;
693:

Line 691: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_3_LSTG');

687: l_rows_inserted := sql%rowcount;
688: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
689: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
690: ' rows into the staging table');
691: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_3_LSTG');
692: commit;
693:
694: edw_log.put_line('Completed Push_EDW_HR_MVMT_GAIN_3_LSTG');
695: Exception When others then

Line 694: edw_log.put_line('Completed Push_EDW_HR_MVMT_GAIN_3_LSTG');

690: ' rows into the staging table');
691: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_3_LSTG');
692: commit;
693:
694: edw_log.put_line('Completed Push_EDW_HR_MVMT_GAIN_3_LSTG');
695: Exception When others then
696: raise;
697: commit;
698: END;

Line 706: edw_log.put_line('Starting Push_EDW_HR_MVMT_LOSS_3_LSTG');

702: l_date1 DATE;
703: l_date2 DATE;
704: l_rows_inserted NUMBER :=0;
705: BEGIN
706: edw_log.put_line('Starting Push_EDW_HR_MVMT_LOSS_3_LSTG');
707: l_date1 := p_from_date;
708: l_date2 := p_to_date;
709: Insert Into
710: EDW_HR_MVMT_LOSS_3_LSTG@EDW_APPS_TO_WH(

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

745:
746:
747: l_rows_inserted := sql%rowcount;
748: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
749: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
750: ' rows into the staging table');
751: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_3_LSTG');
752: commit;
753:

Line 751: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_3_LSTG');

747: l_rows_inserted := sql%rowcount;
748: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
749: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
750: ' rows into the staging table');
751: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_3_LSTG');
752: commit;
753:
754: edw_log.put_line('Completed Push_EDW_HR_MVMT_LOSS_3_LSTG');
755: Exception When others then

Line 754: edw_log.put_line('Completed Push_EDW_HR_MVMT_LOSS_3_LSTG');

750: ' rows into the staging table');
751: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_3_LSTG');
752: commit;
753:
754: edw_log.put_line('Completed Push_EDW_HR_MVMT_LOSS_3_LSTG');
755: Exception When others then
756: raise;
757: commit;
758: END;

Line 766: edw_log.put_line('Starting Push_EDW_HR_MVMT_RCTMNT_3_LSTG');

762: l_date1 DATE;
763: l_date2 DATE;
764: l_rows_inserted NUMBER :=0;
765: BEGIN
766: edw_log.put_line('Starting Push_EDW_HR_MVMT_RCTMNT_3_LSTG');
767: l_date1 := p_from_date;
768: l_date2 := p_to_date;
769: Insert Into
770: EDW_HR_MVMT_RCTMNT_3_LSTG@EDW_APPS_TO_WH(

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

805:
806:
807: l_rows_inserted := sql%rowcount;
808: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
809: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
810: ' rows into the staging table');
811: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_3_LSTG');
812: commit;
813:

Line 811: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_3_LSTG');

807: l_rows_inserted := sql%rowcount;
808: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
809: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
810: ' rows into the staging table');
811: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_3_LSTG');
812: commit;
813:
814: edw_log.put_line('Completed Push_EDW_HR_MVMT_RCTMNT_3_LSTG');
815: Exception When others then

Line 814: edw_log.put_line('Completed Push_EDW_HR_MVMT_RCTMNT_3_LSTG');

810: ' rows into the staging table');
811: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_3_LSTG');
812: commit;
813:
814: edw_log.put_line('Completed Push_EDW_HR_MVMT_RCTMNT_3_LSTG');
815: Exception When others then
816: raise;
817: commit;
818: END;

Line 826: edw_log.put_line('Starting Push_EDW_HR_MVMT_SPRTN_3_LSTG');

822: l_date1 DATE;
823: l_date2 DATE;
824: l_rows_inserted NUMBER :=0;
825: BEGIN
826: edw_log.put_line('Starting Push_EDW_HR_MVMT_SPRTN_3_LSTG');
827: l_date1 := p_from_date;
828: l_date2 := p_to_date;
829: Insert Into
830: EDW_HR_MVMT_SPRTN_3_LSTG@EDW_APPS_TO_WH(

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

865:
866:
867: l_rows_inserted := sql%rowcount;
868: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
869: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
870: ' rows into the staging table');
871: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_3_LSTG');
872: commit;
873:

Line 871: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_3_LSTG');

867: l_rows_inserted := sql%rowcount;
868: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
869: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
870: ' rows into the staging table');
871: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_3_LSTG');
872: commit;
873:
874: edw_log.put_line('Completed Push_EDW_HR_MVMT_SPRTN_3_LSTG');
875: Exception When others then

Line 874: edw_log.put_line('Completed Push_EDW_HR_MVMT_SPRTN_3_LSTG');

870: ' rows into the staging table');
871: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_3_LSTG');
872: commit;
873:
874: edw_log.put_line('Completed Push_EDW_HR_MVMT_SPRTN_3_LSTG');
875: Exception When others then
876: raise;
877: commit;
878: END;