APPS.IEC_CRITERIA_UTIL_PVT dependencies on IEC_G_FIELDS

Line 10: , FIELD_NAME IEC_G_FIELDS.FIELD_NAME%TYPE

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
14: , UNARY_FLAG IEC_O_ALG_OP_DEFS_B.IS_UNARY_FLAG%TYPE

Line 11: , FIELD_VALUE IEC_G_FIELDS.FIELD_VALUE%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
14: , UNARY_FLAG IEC_O_ALG_OP_DEFS_B.IS_UNARY_FLAG%TYPE
15: , FIELD_DATATYPE USER_TAB_COLUMNS.DATA_TYPE%TYPE

Line 12: , FIELD_OP_CODE IEC_G_FIELDS.OPERATOR_CODE%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
14: , UNARY_FLAG IEC_O_ALG_OP_DEFS_B.IS_UNARY_FLAG%TYPE
15: , FIELD_DATATYPE USER_TAB_COLUMNS.DATA_TYPE%TYPE
16: );

Line 36: -- and IEC_G_FIELDS tables for the specified owner_id,

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.
40: --

Line 102: -- the current field criterion from the IEC_G_FIELDS table. The

98: LOOP
99:
100: ----------------------------------------------------------------
101: -- Retrieve all of the fields that have been defined for
102: -- the current field criterion from the IEC_G_FIELDS table. The
103: -- columns retrieved are used when creating the entity's
104: -- contribution to the dynamic SQL where clause.
105: ----------------------------------------------------------------
106: FOR field_rec IN (SELECT A.FIELD_NAME FIELD_NAME

Line 111: FROM IEC_G_FIELDS A

107: , A.FIELD_VALUE FIELD_VALUE
108: , A.OPERATOR_CODE OPERATOR_CODE
109: , B.SQL_OPERATOR SQL_OPERATOR
110: , B.IS_UNARY_FLAG IS_UNARY_FLAG
111: FROM IEC_G_FIELDS A
112: , IEC_O_ALG_OP_DEFS_B B
113: WHERE A.CRITERIA_ID = criteria_rec.CRITERIA_ID
114: AND A.OPERATOR_CODE = B.OPERATOR_CODE)
115: LOOP