APPS.PA_TASK_WORKFLOW_PKG dependencies on WF_NOTIFICATIONS

Line 1581: l_max_notification_id WF_NOTIFICATIONS.notification_id%TYPE;

1577: and not exists (select 1 from pa_tasks where task_id = pra.task_id and project_id = pra.project_id);
1578:
1579: l_unapproved_task_cnt NUMBER :=0;
1580: c_task_rec c_task_info%ROWTYPE;
1581: l_max_notification_id WF_NOTIFICATIONS.notification_id%TYPE;
1582: BEGIN
1583: log_message('Inside Verify_Task_Status',3);
1584: x_return_status := 'S';
1585:

Line 1606: FROM WF_NOTIFICATIONS WFN

1602: IF c_task_rec.task_status = 'SUBMITTED' THEN
1603: BEGIN
1604: SELECT max(notification_id)
1605: INTO l_max_notification_id
1606: FROM WF_NOTIFICATIONS WFN
1607: WHERE message_type = 'PATASKWF'
1608: AND status = 'OPEN'
1609: AND EXISTS (
1610: SELECT 1

Line 1628: UPDATE WF_NOTIFICATIONS

1624: WHEN OTHERS THEN
1625: NULL;
1626: END;
1627: IF l_max_notification_id IS NOT NULL THEN
1628: UPDATE WF_NOTIFICATIONS
1629: SET status = 'CLOSED'
1630: WHERE notification_id = l_max_notification_id;
1631: PA_TASK_WORKFLOW_PKG.Start_Task_Aprv_Wf (
1632: 'PATASKWF'