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_LA_SALES_TAX_PVT dependencies on OKC_RULES_B

Line 75: FROM okc_rules_b rl,

71: -- Bug# 6512668: Exclude asset lines in Abandoned status
72: CURSOR check_feetype_csr (p_contract_id IN NUMBER)
73: IS
74: SELECT NVL(rule_information11,'BILLED') feetype
75: FROM okc_rules_b rl,
76: okc_rule_groups_b rgp,
77: okc_k_lines_b cle
78: WHERE rl.dnz_chr_id = p_contract_id
79: AND rl.rule_information_category = 'LAASTX'

Line 93: FROM okc_rules_b rl

89: rule_information2,
90: rule_information3,
91: rule_information4,
92: rule_information5
93: FROM okc_rules_b rl
94: WHERE rl.dnz_chr_id = p_contract_id
95: AND rl.rule_information_category = 'LASTPR';
96:
97: -- The following checks if all the lines have the asset upfront tax as

Line 107: FROM okc_rules_b rl,

103: -- Bug# 6512668: Exclude asset lines in Abandoned status
104: CURSOR check_lines_csr (p_contract_id IN NUMBER, l_fee_type IN VARCHAR2 )
105: IS
106: SELECT count(NVL(rule_information11, l_fee_type))
107: FROM okc_rules_b rl,
108: okc_rule_groups_b rgp,
109: okc_k_lines_b cle
110: WHERE rl.dnz_chr_id = p_contract_id
111: AND rl.rule_information_category = 'LAASTX'

Line 126: okc_rules_b rl1,

122: IS
123: SELECT NVL(SUM(NVL(TOTAL_TAX,0)),0)
124: FROM okl_tax_sources txs,
125: okc_rule_groups_b rg1,
126: okc_rules_b rl1,
127: okc_rule_groups_b rg2,
128: okc_rules_b rl2,
129: okc_k_lines_b cle
130: WHERE txs.KHR_ID = p_contract_id

Line 128: okc_rules_b rl2,

124: FROM okl_tax_sources txs,
125: okc_rule_groups_b rg1,
126: okc_rules_b rl1,
127: okc_rule_groups_b rg2,
128: okc_rules_b rl2,
129: okc_k_lines_b cle
130: WHERE txs.KHR_ID = p_contract_id
131: AND txs.khr_id = rg1.dnz_chr_id
132: AND txs.kle_id = rg1.cle_id

Line 160: ,okc_rules_b rl1

156: IS
157: SELECT NVL(SUM(NVL(TOTAL_TAX,0)),0)
158: FROM okl_tax_sources txs
159: ,okc_rule_groups_b rg1
160: ,okc_rules_b rl1
161: ,okc_k_lines_b cle
162: WHERE txs.KHR_ID = p_Contract_id
163: AND txs.khr_id = rg1.dnz_chr_id
164: AND txs.kle_id = rg1.cle_id

Line 186: okc_rules_b rl1,

182: p_transaction_id IN NUMBER) IS
183: SELECT 1
184: FROM okl_tax_sources txs,
185: okc_rule_groups_b rg1,
186: okc_rules_b rl1,
187: okc_k_lines_b cle
188: WHERE txs.khr_id = p_contract_id
189: AND txs.trx_id = p_transaction_id
190: -- R12B ebtax: Active and Inactive lines will be billed during rebook

Line 214: okc_rules_b rl1,

210: p_transaction_id IN NUMBER) IS
211: SELECT 1
212: FROM okl_tax_sources txs,
213: okc_rule_groups_b rg1,
214: okc_rules_b rl1,
215: okc_k_lines_b cle
216: WHERE txs.khr_id = p_contract_id
217: AND txs.trx_id = p_transaction_id
218: -- R12B ebtax: Active and Inactive lines will be billed during rebook

Line 760: CURSOR get_segment_prompt(p_ri okc_rules_b.rule_information1%TYPE) IS

756: AND rgp.cle_id is NULL
757: AND rgp.rgd_code = 'LAHDTX'
758: AND rul.rule_information_category = 'LASTPR';
759:
760: CURSOR get_segment_prompt(p_ri okc_rules_b.rule_information1%TYPE) IS
761: select col.form_left_prompt
762: from fnd_descr_flex_col_usage_vl col,
763: okc_rule_defs_v rdef
764: where col.application_id = 540

Line 1654: okc_rules_b rl1,

1650: IS
1651: SELECT cle.id, cle.name, cle.item_description
1652: FROM okc_k_lines_v cle,
1653: okc_rule_groups_b rg1,
1654: okc_rules_b rl1,
1655: okc_line_styles_b lse,
1656: okc_rule_groups_b rg2,
1657: okc_rules_b rl2
1658: WHERE cle.chr_ID = p_contract_id

Line 1657: okc_rules_b rl2

