[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT task_assignment_id, object_version_number
FROM jtf_task_all_assignments
WHERE task_id = b_task_id AND
assignee_role <> 'OWNER';
select contact_id
from jtf_task_contacts
where task_id = p_object_id
and (primary_flag is null or primary_flag = 'Y')
order by primary_flag;
SELECT tb.source_object_type_code
FROM jtf_object_usages ou,
jtf_tasks_b tb
WHERE
tb.task_id = b_task_id and
ou.object_user_code = 'NOTES' and
ou.object_code = tb.source_object_type_code;
SAVEPOINT update_task_savepoint;
e. if task_Rec_tbl.count > 1 => multi-select mode
f. if multi-select mode, we should ignore some of the parameters (per reqmnt).
g. loop through l_task_rec_tbl and call update_task for each task_id - do not --commit.
g1. break out of loop if any update_task fails.
h. if all task items were updated successfully - --commit.
i. if any task update fails, roll back and return error message.
*/
--INSERT INTO msista_Tmp values (20, 'entering for(p_action_input_data) loop');
Update Task:
Checked by Form:N/A
Checked by API:Task Status, Task Type
Close Task
Checked by Form: N/A
Checked by API:Task Status,Task Type
Reassign Task:
Checked by Form:Task Assignee
Checked by API: N/A
Reschedule Task:
Checked by Form: N/A
Checked by API: N/A
Transfer Task:
Checked by Form: Task Owner
Checked by API: N/A
*/
if (l_p_task_name is null) then
RAISE name_fail_exception;
if ((p_Action_Type = 'UPDATE_TASK' or p_Action_TYPE = 'CLOSE_TASK')
and (l_p_type is null or l_p_status is null)) then
-- ROLLBACK TO update_task_savepoint;
e. if task_Rec_tbl.count > 1 => multi-select mode
f. if multi-select mode, we should ignore some of the parameters (per reqmnt).
g. loop through l_task_rec_tbl and call update_task for each task_id - do not --commit.
g1. break out of loop if any update_task fails.
h. if all task items were updated successfully - --commit.
i. if any task update fails, roll back and return error message.
*/
-- task api uses g_miss* values for defaults
IF (l_p_task_name is NULL) THEN
--INSERT INTO msista_Tmp values (42, 'l_task_name is null');
SELECT object_version_number INTO l_object_version_number
FROM jtf_tasks_b WHERE task_id = l_task_rec_tbl(i).id;
jtf_tasks_pub.update_task(
p_api_version => l_api_version,
p_init_msg_list => G_FALSE,
p_commit => G_FALSE,
p_object_version_number => l_task_rec_tbl(i).object_version_number,
p_task_id => l_task_rec_tbl(i).id,
p_task_name => l_task_name,
p_task_type_name => l_type,
p_description => l_description,
p_task_status_name => l_status,
p_task_priority_name => l_priority,
p_owner_type_code => l_owner_type_code,
p_owner_id => l_owner_id,
p_planned_start_date => l_planned_start,
p_planned_end_date => l_planned_end,
p_scheduled_start_date => l_sched_start,
p_scheduled_end_date => l_sched_end,
p_actual_start_date => l_actual_start,
p_actual_end_date => l_actual_end,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
a. delete all existing assignments
b. assign task to specified assignee
c. --commit
*/
-- a
OPEN c_task_ass (l_task_rec_tbl(i).id);
jtf_task_assignments_pub.delete_task_assignment(
p_api_version => l_api_version,
p_object_version_number => l_exist_assign_ver,
p_init_msg_list => G_FALSE,
p_commit => G_FALSE,
p_task_assignment_id => l_exist_assign_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
, p_last_update_date => TO_DATE('1','j')
, p_last_updated_by => fnd_global.user_id
, p_creation_date => TO_DATE('1','j')
--, p_created_by => fnd_global.user_id
--, p_last_update_login => fnd_global.login_id
/*, p_attribute1 => NULL
, p_attribute2 => NULL
, p_attribute3 => NULL
, p_attribute4 => NULL
, p_attribute5 => NULL
, p_attribute6 => NULL
, p_attribute7 => NULL
, p_attribute8 => NULL
, p_attribute9 => NULL
, p_attribute10 => NULL
, p_attribute11 => NULL
, p_attribute12 => NULL
, p_attribute13 => NULL
, p_attribute14 => NULL
, p_attribute15 => NULL
, p_context => NULL
, p_note_type => NULL*/,
p_jtf_note_contexts_tab => l_note_ctxt_tbl
, p_entered_by => G_USER_ID
);
select count(source_object_id) into l_continue
from jtf_tasks_b
where task_id = l_task_rec_tbl(i).id;
select source_object_id into l_note_context_type_id
from jtf_tasks_b
where task_id = l_task_rec_tbl(i).id;
p_last_update_date => FND_API.G_MISS_DATE,
p_last_updated_by => G_USER_ID,
p_creation_date => FND_API.G_MISS_DATE,
p_note_context_type_id => l_note_context_type_id,
p_note_context_type => l_obj_type_code,
x_return_status => l_return_status,
x_note_context_id => l_context_id
);
select count(customer_id) into l_continue
from jtf_tasks_b
where task_id = l_task_rec_tbl(i).id;
select customer_id into l_note_context_type_id
from jtf_tasks_b
where task_id = l_task_rec_tbl(i).id;
p_last_update_date => FND_API.G_MISS_DATE,
p_last_updated_by => G_USER_ID,
p_creation_date => FND_API.G_MISS_DATE,
p_note_context_type_id => l_note_context_type_id,
p_note_context_type => 'PARTY',
x_return_status => l_return_status,
x_note_context_id => l_context_id
);
p_last_update_date => FND_API.G_MISS_DATE,
p_last_updated_by => G_USER_ID,
p_creation_date => FND_API.G_MISS_DATE,
p_note_context_type_id => l_note_context_type_id,
p_note_context_type => 'PARTY',
x_return_status => l_return_status,
x_note_context_id => l_context_id
);
select count(customer_id) into l_continue
from jtf_tasks_b
where task_id = l_task_rec_tbl(i).id;
select customer_id into l_note_context_type_id
from jtf_tasks_b
where task_id = l_task_rec_tbl(i).id;
p_last_update_date => FND_API.G_MISS_DATE,
p_last_updated_by => G_USER_ID,
p_creation_date => FND_API.G_MISS_DATE,
p_note_context_type_id => l_note_context_type_id,
p_note_context_type => 'PARTY',
x_return_status => l_return_status,
x_note_context_id => l_context_id
);
--INSERT INTO msista_Tmp values (74, 'create_note_context failed, ret_status - ' || l_return_status);
--INSERT INTO msista_Tmp values (74, 'create_note_context failed, msg_count - ' || l_msg_count);
--INSERT INTO msista_Tmp values (74, 'create_note_context failed, msg_data - ' || l_msg_data);
p_last_update_date => FND_API.G_MISS_DATE,
p_last_updated_by => G_USER_ID,
p_creation_date => FND_API.G_MISS_DATE,
p_note_context_type_id => l_note_context_type_id,
p_note_context_type => 'PARTY',
x_return_status => l_return_status,
x_note_context_id => l_context_id
);
select count(a.object_id) into l_continue
from hz_relationships a, hz_parties b
where b.party_type = 'PARTY_RELATIONSHIP'
and a.party_id in (select source_object_id
from jtf_tasks_b
where task_id = l_task_rec_tbl(i).id)
and a.party_id = b.party_id
and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DIRECTIONAL_FLAG = 'F';
select a.object_id into l_note_context_type_id
from hz_relationships a, hz_parties b
where b.party_type = 'PARTY_RELATIONSHIP'
and a.party_id in (select source_object_id
from jtf_tasks_b
where task_id = l_task_rec_tbl(i).id)
and a.party_id = b.party_id
and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DIRECTIONAL_FLAG = 'F';
p_last_update_date => FND_API.G_MISS_DATE,
p_last_updated_by => G_USER_ID,
p_creation_date => FND_API.G_MISS_DATE,
p_note_context_type_id => l_note_context_type_id,
p_note_context_type => 'PARTY',
x_return_status => l_return_status,
x_note_context_id => l_context_id
);
select count(a.subject_id) into l_continue
from hz_relationships a, hz_parties b
where b.party_type = 'PARTY_RELATIONSHIP'
and a.party_id = (select source_object_id
from jtf_tasks_b
where task_id = l_task_rec_tbl(i).id)
and a.party_id = b.party_id
and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DIRECTIONAL_FLAG = 'F';
select a.subject_id into l_note_context_type_id
from hz_relationships a, hz_parties b
where b.party_type = 'PARTY_RELATIONSHIP'
and a.party_id = (select source_object_id
from jtf_tasks_b
where task_id = l_task_rec_tbl(i).id)
and a.party_id = b.party_id
and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DIRECTIONAL_FLAG = 'F';
p_last_update_date => FND_API.G_MISS_DATE,
p_last_updated_by => G_USER_ID,
p_creation_date => FND_API.G_MISS_DATE,
p_note_context_type_id => l_note_context_type_id,
p_note_context_type => 'PARTY',
x_return_status => l_return_status,
x_note_context_id => l_context_id
);
fnd_message.set_name ('IEU', 'IEU_UPDATE_TASK_FAIL');
ROLLBACK TO update_task_savepoint;
fnd_message.set_name ('IEU', 'IEU_UPDATE_TASK_FAIL');
PROCEDURE UPDATE_TASK
( P_RESOURCE_ID IN NUMBER,
P_LANGUAGE IN VARCHAR2,
P_SOURCE_LANG IN VARCHAR2,
P_ACTION_KEY IN VARCHAR2,
P_ACTION_INPUT_DATA IN SYSTEM.ACTION_INPUT_DATA_NST,
X_UWQ_ACTION_LIST OUT NOCOPY SYSTEM.IEU_UWQ_WORK_ACTIONS_NST,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2,
X_RETURN_STATUS OUT NOCOPY VARCHAR2
)
IS
BEGIN
IEU_WPACTIONS_PVT.WP_TASK(P_RESOURCE_ID,
P_LANGUAGE ,
P_SOURCE_LANG,
P_ACTION_KEY ,
P_ACTION_INPUT_DATA ,
'UPDATE_TASK',
X_UWQ_ACTION_LIST ,
X_MSG_COUNT ,
X_MSG_DATA ,
X_RETURN_STATUS);
END UPDATE_TASK; -- PROCEDURE UPDATE_TASK