APPS.ECX_TP_MERGE_PKG dependencies on ECX_TP_DETAILS

Line 67: v_ext_process_id ecx_tp_details.ext_process_id%type,

63: type t_tp_details_rec
64: is
65: record
66: (
67: v_ext_process_id ecx_tp_details.ext_process_id%type,
68: v_source_tp_location_code ecx_tp_details.source_tp_location_code%type);
69: type t_tp_details_tab
70: is
71: table of t_tp_details_rec;

Line 68: v_source_tp_location_code ecx_tp_details.source_tp_location_code%type);

64: is
65: record
66: (
67: v_ext_process_id ecx_tp_details.ext_process_id%type,
68: v_source_tp_location_code ecx_tp_details.source_tp_location_code%type);
69: type t_tp_details_tab
70: is
71: table of t_tp_details_rec;
72: v_tp_details_source_tab t_tp_details_tab;

Line 104: ecx_tp_details etd

100: select etd.ext_process_id,
101: etd.source_tp_location_code bulk collect
102: into v_tp_details_target_tab
103: from ecx_tp_headers eth,
104: ecx_tp_details etd
105: where eth.tp_header_id= etd.tp_header_id
106: and eth.party_site_id =p_to_fk_id;
107:
108: select etd.ext_process_id,

Line 112: ecx_tp_details etd

108: select etd.ext_process_id,
109: etd.source_tp_location_code bulk collect
110: into v_tp_details_source_tab
111: from ecx_tp_headers eth,
112: ecx_tp_details etd
113: where eth.tp_header_id= etd.tp_header_id
114: and eth.party_site_id =p_from_fk_id;
115:
116: for i in 1..v_tp_details_source_tab.count

Line 131: update ecx_tp_details

127: end if;
128: end loop;
129: end loop;
130: end if;
131: update ecx_tp_details
132: set tp_header_id = v_target_header_id
133: where tp_header_id in
134: (select tp_header_id
135: from ecx_tp_headers