DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_SYSTEM_PARAMS_ALL

Line 7815: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,

7811: PROCEDURE Create_Repo_asset_2(
7812: p_init_msg_list IN VARCHAR2,
7813: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
7814: p_kle_id IN OKL_K_LINES.ID%TYPE,
7815: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
7816: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
7817: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
7818: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
7819: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,

Line 7816: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,

7812: p_init_msg_list IN VARCHAR2,
7813: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
7814: p_kle_id IN OKL_K_LINES.ID%TYPE,
7815: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
7816: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
7817: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
7818: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
7819: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
7820: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,

Line 7817: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,

7813: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
7814: p_kle_id IN OKL_K_LINES.ID%TYPE,
7815: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
7816: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
7817: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
7818: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
7819: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
7820: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
7821: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,

Line 7818: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,

7814: p_kle_id IN OKL_K_LINES.ID%TYPE,
7815: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
7816: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
7817: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
7818: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
7819: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
7820: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
7821: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
7822: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,

Line 7819: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,

7815: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
7816: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
7817: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
7818: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
7819: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
7820: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
7821: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
7822: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
7823: p_line_number IN NUMBER,

Line 7820: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,

7816: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
7817: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
7818: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
7819: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
7820: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
7821: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
7822: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
7823: p_line_number IN NUMBER,
7824: p_quote_id IN NUMBER,

Line 7821: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,

7817: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
7818: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
7819: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
7820: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
7821: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
7822: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
7823: p_line_number IN NUMBER,
7824: p_quote_id IN NUMBER,
7825: x_return_status OUT NOCOPY VARCHAR2,

Line 8301: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,

8297: PROCEDURE Populate_Sources(p_api_version IN NUMBER,
8298: p_init_msg_list IN VARCHAR2,
8299: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8300: p_kle_id IN OKL_K_LINES.ID%TYPE,
8301: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8302: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8303: p_tal_id IN NUMBER,
8304: p_line_type IN VARCHAR2,
8305: p_fa_trx_id IN NUMBER,

Line 8411: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,

8407: PROCEDURE Create_Repo_asset(
8408: p_init_msg_list IN VARCHAR2,
8409: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8410: p_kle_id IN OKL_K_LINES.ID%TYPE,
8411: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8412: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8413: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
8414: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
8415: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,

Line 8412: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,

8408: p_init_msg_list IN VARCHAR2,
8409: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8410: p_kle_id IN OKL_K_LINES.ID%TYPE,
8411: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8412: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8413: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
8414: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
8415: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
8416: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,

Line 8413: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,

8409: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8410: p_kle_id IN OKL_K_LINES.ID%TYPE,
8411: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8412: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8413: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
8414: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
8415: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
8416: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
8417: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,

Line 8414: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,

8410: p_kle_id IN OKL_K_LINES.ID%TYPE,
8411: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8412: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8413: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
8414: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
8415: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
8416: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
8417: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
8418: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,

Line 8415: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,

8411: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8412: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8413: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
8414: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
8415: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
8416: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
8417: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
8418: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8419: p_line_number IN NUMBER,

Line 8416: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,

8412: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8413: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
8414: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
8415: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
8416: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
8417: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
8418: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8419: p_line_number IN NUMBER,
8420: p_quote_id IN NUMBER,

Line 8417: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,

8413: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
8414: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,
8415: p_fa_location_id IN OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE,
8416: p_asset_key_id IN OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE,
8417: p_depreciate_yn IN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE,
8418: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8419: p_line_number IN NUMBER,
8420: p_quote_id IN NUMBER,
8421: x_return_status OUT NOCOPY VARCHAR2,

Line 9121: FROM OKL_SYSTEM_PARAMS_ALL

9117: RPT_PROD_BOOK_TYPE_CODE,
9118: FA_LOCATION_ID,
9119: ASSET_KEY_ID,
9120: DEPRECIATE_YN
9121: FROM OKL_SYSTEM_PARAMS_ALL
9122: WHERE ORG_ID = p_org_id;
9123:
9124: l_corporate_book OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE;
9125: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE;

Line 9124: l_corporate_book OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE;

9120: DEPRECIATE_YN
9121: FROM OKL_SYSTEM_PARAMS_ALL
9122: WHERE ORG_ID = p_org_id;
9123:
9124: l_corporate_book OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE;
9125: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE;
9126: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE;
9127: l_rep_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
9128: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE;

Line 9125: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE;

9121: FROM OKL_SYSTEM_PARAMS_ALL
9122: WHERE ORG_ID = p_org_id;
9123:
9124: l_corporate_book OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE;
9125: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE;
9126: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE;
9127: l_rep_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
9128: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE;
9129: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE;

Line 9126: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE;

9122: WHERE ORG_ID = p_org_id;
9123:
9124: l_corporate_book OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE;
9125: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE;
9126: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE;
9127: l_rep_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
9128: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE;
9129: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE;
9130: l_depreciate_yn OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE;

Line 9127: l_rep_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;

9123:
9124: l_corporate_book OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE;
9125: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE;
9126: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE;
9127: l_rep_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
9128: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE;
9129: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE;
9130: l_depreciate_yn OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE;
9131:

Line 9128: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE;

9124: l_corporate_book OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE;
9125: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE;
9126: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE;
9127: l_rep_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
9128: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE;
9129: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE;
9130: l_depreciate_yn OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE;
9131:
9132: CURSOR try_id_csr(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS

Line 9129: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE;

9125: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE;
9126: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE;
9127: l_rep_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
9128: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE;
9129: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE;
9130: l_depreciate_yn OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE;
9131:
9132: CURSOR try_id_csr(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
9133: SELECT id

Line 9130: l_depreciate_yn OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE;

9126: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE;
9127: l_rep_book OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
9128: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%TYPE;
9129: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%TYPE;
9130: l_depreciate_yn OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%TYPE;
9131:
9132: CURSOR try_id_csr(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
9133: SELECT id
9134: FROM OKL_TRX_TYPES_tl