APPS.IEX_FILTER_PUB dependencies on FND_API

Line 5: OBJECT_FILTER_ID NUMBER := FND_API.G_MISS_NUM,

1: PACKAGE IEX_FILTER_PUB AS
2: /* $Header: iexpfils.pls 120.3 2006/08/10 18:47:19 raverma noship $ */
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 2006/08/10 18:47:19 raverma noship $ */
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 55: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

51: ,x_end_of_universe out nocopy boolean)
52: return IEX_FILTER_PUB.UNIVERSE_IDS;
53:
54:
55: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
56: P_FILTER_rec IN IEX_FILTER_PUB.FILTER_REC_TYPE,
57: X_Dup_Status OUT NOCOPY VARCHAR2,
58: X_Return_Status OUT NOCOPY VARCHAR2,
59: X_Msg_Count OUT NOCOPY NUMBER,

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

60: X_Msg_Data OUT NOCOPY VARCHAR2);
61:
62: Procedure Create_OBJECT_FILTER
63: (p_api_version IN NUMBER := 1.0,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE,
66: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
67: x_dup_status OUT NOCOPY VARCHAR2,
68: x_return_status OUT NOCOPY VARCHAR2,

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

61:
62: Procedure Create_OBJECT_FILTER
63: (p_api_version IN NUMBER := 1.0,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE,
66: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
67: x_dup_status OUT NOCOPY VARCHAR2,
68: x_return_status OUT NOCOPY VARCHAR2,
69: x_msg_count OUT NOCOPY NUMBER,

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

72:
73:
74: Procedure Update_OBJECT_FILTER
75: (p_api_version IN NUMBER := 1.0,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
79: x_dup_status OUT NOCOPY VARCHAR2,
80: x_return_status OUT NOCOPY VARCHAR2,

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

73:
74: Procedure Update_OBJECT_FILTER
75: (p_api_version IN NUMBER := 1.0,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
79: x_dup_status OUT NOCOPY VARCHAR2,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,

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

84:
85:
86: Procedure Delete_OBJECT_FILTER
87: (p_api_version IN NUMBER := 1.0,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: P_OBJECT_FILTER_ID IN NUMBER,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,

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

85:
86: Procedure Delete_OBJECT_FILTER
87: (p_api_version IN NUMBER := 1.0,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: P_OBJECT_FILTER_ID IN NUMBER,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2);