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 3177: l_rdf_name OKC_RULES_B.RULE_INFORMATION1%TYPE default G_TAX_OWNER_RUL_PROMPT;

3173:
3174: --parameters for rule apis
3175: l_rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE default G_TAX_OWNER_RGP_CODE;
3176: l_rdf_code OKC_RG_DEF_RULES.RDF_CODE%TYPE default G_TAX_OWNER_RUL_CODE;
3177: l_rdf_name OKC_RULES_B.RULE_INFORMATION1%TYPE default G_TAX_OWNER_RUL_PROMPT;
3178: --Bug #2525946
3179: l_segment_number NUMBER default G_TAX_OWNER_RUL_SEG_NUMBER;
3180: l_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
3181: l_id2 OKC_RULES_B.OBJECT1_ID2%TYPE;

Line 3180: l_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

3176: l_rdf_code OKC_RG_DEF_RULES.RDF_CODE%TYPE default G_TAX_OWNER_RUL_CODE;
3177: l_rdf_name OKC_RULES_B.RULE_INFORMATION1%TYPE default G_TAX_OWNER_RUL_PROMPT;
3178: --Bug #2525946
3179: l_segment_number NUMBER default G_TAX_OWNER_RUL_SEG_NUMBER;
3180: l_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
3181: l_id2 OKC_RULES_B.OBJECT1_ID2%TYPE;
3182: l_tax_owner Varchar2(200);
3183: l_description Varchar2(1995);
3184: l_status Varchar2(3);

Line 3181: l_id2 OKC_RULES_B.OBJECT1_ID2%TYPE;

3177: l_rdf_name OKC_RULES_B.RULE_INFORMATION1%TYPE default G_TAX_OWNER_RUL_PROMPT;
3178: --Bug #2525946
3179: l_segment_number NUMBER default G_TAX_OWNER_RUL_SEG_NUMBER;
3180: l_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
3181: l_id2 OKC_RULES_B.OBJECT1_ID2%TYPE;
3182: l_tax_owner Varchar2(200);
3183: l_description Varchar2(1995);
3184: l_status Varchar2(3);
3185: l_start_date date;

Line 3257: From okc_rules_b rul

3253: --cursor to get tax owner rule
3254: Cursor town_rul_csr (pchrid number) is
3255: Select rule_information1 tax_owner,
3256: id
3257: From okc_rules_b rul
3258: where rul.dnz_chr_id = pchrid
3259: and rul.rule_information_category = 'LATOWN'
3260: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
3261:

Line 3262: l_town_rul okc_rules_b.rule_information1%TYPE;

3258: where rul.dnz_chr_id = pchrid
3259: and rul.rule_information_category = 'LATOWN'
3260: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
3261:
3262: l_town_rul okc_rules_b.rule_information1%TYPE;
3263: l_town_rul_id okc_rules_b.id%TYPE;
3264:
3265: --Bug# 5261704
3266: l_depreciate_flag VARCHAR2(3);

Line 3263: l_town_rul_id okc_rules_b.id%TYPE;

3259: and rul.rule_information_category = 'LATOWN'
3260: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
3261:
3262: l_town_rul okc_rules_b.rule_information1%TYPE;
3263: l_town_rul_id okc_rules_b.id%TYPE;
3264:
3265: --Bug# 5261704
3266: l_depreciate_flag VARCHAR2(3);
3267: --Bug# 6373605

Line 4675: From okc_rules_b rul

4671: --cursor to get tax owner rule
4672: Cursor town_rul_csr (pchrid number) is
4673: Select rule_information1 tax_owner,
4674: id
4675: From okc_rules_b rul
4676: where rul.dnz_chr_id = pchrid
4677: and rul.rule_information_category = 'LATOWN'
4678: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
4679:

Line 4680: l_town_rul okc_rules_b.rule_information1%TYPE;

4676: where rul.dnz_chr_id = pchrid
4677: and rul.rule_information_category = 'LATOWN'
4678: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
4679:
4680: l_town_rul okc_rules_b.rule_information1%TYPE;
4681: l_town_rul_id okc_rules_b.id%TYPE;
4682:
4683: --Bug# 3156924
4684: l_trans_number okl_trx_assets.trans_number%TYPE := Null;

Line 4681: l_town_rul_id okc_rules_b.id%TYPE;

4677: and rul.rule_information_category = 'LATOWN'
4678: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
4679:
4680: l_town_rul okc_rules_b.rule_information1%TYPE;
4681: l_town_rul_id okc_rules_b.id%TYPE;
4682:
4683: --Bug# 3156924
4684: l_trans_number okl_trx_assets.trans_number%TYPE := Null;
4685: l_calling_interface varchar2(30) := 'OKLRACAB:Booking';

Line 5042: FROM OKC_RULES_B rul,

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

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

Line 5295: From okc_rules_b rul

5291: --cursor to get tax owner rule
5292: Cursor town_rul_csr (pchrid number) is
5293: Select rule_information1 tax_owner,
5294: id
5295: From okc_rules_b rul
5296: where rul.dnz_chr_id = pchrid
5297: and rul.rule_information_category = 'LATOWN'
5298: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
5299:

Line 5300: l_town_rul okc_rules_b.rule_information1%TYPE;