1653: okc_rule_groups_b rg1,
1654: okc_rules_b rl1,
1655: okc_line_styles_b lse,
1656: okc_rule_groups_b rg2,
1657: okc_rules_b rl2
1658: WHERE cle.chr_ID = p_contract_id
1659: AND cle.lse_id = lse.id
1660: AND lse.lty_code = 'FREE_FORM1'
1661: AND cle.dnz_chr_id = rg1.dnz_chr_id

Line 1686: okc_rules_b rl1,

1682: IS
1683: SELECT cle.id, cle.name, cle.item_description
1684: FROM okc_k_lines_v cle,
1685: okc_rule_groups_b rg1,
1686: okc_rules_b rl1,
1687: okc_line_styles_b lse
1688: WHERE cle.dnz_chr_id = p_contract_id
1689: AND cle.lse_id = lse.id
1690: AND lse.lty_code = 'FREE_FORM1'

Line 1770: okc_rules_b rul_lafexp

1766: rul_lafexp.dnz_chr_id,
1767: rul_lafexp.rule_information_category,
1768: TO_NUMBER(rul_lafexp.rule_information2) amount
1769: FROM okc_rule_groups_b rgp_lafexp,
1770: okc_rules_b rul_lafexp
1771: WHERE rgp_lafexp.dnz_chr_id = p_chr_id
1772: AND rgp_lafexp.cle_id = p_fee_cle_id
1773: AND rgp_lafexp.rgd_code = 'LAFEXP'
1774: AND rul_lafexp.rgp_id = rgp_lafexp.id

Line 1805: okc_rules_b rul

1801: FROM okc_k_lines_b cleb_cov_asset,
1802: okc_k_items cim_cov_asset,
1803: okc_k_lines_b cleb_fin,
1804: okc_rule_groups_b rgp,
1805: okc_rules_b rul
1806: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1807: AND cleb_cov_asset.dnz_chr_id = p_chr_id
1808: AND cim_cov_asset.cle_id = cleb_cov_asset.id
1809: AND cim_cov_asset.dnz_chr_id = cleb_cov_asset.dnz_chr_id

Line 1833: okc_rules_b rul

1829: FROM okc_k_lines_b cleb_cov_asset,
1830: okc_k_items cim_cov_asset,
1831: okc_k_lines_b cleb_fin,
1832: okc_rule_groups_b rgp,
1833: okc_rules_b rul
1834: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1835: AND cleb_cov_asset.dnz_chr_id = p_chr_id
1836: AND cim_cov_asset.cle_id = cleb_cov_asset.id
1837: AND cim_cov_asset.dnz_chr_id = cleb_cov_asset.dnz_chr_id

Line 2566: okc_rules_b rl1,

2562: IS
2563: SELECT cle.id, cle.name, cle.item_description
2564: FROM okc_k_lines_v cle,
2565: okc_rule_groups_b rg1,
2566: okc_rules_b rl1,
2567: okc_line_styles_b lse,
2568: okc_rule_groups_b rg2,
2569: okc_rules_b rl2
2570: WHERE cle.chr_ID = p_contract_id

Line 2569: okc_rules_b rl2

2565: okc_rule_groups_b rg1,
2566: okc_rules_b rl1,
2567: okc_line_styles_b lse,
2568: okc_rule_groups_b rg2,
2569: okc_rules_b rl2
2570: WHERE cle.chr_ID = p_contract_id
2571: AND cle.lse_id = lse.id
2572: AND lse.lty_code = 'FREE_FORM1'
2573: AND cle.dnz_chr_id = rg1.dnz_chr_id

Line 2599: okc_rules_b rl1,

2595: IS
2596: SELECT cle.id, cle.name, cle.item_description
2597: FROM okc_k_lines_v cle,
2598: okc_rule_groups_b rg1,
2599: okc_rules_b rl1,
2600: okc_line_styles_b lse
2601: WHERE cle.dnz_chr_ID = p_contract_id
2602: AND cle.lse_id = lse.id
2603: AND lse.lty_code = 'FREE_FORM1'

Line 3235: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

3231:
3232: -- Cursors plucked from OKL_LA_JE_PVT for a/c - END
3233: l_acc_gen_primary_key_tbl okl_account_dist_pvt.acc_gen_primary_key;
3234: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
3235: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
3236:
3237: account_data_exception EXCEPTION;
3238:
3239: --Bug# 6619311

Line 3768: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

3764: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec
3765: INDEX BY BINARY_INTEGER;
3766: l_accoutable_tax_lines ac_tax_line_tbl;
3767: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
3768: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
3769: upfront_tax_acct_exception EXCEPTION;
3770:
3771: --Bug# 6619311
3772: l_billed_sty_id NUMBER;

