APPS.CAC_VIEW_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package cac_view_pvt_w as
2: /* $Header: cacvpws.pls 120.3 2006/02/22 07:16:45 sankgupt noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_pvt.callsttbltype, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_VARCHAR2_TABLE_100
7: );
8: procedure rosetta_table_copy_out_p1(t cac_view_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: cacvpws.pls 120.3 2006/02/22 07:16:45 sankgupt noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_pvt.callsttbltype, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_VARCHAR2_TABLE_100
7: );
8: procedure rosetta_table_copy_out_p1(t cac_view_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_VARCHAR2_TABLE_100
10: , a2 out nocopy JTF_VARCHAR2_TABLE_400

Line 9: , a1 out nocopy JTF_VARCHAR2_TABLE_100

5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_VARCHAR2_TABLE_100
7: );
8: procedure rosetta_table_copy_out_p1(t cac_view_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_VARCHAR2_TABLE_100
10: , a2 out nocopy JTF_VARCHAR2_TABLE_400
11: , a3 out nocopy JTF_VARCHAR2_TABLE_100
12: );
13:

Line 11: , a3 out nocopy JTF_VARCHAR2_TABLE_100

7: );
8: procedure rosetta_table_copy_out_p1(t cac_view_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_VARCHAR2_TABLE_100
10: , a2 out nocopy JTF_VARCHAR2_TABLE_400
11: , a3 out nocopy JTF_VARCHAR2_TABLE_100
12: );
13:
14: procedure rosetta_table_copy_in_p4(t out nocopy cac_view_pvt.queryouttab, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE

Line 16: , a2 JTF_VARCHAR2_TABLE_100

12: );
13:
14: procedure rosetta_table_copy_in_p4(t out nocopy cac_view_pvt.queryouttab, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_VARCHAR2_TABLE_100
17: , a3 JTF_VARCHAR2_TABLE_2000
18: , a4 JTF_VARCHAR2_TABLE_2000
19: , a5 JTF_VARCHAR2_TABLE_100
20: , a6 JTF_NUMBER_TABLE

Line 19: , a5 JTF_VARCHAR2_TABLE_100

15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_VARCHAR2_TABLE_100
17: , a3 JTF_VARCHAR2_TABLE_2000
18: , a4 JTF_VARCHAR2_TABLE_2000
19: , a5 JTF_VARCHAR2_TABLE_100
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_NUMBER_TABLE
22: , a8 JTF_NUMBER_TABLE
23: , a9 JTF_NUMBER_TABLE

Line 26: , a12 JTF_VARCHAR2_TABLE_100

22: , a8 JTF_NUMBER_TABLE
23: , a9 JTF_NUMBER_TABLE
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_DATE_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_DATE_TABLE
28: , a14 JTF_VARCHAR2_TABLE_2000
29: , a15 JTF_VARCHAR2_TABLE_2000
30: , a16 JTF_VARCHAR2_TABLE_2000

Line 32: , a18 JTF_VARCHAR2_TABLE_100

28: , a14 JTF_VARCHAR2_TABLE_2000
29: , a15 JTF_VARCHAR2_TABLE_2000
30: , a16 JTF_VARCHAR2_TABLE_2000
31: , a17 JTF_VARCHAR2_TABLE_4000
32: , a18 JTF_VARCHAR2_TABLE_100
33: , a19 JTF_VARCHAR2_TABLE_100
34: , a20 JTF_VARCHAR2_TABLE_100
35: , a21 JTF_VARCHAR2_TABLE_100
36: , a22 JTF_VARCHAR2_TABLE_100

Line 33: , a19 JTF_VARCHAR2_TABLE_100

29: , a15 JTF_VARCHAR2_TABLE_2000
30: , a16 JTF_VARCHAR2_TABLE_2000
31: , a17 JTF_VARCHAR2_TABLE_4000
32: , a18 JTF_VARCHAR2_TABLE_100
33: , a19 JTF_VARCHAR2_TABLE_100
34: , a20 JTF_VARCHAR2_TABLE_100
35: , a21 JTF_VARCHAR2_TABLE_100
36: , a22 JTF_VARCHAR2_TABLE_100
37: , a23 JTF_VARCHAR2_TABLE_400

Line 34: , a20 JTF_VARCHAR2_TABLE_100

30: , a16 JTF_VARCHAR2_TABLE_2000
31: , a17 JTF_VARCHAR2_TABLE_4000
32: , a18 JTF_VARCHAR2_TABLE_100
33: , a19 JTF_VARCHAR2_TABLE_100
34: , a20 JTF_VARCHAR2_TABLE_100
35: , a21 JTF_VARCHAR2_TABLE_100
36: , a22 JTF_VARCHAR2_TABLE_100
37: , a23 JTF_VARCHAR2_TABLE_400
38: , a24 JTF_VARCHAR2_TABLE_4000

Line 35: , a21 JTF_VARCHAR2_TABLE_100

31: , a17 JTF_VARCHAR2_TABLE_4000
32: , a18 JTF_VARCHAR2_TABLE_100
33: , a19 JTF_VARCHAR2_TABLE_100
34: , a20 JTF_VARCHAR2_TABLE_100
35: , a21 JTF_VARCHAR2_TABLE_100
36: , a22 JTF_VARCHAR2_TABLE_100
37: , a23 JTF_VARCHAR2_TABLE_400
38: , a24 JTF_VARCHAR2_TABLE_4000
39: , a25 JTF_NUMBER_TABLE

Line 36: , a22 JTF_VARCHAR2_TABLE_100

32: , a18 JTF_VARCHAR2_TABLE_100
33: , a19 JTF_VARCHAR2_TABLE_100
34: , a20 JTF_VARCHAR2_TABLE_100
35: , a21 JTF_VARCHAR2_TABLE_100
36: , a22 JTF_VARCHAR2_TABLE_100
37: , a23 JTF_VARCHAR2_TABLE_400
38: , a24 JTF_VARCHAR2_TABLE_4000
39: , a25 JTF_NUMBER_TABLE
40: , a26 JTF_VARCHAR2_TABLE_100

Line 40: , a26 JTF_VARCHAR2_TABLE_100

36: , a22 JTF_VARCHAR2_TABLE_100
37: , a23 JTF_VARCHAR2_TABLE_400
38: , a24 JTF_VARCHAR2_TABLE_4000
39: , a25 JTF_NUMBER_TABLE
40: , a26 JTF_VARCHAR2_TABLE_100
41: , a27 JTF_VARCHAR2_TABLE_100
42: );
43: procedure rosetta_table_copy_out_p4(t cac_view_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_NUMBER_TABLE

Line 41: , a27 JTF_VARCHAR2_TABLE_100

37: , a23 JTF_VARCHAR2_TABLE_400
38: , a24 JTF_VARCHAR2_TABLE_4000
39: , a25 JTF_NUMBER_TABLE
40: , a26 JTF_VARCHAR2_TABLE_100
41: , a27 JTF_VARCHAR2_TABLE_100
42: );
43: procedure rosetta_table_copy_out_p4(t cac_view_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 45: , a2 out nocopy JTF_VARCHAR2_TABLE_100

41: , a27 JTF_VARCHAR2_TABLE_100
42: );
43: procedure rosetta_table_copy_out_p4(t cac_view_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_VARCHAR2_TABLE_100
46: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a5 out nocopy JTF_VARCHAR2_TABLE_100
49: , a6 out nocopy JTF_NUMBER_TABLE

Line 48: , a5 out nocopy JTF_VARCHAR2_TABLE_100

44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_VARCHAR2_TABLE_100
46: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a5 out nocopy JTF_VARCHAR2_TABLE_100
49: , a6 out nocopy JTF_NUMBER_TABLE
50: , a7 out nocopy JTF_NUMBER_TABLE
51: , a8 out nocopy JTF_NUMBER_TABLE
52: , a9 out nocopy JTF_NUMBER_TABLE

Line 55: , a12 out nocopy JTF_VARCHAR2_TABLE_100

51: , a8 out nocopy JTF_NUMBER_TABLE
52: , a9 out nocopy JTF_NUMBER_TABLE
53: , a10 out nocopy JTF_NUMBER_TABLE
54: , a11 out nocopy JTF_DATE_TABLE
55: , a12 out nocopy JTF_VARCHAR2_TABLE_100
56: , a13 out nocopy JTF_DATE_TABLE
57: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
59: , a16 out nocopy JTF_VARCHAR2_TABLE_2000

Line 61: , a18 out nocopy JTF_VARCHAR2_TABLE_100

57: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
59: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
60: , a17 out nocopy JTF_VARCHAR2_TABLE_4000
61: , a18 out nocopy JTF_VARCHAR2_TABLE_100
62: , a19 out nocopy JTF_VARCHAR2_TABLE_100
63: , a20 out nocopy JTF_VARCHAR2_TABLE_100
64: , a21 out nocopy JTF_VARCHAR2_TABLE_100
65: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , a19 out nocopy JTF_VARCHAR2_TABLE_100

58: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
59: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
60: , a17 out nocopy JTF_VARCHAR2_TABLE_4000
61: , a18 out nocopy JTF_VARCHAR2_TABLE_100
62: , a19 out nocopy JTF_VARCHAR2_TABLE_100
63: , a20 out nocopy JTF_VARCHAR2_TABLE_100
64: , a21 out nocopy JTF_VARCHAR2_TABLE_100
65: , a22 out nocopy JTF_VARCHAR2_TABLE_100
66: , a23 out nocopy JTF_VARCHAR2_TABLE_400

Line 63: , a20 out nocopy JTF_VARCHAR2_TABLE_100

59: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
60: , a17 out nocopy JTF_VARCHAR2_TABLE_4000
61: , a18 out nocopy JTF_VARCHAR2_TABLE_100
62: , a19 out nocopy JTF_VARCHAR2_TABLE_100
63: , a20 out nocopy JTF_VARCHAR2_TABLE_100
64: , a21 out nocopy JTF_VARCHAR2_TABLE_100
65: , a22 out nocopy JTF_VARCHAR2_TABLE_100
66: , a23 out nocopy JTF_VARCHAR2_TABLE_400
67: , a24 out nocopy JTF_VARCHAR2_TABLE_4000

Line 64: , a21 out nocopy JTF_VARCHAR2_TABLE_100

60: , a17 out nocopy JTF_VARCHAR2_TABLE_4000
61: , a18 out nocopy JTF_VARCHAR2_TABLE_100
62: , a19 out nocopy JTF_VARCHAR2_TABLE_100
63: , a20 out nocopy JTF_VARCHAR2_TABLE_100
64: , a21 out nocopy JTF_VARCHAR2_TABLE_100
65: , a22 out nocopy JTF_VARCHAR2_TABLE_100
66: , a23 out nocopy JTF_VARCHAR2_TABLE_400
67: , a24 out nocopy JTF_VARCHAR2_TABLE_4000
68: , a25 out nocopy JTF_NUMBER_TABLE

Line 65: , a22 out nocopy JTF_VARCHAR2_TABLE_100

61: , a18 out nocopy JTF_VARCHAR2_TABLE_100
62: , a19 out nocopy JTF_VARCHAR2_TABLE_100
63: , a20 out nocopy JTF_VARCHAR2_TABLE_100
64: , a21 out nocopy JTF_VARCHAR2_TABLE_100
65: , a22 out nocopy JTF_VARCHAR2_TABLE_100
66: , a23 out nocopy JTF_VARCHAR2_TABLE_400
67: , a24 out nocopy JTF_VARCHAR2_TABLE_4000
68: , a25 out nocopy JTF_NUMBER_TABLE
69: , a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 69: , a26 out nocopy JTF_VARCHAR2_TABLE_100

65: , a22 out nocopy JTF_VARCHAR2_TABLE_100
66: , a23 out nocopy JTF_VARCHAR2_TABLE_400
67: , a24 out nocopy JTF_VARCHAR2_TABLE_4000
68: , a25 out nocopy JTF_NUMBER_TABLE
69: , a26 out nocopy JTF_VARCHAR2_TABLE_100
70: , a27 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:
73: procedure getcalendarlist(p_api_version NUMBER

Line 70: , a27 out nocopy JTF_VARCHAR2_TABLE_100

66: , a23 out nocopy JTF_VARCHAR2_TABLE_400
67: , a24 out nocopy JTF_VARCHAR2_TABLE_4000
68: , a25 out nocopy JTF_NUMBER_TABLE
69: , a26 out nocopy JTF_VARCHAR2_TABLE_100
70: , a27 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:
73: procedure getcalendarlist(p_api_version NUMBER
74: , p_init_msg_list VARCHAR2

Line 83: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

79: , p_resourceid in out nocopy NUMBER
80: , p_resourcetype in out nocopy VARCHAR2
81: , p_userid NUMBER
82: , p9_a0 out nocopy JTF_NUMBER_TABLE
83: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
84: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
85: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
86: );
87: procedure getview(p_api_version NUMBER

Line 85: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

81: , p_userid NUMBER
82: , p9_a0 out nocopy JTF_NUMBER_TABLE
83: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
84: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
85: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
86: );
87: procedure getview(p_api_version NUMBER
88: , p_init_msg_list VARCHAR2
89: , p_validation_level NUMBER

Line 129: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

125: , p6_a32 CHAR
126: , p6_a33 NUMBER
127: , p7_a0 out nocopy JTF_NUMBER_TABLE
128: , p7_a1 out nocopy JTF_NUMBER_TABLE
129: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
130: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000
132: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
133: , p7_a6 out nocopy JTF_NUMBER_TABLE

Line 132: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

128: , p7_a1 out nocopy JTF_NUMBER_TABLE
129: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
130: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000
132: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
133: , p7_a6 out nocopy JTF_NUMBER_TABLE
134: , p7_a7 out nocopy JTF_NUMBER_TABLE
135: , p7_a8 out nocopy JTF_NUMBER_TABLE
136: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 139: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100

135: , p7_a8 out nocopy JTF_NUMBER_TABLE
136: , p7_a9 out nocopy JTF_NUMBER_TABLE
137: , p7_a10 out nocopy JTF_NUMBER_TABLE
138: , p7_a11 out nocopy JTF_DATE_TABLE
139: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
140: , p7_a13 out nocopy JTF_DATE_TABLE
141: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
142: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
143: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000

Line 145: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

141: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
142: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
143: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
144: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_4000
145: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
147: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
148: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
149: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 146: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

142: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
143: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
144: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_4000
145: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
147: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
148: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
149: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
150: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400

Line 147: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100

143: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
144: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_4000
145: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
147: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
148: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
149: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
150: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400
151: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_4000

Line 148: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100

144: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_4000
145: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
147: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
148: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
149: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
150: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400
151: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_4000
152: , p7_a25 out nocopy JTF_NUMBER_TABLE

Line 149: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

145: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
147: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
148: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
149: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
150: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400
151: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_4000
152: , p7_a25 out nocopy JTF_NUMBER_TABLE
153: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 153: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100

149: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
150: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400
151: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_4000
152: , p7_a25 out nocopy JTF_NUMBER_TABLE
153: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
154: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
155: );
156: end cac_view_pvt_w;

Line 154: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100

150: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400
151: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_4000
152: , p7_a25 out nocopy JTF_NUMBER_TABLE
153: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
154: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
155: );
156: end cac_view_pvt_w;