APPS.OKL_AM_INVOICES_PVT dependencies on OKL_SYSTEM_PARAMS

Line 1500: -- is Y in OKL_SYSTEM_PARAMS_ALL

1496: -- History : RMUNJULU 30-DEC-02 2726739 Changed cursor and taiv_rec
1497: -- to set currency columns
1498: -- : PAGARG 4044659 25-Jan-2005 Obtain inventory org id from
1499: -- contract and assign it to tilv_rec if LEASE_INV_ORG_YN
1500: -- is Y in OKL_SYSTEM_PARAMS_ALL
1501: -- : PAGARG 14-Feb-2005 Bug 3559535, pass l_vendor_status in call
1502: -- to get_vendor_billing_info and based on the value of l_vendor_status
1503: -- set the value for l_return_status
1504: -- End of comments

Line 1568: FROM OKL_SYSTEM_PARAMS;

1564: l_part_name VARCHAR2(200);
1565: --PAGARG Bug 4044659 Cursor to obtain operational options values
1566: CURSOR l_sys_prms_csr IS
1567: SELECT NVL(LEASE_INV_ORG_YN, 'N') LEASE_INV_ORG_YN
1568: FROM OKL_SYSTEM_PARAMS;
1569: l_sys_prms_rec l_sys_prms_csr%ROWTYPE;
1570:
1571: -- RRAVIKIR Legal Entity Changes
1572: CURSOR l_assetreturns_csr(cp_kle_id IN NUMBER) IS

Line 2241: -- if LEASE_INV_ORG_YN is Y in OKL_SYSTEM_PARAMS_ALL

2237: -- : SECHAWLA 01-NOV-04 3967398 : create remarket invoice for remarket item
2238: -- : rmunjulu bug 4056364 Removed Quote line alloc message
2239: -- : PAGARG 4044659 25-Jan-2005 Assign order lines' or header's
2240: -- sold_from_org_id and assign it to tilv_rec.inventory_org_id
2241: -- if LEASE_INV_ORG_YN is Y in OKL_SYSTEM_PARAMS_ALL
2242: -- : rmunjulu 3985369 Added code to get Ship_From Org Id from the order lines and
2243: -- pass as inventory_org_id when creating invoice transaction lines
2244: -- End of comments
2245:

Line 2305: FROM OKL_SYSTEM_PARAMS ;

2301: -- PAGARG 26-Jan-2005 Bug 4044659 Querying LEASE_INV_ORG_YN also.
2302: CURSOR l_systemparamsall_csr IS
2303: SELECT REMK_ITEM_INVOICED_CODE
2304: ,NVL(LEASE_INV_ORG_YN, 'N') LEASE_INV_ORG_YN
2305: FROM OKL_SYSTEM_PARAMS ;
2306:
2307: l_remk_item_invoiced VARCHAR2(15);
2308: l_inventory_item_id NUMBER;
2309: -- PAGARG 26-Jan-2005 Bug 4044659 variable to store the value of LEASE_INV_ORG_YN

Line 2310: l_lease_inv_org_yn OKL_SYSTEM_PARAMS_ALL.lease_inv_org_yn%TYPE;

2306:
2307: l_remk_item_invoiced VARCHAR2(15);
2308: l_inventory_item_id NUMBER;
2309: -- PAGARG 26-Jan-2005 Bug 4044659 variable to store the value of LEASE_INV_ORG_YN
2310: l_lease_inv_org_yn OKL_SYSTEM_PARAMS_ALL.lease_inv_org_yn%TYPE;
2311:
2312:
2313: l_art_rec l_art_csr%ROWTYPE;
2314: l_til_rec l_til_csr%ROWTYPE;

Line 3361: -- is Y in OKL_SYSTEM_PARAMS_ALL

3357: -- : rmunjulu EDAT 07-DEC-04 Set pos and neg amts properly
3358: -- : rmunjulu 4056364 09-DEC-04 Modified to not set Quote Line Allocation message
3359: -- : PAGARG 4044659 25-Jan-2005 Obtain inventory org id from
3360: -- contract and assign it to tilv_rec if LEASE_INV_ORG_YN
3361: -- is Y in OKL_SYSTEM_PARAMS_ALL
3362: -- : rmunjulu 27-Jan-05 3985369 Modified to set inv_org_id
3363: -- when creating transaction for billing adjustment line
3364: -- : rmunjulu 3985369 Modified get_qte_dtls_csr cursor
3365: -- : rmunjulu sales tax enhancement, set quote line id in tilv_rec/tilv_tbl

Line 3523: FROM OKL_SYSTEM_PARAMS;

3519:
3520: --PAGARG Bug 4044659 Cursor to obtain operational options values
3521: CURSOR l_sys_prms_csr IS
3522: SELECT NVL(LEASE_INV_ORG_YN, 'N') LEASE_INV_ORG_YN
3523: FROM OKL_SYSTEM_PARAMS;
3524: l_sys_prms_rec l_sys_prms_csr%ROWTYPE;
3525:
3526: -- rmunjulu 3985369
3527: l_inv_org_id NUMBER;

Line 4529: FROM OKL_SYSTEM_PARAMS;

4525: --+++++++++++++++++++++ rmunjulu 4547765 ++++++++++++++++++++++++++++++++
4526: -- Cursor to obtain operational options values
4527: CURSOR l_sys_prms_csr IS
4528: SELECT NVL(LEASE_INV_ORG_YN, 'N') LEASE_INV_ORG_YN
4529: FROM OKL_SYSTEM_PARAMS;
4530:
4531: -- Get the quote line meaning for BILL_ADJST
4532: CURSOR get_qte_ln_meaning_csr IS
4533: SELECT fnd.meaning meaning