DBA Data[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PVT_W dependencies on AHL_MC_ITEM_COMP_PVT

Line 1: package body ahl_mc_item_comp_pvt_w as

1: package body ahl_mc_item_comp_pvt_w as
2: /* $Header: AHLVICWB.pls 120.1 2006/05/03 01:17 sathapli noship $ */
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 ahl_mc_item_comp_pvt.det_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 ahl_mc_item_comp_pvt.det_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 95: procedure rosetta_table_copy_out_p2(t ahl_mc_item_comp_pvt.det_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t ahl_mc_item_comp_pvt.det_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_NUMBER_TABLE
97: , a2 out nocopy JTF_NUMBER_TABLE
98: , a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , a4 out nocopy JTF_NUMBER_TABLE

Line 337: ddp_x_ic_header_rec ahl_mc_item_comp_pvt.header_rec_type;

333: , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_100
334: )
335:
336: as
337: ddp_x_ic_header_rec ahl_mc_item_comp_pvt.header_rec_type;
338: ddp_x_det_tbl ahl_mc_item_comp_pvt.det_tbl_type;
339: ddindx binary_integer; indx binary_integer;
340: begin
341:

Line 338: ddp_x_det_tbl ahl_mc_item_comp_pvt.det_tbl_type;

334: )
335:
336: as
337: ddp_x_ic_header_rec ahl_mc_item_comp_pvt.header_rec_type;
338: ddp_x_det_tbl ahl_mc_item_comp_pvt.det_tbl_type;
339: ddindx binary_integer; indx binary_integer;
340: begin
341:
342: -- copy data to the local IN or IN-OUT args, if any

Line 378: ahl_mc_item_comp_pvt_w.rosetta_table_copy_in_p2(ddp_x_det_tbl, p8_a0

374: ddp_x_ic_header_rec.attribute14 := p7_a24;
375: ddp_x_ic_header_rec.attribute15 := p7_a25;
376: ddp_x_ic_header_rec.operation_flag := p7_a26;
377:
378: ahl_mc_item_comp_pvt_w.rosetta_table_copy_in_p2(ddp_x_det_tbl, p8_a0
379: , p8_a1
380: , p8_a2
381: , p8_a3
382: , p8_a4

Line 412: ahl_mc_item_comp_pvt.create_item_composition(p_api_version,

408: , p8_a30
409: );
410:
411: -- here's the delegated call to the old PL/SQL routine
412: ahl_mc_item_comp_pvt.create_item_composition(p_api_version,
413: p_init_msg_list,
414: p_commit,
415: p_validation_level,
416: x_return_status,

Line 458: ahl_mc_item_comp_pvt_w.rosetta_table_copy_out_p2(ddp_x_det_tbl, p8_a0

454: p7_a24 := ddp_x_ic_header_rec.attribute14;
455: p7_a25 := ddp_x_ic_header_rec.attribute15;
456: p7_a26 := ddp_x_ic_header_rec.operation_flag;
457:
458: ahl_mc_item_comp_pvt_w.rosetta_table_copy_out_p2(ddp_x_det_tbl, p8_a0
459: , p8_a1
460: , p8_a2
461: , p8_a3
462: , p8_a4

Line 560: ddp_x_ic_header_rec ahl_mc_item_comp_pvt.header_rec_type;

556: , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_100
557: )
558:
559: as
560: ddp_x_ic_header_rec ahl_mc_item_comp_pvt.header_rec_type;
561: ddp_x_det_tbl ahl_mc_item_comp_pvt.det_tbl_type;
562: ddindx binary_integer; indx binary_integer;
563: begin
564:

Line 561: ddp_x_det_tbl ahl_mc_item_comp_pvt.det_tbl_type;

557: )
558:
559: as
560: ddp_x_ic_header_rec ahl_mc_item_comp_pvt.header_rec_type;
561: ddp_x_det_tbl ahl_mc_item_comp_pvt.det_tbl_type;
562: ddindx binary_integer; indx binary_integer;
563: begin
564:
565: -- copy data to the local IN or IN-OUT args, if any

Line 601: ahl_mc_item_comp_pvt_w.rosetta_table_copy_in_p2(ddp_x_det_tbl, p8_a0

597: ddp_x_ic_header_rec.attribute14 := p7_a24;
598: ddp_x_ic_header_rec.attribute15 := p7_a25;
599: ddp_x_ic_header_rec.operation_flag := p7_a26;
600:
601: ahl_mc_item_comp_pvt_w.rosetta_table_copy_in_p2(ddp_x_det_tbl, p8_a0
602: , p8_a1
603: , p8_a2
604: , p8_a3
605: , p8_a4

Line 635: ahl_mc_item_comp_pvt.modify_item_composition(p_api_version,

631: , p8_a30
632: );
633:
634: -- here's the delegated call to the old PL/SQL routine
635: ahl_mc_item_comp_pvt.modify_item_composition(p_api_version,
636: p_init_msg_list,
637: p_commit,
638: p_validation_level,
639: x_return_status,

Line 681: ahl_mc_item_comp_pvt_w.rosetta_table_copy_out_p2(ddp_x_det_tbl, p8_a0

677: p7_a24 := ddp_x_ic_header_rec.attribute14;
678: p7_a25 := ddp_x_ic_header_rec.attribute15;
679: p7_a26 := ddp_x_ic_header_rec.operation_flag;
680:
681: ahl_mc_item_comp_pvt_w.rosetta_table_copy_out_p2(ddp_x_det_tbl, p8_a0
682: , p8_a1
683: , p8_a2
684: , p8_a3
685: , p8_a4

Line 715: end ahl_mc_item_comp_pvt_w;

711: , p8_a30
712: );
713: end;
714:
715: end ahl_mc_item_comp_pvt_w;