DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_pvt.callsttbltype, a0 JTF_NUMBER_TABLE

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

Line 8: procedure rosetta_table_copy_out_p1(t cac_view_pvt.callsttbltype, a0 out nocopy 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
11: , a3 out nocopy JTF_VARCHAR2_TABLE_100
12: );

Line 14: procedure rosetta_table_copy_in_p4(t out nocopy cac_view_pvt.queryouttab, a0 JTF_NUMBER_TABLE

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
16: , a2 JTF_VARCHAR2_TABLE_100
17: , a3 JTF_VARCHAR2_TABLE_2000
18: , a4 JTF_VARCHAR2_TABLE_2000

Line 15: , a1 JTF_NUMBER_TABLE

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
16: , a2 JTF_VARCHAR2_TABLE_100
17: , a3 JTF_VARCHAR2_TABLE_2000
18: , a4 JTF_VARCHAR2_TABLE_2000
19: , a5 JTF_VARCHAR2_TABLE_100

Line 20: , a6 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
24: , a10 JTF_NUMBER_TABLE

Line 21: , a7 JTF_NUMBER_TABLE

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
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_DATE_TABLE

Line 22: , a8 JTF_NUMBER_TABLE

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
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_DATE_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100

Line 23: , a9 JTF_NUMBER_TABLE

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
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_DATE_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_DATE_TABLE

Line 24: , a10 JTF_NUMBER_TABLE

20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_NUMBER_TABLE
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

Line 39: , a25 JTF_NUMBER_TABLE

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

Line 43: procedure rosetta_table_copy_out_p4(t cac_view_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE

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
46: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 44: , a1 out nocopy 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
46: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , a6 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
53: , a10 out nocopy JTF_NUMBER_TABLE

Line 50: , a7 out nocopy JTF_NUMBER_TABLE

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
53: , a10 out nocopy JTF_NUMBER_TABLE
54: , a11 out nocopy JTF_DATE_TABLE

Line 51: , a8 out nocopy JTF_NUMBER_TABLE

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
53: , a10 out nocopy JTF_NUMBER_TABLE
54: , a11 out nocopy JTF_DATE_TABLE
55: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 52: , a9 out nocopy JTF_NUMBER_TABLE

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

Line 53: , a10 out nocopy JTF_NUMBER_TABLE

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

Line 68: , a25 out nocopy JTF_NUMBER_TABLE

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
70: , a27 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:

Line 82: , p9_a0 out nocopy JTF_NUMBER_TABLE

78: , x_msg_data out nocopy VARCHAR2
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: );

Line 127: , p7_a0 out nocopy JTF_NUMBER_TABLE

123: , p6_a30 CHAR
124: , p6_a31 CHAR
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

Line 128: , p7_a1 out nocopy JTF_NUMBER_TABLE

124: , p6_a31 CHAR
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

Line 133: , p7_a6 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
137: , p7_a10 out nocopy JTF_NUMBER_TABLE

Line 134: , p7_a7 out nocopy JTF_NUMBER_TABLE

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
137: , p7_a10 out nocopy JTF_NUMBER_TABLE
138: , p7_a11 out nocopy JTF_DATE_TABLE

Line 135: , p7_a8 out nocopy JTF_NUMBER_TABLE

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

Line 136: , p7_a9 out nocopy JTF_NUMBER_TABLE

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

Line 137: , p7_a10 out nocopy JTF_NUMBER_TABLE

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

Line 152: , p7_a25 out nocopy JTF_NUMBER_TABLE

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
154: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
155: );
156: end cac_view_pvt_w;