DBA Data[Home] [Help]

APPS.PER_CHECKLIST_EVENTS dependencies on PER_ALLOCATED_TASKS

Line 305: per_allocated_tasks pat

301: 'Exists'
302: from
303: per_tasks_in_checklist tic,
304: per_allocated_checklists pac,
305: per_allocated_tasks pat
306: where
307: tic.task_in_checklist_id = p_task_in_checklist_id
308: and pac.person_id = p_person_id
309: and tic.checklist_id = pac.checklist_id

Line 933: update PER_ALLOCATED_TASKS

929: ,ignore_notfound => false
930: );
931: --
932: --
933: update PER_ALLOCATED_TASKS
934: set status = 'COM'
935: where ALLOCATED_TASK_ID = l_alloc_id;
936: --
937: resultout := l_alloc_id || 'COMPLETE';

Line 986: update PER_ALLOCATED_TASKS

982: ,aname => 'ALLOC_TASKID'
983: ,ignore_notfound => false
984: );
985: --
986: update PER_ALLOCATED_TASKS
987: set status = 'REJ'
988: where ALLOCATED_TASK_ID = l_alloc_id;
989: --
990: resultout := l_alloc_id || 'TASK_REJECTED';