[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
)IS SELECT jtb.source_object_id ItemSourceID
, jtb.source_object_type_code ItemSourceCode
, jtb.calendar_start_date StartDate
, jtb.calendar_end_date EndDate
, jtb.timezone_id TimezoneID
FROM jtf_task_all_assignments jta
, jtf_tasks_b jtb
, jtf_task_statuses_b jtsb
WHERE jta.resource_id = b_ResourceID -- 101272224
AND jta.resource_type_code = b_ResourceType -- 'RS_EMPLOYEE'
AND jta.task_id = jtb.task_id -- join to tasks_b
AND jtb.task_status_id = jtsb.task_status_id -- join to to task_status_b
AND jta.show_on_calendar = 'Y'
AND jta.assignment_status_id <> 4 -- using status rejected for declined
AND NVL(jtsb.closed_flag,'N')<> 'Y'
AND ( jtb.calendar_start_date <= b_EndDate
OR jtb.calendar_start_date IS NULL
)
AND ( jtb.calendar_end_date >= b_StartDate
OR jtb.calendar_end_date IS NULL
);
PROCEDURE UpdateList
( p_List IN OUT NOCOPY AvlblTb -- List Name
, p_StartRecord IN NUMBER -- For this RS List section starts with record #
, p_FirstSlot IN NUMBER -- First Slot to set to unavailable
, p_LastSlot IN NUMBER -- Last Slot to set to unavailable
)
IS
p BINARY_INTEGER;
END UpdateList;
** Update the availabity list section of this resource with the Slot
** Data
*************************************************************************/
UpdateList( x_AvailbltyList -- List Name
, l_RSSectionStart -- For this RS List section starts with record #
, l_FirstSlot -- First Slot to set to unavailable
, l_LastSlot -- Last Slot to set to unavailable
);
** Update the total availabity list with the Slot Data
*************************************************************************/
UpdateList( x_TotalAvailbltyList -- List Name
, 1 -- start with record #
, l_FirstSlot -- First Slot to set to unavailable
, l_LastSlot -- Last Slot to set to unavailable
);