DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_PVT_W dependencies on JTF_DATE_TABLE

Line 9: , a6 JTF_DATE_TABLE

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_1900
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100

Line 11: , a8 JTF_DATE_TABLE

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_200
15: , a12 JTF_VARCHAR2_TABLE_200

Line 12: , a9 JTF_DATE_TABLE

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_200
15: , a12 JTF_VARCHAR2_TABLE_200
16: , a13 JTF_VARCHAR2_TABLE_200

Line 82: , a6 out nocopy JTF_DATE_TABLE

78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
80: , a4 out nocopy JTF_VARCHAR2_TABLE_100
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_DATE_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
84: , a8 out nocopy JTF_DATE_TABLE
85: , a9 out nocopy JTF_DATE_TABLE
86: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 84: , a8 out nocopy JTF_DATE_TABLE

80: , a4 out nocopy JTF_VARCHAR2_TABLE_100
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_DATE_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
84: , a8 out nocopy JTF_DATE_TABLE
85: , a9 out nocopy JTF_DATE_TABLE
86: , a10 out nocopy JTF_VARCHAR2_TABLE_100
87: , a11 out nocopy JTF_VARCHAR2_TABLE_200
88: , a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 85: , a9 out nocopy JTF_DATE_TABLE

81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_DATE_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
84: , a8 out nocopy JTF_DATE_TABLE
85: , a9 out nocopy JTF_DATE_TABLE
86: , a10 out nocopy JTF_VARCHAR2_TABLE_100
87: , a11 out nocopy JTF_VARCHAR2_TABLE_200
88: , a12 out nocopy JTF_VARCHAR2_TABLE_200
89: , a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 114: a6 := JTF_DATE_TABLE();

110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_VARCHAR2_TABLE_1900();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_DATE_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_DATE_TABLE();
117: a9 := JTF_DATE_TABLE();
118: a10 := JTF_VARCHAR2_TABLE_100();

Line 116: a8 := JTF_DATE_TABLE();

112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_DATE_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_DATE_TABLE();
117: a9 := JTF_DATE_TABLE();
118: a10 := JTF_VARCHAR2_TABLE_100();
119: a11 := JTF_VARCHAR2_TABLE_200();
120: a12 := JTF_VARCHAR2_TABLE_200();

Line 117: a9 := JTF_DATE_TABLE();

113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_DATE_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_DATE_TABLE();
117: a9 := JTF_DATE_TABLE();
118: a10 := JTF_VARCHAR2_TABLE_100();
119: a11 := JTF_VARCHAR2_TABLE_200();
120: a12 := JTF_VARCHAR2_TABLE_200();
121: a13 := JTF_VARCHAR2_TABLE_200();

Line 143: a6 := JTF_DATE_TABLE();

139: a2 := JTF_VARCHAR2_TABLE_100();
140: a3 := JTF_VARCHAR2_TABLE_1900();
141: a4 := JTF_VARCHAR2_TABLE_100();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_DATE_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
145: a8 := JTF_DATE_TABLE();
146: a9 := JTF_DATE_TABLE();
147: a10 := JTF_VARCHAR2_TABLE_100();

Line 145: a8 := JTF_DATE_TABLE();

141: a4 := JTF_VARCHAR2_TABLE_100();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_DATE_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
145: a8 := JTF_DATE_TABLE();
146: a9 := JTF_DATE_TABLE();
147: a10 := JTF_VARCHAR2_TABLE_100();
148: a11 := JTF_VARCHAR2_TABLE_200();
149: a12 := JTF_VARCHAR2_TABLE_200();

Line 146: a9 := JTF_DATE_TABLE();

142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_DATE_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
145: a8 := JTF_DATE_TABLE();
146: a9 := JTF_DATE_TABLE();
147: a10 := JTF_VARCHAR2_TABLE_100();
148: a11 := JTF_VARCHAR2_TABLE_200();
149: a12 := JTF_VARCHAR2_TABLE_200();
150: a13 := JTF_VARCHAR2_TABLE_200();

Line 240: , a5 JTF_DATE_TABLE

236: , a1 JTF_NUMBER_TABLE
237: , a2 JTF_NUMBER_TABLE
238: , a3 JTF_VARCHAR2_TABLE_100
239: , a4 JTF_VARCHAR2_TABLE_200
240: , a5 JTF_DATE_TABLE
241: , a6 JTF_DATE_TABLE
242: , a7 JTF_NUMBER_TABLE
243: ) as
244: ddindx binary_integer; indx binary_integer;

Line 241: , a6 JTF_DATE_TABLE

237: , a2 JTF_NUMBER_TABLE
238: , a3 JTF_VARCHAR2_TABLE_100
239: , a4 JTF_VARCHAR2_TABLE_200
240: , a5 JTF_DATE_TABLE
241: , a6 JTF_DATE_TABLE
242: , a7 JTF_NUMBER_TABLE
243: ) as
244: ddindx binary_integer; indx binary_integer;
245: begin

Line 273: , a5 out nocopy JTF_DATE_TABLE

