APPS.IEX_FILTER_PUB dependencies on IEX_UTILITIES

Line 164: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => p_filter_rec.object_filter_id,

160:
161: -- api body
162: -- validate object_filter_id
163: /*
164: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => p_filter_rec.object_filter_id,
165: P_COL_NAME => 'OBJECT_FILTER_ID',
166: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',
167: X_Return_Status => x_return_status,
168: X_Msg_Count => x_msg_count,

Line 179: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.object_filter_name,

175: */
176:
177: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_Any_VARCHAR');
178: -- validate object_filter_name
179: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.object_filter_name,
180: P_COL_NAME => 'OBJECT_FILTER_NAME',
181: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',
182: X_Return_Status => l_return_status,
183: X_Msg_Count => x_msg_count,

Line 199: IEX_UTILITIES.validate_lookup_code(P_LOOKUP_TYPE => 'IEX_OBJECT_FILTERS',

195:
196: -- validate lookup_type/ code
197: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:');
198: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:lookup_code:'||p_filter_rec.object_filter_type);
199: IEX_UTILITIES.validate_lookup_code(P_LOOKUP_TYPE => 'IEX_OBJECT_FILTERS',
200: P_LOOKUP_CODE => p_filter_rec.OBJECT_FILTER_TYPE,
201: X_Return_Status => l_return_status,
202: X_Msg_Count => x_msg_count,
203: X_Msg_Data => x_msg_data,

Line 230: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => p_filter_rec.object_id,

226: l_col_name := 'STATUS_RULE_ID';
227: end if;
228:
229: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_id:');
230: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => p_filter_rec.object_id,
231: P_COL_NAME => l_col_name,
232: P_TABLE_NAME => l_table_name,
233: X_Return_Status => l_return_status,
234: X_Msg_Count => x_msg_count,

Line 253: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.ENTITY_NAME,

249: * we dont validate entity(view) and column here.
250: *
251: -- validate entity_name
252: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_varchar');
253: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.ENTITY_NAME,
254: P_COL_NAME => 'VIEW_NAME',
255: P_TABLE_NAME => 'ALL_VIEWS',
256: X_Return_Status => l_return_status,
257: X_Msg_Count => x_msg_count,

Line 268: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.SELECT_COLUMN,

264: END IF;
265:
266: -- validate select_column
267: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_varchar');
268: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.SELECT_COLUMN,
269: P_COL_NAME => 'COLUMN_NAME',
270: P_TABLE_NAME => 'ALL_TAB_COLUMNS',
271: X_Return_Status => l_return_status,
272: X_Msg_Count => x_msg_count,