DBA Data[Home] [Help]

APPS.OKL_MASS_REBOOK_PVT_W dependencies on JTF_DATE_TABLE

Line 132: , p6_a28 JTF_DATE_TABLE

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

Line 134: , p6_a30 JTF_DATE_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

Line 162: , p7_a26 out nocopy JTF_DATE_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

Line 164: , p7_a28 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: );

Line 166: , p7_a30 out nocopy JTF_DATE_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
170: , p_init_msg_list VARCHAR2

Line 204: , p7_a28 JTF_DATE_TABLE

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

Line 206: , p7_a30 JTF_DATE_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

Line 234: , p8_a26 out nocopy JTF_DATE_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

Line 236: , p8_a28 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: );

Line 238: , p8_a30 out nocopy JTF_DATE_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
242: , p_init_msg_list VARCHAR2

Line 540: , p5_a26 JTF_DATE_TABLE

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

Line 542: , p5_a28 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

Line 544: , p5_a30 JTF_DATE_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
548: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 571: , p6_a26 out nocopy JTF_DATE_TABLE

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

Line 573: , p6_a28 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

Line 575: , p6_a30 out nocopy JTF_DATE_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
579: , x_return_status out nocopy VARCHAR2

Line 611: , p6_a28 JTF_DATE_TABLE

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

Line 613: , p6_a30 JTF_DATE_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

Line 643: , p7_a28 out nocopy JTF_DATE_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: );

Line 645: , p7_a30 out nocopy JTF_DATE_TABLE

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;