APPS.OKC_XPRT_RULE_PVT dependencies on OKC_XPRT_RULE_CONDITIONS

Line 17: g_rule_condition_id okc_xprt_rule_conditions.rule_condition_id%TYPE;

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';
21: g_rule_count NUMBER;

Line 685: FROM okc_xprt_rule_conditions

681: IS
682: CURSOR cur_conditions
683: IS
684: SELECT object_type, object_code, rule_condition_id
685: FROM okc_xprt_rule_conditions
686: WHERE rule_id = p_rule_id;
687:
688: CURSOR cur_condn_values (p_rule_condition_id NUMBER)
689: IS

Line 1575: INSERT INTO okc_xprt_rule_conditions

1571: INTO p_rule_condition_rec.rule_condition_id
1572: FROM DUAL; */
1573:
1574: -- Insert
1575: INSERT INTO okc_xprt_rule_conditions
1576: (rule_condition_id,
1577: rule_id,
1578: object_type,
1579: object_code,

Line 2743: FROM okc_xprt_rule_conditions

2739:
2740: BEGIN
2741: SELECT 'Y'
2742: INTO l_flag
2743: FROM okc_xprt_rule_conditions
2744: WHERE rule_id = p_rule_child_entities_rec.rule_id
2745: AND rule_condition_id =
2746: p_rule_child_entities_rec.rule_condition_id_tbl (i)
2747: AND ROWNUM = 1;

Line 2771: DELETE FROM okc_xprt_rule_conditions

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
2771: DELETE FROM okc_xprt_rule_conditions
2772: WHERE rule_condition_id =
2773: p_rule_child_entities_rec.rule_condition_id_tbl (i);
2774:
2775: -- A valid rule requires atleasrt one condition.

Line 2779: FROM okc_xprt_rule_conditions

2775: -- A valid rule requires atleasrt one condition.
2776: -- Atleast one condition must exist other wise return error
2777: SELECT COUNT (1)
2778: INTO l_conditions_count
2779: FROM okc_xprt_rule_conditions
2780: WHERE rule_id = p_rule_child_entities_rec.rule_id;
2781:
2782: IF l_conditions_count = 0
2783: THEN