eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_APPROVAL_ACTION_PUB dependencies on WF_NOTIFICATION

Line 2215: from WF_NOTIFICATIONS wfn

2211: +-----------------------------------------------------------------------*/
2212:
2213: CURSOR get_notification_id_cur(l_loan_number VARCHAR2, P_MESSAGE_NAME VARCHAR2, P_CURRENT_APPROVER VARCHAR2) IS
2214: select wfn.notification_id
2215: from WF_NOTIFICATIONS wfn
2216: where item_key like l_loan_number
2217: and message_name = P_MESSAGE_NAME
2218: and recipient_role = P_CURRENT_APPROVER
2219: and status = 'OPEN';

Line 2287: WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'RESULT',l_action_type);

2283:
2284: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Notification Id fetched - '|| l_notification_id);
2285: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Before completing the notification activity');
2286:
2287: WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'RESULT',l_action_type);
2288: --Test code to check whether following code captures the notes entered by the user--
2289: --WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'LNS_LOAN_NOTE',P_NOTES);
2290: WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'WF_NOTE',P_NOTES);
2291: --End Test Code

Line 2289: --WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'LNS_LOAN_NOTE',P_NOTES);

2285: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Before completing the notification activity');
2286:
2287: WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'RESULT',l_action_type);
2288: --Test code to check whether following code captures the notes entered by the user--
2289: --WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'LNS_LOAN_NOTE',P_NOTES);
2290: WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'WF_NOTE',P_NOTES);
2291: --End Test Code
2292:
2293: WF_NOTIFICATION.RESPOND(l_notification_id,P_NOTES,P_CURRENT_APPROVER);

Line 2290: WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'WF_NOTE',P_NOTES);

2286:
2287: WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'RESULT',l_action_type);
2288: --Test code to check whether following code captures the notes entered by the user--
2289: --WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'LNS_LOAN_NOTE',P_NOTES);
2290: WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'WF_NOTE',P_NOTES);
2291: --End Test Code
2292:
2293: WF_NOTIFICATION.RESPOND(l_notification_id,P_NOTES,P_CURRENT_APPROVER);
2294:

Line 2293: WF_NOTIFICATION.RESPOND(l_notification_id,P_NOTES,P_CURRENT_APPROVER);

2289: --WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'LNS_LOAN_NOTE',P_NOTES);
2290: WF_NOTIFICATION.SETATTRTEXT(l_notification_id,'WF_NOTE',P_NOTES);
2291: --End Test Code
2292:
2293: WF_NOTIFICATION.RESPOND(l_notification_id,P_NOTES,P_CURRENT_APPROVER);
2294:
2295: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'After completing the notification activity');
2296:
2297: