eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKL_K_HEADERS

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 3149: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

3145:
3146:
3147: --end-----------cursor definitions----------------------------------------------
3148:
3149: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
3150: l_talv_rec_in talv_rec_type;
3151: l_cimv_rec_in cimv_rec_type;
3152: l_cimv_rec_out cimv_rec_type;
3153: l_talv_rec talv_rec_type;

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 4630: OKL_K_HEADERS khr

4626: --11.5.9(Multi GAAP)
4627: khr.PDT_ID,
4628: chr.START_DATE
4629: From OKC_K_HEADERS_B chr,
4630: OKL_K_HEADERS khr
4631: WHERE khr.id = chr.id
4632: AND chr.ID = P_CHRV_ID;
4633:
4634: --cursor for fetching passed fixed asset lines

Line 5034: OKL_K_HEADERS khr,

5030: chr.start_date,
5031: --Bug# 3156924
5032: ktrx.trx_number
5033: FROM OKC_RULES_B rul,
5034: OKL_K_HEADERS khr,
5035: OKC_K_HEADERS_B chr,
5036: OKL_TRX_CONTRACTS ktrx,
5037: OKC_K_HEADERS_B rbk_chr
5038: WHERE rul.dnz_chr_id = chr.id

Line 5057: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

5053: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
5054: AND rbk_chr.id = p_rbk_chr_id;
5055:
5056: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
5057: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
5058: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
5059: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
5060: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
5061: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;

Line 5063: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;

5059: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
5060: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
5061: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
5062: --Bug# : 11.5.9 enhancement Multi GAAP
5063: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;
5064: l_start_date Date;
5065: l_rep_pdt_id Number;
5066: l_pdt_tax_owner Varchar2(150);
5067: l_rep_deal_type Varchar2(150);

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:

Line 6329: OKL_K_HEADERS khr,

6325: chr.start_date,
6326: --Bug# 3156924
6327: ktrx.trx_number
6328: FROM OKC_RULES_B rul,
6329: OKL_K_HEADERS khr,
6330: OKC_K_HEADERS_B chr,
6331: OKL_TRX_CONTRACTS ktrx
6332: WHERE rul.dnz_chr_id = chr.id
6333: AND rul.rule_information_category = 'LATOWN'

Line 6350: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

6346: AND ktrx.KHR_ID_NEW is null
6347: AND ktrx.tsu_code = G_TSU_CODE_ENTERED;
6348:
6349: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
6350: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
6351: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
6352: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
6353: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
6354: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;

Line 6509: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;

6505: And TRX.tsu_code = 'ENTERED');
6506:
6507: adj_txl_rec adj_txl_csr%ROWTYPE;
6508: --Bug# : 11.5.9 enhancement Multi GAAP
6509: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;
6510: l_start_date Date;
6511: l_rep_pdt_id Number;
6512: l_rep_deal_type Varchar2(150);
6513: l_Multi_GAAP_YN Varchar2(1) := 'N';

Line 7402: OKL_K_HEADERS khr,

7398: chr.start_date,
7399: --Bug# 4631549
7400: chr.orig_system_source_code
7401: FROM OKC_RULES_B rul,
7402: OKL_K_HEADERS khr,
7403: OKC_K_HEADERS_B chr
7404: WHERE rul.dnz_chr_id = chr.id
7405: AND rul.rule_information_category = 'LATOWN'
7406: AND rul.dnz_chr_id = khr.id

Line 7418: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

7414: AND rul_rel_ast.rule_information_category = 'LARLES'
7415: AND nvl(rule_information1,'N') = 'Y');
7416: --Bug#2522439
7417:
7418: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
7419: l_rel_chr_id OKC_K_HEADERS_B.ID%TYPE;
7420: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
7421: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
7422: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 7424: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;

7420: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
7421: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
7422: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
7423: --Bug# : 11.5.9 enhancement Multi GAAP
7424: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;
7425: l_start_date Date;
7426: l_rep_pdt_id Number;
7427: l_rep_deal_type Varchar2(150);
7428: l_Multi_GAAP_YN Varchar2(1) := 'N';

Line 7838: okl_k_headers khr,

7834: --Bug# 3783518
7835: CURSOR orig_pdt_csr(p_cle_id IN NUMBER) is
7836: SELECT pdt.reporting_pdt_id
7837: FROM okc_k_lines_b cle,
7838: okl_k_headers khr,
7839: okl_products pdt
7840: WHERE cle.id = p_cle_id
7841: AND khr.id = cle.dnz_chr_id
7842: AND pdt.id = khr.pdt_id;

Line 9397: okl_k_headers khr,

9393: chrb.start_date,
9394: rul.rule_information1
9395: from okc_rules_b rul,
9396: okc_rule_groups_b rgp,
9397: okl_k_headers khr,
9398: okc_k_headers_b chrb
9399: where rul.rule_information_category = 'LATOWN'
9400: and rul.rgp_id = rgp.id
9401: and rul.dnz_chr_id = rgp.dnz_chr_id

Line 9412: l_deal_type okl_k_headers.deal_type%TYPE;

9408: l_pdt_id number;
9409: l_start_date date;
9410: l_rep_pdt_id number;
9411: l_tax_owner okc_rules_b.rule_information_category%TYPE;
9412: l_deal_type okl_k_headers.deal_type%TYPE;
9413: l_rep_deal_type okl_k_headers.deal_type%TYPE;
9414: l_Multi_GAAP_YN varchar2(1);
9415: l_adjust_asset_to_zero varchar2(1);
9416: l_multi_gaap_book_done varchar2(1);

Line 9413: l_rep_deal_type okl_k_headers.deal_type%TYPE;

9409: l_start_date date;
9410: l_rep_pdt_id number;
9411: l_tax_owner okc_rules_b.rule_information_category%TYPE;
9412: l_deal_type okl_k_headers.deal_type%TYPE;
9413: l_rep_deal_type okl_k_headers.deal_type%TYPE;
9414: l_Multi_GAAP_YN varchar2(1);
9415: l_adjust_asset_to_zero varchar2(1);
9416: l_multi_gaap_book_done varchar2(1);
9417:

Line 11152: okl_k_headers khr,

11148: chrb.start_date,
11149: rul.rule_information1
11150: from okc_rules_b rul,
11151: okc_rule_groups_b rgp,
11152: okl_k_headers khr,
11153: okc_k_headers_b chrb
11154: where rul.rule_information_category = 'LATOWN'
11155: and rul.rgp_id = rgp.id
11156: and rul.dnz_chr_id = rgp.dnz_chr_id

Line 11167: l_deal_type okl_k_headers.deal_type%TYPE;

11163: l_pdt_id number;
11164: l_start_date date;
11165: l_rep_pdt_id number;
11166: l_tax_owner okc_rules_b.rule_information_category%TYPE;
11167: l_deal_type okl_k_headers.deal_type%TYPE;
11168: l_rep_deal_type okl_k_headers.deal_type%TYPE;
11169: l_Multi_GAAP_YN varchar2(1);
11170:
11171: cursor l_tax_book_csr(p_tal_id in number) is

Line 11168: l_rep_deal_type okl_k_headers.deal_type%TYPE;

11164: l_start_date date;
11165: l_rep_pdt_id number;
11166: l_tax_owner okc_rules_b.rule_information_category%TYPE;
11167: l_deal_type okl_k_headers.deal_type%TYPE;
11168: l_rep_deal_type okl_k_headers.deal_type%TYPE;
11169: l_Multi_GAAP_YN varchar2(1);
11170:
11171: cursor l_tax_book_csr(p_tal_id in number) is
11172: select txd.id,