DBA Data[Home] [Help]

APPS.IEC_CRITERIA_UTIL_PVT dependencies on IEC_O_ALG_OP_DEFS_B

Line 13: , FIELD_OPERATOR IEC_O_ALG_OP_DEFS_B.SQL_OPERATOR%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: );
17:

Line 14: , UNARY_FLAG IEC_O_ALG_OP_DEFS_B.IS_UNARY_FLAG%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: );
17:
18: TYPE BIND_VARIABLE IS RECORD ( NAME VARCHAR2(30)

Line 112: , IEC_O_ALG_OP_DEFS_B B

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
116: