APPS.EDW_DUNS_M_C dependencies on EDW_DUNS_DOMESTIC_LSTG

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 918: Procedure Push_EDW_DUNS_DOMESTIC_LSTG(p_from_date IN date,

914: END Push_EDW_DUNS_PARENT_LSTG;
915:
916:
917:
918: Procedure Push_EDW_DUNS_DOMESTIC_LSTG(p_from_date IN date,
919: p_to_date IN DATE) IS
920: l_date1 DATE;
921: l_date2 DATE;
922: l_rows_inserted NUMBER :=0;

Line 928: EDW_DUNS_DOMESTIC_LSTG(

924: edw_log.put_line('Starting Push_DUNS_DOMESTIC_LSTG');
925: l_date1 := p_from_date;
926: l_date2 := p_to_date;
927: Insert Into
928: EDW_DUNS_DOMESTIC_LSTG(
929: DOMESTIC_ULT_PK,
930: DOMESTIC_ULT_DP,
931: NAME,
932: DUNS_NUMBER,

Line 967: EDW_DUNS_DOMESTIC_LSTG(

963:
964: l_rows_inserted := sql%rowcount;
965:
966: Insert Into
967: EDW_DUNS_DOMESTIC_LSTG(
968: DOMESTIC_ULT_PK,
969: DOMESTIC_ULT_DP,
970: NAME,
971: DUNS_NUMBER,

Line 1001: edw_log.put_line('Commiting records for EDW_DUNS_DOMESTIC_LSTG');

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');
1005: Exception When others then

Line 1004: edw_log.put_line('Completed Push_EDW_DUNS_DOMESTIC_LSTG');

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');
1005: Exception When others then
1006: raise;
1007: commit;
1008: END Push_EDW_DUNS_DOMESTIC_LSTG;

Line 1008: END Push_EDW_DUNS_DOMESTIC_LSTG;

1004: edw_log.put_line('Completed Push_EDW_DUNS_DOMESTIC_LSTG');
1005: Exception When others then
1006: raise;
1007: commit;
1008: END Push_EDW_DUNS_DOMESTIC_LSTG;
1009:
1010:
1011:
1012: Procedure Push_EDW_DUNS_GLOBAL_LSTG(p_from_date IN date,

Line 1060: Insert into EDW_DUNS_DOMESTIC_LSTG(

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
1060: Insert into EDW_DUNS_DOMESTIC_LSTG(
1061: DOMESTIC_ULT_PK,
1062: DOMESTIC_ULT_DP,
1063: NAME,
1064: DUNS_NUMBER,

Line 1103: edw_log.put_line('Commiting records for EDW_DUNS_DOMESTIC_LSTG');

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(
1107: HQ_PK,