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_UNSPSC_M_C dependencies on EDW_UNSPSC_M_C

Line 1: Package Body EDW_UNSPSC_M_C AS

1: Package Body EDW_UNSPSC_M_C AS
2: /* $Header: poaphunb.pls 115.16 2004/02/26 13:55:46 apalorka ship $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;

Line 37: EDW_UNSPSC_M_C.g_push_date_range1 := nvl(l_from_date,

33:
34: l_from_date := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
35: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
36:
37: EDW_UNSPSC_M_C.g_push_date_range1 := nvl(l_from_date,
38: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
39: EDW_COLLECTION_UTIL.g_offset);
40:
41: EDW_UNSPSC_M_C.g_push_date_range2 := nvl(l_to_date,

Line 41: EDW_UNSPSC_M_C.g_push_date_range2 := nvl(l_to_date,

37: EDW_UNSPSC_M_C.g_push_date_range1 := nvl(l_from_date,
38: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
39: EDW_COLLECTION_UTIL.g_offset);
40:
41: EDW_UNSPSC_M_C.g_push_date_range2 := nvl(l_to_date,
42: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_UNSPSC_M_C.g_push_date_range1,

Line 45: to_char(EDW_UNSPSC_M_C.g_push_date_range1,

41: EDW_UNSPSC_M_C.g_push_date_range2 := nvl(l_to_date,
42: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_UNSPSC_M_C.g_push_date_range1,
46: 'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_UNSPSC_M_C.g_push_date_range2,
48: 'MM/DD/YYYY HH24:MI:SS'));
49:

Line 47: to_char(EDW_UNSPSC_M_C.g_push_date_range2,

43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_UNSPSC_M_C.g_push_date_range1,
46: 'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_UNSPSC_M_C.g_push_date_range2,
48: 'MM/DD/YYYY HH24:MI:SS'));
49:
50: edw_log.put_line(' ');
51: edw_log.put_line('Pushing data');

Line 54: Push_EDW_UNSPSC_CLASS_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,

50: edw_log.put_line(' ');
51: edw_log.put_line('Pushing data');
52:
53: Push_EDW_DNB_POA_ITEMS();
54: Push_EDW_UNSPSC_CLASS_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
55: EDW_UNSPSC_M_C.g_push_date_range2);
56:
57: Push_EDW_UNSPSC_COMMODITY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
58: EDW_UNSPSC_M_C.g_push_date_range2);

Line 55: EDW_UNSPSC_M_C.g_push_date_range2);

51: edw_log.put_line('Pushing data');
52:
53: Push_EDW_DNB_POA_ITEMS();
54: Push_EDW_UNSPSC_CLASS_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
55: EDW_UNSPSC_M_C.g_push_date_range2);
56:
57: Push_EDW_UNSPSC_COMMODITY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
58: EDW_UNSPSC_M_C.g_push_date_range2);
59:

Line 57: Push_EDW_UNSPSC_COMMODITY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,

53: Push_EDW_DNB_POA_ITEMS();
54: Push_EDW_UNSPSC_CLASS_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
55: EDW_UNSPSC_M_C.g_push_date_range2);
56:
57: Push_EDW_UNSPSC_COMMODITY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
58: EDW_UNSPSC_M_C.g_push_date_range2);
59:
60: Push_EDW_UNSPSC_FAMILY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
61: EDW_UNSPSC_M_C.g_push_date_range2);

Line 58: EDW_UNSPSC_M_C.g_push_date_range2);

54: Push_EDW_UNSPSC_CLASS_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
55: EDW_UNSPSC_M_C.g_push_date_range2);
56:
57: Push_EDW_UNSPSC_COMMODITY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
58: EDW_UNSPSC_M_C.g_push_date_range2);
59:
60: Push_EDW_UNSPSC_FAMILY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
61: EDW_UNSPSC_M_C.g_push_date_range2);
62:

Line 60: Push_EDW_UNSPSC_FAMILY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,

56:
57: Push_EDW_UNSPSC_COMMODITY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
58: EDW_UNSPSC_M_C.g_push_date_range2);
59:
60: Push_EDW_UNSPSC_FAMILY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
61: EDW_UNSPSC_M_C.g_push_date_range2);
62:
63: Push_EDW_UNSPSC_FUNCTION_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
64: EDW_UNSPSC_M_C.g_push_date_range2);

Line 61: EDW_UNSPSC_M_C.g_push_date_range2);

57: Push_EDW_UNSPSC_COMMODITY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
58: EDW_UNSPSC_M_C.g_push_date_range2);
59:
60: Push_EDW_UNSPSC_FAMILY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
61: EDW_UNSPSC_M_C.g_push_date_range2);
62:
63: Push_EDW_UNSPSC_FUNCTION_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
64: EDW_UNSPSC_M_C.g_push_date_range2);
65:

Line 63: Push_EDW_UNSPSC_FUNCTION_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,

59:
60: Push_EDW_UNSPSC_FAMILY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
61: EDW_UNSPSC_M_C.g_push_date_range2);
62:
63: Push_EDW_UNSPSC_FUNCTION_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
64: EDW_UNSPSC_M_C.g_push_date_range2);
65:
66: Push_EDW_UNSPSC_SEGMENT_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
67: EDW_UNSPSC_M_C.g_push_date_range2);

Line 64: EDW_UNSPSC_M_C.g_push_date_range2);

60: Push_EDW_UNSPSC_FAMILY_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
61: EDW_UNSPSC_M_C.g_push_date_range2);
62:
63: Push_EDW_UNSPSC_FUNCTION_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
64: EDW_UNSPSC_M_C.g_push_date_range2);
65:
66: Push_EDW_UNSPSC_SEGMENT_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
67: EDW_UNSPSC_M_C.g_push_date_range2);
68:

Line 66: Push_EDW_UNSPSC_SEGMENT_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,

62:
63: Push_EDW_UNSPSC_FUNCTION_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
64: EDW_UNSPSC_M_C.g_push_date_range2);
65:
66: Push_EDW_UNSPSC_SEGMENT_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
67: EDW_UNSPSC_M_C.g_push_date_range2);
68:
69: l_duration := sysdate - l_temp_date;
70:

Line 67: EDW_UNSPSC_M_C.g_push_date_range2);

63: Push_EDW_UNSPSC_FUNCTION_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
64: EDW_UNSPSC_M_C.g_push_date_range2);
65:
66: Push_EDW_UNSPSC_SEGMENT_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
67: EDW_UNSPSC_M_C.g_push_date_range2);
68:
69: l_duration := sysdate - l_temp_date;
70:
71: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

Line 78: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, EDW_UNSPSC_M_C.g_exception_msg,

74: -- ---------------------------------------------------------------------------
75: -- END OF Collection , Developer Customizable Section
76: -- ---------------------------------------------------------------------------
77:
78: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, EDW_UNSPSC_M_C.g_exception_msg,
79: g_push_date_range1, g_push_date_range2);
80:
81: commit;
82:

Line 87: EDW_UNSPSC_M_C.g_exception_msg := l_exception_msg;

83: Exception When others then
84: Errbuf:=sqlerrm;
85: Retcode:=sqlcode;
86: l_exception_msg := Retcode || ':' || Errbuf;
87: EDW_UNSPSC_M_C.g_exception_msg := l_exception_msg;
88: rollback;
89:
90: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_UNSPSC_M_C.g_exception_msg,
91: g_push_date_range1, g_push_date_range2);

Line 90: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_UNSPSC_M_C.g_exception_msg,

86: l_exception_msg := Retcode || ':' || Errbuf;
87: EDW_UNSPSC_M_C.g_exception_msg := l_exception_msg;
88: rollback;
89:
90: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_UNSPSC_M_C.g_exception_msg,
91: g_push_date_range1, g_push_date_range2);
92:
93: commit;
94: End Push;

Line 168: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;

164: 'READY'
165: from POA_UNSPSC_INTERFACE dnb;
166:
167: l_rows_inserted := sql%rowcount;
168: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
169: edw_log.put_line('Commiting records for EDW_SPSC_CLASS_LSTG');
170: commit;
171:
172: edw_log.put_line('Completed Push_EDW_UNSPSC_CLASS_LSTG');

Line 215: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;

211: 'READY'
212: from POA_UNSPSC_INTERFACE dnb;
213:
214: l_rows_inserted := sql%rowcount;
215: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
216: edw_log.put_line('Commiting records for EDW_SPSC_COMMODITY_LSTG');
217: commit;
218:
219: edw_log.put_line('Completed Push_EDW_UNSPSC_COMMODITY_LSTG');

Line 260: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;

256: 'READY'
257: from POA_UNSPSC_INTERFACE dnb;
258:
259: l_rows_inserted := sql%rowcount;
260: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
261: edw_log.put_line('Commiting records for EDW_SPSC_FAMILY_LSTG');
262: commit;
263:
264: edw_log.put_line('Completed Push_EDW_UNSPSC_FAMILY_LSTG');

Line 319: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;

315: POA_DNB_ITEMS poa
316: where (dnb.Item_PK = poa.Item_PK);
317:
318: l_rows_inserted := sql%rowcount;
319: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
320: edw_log.put_line('Commiting records for EDW_SPSC_FUNCTION_LSTG');
321: commit;
322:
323: edw_log.put_line('Completed Push_EDW_UNSPSC_FUNCTION_LSTG');

Line 364: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;

360: 'READY'
361: from POA_UNSPSC_INTERFACE dnb;
362:
363: l_rows_inserted := sql%rowcount;
364: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
365: edw_log.put_line('Commiting records for EDW_SPSC_SEGMENT_LSTG');
366: commit;
367:
368: edw_log.put_line('Completed Push_EDW_UNSPSC_SEGMENT_LSTG');

Line 373: End EDW_UNSPSC_M_C;

369: Exception When others then
370: raise;
371: END Push_EDW_UNSPSC_SEGMENT_LSTG;
372:
373: End EDW_UNSPSC_M_C;