DBA Data[Home] [Help]

APPS.JTF_TASK_TEMPLATES_PUB dependencies on JTF_TASKS_B

Line 245: l_task_id jtf_tasks_b.task_id%TYPE;

241: )
242: IS
243: l_api_version CONSTANT NUMBER := 1.0;
244: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_TEMPLATES';
245: l_task_id jtf_tasks_b.task_id%TYPE;
246: l_task_number jtf_tasks_b.task_number%TYPE;
247: l_task_name jtf_tasks_tl.task_name%TYPE := p_task_name;
248: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
249: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;

Line 246: l_task_number jtf_tasks_b.task_number%TYPE;

242: IS
243: l_api_version CONSTANT NUMBER := 1.0;
244: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_TEMPLATES';
245: l_task_id jtf_tasks_b.task_id%TYPE;
246: l_task_number jtf_tasks_b.task_number%TYPE;
247: l_task_name jtf_tasks_tl.task_name%TYPE := p_task_name;
248: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
249: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
250: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;

Line 248: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;

244: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_TEMPLATES';
245: l_task_id jtf_tasks_b.task_id%TYPE;
246: l_task_number jtf_tasks_b.task_number%TYPE;
247: l_task_name jtf_tasks_tl.task_name%TYPE := p_task_name;
248: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
249: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
250: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
251: l_dependency_id jtf_task_depends.dependency_id%TYPE;
252: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;

Line 249: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;

245: l_task_id jtf_tasks_b.task_id%TYPE;
246: l_task_number jtf_tasks_b.task_number%TYPE;
247: l_task_name jtf_tasks_tl.task_name%TYPE := p_task_name;
248: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
249: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
250: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
251: l_dependency_id jtf_task_depends.dependency_id%TYPE;
252: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;
253: l_task_rec jtf_task_recurrences_pub.task_details_rec;

Line 250: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;

246: l_task_number jtf_tasks_b.task_number%TYPE;
247: l_task_name jtf_tasks_tl.task_name%TYPE := p_task_name;
248: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
249: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
250: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
251: l_dependency_id jtf_task_depends.dependency_id%TYPE;
252: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;
253: l_task_rec jtf_task_recurrences_pub.task_details_rec;
254: l_task_group_id jtf_task_templates_b.task_group_id%TYPE;

Line 1705: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;

1701: )
1702: is
1703: l_api_version CONSTANT NUMBER := 1.0;
1704: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK';
1705: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
1706: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
1707: BEGIN
1708:
1709: SAVEPOINT delete_task_pub;

Line 1706: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;

1702: is
1703: l_api_version CONSTANT NUMBER := 1.0;
1704: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK';
1705: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
1706: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
1707: BEGIN
1708:
1709: SAVEPOINT delete_task_pub;
1710: