DBA Data[Home] [Help]

APPS.EDW_TRD_PARTNER_M_C dependencies on EDW_TPRT_P3_TPARTNER_LSTG

Line 844: l_staging_table_name Varchar2(30) := 'EDW_TPRT_P3_TPARTNER_LSTG';

840: Procedure Push_P3_TPartner(Errbuf out NOCOPY Varchar2,
841: Retcode out NOCOPY Varchar2,
842: p_from_date Date := NULL,
843: p_to_date Date := NULL) IS
844: l_staging_table_name Varchar2(30) := 'EDW_TPRT_P3_TPARTNER_LSTG';
845: l_push_date_range1 Date := NULL;
846: l_push_date_range2 Date := NULL;
847: l_temp_date Date := NULL;
848: l_rows_inserted Number := 0;

Line 870: Insert Into EDW_TPRT_P3_TPARTNER_LSTG(

866: edw_log.put_line(' ');
867: edw_log.put_line('Pushing data for TP Parent 3 Staging Table...');
868:
869: l_temp_date := sysdate;
870: Insert Into EDW_TPRT_P3_TPARTNER_LSTG(
871: ALLOW_SUB_RECEIPT,
872: ALLOW_UNORDER_RCV,
873: ALTERNATE_NAME,
874: END_ACTIVE_DATE,