APPS.ECX_TRADING_PARTNER_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

select	party_id,
	party_site_id,
	party_type,
	company_admin_email
from	ecx_tp_headers
where	tp_header_id = p_tp_header_id;

Line: 29

l_Select	VARCHAR2(2400);

Line: 55

		   l_Select := ' select	haa.org_id' ||
			       ' from   hz_cust_acct_sites_all haa ,' ||
			       '	hz_cust_accounts  ha ' ||
			       ' where	ha.cust_account_id = :party_id' ||
			       ' and	haa.cust_account_id = ha.cust_account_id' ||
			       ' and	haa.cust_acct_site_id= :party_site_id ';

Line: 65

	 	   l_Select := ' select	org_id' ||
			       ' from	po_vendor_sites_all' ||
			       ' where	vendor_id = :party_id' ||
			       ' and    vendor_site_id = :party_site_id ';

Line: 79

		DBMS_SQL.PARSE(l_CursorID, l_Select, DBMS_SQL.V7);

Line: 111

l_Select	VARCHAR2(2000);

Line: 116

	l_Select := ' select  haa.cust_acct_site_id,' ||
		    '	      haa.org_id' ||
		    ' from    hz_cust_acct_sites_all haa' ||
		    ' where   haa.ece_tp_location_code = :location_code_ext ';

Line: 123

	l_Select := ' select  pvs.vendor_site_id,' ||
		    ' 	      pvs.org_id' ||
		    ' from    po_vendor_sites_all pvs' ||
		    ' where   pvs.ece_tp_location_code = :location_code_ext ';

Line: 130

	l_Select := ' select  cbb.branch_party_id, null' ||
		    ' from    ce_bank_branches_v cbb, hz_contact_points hcp' ||
		    ' where   cbb.branch_party_id=hcp.owner_table_id and
		 	      hcp.owner_table_name = ''HZ_PARTIES'' and
			      hcp.contact_point_type = ''EDI'' and
			      hcp.edi_ece_tp_location_code = :location_code_ext ';

Line: 139

	l_Select := ' select  location_id, null' ||
		    ' from    hr_locations_all' ||
		    ' where   ece_tp_location_code = :location_code_ext ';

Line: 152

   DBMS_SQL.PARSE(l_CursorID, l_Select, DBMS_SQL.V7);

Line: 269

	Select eth.company_admin_email
        Into   l_email_addr
	From   ecx_tp_headers eth,
               ecx_transactions et
       where  eth.party_type = et.party_type
       and  et.transaction_type = l_transaction_type
       and  et.transaction_subtype = l_transaction_subtype
       and  eth.party_site_id = l_party_site_id
       and (l_party_type is null or et.party_type = l_party_type);

Line: 371

	         Select  etpd.protocol_type, etpd.protocol_address,
		         etpd.username, etpd.password
	         Into    p_protocol_type, p_protocol_address,
		         p_username, p_password
	         From   ECX_TP_HEADERS etph, ECX_TP_DETAILS_V etpd
	         Where  etph.party_type    = p_party_type
	         And	  etph.party_id      = p_party_id
	         And	  etph.party_site_id = p_party_site_id
                 And    etpd.tp_header_id  = etph.tp_header_id
                 And    etpd.transaction_type = p_transaction_type
	         And    etpd.transaction_subtype = p_transaction_subtype;

Line: 449

select 	message_type,
	message_standard,
       	transaction_type,
       	transaction_subtype,
	document_number,
       	partyid,
       	party_site_id,
	protocol_type,
	protocol_address,
	username,
	password,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5
  from ecx_doclogs
 where internal_control_number = p_icn;

Line: 535

	update  ecx_doclogs
	set     orig_reference_id = i_original_reference_id
	where   internal_control_number = i_internal_control_number;