Line 4441: l_fee_type OKC_RULES_B.rule_information1%TYPE;

4437:
4438: rule_info_csr_rec rule_info_csr%ROWTYPE;
4439: l_asset_count NUMBER := 0;
4440: l_stream_id NUMBER := 0;
4441: l_fee_type OKC_RULES_B.rule_information1%TYPE;
4442: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
4443: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
4444: pre_book_exception exception;
4445:

Line 4442: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;

4438: rule_info_csr_rec rule_info_csr%ROWTYPE;
4439: l_asset_count NUMBER := 0;
4440: l_stream_id NUMBER := 0;
4441: l_fee_type OKC_RULES_B.rule_information1%TYPE;
4442: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
4443: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
4444: pre_book_exception exception;
4445:
4446: -- Cursor to check if sales tax fee exists

Line 4808: l_fee_type OKC_RULES_B.rule_information1%TYPE;

4804: l_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';
4805: l_billed_assets NUMBER :=0;
4806: l_asset_count NUMBER :=0;
4807: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
4808: l_fee_type OKC_RULES_B.rule_information1%TYPE;
4809: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
4810: l_contract_bill_tax NUMBER :=0;
4811: booking_exception exception;
4812:

Line 4809: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;

4805: l_billed_assets NUMBER :=0;
4806: l_asset_count NUMBER :=0;
4807: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
4808: l_fee_type OKC_RULES_B.rule_information1%TYPE;
4809: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
4810: l_contract_bill_tax NUMBER :=0;
4811: booking_exception exception;
4812:
4813: BEGIN

Line 5101: l_fee_type OKC_RULES_B.rule_information1%TYPE;

5097: rule_info_csr_rec rule_info_csr%ROWTYPE;
5098: l_asset_count NUMBER;
5099: l_billed_assets NUMBER :=0;
5100: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
5101: l_fee_type OKC_RULES_B.rule_information1%TYPE;
5102: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
5103: rebook_exception EXCEPTION;
5104:
5105: BEGIN

Line 5102: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;

5098: l_asset_count NUMBER;
5099: l_billed_assets NUMBER :=0;
5100: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
5101: l_fee_type OKC_RULES_B.rule_information1%TYPE;
5102: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
5103: rebook_exception EXCEPTION;
5104:
5105: BEGIN
5106:

Line 5390: FROM okc_rules_b rul

5386: -- Cursor modified to include validation at asset line level
5387: -- Cursor now counts the number of New assets in the contract
5388: /* CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
5389: SELECT NVL(rule_information1,'N')
5390: FROM okc_rules_b rul
5391: WHERE rul.dnz_chr_id = p_chr_id
5392: AND rul.rule_information_category = 'LARLES'; */
5393:
5394: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS

Line 6054: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

6050: WHERE id = p_chr_id;
6051: l_authoring_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
6052:
6053: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
6054: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
6055: chrId NUMBER) IS
6056: select crl.object1_id1,
6057: crl.RULE_INFORMATION1,
6058: crl.RULE_INFORMATION2,

Line 6067: OKC_RULES_B crl

6063: crl.RULE_INFORMATION7,
6064: crl.RULE_INFORMATION10,
6065: crl.RULE_INFORMATION11
6066: from OKC_RULE_GROUPS_B crg,
6067: OKC_RULES_B crl
6068: where crl.rgp_id = crg.id
6069: and crg.RGD_CODE = rgcode
6070: and crl.RULE_INFORMATION_CATEGORY = rlcat
6071: and crg.dnz_chr_id = chrId;

Line 6075: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

6071: and crg.dnz_chr_id = chrId;
6072:
6073:
6074: cursor l_rl_csr1( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
6075: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
6076: chrId NUMBER,
6077: cleId NUMBER ) IS
6078: select crl.id slh_id,
6079: crl.object1_id1,

Line 6089: OKC_RULES_B crl

6085: crl.RULE_INFORMATION7,
6086: crl.RULE_INFORMATION8,
6087: crl.RULE_INFORMATION10
6088: from OKC_RULE_GROUPS_B crg,
6089: OKC_RULES_B crl
6090: where crl.rgp_id = crg.id
6091: and crg.RGD_CODE = rgcode
6092: and crl.RULE_INFORMATION_CATEGORY = rlcat
6093: and crg.dnz_chr_id = chrId

Line 6165: OKC_RULES_B crl

6161: SELECT crl.id slh_id,
6162: crl.object1_id1,
6163: crl.RULE_INFORMATION11
6164: FROM OKC_RULE_GROUPS_B crg,
6165: OKC_RULES_B crl
6166: WHERE crl.rgp_id = crg.id
6167: AND crg.RGD_CODE = 'LAASTX'
6168: AND crl.RULE_INFORMATION_CATEGORY = 'LAASTX'
6169: AND crg.dnz_chr_id = p_chr_id

