[Home] [Help]
PACKAGE: APPS.QP_QP_PRL_FORM_QUALIFIERS
Source
1 PACKAGE QP_QP_PRL_Form_Qualifiers AS
2 /* $Header: QPXFPLQS.pls 120.2 2005/08/31 18:06:30 srashmi noship $ */
3
4 -- Procedure : Default_Attributes
5 --
6
7 PROCEDURE Default_Attributes
8 ( p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM
9 , p_list_header_id IN NUMBER := FND_API.G_MISS_NUM
10 , p_qualifier_context IN VARCHAR2 := FND_API.G_MISS_CHAR
11 , p_qualifier_attribute IN VARCHAR2 := FND_API.G_MISS_CHAR
12 , p_qualifier_attr_value IN VARCHAR2 := FND_API.G_MISS_CHAR
13 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
15 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 , x_comparison_operator_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
32 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 , x_created_from_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
34 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
35 , x_excluder_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 , x_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
37 , x_list_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
38 , x_qualifier_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 , x_qualifier_attr_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 , x_qualifier_attr_value_to OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 , x_qualifier_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 , x_qualifier_datatype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 --, x_qualifier_date_format OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 , x_qualifier_grouping_no OUT NOCOPY /* file.sql.39 change */ NUMBER
45 , x_qualifier_id OUT NOCOPY /* file.sql.39 change */ NUMBER
46 --, x_qualifier_number_format OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 , x_qualifier_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
48 , x_qualifier_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
49 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
50 --, x_comparison_operator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51 , x_created_from_rule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 --, x_excluder OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53 , x_list_header OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54 , x_list_line OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55 --, x_qualifier OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 , x_qualifier_rule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57 , x_qualify_hier_descendent_flag OUT NOCOPY VARCHAR2 -- Added for TCA
58 );
59
60 -- Procedure : Change_Attribute
61 --
62
63 PROCEDURE Change_Attribute
64 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
66 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67 , p_qualifier_id IN NUMBER
68 , p_attr_id IN NUMBER
69 , p_attr_value IN VARCHAR2
70 , p_attribute1 IN VARCHAR2
71 , p_attribute10 IN VARCHAR2
72 , p_attribute11 IN VARCHAR2
73 , p_attribute12 IN VARCHAR2
74 , p_attribute13 IN VARCHAR2
75 , p_attribute14 IN VARCHAR2
76 , p_attribute15 IN VARCHAR2
77 , p_attribute2 IN VARCHAR2
78 , p_attribute3 IN VARCHAR2
79 , p_attribute4 IN VARCHAR2
80 , p_attribute5 IN VARCHAR2
81 , p_attribute6 IN VARCHAR2
82 , p_attribute7 IN VARCHAR2
83 , p_attribute8 IN VARCHAR2
84 , p_attribute9 IN VARCHAR2
85 , p_context IN VARCHAR2
86 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
99 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
101 , x_comparison_operator_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
103 , x_created_from_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
104 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
105 , x_excluder_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 , x_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
107 , x_list_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
108 , x_qualifier_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109 , x_qualifier_attr_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 , x_qualifier_attr_value_to OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 , x_qualifier_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112 , x_qualifier_datatype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 --, x_qualifier_date_format OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 , x_qualifier_grouping_no OUT NOCOPY /* file.sql.39 change */ NUMBER
115 , x_qualifier_id OUT NOCOPY /* file.sql.39 change */ NUMBER
116 --, x_qualifier_number_format OUT NOCOPY /* file.sql.39 change */ VARCHAR2
117 , x_qualifier_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
118 , x_qualifier_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
119 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
120 --, x_comparison_operator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121 , x_created_from_rule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
122 --, x_excluder OUT NOCOPY /* file.sql.39 change */ VARCHAR2
123 , x_list_header OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 , x_list_line OUT NOCOPY /* file.sql.39 change */ VARCHAR2
125 --, x_qualifier OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 , x_qualifier_rule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127 , x_qualify_hier_descendent_flag OUT NOCOPY VARCHAR2 -- Added for TCA
128 );
129
130 -- Procedure Validate_And_Write
131 --
132
133 PROCEDURE Validate_And_Write
134 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
135 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
136 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
137 , p_qualifier_id IN NUMBER
138 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
139 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
140 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
141 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
142 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
143 , x_program_application_id OUT NOCOPY /* file.sql.39 change */ NUMBER
144 , x_program_id OUT NOCOPY /* file.sql.39 change */ NUMBER
145 , x_program_update_date OUT NOCOPY /* file.sql.39 change */ DATE
146 , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
147 );
148
149 -- Procedure Delete_Row
150 --
151
152 PROCEDURE Delete_Row
153 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
154 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
155 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
156 , p_qualifier_id IN NUMBER
157 );
158
159 -- Procedure Process_Entity
160 --
161
162 PROCEDURE Process_Entity
163 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
164 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
165 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
166 );
167
168 -- Procedure lock_Row
169 --
170
171 PROCEDURE Lock_Row
172 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
173 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
174 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
175 , p_attribute1 IN VARCHAR2
176 , p_attribute10 IN VARCHAR2
177 , p_attribute11 IN VARCHAR2
178 , p_attribute12 IN VARCHAR2
179 , p_attribute13 IN VARCHAR2
180 , p_attribute14 IN VARCHAR2
181 , p_attribute15 IN VARCHAR2
182 , p_attribute2 IN VARCHAR2
183 , p_attribute3 IN VARCHAR2
184 , p_attribute4 IN VARCHAR2
185 , p_attribute5 IN VARCHAR2
186 , p_attribute6 IN VARCHAR2
187 , p_attribute7 IN VARCHAR2
188 , p_attribute8 IN VARCHAR2
189 , p_attribute9 IN VARCHAR2
190 , p_comparison_operator_code IN VARCHAR2
191 , p_context IN VARCHAR2
192 , p_created_by IN NUMBER
193 , p_created_from_rule_id IN NUMBER
194 , p_creation_date IN DATE
195 , p_end_date_active IN DATE
196 , p_excluder_flag IN VARCHAR2
197 , p_last_updated_by IN NUMBER
198 , p_last_update_date IN DATE
199 , p_last_update_login IN NUMBER
200 , p_list_header_id IN NUMBER
201 , p_list_line_id IN NUMBER
202 , p_program_application_id IN NUMBER
203 , p_program_id IN NUMBER
204 , p_program_update_date IN DATE
205 , p_qualifier_attribute IN VARCHAR2
206 , p_qualifier_attr_value IN VARCHAR2
207 , p_qualifier_attr_value_to IN VARCHAR2
208 , p_qualifier_context IN VARCHAR2
209 , p_qualifier_datatype IN VARCHAR2
210 --, p_qualifier_date_format IN VARCHAR2
211 , p_qualifier_grouping_no IN NUMBER
212 , p_qualifier_id IN NUMBER
213 --, p_qualifier_number_format IN VARCHAR2
214 , p_qualifier_precedence IN NUMBER
215 , p_qualifier_rule_id IN NUMBER
216 , p_request_id IN NUMBER
217 , p_start_date_active IN DATE
218 , p_qualify_hier_descendent_flag IN VARCHAR2 -- Added for TCA
219 );
220
221 --spgopal added out parameters to error out when copy failed
222 --and also display the number of qualifier records processed
223 PROCEDURE Get_Rules(p_qualifier_rule_id IN NUMBER,
224 p_list_header_id IN NUMBER,
225 p_list_line_id IN NUMBER := Null,
226 p_group_condition IN VARCHAR2 DEFAULT 'AND',
227 x_processed_qual_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
228 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
229 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
230 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
231
232 Procedure Clear_Record
233 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
234 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
235 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
236 , p_qualifier_id IN NUMBER
237 );
238
239
240 Procedure Delete_All_Requests
241 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
242 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
243 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
244 );
245
246
247 END QP_QP_PRL_Form_Qualifiers;