DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_SCHEDULE_PVT_W dependencies on AHL_LTP_SPACE_SCHEDULE_PVT

Line 1: package ahl_ltp_space_schedule_pvt_w AUTHID CURRENT_USER as

1: package ahl_ltp_space_schedule_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWSPSS.pls 120.1 2006/05/04 08:00 anraj noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 JTF_VARCHAR2_TABLE_300

1: package ahl_ltp_space_schedule_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWSPSS.pls 120.1 2006/05/04 08:00 anraj noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 24: procedure rosetta_table_copy_out_p5(t ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300

20: , a17 JTF_DATE_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_DATE_TABLE
23: );
24: procedure rosetta_table_copy_out_p5(t ahl_ltp_space_schedule_pvt.search_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_VARCHAR2_TABLE_100
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 JTF_VARCHAR2_TABLE_300

42: , a18 out nocopy JTF_DATE_TABLE
43: , a19 out nocopy JTF_DATE_TABLE
44: );
45:
46: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 JTF_VARCHAR2_TABLE_300
47: , a1 JTF_VARCHAR2_TABLE_100
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_VARCHAR2_TABLE_100
50: , a4 JTF_VARCHAR2_TABLE_100

Line 69: procedure rosetta_table_copy_out_p6(t ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300

65: , a19 JTF_VARCHAR2_TABLE_100
66: , a20 JTF_VARCHAR2_TABLE_100
67: , a21 JTF_VARCHAR2_TABLE_100
68: );
69: procedure rosetta_table_copy_out_p6(t ahl_ltp_space_schedule_pvt.scheduled_visits_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: , a3 out nocopy JTF_VARCHAR2_TABLE_100
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 93: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE

89: , a20 out nocopy JTF_VARCHAR2_TABLE_100
90: , a21 out nocopy JTF_VARCHAR2_TABLE_100
91: );
92:
93: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE
94: , a1 JTF_DATE_TABLE
95: );
96: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_DATE_TABLE

Line 96: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE

92:
93: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 JTF_NUMBER_TABLE
94: , a1 JTF_DATE_TABLE
95: );
96: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_DATE_TABLE
98: );
99:
100: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE

Line 100: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE

96: procedure rosetta_table_copy_out_p7(t ahl_ltp_space_schedule_pvt.visits_end_date_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_DATE_TABLE
98: );
99:
100: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 JTF_NUMBER_TABLE
101: , a1 JTF_VARCHAR2_TABLE_100
102: , a2 JTF_VARCHAR2_TABLE_100
103: , a3 JTF_NUMBER_TABLE
104: , a4 JTF_VARCHAR2_TABLE_100

Line 114: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

110: , a10 JTF_DATE_TABLE
111: , a11 JTF_DATE_TABLE
112: , a12 JTF_DATE_TABLE
113: );
114: procedure rosetta_table_copy_out_p8(t ahl_ltp_space_schedule_pvt.visit_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_VARCHAR2_TABLE_100
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_NUMBER_TABLE
118: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 272: end ahl_ltp_space_schedule_pvt_w;

268: , x_return_status out nocopy VARCHAR2
269: , x_msg_count out nocopy NUMBER
270: , x_msg_data out nocopy VARCHAR2
271: );
272: end ahl_ltp_space_schedule_pvt_w;