Line 6252: okc_rules_b crl

6248: -- ER# 9327076 - Cursor to check line level setup for upfront tax
6249: CURSOR chk_line_upfront_tax (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6250: SELECT '!'
6251: FROM okc_rule_groups_b crg,
6252: okc_rules_b crl
6253: WHERE crl.rgp_id = crg.ID
6254: AND crg.rgd_code = 'LAASTX'
6255: AND crl.rule_information_category = 'LAASTX'
6256: AND crg.dnz_chr_id = p_chr_id

Line 6270: FROM okc_rules_b rul

6266: -- but needs to be validated at contract line
6267: -- Cursor modified to include validation at asset line level
6268: /*CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
6269: SELECT NVL(rule_information1,'N')
6270: FROM okc_rules_b rul
6271: WHERE rul.dnz_chr_id = p_chr_id
6272: AND rul.rule_information_category = 'LARLES';*/
6273:
6274: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS

Line 6912: CURSOR l_upfront_tax_other_assets(p_line_upfront_tax OKC_RULES_B.RULE_INFORMATION11%TYPE) IS

6908: l_exists boolean;
6909: l_mix_fin_cap VARCHAR2(1);
6910:
6911: -- Bug# 6512668: Exclude asset lines in Abandoned status
6912: CURSOR l_upfront_tax_other_assets(p_line_upfront_tax OKC_RULES_B.RULE_INFORMATION11%TYPE) IS
6913: SELECT 'Y'
6914: FROM okc_rule_groups_b rgp,
6915: okc_rules_b rule,
6916: okc_k_lines_b cle

Line 6915: okc_rules_b rule,

6911: -- Bug# 6512668: Exclude asset lines in Abandoned status
6912: CURSOR l_upfront_tax_other_assets(p_line_upfront_tax OKC_RULES_B.RULE_INFORMATION11%TYPE) IS
6913: SELECT 'Y'
6914: FROM okc_rule_groups_b rgp,
6915: okc_rules_b rule,
6916: okc_k_lines_b cle
6917: WHERE rule.rgp_id = rgp.id
6918: AND rgd_code = 'LAASTX'
6919: AND rule_information_category = 'LAASTX'

Line 7061: FROM okc_rules_b sll,

7057: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
7058: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
7059: TO_NUMBER(sll.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
7060: styt.name stream_type
7061: FROM okc_rules_b sll,
7062: okc_rules_b slh,
7063: okc_rule_groups_b rgp,
7064: okl_strm_type_b sty,
7065: okl_strm_type_tl styt

Line 7062: okc_rules_b slh,

7058: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
7059: TO_NUMBER(sll.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
7060: styt.name stream_type
7061: FROM okc_rules_b sll,
7062: okc_rules_b slh,
7063: okc_rule_groups_b rgp,
7064: okl_strm_type_b sty,
7065: okl_strm_type_tl styt
7066: WHERE rgp.dnz_chr_id = p_chr_id

Line 7083: FROM okc_rules_b slh,

7079: CURSOR l_fn_fee_pmtH_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
7080: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
7081:
7082: SELECT slh.id
7083: FROM okc_rules_b slh,
7084: okc_rule_groups_b rgp,
7085: okl_strm_type_b sty,
7086: okl_strm_type_tl styt
7087: WHERE rgp.dnz_chr_id = p_chr_id

Line 7101: FROM okc_rules_b rule,

7097: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
7098: SELECT styt.name stream_type,
7099: rule.id rule_id,
7100: rgp.id rgp_id
7101: FROM okc_rules_b rule,
7102: okc_rule_groups_b rgp,
7103: okl_strm_type_b sty,
7104: okl_strm_type_tl styt
7105: WHERE NVL(rgp.cle_id, -1) = p_kle_id

Line 7114: CURSOR l_strm_sll_csr (p_rule_id OKC_RULES_B.ID%TYPE,

7110: AND TO_NUMBER(rule.object1_id1) = sty.id
7111: AND styt.LANGUAGE = USERENV('LANG')
7112: AND sty.id = styt.id;
7113:
7114: CURSOR l_strm_sll_csr (p_rule_id OKC_RULES_B.ID%TYPE,
7115: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
7116: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
7117: sll.rule_information1 seq,
7118: sll.rule_information6 amt,

Line 7121: FROM okc_rules_b sll

7117: sll.rule_information1 seq,
7118: sll.rule_information6 amt,
7119: sll.rule_information7 stub_day,
7120: sll.rule_information13 rate
7121: FROM okc_rules_b sll
7122: WHERE sll.rgp_id = p_rgp_id
7123: AND sll.object2_id1 = TO_CHAR(p_rule_id)
7124: AND sll.rule_information_category = 'LASLL'
7125: ORDER BY 1,2;