APPS.CS_TM_LABOR_SCHEDULE_PVT_W dependencies on CS_TM_LABOR_SCHEDULE_PVT

Line 1: package body cs_tm_labor_schedule_pvt_w as

1: package body cs_tm_labor_schedule_pvt_w as
2: /* $Header: cstmlbwshb.pls 120.0 2012/01/03 07:41:56 shachoud noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

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 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 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 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 349: ddp_labor_schedule_tbl cs_tm_labor_schedule_pvt.tm_schedule_tbl_type;

345: , p_init_msg_list VARCHAR2
346: )
347:
348: as
349: ddp_labor_schedule_tbl cs_tm_labor_schedule_pvt.tm_schedule_tbl_type;
350: ddindx binary_integer; indx binary_integer;
351: begin
352:
353: -- copy data to the local IN or IN-OUT args, if any

Line 354: cs_tm_labor_schedule_pvt_w.rosetta_table_copy_in_p1(ddp_labor_schedule_tbl, p0_a0

350: ddindx binary_integer; indx binary_integer;
351: begin
352:
353: -- copy data to the local IN or IN-OUT args, if any
354: cs_tm_labor_schedule_pvt_w.rosetta_table_copy_in_p1(ddp_labor_schedule_tbl, p0_a0
355: , p0_a1
356: , p0_a2
357: , p0_a3
358: , p0_a4

Line 391: cs_tm_labor_schedule_pvt.validate_schedule_overlap(ddp_labor_schedule_tbl,

387:
388:
389:
390: -- here's the delegated call to the old PL/SQL routine
391: cs_tm_labor_schedule_pvt.validate_schedule_overlap(ddp_labor_schedule_tbl,
392: x_return_status,
393: x_msg_count,
394: x_msg_data,
395: p_api_version,

Line 443: ddp_labor_schedule_tbl cs_tm_labor_schedule_pvt.tm_schedule_tbl_type;

439: , p_init_msg_list VARCHAR2
440: )
441:
442: as
443: ddp_labor_schedule_tbl cs_tm_labor_schedule_pvt.tm_schedule_tbl_type;
444: ddindx binary_integer; indx binary_integer;
445: begin
446:
447: -- copy data to the local IN or IN-OUT args, if any

Line 448: cs_tm_labor_schedule_pvt_w.rosetta_table_copy_in_p1(ddp_labor_schedule_tbl, p0_a0

444: ddindx binary_integer; indx binary_integer;
445: begin
446:
447: -- copy data to the local IN or IN-OUT args, if any
448: cs_tm_labor_schedule_pvt_w.rosetta_table_copy_in_p1(ddp_labor_schedule_tbl, p0_a0
449: , p0_a1
450: , p0_a2
451: , p0_a3
452: , p0_a4

Line 485: cs_tm_labor_schedule_pvt.validate_schedule_missing(ddp_labor_schedule_tbl,

481:
482:
483:
484: -- here's the delegated call to the old PL/SQL routine
485: cs_tm_labor_schedule_pvt.validate_schedule_missing(ddp_labor_schedule_tbl,
486: x_return_status,
487: x_msg_count,
488: x_msg_data,
489: p_api_version,

Line 516: ddx_labor_coverage_tbl cs_tm_labor_schedule_pvt.tm_coverage_tbl_type;

512:
513: as
514: ddp_activity_start_date_time date;
515: ddp_activity_end_date_time date;
516: ddx_labor_coverage_tbl cs_tm_labor_schedule_pvt.tm_coverage_tbl_type;
517: ddindx binary_integer; indx binary_integer;
518: begin
519:
520: -- copy data to the local IN or IN-OUT args, if any

Line 533: cs_tm_labor_schedule_pvt.get_labor_coverages(p_business_process_id,

529:
530:
531:
532: -- here's the delegated call to the old PL/SQL routine
533: cs_tm_labor_schedule_pvt.get_labor_coverages(p_business_process_id,
534: ddp_activity_start_date_time,
535: ddp_activity_end_date_time,
536: ddx_labor_coverage_tbl,
537: x_return_status,

Line 547: cs_tm_labor_schedule_pvt_w.rosetta_table_copy_out_p3(ddx_labor_coverage_tbl, p3_a0

543: -- copy data back from the local variables to OUT or IN-OUT args, if any
544:
545:
546:
547: cs_tm_labor_schedule_pvt_w.rosetta_table_copy_out_p3(ddx_labor_coverage_tbl, p3_a0
548: , p3_a1
549: , p3_a2
550: );
551:

Line 558: end cs_tm_labor_schedule_pvt_w;

554:
555:
556: end;
557:
558: end cs_tm_labor_schedule_pvt_w;