[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
* p_date_selected = Date type selected
* p_planned_start_date = Planned start date
* p_scheduled_start_date = Scheduled start date
* p_actual_start_date = Actual start date
* p_calendar_start_date = Calendar start date
* -- Return Type : DATE
* -----------------------------------------------------------------*/
FUNCTION get_start_date(p_source_object_type_code IN VARCHAR2
,p_date_selected IN VARCHAR2
,p_planned_start_date IN DATE
,p_scheduled_start_date IN DATE
,p_actual_start_date IN DATE
,p_calendar_start_date IN DATE
)
RETURN DATE
IS
l_start_date DATE;
ELSIF p_date_selected = 'P' THEN
l_start_date := p_planned_start_date;
ELSIF p_date_selected = 'S' THEN
l_start_date := p_scheduled_start_date;
ELSIF p_date_selected = 'A' THEN
l_start_date := p_actual_start_date;
ELSIF p_date_selected = 'D' THEN
l_start_date := p_calendar_start_date;
ELSIF p_date_selected IS NULL THEN
l_start_date := p_planned_start_date;
* p_date_selected = Date type selected
* p_planned_end_date = Planned end date
* p_scheduled_end_date = Scheduled end date
* p_actual_end_date = Actual end date
* p_calendar_end_date = Calendar end date
* -- Return Type : DATE
* -----------------------------------------------------------------*/
FUNCTION get_end_date(p_source_object_type_code IN VARCHAR2
,p_date_selected IN VARCHAR2
,p_planned_end_date IN DATE
,p_scheduled_end_date IN DATE
,p_actual_end_date IN DATE
,p_calendar_end_date IN DATE
)
RETURN DATE
IS
l_end_date DATE;
ELSIF p_date_selected = 'P' THEN
l_end_date := p_planned_end_date;
ELSIF p_date_selected = 'S' THEN
l_end_date := p_scheduled_end_date;
ELSIF p_date_selected = 'A' THEN
l_end_date := p_actual_end_date;
ELSIF p_date_selected = 'D' THEN
l_end_date := p_calendar_end_date;
ELSIF p_date_selected IS NULL THEN
l_end_date := p_planned_end_date;
* p_date_selected = Date type selected
* p_planned_start_date = Planned start date
* p_planned_end_date = Planned end date
* p_scheduled_start_date = Scheduled start date
* p_scheduled_end_date = Scheduled end date
* p_actual_start_date = Actual start date
* p_actual_end_date = Actual end date
* p_calendar_start_date = Calendar start date
* p_calendar_end_date = Calendar end date
* -- Return Type : VARCHAR2
* -----------------------------------------------------------------*/
FUNCTION get_duration(p_source_object_type_code IN VARCHAR2
,p_date_selected IN VARCHAR2
,p_planned_start_date IN DATE
,p_planned_end_date IN DATE
,p_scheduled_start_date IN DATE
,p_scheduled_end_date IN DATE
,p_actual_start_date IN DATE
,p_actual_end_date IN DATE
,p_calendar_start_date IN DATE
,p_calendar_end_date IN DATE
)
RETURN VARCHAR2
IS
l_start_date DATE;
,p_date_selected => p_date_selected
,p_planned_start_date => p_planned_start_date
,p_scheduled_start_date => p_scheduled_start_date
,p_actual_start_date => p_actual_start_date
,p_calendar_start_date => p_calendar_start_date
);
,p_date_selected => p_date_selected
,p_planned_end_date => p_planned_end_date
,p_scheduled_end_date => p_scheduled_end_date
,p_actual_end_date => p_actual_end_date
,p_calendar_end_date => p_calendar_end_date
);
SELECT meaning
FROM fnd_lookups
WHERE lookup_type = 'CAC_VIEW_DURATION'
AND lookup_code = b_code;
SELECT meaning
FROM fnd_lookups
WHERE lookup_type = 'JTF_CALND_REMIND_ME'
AND lookup_code = b_min;
SELECT alarm_start
, alarm_start_uom
FROM jtf_tasks_b
WHERE task_id = p_task_id;
SELECT source_first_name||' '||source_last_name attendee_name
FROM jtf_rs_resource_extns rs
, jtf_task_all_assignments jta
WHERE jta.resource_type_code = 'RS_EMPLOYEE'
AND jta.assignee_role = 'ASSIGNEE'
AND jta.task_id = p_task_id
AND rs.category = 'EMPLOYEE'
AND rs.resource_id = jta.resource_id
UNION
SELECT source_first_name||' '||source_last_name attendee_name
FROM jtf_rs_resource_extns rs
, jtf_rs_group_members rg
, jtf_task_all_assignments jta
WHERE jta.resource_type_code = 'RS_GROUP'
AND jta.assignee_role = 'ASSIGNEE'
AND jta.task_id = p_task_id
AND rg.group_id = jta.resource_id
AND rs.resource_id = rg.resource_id
UNION
SELECT source_first_name||' '||source_last_name attendee_name
FROM jtf_rs_resource_extns rs
, jtf_rs_team_members rt_ind
, jtf_task_all_assignments jta
WHERE jta.resource_type_code = 'RS_TEAM'
AND jta.assignee_role = 'ASSIGNEE'
AND jta.task_id = p_task_id
AND rt_ind.team_id = jta.resource_id
AND rt_ind.resource_type = 'INDIVIDUAL'
AND rs.resource_id = rt_ind.team_resource_id
UNION
SELECT source_first_name||' '||source_last_name attendee_name
FROM jtf_rs_resource_extns rs
, jtf_rs_group_members rg
, jtf_rs_team_members rt_grp
, jtf_task_all_assignments jta
WHERE jta.resource_type_code = 'RS_TEAM'
AND jta.assignee_role = 'ASSIGNEE'
AND jta.task_id = p_task_id
AND rt_grp.team_id = jta.resource_id
AND rt_grp.resource_type = 'GROUP'
AND rg.group_id = rt_grp.team_resource_id
AND rs.resource_id = rg.resource_id;
SELECT preference_value
FROM fnd_user_preferences
WHERE user_name = fnd_global.user_name
AND module_name = 'CAC_VIEW_PREF'
AND preference_name = p_preference_name;
SELECT assignment_status_id
FROM jtf_task_all_assignments
WHERE task_id = p_task_id
AND resource_type_code = 'RS_EMPLOYEE'
AND resource_id = p_resource_id;
SELECT meaning
FROM fnd_lookups
WHERE lookup_type = 'JTF_CALND_WEEKDAYS'
AND ( (lookup_code = decode(NVL(p_sunday,'N'), 'Y','1','0')) OR
(lookup_code = decode(NVL(p_monday,'N'), 'Y','2','0')) OR
(lookup_code = decode(NVL(p_tuesday,'N'), 'Y','3','0')) OR
(lookup_code = decode(NVL(p_wednesday,'N'),'Y','4','0')) OR
(lookup_code = decode(NVL(p_thursday,'N'), 'Y','5','0')) OR
(lookup_code = decode(NVL(p_friday,'N'), 'Y','6','0')) OR
(lookup_code = decode(NVL(p_saturday,'N'), 'Y','7','0'))
)
ORDER BY lookup_code;
SELECT to_char(to_date('2000-'||to_char(p_occurs_month,'09')||'-01', 'YYYY-MM-DD'),'Month')
INTO l_month_var
FROM dual;
SELECT lower(meaning)
FROM fnd_lookups
WHERE lookup_type = 'JTF_TASK_RECUR_OCCURS'
AND lookup_code = p_occurs_which;
SELECT meaning
FROM fnd_lookups
WHERE lookup_type = 'JTF_TASK_RECUR_OCCURS'
AND lookup_code = p_occurs_which;
SELECT occurs_number
, occurs_every
, occurs_uom
, end_date_active
, occurs_which
, date_of_month
, occurs_month
, sunday
, monday
, tuesday
, wednesday
, thursday
, friday
, saturday
, '(GMT '||to_char(trunc(gmt_offset),'S09') || ':' ||to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') || ') ' || name timezone_name
, planned_end_date
FROM jtf_task_recur_rules r
, fnd_timezones_vl tz
, jtf_tasks_vl j
WHERE r.recurrence_rule_id = p_recurrence_rule_id
AND tz.enabled_flag = 'Y'
AND upgrade_tz_id = l_server_timezone_id
and j.recurrence_rule_id=r.recurrence_rule_id;
SELECT recurrence_rule_id
FROM jtf_tasks_b
WHERE task_id = p_task_id;
SELECT oa_web_function_name
, oa_web_function_parameters
FROM jtf_objects_b
WHERE object_code = p_object_code;
SELECT preference_value
FROM fnd_user_preferences
WHERE user_name = fnd_global.user_name
AND module_name = 'CAC_VIEW_PREF'
AND preference_name = l_preference_name;
SELECT select_id, select_name, from_table, where_clause
FROM jtf_objects_b
WHERE object_code = p_object_type_code;
sql_stmt := 'SELECT ' || rec.select_name ||
' FROM ' || rec.from_table ||
' WHERE ' || l_where_clause ||
rec.select_id ||' = :object_id AND ROWNUM = 1';
SELECT object_type_code
, object_id
FROM jtf_task_references_b
WHERE task_id = p_task_id
ORDER BY object_type_code;
SELECT assignment_status_id
FROM jtf_task_all_assignments
WHERE task_id = p_task_id
AND resource_id = p_resource_id
AND resource_type_code = 'RS_EMPLOYEE';