eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ARINTF_PVT dependencies on IBY_PMT_INSTR_USES_ALL

Line 778: FROM iby_pmt_instr_uses_all ipiu

774: IS
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:

Line 835: p_bank_id iby_pmt_instr_uses_all.instrument_id%TYPE,

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,
838: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
839: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,

Line 836: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,

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,
838: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%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,

Line 841: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS

837: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
838: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%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

Line 843: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay,iby_fndcpt_pmt_chnnls_vl fpc

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

Line 856: p_bank_id iby_pmt_instr_uses_all.instrument_id%TYPE,

852: AND fpc.instrument_type = ibyinstr.instrument_type;*/
853:
854: -- bug 11886651
855: CURSOR instrument_payment_use_id_csr(
856: p_bank_id iby_pmt_instr_uses_all.instrument_id%TYPE,
857: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
858: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
859: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
860: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,

Line 857: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,

853:
854: -- bug 11886651
855: CURSOR instrument_payment_use_id_csr(
856: p_bank_id iby_pmt_instr_uses_all.instrument_id%TYPE,
857: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
858: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
859: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
860: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
861: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE

Line 862: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE

858: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
859: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
860: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
861: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE
862: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE
863: ) IS
864: SELECT instr_assignment_id,
865: fpc.payment_channel_code
866: FROM iby_fndcpt_payer_assgn_instr_v ibyinstr,

Line 906: cursor instrument_id_csr (p_instr_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type)

902: )
903: and p_trx_date between NVL(assignment_start_date,p_trx_date)
904: and NVL(assignment_end_date,p_trx_date);
905:
906: cursor instrument_id_csr (p_instr_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type)
907: is
908: select instrument_id
909: from iby_pmt_instr_uses_all
910: where instrument_payment_use_id = p_instr_payment_use_id;

Line 909: from iby_pmt_instr_uses_all

905:
906: cursor instrument_id_csr (p_instr_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type)
907: is
908: select instrument_id
909: from iby_pmt_instr_uses_all
910: where instrument_payment_use_id = p_instr_payment_use_id;
911:
912: --Get vendor payment method attached in a contract
913: --Bug# 10275519: Modifications to fetch Payment Method

Line 973: FROM IBY_PMT_INSTR_USES_ALL PIU,

969: (SELECT PIU.INSTRUMENT_PAYMENT_USE_ID,
970: PIU.PAYMENT_FUNCTION,
971: PIU.ORDER_OF_PREFERENCE,
972: PIU.PAYMENT_FLOW
973: FROM IBY_PMT_INSTR_USES_ALL PIU,
974: IBY_CREDITCARD ccard,
975: iby_external_payers_all pay
976: WHERE ccard.INSTRID = PIU.instrument_id
977: AND PIU.INSTRUMENT_TYPE = p_instrument_type

Line 990: FROM IBY_PMT_INSTR_USES_ALL PIU,

986: SELECT PIU.INSTRUMENT_PAYMENT_USE_ID,
987: PIU.PAYMENT_FUNCTION,
988: PIU.ORDER_OF_PREFERENCE,
989: PIU.PAYMENT_FLOW
990: FROM IBY_PMT_INSTR_USES_ALL PIU,
991: iby_ext_bank_accounts eb,
992: iby_external_payers_all pay
993: WHERE PIU.instrument_id = eb.ext_bank_account_id
994: AND PIU.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT'

Line 1009: l_instrument_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type;

1005: chr_dtls_rec chr_dtls_csr%ROWTYPE;
1006: instr_type_rec instr_type_csr%ROWTYPE;
1007: l_vendor_bank_rec c_vendor_bank_csr%ROWTYPE;
1008: l_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
1009: l_instrument_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type;
1010: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;
1011: l_payment_method_id okc_rules_b.object1_id1%type;
1012: l_receipt_method_id RA_CUST_RECEIPT_METHODS.RECEIPT_METHOD_ID%TYPE;
1013: l_creation_method AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;

Line 1010: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;

1006: instr_type_rec instr_type_csr%ROWTYPE;
1007: l_vendor_bank_rec c_vendor_bank_csr%ROWTYPE;
1008: l_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
1009: l_instrument_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type;
1010: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;
1011: l_payment_method_id okc_rules_b.object1_id1%type;
1012: l_receipt_method_id RA_CUST_RECEIPT_METHODS.RECEIPT_METHOD_ID%TYPE;
1013: l_creation_method AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
1014: l_vend_pmt_mth_acct_rec c_vendor_payment_method%ROWTYPE;

Line 1020: l_instrument_type IBY_PMT_INSTR_USES_ALL.INSTRUMENT_TYPE%TYPE DEFAULT NULL;

1016: l_vend_pmt_ins_acct_rec c_vendor_payment_instrument%ROWTYPE;
1017: l_vend_pmt_ins_site_rec c_vendor_payment_instrument%ROWTYPE;
1018: l_vend_acct_pmt_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1019: l_vend_site_pmt_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1020: l_instrument_type IBY_PMT_INSTR_USES_ALL.INSTRUMENT_TYPE%TYPE DEFAULT NULL;
1021: l_vend_payment_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1022:
1023: l_vend_pmt_mth_acct_found BOOLEAN := FALSE;
1024: l_vend_pmt_mth_site_found BOOLEAN := FALSE;

Line 1537: FROM iby_pmt_instr_uses_all ipiu

1533: IS
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:

Line 1597: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,

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,
1599: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%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,

Line 1602: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS

1598: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1599: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%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

Line 1604: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay,iby_fndcpt_pmt_chnnls_vl fpc

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

Line 1617: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,

1613: AND fpc.instrument_type = ibyinstr.instrument_type;*/
1614:
1615: -- bug 11886651
1616: CURSOR instrument_payment_use_id_csr(
1617: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
1618: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1619: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1620: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1621: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE

Line 1622: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE

1618: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1619: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1620: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1621: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE
1622: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE
1623: ) IS
1624: SELECT instr_assignment_id,
1625: fpc.payment_channel_code
1626: FROM iby_fndcpt_payer_assgn_instr_v ibyinstr,

Line 1639: l_instrument_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type;

1635: AND fpc.instrument_type = ibyinstr.instrument_type
1636: AND fpc.payment_channel_code in ('BANK_ACCT_XFER','CREDIT_CARD');
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 (

Line 1667: cursor instrument_id_csr (p_instr_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type)

1663: )
1664: and p_trx_date between NVL(assignment_start_date,p_trx_date)
1665: and NVL(assignment_end_date,p_trx_date);
1666:
1667: cursor instrument_id_csr (p_instr_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type)
1668: is
1669: select instrument_id
1670: from iby_pmt_instr_uses_all
1671: where instrument_payment_use_id = p_instr_payment_use_id;

Line 1670: from iby_pmt_instr_uses_all

1666:
1667: cursor instrument_id_csr (p_instr_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type)
1668: is
1669: select instrument_id
1670: from iby_pmt_instr_uses_all
1671: where instrument_payment_use_id = p_instr_payment_use_id;
1672:
1673: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;
1674:

Line 1673: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;

1669: select instrument_id
1670: from iby_pmt_instr_uses_all
1671: where instrument_payment_use_id = p_instr_payment_use_id;
1672:
1673: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;
1674:
1675: BEGIN
1676:
1677: x_return_status := Okl_Api.G_RET_STS_SUCCESS;