DBA Data[Home] [Help]

APPS.OKL_MASS_REBOOK_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p31(t out nocopy okl_mass_rebook_pvt.crit_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_mass_rebook_pvt_w as
2: /* $Header: OKLEMRPS.pls 120.3 2007/07/11 16:52:29 ssdeshpa ship $ */
3: procedure rosetta_table_copy_in_p31(t out nocopy okl_mass_rebook_pvt.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_p31(t okl_mass_rebook_pvt.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_p31(t okl_mass_rebook_pvt.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 18: procedure rosetta_table_copy_in_p33(t out nocopy okl_mass_rebook_pvt.rbk_tbl_type, a0 JTF_NUMBER_TABLE

14: , a4 out nocopy JTF_VARCHAR2_TABLE_200
15: , a5 out nocopy JTF_VARCHAR2_TABLE_200
16: );
17:
18: procedure rosetta_table_copy_in_p33(t out nocopy okl_mass_rebook_pvt.rbk_tbl_type, a0 JTF_NUMBER_TABLE
19: , a1 JTF_VARCHAR2_TABLE_200
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_VARCHAR2_TABLE_600
22: );

Line 20: , a2 JTF_NUMBER_TABLE

16: );
17:
18: procedure rosetta_table_copy_in_p33(t out nocopy okl_mass_rebook_pvt.rbk_tbl_type, a0 JTF_NUMBER_TABLE
19: , a1 JTF_VARCHAR2_TABLE_200
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_VARCHAR2_TABLE_600
22: );
23: procedure rosetta_table_copy_out_p33(t okl_mass_rebook_pvt.rbk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 23: procedure rosetta_table_copy_out_p33(t okl_mass_rebook_pvt.rbk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

19: , a1 JTF_VARCHAR2_TABLE_200
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_VARCHAR2_TABLE_600
22: );
23: procedure rosetta_table_copy_out_p33(t okl_mass_rebook_pvt.rbk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_VARCHAR2_TABLE_200
25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_VARCHAR2_TABLE_600
27: );

Line 25: , a2 out nocopy JTF_NUMBER_TABLE

21: , a3 JTF_VARCHAR2_TABLE_600
22: );
23: procedure rosetta_table_copy_out_p33(t okl_mass_rebook_pvt.rbk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_VARCHAR2_TABLE_200
25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_VARCHAR2_TABLE_600
27: );
28:
29: procedure rosetta_table_copy_in_p35(t out nocopy okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 JTF_NUMBER_TABLE

Line 29: procedure rosetta_table_copy_in_p35(t out nocopy okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 JTF_NUMBER_TABLE

25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_VARCHAR2_TABLE_600
27: );
28:
29: procedure rosetta_table_copy_in_p35(t out nocopy okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 JTF_NUMBER_TABLE
30: , a1 JTF_NUMBER_TABLE
31: , a2 JTF_VARCHAR2_TABLE_500
32: , a3 JTF_VARCHAR2_TABLE_500
33: , a4 JTF_VARCHAR2_TABLE_500

Line 30: , a1 JTF_NUMBER_TABLE

26: , a3 out nocopy JTF_VARCHAR2_TABLE_600
27: );
28:
29: procedure rosetta_table_copy_in_p35(t out nocopy okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 JTF_NUMBER_TABLE
30: , a1 JTF_NUMBER_TABLE
31: , a2 JTF_VARCHAR2_TABLE_500
32: , a3 JTF_VARCHAR2_TABLE_500
33: , a4 JTF_VARCHAR2_TABLE_500
34: , a5 JTF_VARCHAR2_TABLE_500

Line 57: procedure rosetta_table_copy_out_p35(t okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

53: , a24 JTF_VARCHAR2_TABLE_100
54: , a25 JTF_VARCHAR2_TABLE_100
55: , a26 JTF_VARCHAR2_TABLE_100
56: );
57: procedure rosetta_table_copy_out_p35(t okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_VARCHAR2_TABLE_500
60: , a3 out nocopy JTF_VARCHAR2_TABLE_500
61: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 58: , a1 out nocopy JTF_NUMBER_TABLE

54: , a25 JTF_VARCHAR2_TABLE_100
55: , a26 JTF_VARCHAR2_TABLE_100
56: );
57: procedure rosetta_table_copy_out_p35(t okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_VARCHAR2_TABLE_500
60: , a3 out nocopy JTF_VARCHAR2_TABLE_500
61: , a4 out nocopy JTF_VARCHAR2_TABLE_500
62: , a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 86: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE

82: , a25 out nocopy JTF_VARCHAR2_TABLE_100
83: , a26 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: );
89: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE

Line 87: , a1 JTF_NUMBER_TABLE

83: , a26 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: );
89: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: );

Line 89: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

85:
86: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: );
89: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: );
92:
93: procedure rosetta_table_copy_in_p39(t out nocopy okl_mass_rebook_pvt.kle_tbl_type, a0 JTF_NUMBER_TABLE

Line 90: , a1 out nocopy JTF_NUMBER_TABLE

86: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: );
89: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: );
92:
93: procedure rosetta_table_copy_in_p39(t out nocopy okl_mass_rebook_pvt.kle_tbl_type, a0 JTF_NUMBER_TABLE
94: );

Line 93: procedure rosetta_table_copy_in_p39(t out nocopy okl_mass_rebook_pvt.kle_tbl_type, a0 JTF_NUMBER_TABLE

89: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: );
92:
93: procedure rosetta_table_copy_in_p39(t out nocopy okl_mass_rebook_pvt.kle_tbl_type, a0 JTF_NUMBER_TABLE
94: );
95: procedure rosetta_table_copy_out_p39(t okl_mass_rebook_pvt.kle_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: );
97:

