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_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE

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_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_200
16: , a13 JTF_VARCHAR2_TABLE_200

Line 13: , a10 JTF_DATE_TABLE

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

Line 84: , a6 out nocopy JTF_DATE_TABLE

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

Line 87: , a9 out nocopy JTF_DATE_TABLE

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

Line 88: , a10 out nocopy JTF_DATE_TABLE

84: , a6 out nocopy JTF_DATE_TABLE
85: , a7 out nocopy JTF_VARCHAR2_TABLE_100
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
87: , a9 out nocopy JTF_DATE_TABLE
88: , a10 out nocopy JTF_DATE_TABLE
89: , a11 out nocopy JTF_VARCHAR2_TABLE_100
90: , a12 out nocopy JTF_VARCHAR2_TABLE_200
91: , a13 out nocopy JTF_VARCHAR2_TABLE_200
92: , a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 117: a6 := JTF_DATE_TABLE();

113: a2 := JTF_VARCHAR2_TABLE_100();
114: a3 := JTF_VARCHAR2_TABLE_1900();
115: a4 := JTF_VARCHAR2_TABLE_100();
116: a5 := JTF_VARCHAR2_TABLE_100();
117: a6 := JTF_DATE_TABLE();
118: a7 := JTF_VARCHAR2_TABLE_100();
119: a8 := JTF_VARCHAR2_TABLE_100();
120: a9 := JTF_DATE_TABLE();
121: a10 := JTF_DATE_TABLE();

Line 120: a9 := JTF_DATE_TABLE();

116: a5 := JTF_VARCHAR2_TABLE_100();
117: a6 := JTF_DATE_TABLE();
118: a7 := JTF_VARCHAR2_TABLE_100();
119: a8 := JTF_VARCHAR2_TABLE_100();
120: a9 := JTF_DATE_TABLE();
121: a10 := JTF_DATE_TABLE();
122: a11 := JTF_VARCHAR2_TABLE_100();
123: a12 := JTF_VARCHAR2_TABLE_200();
124: a13 := JTF_VARCHAR2_TABLE_200();

Line 121: a10 := JTF_DATE_TABLE();

117: a6 := JTF_DATE_TABLE();
118: a7 := JTF_VARCHAR2_TABLE_100();
119: a8 := JTF_VARCHAR2_TABLE_100();
120: a9 := JTF_DATE_TABLE();
121: a10 := JTF_DATE_TABLE();
122: a11 := JTF_VARCHAR2_TABLE_100();
123: a12 := JTF_VARCHAR2_TABLE_200();
124: a13 := JTF_VARCHAR2_TABLE_200();
125: a14 := JTF_VARCHAR2_TABLE_200();

Line 147: a6 := JTF_DATE_TABLE();

143: a2 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_VARCHAR2_TABLE_1900();
145: a4 := JTF_VARCHAR2_TABLE_100();
146: a5 := JTF_VARCHAR2_TABLE_100();
147: a6 := JTF_DATE_TABLE();
148: a7 := JTF_VARCHAR2_TABLE_100();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_DATE_TABLE();
151: a10 := JTF_DATE_TABLE();

Line 150: a9 := JTF_DATE_TABLE();

146: a5 := JTF_VARCHAR2_TABLE_100();
147: a6 := JTF_DATE_TABLE();
148: a7 := JTF_VARCHAR2_TABLE_100();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_DATE_TABLE();
151: a10 := JTF_DATE_TABLE();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_VARCHAR2_TABLE_200();
154: a13 := JTF_VARCHAR2_TABLE_200();

Line 151: a10 := JTF_DATE_TABLE();

147: a6 := JTF_DATE_TABLE();
148: a7 := JTF_VARCHAR2_TABLE_100();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_DATE_TABLE();
151: a10 := JTF_DATE_TABLE();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_VARCHAR2_TABLE_200();
154: a13 := JTF_VARCHAR2_TABLE_200();
155: a14 := JTF_VARCHAR2_TABLE_200();

Line 247: , a5 JTF_DATE_TABLE

243: , a1 JTF_NUMBER_TABLE
244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_200
247: , a5 JTF_DATE_TABLE
248: , a6 JTF_DATE_TABLE
249: , a7 JTF_NUMBER_TABLE
250: ) as
251: ddindx binary_integer; indx binary_integer;

Line 248: , a6 JTF_DATE_TABLE

244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_200
247: , a5 JTF_DATE_TABLE
248: , a6 JTF_DATE_TABLE
249: , a7 JTF_NUMBER_TABLE
250: ) as
251: ddindx binary_integer; indx binary_integer;
252: begin

Line 280: , a5 out nocopy JTF_DATE_TABLE

276: , a1 out nocopy JTF_NUMBER_TABLE
277: , a2 out nocopy JTF_NUMBER_TABLE
278: , a3 out nocopy JTF_VARCHAR2_TABLE_100
279: , a4 out nocopy JTF_VARCHAR2_TABLE_200
280: , a5 out nocopy JTF_DATE_TABLE
281: , a6 out nocopy JTF_DATE_TABLE
282: , a7 out nocopy JTF_NUMBER_TABLE
283: ) as
284: ddindx binary_integer; indx binary_integer;

