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.49.12010000.3 2009/01/15 20:51:16 smereddy 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.49.12010000.3 2009/01/15 20:51:16 smereddy 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.49.12010000.3 2009/01/15 20:51:16 smereddy 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 3200: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

3196: x_khrv_rec okl_contract_pub.khrv_rec_type;
3197:
3198: l_bk_dfs_rec bk_dfs_csr%ROWTYPE;
3199:
3200: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3201: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3202:
3203: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3204: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

Line 3201: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

3197:
3198: l_bk_dfs_rec bk_dfs_csr%ROWTYPE;
3199:
3200: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3201: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3202:
3203: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3204: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3205: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 3203: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

3199:
3200: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3201: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3202:
3203: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3204: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3205: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
3206: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3207:

Line 3204: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

3200: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3201: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3202:
3203: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3204: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3205: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
3206: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3207:
3208: --Bug# 3156924 :

Line 3205: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

3201: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
3202:
3203: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3204: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3205: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
3206: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3207:
3208: --Bug# 3156924 :
3209: --cursor to fetch transaction number from okl_trx_assets

Line 3206: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

3202:
3203: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
3204: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3205: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
3206: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3207:
3208: --Bug# 3156924 :
3209: --cursor to fetch transaction number from okl_trx_assets
3210: cursor l_tas_csr(p_tas_id in number) is

Line 5369: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

5365:
5366: l_hdr_rec l_hdr_csr%ROWTYPE;
5367:
5368: -- Bug# 5174778
5369: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
5370:
5371: -- Bug# 5207066
5372: l_unit_difference number;
5373: