APPS.CN_REASONS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy cn_reasons_pub.notes_tbl, a0 JTF_NUMBER_TABLE

1: package cn_reasons_pub_w AUTHID CURRENT_USER as
2: /* $Header: cnwresns.pls 115.3 2003/07/04 01:43:11 jjhuang ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy cn_reasons_pub.notes_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_4000

Line 4: , a1 JTF_NUMBER_TABLE

1: package cn_reasons_pub_w AUTHID CURRENT_USER as
2: /* $Header: cnwresns.pls 115.3 2003/07/04 01:43:11 jjhuang ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy cn_reasons_pub.notes_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_4000
8: , a5 JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: cnwresns.pls 115.3 2003/07/04 01:43:11 jjhuang ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy cn_reasons_pub.notes_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_4000
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100

Line 30: , a27 JTF_NUMBER_TABLE

26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 32: , a29 JTF_NUMBER_TABLE

28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 34: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE

30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_100
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_VARCHAR2_TABLE_4000

Line 35: , a1 out nocopy JTF_NUMBER_TABLE

31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_100
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_VARCHAR2_TABLE_4000
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 37: , a3 out nocopy JTF_NUMBER_TABLE

33: );
34: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_100
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_VARCHAR2_TABLE_4000
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 61: , a27 out nocopy JTF_NUMBER_TABLE

57: , a23 out nocopy JTF_VARCHAR2_TABLE_100
58: , a24 out nocopy JTF_VARCHAR2_TABLE_100
59: , a25 out nocopy JTF_VARCHAR2_TABLE_100
60: , a26 out nocopy JTF_DATE_TABLE
61: , a27 out nocopy JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_VARCHAR2_TABLE_100
63: , a29 out nocopy JTF_NUMBER_TABLE
64: );
65:

Line 63: , a29 out nocopy JTF_NUMBER_TABLE

59: , a25 out nocopy JTF_VARCHAR2_TABLE_100
60: , a26 out nocopy JTF_DATE_TABLE
61: , a27 out nocopy JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_VARCHAR2_TABLE_100
63: , a29 out nocopy JTF_NUMBER_TABLE
64: );
65:
66: procedure show_analyst_notes(p_api_version NUMBER
67: , p_init_msg_list VARCHAR2

Line 93: , p14_a0 out nocopy JTF_NUMBER_TABLE

89: , p13_a10 out nocopy VARCHAR2
90: , p13_a11 out nocopy VARCHAR2
91: , p13_a12 out nocopy NUMBER
92: , p13_a13 out nocopy VARCHAR2
93: , p14_a0 out nocopy JTF_NUMBER_TABLE
94: , p14_a1 out nocopy JTF_NUMBER_TABLE
95: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , p14_a3 out nocopy JTF_NUMBER_TABLE
97: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_4000

Line 94: , p14_a1 out nocopy JTF_NUMBER_TABLE

90: , p13_a11 out nocopy VARCHAR2
91: , p13_a12 out nocopy NUMBER
92: , p13_a13 out nocopy VARCHAR2
93: , p14_a0 out nocopy JTF_NUMBER_TABLE
94: , p14_a1 out nocopy JTF_NUMBER_TABLE
95: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , p14_a3 out nocopy JTF_NUMBER_TABLE
97: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_4000
98: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 96: , p14_a3 out nocopy JTF_NUMBER_TABLE

92: , p13_a13 out nocopy VARCHAR2
93: , p14_a0 out nocopy JTF_NUMBER_TABLE
94: , p14_a1 out nocopy JTF_NUMBER_TABLE
95: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , p14_a3 out nocopy JTF_NUMBER_TABLE
97: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_4000
98: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 120: , p14_a27 out nocopy JTF_NUMBER_TABLE

116: , p14_a23 out nocopy JTF_VARCHAR2_TABLE_100
117: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
118: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_100
119: , p14_a26 out nocopy JTF_DATE_TABLE
120: , p14_a27 out nocopy JTF_NUMBER_TABLE
121: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
122: , p14_a29 out nocopy JTF_NUMBER_TABLE
123: , x_notes_count out nocopy NUMBER
124: );

Line 122: , p14_a29 out nocopy JTF_NUMBER_TABLE

118: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_100
119: , p14_a26 out nocopy JTF_DATE_TABLE
120: , p14_a27 out nocopy JTF_NUMBER_TABLE
121: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
122: , p14_a29 out nocopy JTF_NUMBER_TABLE
123: , x_notes_count out nocopy NUMBER
124: );
125: procedure manage_analyst_notes(p_api_version NUMBER
126: , p_init_msg_list VARCHAR2

Line 129: , p4_a0 JTF_NUMBER_TABLE

125: procedure manage_analyst_notes(p_api_version NUMBER
126: , p_init_msg_list VARCHAR2
127: , p_validation_level VARCHAR2
128: , p_commit VARCHAR2
129: , p4_a0 JTF_NUMBER_TABLE
130: , p4_a1 JTF_NUMBER_TABLE
131: , p4_a2 JTF_VARCHAR2_TABLE_100
132: , p4_a3 JTF_NUMBER_TABLE
133: , p4_a4 JTF_VARCHAR2_TABLE_4000

Line 130: , p4_a1 JTF_NUMBER_TABLE

126: , p_init_msg_list VARCHAR2
127: , p_validation_level VARCHAR2
128: , p_commit VARCHAR2
129: , p4_a0 JTF_NUMBER_TABLE
130: , p4_a1 JTF_NUMBER_TABLE
131: , p4_a2 JTF_VARCHAR2_TABLE_100
132: , p4_a3 JTF_NUMBER_TABLE
133: , p4_a4 JTF_VARCHAR2_TABLE_4000
134: , p4_a5 JTF_VARCHAR2_TABLE_100

Line 132: , p4_a3 JTF_NUMBER_TABLE

128: , p_commit VARCHAR2
129: , p4_a0 JTF_NUMBER_TABLE
130: , p4_a1 JTF_NUMBER_TABLE
131: , p4_a2 JTF_VARCHAR2_TABLE_100
132: , p4_a3 JTF_NUMBER_TABLE
133: , p4_a4 JTF_VARCHAR2_TABLE_4000
134: , p4_a5 JTF_VARCHAR2_TABLE_100
135: , p4_a6 JTF_VARCHAR2_TABLE_100
136: , p4_a7 JTF_VARCHAR2_TABLE_100

Line 156: , p4_a27 JTF_NUMBER_TABLE

152: , p4_a23 JTF_VARCHAR2_TABLE_100
153: , p4_a24 JTF_VARCHAR2_TABLE_100
154: , p4_a25 JTF_VARCHAR2_TABLE_100
155: , p4_a26 JTF_DATE_TABLE
156: , p4_a27 JTF_NUMBER_TABLE
157: , p4_a28 JTF_VARCHAR2_TABLE_100
158: , p4_a29 JTF_NUMBER_TABLE
159: , x_return_status out nocopy VARCHAR2
160: , x_msg_count out nocopy NUMBER

Line 158: , p4_a29 JTF_NUMBER_TABLE

154: , p4_a25 JTF_VARCHAR2_TABLE_100
155: , p4_a26 JTF_DATE_TABLE
156: , p4_a27 JTF_NUMBER_TABLE
157: , p4_a28 JTF_VARCHAR2_TABLE_100
158: , p4_a29 JTF_NUMBER_TABLE
159: , x_return_status out nocopy VARCHAR2
160: , x_msg_count out nocopy NUMBER
161: , x_msg_data out nocopy VARCHAR2
162: , x_loading_status out nocopy VARCHAR2

Line 175: , p11_a0 out nocopy JTF_NUMBER_TABLE

171: , x_return_status out nocopy VARCHAR2
172: , x_msg_count out nocopy NUMBER
173: , x_msg_data out nocopy VARCHAR2
174: , x_loading_status out nocopy VARCHAR2
175: , p11_a0 out nocopy JTF_NUMBER_TABLE
176: , p11_a1 out nocopy JTF_NUMBER_TABLE
177: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
178: , p11_a3 out nocopy JTF_NUMBER_TABLE
179: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_4000

Line 176: , p11_a1 out nocopy JTF_NUMBER_TABLE

172: , x_msg_count out nocopy NUMBER
173: , x_msg_data out nocopy VARCHAR2
174: , x_loading_status out nocopy VARCHAR2
175: , p11_a0 out nocopy JTF_NUMBER_TABLE
176: , p11_a1 out nocopy JTF_NUMBER_TABLE
177: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
178: , p11_a3 out nocopy JTF_NUMBER_TABLE
179: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_4000
180: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 178: , p11_a3 out nocopy JTF_NUMBER_TABLE

174: , x_loading_status out nocopy VARCHAR2
175: , p11_a0 out nocopy JTF_NUMBER_TABLE
176: , p11_a1 out nocopy JTF_NUMBER_TABLE
177: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
178: , p11_a3 out nocopy JTF_NUMBER_TABLE
179: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_4000
180: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
181: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
182: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 202: , p11_a27 out nocopy JTF_NUMBER_TABLE

198: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_100
199: , p11_a24 out nocopy JTF_VARCHAR2_TABLE_100
200: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
201: , p11_a26 out nocopy JTF_DATE_TABLE
202: , p11_a27 out nocopy JTF_NUMBER_TABLE
203: , p11_a28 out nocopy JTF_VARCHAR2_TABLE_100
204: , p11_a29 out nocopy JTF_NUMBER_TABLE
205: , x_notes_count out nocopy NUMBER
206: );

Line 204: , p11_a29 out nocopy JTF_NUMBER_TABLE

200: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
201: , p11_a26 out nocopy JTF_DATE_TABLE
202: , p11_a27 out nocopy JTF_NUMBER_TABLE
203: , p11_a28 out nocopy JTF_VARCHAR2_TABLE_100
204: , p11_a29 out nocopy JTF_NUMBER_TABLE
205: , x_notes_count out nocopy NUMBER
206: );
207: end cn_reasons_pub_w;