269: , a1 out nocopy JTF_NUMBER_TABLE
270: , a2 out nocopy JTF_NUMBER_TABLE
271: , a3 out nocopy JTF_VARCHAR2_TABLE_100
272: , a4 out nocopy JTF_VARCHAR2_TABLE_200
273: , a5 out nocopy JTF_DATE_TABLE
274: , a6 out nocopy JTF_DATE_TABLE
275: , a7 out nocopy JTF_NUMBER_TABLE
276: ) as
277: ddindx binary_integer; indx binary_integer;

Line 274: , a6 out nocopy JTF_DATE_TABLE

270: , a2 out nocopy JTF_NUMBER_TABLE
271: , a3 out nocopy JTF_VARCHAR2_TABLE_100
272: , a4 out nocopy JTF_VARCHAR2_TABLE_200
273: , a5 out nocopy JTF_DATE_TABLE
274: , a6 out nocopy JTF_DATE_TABLE
275: , a7 out nocopy JTF_NUMBER_TABLE
276: ) as
277: ddindx binary_integer; indx binary_integer;
278: begin

Line 285: a5 := JTF_DATE_TABLE();

281: a1 := JTF_NUMBER_TABLE();
282: a2 := JTF_NUMBER_TABLE();
283: a3 := JTF_VARCHAR2_TABLE_100();
284: a4 := JTF_VARCHAR2_TABLE_200();
285: a5 := JTF_DATE_TABLE();
286: a6 := JTF_DATE_TABLE();
287: a7 := JTF_NUMBER_TABLE();
288: else
289: a0 := JTF_NUMBER_TABLE();

Line 286: a6 := JTF_DATE_TABLE();

282: a2 := JTF_NUMBER_TABLE();
283: a3 := JTF_VARCHAR2_TABLE_100();
284: a4 := JTF_VARCHAR2_TABLE_200();
285: a5 := JTF_DATE_TABLE();
286: a6 := JTF_DATE_TABLE();
287: a7 := JTF_NUMBER_TABLE();
288: else
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();

Line 294: a5 := JTF_DATE_TABLE();

290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_NUMBER_TABLE();
292: a3 := JTF_VARCHAR2_TABLE_100();
293: a4 := JTF_VARCHAR2_TABLE_200();
294: a5 := JTF_DATE_TABLE();
295: a6 := JTF_DATE_TABLE();
296: a7 := JTF_NUMBER_TABLE();
297: if t.count > 0 then
298: a0.extend(t.count);

Line 295: a6 := JTF_DATE_TABLE();

291: a2 := JTF_NUMBER_TABLE();
292: a3 := JTF_VARCHAR2_TABLE_100();
293: a4 := JTF_VARCHAR2_TABLE_200();
294: a5 := JTF_DATE_TABLE();
295: a6 := JTF_DATE_TABLE();
296: a7 := JTF_NUMBER_TABLE();
297: if t.count > 0 then
298: a0.extend(t.count);
299: a1.extend(t.count);

Line 333: , a6 JTF_DATE_TABLE

329: , a2 JTF_NUMBER_TABLE
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_400
332: , a5 JTF_VARCHAR2_TABLE_100
333: , a6 JTF_DATE_TABLE
334: , a7 JTF_DATE_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;
337: begin

Line 334: , a7 JTF_DATE_TABLE

330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_400
332: , a5 JTF_VARCHAR2_TABLE_100
333: , a6 JTF_DATE_TABLE
334: , a7 JTF_DATE_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if a0 is not null and a0.count > 0 then

Line 366: , a6 out nocopy JTF_DATE_TABLE

362: , a2 out nocopy JTF_NUMBER_TABLE
363: , a3 out nocopy JTF_VARCHAR2_TABLE_100
364: , a4 out nocopy JTF_VARCHAR2_TABLE_400
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_DATE_TABLE
367: , a7 out nocopy JTF_DATE_TABLE
368: ) as
369: ddindx binary_integer; indx binary_integer;
370: begin

Line 367: , a7 out nocopy JTF_DATE_TABLE

363: , a3 out nocopy JTF_VARCHAR2_TABLE_100
364: , a4 out nocopy JTF_VARCHAR2_TABLE_400
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_DATE_TABLE
367: , a7 out nocopy JTF_DATE_TABLE
368: ) as
369: ddindx binary_integer; indx binary_integer;
370: begin
371: if t is null or t.count = 0 then

Line 378: a6 := JTF_DATE_TABLE();

374: a2 := JTF_NUMBER_TABLE();
375: a3 := JTF_VARCHAR2_TABLE_100();
376: a4 := JTF_VARCHAR2_TABLE_400();
377: a5 := JTF_VARCHAR2_TABLE_100();
378: a6 := JTF_DATE_TABLE();
379: a7 := JTF_DATE_TABLE();
380: else
381: a0 := JTF_NUMBER_TABLE();
382: a1 := JTF_NUMBER_TABLE();

Line 379: a7 := JTF_DATE_TABLE();

375: a3 := JTF_VARCHAR2_TABLE_100();
376: a4 := JTF_VARCHAR2_TABLE_400();
377: a5 := JTF_VARCHAR2_TABLE_100();
378: a6 := JTF_DATE_TABLE();
379: a7 := JTF_DATE_TABLE();
380: else
381: a0 := JTF_NUMBER_TABLE();
382: a1 := JTF_NUMBER_TABLE();
383: a2 := JTF_NUMBER_TABLE();

