APPS.XNB_CMN_PVT dependencies on ECX_OAG_CONTROLAREA_TP_V

Line 122: FROM ecx_oag_controlarea_tp_v

118: SELECT party_id,
119: party_site_id
120: INTO l_party_id,
121: l_party_site_id
122: FROM ecx_oag_controlarea_tp_v
123: WHERE transaction_type = l_transaction_type
124: AND transaction_subtype = l_transaction_subtype
125: AND party_type = l_party_type;
126:

Line 342: FROM ecx_oag_controlarea_tp_v

338: SELECT party_id,
339: party_site_id
340: INTO l_party_id,
341: l_party_site_id
342: FROM ecx_oag_controlarea_tp_v
343: WHERE transaction_type = l_transaction_type
344: AND transaction_subtype = l_transaction_subtype
345: AND party_type = l_party_type;
346:

Line 527: FROM ecx_oag_controlarea_tp_v

523: SELECT party_id,
524: party_site_id
525: INTO l_party_id,
526: l_party_site_id
527: FROM ecx_oag_controlarea_tp_v
528: WHERE transaction_type = l_transaction_type
529: AND transaction_subtype = l_transaction_subtype
530: AND party_type = l_party_type;
531:

Line 692: FROM ecx_oag_controlarea_tp_v

688: SELECT party_id,
689: party_site_id
690: INTO l_party_id,
691: l_party_site_id
692: FROM ecx_oag_controlarea_tp_v
693: WHERE transaction_type = l_transaction_type
694: AND transaction_subtype = l_transaction_subtype
695: AND party_type = l_party_type;
696:

Line 856: l_party_id ecx_oag_controlarea_tp_v.party_id%TYPE; --Trading Partner ID (from XML Gateway setup)

852: resultout OUT NOCOPY VARCHAR2)
853: AS
854: l_transaction_type VARCHAR2(10) ; --XML GW Internal Txn Type - XNB
855: l_transaction_subtype VARCHAR2(10) ; --XML GW Internal Txn Subtype - Owner Outbound
856: l_party_id ecx_oag_controlarea_tp_v.party_id%TYPE; --Trading Partner ID (from XML Gateway setup)
857: l_party_site_id ecx_oag_controlarea_tp_v.party_site_id%TYPE; --Trading Partner Site ID (from XML Gateway setup)
858: l_party_type VARCHAR2(30) ; --XML Gateway Party Type
859:
860: BEGIN

Line 857: l_party_site_id ecx_oag_controlarea_tp_v.party_site_id%TYPE; --Trading Partner Site ID (from XML Gateway setup)

853: AS
854: l_transaction_type VARCHAR2(10) ; --XML GW Internal Txn Type - XNB
855: l_transaction_subtype VARCHAR2(10) ; --XML GW Internal Txn Subtype - Owner Outbound
856: l_party_id ecx_oag_controlarea_tp_v.party_id%TYPE; --Trading Partner ID (from XML Gateway setup)
857: l_party_site_id ecx_oag_controlarea_tp_v.party_site_id%TYPE; --Trading Partner Site ID (from XML Gateway setup)
858: l_party_type VARCHAR2(30) ; --XML Gateway Party Type
859:
860: BEGIN
861:

Line 878: FROM ecx_oag_controlarea_tp_v

874: SELECT party_id,
875: party_site_id
876: INTO l_party_id,
877: l_party_site_id
878: FROM ecx_oag_controlarea_tp_v
879: WHERE transaction_type = l_transaction_type
880: AND transaction_subtype = l_transaction_subtype
881: AND party_type = l_party_type;
882:

Line 1938: FROM ecx_oag_controlarea_tp_v

1934: SELECT party_id,
1935: party_site_id
1936: INTO l_party_id,
1937: l_party_site_id
1938: FROM ecx_oag_controlarea_tp_v
1939: WHERE transaction_type = l_transaction_type
1940: AND transaction_subtype = l_transaction_subtype
1941: AND party_type = l_party_type;
1942: