APPS.AHL_MM_RESERVATIONS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

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
8: if a0 is not null and a0.count > 0 then

Line 25: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
29: if t is null or t.count = 0 then

Line 31: a1 := JTF_VARCHAR2_TABLE_100();

27: ddindx binary_integer; indx binary_integer;
28: begin
29: if t is null or t.count = 0 then
30: a0 := JTF_NUMBER_TABLE();
31: a1 := JTF_VARCHAR2_TABLE_100();
32: else
33: a0 := JTF_NUMBER_TABLE();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: if t.count > 0 then

Line 34: a1 := JTF_VARCHAR2_TABLE_100();

30: a0 := JTF_NUMBER_TABLE();
31: a1 := JTF_VARCHAR2_TABLE_100();
32: else
33: a0 := JTF_NUMBER_TABLE();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: if t.count > 0 then
36: a0.extend(t.count);
37: a1.extend(t.count);
38: ddindx := t.first;

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 116: a0 := JTF_VARCHAR2_TABLE_100();

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();
117: else
118: a0 := JTF_VARCHAR2_TABLE_100();
119: if t.count > 0 then
120: a0.extend(t.count);

Line 118: a0 := JTF_VARCHAR2_TABLE_100();

114: begin
115: if t is null or t.count = 0 then
116: a0 := JTF_VARCHAR2_TABLE_100();
117: else
118: a0 := JTF_VARCHAR2_TABLE_100();
119: if t.count > 0 then
120: a0.extend(t.count);
121: ddindx := t.first;
122: indx := 1;

Line 215: , p9_a1 JTF_VARCHAR2_TABLE_100

211: , p8_a68 NUMBER
212: , p8_a69 NUMBER
213: , p8_a70 VARCHAR2
214: , p9_a0 JTF_NUMBER_TABLE
215: , p9_a1 JTF_VARCHAR2_TABLE_100
216: , x_reservation_id out nocopy NUMBER
217: )
218:
219: as

Line 418: , p10_a1 JTF_VARCHAR2_TABLE_100

414: , p9_a68 NUMBER
415: , p9_a69 NUMBER
416: , p9_a70 VARCHAR2
417: , p10_a0 JTF_NUMBER_TABLE
418: , p10_a1 JTF_VARCHAR2_TABLE_100
419: )
420:
421: as
422: ddp_rsv_rec ahl_mm_reservations_pvt.mtl_reservation_rec_type;

Line 549: , p9_a1 JTF_VARCHAR2_TABLE_100

545: , x_msg_count out nocopy NUMBER
546: , x_msg_data out nocopy VARCHAR2
547: , p_reservation_id NUMBER
548: , p9_a0 JTF_NUMBER_TABLE
549: , p9_a1 JTF_VARCHAR2_TABLE_100
550: )
551:
552: as
553: ddp_serial_number_tbl ahl_mm_reservations_pvt.serial_number_tbl_type;

Line 676: , p10_a1 JTF_VARCHAR2_TABLE_100

672: , p9_a68 NUMBER
673: , p9_a69 NUMBER
674: , p9_a70 VARCHAR2
675: , p10_a0 JTF_NUMBER_TABLE
676: , p10_a1 JTF_VARCHAR2_TABLE_100
677: , x_to_reservation_id out nocopy NUMBER
678: )
679:
680: as

Line 881: , p9_a1 JTF_VARCHAR2_TABLE_100

877: , p8_a68 NUMBER
878: , p8_a69 NUMBER
879: , p8_a70 VARCHAR2
880: , p9_a0 JTF_NUMBER_TABLE
881: , p9_a1 JTF_VARCHAR2_TABLE_100
882: , x_reservation_id_tbl out nocopy JTF_NUMBER_TABLE
883: )
884:
885: as

Line 1014: , p8_a1 JTF_VARCHAR2_TABLE_100

1010: , x_return_status out nocopy VARCHAR2
1011: , x_msg_count out nocopy NUMBER
1012: , x_msg_data out nocopy VARCHAR2
1013: , p8_a0 JTF_NUMBER_TABLE
1014: , p8_a1 JTF_VARCHAR2_TABLE_100
1015: , p_reservation_id_tbl JTF_NUMBER_TABLE
1016: )
1017:
1018: as