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_NOTIFICATION

Line 1657: FROM wf_notification_attr_resp_v

1653:
1654: If (l_notification_id is not null) then
1655: SELECT attribute_value
1656: into l_note
1657: FROM wf_notification_attr_resp_v
1658: WHERE group_id = l_notification_id
1659: AND attribute_name = 'NOTE';
1660: end if;
1661:

Line 1753: FROM wf_notification_attr_resp_v

1749:
1750: If l_notification_id is not null then
1751: SELECT attribute_value
1752: into l_note
1753: FROM wf_notification_attr_resp_v
1754: WHERE group_id = l_notification_id
1755: AND attribute_name = 'NOTE';
1756: end if;
1757:

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 1883: FROM wf_notification_attr_resp_v

1879: AND status = 'CANCELED';
1880:
1881: CURSOR c_response(p_group_id number) IS
1882: SELECT recipient_role, attribute_value
1883: FROM wf_notification_attr_resp_v
1884: WHERE group_id = p_group_id
1885: AND attribute_name = 'RESULT';
1886:
1887: CURSOR c_response_note(p_group_id number) IS

Line 1889: FROM wf_notification_attr_resp_v

1885: AND attribute_name = 'RESULT';
1886:
1887: CURSOR c_response_note(p_group_id number) IS
1888: SELECT attribute_value
1889: FROM wf_notification_attr_resp_v
1890: WHERE group_id = p_group_id
1891: AND attribute_name = 'NOTE';
1892:
1893: CURSOR c_responderid(p_responder VARCHAR2) 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 2433: SELECT nvl(max(wf.notification_id), -9995)

2429: END IF;
2430:
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

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 3246: l_result := wf_notification.GetAttrText

3242: 'l_notification_id '||l_notification_id );
3243: END IF;
3244:
3245:
3246: l_result := wf_notification.GetAttrText
3247: (l_notification_id, 'RESULT');
3248:
3249:
3250: IF (g_asn_debug = 'Y') THEN

Line 3259: l_forwardTo := wf_notification.GetAttrText

3255:
3256:
3257: if (l_result = 'FORWARD') then --{
3258:
3259: l_forwardTo := wf_notification.GetAttrText
3260: (l_notification_id,
3261: 'FORWARD_TO_USERNAME_RESPONSE');
3262:
3263:

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: