APPS.JTF_CALENDAR_PUB_24HR_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: JTFPC24S.pls 120.2 2005/07/07 12:28:30 abraina ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_calendar_pub_24hr.shift_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: );
8: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub_24hr.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_DATE_TABLE
10: , a2 out nocopy JTF_DATE_TABLE

Line 11: , a3 out nocopy JTF_VARCHAR2_TABLE_100

7: );
8: procedure rosetta_table_copy_out_p1(t jtf_calendar_pub_24hr.shift_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_DATE_TABLE
10: , a2 out nocopy JTF_DATE_TABLE
11: , a3 out nocopy JTF_VARCHAR2_TABLE_100
12: );
13:
14: procedure rosetta_table_copy_in_p3(t out nocopy jtf_calendar_pub_24hr.shift_tbl_attributes_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_DATE_TABLE

Line 17: , a3 JTF_VARCHAR2_TABLE_100

13:
14: procedure rosetta_table_copy_in_p3(t out nocopy jtf_calendar_pub_24hr.shift_tbl_attributes_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_DATE_TABLE
16: , a2 JTF_DATE_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_200
19: , a5 JTF_VARCHAR2_TABLE_200
20: , a6 JTF_VARCHAR2_TABLE_200
21: , a7 JTF_VARCHAR2_TABLE_200

Line 37: , a3 out nocopy JTF_VARCHAR2_TABLE_100

33: );
34: procedure rosetta_table_copy_out_p3(t jtf_calendar_pub_24hr.shift_tbl_attributes_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_DATE_TABLE
36: , a2 out nocopy JTF_DATE_TABLE
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_200
39: , a5 out nocopy JTF_VARCHAR2_TABLE_200
40: , a6 out nocopy JTF_VARCHAR2_TABLE_200
41: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 67: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

63: , x_msg_data out nocopy VARCHAR2
64: , p9_a0 out nocopy JTF_NUMBER_TABLE
65: , p9_a1 out nocopy JTF_DATE_TABLE
66: , p9_a2 out nocopy JTF_DATE_TABLE
67: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
68: );
69: procedure get_available_slot(p_api_version NUMBER
70: , p_init_msg_list VARCHAR2
71: , p_resource_id NUMBER

Line 96: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

92: , x_msg_data out nocopy VARCHAR2
93: , p9_a0 out nocopy JTF_NUMBER_TABLE
94: , p9_a1 out nocopy JTF_DATE_TABLE
95: , p9_a2 out nocopy JTF_DATE_TABLE
96: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: );
98: procedure get_resource_shifts(p_api_version NUMBER
99: , p_init_msg_list VARCHAR2
100: , p_resource_id NUMBER

Line 110: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

106: , x_msg_data out nocopy VARCHAR2
107: , p9_a0 out nocopy JTF_NUMBER_TABLE
108: , p9_a1 out nocopy JTF_DATE_TABLE
109: , p9_a2 out nocopy JTF_DATE_TABLE
110: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_200
112: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_200
113: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_200
114: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 150: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

146: , x_msg_data out nocopy VARCHAR2
147: , p9_a0 out nocopy JTF_NUMBER_TABLE
148: , p9_a1 out nocopy JTF_DATE_TABLE
149: , p9_a2 out nocopy JTF_DATE_TABLE
150: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
151: );
152: function resourcedt_to_serverdt(p_resource_dttime date
153: , p_resource_tz_id NUMBER
154: , p_server_tz_id NUMBER