DBA Data[Home] [Help]

APPS.AHL_MM_RESERVATIONS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package ahl_mm_reservations_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWMMRS.pls 120.0.12020000.2 2012/12/13 06:07:48 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: );
6: procedure rosetta_table_copy_out_p2(t ahl_mm_reservations_pvt.serial_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );

Line 7: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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: );
6: procedure rosetta_table_copy_out_p2(t ahl_mm_reservations_pvt.serial_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mm_reservations_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
11: procedure rosetta_table_copy_out_p4(t ahl_mm_reservations_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);

Line 13: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mm_reservations_pvt.varchar_table_type, a0 JTF_VARCHAR2_TABLE_100);

9:
10: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mm_reservations_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
11: procedure rosetta_table_copy_out_p4(t ahl_mm_reservations_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
12:
13: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mm_reservations_pvt.varchar_table_type, a0 JTF_VARCHAR2_TABLE_100);
14: procedure rosetta_table_copy_out_p5(t ahl_mm_reservations_pvt.varchar_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
15:
16: procedure create_reservation(p_api_version NUMBER
17: , p_init_msg_list VARCHAR2

Line 14: procedure rosetta_table_copy_out_p5(t ahl_mm_reservations_pvt.varchar_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);

10: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mm_reservations_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
11: procedure rosetta_table_copy_out_p4(t ahl_mm_reservations_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
12:
13: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mm_reservations_pvt.varchar_table_type, a0 JTF_VARCHAR2_TABLE_100);
14: procedure rosetta_table_copy_out_p5(t ahl_mm_reservations_pvt.varchar_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
15:
16: procedure create_reservation(p_api_version NUMBER
17: , p_init_msg_list VARCHAR2
18: , p_commit VARCHAR2

Line 96: , p9_a1 JTF_VARCHAR2_TABLE_100

92: , p8_a68 NUMBER
93: , p8_a69 NUMBER
94: , p8_a70 VARCHAR2
95: , p9_a0 JTF_NUMBER_TABLE
96: , p9_a1 JTF_VARCHAR2_TABLE_100
97: , x_reservation_id out nocopy NUMBER
98: );
99: procedure update_reservation(p_api_version NUMBER
100: , p_init_msg_list VARCHAR2

Line 180: , p10_a1 JTF_VARCHAR2_TABLE_100

176: , p9_a68 NUMBER
177: , p9_a69 NUMBER
178: , p9_a70 VARCHAR2
179: , p10_a0 JTF_NUMBER_TABLE
180: , p10_a1 JTF_VARCHAR2_TABLE_100
181: );
182: procedure relieve_reservation(p_api_version NUMBER
183: , p_init_msg_list VARCHAR2
184: , p_commit VARCHAR2

Line 192: , p9_a1 JTF_VARCHAR2_TABLE_100

188: , x_msg_count out nocopy NUMBER
189: , x_msg_data out nocopy VARCHAR2
190: , p_reservation_id NUMBER
191: , p9_a0 JTF_NUMBER_TABLE
192: , p9_a1 JTF_VARCHAR2_TABLE_100
193: );
194: procedure transfer_reservation(p_api_version NUMBER
195: , p_init_msg_list VARCHAR2
196: , p_commit VARCHAR2

Line 275: , p10_a1 JTF_VARCHAR2_TABLE_100

271: , p9_a68 NUMBER
272: , p9_a69 NUMBER
273: , p9_a70 VARCHAR2
274: , p10_a0 JTF_NUMBER_TABLE
275: , p10_a1 JTF_VARCHAR2_TABLE_100
276: , x_to_reservation_id out nocopy NUMBER
277: );
278: procedure process_reservation(p_api_version NUMBER
279: , p_init_msg_list VARCHAR2

Line 358: , p9_a1 JTF_VARCHAR2_TABLE_100

354: , p8_a68 NUMBER
355: , p8_a69 NUMBER
356: , p8_a70 VARCHAR2
357: , p9_a0 JTF_NUMBER_TABLE
358: , p9_a1 JTF_VARCHAR2_TABLE_100
359: , x_reservation_id_tbl out nocopy JTF_NUMBER_TABLE
360: );
361: procedure cancel_reservation(p_api_version NUMBER
362: , p_init_msg_list VARCHAR2

Line 370: , p8_a1 JTF_VARCHAR2_TABLE_100

366: , x_return_status out nocopy VARCHAR2
367: , x_msg_count out nocopy NUMBER
368: , x_msg_data out nocopy VARCHAR2
369: , p8_a0 JTF_NUMBER_TABLE
370: , p8_a1 JTF_VARCHAR2_TABLE_100
371: , p_reservation_id_tbl JTF_NUMBER_TABLE
372: );
373: end ahl_mm_reservations_pvt_w;