DBA Data[Home] [Help]

APPS.EDW_TRD_PARTNER_M_C dependencies on EDW_TPRT_P1_TPARTNER_LSTG

Line 600: l_staging_table_name Varchar2(30) := 'EDW_TPRT_P1_TPARTNER_LSTG';

596: Procedure Push_P1_TPartner(Errbuf out NOCOPY Varchar2,
597: Retcode out NOCOPY Varchar2,
598: p_from_date Date := NULL,
599: p_to_date Date := NULL) IS
600: l_staging_table_name Varchar2(30) := 'EDW_TPRT_P1_TPARTNER_LSTG';
601: l_push_date_range1 Date := NULL;
602: l_push_date_range2 Date := NULL;
603: l_temp_date Date := NULL;
604: l_rows_inserted Number := 0;

Line 628: Insert Into EDW_TPRT_P1_TPARTNER_LSTG(

624: edw_log.put_line(' ');
625: edw_log.put_line('Pushing data for TP Parent 1 Staging Table...');
626:
627: l_temp_date := sysdate;
628: Insert Into EDW_TPRT_P1_TPARTNER_LSTG(
629: ALLOW_SUB_RECEIPT,
630: ALLOW_UNORDER_RCV,
631: ALTERNATE_NAME,
632: END_ACTIVE_DATE,