APPS.JTF_AGENDA_CALCULATIONS dependencies on JTF_CALENDAR_PUB

Line 544: l_shift JTF_CALENDAR_PUB.SHIFT_TBL_TYPE;

540: l_time NUMBER;
541: l_return_status VARCHAR2(1);
542: l_msg_count NUMBER;
543: l_msg_data VARCHAR2(2000);
544: l_shift JTF_CALENDAR_PUB.SHIFT_TBL_TYPE;
545:
546: CURSOR c_shift_construct IS
547: SELECT begin_time
548: FROM jtf_cal_shift_constructs

Line 565: JTF_CALENDAR_PUB.Get_Resource_Shifts

561: CLOSE c_shift_construct;
562:
563: -- No shift start was found using shift_construct_id
564: IF l_start IS NULL THEN
565: JTF_CALENDAR_PUB.Get_Resource_Shifts
566: ( p_api_version => 1.0 ,
567: p_resource_id => p_resource_id ,
568: p_resource_type => p_resource_type_code ,
569: p_start_date => p_date ,

Line 607: l_shift JTF_CALENDAR_PUB.SHIFT_TBL_TYPE;

603: l_return_status VARCHAR2(1);
604: l_msg_count NUMBER;
605: l_msg_data VARCHAR2(2000);
606:
607: l_shift JTF_CALENDAR_PUB.SHIFT_TBL_TYPE;
608:
609: CURSOR c_shift_construct IS
610: SELECT end_time
611: FROM jtf_cal_shift_constructs

Line 627: JTF_CALENDAR_PUB.Get_Resource_Shifts

623: CLOSE c_shift_construct;
624:
625: -- No shift end was found using shift_construct_id
626: IF l_end IS NULL THEN
627: JTF_CALENDAR_PUB.Get_Resource_Shifts
628: ( p_api_version => 1.0 ,
629: p_resource_id => p_resource_id ,
630: p_resource_type => p_resource_type_code ,
631: p_start_date => p_date ,