DBA Data[Home] [Help]

APPS.LNS_WORK_FLOW dependencies on WF_NOTIFICATION

Line 121: from wf_notifications

117: +-----------------------------------------------------------------------*/
118:
119: CURSOR csr_notification (p_itemtype varchar2, p_itemkey varchar2) IS
120: select NOTIFICATION_ID, responder
121: from wf_notifications
122: where MESSAGE_TYPE = p_itemtype and
123: ITEM_KEY = p_itemkey;
124:
125: CURSOR csr_user_id (p_user_name varchar2) IS

Line 1436: l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE;

1432: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1433: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;
1434: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;
1435: l_return_status Varchar2(1);
1436: l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE;
1437: l_search_criteria LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;
1438: l_current_user_name fnd_user.user_name%TYPE;
1439:
1440: /*-----------------------------------------------------------------------+

Line 1451: FROM WF_NOTIFICATIONS

1447: WHERE fndu.user_id = current_user_id;
1448:
1449: CURSOR get_notifications_for_close(search_criteria varchar2) IS
1450: SELECT notification_id
1451: FROM WF_NOTIFICATIONS
1452: WHERE item_key like search_criteria
1453: AND message_name = 'MSG_LOAN_TO_BE_APPROVED'
1454: AND status = 'OPEN';
1455:

Line 1546: --wf_notification.close(l_notification_id,l_current_user_name);

1542: FETCH csr_current_user INTO l_current_user_name;
1543: CLOSE csr_current_user;
1544: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_current_user_name = ' || l_current_user_name );
1545:
1546: --wf_notification.close(l_notification_id,l_current_user_name);
1547: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before setting Approve programmatically');
1548: --test_proc('Before setting Approve programmatically');
1549: wf_notification.setattrtext ( nid => l_notification_id
1550: , aname => 'RESULT'

Line 1549: wf_notification.setattrtext ( nid => l_notification_id

1545:
1546: --wf_notification.close(l_notification_id,l_current_user_name);
1547: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before setting Approve programmatically');
1548: --test_proc('Before setting Approve programmatically');
1549: wf_notification.setattrtext ( nid => l_notification_id
1550: , aname => 'RESULT'
1551: , avalue => 'APPROVE' );
1552: wf_notification.respond ( nid => l_notification_id
1553: , respond_comment => null

Line 1552: wf_notification.respond ( nid => l_notification_id

1548: --test_proc('Before setting Approve programmatically');
1549: wf_notification.setattrtext ( nid => l_notification_id
1550: , aname => 'RESULT'
1551: , avalue => 'APPROVE' );
1552: wf_notification.respond ( nid => l_notification_id
1553: , respond_comment => null
1554: , responder => l_current_user_name );
1555: LogMessage(FND_LOG.LEVEL_STATEMENT, 'After responding programmatically');
1556: --test_proc('After responding programmatically');