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 OKC_RULES_B

Line 3168: l_rdf_name OKC_RULES_B.RULE_INFORMATION1%TYPE default G_TAX_OWNER_RUL_PROMPT;

3164:
3165: --parameters for rule apis
3166: l_rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE default G_TAX_OWNER_RGP_CODE;
3167: l_rdf_code OKC_RG_DEF_RULES.RDF_CODE%TYPE default G_TAX_OWNER_RUL_CODE;
3168: l_rdf_name OKC_RULES_B.RULE_INFORMATION1%TYPE default G_TAX_OWNER_RUL_PROMPT;
3169: --Bug #2525946
3170: l_segment_number NUMBER default G_TAX_OWNER_RUL_SEG_NUMBER;
3171: l_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
3172: l_id2 OKC_RULES_B.OBJECT1_ID2%TYPE;

Line 3171: l_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

3167: l_rdf_code OKC_RG_DEF_RULES.RDF_CODE%TYPE default G_TAX_OWNER_RUL_CODE;
3168: l_rdf_name OKC_RULES_B.RULE_INFORMATION1%TYPE default G_TAX_OWNER_RUL_PROMPT;
3169: --Bug #2525946
3170: l_segment_number NUMBER default G_TAX_OWNER_RUL_SEG_NUMBER;
3171: l_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
3172: l_id2 OKC_RULES_B.OBJECT1_ID2%TYPE;
3173: l_tax_owner Varchar2(200);
3174: l_description Varchar2(1995);
3175: l_status Varchar2(3);

Line 3172: l_id2 OKC_RULES_B.OBJECT1_ID2%TYPE;

3168: l_rdf_name OKC_RULES_B.RULE_INFORMATION1%TYPE default G_TAX_OWNER_RUL_PROMPT;
3169: --Bug #2525946
3170: l_segment_number NUMBER default G_TAX_OWNER_RUL_SEG_NUMBER;
3171: l_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
3172: l_id2 OKC_RULES_B.OBJECT1_ID2%TYPE;
3173: l_tax_owner Varchar2(200);
3174: l_description Varchar2(1995);
3175: l_status Varchar2(3);
3176: l_start_date date;

Line 3248: From okc_rules_b rul

3244: --cursor to get tax owner rule
3245: Cursor town_rul_csr (pchrid number) is
3246: Select rule_information1 tax_owner,
3247: id
3248: From okc_rules_b rul
3249: where rul.dnz_chr_id = pchrid
3250: and rul.rule_information_category = 'LATOWN'
3251: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
3252:

Line 3253: l_town_rul okc_rules_b.rule_information1%TYPE;

3249: where rul.dnz_chr_id = pchrid
3250: and rul.rule_information_category = 'LATOWN'
3251: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
3252:
3253: l_town_rul okc_rules_b.rule_information1%TYPE;
3254: l_town_rul_id okc_rules_b.id%TYPE;
3255:
3256: --Bug# 5261704
3257: l_depreciate_flag VARCHAR2(3);

Line 3254: l_town_rul_id okc_rules_b.id%TYPE;

3250: and rul.rule_information_category = 'LATOWN'
3251: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
3252:
3253: l_town_rul okc_rules_b.rule_information1%TYPE;
3254: l_town_rul_id okc_rules_b.id%TYPE;
3255:
3256: --Bug# 5261704
3257: l_depreciate_flag VARCHAR2(3);
3258: --Bug# 6373605

Line 4666: From okc_rules_b rul

4662: --cursor to get tax owner rule
4663: Cursor town_rul_csr (pchrid number) is
4664: Select rule_information1 tax_owner,
4665: id
4666: From okc_rules_b rul
4667: where rul.dnz_chr_id = pchrid
4668: and rul.rule_information_category = 'LATOWN'
4669: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
4670:

Line 4671: l_town_rul okc_rules_b.rule_information1%TYPE;

4667: where rul.dnz_chr_id = pchrid
4668: and rul.rule_information_category = 'LATOWN'
4669: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
4670:
4671: l_town_rul okc_rules_b.rule_information1%TYPE;
4672: l_town_rul_id okc_rules_b.id%TYPE;
4673:
4674: --Bug# 3156924
4675: l_trans_number okl_trx_assets.trans_number%TYPE := Null;

Line 4672: l_town_rul_id okc_rules_b.id%TYPE;

4668: and rul.rule_information_category = 'LATOWN'
4669: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
4670:
4671: l_town_rul okc_rules_b.rule_information1%TYPE;
4672: l_town_rul_id okc_rules_b.id%TYPE;
4673:
4674: --Bug# 3156924
4675: l_trans_number okl_trx_assets.trans_number%TYPE := Null;
4676: l_calling_interface varchar2(30) := 'OKLRACAB:Booking';

Line 5033: FROM OKC_RULES_B rul,

5029: khr.pdt_id,
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

Line 5061: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%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;
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;

Line 5335: From okc_rules_b rul

