APPS.OKS_INTEGRATION_UTIL_PUB dependencies on OKC_RULES_B

Line 341: update okc_rules_b set

337: l_year := to_char(to_date(p_date, p_format), 'YYYY');
338: l_date := l_year || '/' || l_month || '/' || l_day || ' ' || l_time;
339:
340: If p_rule_num = 2 then
341: update okc_rules_b set
342: rule_information2 = l_date
343: ---where rule_information_category = p_category_code and rule_information2 = p_date;
344: where id = p_rule_id;
345: Elsif p_rule_num = 3 then

Line 346: update okc_rules_b set

342: rule_information2 = l_date
343: ---where rule_information_category = p_category_code and rule_information2 = p_date;
344: where id = p_rule_id;
345: Elsif p_rule_num = 3 then
346: update okc_rules_b set
347: rule_information3 = l_date
348: ---where rule_information_category = p_category_code and rule_information3 = p_date;
349: where id = p_rule_id;
350: Elsif p_rule_num = 4 then

Line 351: update okc_rules_b set

347: rule_information3 = l_date
348: ---where rule_information_category = p_category_code and rule_information3 = p_date;
349: where id = p_rule_id;
350: Elsif p_rule_num = 4 then
351: update okc_rules_b set
352: rule_information4 = l_date
353: ---where rule_information_category = p_category_code and rule_information4 = p_date;
354: where id = p_rule_id;
355: End if;

Line 396: from okc_rules_b

392: -- category can be: CCR, CVN, IBR, RVE, SLL
393: ----CURSOR rule_info2(category VARCHAR2, format VARCHAR2) IS
394: CURSOR rule_info2(category VARCHAR2) IS
395: select id rul_id, rule_information2 rul2
396: from okc_rules_b
397: where rgp_id between p_from_id and p_to_id
398: and rule_information_category = category;
399:
400: -----and length(rule_information2) = length(format);

Line 406: from okc_rules_b

402: -- category can be: REN, SBG
403: ---CURSOR rule_info3_4(category VARCHAR2, format VARCHAR2) IS
404: CURSOR rule_info3_4(category VARCHAR2) IS
405: select id rul_id, rule_information3 rul3, rule_information4 rul4
406: from okc_rules_b
407: where rgp_id between p_from_id and p_to_id
408: and rule_information_category = category;
409:
410: -----and length(rule_information3) = length(format) or length(rule_information4) = length(format);