DBA Data[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on WF_NOTIFICATIONS

Line 2154: FROM WF_NOTIFICATIONS WFN

2150: l_ntf_id NUMBER;
2151:
2152: cursor task_ntf(c_task_id NUMBER,c_project_id NUMBER) IS
2153: SELECT max(notification_id) ntf_id
2154: FROM WF_NOTIFICATIONS WFN
2155: WHERE message_type = 'PATASKWF'
2156: AND status = 'OPEN'
2157: --bug 13395163
2158: --bug 14284485

Line 2320: update WF_NOTIFICATIONS

2316: fetch task_ntf into l_ntf_id;
2317: close task_ntf;
2318: if(l_ntf_id is not null)
2319: then
2320: update WF_NOTIFICATIONS
2321: set status = 'CLOSED'
2322: where notification_id = l_ntf_id ;
2323: end if;
2324:

Line 17119: FROM WF_NOTIFICATIONS WFN

17115: l_item_key pa_wf_processes.item_key%TYPE;
17116:
17117: cursor task_ntf(c_task_id NUMBER,c_project_id NUMBER) IS
17118: SELECT max(notification_id) ntf_id
17119: FROM WF_NOTIFICATIONS WFN
17120: WHERE message_type = 'PATASKWF'
17121: AND status = 'OPEN'
17122: --bug 13395163
17123: --bug 14284485

Line 17235: update WF_NOTIFICATIONS

17231: fetch task_ntf into l_ntf_id;
17232: close task_ntf;
17233: if(l_ntf_id is not null)
17234: then
17235: update WF_NOTIFICATIONS
17236: set status = 'CLOSED'
17237: where notification_id = l_ntf_id ;
17238: end if;
17239: