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

3154:
3155:
3156: --end-----------cursor definitions----------------------------------------------
3157:
3158: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
3159: l_talv_rec_in talv_rec_type;
3160: l_cimv_rec_in cimv_rec_type;
3161: l_cimv_rec_out cimv_rec_type;
3162: l_talv_rec talv_rec_type;

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

4635: --11.5.9(Multi GAAP)
4636: khr.PDT_ID,
4637: chr.START_DATE
4638: From OKC_K_HEADERS_B chr,
4639: OKL_K_HEADERS khr
4640: WHERE khr.id = chr.id
4641: AND chr.ID = P_CHRV_ID;
4642:
4643: --cursor for fetching passed fixed asset lines

Line 5043: OKL_K_HEADERS khr,

5039: chr.start_date,
5040: --Bug# 3156924
5041: ktrx.trx_number
5042: FROM OKC_RULES_B rul,
5043: OKL_K_HEADERS khr,
5044: OKC_K_HEADERS_B chr,
5045: OKL_TRX_CONTRACTS ktrx,
5046: OKC_K_HEADERS_B rbk_chr
5047: WHERE rul.dnz_chr_id = chr.id

Line 5066: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

5062: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
5063: AND rbk_chr.id = p_rbk_chr_id;
5064:
5065: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
5066: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
5067: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
5068: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
5069: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
5070: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;

Line 5072: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;

5068: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
5069: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
5070: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
5071: --Bug# : 11.5.9 enhancement Multi GAAP
5072: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;
5073: l_start_date Date;
5074: l_rep_pdt_id Number;
5075: l_pdt_tax_owner Varchar2(150);
5076: l_rep_deal_type Varchar2(150);

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:

Line 6261: OKL_K_HEADERS khr,

6257: chr.start_date,
6258: --Bug# 3156924
6259: ktrx.trx_number
6260: FROM OKC_RULES_B rul,
6261: OKL_K_HEADERS khr,
6262: OKC_K_HEADERS_B chr,
6263: OKL_TRX_CONTRACTS ktrx
6264: WHERE rul.dnz_chr_id = chr.id
6265: AND rul.rule_information_category = 'LATOWN'

Line 6282: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

6278: AND ktrx.KHR_ID_NEW is null
6279: AND ktrx.tsu_code = G_TSU_CODE_ENTERED;
6280:
6281: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
6282: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
6283: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
6284: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
6285: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
6286: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;

Line 6437: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;

6433: And TRX.tsu_code = 'ENTERED');
6434:
6435: adj_txl_rec adj_txl_csr%ROWTYPE;
6436: --Bug# : 11.5.9 enhancement Multi GAAP
6437: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;
6438: l_start_date Date;
6439: l_rep_pdt_id Number;
6440: l_rep_deal_type Varchar2(150);
6441: l_Multi_GAAP_YN Varchar2(1) := 'N';

Line 7118: OKL_K_HEADERS khr,

7114: chr.start_date,
7115: --Bug# 4631549
7116: chr.orig_system_source_code
7117: FROM OKC_RULES_B rul,
7118: OKL_K_HEADERS khr,
7119: OKC_K_HEADERS_B chr
7120: WHERE rul.dnz_chr_id = chr.id
7121: AND rul.rule_information_category = 'LATOWN'
7122: AND rul.dnz_chr_id = khr.id

Line 7143: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

7139: AND cleb.chr_id = chr.id
7140: AND cleb.id = kle.id
7141: AND nvl(kle.re_lease_yn,'N') = 'Y');
7142: --Bug# 15992711 End of Modifications
7143: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
7144: l_rel_chr_id OKC_K_HEADERS_B.ID%TYPE;
7145: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
7146: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
7147: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 7149: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;

7145: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
7146: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
7147: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
7148: --Bug# : 11.5.9 enhancement Multi GAAP
7149: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;
7150: l_start_date Date;
7151: l_rep_pdt_id Number;
7152: l_rep_deal_type Varchar2(150);
7153: l_Multi_GAAP_YN Varchar2(1) := 'N';

Line 7563: okl_k_headers khr,

7559: --Bug# 3783518
7560: CURSOR orig_pdt_csr(p_cle_id IN NUMBER) is
7561: SELECT pdt.reporting_pdt_id
7562: FROM okc_k_lines_b cle,
7563: okl_k_headers khr,
7564: okl_products pdt
7565: WHERE cle.id = p_cle_id
7566: AND khr.id = cle.dnz_chr_id
7567: AND pdt.id = khr.pdt_id;

Line 9122: okl_k_headers khr,

9118: chrb.start_date,
9119: rul.rule_information1
9120: from okc_rules_b rul,
9121: okc_rule_groups_b rgp,
9122: okl_k_headers khr,
9123: okc_k_headers_b chrb
9124: where rul.rule_information_category = 'LATOWN'
9125: and rul.rgp_id = rgp.id
9126: and rul.dnz_chr_id = rgp.dnz_chr_id

Line 9137: l_deal_type okl_k_headers.deal_type%TYPE;

9133: l_pdt_id number;
9134: l_start_date date;
9135: l_rep_pdt_id number;
9136: l_tax_owner okc_rules_b.rule_information_category%TYPE;
9137: l_deal_type okl_k_headers.deal_type%TYPE;
9138: l_rep_deal_type okl_k_headers.deal_type%TYPE;
9139: l_Multi_GAAP_YN varchar2(1);
9140: l_adjust_asset_to_zero varchar2(1);
9141: l_multi_gaap_book_done varchar2(1);

Line 9138: l_rep_deal_type okl_k_headers.deal_type%TYPE;

9134: l_start_date date;
9135: l_rep_pdt_id number;
9136: l_tax_owner okc_rules_b.rule_information_category%TYPE;
9137: l_deal_type okl_k_headers.deal_type%TYPE;
9138: l_rep_deal_type okl_k_headers.deal_type%TYPE;
9139: l_Multi_GAAP_YN varchar2(1);
9140: l_adjust_asset_to_zero varchar2(1);
9141: l_multi_gaap_book_done varchar2(1);
9142:

Line 10877: okl_k_headers khr,

10873: chrb.start_date,
10874: rul.rule_information1
10875: from okc_rules_b rul,
10876: okc_rule_groups_b rgp,
10877: okl_k_headers khr,
10878: okc_k_headers_b chrb
10879: where rul.rule_information_category = 'LATOWN'
10880: and rul.rgp_id = rgp.id
10881: and rul.dnz_chr_id = rgp.dnz_chr_id

Line 10892: l_deal_type okl_k_headers.deal_type%TYPE;

10888: l_pdt_id number;
10889: l_start_date date;
10890: l_rep_pdt_id number;
10891: l_tax_owner okc_rules_b.rule_information_category%TYPE;
10892: l_deal_type okl_k_headers.deal_type%TYPE;
10893: l_rep_deal_type okl_k_headers.deal_type%TYPE;
10894: l_Multi_GAAP_YN varchar2(1);
10895:
10896: cursor l_tax_book_csr(p_tal_id in number) is

Line 10893: l_rep_deal_type okl_k_headers.deal_type%TYPE;

10889: l_start_date date;
10890: l_rep_pdt_id number;
10891: l_tax_owner okc_rules_b.rule_information_category%TYPE;
10892: l_deal_type okl_k_headers.deal_type%TYPE;
10893: l_rep_deal_type okl_k_headers.deal_type%TYPE;
10894: l_Multi_GAAP_YN varchar2(1);
10895:
10896: cursor l_tax_book_csr(p_tal_id in number) is
10897: select txd.id,