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_CONTRACT_REBOOK_PVT dependencies on OKC_RULES_V

Line 1339: Okc_Rules_V rule

1335: rule.ans_set_jtot_object_id1,
1336: rule.ans_set_jtot_object_id2,
1337: rule.DISPLAY_SEQUENCE
1338: FROM OKC_RULE_GROUPS_V rgp,
1339: Okc_Rules_V rule
1340: WHERE rgp.id = rule.rgp_id
1341: AND rgp.rgd_code = p_rgd_code
1342: AND RULE_INFORMATION_CATEGORY = p_rule_code
1343: AND rgp.dnz_chr_id = p_chr_id

Line 1522: FROM Okc_Rules_V

1518: ans_set_jtot_object_code,
1519: ans_set_jtot_object_id1,
1520: ans_set_jtot_object_id2,
1521: DISPLAY_SEQUENCE
1522: FROM Okc_Rules_V
1523: WHERE okc_rules_v.rgp_id = p_rgp_id
1524: AND okc_rules_v.object2_id1 = p_slh_id
1525: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
1526:

Line 1523: WHERE okc_rules_v.rgp_id = p_rgp_id

1519: ans_set_jtot_object_id1,
1520: ans_set_jtot_object_id2,
1521: DISPLAY_SEQUENCE
1522: FROM Okc_Rules_V
1523: WHERE okc_rules_v.rgp_id = p_rgp_id
1524: AND okc_rules_v.object2_id1 = p_slh_id
1525: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
1526:
1527: l_rulv_rec rulv_rec_type;

Line 1524: AND okc_rules_v.object2_id1 = p_slh_id

1520: ans_set_jtot_object_id2,
1521: DISPLAY_SEQUENCE
1522: FROM Okc_Rules_V
1523: WHERE okc_rules_v.rgp_id = p_rgp_id
1524: AND okc_rules_v.object2_id1 = p_slh_id
1525: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
1526:
1527: l_rulv_rec rulv_rec_type;
1528: i NUMBER DEFAULT 0;

Line 1961: FROM okc_rules_v

1957: AND rgd_code = 'LALEVL';
1958:
1959: CURSOR rule_csr(p_rgp_id NUMBER) IS
1960: SELECT id
1961: FROM okc_rules_v
1962: WHERE rgp_id = p_rgp_id;
1963:
1964: --Bug# 4899328
1965: l_lalevl_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

Line 3609: l_orig_freq OKC_RULES_V.OBJECT1_ID1%TYPE;

3605: l_d_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3606:
3607: l_orig_freq_rule_id NUMBER;
3608: l_orig_freq_rgp_id NUMBER;
3609: l_orig_freq OKC_RULES_V.OBJECT1_ID1%TYPE;
3610: l_orig_exp_rule_id NUMBER;
3611: l_orig_exp_rgp_id NUMBER;
3612: l_orig_exp_period NUMBER;
3613: l_orig_exp_amount NUMBER;

Line 4513: l_orig_freq OKC_RULES_V.OBJECT1_ID1%TYPE;

4509: ins NUMBER := 0;
4510:
4511: l_orig_freq_rule_id NUMBER;
4512: l_orig_freq_rgp_id NUMBER;
4513: l_orig_freq OKC_RULES_V.OBJECT1_ID1%TYPE;
4514: l_orig_exp_rule_id NUMBER;
4515: l_orig_exp_rgp_id NUMBER;
4516: l_orig_exp_period NUMBER;
4517: l_orig_exp_amount NUMBER;

Line 5145: FROM okc_rules_v rul_orig

