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_DUNS_M_C dependencies on EDW_DUNS_M_C

Line 1: Package Body EDW_DUNS_M_C AS

1: Package Body EDW_DUNS_M_C AS
2: /* $Header: poaphtpb.pls 115.20 2004/02/26 13:53:00 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_DUNS_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_DUNS_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_DUNS_M_C.g_push_date_range2 := nvl(l_to_date,

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

37: EDW_DUNS_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_DUNS_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_DUNS_M_C.g_push_date_range1,

Line 45: to_char(EDW_DUNS_M_C.g_push_date_range1,

41: EDW_DUNS_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_DUNS_M_C.g_push_date_range1,
46: 'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_DUNS_M_C.g_push_date_range2,
48: 'MM/DD/YYYY HH24:MI:SS'));
49:

Line 47: to_char(EDW_DUNS_M_C.g_push_date_range2,

43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_DUNS_M_C.g_push_date_range1,
46: 'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_DUNS_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_DUNS_NUMBER_LSTG(EDW_DUNS_M_C.g_push_date_range1,

50: edw_log.put_line(' ');
51: edw_log.put_line('Pushing data');
52:
53: Push_EDW_DNB_TPRT();
54: Push_EDW_DUNS_NUMBER_LSTG(EDW_DUNS_M_C.g_push_date_range1,
55: EDW_DUNS_M_C.g_push_date_range2);
56:
57: Push_EDW_DUNS_PARENT_LSTG(EDW_DUNS_M_C.g_push_date_range1,
58: EDW_DUNS_M_C.g_push_date_range2);

Line 55: EDW_DUNS_M_C.g_push_date_range2);

51: edw_log.put_line('Pushing data');
52:
53: Push_EDW_DNB_TPRT();
54: Push_EDW_DUNS_NUMBER_LSTG(EDW_DUNS_M_C.g_push_date_range1,
55: EDW_DUNS_M_C.g_push_date_range2);
56:
57: Push_EDW_DUNS_PARENT_LSTG(EDW_DUNS_M_C.g_push_date_range1,
58: EDW_DUNS_M_C.g_push_date_range2);
59:

Line 57: Push_EDW_DUNS_PARENT_LSTG(EDW_DUNS_M_C.g_push_date_range1,

53: Push_EDW_DNB_TPRT();
54: Push_EDW_DUNS_NUMBER_LSTG(EDW_DUNS_M_C.g_push_date_range1,
55: EDW_DUNS_M_C.g_push_date_range2);
56:
57: Push_EDW_DUNS_PARENT_LSTG(EDW_DUNS_M_C.g_push_date_range1,
58: EDW_DUNS_M_C.g_push_date_range2);
59:
60: Push_EDW_DUNS_DOMESTIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,
61: EDW_DUNS_M_C.g_push_date_range2);

Line 58: EDW_DUNS_M_C.g_push_date_range2);

54: Push_EDW_DUNS_NUMBER_LSTG(EDW_DUNS_M_C.g_push_date_range1,
55: EDW_DUNS_M_C.g_push_date_range2);
56:
57: Push_EDW_DUNS_PARENT_LSTG(EDW_DUNS_M_C.g_push_date_range1,
58: EDW_DUNS_M_C.g_push_date_range2);
59:
60: Push_EDW_DUNS_DOMESTIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,
61: EDW_DUNS_M_C.g_push_date_range2);
62:

Line 60: Push_EDW_DUNS_DOMESTIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,

56:
57: Push_EDW_DUNS_PARENT_LSTG(EDW_DUNS_M_C.g_push_date_range1,
58: EDW_DUNS_M_C.g_push_date_range2);
59:
60: Push_EDW_DUNS_DOMESTIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,
61: EDW_DUNS_M_C.g_push_date_range2);
62:
63: Push_EDW_DUNS_HEADQTR_LSTG(EDW_DUNS_M_C.g_push_date_range1,
64: EDW_DUNS_M_C.g_push_date_range2);

Line 61: EDW_DUNS_M_C.g_push_date_range2);

57: Push_EDW_DUNS_PARENT_LSTG(EDW_DUNS_M_C.g_push_date_range1,
58: EDW_DUNS_M_C.g_push_date_range2);
59:
60: Push_EDW_DUNS_DOMESTIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,
61: EDW_DUNS_M_C.g_push_date_range2);
62:
63: Push_EDW_DUNS_HEADQTR_LSTG(EDW_DUNS_M_C.g_push_date_range1,
64: EDW_DUNS_M_C.g_push_date_range2);
65:

Line 63: Push_EDW_DUNS_HEADQTR_LSTG(EDW_DUNS_M_C.g_push_date_range1,

59:
60: Push_EDW_DUNS_DOMESTIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,
61: EDW_DUNS_M_C.g_push_date_range2);
62:
63: Push_EDW_DUNS_HEADQTR_LSTG(EDW_DUNS_M_C.g_push_date_range1,
64: EDW_DUNS_M_C.g_push_date_range2);
65:
66: Push_EDW_DUNS_GLOBAL_LSTG(EDW_DUNS_M_C.g_push_date_range1,
67: EDW_DUNS_M_C.g_push_date_range2);

Line 64: EDW_DUNS_M_C.g_push_date_range2);

60: Push_EDW_DUNS_DOMESTIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,
61: EDW_DUNS_M_C.g_push_date_range2);
62:
63: Push_EDW_DUNS_HEADQTR_LSTG(EDW_DUNS_M_C.g_push_date_range1,
64: EDW_DUNS_M_C.g_push_date_range2);
65:
66: Push_EDW_DUNS_GLOBAL_LSTG(EDW_DUNS_M_C.g_push_date_range1,
67: EDW_DUNS_M_C.g_push_date_range2);
68:

Line 66: Push_EDW_DUNS_GLOBAL_LSTG(EDW_DUNS_M_C.g_push_date_range1,

62:
63: Push_EDW_DUNS_HEADQTR_LSTG(EDW_DUNS_M_C.g_push_date_range1,
64: EDW_DUNS_M_C.g_push_date_range2);
65:
66: Push_EDW_DUNS_GLOBAL_LSTG(EDW_DUNS_M_C.g_push_date_range1,
67: EDW_DUNS_M_C.g_push_date_range2);
68:
69: Push_EDW_SICM_SIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,
70: EDW_DUNS_M_C.g_push_date_range2);

Line 67: EDW_DUNS_M_C.g_push_date_range2);

63: Push_EDW_DUNS_HEADQTR_LSTG(EDW_DUNS_M_C.g_push_date_range1,
64: EDW_DUNS_M_C.g_push_date_range2);
65:
66: Push_EDW_DUNS_GLOBAL_LSTG(EDW_DUNS_M_C.g_push_date_range1,
67: EDW_DUNS_M_C.g_push_date_range2);
68:
69: Push_EDW_SICM_SIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,
70: EDW_DUNS_M_C.g_push_date_range2);
71:

Line 69: Push_EDW_SICM_SIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,

65:
66: Push_EDW_DUNS_GLOBAL_LSTG(EDW_DUNS_M_C.g_push_date_range1,
67: EDW_DUNS_M_C.g_push_date_range2);
68:
69: Push_EDW_SICM_SIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,
70: EDW_DUNS_M_C.g_push_date_range2);
71:
72: l_duration := sysdate - l_temp_date;
73:

Line 70: EDW_DUNS_M_C.g_push_date_range2);

66: Push_EDW_DUNS_GLOBAL_LSTG(EDW_DUNS_M_C.g_push_date_range1,
67: EDW_DUNS_M_C.g_push_date_range2);
68:
69: Push_EDW_SICM_SIC_LSTG(EDW_DUNS_M_C.g_push_date_range1,
70: EDW_DUNS_M_C.g_push_date_range2);
71:
72: l_duration := sysdate - l_temp_date;
73:
74: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

Line 80: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, EDW_DUNS_M_C.g_exception_msg,

76:
77: -- ---------------------------------------------------------------------------
78: -- END OF Collection , Developer Customizable Section
79: -- ---------------------------------------------------------------------------
80: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, EDW_DUNS_M_C.g_exception_msg,
81: g_push_date_range1, g_push_date_range2);
82: commit;
83:
84: Exception When others then

Line 88: EDW_DUNS_M_C.g_exception_msg := l_exception_msg;

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

Line 91: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_DUNS_M_C.g_exception_msg,

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

Line 807: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;

803: where (dnb.TRADING_PARTNER_PK = poa.TRADING_PARTNER_PK);
804:
805: l_rows_inserted := sql%rowcount;
806:
807: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
808:
809: edw_log.put_line('Commiting records for EDW_DUNS_NUMBER_LSTG');
810: commit;
811:

Line 906: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;

902: from POA_TPRT_INTERFACE dnb
903: where (ltrim(rtrim(PARENT_DUNS)) IS NULL);
904:
905: l_rows_inserted := l_rows_inserted + sql%rowcount;
906: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
907: edw_log.put_line('Commiting records for EDW_DUNS_PARENT_LSTG');
908: commit;
909:
910: edw_log.put_line('Completed Push_EDW_DUNS_PARENT_LSTG');

Line 1000: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;

996: 'READY'
997: from POA_TPRT_INTERFACE dnb
998: where (ltrim(rtrim(DOMESTIC_ULT_DUNS)) IS NULL);
999:
1000: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1001: edw_log.put_line('Commiting records for EDW_DUNS_DOMESTIC_LSTG');
1002: commit;
1003:
1004: edw_log.put_line('Completed Push_EDW_DUNS_DOMESTIC_LSTG');

Line 1055: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;

1051: 'READY'
1052: from POA_TPRT_INTERFACE dnb;
1053:
1054: l_rows_inserted := sql%rowcount;
1055: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1056: edw_log.put_line('Commiting records for EDW_DUNS_GLOBAL_LSTG');
1057: commit;
1058:
1059: -- Push Global Ultimate to all lower level if needed

Line 1102: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;

1098: where ltrim(rtrim(DUNS)) IS NOT NULL
1099: and dnb.GLOBAL_ULT_DUNS = pti.DUNS));
1100:
1101: l_rows_inserted := sql%rowcount;
1102: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1103: edw_log.put_line('Commiting records for EDW_DUNS_DOMESTIC_LSTG');
1104: commit;
1105:
1106: Insert into EDW_DUNS_HEADQTR_LSTG(

Line 1148: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;

1144: where (ltrim(rtrim(DUNS)) IS NOT NULL)
1145: and dnb.GLOBAL_ULT_DUNS = pti.DUNS));
1146:
1147: l_rows_inserted := sql%rowcount;
1148: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1149: edw_log.put_line('Commiting records for EDW_DUNS_HEADQTR_LSTG');
1150: commit;
1151:
1152: Insert into EDW_DUNS_PARENT_LSTG(

Line 1194: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;

1190: where (ltrim(rtrim(DUNS)) IS NOT NULL)
1191: and dnb.GLOBAL_ULT_DUNS = pti.DUNS));
1192:
1193: l_rows_inserted := sql%rowcount;
1194: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1195: edw_log.put_line('Commiting records for EDW_DUNS_PARENT_LSTG');
1196: commit;
1197:
1198: Insert into EDW_DUNS_NUMBER_LSTG(

Line 1309: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;

1305: where (ltrim(rtrim(DUNS)) IS NOT NULL)
1306: and dnb.GLOBAL_ULT_DUNS = pti.DUNS)));
1307:
1308: l_rows_inserted := sql%rowcount;
1309: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1310: edw_log.put_line('Commiting records for EDW_DUNS_NUMBER_LSTG');
1311: commit;
1312:
1313: edw_log.put_line('Completed Push_EDW_DUNS_GLOBAL_LSTG');

Line 1403: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;

1399: 'READY'
1400: from POA_TPRT_INTERFACE dnb
1401: where (ltrim(rtrim(HQ_DUNS)) IS NULL);
1402:
1403: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1404: edw_log.put_line('Commiting records for EDW_DUNS_HEADQTR_LSTG');
1405: commit;
1406:
1407: edw_log.put_line('Completed Push_EDW_DUNS_HEADQTR_LSTG');

Line 1443: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;

1439: 'Y'
1440: from POA_DNB_SIC_CODE poa;
1441:
1442: l_rows_inserted := sql%rowcount;
1443: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1444: edw_log.put_line('Commiting records for EDW_SICM_SIC_LSTG');
1445: Exception When others then
1446: raise;
1447: commit;

Line 1451: END EDW_DUNS_M_C;

1447: commit;
1448: END Push_EDW_SICM_SIC_LSTG;
1449:
1450:
1451: END EDW_DUNS_M_C;
1452: