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.POS_WCAPPROVE_PVT dependencies on WF_NOTIFICATIONS

Line 1878: FROM WF_NOTIFICATIONS

1874: ORDER BY activity_end_date DESC;
1875:
1876: CURSOR c_canceled_notif (p_notif_id number) IS
1877: SELECT '1'
1878: FROM WF_NOTIFICATIONS
1879: WHERE notification_id = p_notif_id
1880: AND status = 'CANCELED';
1881:
1882: CURSOR c_response(p_group_id number) IS

Line 1901: l_responder wf_notifications.responder%TYPE;

1897: WHERE wfu.name = p_responder
1898: AND wfu.orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
1899:
1900: l_api_name varchar2(50) := p_itemkey || ' update_approval_list_response';
1901: l_responder wf_notifications.responder%TYPE;
1902: l_recipient_role wf_notifications.recipient_role%TYPE;
1903:
1904: l_group_id NUMBER;
1905: l_role wf_notifications.recipient_role%TYPE;

Line 1902: l_recipient_role wf_notifications.recipient_role%TYPE;

1898: AND wfu.orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
1899:
1900: l_api_name varchar2(50) := p_itemkey || ' update_approval_list_response';
1901: l_responder wf_notifications.responder%TYPE;
1902: l_recipient_role wf_notifications.recipient_role%TYPE;
1903:
1904: l_group_id NUMBER;
1905: l_role wf_notifications.recipient_role%TYPE;
1906: l_response VARCHAR2(2000);

Line 1905: l_role wf_notifications.recipient_role%TYPE;

1901: l_responder wf_notifications.responder%TYPE;
1902: l_recipient_role wf_notifications.recipient_role%TYPE;
1903:
1904: l_group_id NUMBER;
1905: l_role wf_notifications.recipient_role%TYPE;
1906: l_response VARCHAR2(2000);
1907:
1908: l_approver_id NUMBER := NULL;
1909: l_orig_system wf_users.orig_system%TYPE;

Line 1995: FROM wf_notifications wfn

1991:
1992:
1993: SELECT wfn.responder, wfn.recipient_role, wfn.end_date
1994: INTO l_responder, l_recipient_role, l_response_end_date
1995: FROM wf_notifications wfn
1996: WHERE wfn.notification_id = l_group_id;
1997:
1998: IF (g_asn_debug = 'Y') THEN
1999: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 2401: l_original_recipient wf_notifications.original_recipient%TYPE;

2397: l_progress varchar2(300);
2398: l_notification_id number;
2399: l_comments varchar2(240) := null;
2400: l_original_recipient_id number;
2401: l_original_recipient wf_notifications.original_recipient%TYPE;
2402: l_recipient_role wf_notifications.recipient_role%TYPE;
2403: l_more_info_role wf_notifications.more_info_role%TYPE;
2404: l_responder_id number;
2405: l_more_origsys wf_roles.orig_system%TYPE;

Line 2402: l_recipient_role wf_notifications.recipient_role%TYPE;

2398: l_notification_id number;
2399: l_comments varchar2(240) := null;
2400: l_original_recipient_id number;
2401: l_original_recipient wf_notifications.original_recipient%TYPE;
2402: l_recipient_role wf_notifications.recipient_role%TYPE;
2403: l_more_info_role wf_notifications.more_info_role%TYPE;
2404: l_responder_id number;
2405: l_more_origsys wf_roles.orig_system%TYPE;
2406: l_more_origsysid wf_roles.orig_system_id%TYPE := null;

Line 2403: l_more_info_role wf_notifications.more_info_role%TYPE;

2399: l_comments varchar2(240) := null;
2400: l_original_recipient_id number;
2401: l_original_recipient wf_notifications.original_recipient%TYPE;
2402: l_recipient_role wf_notifications.recipient_role%TYPE;
2403: l_more_info_role wf_notifications.more_info_role%TYPE;
2404: l_responder_id number;
2405: l_more_origsys wf_roles.orig_system%TYPE;
2406: l_more_origsysid wf_roles.orig_system_id%TYPE := null;
2407: l_responder wf_notifications.responder%TYPE;

Line 2407: l_responder wf_notifications.responder%TYPE;

2403: l_more_info_role wf_notifications.more_info_role%TYPE;
2404: l_responder_id number;
2405: l_more_origsys wf_roles.orig_system%TYPE;
2406: l_more_origsysid wf_roles.orig_system_id%TYPE := null;
2407: l_responder wf_notifications.responder%TYPE;
2408:
2409:
2410: begin
2411: l_progress := 'POS_WCAPPROVE_PVT.Update_Action_history: 01.';

Line 2436: FROM wf_notifications wf,

2432:
2433: l_progress := 'POS_WCAPPROVE_PVT.Update_Action_history: 02.';
2434: SELECT nvl(max(wf.notification_id), -9995)
2435: into l_notification_id
2436: FROM wf_notifications wf,
2437: wf_item_activity_statuses wias
2438: WHERE wias.item_type = p_itemtype
2439: and wias.item_key = p_itemkey
2440: and wias.notification_id = wf.group_id;

Line 2455: FROM wf_notifications wfn

2451: SELECT wfn.responder, wfn.recipient_role,
2452: wfn.original_recipient, wfn.more_info_role
2453: INTO l_responder, l_recipient_role,
2454: l_original_recipient, l_more_info_role
2455: FROM wf_notifications wfn
2456: WHERE wfn.notification_id = l_notification_id;
2457:
2458: IF (g_asn_debug = 'Y') THEN
2459: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 3275: wf_notifications wfn

3271:
3272: SELECT fu.USER_ID
3273: INTO l_responder_id
3274: FROM fnd_user fu,
3275: wf_notifications wfn
3276: WHERE wfn.notification_id = l_notification_id
3277: AND wfn.original_recipient = fu.user_name;
3278:
3279: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 04.' ;

Line 4966: update wf_notifications set status = 'CLOSED'

4962: IF (g_asn_debug = 'Y') THEN
4963: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4964: l_api_name,'Enter in CloseOldNotif ' || l_progress);
4965: END IF;
4966: update wf_notifications set status = 'CLOSED'
4967: where notification_id in (
4968: select ias.notification_id
4969: from wf_item_activity_statuses ias,
4970: wf_notifications ntf

Line 4970: wf_notifications ntf

4966: update wf_notifications set status = 'CLOSED'
4967: where notification_id in (
4968: select ias.notification_id
4969: from wf_item_activity_statuses ias,
4970: wf_notifications ntf
4971: where ias.item_type = p_itemtype
4972: and ias.item_key = p_itemkey
4973: and ntf.notification_id = ias.notification_id);
4974: