[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select uom_code into l_base_uom_code from mtl_units_of_measure
where base_uom_flag = 'Y' and uom_class = fnd_profile.value('JTF_TIME_UOM_CLASS');
SELECT NVL(completed_flag,'N') completed_flag,
NVL(cancelled_flag,'N') cancelled_flag,
NVL(rejected_flag,'N') rejected_flag,
NVL(closed_flag,'N') closed_flag
FROM jtf_task_statuses_b
WHERE task_status_id = p_task_status_id;
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,
x_show_on_calendar IN OUT NOCOPY varchar2,-- Fixed from OUT to IN OUT
x_date_selected IN OUT NOCOPY varchar2,-- Fixed from OUT to IN OUT
x_calendar_start_date OUT NOCOPY date,
x_calendar_end_date OUT NOCOPY date,
x_return_status OUT NOCOPY varchar2,
p_task_status_id IN NUMBER, -- Enhancement 2683868: new parameter
p_creation_date IN DATE -- Enhancement 2683868: new parameter
)
is
-- Fix for bug 2932012
--cursor c_date_selected is
--select decode(fnd_profile.value('JTF_TASK_DEFAULT_DATE_SELECTED'),
-- 'PLANNED', 'P',
-- 'SCHEDULED', 'S',
-- 'ACTUAL', 'A',
-- 'S')
-- from dual;
l_date_selected varchar2(1);
l_date_profile varchar2(30) := fnd_profile.value('JTF_TASK_DEFAULT_DATE_SELECTED');
IF p_date_selected IS NULL OR
p_date_selected = fnd_api.g_miss_char
THEN
-- Fix for bug 2932012
--open c_date_selected;
l_date_selected := 'P';
l_date_selected := 'S';
l_date_selected := 'A';
l_date_selected := 'S';
l_date_selected := p_date_selected;
if l_date_selected = 'P' then
l_cal_start_date := p_planned_start_date;
l_date_selected = 'S' then
l_cal_start_date := p_scheduled_start_date;
l_date_selected = 'A' then
l_cal_start_date := p_actual_start_date;
elsif l_date_selected = 'D'
then
set_start_n_due_date (
p_task_status_id => p_task_status_id,
p_planned_start_date => p_planned_start_date,
p_planned_end_date => p_planned_end_date,
p_scheduled_start_date => p_scheduled_start_date,
p_scheduled_end_date => p_scheduled_end_date,
p_actual_start_date => p_actual_start_date,
p_actual_end_date => p_actual_end_date,
p_creation_date => p_creation_date,
x_calendar_start_date => l_cal_start_date,
x_calendar_end_date => l_cal_end_date,
x_return_status => x_return_status);
x_date_selected := l_date_selected; -- For fix bug 2467890: always store date_selected
if (p_date_selected is null or p_date_selected = fnd_api.g_miss_char)
then
x_show_on_calendar := 'Y';
IF x_date_selected <> 'D' THEN
x_date_selected := NULL;
SELECT start_date_type
, end_date_type
FROM jtf_task_statuses_b
WHERE task_status_id = p_task_status_id;
l_date_profile varchar2(30) := fnd_profile.value('JTF_TASK_DEFAULT_DATE_SELECTED');
SELECT last_number
FROM all_sequences
WHERE sequence_name = p_sequence_name
AND sequence_owner = l_oracle_schema;
SELECT task_id , parent_task_id , level
FROM jtf_tasks_b
START WITH task_id = p_task_id
CONNECT BY PRIOR task_id = parent_task_id ;
PROCEDURE update_object_code (
p_task_id IN NUMBER
,p_old_object_code IN VARCHAR2
,p_new_object_code IN VARCHAR2
,p_old_object_id IN NUMBER
,p_new_object_id IN NUMBER
,p_new_object_name IN VARCHAR2
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
CURSOR c_ref (b_task_id jtf_tasks_b.task_id%type,
b_source_id hz_parties.party_id%type) IS
SELECT task_reference_id, object_version_number
FROM jtf_task_references_b
WHERE task_id = b_task_id
AND object_id = b_source_id;
jtf_task_utl.delete_party_reference(
p_reference_from => 'TASK',
p_task_id => p_task_id,
p_party_id => p_old_object_id,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status
);
jtf_task_references_pub.delete_references (
p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_object_version_number => l_obj_version_number,
p_task_reference_id => l_task_ref_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
END update_object_code;
SELECT select_id, select_details, from_table, where_clause
FROM jtf_objects_b
WHERE object_code = p_object_code;
l_id_column jtf_objects_b.select_id%TYPE;
l_detail_column jtf_objects_b.select_details%TYPE;
sql_stmt := ' SELECT ' || l_detail_column ||
' FROM ' || l_from_clause ||
' WHERE ' || l_where_clause ||
l_id_column ||' = :object_id ';
SELECT task_name
INTO l_task_name
FROM jtf_tasks_vl
WHERE task_id = p_task_id;
FUNCTION check_dup_reference_for_update (
p_task_reference_id jtf_task_references_b.task_reference_id%type,
p_task_id jtf_tasks_b.task_id%type,
p_object_id hz_relationships.object_id%type,
p_object_type_code jtf_task_references_b.object_type_code%type)
return boolean
is
x_count NUMBER := 0;
update. Added task_reference_id to the whereclause for
eliminate itself.
*/
select count(object_id)
INTO x_count
FROM JTF_TASK_REFERENCES_b
WHERE task_reference_id <> p_task_reference_id
AND task_id = p_task_id
AND object_id = p_object_id
AND object_type_code = p_object_type_code
AND rownum = 1;
end check_dup_reference_for_update;