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_MTL_INVENTORY_LOC_M_C dependencies on EDW_MTL_INVENTORY_LOC_M_C

Line 1: Package Body EDW_MTL_INVENTORY_LOC_M_C AS

1: Package Body EDW_MTL_INVENTORY_LOC_M_C AS
2: /* $Header: OPIINVDB.pls 120.1 2005/06/08 01:10:03 appldev $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;

Line 30: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -

26: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
27: Return;
28: END IF;
29: IF (p_from_date IS NULL) THEN
30: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
31: EDW_COLLECTION_UTIL.g_offset;
32: ELSE
33: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
34: END IF;

Line 33: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');

29: IF (p_from_date IS NULL) THEN
30: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
31: EDW_COLLECTION_UTIL.g_offset;
32: ELSE
33: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
34: END IF;
35: IF (p_to_date IS NULL) THEN
36: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
37: ELSE

Line 36: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

32: ELSE
33: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
34: END IF;
35: IF (p_to_date IS NULL) THEN
36: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
37: ELSE
38: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
39: END IF;
40: edw_log.put_line( 'The collection range is from '||

Line 38: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');

34: END IF;
35: IF (p_to_date IS NULL) THEN
36: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
37: ELSE
38: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
39: END IF;
40: edw_log.put_line( 'The collection range is from '||
41: to_char(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
42: to_char(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

Line 41: to_char(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||

37: ELSE
38: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
39: END IF;
40: edw_log.put_line( 'The collection range is from '||
41: to_char(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
42: to_char(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
43: edw_log.put_line(' ');
44: -- -----------------------------------------------------------------------------
45: -- Start of Collection , Developer Customizable Section

Line 42: to_char(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

38: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
39: END IF;
40: edw_log.put_line( 'The collection range is from '||
41: to_char(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
42: to_char(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
43: edw_log.put_line(' ');
44: -- -----------------------------------------------------------------------------
45: -- Start of Collection , Developer Customizable Section
46: -- -----------------------------------------------------------------------------

Line 50: Push_EDW_MTL_ILDM_LOCATOR_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);

46: -- -----------------------------------------------------------------------------
47: edw_log.put_line(' ');
48: edw_log.put_line('Pushing data');
49: l_temp_date := sysdate;
50: Push_EDW_MTL_ILDM_LOCATOR_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
51: Push_EDW_MTL_ILDM_SUB_INV_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
52: Push_EDW_MTL_ILDM_PLANT_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
53: Push_EDW_MTL_ILDM_OU_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
54: Push_EDW_MTL_ILDM_PORG_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);

Line 51: Push_EDW_MTL_ILDM_SUB_INV_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);

47: edw_log.put_line(' ');
48: edw_log.put_line('Pushing data');
49: l_temp_date := sysdate;
50: Push_EDW_MTL_ILDM_LOCATOR_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
51: Push_EDW_MTL_ILDM_SUB_INV_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
52: Push_EDW_MTL_ILDM_PLANT_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
53: Push_EDW_MTL_ILDM_OU_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
54: Push_EDW_MTL_ILDM_PORG_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
55: Push_EDW_MTL_ILDM_PCMP_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);

Line 52: Push_EDW_MTL_ILDM_PLANT_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);

48: edw_log.put_line('Pushing data');
49: l_temp_date := sysdate;
50: Push_EDW_MTL_ILDM_LOCATOR_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
51: Push_EDW_MTL_ILDM_SUB_INV_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
52: Push_EDW_MTL_ILDM_PLANT_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
53: Push_EDW_MTL_ILDM_OU_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
54: Push_EDW_MTL_ILDM_PORG_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
55: Push_EDW_MTL_ILDM_PCMP_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
56: l_duration := sysdate - l_temp_date;

Line 53: Push_EDW_MTL_ILDM_OU_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);

49: l_temp_date := sysdate;
50: Push_EDW_MTL_ILDM_LOCATOR_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
51: Push_EDW_MTL_ILDM_SUB_INV_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
52: Push_EDW_MTL_ILDM_PLANT_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
53: Push_EDW_MTL_ILDM_OU_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
54: Push_EDW_MTL_ILDM_PORG_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
55: Push_EDW_MTL_ILDM_PCMP_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
56: l_duration := sysdate - l_temp_date;
57: edw_log.put_line('Total rows inserted : '||g_row_count);

Line 54: Push_EDW_MTL_ILDM_PORG_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);

50: Push_EDW_MTL_ILDM_LOCATOR_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
51: Push_EDW_MTL_ILDM_SUB_INV_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
52: Push_EDW_MTL_ILDM_PLANT_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
53: Push_EDW_MTL_ILDM_OU_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
54: Push_EDW_MTL_ILDM_PORG_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
55: Push_EDW_MTL_ILDM_PCMP_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
56: l_duration := sysdate - l_temp_date;
57: edw_log.put_line('Total rows inserted : '||g_row_count);
58: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

Line 55: Push_EDW_MTL_ILDM_PCMP_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);

51: Push_EDW_MTL_ILDM_SUB_INV_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
52: Push_EDW_MTL_ILDM_PLANT_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
53: Push_EDW_MTL_ILDM_OU_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
54: Push_EDW_MTL_ILDM_PORG_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
55: Push_EDW_MTL_ILDM_PCMP_LSTG(EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1, EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
56: l_duration := sysdate - l_temp_date;
57: edw_log.put_line('Total rows inserted : '||g_row_count);
58: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
59: edw_log.put_line(' ');

Line 64: EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,

60: -- ---------------------------------------------------------------------------
61: -- END OF Collection , Developer Customizable Section
62: -- ---------------------------------------------------------------------------
63: EDW_COLLECTION_UTIL.wrapup(TRUE, g_lowest_level_count,
64: EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,
65: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,
66: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
67: commit;
68: Exception When others then

Line 65: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,

61: -- END OF Collection , Developer Customizable Section
62: -- ---------------------------------------------------------------------------
63: EDW_COLLECTION_UTIL.wrapup(TRUE, g_lowest_level_count,
64: EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,
65: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,
66: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
67: commit;
68: Exception When others then
69: Errbuf:=sqlerrm;

Line 66: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);

62: -- ---------------------------------------------------------------------------
63: EDW_COLLECTION_UTIL.wrapup(TRUE, g_lowest_level_count,
64: EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,
65: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,
66: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
67: commit;
68: Exception When others then
69: Errbuf:=sqlerrm;
70: Retcode:=sqlcode;

Line 72: EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg := l_exception_msg;

68: Exception When others then
69: Errbuf:=sqlerrm;
70: Retcode:=sqlcode;
71: l_exception_msg := Retcode || ':' || Errbuf;
72: EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg := l_exception_msg;
73: rollback;
74: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,
75: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,
76: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);

Line 74: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,

70: Retcode:=sqlcode;
71: l_exception_msg := Retcode || ':' || Errbuf;
72: EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg := l_exception_msg;
73: rollback;
74: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,
75: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,
76: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
77: commit;
78: End;

Line 75: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,

71: l_exception_msg := Retcode || ':' || Errbuf;
72: EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg := l_exception_msg;
73: rollback;
74: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,
75: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,
76: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
77: commit;
78: End;
79: Procedure Push_EDW_MTL_ILDM_LOCATOR_LSTG(p_from_date IN date, p_to_date IN DATE) IS

Line 76: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);

72: EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg := l_exception_msg;
73: rollback;
74: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,
75: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,
76: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
77: commit;
78: End;
79: Procedure Push_EDW_MTL_ILDM_LOCATOR_LSTG(p_from_date IN date, p_to_date IN DATE) IS
80: l_date1 DATE;

Line 127: EDW_MTL_INVENTORY_LOC_M_C.g_lowest_level_count := l_rows_inserted;

123: from EDW_MTL_ILDM_LOCATOR_LCV@APPS_TO_APPS
124: where last_update_date between l_date1 and l_date2;
125: l_rows_inserted := sql%rowcount;
126:
127: EDW_MTL_INVENTORY_LOC_M_C.g_lowest_level_count := l_rows_inserted;
128:
129: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
130: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
131: ' rows into the staging table');

Line 129: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;

125: l_rows_inserted := sql%rowcount;
126:
127: EDW_MTL_INVENTORY_LOC_M_C.g_lowest_level_count := l_rows_inserted;
128:
129: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
130: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
131: ' rows into the staging table');
132: edw_log.put_line('Commiting records for EDW_MTL_ILDM_LOCATOR_LSTG');
133: commit;

Line 184: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;

180: 'READY'
181: from EDW_MTL_ILDM_SUB_INV_LCV@APPS_TO_APPS
182: where last_update_date between l_date1 and l_date2;
183: l_rows_inserted := sql%rowcount;
184: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
185: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
186: ' rows into the staging table');
187: edw_log.put_line('Commiting records for EDW_MTL_ILDM_SUB_INV_LSTG');
188: commit;

Line 243: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;

239: 'READY'
240: from EDW_MTL_ILDM_PLANT_LCV@APPS_TO_APPS
241: where last_update_date between l_date1 and l_date2;
242: l_rows_inserted := sql%rowcount;
243: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
244: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
245: ' rows into the staging table');
246: edw_log.put_line('Commiting records for EDW_MTL_ILDM_PLANT_LSTG');
247: commit;

Line 308: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;

304: 'READY'
305: from EDW_MTL_ILDM_OU_LCV@APPS_TO_APPS
306: where last_update_date between l_date1 and l_date2;
307: l_rows_inserted := sql%rowcount;
308: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
309: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
310: ' rows into the staging table');
311: edw_log.put_line('Commiting records for EDW_MTL_ILDM_OU_LSTG');
312: commit;

Line 365: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;

361: 'READY'
362: from EDW_MTL_ILDM_PORG_LCV@APPS_TO_APPS
363: where last_update_date between l_date1 and l_date2;
364: l_rows_inserted := sql%rowcount;
365: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
366: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
367: ' rows into the staging table');
368: edw_log.put_line('Commiting records for EDW_MTL_ILDM_PORG_LSTG');
369: commit;

Line 422: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;

418: 'READY'
419: from EDW_MTL_ILDM_PCMP_LCV@APPS_TO_APPS
420: where last_update_date between l_date1 and l_date2;
421: l_rows_inserted := sql%rowcount;
422: EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
423: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
424: ' rows into the staging table');
425: edw_log.put_line('Commiting records for EDW_MTL_ILDM_PCMP_LSTG');
426: commit;

Line 432: End EDW_MTL_INVENTORY_LOC_M_C;

428: Exception When others then
429: raise;
430: commit;
431: END;
432: End EDW_MTL_INVENTORY_LOC_M_C;