DBA Data[Home] [Help]

APPS.M4R_7B1_WSM_IN dependencies on ECX_TP_HEADERS

Line 236: g_exception_tracking_msg := 'Querying ecx_tp_headers for Trading Partner Details';

232: cln_debug_pub.Add('-------- Entering procedure GET_TP_DETAILS ------', 2);
233: cln_debug_pub.Add('p_tp_hdr_id : ' || p_tp_hdr_id, 2);
234: END IF;
235:
236: g_exception_tracking_msg := 'Querying ecx_tp_headers for Trading Partner Details';
237:
238: SELECT party_id,party_site_id
239: INTO x_party_id,x_party_site_id
240: FROM ecx_tp_headers

Line 240: FROM ecx_tp_headers

236: g_exception_tracking_msg := 'Querying ecx_tp_headers for Trading Partner Details';
237:
238: SELECT party_id,party_site_id
239: INTO x_party_id,x_party_site_id
240: FROM ecx_tp_headers
241: WHERE tp_header_id = p_tp_hdr_id;
242:
243: IF (g_debug_level <= 2) THEN
244: cln_debug_pub.Add('------- Exiting procedure GET_TP_DETAILS ------ ', 2);