APPS.ECX_TP_API dependencies on ECX_XREF_DTL

Line 336: l_xref_dtl_id ecx_xref_dtl.xref_dtl_id%type;

332: x_msg OUT NOCOPY Varchar2,
333: p_tp_header_id IN Pls_integer
334: ) IS
335:
336: l_xref_dtl_id ecx_xref_dtl.xref_dtl_id%type;
337: l_ret_code pls_integer := ECX_UTIL_API.G_NO_ERROR;
338: l_ret_msg varchar2(2000) := null;
339: l_event_name varchar2(250) := null;
340: l_event_key number := -1;

Line 347: select xref_dtl_id from ecx_xref_dtl

343: l_party_site_id number;
344: l_company_admin_email ecx_tp_headers.company_admin_email%type;
345:
346: cursor get_xref_dtl_id is
347: select xref_dtl_id from ecx_xref_dtl
348: where tp_header_id = p_tp_header_id;
349:
350: Begin
351: x_return_status := ECX_UTIL_API.G_NO_ERROR;

Line 375: delete from ecx_xref_dtl

371:
372: delete from ecx_tp_details
373: where tp_header_id = p_tp_header_id;
374:
375: delete from ecx_xref_dtl
376: where tp_header_id = p_tp_header_id;
377:
378: delete from ecx_xref_dtl_tl
379: where xref_dtl_id = l_xref_dtl_id;

Line 378: delete from ecx_xref_dtl_tl

374:
375: delete from ecx_xref_dtl
376: where tp_header_id = p_tp_header_id;
377:
378: delete from ecx_xref_dtl_tl
379: where xref_dtl_id = l_xref_dtl_id;
380:
381: /* For raising event */
382: select party_type,