APPS.OKL_AM_INVOICES_PVT dependencies on OKL_SYSTEM_PARAMS

Line 1602: -- is Y in OKL_SYSTEM_PARAMS_ALL

1598: -- History : RMUNJULU 30-DEC-02 2726739 Changed cursor and taiv_rec
1599: -- to set currency columns
1600: -- : PAGARG 4044659 25-Jan-2005 Obtain inventory org id from
1601: -- contract and assign it to tilv_rec if LEASE_INV_ORG_YN
1602: -- is Y in OKL_SYSTEM_PARAMS_ALL
1603: -- : PAGARG 14-Feb-2005 Bug 3559535, pass l_vendor_status in call
1604: -- to get_vendor_billing_info and based on the value of l_vendor_status
1605: -- set the value for l_return_status
1606: -- End of comments

Line 1670: FROM OKL_SYSTEM_PARAMS;

1666: l_part_name VARCHAR2(200);
1667: --PAGARG Bug 4044659 Cursor to obtain operational options values
1668: CURSOR l_sys_prms_csr IS
1669: SELECT NVL(LEASE_INV_ORG_YN, 'N') LEASE_INV_ORG_YN
1670: FROM OKL_SYSTEM_PARAMS;
1671: l_sys_prms_rec l_sys_prms_csr%ROWTYPE;
1672:
1673: -- RRAVIKIR Legal Entity Changes
1674: CURSOR l_assetreturns_csr(cp_kle_id IN NUMBER) IS

Line 2343: -- if LEASE_INV_ORG_YN is Y in OKL_SYSTEM_PARAMS_ALL

2339: -- : SECHAWLA 01-NOV-04 3967398 : create remarket invoice for remarket item
2340: -- : rmunjulu bug 4056364 Removed Quote line alloc message
2341: -- : PAGARG 4044659 25-Jan-2005 Assign order lines' or header's
2342: -- sold_from_org_id and assign it to tilv_rec.inventory_org_id
2343: -- if LEASE_INV_ORG_YN is Y in OKL_SYSTEM_PARAMS_ALL
2344: -- : rmunjulu 3985369 Added code to get Ship_From Org Id from the order lines and
2345: -- pass as inventory_org_id when creating invoice transaction lines
2346: -- End of comments
2347:

Line 2411: FROM OKL_SYSTEM_PARAMS ;

2407: -- PAGARG 26-Jan-2005 Bug 4044659 Querying LEASE_INV_ORG_YN also.
2408: CURSOR l_systemparamsall_csr IS
2409: SELECT REMK_ITEM_INVOICED_CODE
2410: ,NVL(LEASE_INV_ORG_YN, 'N') LEASE_INV_ORG_YN
2411: FROM OKL_SYSTEM_PARAMS ;
2412:
2413: l_remk_item_invoiced VARCHAR2(15);
2414: l_inventory_item_id NUMBER;
2415: -- PAGARG 26-Jan-2005 Bug 4044659 variable to store the value of LEASE_INV_ORG_YN

Line 2416: l_lease_inv_org_yn OKL_SYSTEM_PARAMS_ALL.lease_inv_org_yn%TYPE;

2412:
2413: l_remk_item_invoiced VARCHAR2(15);
2414: l_inventory_item_id NUMBER;
2415: -- PAGARG 26-Jan-2005 Bug 4044659 variable to store the value of LEASE_INV_ORG_YN
2416: l_lease_inv_org_yn OKL_SYSTEM_PARAMS_ALL.lease_inv_org_yn%TYPE;
2417:
2418:
2419: l_art_rec l_art_csr%ROWTYPE;
2420: l_til_rec l_til_csr%ROWTYPE;

Line 3467: -- is Y in OKL_SYSTEM_PARAMS_ALL

3463: -- : rmunjulu EDAT 07-DEC-04 Set pos and neg amts properly
3464: -- : rmunjulu 4056364 09-DEC-04 Modified to not set Quote Line Allocation message
3465: -- : PAGARG 4044659 25-Jan-2005 Obtain inventory org id from
3466: -- contract and assign it to tilv_rec if LEASE_INV_ORG_YN
3467: -- is Y in OKL_SYSTEM_PARAMS_ALL
3468: -- : rmunjulu 27-Jan-05 3985369 Modified to set inv_org_id
3469: -- when creating transaction for billing adjustment line
3470: -- : rmunjulu 3985369 Modified get_qte_dtls_csr cursor
3471: -- : rmunjulu sales tax enhancement, set quote line id in tilv_rec/tilv_tbl

Line 3629: FROM OKL_SYSTEM_PARAMS;

3625:
3626: --PAGARG Bug 4044659 Cursor to obtain operational options values
3627: CURSOR l_sys_prms_csr IS
3628: SELECT NVL(LEASE_INV_ORG_YN, 'N') LEASE_INV_ORG_YN
3629: FROM OKL_SYSTEM_PARAMS;
3630: l_sys_prms_rec l_sys_prms_csr%ROWTYPE;
3631:
3632: -- rmunjulu 3985369
3633: l_inv_org_id NUMBER;

Line 4642: FROM OKL_SYSTEM_PARAMS;

4638: --+++++++++++++++++++++ rmunjulu 4547765 ++++++++++++++++++++++++++++++++
4639: -- Cursor to obtain operational options values
4640: CURSOR l_sys_prms_csr IS
4641: SELECT NVL(LEASE_INV_ORG_YN, 'N') LEASE_INV_ORG_YN
4642: FROM OKL_SYSTEM_PARAMS;
4643:
4644: -- Get the quote line meaning for BILL_ADJST
4645: CURSOR get_qte_ln_meaning_csr IS
4646: SELECT fnd.meaning meaning