DBA Data[Home] [Help]

APPS.AHL_MC_ITEMGROUP_PVT_W dependencies on AHL_MC_ITEMGROUP_PVT

Line 1: package body ahl_mc_itemgroup_pvt_w as

1: package body ahl_mc_itemgroup_pvt_w as
2: /* $Header: AHLVIGWB.pls 120.1 2005/08/09 11:02 priyan 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:

Line 13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mc_itemgroup_pvt.item_association_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mc_itemgroup_pvt.item_association_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100

Line 96: procedure rosetta_table_copy_out_p2(t ahl_mc_itemgroup_pvt.item_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 348: ddp_x_item_group_rec ahl_mc_itemgroup_pvt.item_group_rec_type;

344: , p7_a32 in out nocopy JTF_VARCHAR2_TABLE_100
345: )
346:
347: as
348: ddp_x_item_group_rec ahl_mc_itemgroup_pvt.item_group_rec_type;
349: ddp_x_items_tbl ahl_mc_itemgroup_pvt.item_association_tbl_type;
350: ddindx binary_integer; indx binary_integer;
351: begin
352:

Line 349: ddp_x_items_tbl ahl_mc_itemgroup_pvt.item_association_tbl_type;

345: )
346:
347: as
348: ddp_x_item_group_rec ahl_mc_itemgroup_pvt.item_group_rec_type;
349: ddp_x_items_tbl ahl_mc_itemgroup_pvt.item_association_tbl_type;
350: ddindx binary_integer; indx binary_integer;
351: begin
352:
353: -- copy data to the local IN or IN-OUT args, if any

Line 387: ahl_mc_itemgroup_pvt_w.rosetta_table_copy_in_p2(ddp_x_items_tbl, p7_a0

383: ddp_x_item_group_rec.attribute14 := p6_a23;
384: ddp_x_item_group_rec.attribute15 := p6_a24;
385: ddp_x_item_group_rec.operation_flag := p6_a25;
386:
387: ahl_mc_itemgroup_pvt_w.rosetta_table_copy_in_p2(ddp_x_items_tbl, p7_a0
388: , p7_a1
389: , p7_a2
390: , p7_a3
391: , p7_a4

Line 423: ahl_mc_itemgroup_pvt.create_item_group(p_api_version,

419: , p7_a32
420: );
421:
422: -- here's the delegated call to the old PL/SQL routine
423: ahl_mc_itemgroup_pvt.create_item_group(p_api_version,
424: p_init_msg_list,
425: p_validation_level,
426: x_return_status,
427: x_msg_count,

Line 466: ahl_mc_itemgroup_pvt_w.rosetta_table_copy_out_p2(ddp_x_items_tbl, p7_a0

462: p6_a23 := ddp_x_item_group_rec.attribute14;
463: p6_a24 := ddp_x_item_group_rec.attribute15;
464: p6_a25 := ddp_x_item_group_rec.operation_flag;
465:
466: ahl_mc_itemgroup_pvt_w.rosetta_table_copy_out_p2(ddp_x_items_tbl, p7_a0
467: , p7_a1
468: , p7_a2
469: , p7_a3
470: , p7_a4

Line 570: ddp_item_group_rec ahl_mc_itemgroup_pvt.item_group_rec_type;

566: , p7_a32 in out nocopy JTF_VARCHAR2_TABLE_100
567: )
568:
569: as
570: ddp_item_group_rec ahl_mc_itemgroup_pvt.item_group_rec_type;
571: ddp_x_items_tbl ahl_mc_itemgroup_pvt.item_association_tbl_type;
572: ddindx binary_integer; indx binary_integer;
573: begin
574:

Line 571: ddp_x_items_tbl ahl_mc_itemgroup_pvt.item_association_tbl_type;

567: )
568:
569: as
570: ddp_item_group_rec ahl_mc_itemgroup_pvt.item_group_rec_type;
571: ddp_x_items_tbl ahl_mc_itemgroup_pvt.item_association_tbl_type;
572: ddindx binary_integer; indx binary_integer;
573: begin
574:
575: -- copy data to the local IN or IN-OUT args, if any

Line 609: ahl_mc_itemgroup_pvt_w.rosetta_table_copy_in_p2(ddp_x_items_tbl, p7_a0

605: ddp_item_group_rec.attribute14 := p6_a23;
606: ddp_item_group_rec.attribute15 := p6_a24;
607: ddp_item_group_rec.operation_flag := p6_a25;
608:
609: ahl_mc_itemgroup_pvt_w.rosetta_table_copy_in_p2(ddp_x_items_tbl, p7_a0
610: , p7_a1
611: , p7_a2
612: , p7_a3
613: , p7_a4

Line 645: ahl_mc_itemgroup_pvt.modify_item_group(p_api_version,

641: , p7_a32
642: );
643:
644: -- here's the delegated call to the old PL/SQL routine
645: ahl_mc_itemgroup_pvt.modify_item_group(p_api_version,
646: p_init_msg_list,
647: p_validation_level,
648: x_return_status,
649: x_msg_count,

Line 662: ahl_mc_itemgroup_pvt_w.rosetta_table_copy_out_p2(ddp_x_items_tbl, p7_a0

658:
659:
660:
661:
662: ahl_mc_itemgroup_pvt_w.rosetta_table_copy_out_p2(ddp_x_items_tbl, p7_a0
663: , p7_a1
664: , p7_a2
665: , p7_a3
666: , p7_a4

Line 733: ddp_item_group_rec ahl_mc_itemgroup_pvt.item_group_rec_type;

729: , p6_a25 VARCHAR2
730: )
731:
732: as
733: ddp_item_group_rec ahl_mc_itemgroup_pvt.item_group_rec_type;
734: ddindx binary_integer; indx binary_integer;
735: begin
736:
737: -- copy data to the local IN or IN-OUT args, if any

Line 772: ahl_mc_itemgroup_pvt.remove_item_group(p_api_version,

768: ddp_item_group_rec.attribute15 := p6_a24;
769: ddp_item_group_rec.operation_flag := p6_a25;
770:
771: -- here's the delegated call to the old PL/SQL routine
772: ahl_mc_itemgroup_pvt.remove_item_group(p_api_version,
773: p_init_msg_list,
774: p_validation_level,
775: x_return_status,
776: x_msg_count,

Line 894: ahl_mc_itemgroup_pvt.modify_position_assos(p_api_version,

890: , p10_a36
891: );
892:
893: -- here's the delegated call to the old PL/SQL routine
894: ahl_mc_itemgroup_pvt.modify_position_assos(p_api_version,
895: p_init_msg_list,
896: p_commit,
897: p_validation_level,
898: p_module_type,

Line 919: end ahl_mc_itemgroup_pvt_w;

915:
916:
917: end;
918:
919: end ahl_mc_itemgroup_pvt_w;