Line 281: , a6 out nocopy JTF_DATE_TABLE

277: , a2 out nocopy JTF_NUMBER_TABLE
278: , a3 out nocopy JTF_VARCHAR2_TABLE_100
279: , a4 out nocopy JTF_VARCHAR2_TABLE_200
280: , a5 out nocopy JTF_DATE_TABLE
281: , a6 out nocopy JTF_DATE_TABLE
282: , a7 out nocopy JTF_NUMBER_TABLE
283: ) as
284: ddindx binary_integer; indx binary_integer;
285: begin

Line 292: a5 := JTF_DATE_TABLE();

288: a1 := JTF_NUMBER_TABLE();
289: a2 := JTF_NUMBER_TABLE();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();
292: a5 := JTF_DATE_TABLE();
293: a6 := JTF_DATE_TABLE();
294: a7 := JTF_NUMBER_TABLE();
295: else
296: a0 := JTF_NUMBER_TABLE();

Line 293: a6 := JTF_DATE_TABLE();

289: a2 := JTF_NUMBER_TABLE();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();
292: a5 := JTF_DATE_TABLE();
293: a6 := JTF_DATE_TABLE();
294: a7 := JTF_NUMBER_TABLE();
295: else
296: a0 := JTF_NUMBER_TABLE();
297: a1 := JTF_NUMBER_TABLE();

Line 301: a5 := JTF_DATE_TABLE();

297: a1 := JTF_NUMBER_TABLE();
298: a2 := JTF_NUMBER_TABLE();
299: a3 := JTF_VARCHAR2_TABLE_100();
300: a4 := JTF_VARCHAR2_TABLE_200();
301: a5 := JTF_DATE_TABLE();
302: a6 := JTF_DATE_TABLE();
303: a7 := JTF_NUMBER_TABLE();
304: if t.count > 0 then
305: a0.extend(t.count);

Line 302: a6 := JTF_DATE_TABLE();

298: a2 := JTF_NUMBER_TABLE();
299: a3 := JTF_VARCHAR2_TABLE_100();
300: a4 := JTF_VARCHAR2_TABLE_200();
301: a5 := JTF_DATE_TABLE();
302: a6 := JTF_DATE_TABLE();
303: a7 := JTF_NUMBER_TABLE();
304: if t.count > 0 then
305: a0.extend(t.count);
306: a1.extend(t.count);

Line 340: , a6 JTF_DATE_TABLE

336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_VARCHAR2_TABLE_400
339: , a5 JTF_VARCHAR2_TABLE_100
340: , a6 JTF_DATE_TABLE
341: , a7 JTF_DATE_TABLE
342: ) as
343: ddindx binary_integer; indx binary_integer;
344: begin

Line 341: , a7 JTF_DATE_TABLE

337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_VARCHAR2_TABLE_400
339: , a5 JTF_VARCHAR2_TABLE_100
340: , a6 JTF_DATE_TABLE
341: , a7 JTF_DATE_TABLE
342: ) as
343: ddindx binary_integer; indx binary_integer;
344: begin
345: if a0 is not null and a0.count > 0 then

Line 373: , a6 out nocopy JTF_DATE_TABLE

369: , a2 out nocopy JTF_NUMBER_TABLE
370: , a3 out nocopy JTF_VARCHAR2_TABLE_100
371: , a4 out nocopy JTF_VARCHAR2_TABLE_400
372: , a5 out nocopy JTF_VARCHAR2_TABLE_100
373: , a6 out nocopy JTF_DATE_TABLE
374: , a7 out nocopy JTF_DATE_TABLE
375: ) as
376: ddindx binary_integer; indx binary_integer;
377: begin

Line 374: , a7 out nocopy JTF_DATE_TABLE

370: , a3 out nocopy JTF_VARCHAR2_TABLE_100
371: , a4 out nocopy JTF_VARCHAR2_TABLE_400
372: , a5 out nocopy JTF_VARCHAR2_TABLE_100
373: , a6 out nocopy JTF_DATE_TABLE
374: , a7 out nocopy JTF_DATE_TABLE
375: ) as
376: ddindx binary_integer; indx binary_integer;
377: begin
378: if t is null or t.count = 0 then

Line 385: a6 := JTF_DATE_TABLE();

381: a2 := JTF_NUMBER_TABLE();
382: a3 := JTF_VARCHAR2_TABLE_100();
383: a4 := JTF_VARCHAR2_TABLE_400();
384: a5 := JTF_VARCHAR2_TABLE_100();
385: a6 := JTF_DATE_TABLE();
386: a7 := JTF_DATE_TABLE();
387: else
388: a0 := JTF_NUMBER_TABLE();
389: a1 := JTF_NUMBER_TABLE();

Line 386: a7 := JTF_DATE_TABLE();

382: a3 := JTF_VARCHAR2_TABLE_100();
383: a4 := JTF_VARCHAR2_TABLE_400();
384: a5 := JTF_VARCHAR2_TABLE_100();
385: a6 := JTF_DATE_TABLE();
386: a7 := JTF_DATE_TABLE();
387: else
388: a0 := JTF_NUMBER_TABLE();
389: a1 := JTF_NUMBER_TABLE();
390: a2 := JTF_NUMBER_TABLE();

