DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 4: G_CHR_CURRENCY_CODE OKL_K_HEADERS_FULL_V.currency_code%TYPE;

1: PACKAGE BODY OKL_ACTIVATE_ASSET_PVT as
2: /* $Header: OKLRACAB.pls 120.53.12020000.2 2013/03/07 05:09:57 racheruv ship $ */
3: G_PKG_NAME VARCHAR2(100) := 'OKL_ACTIVATE_ASSET_PVT';
4: G_CHR_CURRENCY_CODE OKL_K_HEADERS_FULL_V.currency_code%TYPE;
5: G_FUNC_CURRENCY_CODE OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6: G_CHR_AUTHORING_ORG_ID OKL_K_HEADERS_FULL_V.authoring_org_id%TYPE;
7: G_CHR_START_DATE DATE;
8: G_CHR_REPORT_PDT_ID OKL_PRODUCTS_V.reporting_pdt_id%TYPE;

Line 5: G_FUNC_CURRENCY_CODE OKL_K_HEADERS_FULL_V.currency_code%TYPE;

1: PACKAGE BODY OKL_ACTIVATE_ASSET_PVT as
2: /* $Header: OKLRACAB.pls 120.53.12020000.2 2013/03/07 05:09:57 racheruv ship $ */
3: G_PKG_NAME VARCHAR2(100) := 'OKL_ACTIVATE_ASSET_PVT';
4: G_CHR_CURRENCY_CODE OKL_K_HEADERS_FULL_V.currency_code%TYPE;
5: G_FUNC_CURRENCY_CODE OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6: G_CHR_AUTHORING_ORG_ID OKL_K_HEADERS_FULL_V.authoring_org_id%TYPE;
7: G_CHR_START_DATE DATE;
8: G_CHR_REPORT_PDT_ID OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
9:

Line 6: G_CHR_AUTHORING_ORG_ID OKL_K_HEADERS_FULL_V.authoring_org_id%TYPE;

2: /* $Header: OKLRACAB.pls 120.53.12020000.2 2013/03/07 05:09:57 racheruv ship $ */
3: G_PKG_NAME VARCHAR2(100) := 'OKL_ACTIVATE_ASSET_PVT';
4: G_CHR_CURRENCY_CODE OKL_K_HEADERS_FULL_V.currency_code%TYPE;
5: G_FUNC_CURRENCY_CODE OKL_K_HEADERS_FULL_V.currency_code%TYPE;
6: G_CHR_AUTHORING_ORG_ID OKL_K_HEADERS_FULL_V.authoring_org_id%TYPE;
7: G_CHR_START_DATE DATE;
8: G_CHR_REPORT_PDT_ID OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
9:
10: --------------------------------------------------------------------------------

Line 461: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

457: l_api_name CONSTANT VARCHAR2(30) := 'CONVERT_2FUNCT_CURRENCY';
458: l_api_version CONSTANT NUMBER := 1.0;
459:
460:
461: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
462: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
463:
464: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
465: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

Line 462: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

458: l_api_version CONSTANT NUMBER := 1.0;
459:
460:
461: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
462: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
463:
464: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
465: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
466: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 464: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

460:
461: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
462: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
463:
464: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
465: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
466: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
467: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
468:

Line 465: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

461: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
462: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
463:
464: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
465: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
466: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
467: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
468:
469: BEGIN

Line 466: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

462: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
463:
464: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
465: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
466: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
467: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
468:
469: BEGIN
470: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 467: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

463:
464: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
465: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
466: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
467: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
468:
469: BEGIN
470: x_return_status := OKL_API.G_RET_STS_SUCCESS;
471: --call start activity to set savepoint

Line 3209: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

3205: x_khrv_rec okl_contract_pub.khrv_rec_type;
3206:
3207: l_bk_dfs_rec bk_dfs_csr%ROWTYPE;
3208:
3209: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3210: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3211:
3212: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3213: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

Line 3210: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

3206:
3207: l_bk_dfs_rec bk_dfs_csr%ROWTYPE;
3208:
3209: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3210: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3211:
3212: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3213: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3214: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 3212: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

3208:
3209: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3210: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3211:
3212: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3213: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3214: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
3215: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3216:

Line 3213: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

3209: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3210: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3211:
3212: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3213: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3214: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
3215: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3216:
3217: --Bug# 3156924 :

Line 3214: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

3210: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3211:
3212: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3213: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3214: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
3215: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3216:
3217: --Bug# 3156924 :
3218: --cursor to fetch transaction number from okl_trx_assets

Line 3215: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

3211:
3212: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3213: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3214: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
3215: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3216:
3217: --Bug# 3156924 :
3218: --cursor to fetch transaction number from okl_trx_assets
3219: cursor l_tas_csr(p_tas_id in number) is

Line 5329: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

5325:
5326: l_hdr_rec l_hdr_csr%ROWTYPE;
5327:
5328: -- Bug# 5174778
5329: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
5330:
5331: -- Bug# 5207066
5332: l_unit_difference number;
5333: