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 755: l_bank_id okc_rules_b.object1_id1%TYPE := NULL;

751: x_msg_data OUT NOCOPY VARCHAR2
752:
753: ) IS
754: -- BANK-ACCOUNT-UPTAKE-START
755: l_bank_id okc_rules_b.object1_id1%TYPE := NULL;
756: l_return_status VARCHAR2(1);
757: l_msg_count NUMBER;
758: l_msg_data VARCHAR2(32767);
759:

Line 800: FROM OKC_RULES_B rul,

796:
797: -- Fetch the Contract Level Bank Id
798: CURSOR cust_bank_csr ( cp_khr_id NUMBER ) IS
799: SELECT object1_id1
800: FROM OKC_RULES_B rul,
801: Okc_rule_groups_B rgp
802: WHERE rul.rgp_id = rgp.id AND
803: rgp.rgd_code = 'LABILL' AND
804: rgp.dnz_chr_id = rgp.chr_id AND

Line 1062: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

1058: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1059: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1060: l_invoice_group okl_invoice_formats_v.name%type;
1061: l_khr_id okc_k_headers_b.id%type;
1062: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
1063:
1064:
1065: CURSOR acc_sys_option is
1066: select account_derivation