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,
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,
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
26 type Universe_IDS is table of number
27 index by binary_integer;
28
29 /*
30 || Overview: this function will return a dynamic SQL statement to
31 || execute as the universe of objects to score for a particular
32 || scoring engine
33 ||
34 || Parameter: p_object_id Scoring_Engine or Strategy Engine attached to the universe
35 || p_object_type = EITHER SCORE OR STRATEGY OR AGING
36 ||
37 || Return value: select statement for the Universe
38 ||
39 || Source Tables: IEX_OBJECT_FILTERS
40 ||
41 || Target Tables: none
42 ||
43 || Creation date: 01/09/02 3:38:PM
44 ||
45 || Major Modifications: when who what
46 || 01/09/02 raverma created
47 */
48 function buildUniverse(p_object_id IN NUMBER
49 ,p_object_type IN VARCHAR2
50 ,p_last_object_scored in out nocopy number
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,
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,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 X_FILTER_ID OUT NOCOPY NUMBER);
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,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2);
83
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,
93 x_msg_data OUT NOCOPY VARCHAR2);
94
95
96
97 END IEX_FILTER_PUB;