APPS.EDW_DUNS_M_C dependencies on EDW_DUNS_PARENT_LSTG

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 822: Procedure Push_EDW_DUNS_PARENT_LSTG(p_from_date IN date,

818:
819:
820:
821:
822: Procedure Push_EDW_DUNS_PARENT_LSTG(p_from_date IN date,
823: p_to_date IN DATE) IS
824: l_date1 DATE;
825: l_date2 DATE;
826: l_rows_inserted NUMBER :=0;

Line 832: EDW_DUNS_PARENT_LSTG(

828: edw_log.put_line('Starting Push_DUNS_PARENT_LSTG');
829: l_date1 := p_from_date;
830: l_date2 := p_to_date;
831: Insert Into
832: EDW_DUNS_PARENT_LSTG(
833: PARENT_PK,
834: PARENT_DP,
835: NAME,
836: DUNS_NUMBER,

Line 872: EDW_DUNS_PARENT_LSTG(

868: l_rows_inserted := sql%rowcount;
869:
870: -- Push up the DUNS No. if its doesnt have any Parent
871: Insert Into
872: EDW_DUNS_PARENT_LSTG(
873: PARENT_PK,
874: PARENT_DP,
875: NAME,
876: DUNS_NUMBER,

Line 907: edw_log.put_line('Commiting records for EDW_DUNS_PARENT_LSTG');

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

Line 910: edw_log.put_line('Completed Push_EDW_DUNS_PARENT_LSTG');

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');
911: Exception When others then
912: raise;
913: commit;
914: END Push_EDW_DUNS_PARENT_LSTG;

Line 914: END Push_EDW_DUNS_PARENT_LSTG;

910: edw_log.put_line('Completed Push_EDW_DUNS_PARENT_LSTG');
911: Exception When others then
912: raise;
913: commit;
914: END Push_EDW_DUNS_PARENT_LSTG;
915:
916:
917:
918: Procedure Push_EDW_DUNS_DOMESTIC_LSTG(p_from_date IN date,

Line 1152: Insert into EDW_DUNS_PARENT_LSTG(

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(
1153: PARENT_PK,
1154: PARENT_DP,
1155: NAME,
1156: DUNS_NUMBER,

Line 1195: edw_log.put_line('Commiting records for EDW_DUNS_PARENT_LSTG');

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(
1199: DUNS_NUM_PK,