APPS.JTF_TASK_TEMPLATES_PVT dependencies on JTF_TASKS_B

Line 229: l_task_id jtf_tasks_b.task_id%TYPE

225: l_api_version CONSTANT NUMBER := 1.0;
226: l_api_name CONSTANT VARCHAR2(30)
227: := 'CREATE_TASK_TEMPLATES';
228: l_rowid ROWID;
229: l_task_id jtf_tasks_b.task_id%TYPE
230: := p_task_id;
231: l_task_number jtf_tasks_b.task_number%TYPE;
232: l_task_type_id jtf_tasks_b.task_type_id%TYPE
233: := p_task_type_id;

Line 231: l_task_number jtf_tasks_b.task_number%TYPE;

227: := 'CREATE_TASK_TEMPLATES';
228: l_rowid ROWID;
229: l_task_id jtf_tasks_b.task_id%TYPE
230: := p_task_id;
231: l_task_number jtf_tasks_b.task_number%TYPE;
232: l_task_type_id jtf_tasks_b.task_type_id%TYPE
233: := p_task_type_id;
234: l_task_status_id jtf_tasks_b.task_status_id%TYPE
235: := p_task_status_id;

Line 232: l_task_type_id jtf_tasks_b.task_type_id%TYPE

228: l_rowid ROWID;
229: l_task_id jtf_tasks_b.task_id%TYPE
230: := p_task_id;
231: l_task_number jtf_tasks_b.task_number%TYPE;
232: l_task_type_id jtf_tasks_b.task_type_id%TYPE
233: := p_task_type_id;
234: l_task_status_id jtf_tasks_b.task_status_id%TYPE
235: := p_task_status_id;
236: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE

Line 234: l_task_status_id jtf_tasks_b.task_status_id%TYPE

230: := p_task_id;
231: l_task_number jtf_tasks_b.task_number%TYPE;
232: l_task_type_id jtf_tasks_b.task_type_id%TYPE
233: := p_task_type_id;
234: l_task_status_id jtf_tasks_b.task_status_id%TYPE
235: := p_task_status_id;
236: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE
237: := p_task_priority_id;
238: l_duration jtf_tasks_b.duration%TYPE

Line 236: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE

232: l_task_type_id jtf_tasks_b.task_type_id%TYPE
233: := p_task_type_id;
234: l_task_status_id jtf_tasks_b.task_status_id%TYPE
235: := p_task_status_id;
236: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE
237: := p_task_priority_id;
238: l_duration jtf_tasks_b.duration%TYPE
239: := p_duration;
240: l_duration_uom jtf_tasks_b.duration_uom%TYPE

Line 238: l_duration jtf_tasks_b.duration%TYPE

234: l_task_status_id jtf_tasks_b.task_status_id%TYPE
235: := p_task_status_id;
236: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE
237: := p_task_priority_id;
238: l_duration jtf_tasks_b.duration%TYPE
239: := p_duration;
240: l_duration_uom jtf_tasks_b.duration_uom%TYPE
241: := p_duration_uom;
242: l_planned_effort jtf_tasks_b.planned_effort%TYPE

Line 240: l_duration_uom jtf_tasks_b.duration_uom%TYPE

236: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE
237: := p_task_priority_id;
238: l_duration jtf_tasks_b.duration%TYPE
239: := p_duration;
240: l_duration_uom jtf_tasks_b.duration_uom%TYPE
241: := p_duration_uom;
242: l_planned_effort jtf_tasks_b.planned_effort%TYPE
243: := p_planned_effort;
244: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE

Line 242: l_planned_effort jtf_tasks_b.planned_effort%TYPE

238: l_duration jtf_tasks_b.duration%TYPE
239: := p_duration;
240: l_duration_uom jtf_tasks_b.duration_uom%TYPE
241: := p_duration_uom;
242: l_planned_effort jtf_tasks_b.planned_effort%TYPE
243: := p_planned_effort;
244: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE
245: := p_planned_effort_uom;
246: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%TYPE

Line 244: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE

240: l_duration_uom jtf_tasks_b.duration_uom%TYPE
241: := p_duration_uom;
242: l_planned_effort jtf_tasks_b.planned_effort%TYPE
243: := p_planned_effort;
244: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE
245: := p_planned_effort_uom;
246: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%TYPE
247: := p_task_confirmation_status;
248:

Line 246: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%TYPE

242: l_planned_effort jtf_tasks_b.planned_effort%TYPE
243: := p_planned_effort;
244: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE
245: := p_planned_effort_uom;
246: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%TYPE
247: := p_task_confirmation_status;
248:
249: CURSOR c_jtf_tasks (l_rowid IN ROWID)
250: IS