65: creation_date DATE,
66: last_updated_by NUMBER,
67: last_update_date DATE,
68: last_update_login NUMBER,
69: elmt_content VARCHAR2(1600):= FND_API.G_MISS_CHAR
70: );
71:
72: g_miss_qsnr_element_rec qsnr_element_rec_type := NULL;
73: TYPE qsnr_element_tbl_type IS TABLE OF qsnr_element_rec_type INDEX BY BINARY_INTEGER;
85: -- Parameters
86: --
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_qsnr_element_rec IN qsnr_element_rec_type Required
93: --
86: --
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_qsnr_element_rec IN qsnr_element_rec_type Required
93: --
94: -- OUT
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_qsnr_element_rec IN qsnr_element_rec_type Required
93: --
94: -- OUT
95: -- x_return_status OUT VARCHAR2
107: -- ==============================================================================
108:
109: PROCEDURE Create_Gq_Elements(
110: p_api_version_number IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114:
115: x_return_status OUT NOCOPY VARCHAR2,
108:
109: PROCEDURE Create_Gq_Elements(
110: p_api_version_number IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114:
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
109: PROCEDURE Create_Gq_Elements(
110: p_api_version_number IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114:
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
132: -- Parameters
133: --
134: -- IN
135: -- p_api_version_number IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
139: -- p_src_object_id IN NUMBER Required
140: -- p_tar_object_id IN NUMBER Required
133: --
134: -- IN
135: -- p_api_version_number IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
139: -- p_src_object_id IN NUMBER Required
140: -- p_tar_object_id IN NUMBER Required
141: --
134: -- IN
135: -- p_api_version_number IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
139: -- p_src_object_id IN NUMBER Required
140: -- p_tar_object_id IN NUMBER Required
141: --
142: -- OUT
155: -- ==============================================================================
156: PROCEDURE Copy_Row
157: (
158: p_api_version_number IN NUMBER
159: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162: ,x_return_status OUT NOCOPY VARCHAR2
163: ,x_msg_count OUT NOCOPY NUMBER
156: PROCEDURE Copy_Row
157: (
158: p_api_version_number IN NUMBER
159: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162: ,x_return_status OUT NOCOPY VARCHAR2
163: ,x_msg_count OUT NOCOPY NUMBER
164: ,x_msg_data OUT NOCOPY VARCHAR2
157: (
158: p_api_version_number IN NUMBER
159: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162: ,x_return_status OUT NOCOPY VARCHAR2
163: ,x_msg_count OUT NOCOPY NUMBER
164: ,x_msg_data OUT NOCOPY VARCHAR2
165: ,p_src_object_id IN NUMBER
178: -- Parameters
179: --
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_qsnr_element_rec IN qsnr_element_rec_type Required
186: --
179: --
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_qsnr_element_rec IN qsnr_element_rec_type Required
186: --
187: -- OUT
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_qsnr_element_rec IN qsnr_element_rec_type Required
186: --
187: -- OUT
188: -- x_return_status OUT VARCHAR2
200: -- ==============================================================================
201:
202: PROCEDURE Update_Gq_Elements(
203: p_api_version_number IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207:
208: x_return_status OUT NOCOPY VARCHAR2,
201:
202: PROCEDURE Update_Gq_Elements(
203: p_api_version_number IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207:
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
202: PROCEDURE Update_Gq_Elements(
203: p_api_version_number IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207:
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
225: -- Parameters
226: --
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_qsnr_element_id IN NUMBER
233: -- p_object_version_number IN NUMBER Optional Default = NULL
226: --
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_qsnr_element_id IN NUMBER
233: -- p_object_version_number IN NUMBER Optional Default = NULL
234: --
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_qsnr_element_id IN NUMBER
233: -- p_object_version_number IN NUMBER Optional Default = NULL
234: --
235: -- OUT
248: -- ==============================================================================
249:
250: PROCEDURE Delete_Gq_Elements(
251: p_api_version_number IN NUMBER,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_commit IN VARCHAR2 := FND_API.G_FALSE,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
249:
250: PROCEDURE Delete_Gq_Elements(
251: p_api_version_number IN NUMBER,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_commit IN VARCHAR2 := FND_API.G_FALSE,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
250: PROCEDURE Delete_Gq_Elements(
251: p_api_version_number IN NUMBER,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_commit IN VARCHAR2 := FND_API.G_FALSE,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_qsnr_element_id IN NUMBER,
272: -- Parameters
273: --
274: -- IN
275: -- p_api_version_number IN NUMBER Required
276: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
277: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
278: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
279: -- p_qsnr_element_id IN NUMBER
280: -- p_object_version_number IN NUMBER Optional Default = NULL
273: --
274: -- IN
275: -- p_api_version_number IN NUMBER Required
276: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
277: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
278: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
279: -- p_qsnr_element_id IN NUMBER
280: -- p_object_version_number IN NUMBER Optional Default = NULL
281: --
274: -- IN
275: -- p_api_version_number IN NUMBER Required
276: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
277: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
278: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
279: -- p_qsnr_element_id IN NUMBER
280: -- p_object_version_number IN NUMBER Optional Default = NULL
281: --
282: -- OUT
294: -- End of Comments
295: -- ==============================================================================
296: PROCEDURE Delete_Gq_PB_Elements(
297: p_api_version_number IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299: p_commit IN VARCHAR2 := FND_API.G_FALSE,
300: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
301: x_return_status OUT NOCOPY VARCHAR2,
302: x_msg_count OUT NOCOPY NUMBER,
295: -- ==============================================================================
296: PROCEDURE Delete_Gq_PB_Elements(
297: p_api_version_number IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299: p_commit IN VARCHAR2 := FND_API.G_FALSE,
300: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
301: x_return_status OUT NOCOPY VARCHAR2,
302: x_msg_count OUT NOCOPY NUMBER,
303: x_msg_data OUT NOCOPY VARCHAR2,
296: PROCEDURE Delete_Gq_PB_Elements(
297: p_api_version_number IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299: p_commit IN VARCHAR2 := FND_API.G_FALSE,
300: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
301: x_return_status OUT NOCOPY VARCHAR2,
302: x_msg_count OUT NOCOPY NUMBER,
303: x_msg_data OUT NOCOPY VARCHAR2,
304: p_qsnr_element_id IN NUMBER,
317: -- Parameters
318: --
319: -- IN
320: -- p_api_version_number IN NUMBER Required
321: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
322: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
323: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
324: -- p_qsnr_element_rec IN qsnr_element_rec_type Required
325: --
318: --
319: -- IN
320: -- p_api_version_number IN NUMBER Required
321: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
322: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
323: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
324: -- p_qsnr_element_rec IN qsnr_element_rec_type Required
325: --
326: -- OUT
319: -- IN
320: -- p_api_version_number IN NUMBER Required
321: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
322: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
323: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
324: -- p_qsnr_element_rec IN qsnr_element_rec_type Required
325: --
326: -- OUT
327: -- x_return_status OUT VARCHAR2
339: -- ==============================================================================
340:
341: PROCEDURE Lock_Gq_Elements(
342: p_api_version_number IN NUMBER,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344:
345: x_return_status OUT NOCOPY VARCHAR2,
346: x_msg_count OUT NOCOPY NUMBER,
347: x_msg_data OUT NOCOPY VARCHAR2,
373:
374:
375: PROCEDURE Validate_Gq_Elements(
376: p_api_version_number IN NUMBER,
377: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
378: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
379: p_qsnr_element_rec IN qsnr_element_rec_type,
380: p_validation_mode IN VARCHAR2,
381: x_return_status OUT NOCOPY VARCHAR2,
374:
375: PROCEDURE Validate_Gq_Elements(
376: p_api_version_number IN NUMBER,
377: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
378: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
379: p_qsnr_element_rec IN qsnr_element_rec_type,
380: p_validation_mode IN VARCHAR2,
381: x_return_status OUT NOCOPY VARCHAR2,
382: x_msg_count OUT NOCOPY NUMBER,
432:
433:
434: PROCEDURE Validate_Qsnr_Element_Rec (
435: p_api_version_number IN NUMBER,
436: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,
440: p_qsnr_element_rec IN qsnr_element_rec_type
453: -- Parameters
454: --
455: -- IN
456: -- p_api_version_number IN NUMBER Required
457: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
458: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
459: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
460: -- p_qsnr_element_id IN NUMBER
461: -- p_object_version_number IN NUMBER
454: --
455: -- IN
456: -- p_api_version_number IN NUMBER Required
457: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
458: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
459: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
460: -- p_qsnr_element_id IN NUMBER
461: -- p_object_version_number IN NUMBER
462: --
455: -- IN
456: -- p_api_version_number IN NUMBER Required
457: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
458: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
459: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
460: -- p_qsnr_element_id IN NUMBER
461: -- p_object_version_number IN NUMBER
462: --
463: -- OUT
474: -- ==============================================================================
475:
476: PROCEDURE Move_Qsnr_Element (
477: p_api_version_number IN NUMBER
478: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
479: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
480: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
481:
482: ,x_return_status OUT NOCOPY VARCHAR2
475:
476: PROCEDURE Move_Qsnr_Element (
477: p_api_version_number IN NUMBER
478: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
479: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
480: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
481:
482: ,x_return_status OUT NOCOPY VARCHAR2
483: ,x_msg_count OUT NOCOPY NUMBER
476: PROCEDURE Move_Qsnr_Element (
477: p_api_version_number IN NUMBER
478: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
479: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
480: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
481:
482: ,x_return_status OUT NOCOPY VARCHAR2
483: ,x_msg_count OUT NOCOPY NUMBER
484: ,x_msg_data OUT NOCOPY VARCHAR2