Line 387: a6 := JTF_DATE_TABLE();

383: a2 := JTF_NUMBER_TABLE();
384: a3 := JTF_VARCHAR2_TABLE_100();
385: a4 := JTF_VARCHAR2_TABLE_400();
386: a5 := JTF_VARCHAR2_TABLE_100();
387: a6 := JTF_DATE_TABLE();
388: a7 := JTF_DATE_TABLE();
389: if t.count > 0 then
390: a0.extend(t.count);
391: a1.extend(t.count);

Line 388: a7 := JTF_DATE_TABLE();

384: a3 := JTF_VARCHAR2_TABLE_100();
385: a4 := JTF_VARCHAR2_TABLE_400();
386: a5 := JTF_VARCHAR2_TABLE_100();
387: a6 := JTF_DATE_TABLE();
388: a7 := JTF_DATE_TABLE();
389: if t.count > 0 then
390: a0.extend(t.count);
391: a1.extend(t.count);
392: a2.extend(t.count);

Line 819: , p9_a6 out nocopy JTF_DATE_TABLE

815: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
816: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
817: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
818: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
819: , p9_a6 out nocopy JTF_DATE_TABLE
820: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
821: , p9_a8 out nocopy JTF_DATE_TABLE
822: , p9_a9 out nocopy JTF_DATE_TABLE
823: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 821: , p9_a8 out nocopy JTF_DATE_TABLE

817: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
818: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
819: , p9_a6 out nocopy JTF_DATE_TABLE
820: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
821: , p9_a8 out nocopy JTF_DATE_TABLE
822: , p9_a9 out nocopy JTF_DATE_TABLE
823: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
824: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_200
825: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 822: , p9_a9 out nocopy JTF_DATE_TABLE

818: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
819: , p9_a6 out nocopy JTF_DATE_TABLE
820: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
821: , p9_a8 out nocopy JTF_DATE_TABLE
822: , p9_a9 out nocopy JTF_DATE_TABLE
823: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
824: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_200
825: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_200
826: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 939: , p5_a6 out nocopy JTF_DATE_TABLE

935: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
936: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
937: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
938: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
939: , p5_a6 out nocopy JTF_DATE_TABLE
940: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
941: , p5_a8 out nocopy JTF_DATE_TABLE
942: , p5_a9 out nocopy JTF_DATE_TABLE
943: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 941: , p5_a8 out nocopy JTF_DATE_TABLE

937: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
938: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
939: , p5_a6 out nocopy JTF_DATE_TABLE
940: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
941: , p5_a8 out nocopy JTF_DATE_TABLE
942: , p5_a9 out nocopy JTF_DATE_TABLE
943: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
944: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_200
945: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 942: , p5_a9 out nocopy JTF_DATE_TABLE

938: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
939: , p5_a6 out nocopy JTF_DATE_TABLE
940: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
941: , p5_a8 out nocopy JTF_DATE_TABLE
942: , p5_a9 out nocopy JTF_DATE_TABLE
943: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
944: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_200
945: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_200
946: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 1042: , p5_a5 out nocopy JTF_DATE_TABLE

1038: , p5_a1 out nocopy JTF_NUMBER_TABLE
1039: , p5_a2 out nocopy JTF_NUMBER_TABLE
1040: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1041: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
1042: , p5_a5 out nocopy JTF_DATE_TABLE
1043: , p5_a6 out nocopy JTF_DATE_TABLE
1044: , p5_a7 out nocopy JTF_NUMBER_TABLE
1045: , x_return_status out nocopy VARCHAR2
1046: , x_msg_count out nocopy NUMBER

Line 1043: , p5_a6 out nocopy JTF_DATE_TABLE

1039: , p5_a2 out nocopy JTF_NUMBER_TABLE
1040: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1041: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
1042: , p5_a5 out nocopy JTF_DATE_TABLE
1043: , p5_a6 out nocopy JTF_DATE_TABLE
1044: , p5_a7 out nocopy JTF_NUMBER_TABLE
1045: , x_return_status out nocopy VARCHAR2
1046: , x_msg_count out nocopy NUMBER
1047: , x_msg_data out nocopy VARCHAR2

Line 1205: , p4_a6 out nocopy JTF_DATE_TABLE

1201: , p4_a2 out nocopy JTF_NUMBER_TABLE
1202: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1203: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
1204: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1205: , p4_a6 out nocopy JTF_DATE_TABLE
1206: , p4_a7 out nocopy JTF_DATE_TABLE
1207: )
1208:
1209: as

Line 1206: , p4_a7 out nocopy JTF_DATE_TABLE

1202: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1203: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
1204: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1205: , p4_a6 out nocopy JTF_DATE_TABLE
1206: , p4_a7 out nocopy JTF_DATE_TABLE
1207: )
1208:
1209: as
1210: ddx_result_tbl cn_comp_plan_pvt.srp_plan_assign_tbl_type;