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
136: , p7_a0 out nocopy JTF_NUMBER_TABLE
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
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
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
166: , p7_a30 out nocopy JTF_DATE_TABLE
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
168: );
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
170: , p_init_msg_list VARCHAR2
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
208: , p8_a0 out nocopy JTF_NUMBER_TABLE
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
210: , p8_a2 out nocopy JTF_NUMBER_TABLE
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
238: , p8_a30 out nocopy JTF_DATE_TABLE
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
240: );
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
242: , p_init_msg_list VARCHAR2
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
544: , p5_a30 JTF_DATE_TABLE
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
546: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
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
548: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
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
575: , p6_a30 out nocopy JTF_DATE_TABLE
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: );
577: procedure create_mass_rbk_set_values(p_api_version NUMBER
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
579: , x_return_status out nocopy VARCHAR2
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
615: , p7_a0 out nocopy JTF_NUMBER_TABLE
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
617: , p7_a2 out nocopy JTF_NUMBER_TABLE
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
647: );
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;