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

Line 89: l_number := wf_notification.GETATTRNUMBER(p_nid, p_attname);

85: l_number NUMBER;
86: BEGIN
87: l_number := null;
88: BEGIN
89: l_number := wf_notification.GETATTRNUMBER(p_nid, p_attname);
90: EXCEPTION WHEN OTHERS THEN
91: NULL;
92: END;
93: return l_number;

Line 104: l_text := wf_notification.GETATTRTEXT(p_nid, p_attname);

100: l_text VARCHAR2(1000);
101: BEGIN
102: l_text := null;
103: BEGIN
104: l_text := wf_notification.GETATTRTEXT(p_nid, p_attname);
105: EXCEPTION WHEN OTHERS THEN
106: NULL;
107: END;
108: return l_text;

Line 725: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

721:
722:
723: CURSOR GET_RESPONSE_ATTR IS
724: select WMA.NAME,WMA.DISPLAY_NAME, WL.meaning
725: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
726: WF_MESSAGE_ATTRIBUTES_VL WMA , WF_LOOKUPS WL
727: where WNA.NOTIFICATION_ID = wf_engine.context_nid
728: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
729: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 740: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

736: and decode(wma.name,'RESULT','RESULT','NORESULT') = 'NORESULT'
737: union
738: select WMA.NAME,WMA.DISPLAY_NAME, decode(wma.type,'VARCHAR2',wna.text_value,'NUMBER',
739: to_char(wna.number_value),'DATE',to_char(wna.date_value))
740: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
741: WF_MESSAGE_ATTRIBUTES_VL WMA
742: where WNA.NOTIFICATION_ID = wf_engine.context_nid
743: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
744: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 753: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

749: and decode(wma.name,'RESULT','RESULT','NORESULT') = 'NORESULT';
750:
751: CURSOR GET_USER_RESPONSE_RESULT IS
752: select WL.LOOKUP_CODE,WMA.DISPLAY_NAME, WL.meaning
753: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
754: WF_MESSAGE_ATTRIBUTES_VL WMA , WF_LOOKUPS WL
755: where WNA.NOTIFICATION_ID = wf_engine.context_nid
756: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
757: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 949: wf_notification.cancel(lp_notification_id);

945: and activity_status ='NOTIFIED';
946:
947:
948: if lp_notification_id is not null and lp_notification_id > 0 then
949: wf_notification.cancel(lp_notification_id);
950:
951: end if;
952:
953:

Line 1080: -- Bug 4190367 : Modifying to make use of wf_notification.getattrtext to populate Evidence store id.

