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_FILTER_PUB

Line 1: PACKAGE BODY IEX_FILTER_PUB AS

1: PACKAGE BODY IEX_FILTER_PUB AS
2: /* $Header: iexpfilb.pls 120.6.12010000.3 2008/08/25 13:50:55 schekuri ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_FILTER_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpfilb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_FILTER_PUB';

1: PACKAGE BODY IEX_FILTER_PUB AS
2: /* $Header: iexpfilb.pls 120.6.12010000.3 2008/08/25 13:50:55 schekuri ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_FILTER_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpfilb.pls';
6: G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
7: PG_DEBUG NUMBER;
8:

Line 31: ,x_end_of_universe out nocopy boolean) return IEX_FILTER_PUB.UNIVERSE_IDS

27: */
28: function buildUniverse(p_object_id IN NUMBER
29: ,p_object_type IN VARCHAR2
30: ,p_last_object_scored in out nocopy number
31: ,x_end_of_universe out nocopy boolean) return IEX_FILTER_PUB.UNIVERSE_IDS
32:
33: IS
34: l_select_column varchar2(30); -- select column for universeQuery
35: l_entity_name varchar2(30); -- entity for universeQuery

Line 41: l_universe_ids IEX_FILTER_PUB.UNIVERSE_IDS;

37: Type refCur is Ref Cursor;
38: --object_cur refCur;
39: vPLSQL varchar2(2000);
40: Universe_cur refCur;
41: l_universe_ids IEX_FILTER_PUB.UNIVERSE_IDS;
42: i number := 0;
43: l_last_object_scored number;
44: l_api_name varchar2(20);
45:

Line 127: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);

123:
124: exception
125:
126: When No_Data_Found then
127: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
128: return l_universe_ids;
129: When others Then
130: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
131: return l_universe_ids;

Line 130: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);

126: When No_Data_Found then
127: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
128: return l_universe_ids;
129: When others Then
130: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
131: return l_universe_ids;
132: end buildUniverse;
133:
134: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 135: P_FILTER_rec IN IEX_FILTER_PUB.FILTER_REC_TYPE,

131: return l_universe_ids;
132: end buildUniverse;
133:
134: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135: P_FILTER_rec IN IEX_FILTER_PUB.FILTER_REC_TYPE,
136: X_Dup_Status OUT NOCOPY VARCHAR2,
137: X_Return_Status OUT NOCOPY VARCHAR2,
138: X_Msg_Count OUT NOCOPY NUMBER,
139: X_Msg_Data OUT NOCOPY VARCHAR2)

Line 142: l_filter_rec IEX_FILTER_PUB.FILTER_REC_TYPE;

138: X_Msg_Count OUT NOCOPY NUMBER,
139: X_Msg_Data OUT NOCOPY VARCHAR2)
140:
141: IS
142: l_filter_rec IEX_FILTER_PUB.FILTER_REC_TYPE;
143: l_table_name varchar2(50);
144: l_col_name varchar2(25);
145: l_return_Status varchar2(1);
146: L_API_NAME varchar2(25);

Line 326: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,

322: Procedure Create_OBJECT_FILTER
323: (p_api_version IN NUMBER := 1.0,
324: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
325: p_commit IN VARCHAR2 := FND_API.G_FALSE,
326: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
327: x_dup_status OUT NOCOPY VARCHAR2,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_msg_count OUT NOCOPY NUMBER,
330: x_msg_data OUT NOCOPY VARCHAR2,

Line 340: l_FILTER_REC IEX_FILTER_PUB.FILTER_REC_TYPE ;

336: l_return_status VARCHAR2(1);
337: l_msg_count NUMBER;
338: l_msg_data VARCHAR2(32767);
339: l_rowid Varchar2(50);
340: l_FILTER_REC IEX_FILTER_PUB.FILTER_REC_TYPE ;
341: l_object_filter_id NUMBER ;
342:
343:
344: BEGIN

Line 470: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,

466: Procedure Update_OBJECT_FILTER
467: (p_api_version IN NUMBER := 1.0,
468: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
469: p_commit IN VARCHAR2 := FND_API.G_FALSE,
470: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
471: x_dup_status OUT NOCOPY VARCHAR2,
472: x_return_status OUT NOCOPY VARCHAR2,
473: x_msg_count OUT NOCOPY NUMBER,
474: x_msg_data OUT NOCOPY VARCHAR2)

Line 482: l_FILTER_REC IEX_FILTER_PUB.FILTER_REC_TYPE ;

478: l_return_status VARCHAR2(1);
479: l_msg_count NUMBER;
480: l_msg_data VARCHAR2(32767);
481: l_rowid Varchar2(50);
482: l_FILTER_REC IEX_FILTER_PUB.FILTER_REC_TYPE ;
483: l_filter_ref_rec IEX_FILTER_PUB.FILTER_REC_TYPE;
484: l_name_cnt NUMBER;
485:
486:

Line 483: l_filter_ref_rec IEX_FILTER_PUB.FILTER_REC_TYPE;

479: l_msg_count NUMBER;
480: l_msg_data VARCHAR2(32767);
481: l_rowid Varchar2(50);
482: l_FILTER_REC IEX_FILTER_PUB.FILTER_REC_TYPE ;
483: l_filter_ref_rec IEX_FILTER_PUB.FILTER_REC_TYPE;
484: l_name_cnt NUMBER;
485:
486:
487: CURSOR C_CHK_FILTER_NAME (IN_OBJECT_FILTER_ID NUMBER, IN_NAME VARCHAR) IS

Line 839: END IEX_FILTER_PUB;

835: BEGIN
836:
837: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
838:
839: END IEX_FILTER_PUB;