DBA Data[Home] [Help]

APPS.OKL_UBB_INTEGRATION_PVT dependencies on OKC_RULES_V

Line 170: p_rule_information_category IN OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,

166: PROCEDURE get_rule_information(
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_rule_information_category IN OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
171: p_rgd_code IN OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
172: p_jtot_object1_code IN OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE,
173: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
174: p_cle_id IN OKC_K_LINES_V.ID%TYPE,

Line 172: p_jtot_object1_code IN OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE,

168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_rule_information_category IN OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
171: p_rgd_code IN OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
172: p_jtot_object1_code IN OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE,
173: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
174: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
175: x_rulv_rec OUT NOCOPY rulv_rec_type
176: ) IS

Line 179: CURSOR rulv_csr (p_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,

175: x_rulv_rec OUT NOCOPY rulv_rec_type
176: ) IS
177:
178:
179: CURSOR rulv_csr (p_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
180: p_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
181: p_jtot_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE,
182: p_chr_id OKC_K_HEADERS_V.ID%TYPE,
183: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

Line 181: p_jtot_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE,

177:
178:
179: CURSOR rulv_csr (p_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
180: p_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
181: p_jtot_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE,
182: p_chr_id OKC_K_HEADERS_V.ID%TYPE,
183: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
184: SELECT
185: rule.ID,

Line 245: FROM okc_rules_v rule,

241: ans_set_jtot_object_code,
242: ans_set_jtot_object_id1,
243: ans_set_jtot_object_id2,
244: display_sequence
245: FROM okc_rules_v rule,
246: okc_rule_groups_v grp
247: WHERE rule_information_category = p_rule_info_catg --'CAN'
248: AND jtot_object1_code = p_jtot_code --'OKX_CUSTACCT'
249: AND grp.rgd_code = p_rgd_code --'LACAN'