[Home] [Help]
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);
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:
554: -- this is a local schedule variable that will be passed to the check_overlap_schedules
555: -- procedure to avoid corruption of the variable x_schedule
556: -- Bug 14683476
557:
558: x_schedule_dup cac_avlblty_time_varray;
559:
560: BEGIN
561: l_proc := 'hr_wrk_sch_pkg.get_per_asg_schedule';
562: hr_utility.set_location('Entering: '|| l_proc, 10);
562: hr_utility.set_location('Entering: '|| l_proc, 10);
563: --
564: -- Initialize
565: x_return_status := 0;
566: x_schedule := cac_avlblty_time_varray();
567: x_schedule_source := 'PER_ASG';
568: l_busy_tentative_as := NVL(p_busy_tentative_as, 'BUSY');
569: l_wrk_sch_found := FALSE;
570: l_wrk_sch_count := 0;
936:
937: l_working_date DATE;
938: l_flag Boolean;
939: l_schedule_source varchar2(1000);
940: l_schedule cac_avlblty_time_varray;
941: l_return_status number;
942: l_return_message varchar2(1000);
943: l_busy_tentative_as varchar2(30);
944: l_wrk_sch_found boolean;
950: BEGIN
951:
952: l_flag := true;
953: l_return_status := 0;
954: l_schedule := cac_avlblty_time_varray();
955: l_schedule_source := 'PER_ASG';
956: l_busy_tentative_as := NVL(l_busy_tentative_as, 'BUSY');
957: l_wrk_sch_found := false;
958: l_count := 0;