APPS.OZF_PRE_PROCESS_PVT dependencies on ECX_TP_DETAILS_V

Line 685: , ecx_tp_details_v dtl

681: SELECT party_id
682: , party_site_id
683: , company_admin_email
684: FROM ecx_tp_headers_v hdr
685: , ecx_tp_details_v dtl
686: WHERE hdr.tp_header_id = dtl.tp_header_id
687: AND source_tp_location_code = to_char(pc_party_site);
688:
689: time NUMBER;

Line 7550: l_trans_type ecx_tp_details_v.transaction_type%TYPE;

7546: IS
7547: l_api_name CONSTANT VARCHAR2(30) := 'Confirm_BOD_Enabled';
7548: l_api_version_number CONSTANT NUMBER := 1.0;
7549:
7550: l_trans_type ecx_tp_details_v.transaction_type%TYPE;
7551: l_trans_subtype ecx_tp_details_v.transaction_subtype%TYPE;
7552: l_party_id ecx_tp_headers_v.party_id%TYPE;
7553: l_party_site_id ecx_tp_headers_v.party_site_id%TYPE;
7554: l_resale_batch_id NUMBER;

Line 7551: l_trans_subtype ecx_tp_details_v.transaction_subtype%TYPE;

7547: l_api_name CONSTANT VARCHAR2(30) := 'Confirm_BOD_Enabled';
7548: l_api_version_number CONSTANT NUMBER := 1.0;
7549:
7550: l_trans_type ecx_tp_details_v.transaction_type%TYPE;
7551: l_trans_subtype ecx_tp_details_v.transaction_subtype%TYPE;
7552: l_party_id ecx_tp_headers_v.party_id%TYPE;
7553: l_party_site_id ecx_tp_headers_v.party_site_id%TYPE;
7554: l_resale_batch_id NUMBER;
7555:

Line 7569: , ecx_tp_details_v etd

7565: , pc_txn_sub_type VARCHAR2 )
7566: IS
7567: SELECT etd.confirmation, eth.company_admin_email
7568: FROM ecx_tp_headers_v eth
7569: , ecx_tp_details_v etd
7570: WHERE eth.tp_header_id = etd.tp_header_id
7571: AND eth.party_id = pc_party_id
7572: AND eth.party_site_id = pc_site_id
7573: AND etd.transaction_type = pc_transaction_type