5141: rul_orig.ANS_SET_JTOT_OBJECT_CODE,
5142: rul_orig.ANS_SET_JTOT_OBJECT_ID1,
5143: rul_orig.ANS_SET_JTOT_OBJECT_ID2,
5144: rul_orig.DISPLAY_SEQUENCE
5145: FROM okc_rules_v rul_orig
5146: WHERE rul_orig.dnz_chr_id = p_chr_id
5147: AND rul_orig.rgp_id = p_rgp_id;
5148:
5149: CURSOR l_rul_rbk_csr(p_rgp_id IN NUMBER,

Line 5213: FROM okc_rules_v rul_rbk

5209: rul_rbk.ANS_SET_JTOT_OBJECT_CODE,
5210: rul_rbk.ANS_SET_JTOT_OBJECT_ID1,
5211: rul_rbk.ANS_SET_JTOT_OBJECT_ID2,
5212: rul_rbk.DISPLAY_SEQUENCE
5213: FROM okc_rules_v rul_rbk
5214: WHERE rul_rbk.dnz_chr_id = p_chr_id
5215: AND rul_rbk.rgp_id = p_rgp_id
5216: AND rul_rbk.rule_information_category = p_rul_info_cat;
5217:

Line 5301: FROM okc_rules_v rul_rbk

5297: rul_rbk.ANS_SET_JTOT_OBJECT_CODE,
5298: rul_rbk.ANS_SET_JTOT_OBJECT_ID1,
5299: rul_rbk.ANS_SET_JTOT_OBJECT_ID2,
5300: rul_rbk.DISPLAY_SEQUENCE
5301: FROM okc_rules_v rul_rbk
5302: WHERE rul_rbk.dnz_chr_id = p_rebook_chr_id
5303: AND rul_rbk.rgp_id = p_rbk_rgp_id
5304: AND NOT EXISTS (SELECT 1
5305: FROM okc_rules_b rul_orig

Line 5583: FROM okc_rules_v

5579: AND rgd_code = 'LALEVL';
5580:
5581: CURSOR rule_csr(p_rgp_id NUMBER) IS
5582: SELECT id
5583: FROM okc_rules_v
5584: WHERE rgp_id = p_rgp_id;
5585:
5586: CURSOR rebook_new_all_line_csr (p_top_line_id NUMBER) IS
5587: SELECT id,

Line 6596: FROM okc_rules_v rul_orig

6592: rul_orig.ANS_SET_JTOT_OBJECT_CODE,
6593: rul_orig.ANS_SET_JTOT_OBJECT_ID1,
6594: rul_orig.ANS_SET_JTOT_OBJECT_ID2,
6595: rul_orig.DISPLAY_SEQUENCE
6596: FROM okc_rules_v rul_orig
6597: WHERE rul_orig.dnz_chr_id = p_chr_id
6598: AND rul_orig.rgp_id = p_rgp_id;
6599:
6600: CURSOR l_rul_rbk_csr(p_rgp_id IN NUMBER,

Line 6664: FROM okc_rules_v rul_rbk

6660: rul_rbk.ANS_SET_JTOT_OBJECT_CODE,
6661: rul_rbk.ANS_SET_JTOT_OBJECT_ID1,
6662: rul_rbk.ANS_SET_JTOT_OBJECT_ID2,
6663: rul_rbk.DISPLAY_SEQUENCE
6664: FROM okc_rules_v rul_rbk
6665: WHERE rul_rbk.dnz_chr_id = p_chr_id
6666: AND rul_rbk.rgp_id = p_rgp_id
6667: AND rul_rbk.rule_information_category = p_rul_info_cat;
6668:

Line 6756: FROM okc_rules_v rul_rbk

6752: rul_rbk.ANS_SET_JTOT_OBJECT_CODE,
6753: rul_rbk.ANS_SET_JTOT_OBJECT_ID1,
6754: rul_rbk.ANS_SET_JTOT_OBJECT_ID2,
6755: rul_rbk.DISPLAY_SEQUENCE
6756: FROM okc_rules_v rul_rbk
6757: WHERE rul_rbk.dnz_chr_id = p_rebook_chr_id
6758: AND rul_rbk.rgp_id = p_rbk_rgp_id
6759: AND NOT EXISTS (SELECT 1
6760: FROM okc_rules_b rul_orig