eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_FILTER_PUB dependencies on IEX_OBJECT_FILTERS

Line 19: || Source Tables: IEX_OBJECT_FILTERS

15: || p_object_type = EITHER SCORE OR STRATEGY
16: ||
17: || Return value: table of ids for the universe
18: ||
19: || Source Tables: IEX_OBJECT_FILTERS
20: ||
21: || Target Tables: none
22: ||
23: || Creation date: 01/09/02 3:38:PM

Line 51: ' From IEX_OBJECT_FILTERS ' ||

47: vstr4 := ' IS NOT NULL ';
48:
49: execute immediate
50: 'Select select_column, entity_name ' ||
51: ' From IEX_OBJECT_FILTERS ' ||
52: ' Where object_id = :p_object_id AND ' ||
53: ' Object_Filter_Type = :p_object_Type '
54: into l_select_column , l_entity_name
55: using p_object_id, p_object_Type;

Line 138: ' From IEX_OBJECT_FILTERS ' ||

134:
135: -- figure out the universe to select from
136: execute immediate
137: 'Select select_column, entity_name ' ||
138: ' From IEX_OBJECT_FILTERS ' ||
139: ' Where object_id = :p_object_id AND ' ||
140: ' Object_Filter_Type = :p_object_Type '
141: into l_select_column , l_entity_name
142: using p_object_id, p_object_Type;

Line 244: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',

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,
247: X_Msg_Data => x_msg_data,
248: p_init_msg_list => fnd_api.g_false);

Line 259: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',

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,
262: X_Msg_Data => x_msg_data,
263: p_init_msg_list => fnd_api.g_false);

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 467: Select IEX_OBJECT_FILTERS_S.nextval into x_filter_id

463: END IF;
464:
465: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:get object_filter_id from seq');
466:
467: Select IEX_OBJECT_FILTERS_S.nextval into x_filter_id
468: From Dual;
469: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:object_filter_id='||x_filter_id);
470:
471: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:insert row');

Line 474: IEX_OBJECT_FILTERS_PKG.insert_row(

470:
471: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:insert row');
472:
473: -- Create Filter
474: IEX_OBJECT_FILTERS_PKG.insert_row(
475: x_rowid => l_rowid
476: ,p_object_filter_id => x_filter_id
477: ,p_object_filter_type => l_FILTER_REC.object_filter_type
478: ,p_object_filter_name => l_FILTER_REC.object_filter_name

Line 567: FROM IEX_OBJECT_FILTERS

563:
564:
565: CURSOR C_CHK_FILTER_NAME (IN_OBJECT_FILTER_ID NUMBER, IN_NAME VARCHAR) IS
566: SELECT COUNT(OBJECT_FILTER_NAME)
567: FROM IEX_OBJECT_FILTERS
568: WHERE OBJECT_FILTER_ID <> IN_OBJECT_FILTER_ID
569: AND OBJECT_FILTER_NAME = IN_NAME;
570:
571: CURSOR C_get_filter_Rec (IN_FILTER_ID NUMBER) is

Line 586: from iex_object_filters

582: ,CREATED_BY
583: ,LAST_UPDATE_DATE
584: ,LAST_UPDATED_BY
585: ,LAST_UPDATE_LOGIN
586: from iex_object_filters
587: where object_filter_id = in_filter_id
588: FOR UPDATE NOWAIT;
589:
590: BEGIN

Line 660: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);

656: IF (C_get_filter_Rec%NOTFOUND) THEN
657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
658: THEN
659: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
660: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
661: FND_MSG_PUB.Add;
662: END IF;
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;

Line 715: IEX_OBJECT_FILTERS_PKG.update_row(

711: l_filter_rec.OBJECT_VERSION_NUMBER := l_filter_ref_rec.OBJECT_VERSION_NUMBER;
712: END IF;
713:
714: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:update row');
715: IEX_OBJECT_FILTERS_PKG.update_row(
716: x_rowid => l_rowid
717: ,p_object_filter_id => l_filter_rec.object_filter_id
718: ,p_object_filter_type => l_FILTER_REC.object_filter_type
719: ,p_object_filter_name => l_FILTER_REC.object_filter_name

Line 804: FROM IEX_OBJECT_FILTERS

800: l_rowid Varchar2(50);
801:
802: CURSOR C_GET_FILTER (IN_FILTER_ID NUMBER) IS
803: SELECT rowid
804: FROM IEX_OBJECT_FILTERS
805: WHERE OBJECT_FILTER_ID = IN_FILTER_ID;
806:
807: BEGIN
808: -- Standard Start of API savepoint

Line 844: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);

840: IF ( C_GET_FILTER%NOTFOUND) THEN
841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
842: THEN
843: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
844: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
845: FND_MSG_PUB.Add;
846: END IF;
847: RAISE FND_API.G_EXC_ERROR;
848: END IF;

Line 855: IEX_object_filters_PKG.Delete_Row(

851:
852: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:Delete Row');
853:
854: -- Invoke table handler
855: IEX_object_filters_PKG.Delete_Row(
856: x_rowid => l_rowid);
857:
858:
859: --