[Home] [Help]
775: SELECT ipiu.payment_function
776: , fpc.payment_channel_code
777: , ipiu.payment_flow
778: FROM iby_pmt_instr_uses_all ipiu
779: ,iby_fndcpt_pmt_chnnls_vl fpc
780: WHERE instrument_id = p_instr_use_id
781: AND fpc.instrument_type = ipiu.instrument_type;
782:
783: CURSOR chr_dtls_csr (cp_khr_id IN NUMBER)
829: hz_cust_accounts a
830: where s.cust_acct_site_id = cp_customer_address_id
831: AND s.cust_account_id = a.cust_account_id;
832:
833: -- Bug# 11669781: changed the cursor for adding iby_fndcpt_pmt_chnnls_vl
834: /* CURSOR instrument_payment_use_id_csr(
835: p_bank_id iby_pmt_instr_uses_all.instrument_id%TYPE,
836: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
837: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
839: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
840: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,
841: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS
842: SELECT instrument_payment_use_id, fpc.payment_channel_code
843: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay,iby_fndcpt_pmt_chnnls_vl fpc
844: WHERE ibyinstr.instrument_id = p_bank_id
845: AND ibyinstr.payment_flow = p_payment_flow
846: AND pay.payment_function = p_payment_function
847: AND ibyinstr.EXT_PMT_PARTY_ID = pay.EXT_PAYER_ID
863: ) IS
864: SELECT instr_assignment_id,
865: fpc.payment_channel_code
866: FROM iby_fndcpt_payer_assgn_instr_v ibyinstr,
867: iby_fndcpt_pmt_chnnls_vl fpc
868: WHERE ibyinstr.instrument_id = p_bank_id
869: AND ibyinstr.payment_function = p_payment_function
870: AND ibyinstr.party_id = p_party_id
871: AND nvl(ibyinstr.org_id, p_org_id) = p_org_id
876: AND fpc.payment_channel_code in ('BANK_ACCT_XFER','CREDIT_CARD');
877:
878:
879: -- Bug# 11669781: added payment_channel_code
880: l_payment_channel_code iby_fndcpt_pmt_chnnls_vl.payment_channel_code%type;
881:
882: CURSOR cust_instr_payment_use_id_csr (
883: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
884: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1031: l_msg_data VARCHAR2(32767);
1032:
1033: l_payer IBY_FNDCPT_COMMON_PUB.payercontext_rec_type;
1034: l_payer_equivalency VARCHAR2(500);
1035: l_pmt_channel IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;
1036: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.trxnextension_rec_type;
1037: l_entity_id NUMBER;
1038: l_response IBY_FNDCPT_COMMON_PUB.result_rec_type;
1039: l_true VARCHAR2(1) := 'T';
1519: l_msg_data VARCHAR2(32767);
1520:
1521: l_payer IBY_FNDCPT_COMMON_PUB.payercontext_rec_type;
1522: l_payer_equivalency VARCHAR2(500);
1523: l_pmt_channel IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;
1524: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.trxnextension_rec_type;
1525: l_entity_id NUMBER;
1526: l_response IBY_FNDCPT_COMMON_PUB.result_rec_type;
1527: -- This values based on global variables from FND_API G_TRUE and G_FALSE;
1534: SELECT ipiu.payment_function
1535: , fpc.payment_channel_code
1536: , ipiu.payment_flow
1537: FROM iby_pmt_instr_uses_all ipiu
1538: , iby_fndcpt_pmt_chnnls_vl fpc
1539: WHERE instrument_id = p_instr_use_id
1540: AND fpc.instrument_type = ipiu.instrument_type;
1541:
1542: instr_type_rec instr_type_csr%ROWTYPE;
1590:
1591:
1592: --sosharma bug 6608452
1593:
1594: -- sosharma 10167846 changed the cursor for adding iby_fndcpt_pmt_chnnls_vl
1595: --instrument_payment_use_id to be passed to IBY Bug 7162253
1596: /* CURSOR instrument_payment_use_id_csr(
1597: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
1598: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1600: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1601: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,
1602: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS
1603: SELECT instrument_payment_use_id,fpc.payment_channel_code
1604: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay,iby_fndcpt_pmt_chnnls_vl fpc
1605: WHERE ibyinstr.instrument_id = p_bank_id
1606: AND ibyinstr.payment_flow = p_payment_flow
1607: AND pay.payment_function = p_payment_function
1608: AND ibyinstr.EXT_PMT_PARTY_ID = pay.EXT_PAYER_ID
1623: ) IS
1624: SELECT instr_assignment_id,
1625: fpc.payment_channel_code
1626: FROM iby_fndcpt_payer_assgn_instr_v ibyinstr,
1627: iby_fndcpt_pmt_chnnls_vl fpc
1628: WHERE ibyinstr.instrument_id = p_bank_id
1629: AND ibyinstr.payment_function = p_payment_function
1630: AND ibyinstr.party_id = p_party_id
1631: AND nvl(ibyinstr.org_id, p_org_id) = p_org_id
1637:
1638:
1639: l_instrument_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type;
1640: -- sosharma 10167846 added payment_channel_code
1641: payment_channel_code iby_fndcpt_pmt_chnnls_vl.payment_channel_code%type;
1642:
1643: CURSOR cust_instr_payment_use_id_csr (
1644: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1645: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,