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 77: ' From IEX_OBJECT_FILTERS ' ||

73:
74: -- figure out the universe to select from
75: execute immediate
76: 'Select select_column, entity_name ' ||
77: ' From IEX_OBJECT_FILTERS ' ||
78: ' Where object_id = :p_object_id AND ' ||
79: ' Object_Filter_Type = :p_object_Type '
80: into l_select_column , l_entity_name
81: using p_object_id, p_object_Type;

Line 166: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',

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

Line 181: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',

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

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

385: END IF;
386:
387: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:get object_filter_id from seq');
388:
389: Select IEX_OBJECT_FILTERS_S.nextval into x_filter_id
390: From Dual;
391: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:object_filter_id='||x_filter_id);
392:
393: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:insert row');

Line 396: IEX_OBJECT_FILTERS_PKG.insert_row(

392:
393: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:insert row');
394:
395: -- Create Filter
396: IEX_OBJECT_FILTERS_PKG.insert_row(
397: x_rowid => l_rowid
398: ,p_object_filter_id => x_filter_id
399: ,p_object_filter_type => l_FILTER_REC.object_filter_type
400: ,p_object_filter_name => l_FILTER_REC.object_filter_name

Line 489: FROM IEX_OBJECT_FILTERS

485:
486:
487: CURSOR C_CHK_FILTER_NAME (IN_OBJECT_FILTER_ID NUMBER, IN_NAME VARCHAR) IS
488: SELECT COUNT(OBJECT_FILTER_NAME)
489: FROM IEX_OBJECT_FILTERS
490: WHERE OBJECT_FILTER_ID <> IN_OBJECT_FILTER_ID
491: AND OBJECT_FILTER_NAME = IN_NAME;
492:
493: CURSOR C_get_filter_Rec (IN_FILTER_ID NUMBER) is

Line 508: from iex_object_filters

504: ,CREATED_BY
505: ,LAST_UPDATE_DATE
506: ,LAST_UPDATED_BY
507: ,LAST_UPDATE_LOGIN
508: from iex_object_filters
509: where object_filter_id = in_filter_id
510: FOR UPDATE NOWAIT;
511:
512: BEGIN

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

578: IF (C_get_filter_Rec%NOTFOUND) THEN
579: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
580: THEN
581: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
582: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
583: FND_MSG_PUB.Add;
584: END IF;
585: RAISE FND_API.G_EXC_ERROR;
586: END IF;

Line 637: IEX_OBJECT_FILTERS_PKG.update_row(

633: l_filter_rec.OBJECT_VERSION_NUMBER := l_filter_ref_rec.OBJECT_VERSION_NUMBER;
634: END IF;
635:
636: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:update row');
637: IEX_OBJECT_FILTERS_PKG.update_row(
638: x_rowid => l_rowid
639: ,p_object_filter_id => l_filter_rec.object_filter_id
640: ,p_object_filter_type => l_FILTER_REC.object_filter_type
641: ,p_object_filter_name => l_FILTER_REC.object_filter_name

Line 726: FROM IEX_OBJECT_FILTERS

722: l_rowid Varchar2(50);
723:
724: CURSOR C_GET_FILTER (IN_FILTER_ID NUMBER) IS
725: SELECT rowid
726: FROM IEX_OBJECT_FILTERS
727: WHERE OBJECT_FILTER_ID = IN_FILTER_ID;
728:
729: BEGIN
730: -- Standard Start of API savepoint

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

762: IF ( C_GET_FILTER%NOTFOUND) THEN
763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
764: THEN
765: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
766: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
767: FND_MSG_PUB.Add;
768: END IF;
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;

Line 777: IEX_object_filters_PKG.Delete_Row(

773:
774: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:Delete Row');
775:
776: -- Invoke table handler
777: IEX_object_filters_PKG.Delete_Row(
778: x_rowid => l_rowid);
779:
780:
781: --