APPS.PV_GQ_ELEMENTS_PVT_W dependencies on PV_GQ_ELEMENTS_PVT

Line 1: package body pv_gq_elements_pvt_w as

1: package body pv_gq_elements_pvt_w as
2: /* $Header: pvxwgqeb.pls 120.1 2008/03/20 22:18:17 hekkiral ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy pv_gq_elements_pvt.qsnr_element_tbl_type, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy pv_gq_elements_pvt.qsnr_element_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE

Line 63: procedure rosetta_table_copy_out_p2(t pv_gq_elements_pvt.qsnr_element_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

59: end loop;
60: end if;
61: end if;
62: end rosetta_table_copy_in_p2;
63: procedure rosetta_table_copy_out_p2(t pv_gq_elements_pvt.qsnr_element_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_NUMBER_TABLE

Line 183: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;

179: , x_qsnr_element_id out nocopy NUMBER
180: )
181:
182: as
183: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;
184: ddindx binary_integer; indx binary_integer;
185: begin
186:
187: -- copy data to the local IN or IN-OUT args, if any

Line 213: pv_gq_elements_pvt.create_gq_elements(p_api_version_number,

209: ddp_qsnr_element_rec.elmt_content := p7_a14;
210:
211:
212: -- here's the delegated call to the old PL/SQL routine
213: pv_gq_elements_pvt.create_gq_elements(p_api_version_number,
214: p_init_msg_list,
215: p_commit,
216: p_validation_level,
217: x_return_status,

Line 260: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;

256: , x_object_version_number out nocopy NUMBER
257: )
258:
259: as
260: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;
261: ddindx binary_integer; indx binary_integer;
262: begin
263:
264: -- copy data to the local IN or IN-OUT args, if any

Line 290: pv_gq_elements_pvt.update_gq_elements(p_api_version_number,

286: ddp_qsnr_element_rec.elmt_content := p7_a14;
287:
288:
289: -- here's the delegated call to the old PL/SQL routine
290: pv_gq_elements_pvt.update_gq_elements(p_api_version_number,
291: p_init_msg_list,
292: p_commit,
293: p_validation_level,
294: x_return_status,

Line 336: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;

332: , x_msg_data out nocopy VARCHAR2
333: )
334:
335: as
336: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;
337: ddindx binary_integer; indx binary_integer;
338: begin
339:
340: -- copy data to the local IN or IN-OUT args, if any

Line 365: pv_gq_elements_pvt.validate_gq_elements(p_api_version_number,

361:
362:
363:
364: -- here's the delegated call to the old PL/SQL routine
365: pv_gq_elements_pvt.validate_gq_elements(p_api_version_number,
366: p_init_msg_list,
367: p_validation_level,
368: ddp_qsnr_element_rec,
369: p_validation_mode,

Line 404: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;

400: , x_return_status out nocopy VARCHAR2
401: )
402:
403: as
404: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;
405: ddindx binary_integer; indx binary_integer;
406: begin
407:
408: -- copy data to the local IN or IN-OUT args, if any

Line 428: pv_gq_elements_pvt.check_qsnr_element_items(ddp_qsnr_element_rec,

424:
425:
426:
427: -- here's the delegated call to the old PL/SQL routine
428: pv_gq_elements_pvt.check_qsnr_element_items(ddp_qsnr_element_rec,
429: p_validation_mode,
430: x_return_status);
431:
432: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 460: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;

456: , p5_a14 VARCHAR2
457: )
458:
459: as
460: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;
461: ddindx binary_integer; indx binary_integer;
462: begin
463:
464: -- copy data to the local IN or IN-OUT args, if any

Line 487: pv_gq_elements_pvt.validate_qsnr_element_rec(p_api_version_number,

483: ddp_qsnr_element_rec.last_update_login := p5_a13;
484: ddp_qsnr_element_rec.elmt_content := p5_a14;
485:
486: -- here's the delegated call to the old PL/SQL routine
487: pv_gq_elements_pvt.validate_qsnr_element_rec(p_api_version_number,
488: p_init_msg_list,
489: x_return_status,
490: x_msg_count,
491: x_msg_data,

Line 528: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;

524: , p_movement VARCHAR2
525: )
526:
527: as
528: ddp_qsnr_element_rec pv_gq_elements_pvt.qsnr_element_rec_type;
529: ddindx binary_integer; indx binary_integer;
530: begin
531:
532: -- copy data to the local IN or IN-OUT args, if any

Line 558: pv_gq_elements_pvt.move_qsnr_element(p_api_version_number,

554: ddp_qsnr_element_rec.elmt_content := p7_a14;
555:
556:
557: -- here's the delegated call to the old PL/SQL routine
558: pv_gq_elements_pvt.move_qsnr_element(p_api_version_number,
559: p_init_msg_list,
560: p_commit,
561: p_validation_level,
562: x_return_status,

Line 579: end pv_gq_elements_pvt_w;

575:
576:
577: end;
578:
579: end pv_gq_elements_pvt_w;