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 1877: FROM WF_NOTIFICATIONS

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

Line 1900: l_responder wf_notifications.responder%TYPE;

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

Line 1901: l_recipient_role wf_notifications.recipient_role%TYPE;

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

Line 1904: l_role wf_notifications.recipient_role%TYPE;

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

Line 1994: FROM wf_notifications wfn

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

Line 2400: l_original_recipient wf_notifications.original_recipient%TYPE;

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

Line 2401: l_recipient_role wf_notifications.recipient_role%TYPE;

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

Line 2402: l_more_info_role wf_notifications.more_info_role%TYPE;

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

Line 2406: l_responder wf_notifications.responder%TYPE;

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

Line 2435: FROM wf_notifications wf,

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

Line 2454: FROM wf_notifications wfn

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

Line 4639: update wf_notifications set status = 'CLOSED'

4635: IF (g_asn_debug = 'Y') THEN
4636: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4637: l_api_name,'Enter in CloseOldNotif ' || l_progress);
4638: END IF;
4639: update wf_notifications set status = 'CLOSED'
4640: where notification_id in (
4641: select ias.notification_id
4642: from wf_item_activity_statuses ias,
4643: wf_notifications ntf

Line 4643: wf_notifications ntf

4639: update wf_notifications set status = 'CLOSED'
4640: where notification_id in (
4641: select ias.notification_id
4642: from wf_item_activity_statuses ias,
4643: wf_notifications ntf
4644: where ias.item_type = p_itemtype
4645: and ias.item_key = p_itemkey
4646: and ntf.notification_id = ias.notification_id);
4647: