DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on AR_RECEIPT_CLASSES

Line 65: l_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;

61: -- -----------------------------------------------------
62: -- Variable definitions for line level bill-to_support
63: -- -----------------------------------------------------
64: l_pmth_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
65: l_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
66: lp_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
67: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
68:
69: l_line_cust_bank_acct_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;

Line 66: lp_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;

62: -- Variable definitions for line level bill-to_support
63: -- -----------------------------------------------------
64: l_pmth_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
65: l_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
66: lp_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
67: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
68:
69: l_line_cust_bank_acct_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;
70: l_line_cust_address_id OKL_TRX_AR_INVOICES_V.ibt_id%TYPE;

Line 148: AR_RECEIPT_CLASSES C

144: -- Bank Account Cursor
145: CURSOR rcpt_method_csr ( p_rct_method_id NUMBER) IS
146: SELECT C.CREATION_METHOD_CODE
147: FROM AR_RECEIPT_METHODS M,
148: AR_RECEIPT_CLASSES C
149: WHERE M.RECEIPT_CLASS_ID = C.RECEIPT_CLASS_ID AND
150: M.receipt_method_id = p_rct_method_id;
151:
152: CURSOR cust_line_bank_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS

Line 942: AR_RECEIPT_CLASSES C

938:
939: CURSOR c_receipt_method ( p_rct_method_id NUMBER) IS
940: SELECT C.CREATION_METHOD_CODE, M.PAYMENT_CHANNEL_CODE
941: FROM AR_RECEIPT_METHODS M,
942: AR_RECEIPT_CLASSES C
943: WHERE M.RECEIPT_CLASS_ID = C.RECEIPT_CLASS_ID AND
944: M.receipt_method_id = p_rct_method_id;
945:
946: --Get primary active vendor payment method from customer account or from site.

Line 1013: l_creation_method AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%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;
1015: l_vend_pmt_mth_site_rec c_vendor_payment_method%ROWTYPE;
1016: l_vend_pmt_ins_acct_rec c_vendor_payment_instrument%ROWTYPE;
1017: l_vend_pmt_ins_site_rec c_vendor_payment_instrument%ROWTYPE;

Line 2443: l_creation_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;

2439: --akrangan added ebtax billing impacts coding end
2440:
2441: lx_dist_tbl dist_tbl_type; -- rmunjulu R12 Fixes
2442: n NUMBER; -- rmunjulu R12 Fixes
2443: l_creation_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
2444:
2445: -- gboomina added for bug 7513216 - start
2446: cursor get_khr_id_csr (p_contract_number okc_k_headers_all_b.contract_number%type)
2447: is

Line 2468: AR_RECEIPT_CLASSES C

2464: -- sosharma for bug 9871252
2465: CURSOR rcpt_cr_method_csr ( p_rct_method_id NUMBER) IS
2466: SELECT C.CREATION_METHOD_CODE
2467: FROM AR_RECEIPT_METHODS M,
2468: AR_RECEIPT_CLASSES C
2469: WHERE M.RECEIPT_CLASS_ID = C.RECEIPT_CLASS_ID AND
2470: M.receipt_method_id = p_rct_method_id;
2471:
2472: rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;

Line 2472: rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;

2468: AR_RECEIPT_CLASSES C
2469: WHERE M.RECEIPT_CLASS_ID = C.RECEIPT_CLASS_ID AND
2470: M.receipt_method_id = p_rct_method_id;
2471:
2472: rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
2473:
2474: -- Bug#9576651 - Start
2475: -- Define error table
2476: type error_tai_tbl_type IS TABLE OF NUMBER