APPS.IEX_FILTER_PUB dependencies on IEX_UTILITIES

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

238:
239: -- api body
240: -- validate object_filter_id
241: /*
242: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => p_filter_rec.object_filter_id,
243: P_COL_NAME => 'OBJECT_FILTER_ID',
244: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',
245: X_Return_Status => x_return_status,
246: X_Msg_Count => x_msg_count,

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

253: */
254:
255: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_Any_VARCHAR');
256: -- validate object_filter_name
257: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.object_filter_name,
258: P_COL_NAME => 'OBJECT_FILTER_NAME',
259: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',
260: X_Return_Status => l_return_status,
261: X_Msg_Count => x_msg_count,

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

273:
274: -- validate lookup_type/ code
275: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:');
276: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:lookup_code:'||p_filter_rec.object_filter_type);
277: IEX_UTILITIES.validate_lookup_code(P_LOOKUP_TYPE => 'IEX_OBJECT_FILTERS',
278: P_LOOKUP_CODE => p_filter_rec.OBJECT_FILTER_TYPE,
279: X_Return_Status => l_return_status,
280: X_Msg_Count => x_msg_count,
281: X_Msg_Data => x_msg_data,

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

304: l_col_name := 'STATUS_RULE_ID';
305: end if;
306:
307: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_id:');
308: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => p_filter_rec.object_id,
309: P_COL_NAME => l_col_name,
310: P_TABLE_NAME => l_table_name,
311: X_Return_Status => l_return_status,
312: X_Msg_Count => x_msg_count,

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

327: * we dont validate entity(view) and column here.
328: *
329: -- validate entity_name
330: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_varchar');
331: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.ENTITY_NAME,
332: P_COL_NAME => 'VIEW_NAME',
333: P_TABLE_NAME => 'ALL_VIEWS',
334: X_Return_Status => l_return_status,
335: X_Msg_Count => x_msg_count,

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

342: END IF;
343:
344: -- validate select_column
345: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_varchar');
346: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.SELECT_COLUMN,
347: P_COL_NAME => 'COLUMN_NAME',
348: P_TABLE_NAME => 'ALL_TAB_COLUMNS',
349: X_Return_Status => l_return_status,
350: X_Msg_Count => x_msg_count,