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 970: wf_notification.cancel(lp_notification_id);

966: raise;
967: END;
968:
969: if lp_notification_id is not null and lp_notification_id > 0 then
970: wf_notification.cancel(lp_notification_id);
971:
972: end if;
973:
974:

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

1097: IF (l_ERROR_NUM > 0 ) THEN
1098: RAISE EDR_PSIG_DOC_ERR;
1099: END IF;
1100:
1101: -- Bug 4190367 : Modifying to make use of wf_notification.getattrtext to populate Evidence store id.
1102: /*
1103: EDR_PSIG.postSignature(P_DOCUMENT_ID => l_doc_id,
1104: P_EVIDENCE_STORE_ID => wf_notification.getattrtext(wf_engine.context_nid,'#WF_SIG_ID'),
1105: P_USER_NAME => WF_ENGINE.context_text,

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

1100:
1101: -- Bug 4190367 : Modifying to make use of wf_notification.getattrtext to populate Evidence store id.
1102: /*
1103: EDR_PSIG.postSignature(P_DOCUMENT_ID => l_doc_id,
1104: P_EVIDENCE_STORE_ID => wf_notification.getattrtext(wf_engine.context_nid,'#WF_SIG_ID'),
1105: P_USER_NAME => WF_ENGINE.context_text,
1106: P_USER_RESPONSE => GET_USER_RESPONSE_RESULT_REC.MEANING,
1107: P_SIGNATURE_ID => l_SIGNATURE_id,
1108: P_ORIGINAL_RECIPIENT => l_ORIGINAL_RECIPIENT,

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

1111: */
1112:
1113:
1114: EDR_PSIG.postSignature(P_DOCUMENT_ID => l_doc_id,
1115: P_EVIDENCE_STORE_ID => wf_notification.getattrtext(wf_engine.context_nid,'#WF_SIG_ID'),
1116: P_USER_NAME => WF_ENGINE.context_text,
1117: P_USER_RESPONSE => GET_USER_RESPONSE_RESULT_REC.MEANING,
1118: P_SIGNATURE_ID => l_SIGNATURE_id,
1119: P_ORIGINAL_RECIPIENT => l_ORIGINAL_RECIPIENT,

Line 1164: wf_notification.getinfo(

1160: END IF;
1161: CLOSE GET_USER_RESPONSE_RESULT;
1162:
1163: /* Capture Current Notification Responder BUG Fix 2903607 SKARIMIS*/
1164: wf_notification.getinfo(
1165: NID =>wf_engine.context_nid,
1166: ROLE =>L_NTF_RESPOND_ROLE,
1167: MESSAGE_TYPE =>L_NTF_MESSAGE_TYPE,
1168: MESSAGE_NAME =>L_NTF_MESSAGE_NAME,

Line 1222: wf_notification.getinfo(

1218:
1219: END IF; -- RUN function ends
1220:
1221: IF (p_funcmode ='TIMEOUT') then
1222: wf_notification.getinfo(
1223: NID =>wf_engine.context_nid,
1224: ROLE =>L_NTF_RESPOND_ROLE,
1225: MESSAGE_TYPE =>L_NTF_MESSAGE_TYPE,
1226: MESSAGE_NAME =>L_NTF_MESSAGE_NAME,

Line 1584: '#WF_NOTIFICATION_TIMEOUT',

1580: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION'));
1581:
1582: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1583: l_item_key,
1584: '#WF_NOTIFICATION_TIMEOUT',
1585: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'#WF_NOTIFICATION_TIMEOUT'));
1586: /* SKARIMIS Added Resend count */
1587:
1588: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,

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

1581:
1582: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1583: l_item_key,
1584: '#WF_NOTIFICATION_TIMEOUT',
1585: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'#WF_NOTIFICATION_TIMEOUT'));
1586: /* SKARIMIS Added Resend count */
1587:
1588: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1589: l_item_key,

Line 1594: '#WF_NOTIFICATION_TIMEOUT_HR',

1590: 'TIMEOUT_RESEND_COUNT',
1591: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TIMEOUT_RESEND_COUNT'));
1592: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1593: l_item_key,
1594: '#WF_NOTIFICATION_TIMEOUT_HR',
1595: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'#WF_NOTIFICATION_TIMEOUT')/60);
1596:
1597: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype, l_item_key,'PSIG_DOCUMENT_ID',
1598: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_DOCUMENT_ID'));

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

1591: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TIMEOUT_RESEND_COUNT'));
1592: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1593: l_item_key,
1594: '#WF_NOTIFICATION_TIMEOUT_HR',
1595: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'#WF_NOTIFICATION_TIMEOUT')/60);
1596:
1597: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype, l_item_key,'PSIG_DOCUMENT_ID',
1598: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_DOCUMENT_ID'));
1599:

Line 1840: '#WF_NOTIFICATION_TIMEOUT',

1836: l_wf_timeout := round(l_wf_timeout * 60);
1837:
1838: SET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype,
1839: p_itemkey,
1840: '#WF_NOTIFICATION_TIMEOUT',
1841: l_wf_timeout);
1842:
1843: SET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype,
1844: p_itemkey,