DBA Data[Home] [Help]

APPS.AHL_MM_RESERVATIONS_PVT_W dependencies on JTF_NUMBER_TABLE

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 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

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

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: );
9:
10: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mm_reservations_pvt.number_table_type, a0 JTF_NUMBER_TABLE);

Line 10: procedure rosetta_table_copy_in_p4(t out nocopy ahl_mm_reservations_pvt.number_table_type, a0 JTF_NUMBER_TABLE);

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);
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);

Line 11: procedure rosetta_table_copy_out_p4(t ahl_mm_reservations_pvt.number_table_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);
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:

Line 95: , p9_a0 JTF_NUMBER_TABLE

91: , p8_a67 NUMBER
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

Line 179: , p10_a0 JTF_NUMBER_TABLE

175: , p9_a67 NUMBER
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

Line 191: , p9_a0 JTF_NUMBER_TABLE

187: , x_return_status out nocopy VARCHAR2
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

Line 274: , p10_a0 JTF_NUMBER_TABLE

270: , p9_a67 NUMBER
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

Line 357: , p9_a0 JTF_NUMBER_TABLE

353: , p8_a67 NUMBER
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

Line 359: , x_reservation_id_tbl out nocopy JTF_NUMBER_TABLE

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
363: , p_commit VARCHAR2

Line 369: , p8_a0 JTF_NUMBER_TABLE

365: , p_module_type VARCHAR2
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;

Line 371: , p_reservation_id_tbl JTF_NUMBER_TABLE

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;