Line 95: procedure rosetta_table_copy_out_p39(t okl_mass_rebook_pvt.kle_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

91: );
92:
93: procedure rosetta_table_copy_in_p39(t out nocopy okl_mass_rebook_pvt.kle_tbl_type, a0 JTF_NUMBER_TABLE
94: );
95: procedure rosetta_table_copy_out_p39(t okl_mass_rebook_pvt.kle_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: );
97:
98: procedure build_and_get_contracts(p_api_version NUMBER
99: , p_init_msg_list VARCHAR2

Line 104: , p6_a0 JTF_NUMBER_TABLE

100: , x_return_status out nocopy VARCHAR2
101: , x_msg_count out nocopy NUMBER
102: , x_msg_data out nocopy VARCHAR2
103: , p_request_name VARCHAR2
104: , p6_a0 JTF_NUMBER_TABLE
105: , p6_a1 JTF_VARCHAR2_TABLE_600
106: , p6_a2 JTF_NUMBER_TABLE
107: , p6_a3 JTF_VARCHAR2_TABLE_100
108: , p6_a4 JTF_VARCHAR2_TABLE_100

Line 106: , p6_a2 JTF_NUMBER_TABLE

102: , x_msg_data out nocopy VARCHAR2
103: , p_request_name VARCHAR2
104: , p6_a0 JTF_NUMBER_TABLE
105: , p6_a1 JTF_VARCHAR2_TABLE_600
106: , p6_a2 JTF_NUMBER_TABLE
107: , p6_a3 JTF_VARCHAR2_TABLE_100
108: , p6_a4 JTF_VARCHAR2_TABLE_100
109: , p6_a5 JTF_VARCHAR2_TABLE_100
110: , p6_a6 JTF_VARCHAR2_TABLE_600

Line 131: , p6_a27 JTF_NUMBER_TABLE

127: , p6_a23 JTF_VARCHAR2_TABLE_500
128: , p6_a24 JTF_VARCHAR2_TABLE_500
129: , p6_a25 JTF_VARCHAR2_TABLE_500
130: , p6_a26 JTF_VARCHAR2_TABLE_500
131: , p6_a27 JTF_NUMBER_TABLE
132: , p6_a28 JTF_DATE_TABLE
133: , p6_a29 JTF_NUMBER_TABLE
134: , p6_a30 JTF_DATE_TABLE
135: , p6_a31 JTF_NUMBER_TABLE

Line 133: , p6_a29 JTF_NUMBER_TABLE

129: , p6_a25 JTF_VARCHAR2_TABLE_500
130: , p6_a26 JTF_VARCHAR2_TABLE_500
131: , p6_a27 JTF_NUMBER_TABLE
132: , p6_a28 JTF_DATE_TABLE
133: , p6_a29 JTF_NUMBER_TABLE
134: , p6_a30 JTF_DATE_TABLE
135: , p6_a31 JTF_NUMBER_TABLE
136: , p7_a0 out nocopy JTF_NUMBER_TABLE
137: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 135: , p6_a31 JTF_NUMBER_TABLE

131: , p6_a27 JTF_NUMBER_TABLE
132: , p6_a28 JTF_DATE_TABLE
133: , p6_a29 JTF_NUMBER_TABLE
134: , p6_a30 JTF_DATE_TABLE
135: , p6_a31 JTF_NUMBER_TABLE
136: , p7_a0 out nocopy JTF_NUMBER_TABLE
137: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 136: , p7_a0 out nocopy JTF_NUMBER_TABLE

132: , p6_a28 JTF_DATE_TABLE
133: , p6_a29 JTF_NUMBER_TABLE
134: , p6_a30 JTF_DATE_TABLE
135: , p6_a31 JTF_NUMBER_TABLE
136: , p7_a0 out nocopy JTF_NUMBER_TABLE
137: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 138: , p7_a2 out nocopy JTF_NUMBER_TABLE

134: , p6_a30 JTF_DATE_TABLE
135: , p6_a31 JTF_NUMBER_TABLE
136: , p7_a0 out nocopy JTF_NUMBER_TABLE
137: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_NUMBER_TABLE

Line 141: , p7_a5 out nocopy JTF_NUMBER_TABLE

137: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_NUMBER_TABLE
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 142: , p7_a6 out nocopy JTF_NUMBER_TABLE

138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_NUMBER_TABLE
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 161: , p7_a25 out nocopy JTF_NUMBER_TABLE

157: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
158: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
159: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
160: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
161: , p7_a25 out nocopy JTF_NUMBER_TABLE
162: , p7_a26 out nocopy JTF_DATE_TABLE
163: , p7_a27 out nocopy JTF_NUMBER_TABLE
164: , p7_a28 out nocopy JTF_DATE_TABLE
165: , p7_a29 out nocopy JTF_NUMBER_TABLE

Line 163: , p7_a27 out nocopy JTF_NUMBER_TABLE

159: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
160: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
161: , p7_a25 out nocopy JTF_NUMBER_TABLE
162: , p7_a26 out nocopy JTF_DATE_TABLE
163: , p7_a27 out nocopy JTF_NUMBER_TABLE
164: , p7_a28 out nocopy JTF_DATE_TABLE
165: , p7_a29 out nocopy JTF_NUMBER_TABLE
166: , p7_a30 out nocopy JTF_DATE_TABLE
167: , x_rbk_count out nocopy NUMBER

Line 165: , p7_a29 out nocopy JTF_NUMBER_TABLE

161: , p7_a25 out nocopy JTF_NUMBER_TABLE
162: , p7_a26 out nocopy JTF_DATE_TABLE
163: , p7_a27 out nocopy JTF_NUMBER_TABLE
164: , p7_a28 out nocopy JTF_DATE_TABLE
165: , p7_a29 out nocopy JTF_NUMBER_TABLE
166: , p7_a30 out nocopy JTF_DATE_TABLE
167: , x_rbk_count out nocopy NUMBER
168: );
169: procedure build_and_get_contracts(p_api_version NUMBER

Line 176: , p7_a0 JTF_NUMBER_TABLE

172: , x_msg_count out nocopy NUMBER
173: , x_msg_data out nocopy VARCHAR2
174: , p_request_name VARCHAR2
175: , p_transaction_date date
176: , p7_a0 JTF_NUMBER_TABLE
177: , p7_a1 JTF_VARCHAR2_TABLE_600
178: , p7_a2 JTF_NUMBER_TABLE
179: , p7_a3 JTF_VARCHAR2_TABLE_100
180: , p7_a4 JTF_VARCHAR2_TABLE_100

Line 178: , p7_a2 JTF_NUMBER_TABLE

174: , p_request_name VARCHAR2
175: , p_transaction_date date
176: , p7_a0 JTF_NUMBER_TABLE
177: , p7_a1 JTF_VARCHAR2_TABLE_600
178: , p7_a2 JTF_NUMBER_TABLE
179: , p7_a3 JTF_VARCHAR2_TABLE_100
180: , p7_a4 JTF_VARCHAR2_TABLE_100
181: , p7_a5 JTF_VARCHAR2_TABLE_100
182: , p7_a6 JTF_VARCHAR2_TABLE_600

Line 203: , p7_a27 JTF_NUMBER_TABLE

199: , p7_a23 JTF_VARCHAR2_TABLE_500
200: , p7_a24 JTF_VARCHAR2_TABLE_500
201: , p7_a25 JTF_VARCHAR2_TABLE_500
202: , p7_a26 JTF_VARCHAR2_TABLE_500
203: , p7_a27 JTF_NUMBER_TABLE
204: , p7_a28 JTF_DATE_TABLE
205: , p7_a29 JTF_NUMBER_TABLE
206: , p7_a30 JTF_DATE_TABLE
207: , p7_a31 JTF_NUMBER_TABLE

Line 205: , p7_a29 JTF_NUMBER_TABLE

201: , p7_a25 JTF_VARCHAR2_TABLE_500
202: , p7_a26 JTF_VARCHAR2_TABLE_500
203: , p7_a27 JTF_NUMBER_TABLE
204: , p7_a28 JTF_DATE_TABLE
205: , p7_a29 JTF_NUMBER_TABLE
206: , p7_a30 JTF_DATE_TABLE
207: , p7_a31 JTF_NUMBER_TABLE
208: , p8_a0 out nocopy JTF_NUMBER_TABLE
209: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 207: , p7_a31 JTF_NUMBER_TABLE

203: , p7_a27 JTF_NUMBER_TABLE
204: , p7_a28 JTF_DATE_TABLE
205: , p7_a29 JTF_NUMBER_TABLE
206: , p7_a30 JTF_DATE_TABLE
207: , p7_a31 JTF_NUMBER_TABLE
208: , p8_a0 out nocopy JTF_NUMBER_TABLE
209: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
210: , p8_a2 out nocopy JTF_NUMBER_TABLE
211: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 208: , p8_a0 out nocopy JTF_NUMBER_TABLE

204: , p7_a28 JTF_DATE_TABLE
205: , p7_a29 JTF_NUMBER_TABLE
206: , p7_a30 JTF_DATE_TABLE
207: , p7_a31 JTF_NUMBER_TABLE
208: , p8_a0 out nocopy JTF_NUMBER_TABLE
209: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
210: , p8_a2 out nocopy JTF_NUMBER_TABLE
211: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
212: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 210: , p8_a2 out nocopy JTF_NUMBER_TABLE

206: , p7_a30 JTF_DATE_TABLE
207: , p7_a31 JTF_NUMBER_TABLE
208: , p8_a0 out nocopy JTF_NUMBER_TABLE
209: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
210: , p8_a2 out nocopy JTF_NUMBER_TABLE
211: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
212: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600
213: , p8_a5 out nocopy JTF_NUMBER_TABLE
214: , p8_a6 out nocopy JTF_NUMBER_TABLE

Line 213: , p8_a5 out nocopy JTF_NUMBER_TABLE

209: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
210: , p8_a2 out nocopy JTF_NUMBER_TABLE
211: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
212: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600
213: , p8_a5 out nocopy JTF_NUMBER_TABLE
214: , p8_a6 out nocopy JTF_NUMBER_TABLE
215: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
216: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
217: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 214: , p8_a6 out nocopy JTF_NUMBER_TABLE

210: , p8_a2 out nocopy JTF_NUMBER_TABLE
211: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
212: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600
213: , p8_a5 out nocopy JTF_NUMBER_TABLE
214: , p8_a6 out nocopy JTF_NUMBER_TABLE
215: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
216: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
217: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
218: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 233: , p8_a25 out nocopy JTF_NUMBER_TABLE

229: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_500
230: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_500
231: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_500
232: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_500
233: , p8_a25 out nocopy JTF_NUMBER_TABLE
234: , p8_a26 out nocopy JTF_DATE_TABLE
235: , p8_a27 out nocopy JTF_NUMBER_TABLE
236: , p8_a28 out nocopy JTF_DATE_TABLE
237: , p8_a29 out nocopy JTF_NUMBER_TABLE

Line 235: , p8_a27 out nocopy JTF_NUMBER_TABLE

231: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_500
232: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_500
233: , p8_a25 out nocopy JTF_NUMBER_TABLE
234: , p8_a26 out nocopy JTF_DATE_TABLE
235: , p8_a27 out nocopy JTF_NUMBER_TABLE
236: , p8_a28 out nocopy JTF_DATE_TABLE
237: , p8_a29 out nocopy JTF_NUMBER_TABLE
238: , p8_a30 out nocopy JTF_DATE_TABLE
239: , x_rbk_count out nocopy NUMBER

Line 237: , p8_a29 out nocopy JTF_NUMBER_TABLE

233: , p8_a25 out nocopy JTF_NUMBER_TABLE
234: , p8_a26 out nocopy JTF_DATE_TABLE
235: , p8_a27 out nocopy JTF_NUMBER_TABLE
236: , p8_a28 out nocopy JTF_DATE_TABLE
237: , p8_a29 out nocopy JTF_NUMBER_TABLE
238: , p8_a30 out nocopy JTF_DATE_TABLE
239: , x_rbk_count out nocopy NUMBER
240: );
241: procedure apply_mass_rebook(p_api_version NUMBER

Line 246: , p5_a0 JTF_NUMBER_TABLE

242: , p_init_msg_list VARCHAR2
243: , x_return_status out nocopy VARCHAR2
244: , x_msg_count out nocopy NUMBER
245: , x_msg_data out nocopy VARCHAR2
246: , p5_a0 JTF_NUMBER_TABLE
247: , p5_a1 JTF_VARCHAR2_TABLE_200
248: , p5_a2 JTF_NUMBER_TABLE
249: , p5_a3 JTF_VARCHAR2_TABLE_600
250: , p_deprn_method_code VARCHAR2

Line 248: , p5_a2 JTF_NUMBER_TABLE

244: , x_msg_count out nocopy NUMBER
245: , x_msg_data out nocopy VARCHAR2
246: , p5_a0 JTF_NUMBER_TABLE
247: , p5_a1 JTF_VARCHAR2_TABLE_200
248: , p5_a2 JTF_NUMBER_TABLE
249: , p5_a3 JTF_VARCHAR2_TABLE_600
250: , p_deprn_method_code VARCHAR2
251: , p_in_service_date date
252: , p_life_in_months NUMBER

Line 256: , p12_a0 JTF_NUMBER_TABLE

252: , p_life_in_months NUMBER
253: , p_basic_rate NUMBER
254: , p_adjusted_rate NUMBER
255: , p_residual_value NUMBER
256: , p12_a0 JTF_NUMBER_TABLE
257: , p12_a1 JTF_NUMBER_TABLE
258: , p12_a2 JTF_VARCHAR2_TABLE_500
259: , p12_a3 JTF_VARCHAR2_TABLE_500
260: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 257: , p12_a1 JTF_NUMBER_TABLE

253: , p_basic_rate NUMBER
254: , p_adjusted_rate NUMBER
255: , p_residual_value NUMBER
256: , p12_a0 JTF_NUMBER_TABLE
257: , p12_a1 JTF_NUMBER_TABLE
258: , p12_a2 JTF_VARCHAR2_TABLE_500
259: , p12_a3 JTF_VARCHAR2_TABLE_500
260: , p12_a4 JTF_VARCHAR2_TABLE_500
261: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 289: , p5_a0 JTF_NUMBER_TABLE

285: , p_init_msg_list VARCHAR2
286: , x_return_status out nocopy VARCHAR2
287: , x_msg_count out nocopy NUMBER
288: , x_msg_data out nocopy VARCHAR2
289: , p5_a0 JTF_NUMBER_TABLE
290: , p5_a1 JTF_VARCHAR2_TABLE_200
291: , p5_a2 JTF_NUMBER_TABLE
292: , p5_a3 JTF_VARCHAR2_TABLE_600
293: , p_deprn_method_code VARCHAR2

Line 291: , p5_a2 JTF_NUMBER_TABLE

287: , x_msg_count out nocopy NUMBER
288: , x_msg_data out nocopy VARCHAR2
289: , p5_a0 JTF_NUMBER_TABLE
290: , p5_a1 JTF_VARCHAR2_TABLE_200
291: , p5_a2 JTF_NUMBER_TABLE
292: , p5_a3 JTF_VARCHAR2_TABLE_600
293: , p_deprn_method_code VARCHAR2
294: , p_in_service_date date
295: , p_life_in_months NUMBER

Line 299: , p12_a0 JTF_NUMBER_TABLE

295: , p_life_in_months NUMBER
296: , p_basic_rate NUMBER
297: , p_adjusted_rate NUMBER
298: , p_residual_value NUMBER
299: , p12_a0 JTF_NUMBER_TABLE
300: , p12_a1 JTF_NUMBER_TABLE
301: , p12_a2 JTF_VARCHAR2_TABLE_500
302: , p12_a3 JTF_VARCHAR2_TABLE_500
303: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 300: , p12_a1 JTF_NUMBER_TABLE

296: , p_basic_rate NUMBER
297: , p_adjusted_rate NUMBER
298: , p_residual_value NUMBER
299: , p12_a0 JTF_NUMBER_TABLE
300: , p12_a1 JTF_NUMBER_TABLE
301: , p12_a2 JTF_VARCHAR2_TABLE_500
302: , p12_a3 JTF_VARCHAR2_TABLE_500
303: , p12_a4 JTF_VARCHAR2_TABLE_500
304: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 326: , p13_a0 out nocopy JTF_NUMBER_TABLE

322: , p12_a23 JTF_VARCHAR2_TABLE_200
323: , p12_a24 JTF_VARCHAR2_TABLE_100
324: , p12_a25 JTF_VARCHAR2_TABLE_100
325: , p12_a26 JTF_VARCHAR2_TABLE_100
326: , p13_a0 out nocopy JTF_NUMBER_TABLE
327: , p13_a1 out nocopy JTF_NUMBER_TABLE
328: );
329: procedure apply_mass_rebook(p_api_version NUMBER
330: , p_init_msg_list VARCHAR2

Line 327: , p13_a1 out nocopy JTF_NUMBER_TABLE

323: , p12_a24 JTF_VARCHAR2_TABLE_100
324: , p12_a25 JTF_VARCHAR2_TABLE_100
325: , p12_a26 JTF_VARCHAR2_TABLE_100
326: , p13_a0 out nocopy JTF_NUMBER_TABLE
327: , p13_a1 out nocopy JTF_NUMBER_TABLE
328: );
329: procedure apply_mass_rebook(p_api_version NUMBER
330: , p_init_msg_list VARCHAR2
331: , x_return_status out nocopy VARCHAR2

Line 334: , p5_a0 JTF_NUMBER_TABLE

330: , p_init_msg_list VARCHAR2
331: , x_return_status out nocopy VARCHAR2
332: , x_msg_count out nocopy NUMBER
333: , x_msg_data out nocopy VARCHAR2
334: , p5_a0 JTF_NUMBER_TABLE
335: , p5_a1 JTF_VARCHAR2_TABLE_200
336: , p5_a2 JTF_NUMBER_TABLE
337: , p5_a3 JTF_VARCHAR2_TABLE_600
338: , p_deprn_method_code VARCHAR2

Line 336: , p5_a2 JTF_NUMBER_TABLE

332: , x_msg_count out nocopy NUMBER
333: , x_msg_data out nocopy VARCHAR2
334: , p5_a0 JTF_NUMBER_TABLE
335: , p5_a1 JTF_VARCHAR2_TABLE_200
336: , p5_a2 JTF_NUMBER_TABLE
337: , p5_a3 JTF_VARCHAR2_TABLE_600
338: , p_deprn_method_code VARCHAR2
339: , p_in_service_date date
340: , p_life_in_months NUMBER

Line 344: , p12_a0 JTF_NUMBER_TABLE

340: , p_life_in_months NUMBER
341: , p_basic_rate NUMBER
342: , p_adjusted_rate NUMBER
343: , p_residual_value NUMBER
344: , p12_a0 JTF_NUMBER_TABLE
345: , p12_a1 JTF_NUMBER_TABLE
346: , p12_a2 JTF_VARCHAR2_TABLE_500
347: , p12_a3 JTF_VARCHAR2_TABLE_500
348: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 345: , p12_a1 JTF_NUMBER_TABLE

341: , p_basic_rate NUMBER
342: , p_adjusted_rate NUMBER
343: , p_residual_value NUMBER
344: , p12_a0 JTF_NUMBER_TABLE
345: , p12_a1 JTF_NUMBER_TABLE
346: , p12_a2 JTF_VARCHAR2_TABLE_500
347: , p12_a3 JTF_VARCHAR2_TABLE_500
348: , p12_a4 JTF_VARCHAR2_TABLE_500
349: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 372: , p14_a0 out nocopy JTF_NUMBER_TABLE

368: , p12_a24 JTF_VARCHAR2_TABLE_100
369: , p12_a25 JTF_VARCHAR2_TABLE_100
370: , p12_a26 JTF_VARCHAR2_TABLE_100
371: , p_transaction_date date
372: , p14_a0 out nocopy JTF_NUMBER_TABLE
373: , p14_a1 out nocopy JTF_NUMBER_TABLE
374: );
375: procedure apply_mass_rebook(p_api_version NUMBER
376: , p_init_msg_list VARCHAR2

Line 373: , p14_a1 out nocopy JTF_NUMBER_TABLE

369: , p12_a25 JTF_VARCHAR2_TABLE_100
370: , p12_a26 JTF_VARCHAR2_TABLE_100
371: , p_transaction_date date
372: , p14_a0 out nocopy JTF_NUMBER_TABLE
373: , p14_a1 out nocopy JTF_NUMBER_TABLE
374: );
375: procedure apply_mass_rebook(p_api_version NUMBER
376: , p_init_msg_list VARCHAR2
377: , x_return_status out nocopy VARCHAR2

Line 380: , p5_a0 JTF_NUMBER_TABLE

376: , p_init_msg_list VARCHAR2
377: , x_return_status out nocopy VARCHAR2
378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_VARCHAR2_TABLE_200
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_VARCHAR2_TABLE_600
384: , p_deprn_method_code VARCHAR2

Line 382: , p5_a2 JTF_NUMBER_TABLE

378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_VARCHAR2_TABLE_200
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_VARCHAR2_TABLE_600
384: , p_deprn_method_code VARCHAR2
385: , p_in_service_date date
386: , p_life_in_months NUMBER

Line 390: , p12_a0 JTF_NUMBER_TABLE

386: , p_life_in_months NUMBER
387: , p_basic_rate NUMBER
388: , p_adjusted_rate NUMBER
389: , p_residual_value NUMBER
390: , p12_a0 JTF_NUMBER_TABLE
391: , p12_a1 JTF_NUMBER_TABLE
392: , p12_a2 JTF_VARCHAR2_TABLE_500
393: , p12_a3 JTF_VARCHAR2_TABLE_500
394: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 391: , p12_a1 JTF_NUMBER_TABLE

387: , p_basic_rate NUMBER
388: , p_adjusted_rate NUMBER
389: , p_residual_value NUMBER
390: , p12_a0 JTF_NUMBER_TABLE
391: , p12_a1 JTF_NUMBER_TABLE
392: , p12_a2 JTF_VARCHAR2_TABLE_500
393: , p12_a3 JTF_VARCHAR2_TABLE_500
394: , p12_a4 JTF_VARCHAR2_TABLE_500
395: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 426: , p5_a0 JTF_NUMBER_TABLE

422: , p_init_msg_list VARCHAR2
423: , x_return_status out nocopy VARCHAR2
424: , x_msg_count out nocopy NUMBER
425: , x_msg_data out nocopy VARCHAR2
426: , p5_a0 JTF_NUMBER_TABLE
427: , p5_a1 JTF_VARCHAR2_TABLE_200
428: , p5_a2 JTF_NUMBER_TABLE
429: , p5_a3 JTF_VARCHAR2_TABLE_600
430: , p_deprn_method_code VARCHAR2

Line 428: , p5_a2 JTF_NUMBER_TABLE

424: , x_msg_count out nocopy NUMBER
425: , x_msg_data out nocopy VARCHAR2
426: , p5_a0 JTF_NUMBER_TABLE
427: , p5_a1 JTF_VARCHAR2_TABLE_200
428: , p5_a2 JTF_NUMBER_TABLE
429: , p5_a3 JTF_VARCHAR2_TABLE_600
430: , p_deprn_method_code VARCHAR2
431: , p_in_service_date date
432: , p_life_in_months NUMBER

Line 436: , p12_a0 JTF_NUMBER_TABLE

432: , p_life_in_months NUMBER
433: , p_basic_rate NUMBER
434: , p_adjusted_rate NUMBER
435: , p_residual_value NUMBER
436: , p12_a0 JTF_NUMBER_TABLE
437: , p12_a1 JTF_NUMBER_TABLE
438: , p12_a2 JTF_VARCHAR2_TABLE_500
439: , p12_a3 JTF_VARCHAR2_TABLE_500
440: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 437: , p12_a1 JTF_NUMBER_TABLE

433: , p_basic_rate NUMBER
434: , p_adjusted_rate NUMBER
435: , p_residual_value NUMBER
436: , p12_a0 JTF_NUMBER_TABLE
437: , p12_a1 JTF_NUMBER_TABLE
438: , p12_a2 JTF_VARCHAR2_TABLE_500
439: , p12_a3 JTF_VARCHAR2_TABLE_500
440: , p12_a4 JTF_VARCHAR2_TABLE_500
441: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 474: , p6_a0 JTF_NUMBER_TABLE

470: , x_return_status out nocopy VARCHAR2
471: , x_msg_count out nocopy NUMBER
472: , x_msg_data out nocopy VARCHAR2
473: , p_chr_id NUMBER
474: , p6_a0 JTF_NUMBER_TABLE
475: , p_source_trx_id NUMBER
476: , p_source_trx_type VARCHAR2
477: , p_transaction_date date
478: , x_mass_rebook_trx_id out nocopy NUMBER

Line 481: , p13_a0 JTF_NUMBER_TABLE

477: , p_transaction_date date
478: , x_mass_rebook_trx_id out nocopy NUMBER
479: , p_ppd_amount NUMBER
480: , p_ppd_reason_code VARCHAR2
481: , p13_a0 JTF_NUMBER_TABLE
482: , p13_a1 JTF_NUMBER_TABLE
483: , p13_a2 JTF_VARCHAR2_TABLE_500
484: , p13_a3 JTF_VARCHAR2_TABLE_500
485: , p13_a4 JTF_VARCHAR2_TABLE_500

Line 482: , p13_a1 JTF_NUMBER_TABLE

478: , x_mass_rebook_trx_id out nocopy NUMBER
479: , p_ppd_amount NUMBER
480: , p_ppd_reason_code VARCHAR2
481: , p13_a0 JTF_NUMBER_TABLE
482: , p13_a1 JTF_NUMBER_TABLE
483: , p13_a2 JTF_VARCHAR2_TABLE_500
484: , p13_a3 JTF_VARCHAR2_TABLE_500
485: , p13_a4 JTF_VARCHAR2_TABLE_500
486: , p13_a5 JTF_VARCHAR2_TABLE_500

Line 514: , p5_a0 JTF_NUMBER_TABLE

510: , p_init_msg_list VARCHAR2
511: , x_return_status out nocopy VARCHAR2
512: , x_msg_count out nocopy NUMBER
513: , x_msg_data out nocopy VARCHAR2
514: , p5_a0 JTF_NUMBER_TABLE
515: , p5_a1 JTF_VARCHAR2_TABLE_200
516: , p5_a2 JTF_NUMBER_TABLE
517: , p5_a3 JTF_VARCHAR2_TABLE_200
518: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 516: , p5_a2 JTF_NUMBER_TABLE

512: , x_msg_count out nocopy NUMBER
513: , x_msg_data out nocopy VARCHAR2
514: , p5_a0 JTF_NUMBER_TABLE
515: , p5_a1 JTF_VARCHAR2_TABLE_200
516: , p5_a2 JTF_NUMBER_TABLE
517: , p5_a3 JTF_VARCHAR2_TABLE_200
518: , p5_a4 JTF_VARCHAR2_TABLE_600
519: , p5_a5 JTF_NUMBER_TABLE
520: , p5_a6 JTF_NUMBER_TABLE

Line 519: , p5_a5 JTF_NUMBER_TABLE

515: , p5_a1 JTF_VARCHAR2_TABLE_200
516: , p5_a2 JTF_NUMBER_TABLE
517: , p5_a3 JTF_VARCHAR2_TABLE_200
518: , p5_a4 JTF_VARCHAR2_TABLE_600
519: , p5_a5 JTF_NUMBER_TABLE
520: , p5_a6 JTF_NUMBER_TABLE
521: , p5_a7 JTF_VARCHAR2_TABLE_100
522: , p5_a8 JTF_VARCHAR2_TABLE_100
523: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 520: , p5_a6 JTF_NUMBER_TABLE

516: , p5_a2 JTF_NUMBER_TABLE
517: , p5_a3 JTF_VARCHAR2_TABLE_200
518: , p5_a4 JTF_VARCHAR2_TABLE_600
519: , p5_a5 JTF_NUMBER_TABLE
520: , p5_a6 JTF_NUMBER_TABLE
521: , p5_a7 JTF_VARCHAR2_TABLE_100
522: , p5_a8 JTF_VARCHAR2_TABLE_100
523: , p5_a9 JTF_VARCHAR2_TABLE_100
524: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 539: , p5_a25 JTF_NUMBER_TABLE

535: , p5_a21 JTF_VARCHAR2_TABLE_500
536: , p5_a22 JTF_VARCHAR2_TABLE_500
537: , p5_a23 JTF_VARCHAR2_TABLE_500
538: , p5_a24 JTF_VARCHAR2_TABLE_500
539: , p5_a25 JTF_NUMBER_TABLE
540: , p5_a26 JTF_DATE_TABLE
541: , p5_a27 JTF_NUMBER_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE

Line 541: , p5_a27 JTF_NUMBER_TABLE

537: , p5_a23 JTF_VARCHAR2_TABLE_500
538: , p5_a24 JTF_VARCHAR2_TABLE_500
539: , p5_a25 JTF_NUMBER_TABLE
540: , p5_a26 JTF_DATE_TABLE
541: , p5_a27 JTF_NUMBER_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_DATE_TABLE
545: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 543: , p5_a29 JTF_NUMBER_TABLE

539: , p5_a25 JTF_NUMBER_TABLE
540: , p5_a26 JTF_DATE_TABLE
541: , p5_a27 JTF_NUMBER_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_DATE_TABLE
545: , p6_a0 out nocopy JTF_NUMBER_TABLE
546: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
547: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 545: , p6_a0 out nocopy JTF_NUMBER_TABLE

541: , p5_a27 JTF_NUMBER_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_DATE_TABLE
545: , p6_a0 out nocopy JTF_NUMBER_TABLE
546: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
547: , p6_a2 out nocopy JTF_NUMBER_TABLE
548: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
549: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 547: , p6_a2 out nocopy JTF_NUMBER_TABLE

543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_DATE_TABLE
545: , p6_a0 out nocopy JTF_NUMBER_TABLE
546: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
547: , p6_a2 out nocopy JTF_NUMBER_TABLE
548: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
549: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
550: , p6_a5 out nocopy JTF_NUMBER_TABLE
551: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 550: , p6_a5 out nocopy JTF_NUMBER_TABLE

546: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
547: , p6_a2 out nocopy JTF_NUMBER_TABLE
548: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
549: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
550: , p6_a5 out nocopy JTF_NUMBER_TABLE
551: , p6_a6 out nocopy JTF_NUMBER_TABLE
552: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
553: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
554: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 551: , p6_a6 out nocopy JTF_NUMBER_TABLE

547: , p6_a2 out nocopy JTF_NUMBER_TABLE
548: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
549: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
550: , p6_a5 out nocopy JTF_NUMBER_TABLE
551: , p6_a6 out nocopy JTF_NUMBER_TABLE
552: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
553: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
554: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
555: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 570: , p6_a25 out nocopy JTF_NUMBER_TABLE

566: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
567: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
568: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
569: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
570: , p6_a25 out nocopy JTF_NUMBER_TABLE
571: , p6_a26 out nocopy JTF_DATE_TABLE
572: , p6_a27 out nocopy JTF_NUMBER_TABLE
573: , p6_a28 out nocopy JTF_DATE_TABLE
574: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 572: , p6_a27 out nocopy JTF_NUMBER_TABLE

568: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
569: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
570: , p6_a25 out nocopy JTF_NUMBER_TABLE
571: , p6_a26 out nocopy JTF_DATE_TABLE
572: , p6_a27 out nocopy JTF_NUMBER_TABLE
573: , p6_a28 out nocopy JTF_DATE_TABLE
574: , p6_a29 out nocopy JTF_NUMBER_TABLE
575: , p6_a30 out nocopy JTF_DATE_TABLE
576: );

