APPS.EDW_DUNS_M_C dependencies on EDW_DUNS_HEADQTR_LSTG

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 1106: Insert into EDW_DUNS_HEADQTR_LSTG(

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,
1108: HQ_DP,
1109: NAME,
1110: DUNS_NUMBER,

Line 1149: edw_log.put_line('Commiting records for EDW_DUNS_HEADQTR_LSTG');

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(
1153: PARENT_PK,

Line 1321: Procedure Push_EDW_DUNS_HEADQTR_LSTG(p_from_date IN date,

1317: END Push_EDW_DUNS_GLOBAL_LSTG;
1318:
1319:
1320:
1321: Procedure Push_EDW_DUNS_HEADQTR_LSTG(p_from_date IN date,
1322: p_to_date IN DATE) IS
1323: l_date1 DATE;
1324: l_date2 DATE;
1325: l_rows_inserted NUMBER :=0;

Line 1331: EDW_DUNS_HEADQTR_LSTG(

1327: edw_log.put_line('Starting Push_EDW_HEADQTR_LSTG');
1328: l_date1 := p_from_date;
1329: l_date2 := p_to_date;
1330: Insert Into
1331: EDW_DUNS_HEADQTR_LSTG(
1332: HQ_PK,
1333: HQ_DP,
1334: NAME,
1335: DUNS_NUMBER,

Line 1370: EDW_DUNS_HEADQTR_LSTG(

1366:
1367: l_rows_inserted := sql%rowcount;
1368:
1369: Insert Into
1370: EDW_DUNS_HEADQTR_LSTG(
1371: HQ_PK,
1372: HQ_DP,
1373: NAME,
1374: DUNS_NUMBER,

Line 1404: edw_log.put_line('Commiting records for EDW_DUNS_HEADQTR_LSTG');

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

Line 1407: edw_log.put_line('Completed Push_EDW_DUNS_HEADQTR_LSTG');

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');
1408: Exception When others then
1409: raise;
1410: commit;
1411: END Push_EDW_DUNS_HEADQTR_LSTG;

Line 1411: END Push_EDW_DUNS_HEADQTR_LSTG;

1407: edw_log.put_line('Completed Push_EDW_DUNS_HEADQTR_LSTG');
1408: Exception When others then
1409: raise;
1410: commit;
1411: END Push_EDW_DUNS_HEADQTR_LSTG;
1412:
1413:
1414: Procedure Push_EDW_SICM_SIC_LSTG(p_from_date IN date,
1415: p_to_date IN DATE) IS