1076: IF (l_ERROR_NUM > 0 ) THEN
1077: RAISE EDR_PSIG_DOC_ERR;
1078: END IF;
1079:
1080: -- Bug 4190367 : Modifying to make use of wf_notification.getattrtext to populate Evidence store id.
1081: /*
1082: EDR_PSIG.postSignature(P_DOCUMENT_ID => l_doc_id,
1083: P_EVIDENCE_STORE_ID => wf_notification.getattrtext(wf_engine.context_nid,'#WF_SIG_ID'),
1084: P_USER_NAME => WF_ENGINE.context_text,

Line 1083: P_EVIDENCE_STORE_ID => wf_notification.getattrtext(wf_engine.context_nid,'#WF_SIG_ID'),

1079:
1080: -- Bug 4190367 : Modifying to make use of wf_notification.getattrtext to populate Evidence store id.
1081: /*
1082: EDR_PSIG.postSignature(P_DOCUMENT_ID => l_doc_id,
1083: P_EVIDENCE_STORE_ID => wf_notification.getattrtext(wf_engine.context_nid,'#WF_SIG_ID'),
1084: P_USER_NAME => WF_ENGINE.context_text,
1085: P_USER_RESPONSE => GET_USER_RESPONSE_RESULT_REC.MEANING,
1086: P_SIGNATURE_ID => l_SIGNATURE_id,
1087: P_ORIGINAL_RECIPIENT => l_ORIGINAL_RECIPIENT,

Line 1094: P_EVIDENCE_STORE_ID => wf_notification.getattrtext(wf_engine.context_nid,'#WF_SIG_ID'),

1090: */
1091:
1092:
1093: EDR_PSIG.postSignature(P_DOCUMENT_ID => l_doc_id,
1094: P_EVIDENCE_STORE_ID => wf_notification.getattrtext(wf_engine.context_nid,'#WF_SIG_ID'),
1095: P_USER_NAME => WF_ENGINE.context_text,
1096: P_USER_RESPONSE => GET_USER_RESPONSE_RESULT_REC.MEANING,
1097: P_SIGNATURE_ID => l_SIGNATURE_id,
1098: P_ORIGINAL_RECIPIENT => l_ORIGINAL_RECIPIENT,

Line 1143: wf_notification.getinfo(

1139: END IF;
1140: CLOSE GET_USER_RESPONSE_RESULT;
1141:
1142: /* Capture Current Notification Responder BUG Fix 2903607 SKARIMIS*/
1143: wf_notification.getinfo(
1144: NID =>wf_engine.context_nid,
1145: ROLE =>L_NTF_RESPOND_ROLE,
1146: MESSAGE_TYPE =>L_NTF_MESSAGE_TYPE,
1147: MESSAGE_NAME =>L_NTF_MESSAGE_NAME,

Line 1200: wf_notification.getinfo(

1196:
1197: END IF; -- RUN function ends
1198:
1199: IF (p_funcmode ='TIMEOUT') then
1200: wf_notification.getinfo(
1201: NID =>wf_engine.context_nid,
1202: ROLE =>L_NTF_RESPOND_ROLE,
1203: MESSAGE_TYPE =>L_NTF_MESSAGE_TYPE,
1204: MESSAGE_NAME =>L_NTF_MESSAGE_NAME,

Line 1561: '#WF_NOTIFICATION_TIMEOUT',

1557: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION'));
1558:
1559: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1560: l_item_key,
1561: '#WF_NOTIFICATION_TIMEOUT',
1562: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'#WF_NOTIFICATION_TIMEOUT'));
1563: /* SKARIMIS Added Resend count */
1564:
1565: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,

Line 1562: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'#WF_NOTIFICATION_TIMEOUT'));

1558:
1559: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1560: l_item_key,
1561: '#WF_NOTIFICATION_TIMEOUT',
1562: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'#WF_NOTIFICATION_TIMEOUT'));
1563: /* SKARIMIS Added Resend count */
1564:
1565: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1566: l_item_key,

Line 1571: '#WF_NOTIFICATION_TIMEOUT_HR',

1567: 'TIMEOUT_RESEND_COUNT',
1568: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TIMEOUT_RESEND_COUNT'));
1569: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1570: l_item_key,
1571: '#WF_NOTIFICATION_TIMEOUT_HR',
1572: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'#WF_NOTIFICATION_TIMEOUT')/60);
1573:
1574: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype, l_item_key,'PSIG_DOCUMENT_ID',
1575: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_DOCUMENT_ID'));

Line 1572: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'#WF_NOTIFICATION_TIMEOUT')/60);

1568: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TIMEOUT_RESEND_COUNT'));
1569: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1570: l_item_key,
1571: '#WF_NOTIFICATION_TIMEOUT_HR',
1572: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'#WF_NOTIFICATION_TIMEOUT')/60);
1573:
1574: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype, l_item_key,'PSIG_DOCUMENT_ID',
1575: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_DOCUMENT_ID'));
1576:

Line 1817: '#WF_NOTIFICATION_TIMEOUT',

1813: l_wf_timeout := round(l_wf_timeout * 60);
1814:
1815: SET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype,
1816: p_itemkey,
1817: '#WF_NOTIFICATION_TIMEOUT',
1818: l_wf_timeout);
1819:
1820: SET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype,
1821: p_itemkey,