Line 574: , p6_a29 out nocopy JTF_NUMBER_TABLE

570: , p6_a25 out nocopy JTF_NUMBER_TABLE
571: , p6_a26 out nocopy JTF_DATE_TABLE
572: , p6_a27 out nocopy JTF_NUMBER_TABLE
573: , p6_a28 out nocopy JTF_DATE_TABLE
574: , p6_a29 out nocopy JTF_NUMBER_TABLE
575: , p6_a30 out nocopy JTF_DATE_TABLE
576: );
577: procedure create_mass_rbk_set_values(p_api_version NUMBER
578: , p_init_msg_list VARCHAR2

Line 583: , p6_a0 JTF_NUMBER_TABLE

579: , x_return_status out nocopy VARCHAR2
580: , x_msg_count out nocopy NUMBER
581: , x_msg_data out nocopy VARCHAR2
582: , p_request_name VARCHAR2
583: , p6_a0 JTF_NUMBER_TABLE
584: , p6_a1 JTF_VARCHAR2_TABLE_600
585: , p6_a2 JTF_NUMBER_TABLE
586: , p6_a3 JTF_VARCHAR2_TABLE_100
587: , p6_a4 JTF_VARCHAR2_TABLE_100

Line 585: , p6_a2 JTF_NUMBER_TABLE

581: , x_msg_data out nocopy VARCHAR2
582: , p_request_name VARCHAR2
583: , p6_a0 JTF_NUMBER_TABLE
584: , p6_a1 JTF_VARCHAR2_TABLE_600
585: , p6_a2 JTF_NUMBER_TABLE
586: , p6_a3 JTF_VARCHAR2_TABLE_100
587: , p6_a4 JTF_VARCHAR2_TABLE_100
588: , p6_a5 JTF_VARCHAR2_TABLE_100
589: , p6_a6 JTF_VARCHAR2_TABLE_600

Line 610: , p6_a27 JTF_NUMBER_TABLE

606: , p6_a23 JTF_VARCHAR2_TABLE_500
607: , p6_a24 JTF_VARCHAR2_TABLE_500
608: , p6_a25 JTF_VARCHAR2_TABLE_500
609: , p6_a26 JTF_VARCHAR2_TABLE_500
610: , p6_a27 JTF_NUMBER_TABLE
611: , p6_a28 JTF_DATE_TABLE
612: , p6_a29 JTF_NUMBER_TABLE
613: , p6_a30 JTF_DATE_TABLE
614: , p6_a31 JTF_NUMBER_TABLE

Line 612: , p6_a29 JTF_NUMBER_TABLE

608: , p6_a25 JTF_VARCHAR2_TABLE_500
609: , p6_a26 JTF_VARCHAR2_TABLE_500
610: , p6_a27 JTF_NUMBER_TABLE
611: , p6_a28 JTF_DATE_TABLE
612: , p6_a29 JTF_NUMBER_TABLE
613: , p6_a30 JTF_DATE_TABLE
614: , p6_a31 JTF_NUMBER_TABLE
615: , p7_a0 out nocopy JTF_NUMBER_TABLE
616: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600

Line 614: , p6_a31 JTF_NUMBER_TABLE

610: , p6_a27 JTF_NUMBER_TABLE
611: , p6_a28 JTF_DATE_TABLE
612: , p6_a29 JTF_NUMBER_TABLE
613: , p6_a30 JTF_DATE_TABLE
614: , p6_a31 JTF_NUMBER_TABLE
615: , p7_a0 out nocopy JTF_NUMBER_TABLE
616: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600
617: , p7_a2 out nocopy JTF_NUMBER_TABLE
618: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 615: , p7_a0 out nocopy JTF_NUMBER_TABLE

611: , p6_a28 JTF_DATE_TABLE
612: , p6_a29 JTF_NUMBER_TABLE
613: , p6_a30 JTF_DATE_TABLE
614: , p6_a31 JTF_NUMBER_TABLE
615: , p7_a0 out nocopy JTF_NUMBER_TABLE
616: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600
617: , p7_a2 out nocopy JTF_NUMBER_TABLE
618: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
619: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 617: , p7_a2 out nocopy JTF_NUMBER_TABLE

613: , p6_a30 JTF_DATE_TABLE
614: , p6_a31 JTF_NUMBER_TABLE
615: , p7_a0 out nocopy JTF_NUMBER_TABLE
616: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600
617: , p7_a2 out nocopy JTF_NUMBER_TABLE
618: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
619: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
620: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
621: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_600

Line 642: , p7_a27 out nocopy JTF_NUMBER_TABLE

638: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
639: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
640: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_500
641: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_500
642: , p7_a27 out nocopy JTF_NUMBER_TABLE
643: , p7_a28 out nocopy JTF_DATE_TABLE
644: , p7_a29 out nocopy JTF_NUMBER_TABLE
645: , p7_a30 out nocopy JTF_DATE_TABLE
646: , p7_a31 out nocopy JTF_NUMBER_TABLE

Line 644: , p7_a29 out nocopy JTF_NUMBER_TABLE

640: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_500
641: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_500
642: , p7_a27 out nocopy JTF_NUMBER_TABLE
643: , p7_a28 out nocopy JTF_DATE_TABLE
644: , p7_a29 out nocopy JTF_NUMBER_TABLE
645: , p7_a30 out nocopy JTF_DATE_TABLE
646: , p7_a31 out nocopy JTF_NUMBER_TABLE
647: );
648: end okl_mass_rebook_pvt_w;

Line 646: , p7_a31 out nocopy JTF_NUMBER_TABLE

642: , p7_a27 out nocopy JTF_NUMBER_TABLE
643: , p7_a28 out nocopy JTF_DATE_TABLE
644: , p7_a29 out nocopy JTF_NUMBER_TABLE
645: , p7_a30 out nocopy JTF_DATE_TABLE
646: , p7_a31 out nocopy JTF_NUMBER_TABLE
647: );
648: end okl_mass_rebook_pvt_w;