DBA Data[Home] [Help]

APPS.CS_TM_LABOR_SCHEDULE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy cs_tm_labor_schedule_pvt.tm_schedule_tbl_type, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy cs_tm_labor_schedule_pvt.tm_schedule_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100

Line 17: , a1 JTF_NUMBER_TABLE

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy cs_tm_labor_schedule_pvt.tm_schedule_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100

Line 28: , a12 JTF_NUMBER_TABLE

24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_300
31: , a15 JTF_VARCHAR2_TABLE_300
32: , a16 JTF_VARCHAR2_TABLE_300

Line 91: procedure rosetta_table_copy_out_p1(t cs_tm_labor_schedule_pvt.tm_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

87: end loop;
88: end if;
89: end if;
90: end rosetta_table_copy_in_p1;
91: procedure rosetta_table_copy_out_p1(t cs_tm_labor_schedule_pvt.tm_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_DATE_TABLE
94: , a3 out nocopy JTF_DATE_TABLE
95: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 92: , a1 out nocopy JTF_NUMBER_TABLE

88: end if;
89: end if;
90: end rosetta_table_copy_in_p1;
91: procedure rosetta_table_copy_out_p1(t cs_tm_labor_schedule_pvt.tm_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_DATE_TABLE
94: , a3 out nocopy JTF_DATE_TABLE
95: , a4 out nocopy JTF_VARCHAR2_TABLE_100
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 103: , a12 out nocopy JTF_NUMBER_TABLE

99: , a8 out nocopy JTF_VARCHAR2_TABLE_100
100: , a9 out nocopy JTF_VARCHAR2_TABLE_100
101: , a10 out nocopy JTF_VARCHAR2_TABLE_100
102: , a11 out nocopy JTF_VARCHAR2_TABLE_100
103: , a12 out nocopy JTF_NUMBER_TABLE
104: , a13 out nocopy JTF_VARCHAR2_TABLE_100
105: , a14 out nocopy JTF_VARCHAR2_TABLE_300
106: , a15 out nocopy JTF_VARCHAR2_TABLE_300
107: , a16 out nocopy JTF_VARCHAR2_TABLE_300

Line 124: a0 := JTF_NUMBER_TABLE();

120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_DATE_TABLE();
127: a3 := JTF_DATE_TABLE();
128: a4 := JTF_VARCHAR2_TABLE_100();

Line 125: a1 := JTF_NUMBER_TABLE();

121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_DATE_TABLE();
127: a3 := JTF_DATE_TABLE();
128: a4 := JTF_VARCHAR2_TABLE_100();
129: a5 := JTF_VARCHAR2_TABLE_100();

Line 136: a12 := JTF_NUMBER_TABLE();

132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_VARCHAR2_TABLE_100();
135: a11 := JTF_VARCHAR2_TABLE_100();
136: a12 := JTF_NUMBER_TABLE();
137: a13 := JTF_VARCHAR2_TABLE_100();
138: a14 := JTF_VARCHAR2_TABLE_300();
139: a15 := JTF_VARCHAR2_TABLE_300();
140: a16 := JTF_VARCHAR2_TABLE_300();

Line 154: a0 := JTF_NUMBER_TABLE();

150: a26 := JTF_VARCHAR2_TABLE_300();
151: a27 := JTF_VARCHAR2_TABLE_300();
152: a28 := JTF_VARCHAR2_TABLE_300();
153: else
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_DATE_TABLE();
157: a3 := JTF_DATE_TABLE();
158: a4 := JTF_VARCHAR2_TABLE_100();

Line 155: a1 := JTF_NUMBER_TABLE();

151: a27 := JTF_VARCHAR2_TABLE_300();
152: a28 := JTF_VARCHAR2_TABLE_300();
153: else
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_DATE_TABLE();
157: a3 := JTF_DATE_TABLE();
158: a4 := JTF_VARCHAR2_TABLE_100();
159: a5 := JTF_VARCHAR2_TABLE_100();

Line 166: a12 := JTF_NUMBER_TABLE();

162: a8 := JTF_VARCHAR2_TABLE_100();
163: a9 := JTF_VARCHAR2_TABLE_100();
164: a10 := JTF_VARCHAR2_TABLE_100();
165: a11 := JTF_VARCHAR2_TABLE_100();
166: a12 := JTF_NUMBER_TABLE();
167: a13 := JTF_VARCHAR2_TABLE_100();
168: a14 := JTF_VARCHAR2_TABLE_300();
169: a15 := JTF_VARCHAR2_TABLE_300();
170: a16 := JTF_VARCHAR2_TABLE_300();

Line 257: , a2 JTF_NUMBER_TABLE

253: end rosetta_table_copy_out_p1;
254:
255: procedure rosetta_table_copy_in_p3(t out nocopy cs_tm_labor_schedule_pvt.tm_coverage_tbl_type, a0 JTF_DATE_TABLE
256: , a1 JTF_DATE_TABLE
257: , a2 JTF_NUMBER_TABLE
258: ) as
259: ddindx binary_integer; indx binary_integer;
260: begin
261: if a0 is not null and a0.count > 0 then

Line 280: , a2 out nocopy JTF_NUMBER_TABLE

276: end if;
277: end rosetta_table_copy_in_p3;
278: procedure rosetta_table_copy_out_p3(t cs_tm_labor_schedule_pvt.tm_coverage_tbl_type, a0 out nocopy JTF_DATE_TABLE
279: , a1 out nocopy JTF_DATE_TABLE
280: , a2 out nocopy JTF_NUMBER_TABLE
281: ) as
282: ddindx binary_integer; indx binary_integer;
283: begin
284: if t is null or t.count = 0 then

Line 287: a2 := JTF_NUMBER_TABLE();

283: begin
284: if t is null or t.count = 0 then
285: a0 := JTF_DATE_TABLE();
286: a1 := JTF_DATE_TABLE();
287: a2 := JTF_NUMBER_TABLE();
288: else
289: a0 := JTF_DATE_TABLE();
290: a1 := JTF_DATE_TABLE();
291: a2 := JTF_NUMBER_TABLE();

Line 291: a2 := JTF_NUMBER_TABLE();

287: a2 := JTF_NUMBER_TABLE();
288: else
289: a0 := JTF_DATE_TABLE();
290: a1 := JTF_DATE_TABLE();
291: a2 := JTF_NUMBER_TABLE();
292: if t.count > 0 then
293: a0.extend(t.count);
294: a1.extend(t.count);
295: a2.extend(t.count);

Line 312: procedure validate_schedule_overlap(p0_a0 JTF_NUMBER_TABLE

308: end if;
309: end if;
310: end rosetta_table_copy_out_p3;
311:
312: procedure validate_schedule_overlap(p0_a0 JTF_NUMBER_TABLE
313: , p0_a1 JTF_NUMBER_TABLE
314: , p0_a2 JTF_DATE_TABLE
315: , p0_a3 JTF_DATE_TABLE
316: , p0_a4 JTF_VARCHAR2_TABLE_100

Line 313: , p0_a1 JTF_NUMBER_TABLE

309: end if;
310: end rosetta_table_copy_out_p3;
311:
312: procedure validate_schedule_overlap(p0_a0 JTF_NUMBER_TABLE
313: , p0_a1 JTF_NUMBER_TABLE
314: , p0_a2 JTF_DATE_TABLE
315: , p0_a3 JTF_DATE_TABLE
316: , p0_a4 JTF_VARCHAR2_TABLE_100
317: , p0_a5 JTF_VARCHAR2_TABLE_100

Line 324: , p0_a12 JTF_NUMBER_TABLE

320: , p0_a8 JTF_VARCHAR2_TABLE_100
321: , p0_a9 JTF_VARCHAR2_TABLE_100
322: , p0_a10 JTF_VARCHAR2_TABLE_100
323: , p0_a11 JTF_VARCHAR2_TABLE_100
324: , p0_a12 JTF_NUMBER_TABLE
325: , p0_a13 JTF_VARCHAR2_TABLE_100
326: , p0_a14 JTF_VARCHAR2_TABLE_300
327: , p0_a15 JTF_VARCHAR2_TABLE_300
328: , p0_a16 JTF_VARCHAR2_TABLE_300

Line 406: procedure validate_schedule_missing(p0_a0 JTF_NUMBER_TABLE

402:
403:
404: end;
405:
406: procedure validate_schedule_missing(p0_a0 JTF_NUMBER_TABLE
407: , p0_a1 JTF_NUMBER_TABLE
408: , p0_a2 JTF_DATE_TABLE
409: , p0_a3 JTF_DATE_TABLE
410: , p0_a4 JTF_VARCHAR2_TABLE_100

Line 407: , p0_a1 JTF_NUMBER_TABLE

403:
404: end;
405:
406: procedure validate_schedule_missing(p0_a0 JTF_NUMBER_TABLE
407: , p0_a1 JTF_NUMBER_TABLE
408: , p0_a2 JTF_DATE_TABLE
409: , p0_a3 JTF_DATE_TABLE
410: , p0_a4 JTF_VARCHAR2_TABLE_100
411: , p0_a5 JTF_VARCHAR2_TABLE_100

Line 418: , p0_a12 JTF_NUMBER_TABLE

414: , p0_a8 JTF_VARCHAR2_TABLE_100
415: , p0_a9 JTF_VARCHAR2_TABLE_100
416: , p0_a10 JTF_VARCHAR2_TABLE_100
417: , p0_a11 JTF_VARCHAR2_TABLE_100
418: , p0_a12 JTF_NUMBER_TABLE
419: , p0_a13 JTF_VARCHAR2_TABLE_100
420: , p0_a14 JTF_VARCHAR2_TABLE_300
421: , p0_a15 JTF_VARCHAR2_TABLE_300
422: , p0_a16 JTF_VARCHAR2_TABLE_300

Line 505: , p3_a2 out nocopy JTF_NUMBER_TABLE

501: , p_activity_start_date_time date
502: , p_activity_end_date_time date
503: , p3_a0 out nocopy JTF_DATE_TABLE
504: , p3_a1 out nocopy JTF_DATE_TABLE
505: , p3_a2 out nocopy JTF_NUMBER_TABLE
506: , x_return_status out nocopy VARCHAR2
507: , x_msg_count out nocopy NUMBER
508: , x_msg_data out nocopy VARCHAR2
509: , p_api_version NUMBER