APPS.OKC_XPRT_RULE_PVT dependencies on OKC_XPRT_RULE_OUTCOMES

Line 15: g_rule_outcome_id okc_xprt_rule_outcomes.rule_outcome_id%TYPE;

11: g_rule_type VARCHAR2 (30);
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';

Line 473: FROM okc_xprt_rule_outcomes

469: IS
470: CURSOR cur_outcome_exists
471: IS
472: SELECT 'Y'
473: FROM okc_xprt_rule_outcomes
474: WHERE rule_id = p_rule_id
475: AND object_type = p_object_type
476: AND object_value_id = p_object_value_id;
477:

Line 1836: -- Insert into okc_xprt_rule_outcomes table

1832: /* RWA Changes End */
1833:
1834: validate_rule_outcome (p_rule_outcome_rec => p_rule_outcome_rec);
1835:
1836: -- Insert into okc_xprt_rule_outcomes table
1837: INSERT INTO okc_xprt_rule_outcomes
1838: (rule_outcome_id,
1839: rule_id,
1840: object_type,

Line 1837: INSERT INTO okc_xprt_rule_outcomes

1833:
1834: validate_rule_outcome (p_rule_outcome_rec => p_rule_outcome_rec);
1835:
1836: -- Insert into okc_xprt_rule_outcomes table
1837: INSERT INTO okc_xprt_rule_outcomes
1838: (rule_outcome_id,
1839: rule_id,
1840: object_type,
1841: object_value_id, object_version_number,

Line 1845: VALUES (okc_xprt_rule_outcomes_s.NEXTVAL,

1841: object_value_id, object_version_number,
1842: created_by, creation_date, last_updated_by,
1843: last_update_date, last_update_login,mandatory_yn, mandatory_rwa
1844: )
1845: VALUES (okc_xprt_rule_outcomes_s.NEXTVAL,
1846: p_rule_outcome_rec.rule_id,
1847: p_rule_outcome_rec.object_type,
1848: p_rule_outcome_rec.object_value_id, 1,
1849: fnd_global.user_id, SYSDATE, fnd_global.user_id,

Line 2804: FROM okc_xprt_rule_outcomes

2800:
2801: BEGIN
2802: SELECT 'Y'
2803: INTO l_flag
2804: FROM okc_xprt_rule_outcomes
2805: WHERE rule_id = p_rule_child_entities_rec.rule_id
2806: AND rule_outcome_id =
2807: p_rule_child_entities_rec.rule_outcome_id_tbl (i)
2808: AND ROWNUM = 1;

Line 2825: DELETE FROM okc_xprt_rule_outcomes

2821: END LOOP;
2822:
2823: -- Delete
2824: FORALL i IN INDICES OF p_rule_child_entities_rec.rule_outcome_id_tbl
2825: DELETE FROM okc_xprt_rule_outcomes
2826: WHERE rule_outcome_id =
2827: p_rule_child_entities_rec.rule_outcome_id_tbl (i);
2828:
2829: -- Atleast one outcome must exist for clause_selection rules

Line 2832: FROM okc_xprt_rule_outcomes

2828:
2829: -- Atleast one outcome must exist for clause_selection rules
2830: SELECT COUNT (1)
2831: INTO l_outcomes_count
2832: FROM okc_xprt_rule_outcomes
2833: WHERE rule_id = p_rule_child_entities_rec.rule_id;
2834:
2835: IF l_outcomes_count = 0
2836: THEN