1 PACKAGE IEC_RECORD_FILTER_PVT AUTHID CURRENT_USER AS
2 /* $Header: IECRECFS.pls 115.3 2003/08/22 20:42:23 hhuang noship $ */
3
4 -----------------------------++++++-------------------------------
5 --
6 -- Start of comments
7 --
8 -- API name : Make_ListEntriesAvailable
9 -- Type : Private
10 -- Pre-reqs : None
11 -- Function : Makes list entries with specified do not use reason available by setting
12 -- the DO_NOT_USE_FLAG to 'N' in IEC_G_RETURN_ENTRIES. Report counts
13 -- are updated to reflect that these entries are now available.
14 --
15 -- Parameters : p_list_header_id IN NUMBER Required
16 -- p_dnu_reason_code IN NUMBER Required
17 -- p_commit IN VARCHAR2 Required
18 -- x_return_status OUT VARCHAR2 Required
19 --
20 -- Version : Initial version 1.0
21 --
22 -- End of comments
23 --
24 -----------------------------++++++-------------------------------
25 PROCEDURE Make_ListEntriesAvailable
26 ( p_list_header_id IN NUMBER
27 , p_dnu_reason_code IN NUMBER
28 , p_commit IN BOOLEAN
29 , x_return_status OUT NOCOPY VARCHAR2);
30
31 -----------------------------++++++-------------------------------
32 --
33 -- Start of comments
34 --
35 -- API name : Get_RecordFilterView
36 -- Type : Public
37 -- Pre-reqs : None
38 -- Function : Returns the record filter view name after verifying that the view
39 -- exists, creating the view if necessary.
40 --
41 -- Parameters : p_record_filter_id IN NUMBER Required
42 -- p_source_type_view_name IN VARCHAR2 Required
43 -- x_return_code OUT VARCHAR2 Required
44 --
45 -- Version : Initial version 1.0
46 --
47 -- End of comments
48 --
49 -----------------------------++++++-------------------------------
50 FUNCTION Get_RecordFilterView
51 ( p_record_filter_id IN NUMBER
52 , p_source_type_view_name IN VARCHAR2
53 , x_return_code OUT NOCOPY VARCHAR2
54 )
55 RETURN VARCHAR2;
56
57 -----------------------------++++++-------------------------------
58 --
59 -- Start of comments
60 --
61 -- API name : Recreate_RecordFilterView
62 -- Type : Public
63 -- Pre-reqs : None
64 -- Procedure : Recreates the record filter view, deleting it first if necessary.
65 --
66 -- Parameters : p_record_filter_id IN NUMBER Required
67 -- x_record_filter_view_name OUT VARCHAR2 Required
68 --
69 -- Version : Initial version 1.0
70 --
71 -- End of comments
72 --
73 -----------------------------++++++-------------------------------
74 PROCEDURE Recreate_RecordFilterView
75 ( p_record_filter_id IN NUMBER
76 , x_record_filter_view_name OUT NOCOPY VARCHAR2
77 );
78
79 -----------------------------++++++-------------------------------
80 --
81 -- Start of comments
82 --
83 -- API name : Drop_RecordFilterView
84 -- Type : Private
85 -- Pre-reqs : None
86 -- Function :
87 --
88 -- Parameters : p_record_filter_id IN NUMBER Required
89 -- x_return_code OUT VARCHAR2 Required
90 --
91 -- Version : Initial version 1.0
92 --
93 -- End of comments
94 --
95 -----------------------------++++++-------------------------------
96 PROCEDURE Drop_RecordFilterView
97 ( p_record_filter_id IN NUMBER
98 , x_return_code OUT NOCOPY VARCHAR2
99 );
100
101 -----------------------------++++++-------------------------------
102 --
103 -- Start of comments
104 --
105 -- API name : Get_RecordFilterSourceType
106 -- Type : Public
107 -- Pre-reqs : None
108 -- Procedure : Returns the source type view for the record filter.
109 --
110 -- Parameters : p_record_filter_id IN NUMBER Required
111 -- x_source_type_view OUT VARCHAR2 Required
112 --
113 -- Version : Initial version 1.0
114 --
115 -- End of comments
116 --
117 -----------------------------++++++-------------------------------
118 PROCEDURE Get_RecordFilterSourceType
119 ( p_record_filter_id IN NUMBER
120 , x_source_type_view OUT NOCOPY VARCHAR2
121 );
122
123 -----------------------------++++++-------------------------------
124 --
125 -- Start of comments
126 --
127 -- API name : Apply_RecordFilter
128 -- Type : Public
129 -- Pre-reqs : None
130 -- Procedure : Applies a specified record filter to an entry
131 -- belonging to specified target group.
132 --
133 -- Parameters : p_list_entry_id IN NUMBER Required
134 -- p_list_id IN NUMBER Required
135 -- p_returns_id IN NUMBER Required
136 -- p_record_filter_id IN NUMBER Required
137 -- p_source_type_view_name IN VARCHAR2 Required
138 -- x_callable_flag OUT VARCHAR2 Required
139 --
140 -- Version : Initial version 1.0
141 --
142 -- End of comments
143 --
144 -----------------------------++++++-------------------------------
145 PROCEDURE Apply_RecordFilter
146 ( p_list_entry_id IN NUMBER
147 , p_list_id IN NUMBER
148 , p_returns_id IN NUMBER
149 , p_record_filter_id IN NUMBER
150 , p_source_type_view_name IN VARCHAR2
151 , x_callable_flag OUT NOCOPY VARCHAR2
152 );
153
154 -----------------------------++++++-------------------------------
155 --
156 -- Start of comments
157 --
158 -- API name : Cancel_RecordFilter
159 -- Type : Public
160 -- Pre-reqs : None
161 -- Procedure : Remove record filter from all affected entries.
162 --
163 -- Parameters : p_record_filter_id IN VARCHAR2 Required
164 --
165 -- Version : Initial version 1.0
166 --
167 -- End of comments
168 --
169 -----------------------------++++++-------------------------------
170 PROCEDURE Cancel_RecordFilter (p_record_filter_id IN NUMBER);
171
172
173 -----------------------------++++++-------------------------------
174 -- Start of comments
175 --
176 -- API name : Cancel_RecordFilterForList
177 -- Type : Public
178 -- Pre-reqs : None
179 -- Procedure : Remove record filter from specified list.
180 --
181 -- Parameters : p_list_header_id IN NUMBER Required
182 --
183 -- Version : Initial version 1.0
184 --
185 -- End of comments
186 --
187 -----------------------------++++++-------------------------------
188 PROCEDURE Cancel_RecordFilterForList(p_list_header_id IN NUMBER);
189
190 END IEC_RECORD_FILTER_PVT;