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.PO_WF_PO_NOTIFICATION dependencies on WF_NOTIFICATION

Line 902: wf_notification.writetoclob(document, l_document);

898:
899: --
900: --curr_len := lengthb(l_document);
901:
902: wf_notification.writetoclob(document, l_document);
903:
904: l_document := NULL;
905:
906: EXIT WHEN i = l_num_records_to_display;

Line 1023: wf_notification.writetoclob(document, l_document);

1019:
1020: --
1021: -- curr_len := lengthb(l_document);
1022:
1023: wf_notification.writetoclob(document, l_document);
1024:
1025: l_document := NULL;
1026:
1027: EXIT WHEN i = l_num_records_to_display;

Line 1039: wf_notification.writetoclob(document, l_document); --

1035: -- 1036: --so call the function WriteToClob().
1037: curr_len := lengthb(l_document);
1038: IF (NVL(curr_len,0) > 0 ) THEN
1039: wf_notification.writetoclob(document, l_document); --
1040: END IF;
1041: -- document := l_document; --
1042:
1043: elsif (display_type = 'text/plain') then

Line 1128: wf_notification.writetoclob(document, l_document);

1124:
1125: -- < BUG 7006113 START >
1126: -- curr_len := lengthb(l_document);
1127:
1128: wf_notification.writetoclob(document, l_document);
1129:
1130: l_document := NULL;
1131:
1132: EXIT WHEN i = l_num_records_to_display;

Line 1194: wf_notification.writetoclob(document, l_document);

1190: --
1191: -- curr_len := lengthb(l_document);
1192:
1193:
1194: wf_notification.writetoclob(document, l_document);
1195:
1196: l_document := NULL;
1197:
1198: EXIT WHEN i = l_num_records_to_display;

Line 1209: wf_notification.writetoclob(document, l_document); --

1205: -- 1206: --so call the function WriteToClob().
1207: curr_len := lengthb(l_document);
1208: IF (NVL(curr_len,0) > 0 ) THEN
1209: wf_notification.writetoclob(document, l_document); --
1210: END IF;
1211: -- document := l_document; --
1212: end if;
1213:

Line 1699: l_original_recipient wf_notifications.original_recipient%TYPE;

1695: l_action po_action_history.action_code%TYPE;
1696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
1697: l_current_recipient_id wf_roles.orig_system_id%TYPE;
1698: l_origsys wf_roles.orig_system%TYPE;
1699: l_original_recipient wf_notifications.original_recipient%TYPE;
1700: l_current_recipient_role wf_notifications.recipient_role%TYPE;
1701:
1702: --Added the below variables as part of bug 14105414 fix.
1703: x_user_id number;

Line 1700: l_current_recipient_role wf_notifications.recipient_role%TYPE;

1696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
1697: l_current_recipient_id wf_roles.orig_system_id%TYPE;
1698: l_origsys wf_roles.orig_system%TYPE;
1699: l_original_recipient wf_notifications.original_recipient%TYPE;
1700: l_current_recipient_role wf_notifications.recipient_role%TYPE;
1701:
1702: --Added the below variables as part of bug 14105414 fix.
1703: x_user_id number;
1704: l_forward_to_username_response varchar2(100);

Line 1785: FROM wf_notifications

1781: BEGIN
1782: SELECT original_recipient,
1783: Decode(MORE_INFO_ROLE, NULL, RECIPIENT_ROLE,MORE_INFO_ROLE)
1784: INTO l_original_recipient, l_current_recipient_role
1785: FROM wf_notifications
1786: WHERE
1787: notification_id = WF_ENGINE.context_nid
1788: AND ( MORE_INFO_ROLE IS NOT NULL OR RECIPIENT_ROLE <> ORIGINAL_RECIPIENT );
1789:

Line 1889: wf_notifications wfn

1885:
1886: SELECT fu.USER_ID
1887: INTO l_responder_id
1888: FROM fnd_user fu,
1889: wf_notifications wfn
1890: WHERE wfn.notification_id = l_nid
1891: AND wfn.original_recipient = fu.user_name;
1892:
1893: --Start of code changes for updating the action code in the action history

Line 1897: l_respond_action_text := Wf_Notification.GetAttrText(l_nid, 'RESULT');

1893: --Start of code changes for updating the action code in the action history
1894: --as per the approver action.
1895: /* Get the current approver's response/action. Here it can be either FORWARD
1896: or APPROVE or APPROVE_AND_FORWARD or REJECT. */
1897: l_respond_action_text := Wf_Notification.GetAttrText(l_nid, 'RESULT');
1898:
1899: IF (g_po_wf_debug = 'Y') THEN
1900: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,
1901: 'l_respond_action_text: ' || l_respond_action_text);

Line 1936: l_forward_to_username_response := wf_notification.GetAttrText(l_nid, 'FORWARD_TO_USERNAME_RESPONSE');

1932: ** Then set the Forward-To to the one the user entered in the response.
1933: */
1934: /* NOTE: We take the value entered by the user and set it to ALL CAPITAL LETTERS!!!
1935: */
1936: l_forward_to_username_response := wf_notification.GetAttrText(l_nid, 'FORWARD_TO_USERNAME_RESPONSE');
1937:
1938: IF (g_po_wf_debug = 'Y') THEN
1939: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,
1940: 'l_forward_to_username_response: ' || l_forward_to_username_response);

Line 2147: l_note := wf_notification.GetAttrText(l_nid, 'NOTE_R');

2143: itemkey => itemkey,
2144: aname => 'DOCUMENT_TYPE');
2145:
2146: IF (l_doc_type='PO' OR l_doc_type='PA' OR l_doc_type='RELEASE' ) THEN
2147: l_note := wf_notification.GetAttrText(l_nid, 'NOTE_R');
2148: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
2149: itemkey => itemkey,
2150: aname => 'NOTE',
2151: avalue => l_note);

Line 2156: wf_notification.SetAttrText(l_nid, 'NOTE', l_note);

2152: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
2153: itemkey => itemkey,
2154: aname => 'NOTE_R',
2155: avalue => NULL);
2156: wf_notification.SetAttrText(l_nid, 'NOTE', l_note);
2157: wf_notification.SetAttrText(l_nid, 'NOTE_R', null);
2158: END IF;
2159:
2160: l_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 2157: wf_notification.SetAttrText(l_nid, 'NOTE_R', null);

2153: itemkey => itemkey,
2154: aname => 'NOTE_R',
2155: avalue => NULL);
2156: wf_notification.SetAttrText(l_nid, 'NOTE', l_note);
2157: wf_notification.SetAttrText(l_nid, 'NOTE_R', null);
2158: END IF;
2159:
2160: l_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2161: itemkey => itemkey,