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,
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_query_obj_id in varchar2 default null --Added for Bug 8933776 21-Dec-2009 barathsr
50 ,p_limit_rows in number default null --Added for Bug 8933776 21-Dec-2009 barathsr
51 ,p_object_type IN VARCHAR2
52 ,p_last_object_scored in out nocopy number
53 ,x_end_of_universe out nocopy boolean)
54 return IEX_FILTER_PUB.UNIVERSE_IDS;
55
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,
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,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 X_FILTER_ID OUT NOCOPY NUMBER);
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,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2);
88
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,
98 x_msg_data OUT NOCOPY VARCHAR2);
99
100
101
102 END IEX_FILTER_PUB;