DBA Data[Home] [Help]

APPS.OZF_PRICELIST_PVT_W dependencies on JTF_DATE_TABLE

Line 24: , a2 JTF_DATE_TABLE

20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ozf_pricelist_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100

Line 36: , a14 JTF_DATE_TABLE

32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_300
40: , a18 JTF_VARCHAR2_TABLE_300

Line 105: , a2 out nocopy JTF_DATE_TABLE

101: end if;
102: end rosetta_table_copy_in_p3;
103: procedure rosetta_table_copy_out_p3(t ozf_pricelist_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , a14 out nocopy JTF_DATE_TABLE

113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_NUMBER_TABLE
116: , a13 out nocopy JTF_NUMBER_TABLE
117: , a14 out nocopy JTF_DATE_TABLE
118: , a15 out nocopy JTF_VARCHAR2_TABLE_100
119: , a16 out nocopy JTF_VARCHAR2_TABLE_100
120: , a17 out nocopy JTF_VARCHAR2_TABLE_300
121: , a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 141: a2 := JTF_DATE_TABLE();

137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_VARCHAR2_TABLE_100();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_DATE_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_VARCHAR2_TABLE_100();

Line 153: a14 := JTF_DATE_TABLE();

149: a10 := JTF_VARCHAR2_TABLE_100();
150: a11 := JTF_NUMBER_TABLE();
151: a12 := JTF_NUMBER_TABLE();
152: a13 := JTF_NUMBER_TABLE();
153: a14 := JTF_DATE_TABLE();
154: a15 := JTF_VARCHAR2_TABLE_100();
155: a16 := JTF_VARCHAR2_TABLE_100();
156: a17 := JTF_VARCHAR2_TABLE_300();
157: a18 := JTF_VARCHAR2_TABLE_300();

Line 174: a2 := JTF_DATE_TABLE();

170: a31 := JTF_VARCHAR2_TABLE_300();
171: else
172: a0 := JTF_VARCHAR2_TABLE_100();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_DATE_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_VARCHAR2_TABLE_100();

Line 186: a14 := JTF_DATE_TABLE();

182: a10 := JTF_VARCHAR2_TABLE_100();
183: a11 := JTF_NUMBER_TABLE();
184: a12 := JTF_NUMBER_TABLE();
185: a13 := JTF_NUMBER_TABLE();
186: a14 := JTF_DATE_TABLE();
187: a15 := JTF_VARCHAR2_TABLE_100();
188: a16 := JTF_VARCHAR2_TABLE_100();
189: a17 := JTF_VARCHAR2_TABLE_300();
190: a18 := JTF_VARCHAR2_TABLE_300();

Line 283: , a1 JTF_DATE_TABLE

279: end if;
280: end rosetta_table_copy_out_p3;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy ozf_pricelist_pvt.price_list_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
283: , a1 JTF_DATE_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_NUMBER_TABLE

Line 288: , a6 JTF_DATE_TABLE

284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_VARCHAR2_TABLE_100
290: , a8 JTF_VARCHAR2_TABLE_100
291: , a9 JTF_NUMBER_TABLE
292: , a10 JTF_NUMBER_TABLE

Line 362: , a1 out nocopy JTF_DATE_TABLE

358: end if;
359: end if;
360: end rosetta_table_copy_in_p5;
361: procedure rosetta_table_copy_out_p5(t ozf_pricelist_pvt.price_list_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
362: , a1 out nocopy JTF_DATE_TABLE
363: , a2 out nocopy JTF_NUMBER_TABLE
364: , a3 out nocopy JTF_NUMBER_TABLE
365: , a4 out nocopy JTF_NUMBER_TABLE
366: , a5 out nocopy JTF_NUMBER_TABLE

Line 367: , a6 out nocopy JTF_DATE_TABLE

363: , a2 out nocopy JTF_NUMBER_TABLE
364: , a3 out nocopy JTF_NUMBER_TABLE
365: , a4 out nocopy JTF_NUMBER_TABLE
366: , a5 out nocopy JTF_NUMBER_TABLE
367: , a6 out nocopy JTF_DATE_TABLE
368: , a7 out nocopy JTF_VARCHAR2_TABLE_100
369: , a8 out nocopy JTF_VARCHAR2_TABLE_100
370: , a9 out nocopy JTF_NUMBER_TABLE
371: , a10 out nocopy JTF_NUMBER_TABLE

Line 397: a1 := JTF_DATE_TABLE();

393: ddindx binary_integer; indx binary_integer;
394: begin
395: if t is null or t.count = 0 then
396: a0 := JTF_VARCHAR2_TABLE_100();
397: a1 := JTF_DATE_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();

Line 402: a6 := JTF_DATE_TABLE();

398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_DATE_TABLE();
403: a7 := JTF_VARCHAR2_TABLE_100();
404: a8 := JTF_VARCHAR2_TABLE_100();
405: a9 := JTF_NUMBER_TABLE();
406: a10 := JTF_NUMBER_TABLE();

Line 429: a1 := JTF_DATE_TABLE();

425: a29 := JTF_VARCHAR2_TABLE_300();
426: a30 := JTF_VARCHAR2_TABLE_300();
427: else
428: a0 := JTF_VARCHAR2_TABLE_100();
429: a1 := JTF_DATE_TABLE();
430: a2 := JTF_NUMBER_TABLE();
431: a3 := JTF_NUMBER_TABLE();
432: a4 := JTF_NUMBER_TABLE();
433: a5 := JTF_NUMBER_TABLE();

Line 434: a6 := JTF_DATE_TABLE();

430: a2 := JTF_NUMBER_TABLE();
431: a3 := JTF_NUMBER_TABLE();
432: a4 := JTF_NUMBER_TABLE();
433: a5 := JTF_NUMBER_TABLE();
434: a6 := JTF_DATE_TABLE();
435: a7 := JTF_VARCHAR2_TABLE_100();
436: a8 := JTF_VARCHAR2_TABLE_100();
437: a9 := JTF_NUMBER_TABLE();
438: a10 := JTF_NUMBER_TABLE();

Line 718: , p8_a1 JTF_DATE_TABLE

714: , x_return_status out nocopy VARCHAR2
715: , x_msg_count out nocopy NUMBER
716: , x_msg_data out nocopy VARCHAR2
717: , p8_a0 JTF_VARCHAR2_TABLE_100
718: , p8_a1 JTF_DATE_TABLE
719: , p8_a2 JTF_NUMBER_TABLE
720: , p8_a3 JTF_NUMBER_TABLE
721: , p8_a4 JTF_NUMBER_TABLE
722: , p8_a5 JTF_NUMBER_TABLE

Line 723: , p8_a6 JTF_DATE_TABLE

719: , p8_a2 JTF_NUMBER_TABLE
720: , p8_a3 JTF_NUMBER_TABLE
721: , p8_a4 JTF_NUMBER_TABLE
722: , p8_a5 JTF_NUMBER_TABLE
723: , p8_a6 JTF_DATE_TABLE
724: , p8_a7 JTF_VARCHAR2_TABLE_100
725: , p8_a8 JTF_VARCHAR2_TABLE_100
726: , p8_a9 JTF_NUMBER_TABLE
727: , p8_a10 JTF_NUMBER_TABLE

Line 764: , p10_a2 JTF_DATE_TABLE

760: , p9_a12 JTF_VARCHAR2_TABLE_100
761: , p9_a13 JTF_NUMBER_TABLE
762: , p10_a0 JTF_VARCHAR2_TABLE_100
763: , p10_a1 JTF_NUMBER_TABLE
764: , p10_a2 JTF_DATE_TABLE
765: , p10_a3 JTF_VARCHAR2_TABLE_100
766: , p10_a4 JTF_NUMBER_TABLE
767: , p10_a5 JTF_NUMBER_TABLE
768: , p10_a6 JTF_VARCHAR2_TABLE_100

Line 776: , p10_a14 JTF_DATE_TABLE

772: , p10_a10 JTF_VARCHAR2_TABLE_100
773: , p10_a11 JTF_NUMBER_TABLE
774: , p10_a12 JTF_NUMBER_TABLE
775: , p10_a13 JTF_NUMBER_TABLE
776: , p10_a14 JTF_DATE_TABLE
777: , p10_a15 JTF_VARCHAR2_TABLE_100
778: , p10_a16 JTF_VARCHAR2_TABLE_100
779: , p10_a17 JTF_VARCHAR2_TABLE_300
780: , p10_a18 JTF_VARCHAR2_TABLE_300