DBA Data[Home] [Help]

APPS.HR_WRK_SCH_PKG dependencies on CAC_AVLBLTY_TIME_VARRAY

Line 21: ,x_schedule IN OUT NOCOPY cac_avlblty_time_varray) is

17: ,p_schedule_category IN VARCHAR2
18: ,p_include_exceptions IN VARCHAR2
19: ,p_busy_tentative_as IN VARCHAR2
20: ,x_schedule_source IN OUT NOCOPY VARCHAR2
21: ,x_schedule IN OUT NOCOPY cac_avlblty_time_varray) is
22:
23:
24: l_proc VARCHAR2(50);
25: l_return_status VARCHAR2(1);

Line 451: ,x_schedule IN OUT NOCOPY cac_avlblty_time_varray

447: ,p_schedule_category IN VARCHAR2
448: ,p_include_exceptions IN VARCHAR2
449: ,p_busy_tentative_as IN VARCHAR2
450: ,x_schedule_source IN OUT NOCOPY VARCHAR2
451: ,x_schedule IN OUT NOCOPY cac_avlblty_time_varray
452: ,x_return_status OUT NOCOPY NUMBER
453: ,x_return_message OUT NOCOPY VARCHAR2
454: ) IS
455:

Line 561: x_schedule := cac_avlblty_time_varray();

557: hr_utility.set_location('Entering: '|| l_proc, 10);
558: --
559: -- Initialize
560: x_return_status := 0;
561: x_schedule := cac_avlblty_time_varray();
562: x_schedule_source := 'PER_ASG';
563: l_busy_tentative_as := NVL(p_busy_tentative_as, 'BUSY');
564: l_wrk_sch_found := FALSE;
565: l_wrk_sch_count := 0;

Line 929: l_schedule cac_avlblty_time_varray;

925:
926: l_working_date DATE;
927: l_flag Boolean;
928: l_schedule_source varchar2(1000);
929: l_schedule cac_avlblty_time_varray;
930: l_return_status number;
931: l_return_message varchar2(1000);
932: l_busy_tentative_as varchar2(30);
933: l_wrk_sch_found boolean;

Line 943: l_schedule := cac_avlblty_time_varray();

939: BEGIN
940:
941: l_flag := true;
942: l_return_status := 0;
943: l_schedule := cac_avlblty_time_varray();
944: l_schedule_source := 'PER_ASG';
945: l_busy_tentative_as := NVL(l_busy_tentative_as, 'BUSY');
946: l_wrk_sch_found := false;
947: l_count := 0;