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 OKC_RULES_B

Line 64: l_pmth_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

60: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
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:

Line 67: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

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;
71: l_line_receipt_method_id OKL_TRX_AR_INVOICES_V.irm_id%TYPE;

Line 114: FROM OKC_RULES_B rul,

110: AND khr.bill_to_site_use_id = cp.site_use_id(+);
111:
112: CURSOR cust_line_pmth_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
113: SELECT object1_id1
114: FROM OKC_RULES_B rul,
115: Okc_rule_groups_B rgp
116: WHERE rul.rgp_id = rgp.id AND
117: rgp.rgd_code = 'LABILL' AND
118: rgp.cle_id = p_kle_id AND

Line 126: , OKC_RULES_B rul

122: SELECT rul.object1_id1
123: FROM okc_k_lines_b cle
124: , okc_k_items_v item
125: , okc_k_lines_b linked_asset
126: , OKC_RULES_B rul
127: , Okc_rule_groups_B rgp
128: WHERE cle.dnz_chr_id = p_khr_id AND
129: cle.id = p_kle_id AND
130: cle.chr_id IS NULL AND

Line 154: FROM OKC_RULES_B rul,

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
153: SELECT object1_id1
154: FROM OKC_RULES_B rul,
155: Okc_rule_groups_B rgp
156: WHERE rul.rgp_id = rgp.id AND
157: rgp.cle_id = p_kle_id AND
158: rgp.rgd_code = 'LABILL' AND

Line 166: , OKC_RULES_B rul

162: SELECT rul.object1_id1
163: FROM okc_k_lines_b cle
164: , okc_k_items_v item
165: , okc_k_lines_b linked_asset
166: , OKC_RULES_B rul
167: , Okc_rule_groups_B rgp
168: WHERE cle.dnz_chr_id = p_khr_id AND
169: cle.id = p_kle_id AND
170: cle.chr_id IS NULL AND

Line 803: FROM OKC_RULES_B rul,

799: -- correctly when there are multiple vendors
800: -- on a contract
801: CURSOR c_vendor_bank_csr ( cp_khr_id NUMBER, cp_cust_acct_id NUMBER) IS
802: SELECT rul.object1_id1
803: FROM OKC_RULES_B rul,
804: Okc_rule_groups_B rgp,
805: Okc_rg_party_roles rpr,
806: Okc_k_party_roles_b cpl
807: WHERE rul.rgp_id = rgp.id AND

Line 918: FROM OKC_RULES_B rul,

914: -- correctly when there are multiple vendors
915: -- on a contract
916: CURSOR c_ven_payment_method(p_khr_id NUMBER, p_cust_acct_id NUMBER) IS
917: SELECT rul.object1_id1
918: FROM OKC_RULES_B rul,
919: Okc_rule_groups_B rgp,
920: Okc_rg_party_roles rpr,
921: Okc_k_party_roles_b cpl
922: WHERE rul.rgp_id = rgp.id AND

Line 1011: l_payment_method_id okc_rules_b.object1_id1%type;

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;
1015: l_vend_pmt_mth_site_rec c_vendor_payment_method%ROWTYPE;

Line 1516: l_bank_id okc_rules_b.object1_id1%TYPE := NULL;

1512: x_msg_data OUT NOCOPY VARCHAR2
1513:
1514: ) IS
1515: -- BANK-ACCOUNT-UPTAKE-START
1516: l_bank_id okc_rules_b.object1_id1%TYPE := NULL;
1517: l_return_status VARCHAR2(1);
1518: l_msg_count NUMBER;
1519: l_msg_data VARCHAR2(32767);
1520:

Line 1563: FROM OKC_RULES_B rul,

1559:
1560: -- Fetch the Contract Level Bank Id
1561: CURSOR cust_bank_csr ( cp_khr_id NUMBER ) IS
1562: SELECT object1_id1
1563: FROM OKC_RULES_B rul,
1564: Okc_rule_groups_B rgp
1565: WHERE rul.rgp_id = rgp.id AND
1566: rgp.rgd_code = 'LABILL' AND
1567: rgp.dnz_chr_id = rgp.chr_id AND

Line 1913: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

1909: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1910: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1911: l_invoice_group okl_invoice_formats_v.name%type;
1912: l_khr_id okc_k_headers_b.id%type;
1913: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
1914:
1915:
1916: CURSOR acc_sys_option is
1917: select account_derivation