APPS.OKL_MASS_REBOOK_PUB_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p16(t out nocopy okl_mass_rebook_pub.crit_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_mass_rebook_pub_w AUTHID CURRENT_USER as
2: /* $Header: OKLUMRPS.pls 115.2 2004/02/27 19:04:49 dedey noship $ */
3: procedure rosetta_table_copy_in_p16(t out nocopy okl_mass_rebook_pub.crit_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_200

Line 10: procedure rosetta_table_copy_out_p16(t okl_mass_rebook_pub.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_200
9: );
10: procedure rosetta_table_copy_out_p16(t okl_mass_rebook_pub.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_VARCHAR2_TABLE_100
12: , a2 out nocopy JTF_VARCHAR2_TABLE_200
13: , a3 out nocopy JTF_VARCHAR2_TABLE_200
14: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 24: , p6_a0 JTF_NUMBER_TABLE

20: , x_return_status out nocopy VARCHAR2
21: , x_msg_count out nocopy NUMBER
22: , x_msg_data out nocopy VARCHAR2
23: , p_request_name VARCHAR2
24: , p6_a0 JTF_NUMBER_TABLE
25: , p6_a1 JTF_VARCHAR2_TABLE_600
26: , p6_a2 JTF_NUMBER_TABLE
27: , p6_a3 JTF_VARCHAR2_TABLE_100
28: , p6_a4 JTF_VARCHAR2_TABLE_100

Line 26: , p6_a2 JTF_NUMBER_TABLE

22: , x_msg_data out nocopy VARCHAR2
23: , p_request_name VARCHAR2
24: , p6_a0 JTF_NUMBER_TABLE
25: , p6_a1 JTF_VARCHAR2_TABLE_600
26: , p6_a2 JTF_NUMBER_TABLE
27: , p6_a3 JTF_VARCHAR2_TABLE_100
28: , p6_a4 JTF_VARCHAR2_TABLE_100
29: , p6_a5 JTF_VARCHAR2_TABLE_100
30: , p6_a6 JTF_VARCHAR2_TABLE_600

Line 51: , p6_a27 JTF_NUMBER_TABLE

47: , p6_a23 JTF_VARCHAR2_TABLE_500
48: , p6_a24 JTF_VARCHAR2_TABLE_500
49: , p6_a25 JTF_VARCHAR2_TABLE_500
50: , p6_a26 JTF_VARCHAR2_TABLE_500
51: , p6_a27 JTF_NUMBER_TABLE
52: , p6_a28 JTF_DATE_TABLE
53: , p6_a29 JTF_NUMBER_TABLE
54: , p6_a30 JTF_DATE_TABLE
55: , p6_a31 JTF_NUMBER_TABLE

Line 53: , p6_a29 JTF_NUMBER_TABLE

49: , p6_a25 JTF_VARCHAR2_TABLE_500
50: , p6_a26 JTF_VARCHAR2_TABLE_500
51: , p6_a27 JTF_NUMBER_TABLE
52: , p6_a28 JTF_DATE_TABLE
53: , p6_a29 JTF_NUMBER_TABLE
54: , p6_a30 JTF_DATE_TABLE
55: , p6_a31 JTF_NUMBER_TABLE
56: , p7_a0 out nocopy JTF_NUMBER_TABLE
57: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 55: , p6_a31 JTF_NUMBER_TABLE

51: , p6_a27 JTF_NUMBER_TABLE
52: , p6_a28 JTF_DATE_TABLE
53: , p6_a29 JTF_NUMBER_TABLE
54: , p6_a30 JTF_DATE_TABLE
55: , p6_a31 JTF_NUMBER_TABLE
56: , p7_a0 out nocopy JTF_NUMBER_TABLE
57: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , p7_a2 out nocopy JTF_NUMBER_TABLE
59: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 56: , p7_a0 out nocopy JTF_NUMBER_TABLE

52: , p6_a28 JTF_DATE_TABLE
53: , p6_a29 JTF_NUMBER_TABLE
54: , p6_a30 JTF_DATE_TABLE
55: , p6_a31 JTF_NUMBER_TABLE
56: , p7_a0 out nocopy JTF_NUMBER_TABLE
57: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , p7_a2 out nocopy JTF_NUMBER_TABLE
59: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
60: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 58: , p7_a2 out nocopy JTF_NUMBER_TABLE

54: , p6_a30 JTF_DATE_TABLE
55: , p6_a31 JTF_NUMBER_TABLE
56: , p7_a0 out nocopy JTF_NUMBER_TABLE
57: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , p7_a2 out nocopy JTF_NUMBER_TABLE
59: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
60: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
61: , p7_a5 out nocopy JTF_NUMBER_TABLE
62: , p7_a6 out nocopy JTF_NUMBER_TABLE

Line 61: , p7_a5 out nocopy JTF_NUMBER_TABLE

57: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , p7_a2 out nocopy JTF_NUMBER_TABLE
59: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
60: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
61: , p7_a5 out nocopy JTF_NUMBER_TABLE
62: , p7_a6 out nocopy JTF_NUMBER_TABLE
63: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
65: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , p7_a6 out nocopy JTF_NUMBER_TABLE

58: , p7_a2 out nocopy JTF_NUMBER_TABLE
59: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
60: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
61: , p7_a5 out nocopy JTF_NUMBER_TABLE
62: , p7_a6 out nocopy JTF_NUMBER_TABLE
63: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
65: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
66: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 81: , p7_a25 out nocopy JTF_NUMBER_TABLE

77: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
78: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
79: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
80: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
81: , p7_a25 out nocopy JTF_NUMBER_TABLE
82: , p7_a26 out nocopy JTF_DATE_TABLE
83: , p7_a27 out nocopy JTF_NUMBER_TABLE
84: , p7_a28 out nocopy JTF_DATE_TABLE
85: , p7_a29 out nocopy JTF_NUMBER_TABLE

Line 83: , p7_a27 out nocopy JTF_NUMBER_TABLE

79: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
80: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
81: , p7_a25 out nocopy JTF_NUMBER_TABLE
82: , p7_a26 out nocopy JTF_DATE_TABLE
83: , p7_a27 out nocopy JTF_NUMBER_TABLE
84: , p7_a28 out nocopy JTF_DATE_TABLE
85: , p7_a29 out nocopy JTF_NUMBER_TABLE
86: , p7_a30 out nocopy JTF_DATE_TABLE
87: , x_rbk_count out nocopy NUMBER

Line 85: , p7_a29 out nocopy JTF_NUMBER_TABLE

81: , p7_a25 out nocopy JTF_NUMBER_TABLE
82: , p7_a26 out nocopy JTF_DATE_TABLE
83: , p7_a27 out nocopy JTF_NUMBER_TABLE
84: , p7_a28 out nocopy JTF_DATE_TABLE
85: , p7_a29 out nocopy JTF_NUMBER_TABLE
86: , p7_a30 out nocopy JTF_DATE_TABLE
87: , x_rbk_count out nocopy NUMBER
88: );
89: procedure apply_mass_rebook(p_api_version NUMBER

Line 94: , p5_a0 JTF_NUMBER_TABLE

90: , p_init_msg_list VARCHAR2
91: , x_return_status out nocopy VARCHAR2
92: , x_msg_count out nocopy NUMBER
93: , x_msg_data out nocopy VARCHAR2
94: , p5_a0 JTF_NUMBER_TABLE
95: , p5_a1 JTF_VARCHAR2_TABLE_200
96: , p5_a2 JTF_NUMBER_TABLE
97: , p5_a3 JTF_VARCHAR2_TABLE_600
98: , p_deprn_method_code VARCHAR2

Line 96: , p5_a2 JTF_NUMBER_TABLE

92: , x_msg_count out nocopy NUMBER
93: , x_msg_data out nocopy VARCHAR2
94: , p5_a0 JTF_NUMBER_TABLE
95: , p5_a1 JTF_VARCHAR2_TABLE_200
96: , p5_a2 JTF_NUMBER_TABLE
97: , p5_a3 JTF_VARCHAR2_TABLE_600
98: , p_deprn_method_code VARCHAR2
99: , p_in_service_date date
100: , p_life_in_months NUMBER

Line 104: , p12_a0 JTF_NUMBER_TABLE

100: , p_life_in_months NUMBER
101: , p_basic_rate NUMBER
102: , p_adjusted_rate NUMBER
103: , p_residual_value NUMBER
104: , p12_a0 JTF_NUMBER_TABLE
105: , p12_a1 JTF_NUMBER_TABLE
106: , p12_a2 JTF_VARCHAR2_TABLE_500
107: , p12_a3 JTF_VARCHAR2_TABLE_500
108: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 105: , p12_a1 JTF_NUMBER_TABLE

101: , p_basic_rate NUMBER
102: , p_adjusted_rate NUMBER
103: , p_residual_value NUMBER
104: , p12_a0 JTF_NUMBER_TABLE
105: , p12_a1 JTF_NUMBER_TABLE
106: , p12_a2 JTF_VARCHAR2_TABLE_500
107: , p12_a3 JTF_VARCHAR2_TABLE_500
108: , p12_a4 JTF_VARCHAR2_TABLE_500
109: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 137: , p5_a0 JTF_NUMBER_TABLE

133: , p_init_msg_list VARCHAR2
134: , x_return_status out nocopy VARCHAR2
135: , x_msg_count out nocopy NUMBER
136: , x_msg_data out nocopy VARCHAR2
137: , p5_a0 JTF_NUMBER_TABLE
138: , p5_a1 JTF_VARCHAR2_TABLE_200
139: , p5_a2 JTF_NUMBER_TABLE
140: , p5_a3 JTF_VARCHAR2_TABLE_200
141: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 139: , p5_a2 JTF_NUMBER_TABLE

135: , x_msg_count out nocopy NUMBER
136: , x_msg_data out nocopy VARCHAR2
137: , p5_a0 JTF_NUMBER_TABLE
138: , p5_a1 JTF_VARCHAR2_TABLE_200
139: , p5_a2 JTF_NUMBER_TABLE
140: , p5_a3 JTF_VARCHAR2_TABLE_200
141: , p5_a4 JTF_VARCHAR2_TABLE_600
142: , p5_a5 JTF_NUMBER_TABLE
143: , p5_a6 JTF_NUMBER_TABLE

Line 142: , p5_a5 JTF_NUMBER_TABLE

138: , p5_a1 JTF_VARCHAR2_TABLE_200
139: , p5_a2 JTF_NUMBER_TABLE
140: , p5_a3 JTF_VARCHAR2_TABLE_200
141: , p5_a4 JTF_VARCHAR2_TABLE_600
142: , p5_a5 JTF_NUMBER_TABLE
143: , p5_a6 JTF_NUMBER_TABLE
144: , p5_a7 JTF_VARCHAR2_TABLE_100
145: , p5_a8 JTF_VARCHAR2_TABLE_100
146: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 143: , p5_a6 JTF_NUMBER_TABLE

139: , p5_a2 JTF_NUMBER_TABLE
140: , p5_a3 JTF_VARCHAR2_TABLE_200
141: , p5_a4 JTF_VARCHAR2_TABLE_600
142: , p5_a5 JTF_NUMBER_TABLE
143: , p5_a6 JTF_NUMBER_TABLE
144: , p5_a7 JTF_VARCHAR2_TABLE_100
145: , p5_a8 JTF_VARCHAR2_TABLE_100
146: , p5_a9 JTF_VARCHAR2_TABLE_100
147: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 162: , p5_a25 JTF_NUMBER_TABLE

158: , p5_a21 JTF_VARCHAR2_TABLE_500
159: , p5_a22 JTF_VARCHAR2_TABLE_500
160: , p5_a23 JTF_VARCHAR2_TABLE_500
161: , p5_a24 JTF_VARCHAR2_TABLE_500
162: , p5_a25 JTF_NUMBER_TABLE
163: , p5_a26 JTF_DATE_TABLE
164: , p5_a27 JTF_NUMBER_TABLE
165: , p5_a28 JTF_DATE_TABLE
166: , p5_a29 JTF_NUMBER_TABLE

Line 164: , p5_a27 JTF_NUMBER_TABLE

160: , p5_a23 JTF_VARCHAR2_TABLE_500
161: , p5_a24 JTF_VARCHAR2_TABLE_500
162: , p5_a25 JTF_NUMBER_TABLE
163: , p5_a26 JTF_DATE_TABLE
164: , p5_a27 JTF_NUMBER_TABLE
165: , p5_a28 JTF_DATE_TABLE
166: , p5_a29 JTF_NUMBER_TABLE
167: , p5_a30 JTF_DATE_TABLE
168: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 166: , p5_a29 JTF_NUMBER_TABLE

162: , p5_a25 JTF_NUMBER_TABLE
163: , p5_a26 JTF_DATE_TABLE
164: , p5_a27 JTF_NUMBER_TABLE
165: , p5_a28 JTF_DATE_TABLE
166: , p5_a29 JTF_NUMBER_TABLE
167: , p5_a30 JTF_DATE_TABLE
168: , p6_a0 out nocopy JTF_NUMBER_TABLE
169: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
170: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 168: , p6_a0 out nocopy JTF_NUMBER_TABLE

164: , p5_a27 JTF_NUMBER_TABLE
165: , p5_a28 JTF_DATE_TABLE
166: , p5_a29 JTF_NUMBER_TABLE
167: , p5_a30 JTF_DATE_TABLE
168: , p6_a0 out nocopy JTF_NUMBER_TABLE
169: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
170: , p6_a2 out nocopy JTF_NUMBER_TABLE
171: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
172: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 170: , p6_a2 out nocopy JTF_NUMBER_TABLE

166: , p5_a29 JTF_NUMBER_TABLE
167: , p5_a30 JTF_DATE_TABLE
168: , p6_a0 out nocopy JTF_NUMBER_TABLE
169: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
170: , p6_a2 out nocopy JTF_NUMBER_TABLE
171: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
172: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
173: , p6_a5 out nocopy JTF_NUMBER_TABLE
174: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 173: , p6_a5 out nocopy JTF_NUMBER_TABLE

169: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
170: , p6_a2 out nocopy JTF_NUMBER_TABLE
171: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
172: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
173: , p6_a5 out nocopy JTF_NUMBER_TABLE
174: , p6_a6 out nocopy JTF_NUMBER_TABLE
175: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
176: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
177: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 174: , p6_a6 out nocopy JTF_NUMBER_TABLE

170: , p6_a2 out nocopy JTF_NUMBER_TABLE
171: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
172: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
173: , p6_a5 out nocopy JTF_NUMBER_TABLE
174: , p6_a6 out nocopy JTF_NUMBER_TABLE
175: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
176: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
177: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
178: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 193: , p6_a25 out nocopy JTF_NUMBER_TABLE

189: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
190: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
191: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
192: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
193: , p6_a25 out nocopy JTF_NUMBER_TABLE
194: , p6_a26 out nocopy JTF_DATE_TABLE
195: , p6_a27 out nocopy JTF_NUMBER_TABLE
196: , p6_a28 out nocopy JTF_DATE_TABLE
197: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 195: , p6_a27 out nocopy JTF_NUMBER_TABLE

191: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
192: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
193: , p6_a25 out nocopy JTF_NUMBER_TABLE
194: , p6_a26 out nocopy JTF_DATE_TABLE
195: , p6_a27 out nocopy JTF_NUMBER_TABLE
196: , p6_a28 out nocopy JTF_DATE_TABLE
197: , p6_a29 out nocopy JTF_NUMBER_TABLE
198: , p6_a30 out nocopy JTF_DATE_TABLE
199: );

Line 197: , p6_a29 out nocopy JTF_NUMBER_TABLE

193: , p6_a25 out nocopy JTF_NUMBER_TABLE
194: , p6_a26 out nocopy JTF_DATE_TABLE
195: , p6_a27 out nocopy JTF_NUMBER_TABLE
196: , p6_a28 out nocopy JTF_DATE_TABLE
197: , p6_a29 out nocopy JTF_NUMBER_TABLE
198: , p6_a30 out nocopy JTF_DATE_TABLE
199: );
200: end okl_mass_rebook_pub_w;