APPS.OKC_XPRT_RULE_PVT dependencies on OKC_XPRT_RULE_COND_VALS

Line 16: g_rule_condition_value_id okc_xprt_rule_cond_vals.rule_condition_value_id%TYPE;

12: g_rule_status_code VARCHAR2 (30);
13: g_org_wide_flag VARCHAR2 (1);
14: g_org_id NUMBER;
15: g_rule_outcome_id okc_xprt_rule_outcomes.rule_outcome_id%TYPE;
16: g_rule_condition_value_id okc_xprt_rule_cond_vals.rule_condition_value_id%TYPE;
17: g_rule_condition_id okc_xprt_rule_conditions.rule_condition_id%TYPE;
18: l_okc_i_not_null VARCHAR2 (30) := 'OKC_I_NOT_NULL';
19: l_okc_i_invalid_value VARCHAR2 (30) := 'OKC_I_INVALID_VALUE';
20: l_field VARCHAR2 (30) := 'FIELD';

Line 691: FROM okc_xprt_rule_cond_vals

687:
688: CURSOR cur_condn_values (p_rule_condition_id NUMBER)
689: IS
690: SELECT TO_NUMBER (object_value_code) clause_id
691: FROM okc_xprt_rule_cond_vals
692: WHERE rule_condition_id = p_rule_condition_id;
693:
694: l_proc VARCHAR2 (60) := 'validateRuleCondition';
695: l_failed_rec_num NUMBER := 0;

Line 1665: INSERT INTO okc_xprt_rule_cond_vals

1661: FOR i IN p_rule_cond_vals_tbl.FIRST .. p_rule_cond_vals_tbl.LAST
1662: LOOP
1663: l_failed_rec_num := i;
1664:
1665: INSERT INTO okc_xprt_rule_cond_vals
1666: (rule_condition_value_id,
1667: rule_condition_id,
1668: object_value_code, object_version_number,
1669: created_by, creation_date, last_updated_by,

Line 1672: VALUES (okc_xprt_rule_cond_vals_s.NEXTVAL

1668: object_value_code, object_version_number,
1669: created_by, creation_date, last_updated_by,
1670: last_update_date, last_update_login
1671: )
1672: VALUES (okc_xprt_rule_cond_vals_s.NEXTVAL
1673: --p_rule_cond_vals_tbl(i).rule_condition_value_id
1674: ,
1675: p_rule_condition_id
1676: --p_rule_cond_vals_tbl(i).rule_condition_id

Line 2766: DELETE FROM okc_xprt_rule_cond_vals

2762: /*As of now Commenting out the validation */
2763:
2764: -- Delete
2765: FORALL i IN INDICES OF p_rule_child_entities_rec.rule_condition_id_tbl
2766: DELETE FROM okc_xprt_rule_cond_vals
2767: WHERE rule_condition_id =
2768: p_rule_child_entities_rec.rule_condition_id_tbl (i);
2769:
2770: FORALL i IN INDICES OF p_rule_child_entities_rec.rule_condition_id_tbl