APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on JTF_TASK_TYPES_B

Line 236: l_task_type_id jtf_task_types_b.task_type_id % type;

232: p_sr_ea_attr_val varchar2,
233: p_taskrec_table in out nocopy ea_task_table_type,
234: p_task_count in out nocopy number) is
235: --
236: l_task_type_id jtf_task_types_b.task_type_id % type;
237: l_sr_attr_op cug_tsk_typ_attr_deps_vl.sr_attribute_operator % type;
238: l_sr_attr_val_for_Task cug_tsk_typ_attr_deps_vl.sr_attribute_value % type;
239: l_sr_attr_val_for_Task1 cug_tsk_typ_attr_deps_vl.sr_attribute_value % type;
240: cursor c_sr_attr_tasks is

Line 261: l_rule jtf_task_types_b.rule % type;

257: where incident_type_id = p_incident_type_id
258: and sr_attribute_code = p_sr_ea_attr_code);
259: --
260: -- Cursor to get planned effort and UOM
261: l_rule jtf_task_types_b.rule % type;
262: l_planned_effort jtf_tasks_b.planned_effort % type;
263: l_planned_effort_uom jtf_tasks_b.planned_effort_uom % type;
264: l_workflow jtf_task_types_b.workflow % type;
265: l_workflow_type jtf_task_types_b.workflow_type % type;

Line 264: l_workflow jtf_task_types_b.workflow % type;

260: -- Cursor to get planned effort and UOM
261: l_rule jtf_task_types_b.rule % type;
262: l_planned_effort jtf_tasks_b.planned_effort % type;
263: l_planned_effort_uom jtf_tasks_b.planned_effort_uom % type;
264: l_workflow jtf_task_types_b.workflow % type;
265: l_workflow_type jtf_task_types_b.workflow_type % type;
266: cursor c_planned_effort is
267: select planned_effort, planned_effort_uom, rule, workflow, nvl(workflow_type,'JTFTASK')
268: from jtf_task_types_b

Line 265: l_workflow_type jtf_task_types_b.workflow_type % type;

261: l_rule jtf_task_types_b.rule % type;
262: l_planned_effort jtf_tasks_b.planned_effort % type;
263: l_planned_effort_uom jtf_tasks_b.planned_effort_uom % type;
264: l_workflow jtf_task_types_b.workflow % type;
265: l_workflow_type jtf_task_types_b.workflow_type % type;
266: cursor c_planned_effort is
267: select planned_effort, planned_effort_uom, rule, workflow, nvl(workflow_type,'JTFTASK')
268: from jtf_task_types_b
269: where task_type_id = l_task_type_id

Line 268: from jtf_task_types_b

264: l_workflow jtf_task_types_b.workflow % type;
265: l_workflow_type jtf_task_types_b.workflow_type % type;
266: cursor c_planned_effort is
267: select planned_effort, planned_effort_uom, rule, workflow, nvl(workflow_type,'JTFTASK')
268: from jtf_task_types_b
269: where task_type_id = l_task_type_id
270: /* and trunc(sysdate) between nvl(start_date_active,sysdate-1)
271: and nvl(end_date_active ,sysdate+1)*/
272: ;