DBA Data[Home] [Help]

APPS.IEC_CRITERIA_UTIL_PVT dependencies on USER_TAB_COLUMNS

Line 15: , FIELD_DATATYPE USER_TAB_COLUMNS.DATA_TYPE%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)
19: , DATA_TYPE NUMBER

Line 65: L_FIELD_TYPE USER_TAB_COLUMNS.DATA_TYPE%TYPE;

61: IS
62:
63: l_status_code VARCHAR2(1);
64: l_index NUMBER;
65: L_FIELD_TYPE USER_TAB_COLUMNS.DATA_TYPE%TYPE;
66:
67: BEGIN
68: l_status_code := FND_API.G_RET_STS_SUCCESS;
69:

Line 124: FROM USER_TAB_COLUMNS

120: ----------------------------------------------------------------
121: BEGIN
122: SELECT DATA_TYPE
123: INTO L_FIELD_TYPE
124: FROM USER_TAB_COLUMNS
125: WHERE TABLE_NAME = P_VIEW_NAME
126: AND COLUMN_NAME = field_rec.FIELD_NAME;
127: EXCEPTION
128: ----------------------------------------------------------------