[Home] [Help]
PACKAGE: APPS.QP_QP_FORM_MODIFIER_LIST
Source
1 PACKAGE QP_QP_Form_Modifier_List AUTHID CURRENT_USER AS
2 /* $Header: QPXFMLHS.pls 120.2 2005/06/20 22:47:30 appldev ship $ */
3
4 -- Procedure : Default_Attributes
5 --
6
7 PROCEDURE Default_Attributes
8 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
10 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_automatic_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 , x_comments OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 , x_currency_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 , x_discount_lines_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
32 , x_freight_terms_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 , x_gsa_indicator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
34 , x_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
35 , x_list_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 , x_prorate_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 , x_rounding_factor OUT NOCOPY /* file.sql.39 change */ NUMBER
38 , x_ship_method_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
40 , x_terms_id OUT NOCOPY /* file.sql.39 change */ NUMBER
41 , x_source_system_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 , x_pte_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 , x_active_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 , x_parent_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
45 , x_start_date_active_first OUT NOCOPY /* file.sql.39 change */ DATE
46 , x_end_date_active_first OUT NOCOPY /* file.sql.39 change */ DATE
47 , x_active_date_first_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48 , x_start_date_active_second OUT NOCOPY /* file.sql.39 change */ DATE
49 , x_global_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50 , x_end_date_active_second OUT NOCOPY /* file.sql.39 change */ DATE
51 , x_active_date_second_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 , x_automatic OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53 , x_currency OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54 , x_discount_lines OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55 , x_freight_terms OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 , x_list_header OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57 , x_list_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58 , x_prorate OUT NOCOPY /* file.sql.39 change */ VARCHAR2
59 , x_ship_method OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60 , x_terms OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61 , x_ask_for_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 , x_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63 , x_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 , x_version_no OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65 , x_list_source_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
66 , x_orig_system_header_ref OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67 , x_shareable_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
68 --added for MOAC
69 , x_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
70 );
71
72 -- Procedure : Change_Attribute
73 --
74
75 PROCEDURE Change_Attribute
76 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
78 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 , p_list_header_id IN NUMBER
80 , p_attr_id IN NUMBER
81 , p_attr_value IN VARCHAR2
82 , p_attribute1 IN VARCHAR2
83 , p_attribute10 IN VARCHAR2
84 , p_attribute11 IN VARCHAR2
85 , p_attribute12 IN VARCHAR2
86 , p_attribute13 IN VARCHAR2
87 , p_attribute14 IN VARCHAR2
88 , p_attribute15 IN VARCHAR2
89 , p_attribute2 IN VARCHAR2
90 , p_attribute3 IN VARCHAR2
91 , p_attribute4 IN VARCHAR2
92 , p_attribute5 IN VARCHAR2
93 , p_attribute6 IN VARCHAR2
94 , p_attribute7 IN VARCHAR2
95 , p_attribute8 IN VARCHAR2
96 , p_attribute9 IN VARCHAR2
97 , p_context IN VARCHAR2
98 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
99 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
101 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
103 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 , x_automatic_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 , x_comments OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
116 , x_currency_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
117 , x_discount_lines_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
118 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
119 , x_freight_terms_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
120 , x_gsa_indicator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121 , x_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
122 , x_list_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
123 , x_prorate_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 , x_rounding_factor OUT NOCOPY /* file.sql.39 change */ NUMBER
125 , x_ship_method_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
127 , x_terms_id OUT NOCOPY /* file.sql.39 change */ NUMBER
128 , x_source_system_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
129 , x_pte_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130 , x_active_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
131 , x_parent_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
132 , x_start_date_active_first OUT NOCOPY /* file.sql.39 change */ DATE
133 , x_end_date_active_first OUT NOCOPY /* file.sql.39 change */ DATE
134 , x_active_date_first_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
135 , x_start_date_active_second OUT NOCOPY /* file.sql.39 change */ DATE
136 , x_global_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
137 , x_end_date_active_second OUT NOCOPY /* file.sql.39 change */ DATE
138 , x_active_date_second_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
139 , x_automatic OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140 , x_currency OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141 , x_discount_lines OUT NOCOPY /* file.sql.39 change */ VARCHAR2
142 , x_freight_terms OUT NOCOPY /* file.sql.39 change */ VARCHAR2
143 , x_list_header OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 , x_list_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
145 , x_prorate OUT NOCOPY /* file.sql.39 change */ VARCHAR2
146 , x_ship_method OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147 , x_terms OUT NOCOPY /* file.sql.39 change */ VARCHAR2
148 , x_ask_for_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
149 , x_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
150 , x_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
151 , x_version_no OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152 , x_list_source_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
153 , x_orig_system_header_ref OUT NOCOPY /* file.sql.39 change */ VARCHAR2
154 , x_shareable_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
155 --added for MOAC
156 , x_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
157 );
158
159 -- Procedure Validate_And_Write
160 --
161
162 PROCEDURE Validate_And_Write
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 , p_list_header_id IN NUMBER
167 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
168 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
169 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
170 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
171 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
172 );
173
174 -- Procedure Delete_Row
175 --
176
177 PROCEDURE Delete_Row
178 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
179 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
180 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
181 , p_list_header_id IN NUMBER
182 );
183
184 -- Procedure Process_Entity
185 --
186
187 PROCEDURE Process_Entity
188 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
189 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
190 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
191 );
192
193 -- Procedure Process_Object
194 --
195
196 PROCEDURE Process_Object
197 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
198 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
199 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
200 );
201
202 -- Procedure lock_Row
203 --
204
205
206
207 PROCEDURE Create_GSA_Qual(p_list_header_id IN NUMBER,
208 p_list_line_id In NUMBER,
209 p_qualifier_type IN VARCHAR2,
210 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
211
212
213 PROCEDURE Lock_Row
214 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
215 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
216 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
217 , p_attribute1 IN VARCHAR2
218 , p_attribute10 IN VARCHAR2
219 , p_attribute11 IN VARCHAR2
220 , p_attribute12 IN VARCHAR2
221 , p_attribute13 IN VARCHAR2
222 , p_attribute14 IN VARCHAR2
223 , p_attribute15 IN VARCHAR2
224 , p_attribute2 IN VARCHAR2
225 , p_attribute3 IN VARCHAR2
226 , p_attribute4 IN VARCHAR2
227 , p_attribute5 IN VARCHAR2
228 , p_attribute6 IN VARCHAR2
229 , p_attribute7 IN VARCHAR2
230 , p_attribute8 IN VARCHAR2
231 , p_attribute9 IN VARCHAR2
232 , p_automatic_flag IN VARCHAR2
233 , p_comments IN VARCHAR2
234 , p_context IN VARCHAR2
235 , p_created_by IN NUMBER
236 , p_creation_date IN DATE
237 , p_currency_code IN VARCHAR2
238 , p_discount_lines_flag IN VARCHAR2
239 , p_end_date_active IN DATE
240 , p_freight_terms_code IN VARCHAR2
241 , p_gsa_indicator IN VARCHAR2
242 , p_last_updated_by IN NUMBER
243 , p_last_update_date IN DATE
244 , p_last_update_login IN NUMBER
245 , p_list_header_id IN NUMBER
246 , p_list_type_code IN VARCHAR2
247 , p_program_application_id IN NUMBER
248 , p_program_id IN NUMBER
249 , p_program_update_date IN DATE
250 , p_prorate_flag IN VARCHAR2
251 , p_request_id IN NUMBER
252 , p_rounding_factor IN NUMBER
253 , p_ship_method_code IN VARCHAR2
254 , p_start_date_active IN DATE
255 , p_terms_id IN NUMBER
256 , p_source_system_code IN VARCHAR2
257 , p_pte_code IN VARCHAR2
258 , p_active_flag IN VARCHAR2
259 , p_parent_list_header_id IN NUMBER
260 , p_start_date_active_first IN DATE
261 , p_end_date_active_first IN DATE
262 , p_active_date_first_type IN VARCHAR2
263 , p_start_date_active_second IN DATE
264 , p_global_flag IN VARCHAR2
265 , p_end_date_active_second IN DATE
266 , p_active_date_second_type IN VARCHAR2
267 , p_ask_for_flag IN VARCHAR2
268 , p_list_source_code IN VARCHAR2 := NULL
269 , p_orig_system_header_ref IN VARCHAR2 := NULL
270 , p_shareable_flag IN VARCHAR2 := NULL
271 --added for MOAC
272 , p_org_id IN NUMBER
273 );
274
275 -- added by svdeshmu for delayed request on feb 24 ,00
276
277 Procedure Clear_Record
278 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
279 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
280 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
281 , p_list_header_id IN NUMBER
282 );
283
284
285 Procedure Delete_All_Requests
286 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
287 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
288 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
289 );
290
291
292 -- end of additions by svdeshmu
293
294
295
296
297
298
299
300 END QP_QP_Form_Modifier_List;