Line 394: a6 := JTF_DATE_TABLE();

390: a2 := JTF_NUMBER_TABLE();
391: a3 := JTF_VARCHAR2_TABLE_100();
392: a4 := JTF_VARCHAR2_TABLE_400();
393: a5 := JTF_VARCHAR2_TABLE_100();
394: a6 := JTF_DATE_TABLE();
395: a7 := JTF_DATE_TABLE();
396: if t.count > 0 then
397: a0.extend(t.count);
398: a1.extend(t.count);

Line 395: a7 := JTF_DATE_TABLE();

391: a3 := JTF_VARCHAR2_TABLE_100();
392: a4 := JTF_VARCHAR2_TABLE_400();
393: a5 := JTF_VARCHAR2_TABLE_100();
394: a6 := JTF_DATE_TABLE();
395: a7 := JTF_DATE_TABLE();
396: if t.count > 0 then
397: a0.extend(t.count);
398: a1.extend(t.count);
399: a2.extend(t.count);

Line 835: , p9_a6 out nocopy JTF_DATE_TABLE

831: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
832: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
833: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
834: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
835: , p9_a6 out nocopy JTF_DATE_TABLE
836: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
837: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
838: , p9_a9 out nocopy JTF_DATE_TABLE
839: , p9_a10 out nocopy JTF_DATE_TABLE

Line 838: , p9_a9 out nocopy JTF_DATE_TABLE

834: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
835: , p9_a6 out nocopy JTF_DATE_TABLE
836: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
837: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
838: , p9_a9 out nocopy JTF_DATE_TABLE
839: , p9_a10 out nocopy JTF_DATE_TABLE
840: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
841: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_200
842: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 839: , p9_a10 out nocopy JTF_DATE_TABLE

835: , p9_a6 out nocopy JTF_DATE_TABLE
836: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
837: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
838: , p9_a9 out nocopy JTF_DATE_TABLE
839: , p9_a10 out nocopy JTF_DATE_TABLE
840: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
841: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_200
842: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
843: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 957: , p5_a6 out nocopy JTF_DATE_TABLE

953: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
954: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
955: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
956: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
957: , p5_a6 out nocopy JTF_DATE_TABLE
958: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
959: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
960: , p5_a9 out nocopy JTF_DATE_TABLE
961: , p5_a10 out nocopy JTF_DATE_TABLE

Line 960: , p5_a9 out nocopy JTF_DATE_TABLE

956: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
957: , p5_a6 out nocopy JTF_DATE_TABLE
958: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
959: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
960: , p5_a9 out nocopy JTF_DATE_TABLE
961: , p5_a10 out nocopy JTF_DATE_TABLE
962: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
963: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_200
964: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 961: , p5_a10 out nocopy JTF_DATE_TABLE

957: , p5_a6 out nocopy JTF_DATE_TABLE
958: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
959: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
960: , p5_a9 out nocopy JTF_DATE_TABLE
961: , p5_a10 out nocopy JTF_DATE_TABLE
962: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
963: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_200
964: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_200
965: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 1062: , p5_a5 out nocopy JTF_DATE_TABLE

1058: , p5_a1 out nocopy JTF_NUMBER_TABLE
1059: , p5_a2 out nocopy JTF_NUMBER_TABLE
1060: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1061: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
1062: , p5_a5 out nocopy JTF_DATE_TABLE
1063: , p5_a6 out nocopy JTF_DATE_TABLE
1064: , p5_a7 out nocopy JTF_NUMBER_TABLE
1065: , x_return_status out nocopy VARCHAR2
1066: , x_msg_count out nocopy NUMBER

Line 1063: , p5_a6 out nocopy JTF_DATE_TABLE

1059: , p5_a2 out nocopy JTF_NUMBER_TABLE
1060: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1061: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
1062: , p5_a5 out nocopy JTF_DATE_TABLE
1063: , p5_a6 out nocopy JTF_DATE_TABLE
1064: , p5_a7 out nocopy JTF_NUMBER_TABLE
1065: , x_return_status out nocopy VARCHAR2
1066: , x_msg_count out nocopy NUMBER
1067: , x_msg_data out nocopy VARCHAR2

Line 1227: , p4_a6 out nocopy JTF_DATE_TABLE

1223: , p4_a2 out nocopy JTF_NUMBER_TABLE
1224: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1225: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
1226: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1227: , p4_a6 out nocopy JTF_DATE_TABLE
1228: , p4_a7 out nocopy JTF_DATE_TABLE
1229: )
1230:
1231: as

Line 1228: , p4_a7 out nocopy JTF_DATE_TABLE

1224: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1225: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
1226: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1227: , p4_a6 out nocopy JTF_DATE_TABLE
1228: , p4_a7 out nocopy JTF_DATE_TABLE
1229: )
1230:
1231: as
1232: ddx_result_tbl cn_comp_plan_pvt.srp_plan_assign_tbl_type;