APPS.ITG_SETUP dependencies on ECX_TP_HEADERS

Line 413: FROM ecx_tp_headers

409: CURSOR check_ecx_tp_hdr(p_party_type VARCHAR2,
410: p_party_id NUMBER ,
411: p_party_site_id NUMBER) IS
412: SELECT tp_header_id
413: FROM ecx_tp_headers
414: WHERE party_type = p_party_type
415: AND party_id = p_party_id
416: AND party_site_id = p_party_site_id;
417:

Line 440: -- query ecx_tp_headers to get tp_header_id for a given trading partner setup

436:
437: IF (l_Debug_Level <= 1 ) THEN
438: itg_debug_pub.Add('Obtained location id - ' || l_loc_id,1);
439: END IF;
440: -- query ecx_tp_headers to get tp_header_id for a given trading partner setup
441: -- If no record is found create a tp header block else update it
442:
443: OPEN check_ecx_tp_hdr('I',l_loc_id,l_loc_id);
444: FETCH check_ecx_tp_hdr INTO l_tp_hdr_id;

Line 878: ecx_tp_headers tph,

874: )IS
875: SELECT tp_detail_id
876: FROM
877: ecx_tp_details tpd,
878: ecx_tp_headers tph,
879: ecx_ext_processes extp,
880: ecx_transactions txn,
881: ecx_standards svl
882: WHERE 1=1