5296: where rul.dnz_chr_id = pchrid
5297: and rul.rule_information_category = 'LATOWN'
5298: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
5299:
5300: l_town_rul okc_rules_b.rule_information1%TYPE;
5301: l_town_rul_id okc_rules_b.id%TYPE;
5302:
5303: --bug# 2942543 :
5304: l_new_salvage_value Number;

Line 5301: l_town_rul_id okc_rules_b.id%TYPE;

5297: and rul.rule_information_category = 'LATOWN'
5298: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
5299:
5300: l_town_rul okc_rules_b.rule_information1%TYPE;
5301: l_town_rul_id okc_rules_b.id%TYPE;
5302:
5303: --bug# 2942543 :
5304: l_new_salvage_value Number;
5305: l_new_cost Number;

Line 5337: FROM okc_rules_b rul_rel_ast

5333:
5334: /* --sechawla bug 8370324
5335: CURSOR chk_release_chr_csr(p_chr_id IN NUMBER) IS
5336: SELECT 'Y'
5337: FROM okc_rules_b rul_rel_ast
5338: WHERE rul_rel_ast.dnz_chr_id = p_chr_id
5339: AND rul_rel_ast.rule_information_category = 'LARLES'
5340: AND nvl(rule_information1,'N') = 'Y';
5341: */

Line 6260: FROM OKC_RULES_B rul,

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

Line 6286: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%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;
6287: --Bug# 3156924
6288: l_trans_number OKL_TRX_CONTRACTS.trx_number%TYPE;
6289: l_calling_interface Varchar2(30) := 'OKLRACAB:Mass Rebook';
6290:

Line 6499: From okc_rules_b rul

6495: --cursor to get tax owner rule
6496: Cursor town_rul_csr (pchrid number) is
6497: Select rule_information1 tax_owner,
6498: id
6499: From okc_rules_b rul
6500: where rul.dnz_chr_id = pchrid
6501: and rul.rule_information_category = 'LATOWN'
6502: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
6503:

Line 6504: l_town_rul okc_rules_b.rule_information1%TYPE;

6500: where rul.dnz_chr_id = pchrid
6501: and rul.rule_information_category = 'LATOWN'
6502: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
6503:
6504: l_town_rul okc_rules_b.rule_information1%TYPE;
6505: l_town_rul_id okc_rules_b.id%TYPE;
6506:
6507: l_mass_rebook_date date default sysdate;
6508:

Line 6505: l_town_rul_id okc_rules_b.id%TYPE;

6501: and rul.rule_information_category = 'LATOWN'
6502: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
6503:
6504: l_town_rul okc_rules_b.rule_information1%TYPE;
6505: l_town_rul_id okc_rules_b.id%TYPE;
6506:
6507: l_mass_rebook_date date default sysdate;
6508:
6509: --Bug# 2942543 :

Line 6525: FROM okc_rules_b rul_rel_ast

6521:
6522: --sechawla : Bug# 8370324
6523: /* CURSOR chk_release_chr_csr(p_chr_id IN NUMBER) IS
6524: SELECT 'Y'
6525: FROM okc_rules_b rul_rel_ast
6526: WHERE rul_rel_ast.dnz_chr_id = p_chr_id
6527: AND rul_rel_ast.rule_information_category = 'LARLES'
6528: AND nvl(rule_information1,'N') = 'Y';*/
6529:

Line 7117: FROM OKC_RULES_B rul,

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

Line 7128: FROM OKC_RULES_B rul_rel_Ast

7124: AND chr.id = p_rel_chr_id
7125: /* --Bug#2522439
7126: --AND chr.orig_system_source_code = 'OKL_RELEASE';
7127: AND exists (SELECT '1'
7128: FROM OKC_RULES_B rul_rel_Ast
7129: WHERE rul_rel_ast.dnz_chr_id = chr.id
7130: AND rul_rel_ast.rule_information_category = 'LARLES'
7131: AND nvl(rule_information1,'N') = 'Y');
7132: --Bug#2522439 */

Line 7146: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;

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

Line 7356: From okc_rules_b rul

7352: --cursor to get tax owner rule
7353: Cursor town_rul_csr (pchrid number) is
7354: Select rule_information1 tax_owner,
7355: id
7356: From okc_rules_b rul
7357: where rul.dnz_chr_id = pchrid
7358: and rul.rule_information_category = 'LATOWN'
7359: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
7360:

Line 7361: l_town_rul okc_rules_b.rule_information1%TYPE;

7357: where rul.dnz_chr_id = pchrid
7358: and rul.rule_information_category = 'LATOWN'
7359: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
7360:
7361: l_town_rul okc_rules_b.rule_information1%TYPE;
7362: l_town_rul_id okc_rules_b.id%TYPE;
7363:
7364: --Bug# 2942543 :
7365: l_new_salvage_value number;

Line 7362: l_town_rul_id okc_rules_b.id%TYPE;

7358: and rul.rule_information_category = 'LATOWN'
7359: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
7360:
7361: l_town_rul okc_rules_b.rule_information1%TYPE;
7362: l_town_rul_id okc_rules_b.id%TYPE;
7363:
7364: --Bug# 2942543 :
7365: l_new_salvage_value number;
7366: l_new_cost number;

Line 9120: from okc_rules_b rul,

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

Line 9136: l_tax_owner okc_rules_b.rule_information_category%TYPE;

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

Line 10875: from okc_rules_b rul,

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

Line 10891: l_tax_owner okc_rules_b.rule_information_category%TYPE;

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