APPS.AHL_MM_RESERVATIONS_PVT_W dependencies on AHL_MM_RESERVATIONS_PVT

Line 1: package body ahl_mm_reservations_pvt_w as

1: package body ahl_mm_reservations_pvt_w as
2: /* $Header: AHLWMMRB.pls 120.0.12020000.2 2012/12/13 06:01:51 shnatu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_reservations_pvt.serial_number_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: ) as

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_reservations_pvt.serial_number_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_mm_reservations_pvt_w as
2: /* $Header: AHLWMMRB.pls 120.0.12020000.2 2012/12/13 06:01:51 shnatu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_reservations_pvt.serial_number_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin

Line 24: procedure rosetta_table_copy_out_p2(t ahl_mm_reservations_pvt.serial_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

20: end loop;
21: end if;
22: end if;
23: end rosetta_table_copy_in_p2;
24: procedure rosetta_table_copy_out_p2(t ahl_mm_reservations_pvt.serial_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_VARCHAR2_TABLE_100
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin

Line 53: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mm_reservations_pvt.number_table_type, a0 JTF_NUMBER_TABLE) as

49: end if;
50: end if;
51: end rosetta_table_copy_out_p2;
52:
53: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mm_reservations_pvt.number_table_type, a0 JTF_NUMBER_TABLE) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if a0 is not null and a0.count > 0 then
57: if a0.count > 0 then

Line 71: procedure rosetta_table_copy_out_p4(t ahl_mm_reservations_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE) as

67: end loop;
68: end if;
69: end if;
70: end rosetta_table_copy_in_p4;
71: procedure rosetta_table_copy_out_p4(t ahl_mm_reservations_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE) as
72: ddindx binary_integer; indx binary_integer;
73: begin
74: if t is null or t.count = 0 then
75: a0 := JTF_NUMBER_TABLE();

Line 94: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mm_reservations_pvt.varchar_table_type, a0 JTF_VARCHAR2_TABLE_100) as

90: end if;
91: end if;
92: end rosetta_table_copy_out_p4;
93:
94: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mm_reservations_pvt.varchar_table_type, a0 JTF_VARCHAR2_TABLE_100) as
95: ddindx binary_integer; indx binary_integer;
96: begin
97: if a0 is not null and a0.count > 0 then
98: if a0.count > 0 then

Line 112: procedure rosetta_table_copy_out_p5(t ahl_mm_reservations_pvt.varchar_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

108: end loop;
109: end if;
110: end if;
111: end rosetta_table_copy_in_p5;
112: procedure rosetta_table_copy_out_p5(t ahl_mm_reservations_pvt.varchar_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
113: ddindx binary_integer; indx binary_integer;
114: begin
115: if t is null or t.count = 0 then
116: a0 := JTF_VARCHAR2_TABLE_100();

Line 220: ddp_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;

216: , x_reservation_id out nocopy NUMBER
217: )
218:
219: as
220: ddp_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;
221: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
222: ddindx binary_integer; indx binary_integer;
223: begin
224:

Line 221: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;

217: )
218:
219: as
220: ddp_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;
221: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
222: ddindx binary_integer; indx binary_integer;
223: begin
224:
225: -- copy data to the local IN or IN-OUT args, if any

Line 306: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p9_a0

302: ddp_rsv_rec.orig_demand_source_line_id := p8_a68;
303: ddp_rsv_rec.orig_demand_source_line_detail := p8_a69;
304: ddp_rsv_rec.serial_number := p8_a70;
305:
306: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p9_a0
307: , p9_a1
308: );
309:
310:

Line 312: ahl_mm_reservations_pvt.create_reservation(p_api_version,

308: );
309:
310:
311: -- here's the delegated call to the old PL/SQL routine
312: ahl_mm_reservations_pvt.create_reservation(p_api_version,
313: p_init_msg_list,
314: p_commit,
315: p_validation_level,
316: p_module_type,

Line 422: ddp_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;

418: , p10_a1 JTF_VARCHAR2_TABLE_100
419: )
420:
421: as
422: ddp_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;
423: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
424: ddindx binary_integer; indx binary_integer;
425: begin
426:

Line 423: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;

419: )
420:
421: as
422: ddp_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;
423: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
424: ddindx binary_integer; indx binary_integer;
425: begin
426:
427: -- copy data to the local IN or IN-OUT args, if any

Line 509: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p10_a0

505: ddp_rsv_rec.orig_demand_source_line_id := p9_a68;
506: ddp_rsv_rec.orig_demand_source_line_detail := p9_a69;
507: ddp_rsv_rec.serial_number := p9_a70;
508:
509: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p10_a0
510: , p10_a1
511: );
512:
513: -- here's the delegated call to the old PL/SQL routine

Line 514: ahl_mm_reservations_pvt.update_reservation(p_api_version,

510: , p10_a1
511: );
512:
513: -- here's the delegated call to the old PL/SQL routine
514: ahl_mm_reservations_pvt.update_reservation(p_api_version,
515: p_init_msg_list,
516: p_commit,
517: p_validation_level,
518: p_module_type,

Line 553: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;

549: , p9_a1 JTF_VARCHAR2_TABLE_100
550: )
551:
552: as
553: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
554: ddindx binary_integer; indx binary_integer;
555: begin
556:
557: -- copy data to the local IN or IN-OUT args, if any

Line 567: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p9_a0

563:
564:
565:
566:
567: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p9_a0
568: , p9_a1
569: );
570:
571: -- here's the delegated call to the old PL/SQL routine

Line 572: ahl_mm_reservations_pvt.relieve_reservation(p_api_version,

568: , p9_a1
569: );
570:
571: -- here's the delegated call to the old PL/SQL routine
572: ahl_mm_reservations_pvt.relieve_reservation(p_api_version,
573: p_init_msg_list,
574: p_commit,
575: p_validation_level,
576: p_module_type,

Line 681: ddp_to_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;

677: , x_to_reservation_id out nocopy NUMBER
678: )
679:
680: as
681: ddp_to_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;
682: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
683: ddindx binary_integer; indx binary_integer;
684: begin
685:

Line 682: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;

678: )
679:
680: as
681: ddp_to_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;
682: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
683: ddindx binary_integer; indx binary_integer;
684: begin
685:
686: -- copy data to the local IN or IN-OUT args, if any

Line 768: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p10_a0

764: ddp_to_rsv_rec.orig_demand_source_line_id := p9_a68;
765: ddp_to_rsv_rec.orig_demand_source_line_detail := p9_a69;
766: ddp_to_rsv_rec.serial_number := p9_a70;
767:
768: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p10_a0
769: , p10_a1
770: );
771:
772:

Line 774: ahl_mm_reservations_pvt.transfer_reservation(p_api_version,

770: );
771:
772:
773: -- here's the delegated call to the old PL/SQL routine
774: ahl_mm_reservations_pvt.transfer_reservation(p_api_version,
775: p_init_msg_list,
776: p_commit,
777: p_validation_level,
778: p_module_type,

Line 886: ddp_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;

882: , x_reservation_id_tbl out nocopy JTF_NUMBER_TABLE
883: )
884:
885: as
886: ddp_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;
887: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
888: ddx_reservation_id_tbl ahl_mm_reservations_pvt.number_table_type;
889: ddindx binary_integer; indx binary_integer;
890: begin

Line 887: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;

883: )
884:
885: as
886: ddp_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;
887: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
888: ddx_reservation_id_tbl ahl_mm_reservations_pvt.number_table_type;
889: ddindx binary_integer; indx binary_integer;
890: begin
891:

Line 888: ddx_reservation_id_tbl ahl_mm_reservations_pvt.number_table_type;

884:
885: as
886: ddp_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;
887: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
888: ddx_reservation_id_tbl ahl_mm_reservations_pvt.number_table_type;
889: ddindx binary_integer; indx binary_integer;
890: begin
891:
892: -- copy data to the local IN or IN-OUT args, if any

Line 973: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p9_a0

969: ddp_rsv_rec.orig_demand_source_line_id := p8_a68;
970: ddp_rsv_rec.orig_demand_source_line_detail := p8_a69;
971: ddp_rsv_rec.serial_number := p8_a70;
972:
973: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p9_a0
974: , p9_a1
975: );
976:
977:

Line 979: ahl_mm_reservations_pvt.process_reservation(p_api_version,

975: );
976:
977:
978: -- here's the delegated call to the old PL/SQL routine
979: ahl_mm_reservations_pvt.process_reservation(p_api_version,
980: p_init_msg_list,
981: p_commit,
982: p_validation_level,
983: p_module_type,

Line 1002: ahl_mm_reservations_pvt_w.rosetta_table_copy_out_p4(ddx_reservation_id_tbl, x_reservation_id_tbl);

998:
999:
1000:
1001:
1002: ahl_mm_reservations_pvt_w.rosetta_table_copy_out_p4(ddx_reservation_id_tbl, x_reservation_id_tbl);
1003: end;
1004:
1005: procedure cancel_reservation(p_api_version NUMBER
1006: , p_init_msg_list VARCHAR2

Line 1019: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;

1015: , p_reservation_id_tbl JTF_NUMBER_TABLE
1016: )
1017:
1018: as
1019: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
1020: ddp_reservation_id_tbl ahl_mm_reservations_pvt.number_table_type;
1021: ddindx binary_integer; indx binary_integer;
1022: begin
1023:

Line 1020: ddp_reservation_id_tbl ahl_mm_reservations_pvt.number_table_type;

1016: )
1017:
1018: as
1019: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;
1020: ddp_reservation_id_tbl ahl_mm_reservations_pvt.number_table_type;
1021: ddindx binary_integer; indx binary_integer;
1022: begin
1023:
1024: -- copy data to the local IN or IN-OUT args, if any

Line 1033: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p8_a0

1029:
1030:
1031:
1032:
1033: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p8_a0
1034: , p8_a1
1035: );
1036:
1037: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p4(ddp_reservation_id_tbl, p_reservation_id_tbl);

Line 1037: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p4(ddp_reservation_id_tbl, p_reservation_id_tbl);

1033: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p2(ddp_serial_number_tbl, p8_a0
1034: , p8_a1
1035: );
1036:
1037: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p4(ddp_reservation_id_tbl, p_reservation_id_tbl);
1038:
1039: -- here's the delegated call to the old PL/SQL routine
1040: ahl_mm_reservations_pvt.cancel_reservation(p_api_version,
1041: p_init_msg_list,

Line 1040: ahl_mm_reservations_pvt.cancel_reservation(p_api_version,

1036:
1037: ahl_mm_reservations_pvt_w.rosetta_table_copy_in_p4(ddp_reservation_id_tbl, p_reservation_id_tbl);
1038:
1039: -- here's the delegated call to the old PL/SQL routine
1040: ahl_mm_reservations_pvt.cancel_reservation(p_api_version,
1041: p_init_msg_list,
1042: p_commit,
1043: p_validation_level,
1044: p_module_type,

Line 1063: end ahl_mm_reservations_pvt_w;

1059:
1060:
1061: end;
1062:
1063: end ahl_mm_reservations_pvt_w;