DBA Data[Home] [Help]

APPS.CS_TM_LABOR_SCHEDULE_PVT_W dependencies on JTF_DATE_TABLE

Line 18: , a2 JTF_DATE_TABLE

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
22: , a6 JTF_VARCHAR2_TABLE_100

Line 19: , a3 JTF_DATE_TABLE

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
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100

Line 93: , a2 out nocopy JTF_DATE_TABLE

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
97: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 94: , a3 out nocopy JTF_DATE_TABLE

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
97: , a6 out nocopy JTF_VARCHAR2_TABLE_100
98: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 126: a2 := JTF_DATE_TABLE();

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();
130: a6 := JTF_VARCHAR2_TABLE_100();

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_DATE_TABLE();
127: a3 := JTF_DATE_TABLE();
128: a4 := JTF_VARCHAR2_TABLE_100();
129: a5 := JTF_VARCHAR2_TABLE_100();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_VARCHAR2_TABLE_100();

Line 156: a2 := JTF_DATE_TABLE();

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();
160: a6 := JTF_VARCHAR2_TABLE_100();

Line 157: a3 := JTF_DATE_TABLE();

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();
160: a6 := JTF_VARCHAR2_TABLE_100();
161: a7 := JTF_VARCHAR2_TABLE_100();

Line 255: procedure rosetta_table_copy_in_p3(t out nocopy cs_tm_labor_schedule_pvt.tm_coverage_tbl_type, a0 JTF_DATE_TABLE

251: end if;
252: end if;
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;

Line 256: , a1 JTF_DATE_TABLE

252: end if;
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

Line 278: procedure rosetta_table_copy_out_p3(t cs_tm_labor_schedule_pvt.tm_coverage_tbl_type, a0 out nocopy JTF_DATE_TABLE

274: end loop;
275: end if;
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;

Line 279: , a1 out nocopy JTF_DATE_TABLE

275: end if;
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

Line 285: a0 := JTF_DATE_TABLE();

281: ) as
282: ddindx binary_integer; indx binary_integer;
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();

Line 286: a1 := JTF_DATE_TABLE();

282: ddindx binary_integer; indx binary_integer;
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();

Line 289: a0 := JTF_DATE_TABLE();

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();
292: if t.count > 0 then
293: a0.extend(t.count);

Line 290: a1 := 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();
292: if t.count > 0 then
293: a0.extend(t.count);
294: a1.extend(t.count);

Line 314: , p0_a2 JTF_DATE_TABLE

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
318: , p0_a6 JTF_VARCHAR2_TABLE_100

Line 315: , p0_a3 JTF_DATE_TABLE

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
318: , p0_a6 JTF_VARCHAR2_TABLE_100
319: , p0_a7 JTF_VARCHAR2_TABLE_100

Line 408: , p0_a2 JTF_DATE_TABLE

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
412: , p0_a6 JTF_VARCHAR2_TABLE_100

Line 409: , p0_a3 JTF_DATE_TABLE

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
412: , p0_a6 JTF_VARCHAR2_TABLE_100
413: , p0_a7 JTF_VARCHAR2_TABLE_100

Line 503: , p3_a0 out nocopy JTF_DATE_TABLE

499:
500: procedure get_labor_coverages(p_business_process_id NUMBER
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

Line 504: , p3_a1 out nocopy JTF_DATE_TABLE

500: procedure get_labor_coverages(p_business_process_id NUMBER
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