APPS.IEC_CRITERIA_UTIL_PVT dependencies on IEC_G_RULES

Line 6: TYPE RULE_CRITERIA IS RECORD ( OWNER_ID IEC_G_RULES.OWNER_ID%TYPE

2: /* $Header: IECCRUTB.pls 115.4 2004/05/18 19:38:07 minwang noship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'IEC_CRITERIA_UTIL_PVT';
5:
6: TYPE RULE_CRITERIA IS RECORD ( OWNER_ID IEC_G_RULES.OWNER_ID%TYPE
7: , RULE_ID IEC_G_RULES.RULE_ID%TYPE
8: , CRITERIA_ID IEC_G_FIELD_CRITERIA.CRITERIA_ID%TYPE
9: , CRITERIA_COMB_CODE IEC_G_FIELD_CRITERIA.COMBINATION_CODE%TYPE
10: , FIELD_NAME IEC_G_FIELDS.FIELD_NAME%TYPE

Line 7: , RULE_ID IEC_G_RULES.RULE_ID%TYPE

3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'IEC_CRITERIA_UTIL_PVT';
5:
6: TYPE RULE_CRITERIA IS RECORD ( OWNER_ID IEC_G_RULES.OWNER_ID%TYPE
7: , RULE_ID IEC_G_RULES.RULE_ID%TYPE
8: , CRITERIA_ID IEC_G_FIELD_CRITERIA.CRITERIA_ID%TYPE
9: , CRITERIA_COMB_CODE IEC_G_FIELD_CRITERIA.COMBINATION_CODE%TYPE
10: , FIELD_NAME IEC_G_FIELDS.FIELD_NAME%TYPE
11: , FIELD_VALUE IEC_G_FIELDS.FIELD_VALUE%TYPE

Line 35: -- present in the IEC_G_RULES, IEC_G_FIELD_CRITERIA,

31: -- API name : Get_Criteria
32: -- Type : Private
33: -- Pre-reqs : None
34: -- Function : Procedure will append the criteria currently
35: -- present in the IEC_G_RULES, IEC_G_FIELD_CRITERIA,
36: -- and IEC_G_FIELDS tables for the specified owner_id,
37: -- and owner_type_code to the ruleCriteriaCollection
38: -- x_criteria_collection. The owner is either a
39: -- subset or record filter.

Line 79: -- entity from the IEC_G_RULES table.

75: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
76:
77: ----------------------------------------------------------------
78: -- Retrieve all of the rules that have been defined for this
79: -- entity from the IEC_G_RULES table.
80: ----------------------------------------------------------------
81: FOR rule_rec IN (SELECT RULE_ID
82: FROM IEC_G_RULES
83: WHERE OWNER_ID = p_owner_id

Line 82: FROM IEC_G_RULES

78: -- Retrieve all of the rules that have been defined for this
79: -- entity from the IEC_G_RULES table.
80: ----------------------------------------------------------------
81: FOR rule_rec IN (SELECT RULE_ID
82: FROM IEC_G_RULES
83: WHERE OWNER_ID = p_owner_id
84: AND OWNER_TYPE_CODE = p_owner_type_code)
85: LOOP
86:

Line 207: l_last_owner_id IEC_G_RULES.OWNER_ID%TYPE;

203: IS
204: l_status_code VARCHAR2(1);
205: l_index NUMBER;
206:
207: l_last_owner_id IEC_G_RULES.OWNER_ID%TYPE;
208: l_last_rule_id IEC_G_RULES.RULE_ID%TYPE;
209: l_last_criteria_id IEC_G_FIELD_CRITERIA.CRITERIA_ID%TYPE;
210:
211: l_first_field_flag BOOLEAN := TRUE;

Line 208: l_last_rule_id IEC_G_RULES.RULE_ID%TYPE;

204: l_status_code VARCHAR2(1);
205: l_index NUMBER;
206:
207: l_last_owner_id IEC_G_RULES.OWNER_ID%TYPE;
208: l_last_rule_id IEC_G_RULES.RULE_ID%TYPE;
209: l_last_criteria_id IEC_G_FIELD_CRITERIA.CRITERIA_ID%TYPE;
210:
211: l_first_field_flag BOOLEAN := TRUE;
212: l_first_rule_flag BOOLEAN := TRUE;