APPS.IEC_CRITERIA_UTIL_PVT dependencies on IEC_G_FIELD_CRITERIA

Line 8: , CRITERIA_ID IEC_G_FIELD_CRITERIA.CRITERIA_ID%TYPE

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
12: , FIELD_OP_CODE IEC_G_FIELDS.OPERATOR_CODE%TYPE

Line 9: , CRITERIA_COMB_CODE IEC_G_FIELD_CRITERIA.COMBINATION_CODE%TYPE

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
12: , FIELD_OP_CODE IEC_G_FIELDS.OPERATOR_CODE%TYPE
13: , FIELD_OPERATOR IEC_O_ALG_OP_DEFS_B.SQL_OPERATOR%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 89: -- the current rule from the IEC_G_FIELD_CRITERIA table. The

85: LOOP
86:
87: ----------------------------------------------------------------
88: -- Retrieve all of the field criteria that have been defined for
89: -- the current rule from the IEC_G_FIELD_CRITERIA table. The
90: -- combination code is also retrieved, this is either an AND
91: -- or an OR value that is used when creating the entity's
92: -- contribution to the dynamic SQL where clause.
93: ----------------------------------------------------------------

Line 96: FROM IEC_G_FIELD_CRITERIA

92: -- contribution to the dynamic SQL where clause.
93: ----------------------------------------------------------------
94: FOR criteria_rec IN (SELECT CRITERIA_ID
95: , COMBINATION_CODE
96: FROM IEC_G_FIELD_CRITERIA
97: WHERE RULE_ID = rule_rec.RULE_ID)
98: LOOP
99:
100: ----------------------------------------------------------------

Line 209: l_last_criteria_id IEC_G_FIELD_CRITERIA.CRITERIA_ID%TYPE;

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;
213: l_first_criteria_flag BOOLEAN := TRUE;