5331: --cursor to get tax owner rule
5332: Cursor town_rul_csr (pchrid number) is
5333: Select rule_information1 tax_owner,
5334: id
5335: From okc_rules_b rul
5336: where rul.dnz_chr_id = pchrid
5337: and rul.rule_information_category = 'LATOWN'
5338: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
5339:

Line 5340: l_town_rul okc_rules_b.rule_information1%TYPE;

5336: where rul.dnz_chr_id = pchrid
5337: and rul.rule_information_category = 'LATOWN'
5338: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
5339:
5340: l_town_rul okc_rules_b.rule_information1%TYPE;
5341: l_town_rul_id okc_rules_b.id%TYPE;
5342:
5343: --bug# 2942543 :
5344: l_new_salvage_value Number;

Line 5341: l_town_rul_id okc_rules_b.id%TYPE;

5337: and rul.rule_information_category = 'LATOWN'
5338: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
5339:
5340: l_town_rul okc_rules_b.rule_information1%TYPE;
5341: l_town_rul_id okc_rules_b.id%TYPE;
5342:
5343: --bug# 2942543 :
5344: l_new_salvage_value Number;
5345: l_new_cost Number;

Line 6328: FROM OKC_RULES_B rul,

6324: khr.pdt_id,
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

Line 6354: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%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;
6355: --Bug# 3156924
6356: l_trans_number OKL_TRX_CONTRACTS.trx_number%TYPE;
6357: l_calling_interface Varchar2(30) := 'OKLRACAB:Mass Rebook';
6358:

Line 6577: From okc_rules_b rul

6573: --cursor to get tax owner rule
6574: Cursor town_rul_csr (pchrid number) is
6575: Select rule_information1 tax_owner,
6576: id
6577: From okc_rules_b rul
6578: where rul.dnz_chr_id = pchrid
6579: and rul.rule_information_category = 'LATOWN'
6580: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
6581:

Line 6582: l_town_rul okc_rules_b.rule_information1%TYPE;

6578: where rul.dnz_chr_id = pchrid
6579: and rul.rule_information_category = 'LATOWN'
6580: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
6581:
6582: l_town_rul okc_rules_b.rule_information1%TYPE;
6583: l_town_rul_id okc_rules_b.id%TYPE;
6584:
6585: l_mass_rebook_date date default sysdate;
6586:

Line 6583: l_town_rul_id okc_rules_b.id%TYPE;

6579: and rul.rule_information_category = 'LATOWN'
6580: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
6581:
6582: l_town_rul okc_rules_b.rule_information1%TYPE;
6583: l_town_rul_id okc_rules_b.id%TYPE;
6584:
6585: l_mass_rebook_date date default sysdate;
6586:
6587: --Bug# 2942543 :

Line 7401: FROM OKC_RULES_B rul,

7397: khr.pdt_id,
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'

Line 7412: FROM OKC_RULES_B rul_rel_Ast

7408: AND chr.id = p_rel_chr_id
7409: --Bug#2522439
7410: --AND chr.orig_system_source_code = 'OKL_RELEASE';
7411: AND exists (SELECT '1'
7412: FROM OKC_RULES_B rul_rel_Ast
7413: WHERE rul_rel_ast.dnz_chr_id = chr.id
7414: AND rul_rel_ast.rule_information_category = 'LARLES'
7415: AND nvl(rule_information1,'N') = 'Y');
7416: --Bug#2522439

Line 7421: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;

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;
7423: --Bug# : 11.5.9 enhancement Multi GAAP
7424: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;
7425: l_start_date Date;

Line 7631: From okc_rules_b rul

7627: --cursor to get tax owner rule
7628: Cursor town_rul_csr (pchrid number) is
7629: Select rule_information1 tax_owner,
7630: id
7631: From okc_rules_b rul
7632: where rul.dnz_chr_id = pchrid
7633: and rul.rule_information_category = 'LATOWN'
7634: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
7635:

Line 7636: l_town_rul okc_rules_b.rule_information1%TYPE;

7632: where rul.dnz_chr_id = pchrid
7633: and rul.rule_information_category = 'LATOWN'
7634: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
7635:
7636: l_town_rul okc_rules_b.rule_information1%TYPE;
7637: l_town_rul_id okc_rules_b.id%TYPE;
7638:
7639: --Bug# 2942543 :
7640: l_new_salvage_value number;

Line 7637: l_town_rul_id okc_rules_b.id%TYPE;

7633: and rul.rule_information_category = 'LATOWN'
7634: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
7635:
7636: l_town_rul okc_rules_b.rule_information1%TYPE;
7637: l_town_rul_id okc_rules_b.id%TYPE;
7638:
7639: --Bug# 2942543 :
7640: l_new_salvage_value number;
7641: l_new_cost number;

Line 9395: from okc_rules_b rul,

9391: select khr.pdt_id,
9392: khr.deal_type,
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'

Line 9411: l_tax_owner okc_rules_b.rule_information_category%TYPE;

9407:
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);

Line 11150: from okc_rules_b rul,

11146: select khr.pdt_id,
11147: khr.deal_type,
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'

Line 11166: l_tax_owner okc_rules_b.rule_information_category%TYPE;

11162:
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: