DBA Data[Home] [Help]

APPS.CN_PAY_GROUP_DTLS_PVT_W dependencies on JTF_DATE_TABLE

Line 20: , a7 JTF_DATE_TABLE

16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_DATE_TABLE
21: , a8 JTF_DATE_TABLE
22: ) as
23: ddindx binary_integer; indx binary_integer;
24: begin

Line 21: , a8 JTF_DATE_TABLE

17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_DATE_TABLE
21: , a8 JTF_DATE_TABLE
22: ) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then

Line 55: , a7 out nocopy JTF_DATE_TABLE

51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_DATE_TABLE
56: , a8 out nocopy JTF_DATE_TABLE
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin

Line 56: , a8 out nocopy JTF_DATE_TABLE

52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_DATE_TABLE
56: , a8 out nocopy JTF_DATE_TABLE
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then

Line 68: a7 := JTF_DATE_TABLE();

64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_DATE_TABLE();
69: a8 := JTF_DATE_TABLE();
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();

Line 69: a8 := JTF_DATE_TABLE();

65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_DATE_TABLE();
69: a8 := JTF_DATE_TABLE();
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_100();

Line 78: a7 := JTF_DATE_TABLE();

74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_NUMBER_TABLE();
77: a6 := JTF_NUMBER_TABLE();
78: a7 := JTF_DATE_TABLE();
79: a8 := JTF_DATE_TABLE();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);

Line 79: a8 := JTF_DATE_TABLE();

75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_NUMBER_TABLE();
77: a6 := JTF_NUMBER_TABLE();
78: a7 := JTF_DATE_TABLE();
79: a8 := JTF_DATE_TABLE();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);
83: a2.extend(t.count);

Line 118: , a6 JTF_DATE_TABLE

114: , a2 JTF_VARCHAR2_TABLE_100
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_400
117: , a5 JTF_VARCHAR2_TABLE_100
118: , a6 JTF_DATE_TABLE
119: , a7 JTF_DATE_TABLE
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin

Line 119: , a7 JTF_DATE_TABLE

115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_400
117: , a5 JTF_VARCHAR2_TABLE_100
118: , a6 JTF_DATE_TABLE
119: , a7 JTF_DATE_TABLE
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if a0 is not null and a0.count > 0 then

Line 151: , a6 out nocopy JTF_DATE_TABLE

147: , a2 out nocopy JTF_VARCHAR2_TABLE_100
148: , a3 out nocopy JTF_VARCHAR2_TABLE_100
149: , a4 out nocopy JTF_VARCHAR2_TABLE_400
150: , a5 out nocopy JTF_VARCHAR2_TABLE_100
151: , a6 out nocopy JTF_DATE_TABLE
152: , a7 out nocopy JTF_DATE_TABLE
153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin

Line 152: , a7 out nocopy JTF_DATE_TABLE

148: , a3 out nocopy JTF_VARCHAR2_TABLE_100
149: , a4 out nocopy JTF_VARCHAR2_TABLE_400
150: , a5 out nocopy JTF_VARCHAR2_TABLE_100
151: , a6 out nocopy JTF_DATE_TABLE
152: , a7 out nocopy JTF_DATE_TABLE
153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin
156: if t is null or t.count = 0 then

Line 163: a6 := JTF_DATE_TABLE();

159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_400();
162: a5 := JTF_VARCHAR2_TABLE_100();
163: a6 := JTF_DATE_TABLE();
164: a7 := JTF_DATE_TABLE();
165: else
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_VARCHAR2_TABLE_100();

Line 164: a7 := JTF_DATE_TABLE();

160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_400();
162: a5 := JTF_VARCHAR2_TABLE_100();
163: a6 := JTF_DATE_TABLE();
164: a7 := JTF_DATE_TABLE();
165: else
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_VARCHAR2_TABLE_100();
168: a2 := JTF_VARCHAR2_TABLE_100();

Line 172: a6 := JTF_DATE_TABLE();

168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_VARCHAR2_TABLE_100();
170: a4 := JTF_VARCHAR2_TABLE_400();
171: a5 := JTF_VARCHAR2_TABLE_100();
172: a6 := JTF_DATE_TABLE();
173: a7 := JTF_DATE_TABLE();
174: if t.count > 0 then
175: a0.extend(t.count);
176: a1.extend(t.count);

Line 173: a7 := JTF_DATE_TABLE();

169: a3 := JTF_VARCHAR2_TABLE_100();
170: a4 := JTF_VARCHAR2_TABLE_400();
171: a5 := JTF_VARCHAR2_TABLE_100();
172: a6 := JTF_DATE_TABLE();
173: a7 := JTF_DATE_TABLE();
174: if t.count > 0 then
175: a0.extend(t.count);
176: a1.extend(t.count);
177: a2.extend(t.count);

Line 210: , a6 JTF_DATE_TABLE

206: , a2 JTF_VARCHAR2_TABLE_100
207: , a3 JTF_VARCHAR2_TABLE_100
208: , a4 JTF_VARCHAR2_TABLE_100
209: , a5 JTF_NUMBER_TABLE
210: , a6 JTF_DATE_TABLE
211: , a7 JTF_DATE_TABLE
212: ) as
213: ddindx binary_integer; indx binary_integer;
214: begin

Line 211: , a7 JTF_DATE_TABLE

207: , a3 JTF_VARCHAR2_TABLE_100
208: , a4 JTF_VARCHAR2_TABLE_100
209: , a5 JTF_NUMBER_TABLE
210: , a6 JTF_DATE_TABLE
211: , a7 JTF_DATE_TABLE
212: ) as
213: ddindx binary_integer; indx binary_integer;
214: begin
215: if a0 is not null and a0.count > 0 then

Line 243: , a6 out nocopy JTF_DATE_TABLE

239: , a2 out nocopy JTF_VARCHAR2_TABLE_100
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_VARCHAR2_TABLE_100
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_DATE_TABLE
244: , a7 out nocopy JTF_DATE_TABLE
245: ) as
246: ddindx binary_integer; indx binary_integer;
247: begin

Line 244: , a7 out nocopy JTF_DATE_TABLE

240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_VARCHAR2_TABLE_100
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_DATE_TABLE
244: , a7 out nocopy JTF_DATE_TABLE
245: ) as
246: ddindx binary_integer; indx binary_integer;
247: begin
248: if t is null or t.count = 0 then

Line 255: a6 := JTF_DATE_TABLE();

251: a2 := JTF_VARCHAR2_TABLE_100();
252: a3 := JTF_VARCHAR2_TABLE_100();
253: a4 := JTF_VARCHAR2_TABLE_100();
254: a5 := JTF_NUMBER_TABLE();
255: a6 := JTF_DATE_TABLE();
256: a7 := JTF_DATE_TABLE();
257: else
258: a0 := JTF_NUMBER_TABLE();
259: a1 := JTF_VARCHAR2_TABLE_100();

Line 256: a7 := JTF_DATE_TABLE();

252: a3 := JTF_VARCHAR2_TABLE_100();
253: a4 := JTF_VARCHAR2_TABLE_100();
254: a5 := JTF_NUMBER_TABLE();
255: a6 := JTF_DATE_TABLE();
256: a7 := JTF_DATE_TABLE();
257: else
258: a0 := JTF_NUMBER_TABLE();
259: a1 := JTF_VARCHAR2_TABLE_100();
260: a2 := JTF_VARCHAR2_TABLE_100();

Line 264: a6 := JTF_DATE_TABLE();

260: a2 := JTF_VARCHAR2_TABLE_100();
261: a3 := JTF_VARCHAR2_TABLE_100();
262: a4 := JTF_VARCHAR2_TABLE_100();
263: a5 := JTF_NUMBER_TABLE();
264: a6 := JTF_DATE_TABLE();
265: a7 := JTF_DATE_TABLE();
266: if t.count > 0 then
267: a0.extend(t.count);
268: a1.extend(t.count);

Line 265: a7 := JTF_DATE_TABLE();

261: a3 := JTF_VARCHAR2_TABLE_100();
262: a4 := JTF_VARCHAR2_TABLE_100();
263: a5 := JTF_NUMBER_TABLE();
264: a6 := JTF_DATE_TABLE();
265: a7 := JTF_DATE_TABLE();
266: if t.count > 0 then
267: a0.extend(t.count);
268: a1.extend(t.count);
269: a2.extend(t.count);

Line 310: , p7_a7 out nocopy JTF_DATE_TABLE

306: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a5 out nocopy JTF_NUMBER_TABLE
309: , p7_a6 out nocopy JTF_NUMBER_TABLE
310: , p7_a7 out nocopy JTF_DATE_TABLE
311: , p7_a8 out nocopy JTF_DATE_TABLE
312: , x_total_record out nocopy NUMBER
313: , x_return_status out nocopy VARCHAR2
314: , x_msg_count out nocopy NUMBER

Line 311: , p7_a8 out nocopy JTF_DATE_TABLE

307: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a5 out nocopy JTF_NUMBER_TABLE
309: , p7_a6 out nocopy JTF_NUMBER_TABLE
310: , p7_a7 out nocopy JTF_DATE_TABLE
311: , p7_a8 out nocopy JTF_DATE_TABLE
312: , x_total_record out nocopy NUMBER
313: , x_return_status out nocopy VARCHAR2
314: , x_msg_count out nocopy NUMBER
315: , x_msg_data out nocopy VARCHAR2

Line 387: , p7_a6 out nocopy JTF_DATE_TABLE

383: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
385: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400
386: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
387: , p7_a6 out nocopy JTF_DATE_TABLE
388: , p7_a7 out nocopy JTF_DATE_TABLE
389: , x_total_record out nocopy NUMBER
390: , x_return_status out nocopy VARCHAR2
391: , x_msg_count out nocopy NUMBER

Line 388: , p7_a7 out nocopy JTF_DATE_TABLE

384: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
385: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400
386: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
387: , p7_a6 out nocopy JTF_DATE_TABLE
388: , p7_a7 out nocopy JTF_DATE_TABLE
389: , x_total_record out nocopy NUMBER
390: , x_return_status out nocopy VARCHAR2
391: , x_msg_count out nocopy NUMBER
392: , x_msg_data out nocopy VARCHAR2

Line 463: , p7_a6 out nocopy JTF_DATE_TABLE

459: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
460: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
461: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
462: , p7_a5 out nocopy JTF_NUMBER_TABLE
463: , p7_a6 out nocopy JTF_DATE_TABLE
464: , p7_a7 out nocopy JTF_DATE_TABLE
465: , x_total_record out nocopy NUMBER
466: , x_return_status out nocopy VARCHAR2
467: , x_msg_count out nocopy NUMBER

Line 464: , p7_a7 out nocopy JTF_DATE_TABLE

460: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
461: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
462: , p7_a5 out nocopy JTF_NUMBER_TABLE
463: , p7_a6 out nocopy JTF_DATE_TABLE
464: , p7_a7 out nocopy JTF_DATE_TABLE
465: , x_total_record out nocopy NUMBER
466: , x_return_status out nocopy VARCHAR2
467: , x_msg_count out nocopy NUMBER
468: , x_msg_data out nocopy VARCHAR2