APPS.EDW_TRD_PARTNER_M_C dependencies on EDW_TPRT_TRADE_PARTNER_LSTG

Line 185: UPDATE EDW_TPRT_TRADE_PARTNER_LSTG

181: pid := v_hierarchyTable(v_index).parent_vendor_id;
182:
183: IF v_change THEN
184:
185: UPDATE EDW_TPRT_TRADE_PARTNER_LSTG
186: SET PARENT_TPARTNER_FK = pid ||'-'|| v_instance ||'-'|| 'SUPPLIER'
187: WHERE TRADE_PARTNER_PK = id ||'-'|| v_instance ||'-'|| 'SUPPLIER';
188:
189: END IF;

Line 403: l_staging_table_name Varchar2(30) := 'EDW_TPRT_TRADE_PARTNER_LSTG';

399: Procedure Push_Trade_Partner(Errbuf out NOCOPY Varchar2,
400: Retcode out NOCOPY Varchar2,
401: p_from_date Date := NULL,
402: p_to_date Date := NULL) IS
403: l_staging_table_name Varchar2(30) := 'EDW_TPRT_TRADE_PARTNER_LSTG';
404: l_push_date_range1 Date := NULL;
405: l_push_date_range2 Date := NULL;
406: l_temp_date Date := NULL;
407: l_rows_inserted Number := 0;

Line 430: Insert Into EDW_TPRT_TRADE_PARTNER_LSTG(

426: l_push_date_range1 := p_from_date;
427: l_push_date_range2 := p_to_date;
428:
429: l_temp_date := sysdate;
430: Insert Into EDW_TPRT_TRADE_PARTNER_LSTG(
431: ALTERNATE_NAME,
432: CUST_ACCESS_TMPL,
433: CUST_ANALYSIS_FY,
434: CUST_CAT_CODE,