APPS.EDW_DUNS_M_C dependencies on EDW_DUNS_NUMBER_LSTG

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 523: Procedure Push_EDW_DUNS_NUMBER_LSTG(p_from_date IN date, p_to_date IN DATE) IS

519: END Push_EDW_DNB_TPRT;
520:
521:
522:
523: Procedure Push_EDW_DUNS_NUMBER_LSTG(p_from_date IN date, p_to_date IN DATE) IS
524: l_date1 DATE;
525: l_date2 DATE;
526: l_rows_inserted NUMBER :=0;
527: BEGIN

Line 533: EDW_DUNS_NUMBER_LSTG(

529: l_date1 := p_from_date;
530: l_date2 := p_to_date;
531:
532: Insert Into
533: EDW_DUNS_NUMBER_LSTG(
534: DUNS_NUM_PK,
535: DUNS_NUM_DP,
536: NAME,
537: DUNS_NUMBER,

Line 809: edw_log.put_line('Commiting records for EDW_DUNS_NUMBER_LSTG');

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:
812: edw_log.put_line('Completed Push_EDW_DUNS_NUMBER_LSTG');
813: Exception When others then

Line 812: edw_log.put_line('Completed Push_EDW_DUNS_NUMBER_LSTG');

808:
809: edw_log.put_line('Commiting records for EDW_DUNS_NUMBER_LSTG');
810: commit;
811:
812: edw_log.put_line('Completed Push_EDW_DUNS_NUMBER_LSTG');
813: Exception When others then
814: raise;
815: commit;
816: END Push_EDW_DUNS_NUMBER_LSTG;

Line 816: END Push_EDW_DUNS_NUMBER_LSTG;

812: edw_log.put_line('Completed Push_EDW_DUNS_NUMBER_LSTG');
813: Exception When others then
814: raise;
815: commit;
816: END Push_EDW_DUNS_NUMBER_LSTG;
817:
818:
819:
820:

Line 1198: Insert into EDW_DUNS_NUMBER_LSTG(

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(
1199: DUNS_NUM_PK,
1200: DUNS_NUM_DP,
1201: NAME,
1202: DUNS_NUMBER,

Line 1310: edw_log.put_line('Commiting records for EDW_DUNS_NUMBER_LSTG');

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