APPS.AHL_MM_MTL_MGT_PVT_W dependencies on AHL_MM_MTL_MGT_PVT

Line 1: package body ahl_mm_mtl_mgt_pvt_w as

1: package body ahl_mm_mtl_mgt_pvt_w as
2: /* $Header: AHLWMMGB.pls 120.0.12020000.2 2012/12/13 05:58:33 shnatu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100) as
4: ddindx binary_integer; indx binary_integer;
5: begin

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100) as

1: package body ahl_mm_mtl_mgt_pvt_w as
2: /* $Header: AHLWMMGB.pls 120.0.12020000.2 2012/12/13 05:58:33 shnatu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is null then
7: t := null;

Line 9: t := ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100();

5: begin
6: if a0 is null then
7: t := null;
8: elsif a0.count = 0 then
9: t := ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100();
10: else
11: if a0.count > 0 then
12: t := ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100();
13: t.extend(a0.count);

Line 12: t := ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100();

8: elsif a0.count = 0 then
9: t := ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100();
10: else
11: if a0.count > 0 then
12: t := ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100();
13: t.extend(a0.count);
14: indx := a0.first;
15: ddindx := 1;
16: while true loop

Line 27: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

23: end loop;
24: end if;
25: end if;
26: end rosetta_table_copy_in_p2;
27: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if t is null then
31: a0 := null;

Line 52: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE) as

48: end if;
49: end if;
50: end rosetta_table_copy_out_p2;
51:
52: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE) as
53: ddindx binary_integer; indx binary_integer;
54: begin
55: if a0 is null then
56: t := null;

Line 58: t := ahl_mm_mtl_mgt_pvt.oaf_number_table();

54: begin
55: if a0 is null then
56: t := null;
57: elsif a0.count = 0 then
58: t := ahl_mm_mtl_mgt_pvt.oaf_number_table();
59: else
60: if a0.count > 0 then
61: t := ahl_mm_mtl_mgt_pvt.oaf_number_table();
62: t.extend(a0.count);

Line 61: t := ahl_mm_mtl_mgt_pvt.oaf_number_table();

57: elsif a0.count = 0 then
58: t := ahl_mm_mtl_mgt_pvt.oaf_number_table();
59: else
60: if a0.count > 0 then
61: t := ahl_mm_mtl_mgt_pvt.oaf_number_table();
62: t.extend(a0.count);
63: indx := a0.first;
64: ddindx := 1;
65: while true loop

Line 76: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE) as

72: end loop;
73: end if;
74: end if;
75: end rosetta_table_copy_in_p3;
76: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE) as
77: ddindx binary_integer; indx binary_integer;
78: begin
79: if t is null then
80: a0 := null;

Line 101: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE

97: end if;
98: end if;
99: end rosetta_table_copy_out_p3;
100:
101: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
102: , a1 JTF_VARCHAR2_TABLE_100
103: , a2 JTF_NUMBER_TABLE
104: , a3 JTF_VARCHAR2_TABLE_100
105: , a4 JTF_NUMBER_TABLE

Line 118: t := ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type();

114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if a0 is not null and a0.count=0 then
118: t := ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type();
119: elsif a0 is not null and a0.count > 0 then
120: if a0.count > 0 then
121: t := ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type();
122: t.extend(a0.count);

Line 121: t := ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type();

117: if a0 is not null and a0.count=0 then
118: t := ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type();
119: elsif a0 is not null and a0.count > 0 then
120: if a0.count > 0 then
121: t := ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type();
122: t.extend(a0.count);
123: indx := a0.first;
124: ddindx := 1;
125: while true loop

Line 148: procedure rosetta_table_copy_out_p10(t ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

144: end loop;
145: end if;
146: end if;
147: end rosetta_table_copy_in_p10;
148: procedure rosetta_table_copy_out_p10(t ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
149: , a1 out nocopy JTF_VARCHAR2_TABLE_100
150: , a2 out nocopy JTF_NUMBER_TABLE
151: , a3 out nocopy JTF_VARCHAR2_TABLE_100
152: , a4 out nocopy JTF_NUMBER_TABLE

Line 246: procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE

242: end if;
243: end if;
244: end rosetta_table_copy_out_p10;
245:
246: procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE
247: , a1 JTF_NUMBER_TABLE
248: , a2 JTF_DATE_TABLE
249: , a3 JTF_NUMBER_TABLE
250: , a4 JTF_VARCHAR2_TABLE_2000

Line 273: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE

269: end loop;
270: end if;
271: end if;
272: end rosetta_table_copy_in_p11;
273: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE
274: , a1 out nocopy JTF_NUMBER_TABLE
275: , a2 out nocopy JTF_DATE_TABLE
276: , a3 out nocopy JTF_NUMBER_TABLE
277: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 317: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE) as

313: end if;
314: end if;
315: end rosetta_table_copy_out_p11;
316:
317: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE) as
318: ddindx binary_integer; indx binary_integer;
319: begin
320: if a0 is not null and a0.count > 0 then
321: if a0.count > 0 then

Line 335: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE) as

331: end loop;
332: end if;
333: end if;
334: end rosetta_table_copy_in_p12;
335: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();

Line 358: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE

354: end if;
355: end if;
356: end rosetta_table_copy_out_p12;
357:
358: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE
359: , a1 JTF_VARCHAR2_TABLE_100
360: , a2 JTF_NUMBER_TABLE
361: , a3 JTF_VARCHAR2_TABLE_100
362: ) as

Line 383: procedure rosetta_table_copy_out_p13(t ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

379: end loop;
380: end if;
381: end if;
382: end rosetta_table_copy_in_p13;
383: procedure rosetta_table_copy_out_p13(t ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
384: , a1 out nocopy JTF_VARCHAR2_TABLE_100
385: , a2 out nocopy JTF_NUMBER_TABLE
386: , a3 out nocopy JTF_VARCHAR2_TABLE_100
387: ) as

Line 422: procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE

418: end if;
419: end if;
420: end rosetta_table_copy_out_p13;
421:
422: procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE
423: , a1 JTF_VARCHAR2_TABLE_100
424: , a2 JTF_NUMBER_TABLE
425: ) as
426: ddindx binary_integer; indx binary_integer;

Line 445: procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

441: end loop;
442: end if;
443: end if;
444: end rosetta_table_copy_in_p14;
445: procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
446: , a1 out nocopy JTF_VARCHAR2_TABLE_100
447: , a2 out nocopy JTF_NUMBER_TABLE
448: ) as
449: ddindx binary_integer; indx binary_integer;

Line 479: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE

475: end if;
476: end if;
477: end rosetta_table_copy_out_p14;
478:
479: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE
480: , a1 JTF_NUMBER_TABLE
481: , a2 JTF_VARCHAR2_TABLE_2000
482: ) as
483: ddindx binary_integer; indx binary_integer;

Line 502: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE

498: end loop;
499: end if;
500: end if;
501: end rosetta_table_copy_in_p15;
502: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE
503: , a1 out nocopy JTF_NUMBER_TABLE
504: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
505: ) as
506: ddindx binary_integer; indx binary_integer;

Line 536: procedure rosetta_table_copy_in_p34(t out nocopy ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 JTF_NUMBER_TABLE) as

532: end if;
533: end if;
534: end rosetta_table_copy_out_p15;
535:
536: procedure rosetta_table_copy_in_p34(t out nocopy ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 JTF_NUMBER_TABLE) as
537: ddindx binary_integer; indx binary_integer;
538: begin
539: if a0 is not null and a0.count > 0 then
540: if a0.count > 0 then

Line 554: procedure rosetta_table_copy_out_p34(t ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 out nocopy JTF_NUMBER_TABLE) as

550: end loop;
551: end if;
552: end if;
553: end rosetta_table_copy_in_p34;
554: procedure rosetta_table_copy_out_p34(t ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
555: ddindx binary_integer; indx binary_integer;
556: begin
557: if t is null or t.count = 0 then
558: a0 := JTF_NUMBER_TABLE();

Line 594: ddp_schedule_material_id_tbl ahl_mm_mtl_mgt_pvt.number_table_type;

590: , x_msg_data out nocopy VARCHAR2
591: )
592:
593: as
594: ddp_schedule_material_id_tbl ahl_mm_mtl_mgt_pvt.number_table_type;
595: ddx_mtl_avl_schld_tbl ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl;
596: ddindx binary_integer; indx binary_integer;
597: begin
598:

Line 595: ddx_mtl_avl_schld_tbl ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl;

591: )
592:
593: as
594: ddp_schedule_material_id_tbl ahl_mm_mtl_mgt_pvt.number_table_type;
595: ddx_mtl_avl_schld_tbl ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl;
596: ddindx binary_integer; indx binary_integer;
597: begin
598:
599: -- copy data to the local IN or IN-OUT args, if any

Line 605: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p12(ddp_schedule_material_id_tbl, p_schedule_material_id_tbl);

601:
602:
603:
604:
605: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p12(ddp_schedule_material_id_tbl, p_schedule_material_id_tbl);
606:
607:
608:
609:

Line 612: ahl_mm_mtl_mgt_pvt.check_availability(p_api_version,

608:
609:
610:
611: -- here's the delegated call to the old PL/SQL routine
612: ahl_mm_mtl_mgt_pvt.check_availability(p_api_version,
613: p_init_msg_list,
614: p_commit,
615: p_module_type,
616: p_validation_level,

Line 630: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p11(ddx_mtl_avl_schld_tbl, p6_a0

626:
627:
628:
629:
630: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p11(ddx_mtl_avl_schld_tbl, p6_a0
631: , p6_a1
632: , p6_a2
633: , p6_a3
634: , p6_a4

Line 658: ddp_schedule_material_id_tbl ahl_mm_mtl_mgt_pvt.number_table_type;

654: , x_msg_data out nocopy VARCHAR2
655: )
656:
657: as
658: ddp_schedule_material_id_tbl ahl_mm_mtl_mgt_pvt.number_table_type;
659: ddx_mtl_avl_schld_tbl ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl;
660: ddindx binary_integer; indx binary_integer;
661: begin
662:

Line 659: ddx_mtl_avl_schld_tbl ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl;

655: )
656:
657: as
658: ddp_schedule_material_id_tbl ahl_mm_mtl_mgt_pvt.number_table_type;
659: ddx_mtl_avl_schld_tbl ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl;
660: ddindx binary_integer; indx binary_integer;
661: begin
662:
663: -- copy data to the local IN or IN-OUT args, if any

Line 669: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p12(ddp_schedule_material_id_tbl, p_schedule_material_id_tbl);

665:
666:
667:
668:
669: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p12(ddp_schedule_material_id_tbl, p_schedule_material_id_tbl);
670:
671:
672:
673:

Line 676: ahl_mm_mtl_mgt_pvt.schedule_materials(p_api_version,

672:
673:
674:
675: -- here's the delegated call to the old PL/SQL routine
676: ahl_mm_mtl_mgt_pvt.schedule_materials(p_api_version,
677: p_init_msg_list,
678: p_commit,
679: p_module_type,
680: p_validation_level,

Line 694: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p11(ddx_mtl_avl_schld_tbl, p6_a0

690:
691:
692:
693:
694: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p11(ddx_mtl_avl_schld_tbl, p6_a0
695: , p6_a1
696: , p6_a2
697: , p6_a3
698: , p6_a4

Line 722: ddx_mtl_avl_schld_tbl ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl;

718: , x_msg_data out nocopy VARCHAR2
719: )
720:
721: as
722: ddx_mtl_avl_schld_tbl ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl;
723: ddindx binary_integer; indx binary_integer;
724: begin
725:
726: -- copy data to the local IN or IN-OUT args, if any

Line 738: ahl_mm_mtl_mgt_pvt.schedule_visit_materials(p_api_version,

734:
735:
736:
737: -- here's the delegated call to the old PL/SQL routine
738: ahl_mm_mtl_mgt_pvt.schedule_visit_materials(p_api_version,
739: p_init_msg_list,
740: p_commit,
741: p_module_type,
742: p_validation_level,

Line 756: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p11(ddx_mtl_avl_schld_tbl, p6_a0

752:
753:
754:
755:
756: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p11(ddx_mtl_avl_schld_tbl, p6_a0
757: , p6_a1
758: , p6_a2
759: , p6_a3
760: , p6_a4

Line 784: ddp_supply_tbl_type ahl_mm_mtl_mgt_pvt.supply_tbl_type;

780: , x_msg_data out nocopy VARCHAR2
781: )
782:
783: as
784: ddp_supply_tbl_type ahl_mm_mtl_mgt_pvt.supply_tbl_type;
785: ddx_mo_lines_tbl ahl_mm_mtl_mgt_pvt.number_table_type;
786: ddindx binary_integer; indx binary_integer;
787: begin
788:

Line 785: ddx_mo_lines_tbl ahl_mm_mtl_mgt_pvt.number_table_type;

781: )
782:
783: as
784: ddp_supply_tbl_type ahl_mm_mtl_mgt_pvt.supply_tbl_type;
785: ddx_mo_lines_tbl ahl_mm_mtl_mgt_pvt.number_table_type;
786: ddindx binary_integer; indx binary_integer;
787: begin
788:
789: -- copy data to the local IN or IN-OUT args, if any

Line 795: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p13(ddp_supply_tbl_type, p5_a0

791:
792:
793:
794:
795: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p13(ddp_supply_tbl_type, p5_a0
796: , p5_a1
797: , p5_a2
798: , p5_a3
799: );

Line 807: ahl_mm_mtl_mgt_pvt.create_move_order(p_api_version,

803:
804:
805:
806: -- here's the delegated call to the old PL/SQL routine
807: ahl_mm_mtl_mgt_pvt.create_move_order(p_api_version,
808: p_init_msg_list,
809: p_commit,
810: p_validation_level,
811: p_scheduled_material_id,

Line 827: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p12(ddx_mo_lines_tbl, x_mo_lines_tbl);

823:
824:
825:
826:
827: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p12(ddx_mo_lines_tbl, x_mo_lines_tbl);
828:
829:
830:
831: end;

Line 844: ddp_asm_id_tab ahl_mm_mtl_mgt_pvt.number_table_type;

840: , x_msg_data out nocopy VARCHAR2
841: )
842:
843: as
844: ddp_asm_id_tab ahl_mm_mtl_mgt_pvt.number_table_type;
845: ddindx binary_integer; indx binary_integer;
846: begin
847:
848: -- copy data to the local IN or IN-OUT args, if any

Line 853: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p12(ddp_asm_id_tab, p_asm_id_tab);

849:
850:
851:
852:
853: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p12(ddp_asm_id_tab, p_asm_id_tab);
854:
855:
856:
857:

Line 859: ahl_mm_mtl_mgt_pvt.invoke_aog_upd_notification(p_api_version,

855:
856:
857:
858: -- here's the delegated call to the old PL/SQL routine
859: ahl_mm_mtl_mgt_pvt.invoke_aog_upd_notification(p_api_version,
860: p_init_msg_list,
861: p_commit,
862: p_validation_level,
863: ddp_asm_id_tab,

Line 905: ddp_x_mtltfr_tbl ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type;

901: , x_reservation_id out nocopy NUMBER
902: )
903:
904: as
905: ddp_x_mtltfr_tbl ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type;
906: ddindx binary_integer; indx binary_integer;
907: begin
908:
909: -- copy data to the local IN or IN-OUT args, if any

Line 919: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p10(ddp_x_mtltfr_tbl, p9_a0

915:
916:
917:
918:
919: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p10(ddp_x_mtltfr_tbl, p9_a0
920: , p9_a1
921: , p9_a2
922: , p9_a3
923: , p9_a4

Line 937: ahl_mm_mtl_mgt_pvt.perform_inter_org_transfer(p_api_version,

933:
934:
935:
936: -- here's the delegated call to the old PL/SQL routine
937: ahl_mm_mtl_mgt_pvt.perform_inter_org_transfer(p_api_version,
938: p_init_msg_list,
939: p_commit,
940: p_validation_level,
941: p_default,

Line 960: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p10(ddp_x_mtltfr_tbl, p9_a0

956:
957:
958:
959:
960: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p10(ddp_x_mtltfr_tbl, p9_a0
961: , p9_a1
962: , p9_a2
963: , p9_a3
964: , p9_a4

Line 1003: ddp_x_mtltfr_tbl ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type;

999: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1000: )
1001:
1002: as
1003: ddp_x_mtltfr_tbl ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type;
1004: ddindx binary_integer; indx binary_integer;
1005: begin
1006:
1007: -- copy data to the local IN or IN-OUT args, if any

Line 1017: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p10(ddp_x_mtltfr_tbl, p9_a0

1013:
1014:
1015:
1016:
1017: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p10(ddp_x_mtltfr_tbl, p9_a0
1018: , p9_a1
1019: , p9_a2
1020: , p9_a3
1021: , p9_a4

Line 1033: ahl_mm_mtl_mgt_pvt.perform_inter_org_transfer_inv(p_api_version,

1029: , p9_a12
1030: );
1031:
1032: -- here's the delegated call to the old PL/SQL routine
1033: ahl_mm_mtl_mgt_pvt.perform_inter_org_transfer_inv(p_api_version,
1034: p_init_msg_list,
1035: p_commit,
1036: p_validation_level,
1037: p_default,

Line 1054: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p10(ddp_x_mtltfr_tbl, p9_a0

1050:
1051:
1052:
1053:
1054: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p10(ddp_x_mtltfr_tbl, p9_a0
1055: , p9_a1
1056: , p9_a2
1057: , p9_a3
1058: , p9_a4

Line 1090: ddp_source_org_tbl ahl_mm_mtl_mgt_pvt.oaf_number_table;

1086: , x_reservation_id out nocopy NUMBER
1087: )
1088:
1089: as
1090: ddp_source_org_tbl ahl_mm_mtl_mgt_pvt.oaf_number_table;
1091: ddp_source_sub_inv_tbl ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100;
1092: ddp_source_locators_tbl ahl_mm_mtl_mgt_pvt.oaf_number_table;
1093: ddp_serial_num_tbl ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100;
1094: ddindx binary_integer; indx binary_integer;

Line 1091: ddp_source_sub_inv_tbl ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100;

1087: )
1088:
1089: as
1090: ddp_source_org_tbl ahl_mm_mtl_mgt_pvt.oaf_number_table;
1091: ddp_source_sub_inv_tbl ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100;
1092: ddp_source_locators_tbl ahl_mm_mtl_mgt_pvt.oaf_number_table;
1093: ddp_serial_num_tbl ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100;
1094: ddindx binary_integer; indx binary_integer;
1095: begin

Line 1092: ddp_source_locators_tbl ahl_mm_mtl_mgt_pvt.oaf_number_table;

1088:
1089: as
1090: ddp_source_org_tbl ahl_mm_mtl_mgt_pvt.oaf_number_table;
1091: ddp_source_sub_inv_tbl ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100;
1092: ddp_source_locators_tbl ahl_mm_mtl_mgt_pvt.oaf_number_table;
1093: ddp_serial_num_tbl ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100;
1094: ddindx binary_integer; indx binary_integer;
1095: begin
1096:

Line 1093: ddp_serial_num_tbl ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100;

1089: as
1090: ddp_source_org_tbl ahl_mm_mtl_mgt_pvt.oaf_number_table;
1091: ddp_source_sub_inv_tbl ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100;
1092: ddp_source_locators_tbl ahl_mm_mtl_mgt_pvt.oaf_number_table;
1093: ddp_serial_num_tbl ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100;
1094: ddindx binary_integer; indx binary_integer;
1095: begin
1096:
1097: -- copy data to the local IN or IN-OUT args, if any

Line 1106: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p3(ddp_source_org_tbl, p_source_org_tbl);

1102:
1103:
1104:
1105:
1106: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p3(ddp_source_org_tbl, p_source_org_tbl);
1107:
1108: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p2(ddp_source_sub_inv_tbl, p_source_sub_inv_tbl);
1109:
1110: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p3(ddp_source_locators_tbl, p_source_locators_tbl);

Line 1108: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p2(ddp_source_sub_inv_tbl, p_source_sub_inv_tbl);

1104:
1105:
1106: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p3(ddp_source_org_tbl, p_source_org_tbl);
1107:
1108: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p2(ddp_source_sub_inv_tbl, p_source_sub_inv_tbl);
1109:
1110: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p3(ddp_source_locators_tbl, p_source_locators_tbl);
1111:
1112: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p2(ddp_serial_num_tbl, p_serial_num_tbl);

Line 1110: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p3(ddp_source_locators_tbl, p_source_locators_tbl);

1106: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p3(ddp_source_org_tbl, p_source_org_tbl);
1107:
1108: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p2(ddp_source_sub_inv_tbl, p_source_sub_inv_tbl);
1109:
1110: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p3(ddp_source_locators_tbl, p_source_locators_tbl);
1111:
1112: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p2(ddp_serial_num_tbl, p_serial_num_tbl);
1113:
1114:

Line 1112: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p2(ddp_serial_num_tbl, p_serial_num_tbl);

1108: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p2(ddp_source_sub_inv_tbl, p_source_sub_inv_tbl);
1109:
1110: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p3(ddp_source_locators_tbl, p_source_locators_tbl);
1111:
1112: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p2(ddp_serial_num_tbl, p_serial_num_tbl);
1113:
1114:
1115:
1116:

Line 1120: ahl_mm_mtl_mgt_pvt.create_internal_sales_order(p_api_version,

1116:
1117:
1118:
1119: -- here's the delegated call to the old PL/SQL routine
1120: ahl_mm_mtl_mgt_pvt.create_internal_sales_order(p_api_version,
1121: p_init_msg_list,
1122: p_commit,
1123: p_validation_level,
1124: x_msg_count,

Line 1168: ddp_schedule_material_id_tbl ahl_mm_mtl_mgt_pvt.number_table_type;

1164: , x_msg_data out nocopy VARCHAR2
1165: )
1166:
1167: as
1168: ddp_schedule_material_id_tbl ahl_mm_mtl_mgt_pvt.number_table_type;
1169: ddindx binary_integer; indx binary_integer;
1170: begin
1171:
1172: -- copy data to the local IN or IN-OUT args, if any

Line 1177: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p12(ddp_schedule_material_id_tbl, p_schedule_material_id_tbl);

1173:
1174:
1175:
1176:
1177: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p12(ddp_schedule_material_id_tbl, p_schedule_material_id_tbl);
1178:
1179:
1180:
1181:

Line 1183: ahl_mm_mtl_mgt_pvt.aog_upd_notification(p_api_version,

1179:
1180:
1181:
1182: -- here's the delegated call to the old PL/SQL routine
1183: ahl_mm_mtl_mgt_pvt.aog_upd_notification(p_api_version,
1184: p_init_msg_list,
1185: p_commit,
1186: p_validation_level,
1187: ddp_schedule_material_id_tbl,

Line 1215: ddp_aog_tbl ahl_mm_mtl_mgt_pvt.aog_tbl_type;

1211: , x_msg_data out nocopy VARCHAR2
1212: )
1213:
1214: as
1215: ddp_aog_tbl ahl_mm_mtl_mgt_pvt.aog_tbl_type;
1216: ddindx binary_integer; indx binary_integer;
1217: begin
1218:
1219: -- copy data to the local IN or IN-OUT args, if any

Line 1224: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p14(ddp_aog_tbl, p4_a0

1220:
1221:
1222:
1223:
1224: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p14(ddp_aog_tbl, p4_a0
1225: , p4_a1
1226: , p4_a2
1227: );
1228:

Line 1233: ahl_mm_mtl_mgt_pvt.update_aog(p_api_version,

1229:
1230:
1231:
1232: -- here's the delegated call to the old PL/SQL routine
1233: ahl_mm_mtl_mgt_pvt.update_aog(p_api_version,
1234: p_init_msg_list,
1235: p_commit,
1236: p_validation_level,
1237: ddp_aog_tbl,

Line 1277: ddp_demand_record ahl_mm_mtl_mgt_pvt.bg_demand_rec;

1273: , x_msg_data out nocopy VARCHAR2
1274: )
1275:
1276: as
1277: ddp_demand_record ahl_mm_mtl_mgt_pvt.bg_demand_rec;
1278: ddindx binary_integer; indx binary_integer;
1279: begin
1280:
1281: -- copy data to the local IN or IN-OUT args, if any

Line 1306: ahl_mm_mtl_mgt_pvt.filter_instances_matching_bg(p_api_version,

1302:
1303:
1304:
1305: -- here's the delegated call to the old PL/SQL routine
1306: ahl_mm_mtl_mgt_pvt.filter_instances_matching_bg(p_api_version,
1307: p_init_msg_list,
1308: p_commit,
1309: p_module_type,
1310: ddp_demand_record,

Line 1341: ddx_inv_mtl_avl_tbl ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl;

1337: , x_msg_data out nocopy VARCHAR2
1338: )
1339:
1340: as
1341: ddx_inv_mtl_avl_tbl ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl;
1342: ddindx binary_integer; indx binary_integer;
1343: begin
1344:
1345: -- copy data to the local IN or IN-OUT args, if any

Line 1358: ahl_mm_mtl_mgt_pvt.get_available_quantity(p_api_version,

1354:
1355:
1356:
1357: -- here's the delegated call to the old PL/SQL routine
1358: ahl_mm_mtl_mgt_pvt.get_available_quantity(p_api_version,
1359: p_init_msg_list,
1360: p_commit,
1361: p_module_type,
1362: p_validation_level,

Line 1378: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p15(ddx_inv_mtl_avl_tbl, p7_a0

1374:
1375:
1376:
1377:
1378: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p15(ddx_inv_mtl_avl_tbl, p7_a0
1379: , p7_a1
1380: , p7_a2
1381: );
1382:

Line 1404: ddp_visit_ids ahl_mm_mtl_mgt_pvt.visit_ids_tbl;

1400: , x_msg_data out nocopy VARCHAR2
1401: )
1402:
1403: as
1404: ddp_visit_ids ahl_mm_mtl_mgt_pvt.visit_ids_tbl;
1405: ddx_mtl_avl_schld_tbl ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl;
1406: ddindx binary_integer; indx binary_integer;
1407: begin
1408:

Line 1405: ddx_mtl_avl_schld_tbl ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl;

1401: )
1402:
1403: as
1404: ddp_visit_ids ahl_mm_mtl_mgt_pvt.visit_ids_tbl;
1405: ddx_mtl_avl_schld_tbl ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl;
1406: ddindx binary_integer; indx binary_integer;
1407: begin
1408:
1409: -- copy data to the local IN or IN-OUT args, if any

Line 1415: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p34(ddp_visit_ids, p_visit_ids);

1411:
1412:
1413:
1414:
1415: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_in_p34(ddp_visit_ids, p_visit_ids);
1416:
1417:
1418:
1419:

Line 1422: ahl_mm_mtl_mgt_pvt.sched_all_vst_mtls(p_api_version,

1418:
1419:
1420:
1421: -- here's the delegated call to the old PL/SQL routine
1422: ahl_mm_mtl_mgt_pvt.sched_all_vst_mtls(p_api_version,
1423: p_init_msg_list,
1424: p_commit,
1425: p_module_type,
1426: p_validation_level,

Line 1440: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p11(ddx_mtl_avl_schld_tbl, p6_a0

1436:
1437:
1438:
1439:
1440: ahl_mm_mtl_mgt_pvt_w.rosetta_table_copy_out_p11(ddx_mtl_avl_schld_tbl, p6_a0
1441: , p6_a1
1442: , p6_a2
1443: , p6_a3
1444: , p6_a4

Line 1451: end ahl_mm_mtl_mgt_pvt_w;

1447:
1448:
1449: end;
1450:
1451: end ahl_mm_mtl_mgt_pvt_w;