DBA Data[Home] [Help]

APPS.AHL_UMP_UF_PVT_W dependencies on JTF_DATE_TABLE

Line 19: , a3 JTF_DATE_TABLE

15:
16: procedure rosetta_table_copy_in_p16(t out nocopy ahl_ump_uf_pvt.uf_details_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE

Line 21: , a5 JTF_DATE_TABLE

17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_DATE_TABLE

Line 25: , a9 JTF_DATE_TABLE

21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_DATE_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100

Line 26: , a10 JTF_DATE_TABLE

22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_DATE_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_200

Line 94: , a3 out nocopy JTF_DATE_TABLE

90: end rosetta_table_copy_in_p16;
91: procedure rosetta_table_copy_out_p16(t ahl_ump_uf_pvt.uf_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_DATE_TABLE
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_DATE_TABLE
97: , a6 out nocopy JTF_NUMBER_TABLE
98: , a7 out nocopy JTF_NUMBER_TABLE

Line 96: , a5 out nocopy JTF_DATE_TABLE

92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_DATE_TABLE
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_DATE_TABLE
97: , a6 out nocopy JTF_NUMBER_TABLE
98: , a7 out nocopy JTF_NUMBER_TABLE
99: , a8 out nocopy JTF_VARCHAR2_TABLE_100
100: , a9 out nocopy JTF_DATE_TABLE

Line 100: , a9 out nocopy JTF_DATE_TABLE

96: , a5 out nocopy JTF_DATE_TABLE
97: , a6 out nocopy JTF_NUMBER_TABLE
98: , a7 out nocopy JTF_NUMBER_TABLE
99: , a8 out nocopy JTF_VARCHAR2_TABLE_100
100: , a9 out nocopy JTF_DATE_TABLE
101: , a10 out nocopy JTF_DATE_TABLE
102: , a11 out nocopy JTF_NUMBER_TABLE
103: , a12 out nocopy JTF_VARCHAR2_TABLE_100
104: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 101: , a10 out nocopy JTF_DATE_TABLE

97: , a6 out nocopy JTF_NUMBER_TABLE
98: , a7 out nocopy JTF_NUMBER_TABLE
99: , a8 out nocopy JTF_VARCHAR2_TABLE_100
100: , a9 out nocopy JTF_DATE_TABLE
101: , a10 out nocopy JTF_DATE_TABLE
102: , a11 out nocopy JTF_NUMBER_TABLE
103: , a12 out nocopy JTF_VARCHAR2_TABLE_100
104: , a13 out nocopy JTF_VARCHAR2_TABLE_100
105: , a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 127: a3 := JTF_DATE_TABLE();

123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_DATE_TABLE();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_DATE_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_NUMBER_TABLE();

Line 129: a5 := JTF_DATE_TABLE();

125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_DATE_TABLE();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_DATE_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_NUMBER_TABLE();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_DATE_TABLE();

Line 133: a9 := JTF_DATE_TABLE();

129: a5 := JTF_DATE_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_NUMBER_TABLE();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_DATE_TABLE();
134: a10 := JTF_DATE_TABLE();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_100();

Line 134: a10 := JTF_DATE_TABLE();

130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_NUMBER_TABLE();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_DATE_TABLE();
134: a10 := JTF_DATE_TABLE();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_100();
138: a14 := JTF_VARCHAR2_TABLE_200();

Line 157: a3 := JTF_DATE_TABLE();

153: else
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_DATE_TABLE();
158: a4 := JTF_NUMBER_TABLE();
159: a5 := JTF_DATE_TABLE();
160: a6 := JTF_NUMBER_TABLE();
161: a7 := JTF_NUMBER_TABLE();

Line 159: a5 := JTF_DATE_TABLE();

155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_DATE_TABLE();
158: a4 := JTF_NUMBER_TABLE();
159: a5 := JTF_DATE_TABLE();
160: a6 := JTF_NUMBER_TABLE();
161: a7 := JTF_NUMBER_TABLE();
162: a8 := JTF_VARCHAR2_TABLE_100();
163: a9 := JTF_DATE_TABLE();

Line 163: a9 := JTF_DATE_TABLE();

159: a5 := JTF_DATE_TABLE();
160: a6 := JTF_NUMBER_TABLE();
161: a7 := JTF_NUMBER_TABLE();
162: a8 := JTF_VARCHAR2_TABLE_100();
163: a9 := JTF_DATE_TABLE();
164: a10 := JTF_DATE_TABLE();
165: a11 := JTF_NUMBER_TABLE();
166: a12 := JTF_VARCHAR2_TABLE_100();
167: a13 := JTF_VARCHAR2_TABLE_100();

Line 164: a10 := JTF_DATE_TABLE();

160: a6 := JTF_NUMBER_TABLE();
161: a7 := JTF_NUMBER_TABLE();
162: a8 := JTF_VARCHAR2_TABLE_100();
163: a9 := JTF_DATE_TABLE();
164: a10 := JTF_DATE_TABLE();
165: a11 := JTF_NUMBER_TABLE();
166: a12 := JTF_VARCHAR2_TABLE_100();
167: a13 := JTF_VARCHAR2_TABLE_100();
168: a14 := JTF_VARCHAR2_TABLE_200();

Line 297: , p6_a3 in out nocopy JTF_DATE_TABLE

293: , p5_a33 in out nocopy VARCHAR2
294: , p6_a0 in out nocopy JTF_NUMBER_TABLE
295: , p6_a1 in out nocopy JTF_NUMBER_TABLE
296: , p6_a2 in out nocopy JTF_NUMBER_TABLE
297: , p6_a3 in out nocopy JTF_DATE_TABLE
298: , p6_a4 in out nocopy JTF_NUMBER_TABLE
299: , p6_a5 in out nocopy JTF_DATE_TABLE
300: , p6_a6 in out nocopy JTF_NUMBER_TABLE
301: , p6_a7 in out nocopy JTF_NUMBER_TABLE

Line 299: , p6_a5 in out nocopy JTF_DATE_TABLE

295: , p6_a1 in out nocopy JTF_NUMBER_TABLE
296: , p6_a2 in out nocopy JTF_NUMBER_TABLE
297: , p6_a3 in out nocopy JTF_DATE_TABLE
298: , p6_a4 in out nocopy JTF_NUMBER_TABLE
299: , p6_a5 in out nocopy JTF_DATE_TABLE
300: , p6_a6 in out nocopy JTF_NUMBER_TABLE
301: , p6_a7 in out nocopy JTF_NUMBER_TABLE
302: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a9 in out nocopy JTF_DATE_TABLE

Line 303: , p6_a9 in out nocopy JTF_DATE_TABLE

299: , p6_a5 in out nocopy JTF_DATE_TABLE
300: , p6_a6 in out nocopy JTF_NUMBER_TABLE
301: , p6_a7 in out nocopy JTF_NUMBER_TABLE
302: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a9 in out nocopy JTF_DATE_TABLE
304: , p6_a10 in out nocopy JTF_DATE_TABLE
305: , p6_a11 in out nocopy JTF_NUMBER_TABLE
306: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100
307: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 304: , p6_a10 in out nocopy JTF_DATE_TABLE

300: , p6_a6 in out nocopy JTF_NUMBER_TABLE
301: , p6_a7 in out nocopy JTF_NUMBER_TABLE
302: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a9 in out nocopy JTF_DATE_TABLE
304: , p6_a10 in out nocopy JTF_DATE_TABLE
305: , p6_a11 in out nocopy JTF_NUMBER_TABLE
306: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100
307: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200

Line 509: , p9_a3 out nocopy JTF_DATE_TABLE

505: , p_add_unit_item_forecast VARCHAR2
506: , p9_a0 out nocopy JTF_NUMBER_TABLE
507: , p9_a1 out nocopy JTF_NUMBER_TABLE
508: , p9_a2 out nocopy JTF_NUMBER_TABLE
509: , p9_a3 out nocopy JTF_DATE_TABLE
510: , p9_a4 out nocopy JTF_NUMBER_TABLE
511: , p9_a5 out nocopy JTF_DATE_TABLE
512: , p9_a6 out nocopy JTF_NUMBER_TABLE
513: , p9_a7 out nocopy JTF_NUMBER_TABLE

Line 511: , p9_a5 out nocopy JTF_DATE_TABLE

507: , p9_a1 out nocopy JTF_NUMBER_TABLE
508: , p9_a2 out nocopy JTF_NUMBER_TABLE
509: , p9_a3 out nocopy JTF_DATE_TABLE
510: , p9_a4 out nocopy JTF_NUMBER_TABLE
511: , p9_a5 out nocopy JTF_DATE_TABLE
512: , p9_a6 out nocopy JTF_NUMBER_TABLE
513: , p9_a7 out nocopy JTF_NUMBER_TABLE
514: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
515: , p9_a9 out nocopy JTF_DATE_TABLE

Line 515: , p9_a9 out nocopy JTF_DATE_TABLE

511: , p9_a5 out nocopy JTF_DATE_TABLE
512: , p9_a6 out nocopy JTF_NUMBER_TABLE
513: , p9_a7 out nocopy JTF_NUMBER_TABLE
514: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
515: , p9_a9 out nocopy JTF_DATE_TABLE
516: , p9_a10 out nocopy JTF_DATE_TABLE
517: , p9_a11 out nocopy JTF_NUMBER_TABLE
518: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
519: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 516: , p9_a10 out nocopy JTF_DATE_TABLE

512: , p9_a6 out nocopy JTF_NUMBER_TABLE
513: , p9_a7 out nocopy JTF_NUMBER_TABLE
514: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
515: , p9_a9 out nocopy JTF_DATE_TABLE
516: , p9_a10 out nocopy JTF_DATE_TABLE
517: , p9_a11 out nocopy JTF_NUMBER_TABLE
518: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
519: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
520: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 619: , p3_a3 out nocopy JTF_DATE_TABLE

615: , p_onward_end_date date
616: , p3_a0 out nocopy JTF_NUMBER_TABLE
617: , p3_a1 out nocopy JTF_NUMBER_TABLE
618: , p3_a2 out nocopy JTF_NUMBER_TABLE
619: , p3_a3 out nocopy JTF_DATE_TABLE
620: , p3_a4 out nocopy JTF_NUMBER_TABLE
621: , p3_a5 out nocopy JTF_DATE_TABLE
622: , p3_a6 out nocopy JTF_NUMBER_TABLE
623: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 621: , p3_a5 out nocopy JTF_DATE_TABLE

617: , p3_a1 out nocopy JTF_NUMBER_TABLE
618: , p3_a2 out nocopy JTF_NUMBER_TABLE
619: , p3_a3 out nocopy JTF_DATE_TABLE
620: , p3_a4 out nocopy JTF_NUMBER_TABLE
621: , p3_a5 out nocopy JTF_DATE_TABLE
622: , p3_a6 out nocopy JTF_NUMBER_TABLE
623: , p3_a7 out nocopy JTF_NUMBER_TABLE
624: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
625: , p3_a9 out nocopy JTF_DATE_TABLE

Line 625: , p3_a9 out nocopy JTF_DATE_TABLE

621: , p3_a5 out nocopy JTF_DATE_TABLE
622: , p3_a6 out nocopy JTF_NUMBER_TABLE
623: , p3_a7 out nocopy JTF_NUMBER_TABLE
624: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
625: , p3_a9 out nocopy JTF_DATE_TABLE
626: , p3_a10 out nocopy JTF_DATE_TABLE
627: , p3_a11 out nocopy JTF_NUMBER_TABLE
628: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
629: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 626: , p3_a10 out nocopy JTF_DATE_TABLE

622: , p3_a6 out nocopy JTF_NUMBER_TABLE
623: , p3_a7 out nocopy JTF_NUMBER_TABLE
624: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
625: , p3_a9 out nocopy JTF_DATE_TABLE
626: , p3_a10 out nocopy JTF_DATE_TABLE
627: , p3_a11 out nocopy JTF_NUMBER_TABLE
628: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
629: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
630: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_200