APPS.EDW_TRD_PARTNER_M_C dependencies on EDW_TPRT_TPARTNER_LOC_LSTG

Line 215: l_staging_table_name Varchar2(30) := 'EDW_TPRT_TPARTNER_LOC_LSTG';

211: Procedure Push_TPartner_Loc(Errbuf out NOCOPY Varchar2,
212: Retcode out NOCOPY Varchar2,
213: p_from_date Date := NULL,
214: p_to_date Date := NULL) IS
215: l_staging_table_name Varchar2(30) := 'EDW_TPRT_TPARTNER_LOC_LSTG';
216: l_push_date_range1 Date := NULL;
217: l_push_date_range2 Date := NULL;
218: l_temp_date Date := NULL;
219: l_rows_inserted Number := 0;

Line 252: Insert Into EDW_TPRT_TPARTNER_LOC_LSTG(

248: if (l_tmp_str1 IS NULL) THEN
249: edw_log.put_line('***Warning*** : No Look Code Found From GET_LEVEL_DP in Pushing TP Location');
250: end if;
251:
252: Insert Into EDW_TPRT_TPARTNER_LOC_LSTG(
253: TPARTNER_LOC_PK,
254: TRADE_PARTNER_FK,
255: ADDRESS_LINE1,
256: ADDRESS_LINE2,