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.

[Home] [Help]

APPS.IEX_FILTER_PUB dependencies on FND_API

Line 5: OBJECT_FILTER_ID NUMBER := FND_API.G_MISS_NUM,

1: PACKAGE IEX_FILTER_PUB AUTHID CURRENT_USER AS
2: /* $Header: iexpfils.pls 120.3.12010000.4 2010/06/02 11:19:25 barathsr ship $ */
3:
4: TYPE FILTER_REC_TYPE IS RECORD(
5: OBJECT_FILTER_ID NUMBER := FND_API.G_MISS_NUM,
6: OBJECT_FILTER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: OBJECT_FILTER_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
9: SELECT_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 6: OBJECT_FILTER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,

2: /* $Header: iexpfils.pls 120.3.12010000.4 2010/06/02 11:19:25 barathsr ship $ */
3:
4: TYPE FILTER_REC_TYPE IS RECORD(
5: OBJECT_FILTER_ID NUMBER := FND_API.G_MISS_NUM,
6: OBJECT_FILTER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: OBJECT_FILTER_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
9: SELECT_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: ENTITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 7: OBJECT_FILTER_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,

3:
4: TYPE FILTER_REC_TYPE IS RECORD(
5: OBJECT_FILTER_ID NUMBER := FND_API.G_MISS_NUM,
6: OBJECT_FILTER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: OBJECT_FILTER_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
9: SELECT_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: ENTITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: ACTIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 8: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

4: TYPE FILTER_REC_TYPE IS RECORD(
5: OBJECT_FILTER_ID NUMBER := FND_API.G_MISS_NUM,
6: OBJECT_FILTER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: OBJECT_FILTER_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
9: SELECT_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: ENTITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: ACTIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

Line 9: SELECT_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,

5: OBJECT_FILTER_ID NUMBER := FND_API.G_MISS_NUM,
6: OBJECT_FILTER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: OBJECT_FILTER_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
9: SELECT_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: ENTITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: ACTIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
13: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

Line 10: ENTITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,

6: OBJECT_FILTER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
7: OBJECT_FILTER_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
9: SELECT_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: ENTITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: ACTIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
13: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
14: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

Line 11: ACTIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

7: OBJECT_FILTER_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
9: SELECT_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: ENTITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: ACTIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
13: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
14: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
15: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 12: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

8: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
9: SELECT_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: ENTITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: ACTIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
13: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
14: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
15: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 13: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

9: SELECT_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: ENTITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: ACTIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
13: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
14: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
15: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
17: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 14: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

10: ENTITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: ACTIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
13: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
14: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
15: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
17: CREATION_DATE DATE := FND_API.G_MISS_DATE,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 15: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

11: ACTIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
13: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
14: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
15: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
17: CREATION_DATE DATE := FND_API.G_MISS_DATE,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 16: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

12: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
13: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
14: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
15: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
17: CREATION_DATE DATE := FND_API.G_MISS_DATE,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 17: CREATION_DATE DATE := FND_API.G_MISS_DATE,

13: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
14: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
15: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
17: CREATION_DATE DATE := FND_API.G_MISS_DATE,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM);

Line 18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

14: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
15: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
17: CREATION_DATE DATE := FND_API.G_MISS_DATE,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM);
22:

Line 19: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

15: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
16: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
17: CREATION_DATE DATE := FND_API.G_MISS_DATE,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM);
22:
23:

Line 20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

16: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
17: CREATION_DATE DATE := FND_API.G_MISS_DATE,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM);
22:
23:
24: G_MISS_FILTER_REC IEX_FILTER_PUB.FILTER_REC_TYPE;

Line 21: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM);

17: CREATION_DATE DATE := FND_API.G_MISS_DATE,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM);
22:
23:
24: G_MISS_FILTER_REC IEX_FILTER_PUB.FILTER_REC_TYPE;
25:

Line 60: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

56: function buildsql(p_object_id IN NUMBER, p_object_type IN VARCHAR2, p_query_obj_id in varchar2 default null --Added for Bug 9670348 27-May-2009 barathsr
57: ,p_limit_rows in number default null) --Added for Bug 9670348 27-May-2009 barathsr
58: return varchar2; -- added for bug 9387044
59:
60: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
61: P_FILTER_rec IN IEX_FILTER_PUB.FILTER_REC_TYPE,
62: X_Dup_Status OUT NOCOPY VARCHAR2,
63: X_Return_Status OUT NOCOPY VARCHAR2,
64: X_Msg_Count OUT NOCOPY NUMBER,

Line 69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

65: X_Msg_Data OUT NOCOPY VARCHAR2);
66:
67: Procedure Create_OBJECT_FILTER
68: (p_api_version IN NUMBER := 1.0,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
72: x_dup_status OUT NOCOPY VARCHAR2,
73: x_return_status OUT NOCOPY VARCHAR2,

Line 70: p_commit IN VARCHAR2 := FND_API.G_FALSE,

66:
67: Procedure Create_OBJECT_FILTER
68: (p_api_version IN NUMBER := 1.0,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
72: x_dup_status OUT NOCOPY VARCHAR2,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,

Line 81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

77:
78:
79: Procedure Update_OBJECT_FILTER
80: (p_api_version IN NUMBER := 1.0,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE,
83: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
84: x_dup_status OUT NOCOPY VARCHAR2,
85: x_return_status OUT NOCOPY VARCHAR2,

Line 82: p_commit IN VARCHAR2 := FND_API.G_FALSE,

78:
79: Procedure Update_OBJECT_FILTER
80: (p_api_version IN NUMBER := 1.0,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE,
83: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
84: x_dup_status OUT NOCOPY VARCHAR2,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,

Line 93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

89:
90:
91: Procedure Delete_OBJECT_FILTER
92: (p_api_version IN NUMBER := 1.0,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94: p_commit IN VARCHAR2 := FND_API.G_FALSE,
95: P_OBJECT_FILTER_ID IN NUMBER,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,

Line 94: p_commit IN VARCHAR2 := FND_API.G_FALSE,

90:
91: Procedure Delete_OBJECT_FILTER
92: (p_api_version IN NUMBER := 1.0,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94: p_commit IN VARCHAR2 := FND_API.G_FALSE,
95: P_OBJECT_FILTER_ID IN NUMBER,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2);