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_ENGINE

Line 47: return wf_engine.getitemattrnumber(p_itemtype, p_itemkey,p_attname, TRUE);

43: RETURN NUMBER
44: IS
45: BEGIN
46:
47: return wf_engine.getitemattrnumber(p_itemtype, p_itemkey,p_attname, TRUE);
48: END GET_WF_ITEM_ATTRIBUTE_NUMBER;
49:
50: -- returns wf text item attribute
51: FUNCTION GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype varchar2, p_itemkey varchar2,

Line 57: return wf_engine.getitemattrtext(p_itemtype, p_itemkey,p_attname, TRUE);

53: RETURN VARCHAR2
54: IS
55: BEGIN
56:
57: return wf_engine.getitemattrtext(p_itemtype, p_itemkey,p_attname, TRUE);
58: END GET_WF_ITEM_ATTRIBUTE_TEXT;
59:
60: -- sets wf number item attribute
61: PROCEDURE SET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype varchar2, p_itemkey varchar2,

Line 65: wf_engine.setitemattrnumber(p_itemtype,p_itemkey,p_attname,p_attvalue);

61: PROCEDURE SET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype varchar2, p_itemkey varchar2,
62: p_attname varchar2, p_attvalue NUMBER)
63: IS
64: BEGIN
65: wf_engine.setitemattrnumber(p_itemtype,p_itemkey,p_attname,p_attvalue);
66: EXCEPTION WHEN OTHERS THEN
67: NULL;
68: END SET_WF_ITEM_ATTRIBUTE_NUMBER;
69:

Line 75: wf_engine.setitemattrtext(p_itemtype,p_itemkey,p_attname,p_attvalue);

71: PROCEDURE SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype varchar2, p_itemkey varchar2,
72: p_attname varchar2, p_attvalue varchar2)
73: IS
74: BEGIN
75: wf_engine.setitemattrtext(p_itemtype,p_itemkey,p_attname,p_attvalue);
76: EXCEPTION WHEN OTHERS THEN
77: NULL;
78: END SET_WF_ITEM_ATTRIBUTE_TEXT;
79:

Line 319: wf_engine.setitemAttrText(p_itemtype, p_itemkey,'REASON_CODE',null);

315: IS
316: BEGIN
317: IF (p_funcmode = 'RUN') THEN
318: /*
319: wf_engine.setitemAttrText(p_itemtype, p_itemkey,'REASON_CODE',null);
320: wf_engine.setitemAttrText(p_itemtype, p_itemkey,'WF_SIGNER_TYPE',null);
321: */
322: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE','PSIG_NONE');
323: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);

Line 320: wf_engine.setitemAttrText(p_itemtype, p_itemkey,'WF_SIGNER_TYPE',null);

316: BEGIN
317: IF (p_funcmode = 'RUN') THEN
318: /*
319: wf_engine.setitemAttrText(p_itemtype, p_itemkey,'REASON_CODE',null);
320: wf_engine.setitemAttrText(p_itemtype, p_itemkey,'WF_SIGNER_TYPE',null);
321: */
322: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE','PSIG_NONE');
323: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);
324: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE','AUTHOR');

Line 395: WF_ENGINE.ADDITEMATTR(itemtype => p_itemtype,

391: P_STATUS => 'CANCEL',
392: P_ERROR => l_error_num,
393: P_ERROR_MSG => l_error_mesg);
394: --Bug 3207385: Start
395: WF_ENGINE.ADDITEMATTR(itemtype => p_itemtype,
396: itemkey => p_itemkey,
397: aname => EDR_CONSTANTS_GRP.G_FINAL_DOCUMENT_STATUS,
398: text_value => EDR_CONSTANTS_GRP.G_CANCEL_STATUS);
399: --Bug 3207385: End

Line 475: l_voting_regime := wf_engine.GetitemAttrText

471: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
472: --Bug 4074173 : end
473:
474: --Bug 4577122: Start
475: l_voting_regime := wf_engine.GetitemAttrText
476: (p_itemtype, p_itemkey,'AME_VOTING_REGIME',
477: l_ignore_wfattr_notfound);
478: --Bug 4577122: End
479:

Line 514: WF_ENGINE.ADDITEMATTR(itemtype => p_itemtype,

510: P_ERROR => l_error_num,
511: P_ERROR_MSG => l_error_mesg);
512:
513: --Bug 3207385: Start
514: WF_ENGINE.ADDITEMATTR(itemtype => p_itemtype,
515: itemkey => p_itemkey,
516: aname => EDR_CONSTANTS_GRP.G_FINAL_DOCUMENT_STATUS,
517: text_value => EDR_CONSTANTS_GRP.G_COMPLETE_STATUS);
518: --Bug 3207385: End

Line 529: WF_ENGINE.ADDITEMATTR(itemtype => p_itemtype,

525: P_STATUS => 'REJECTED',
526: P_ERROR => l_error_num,
527: P_ERROR_MSG => l_error_mesg);
528: --Bug 3207385: Start
529: WF_ENGINE.ADDITEMATTR(itemtype => p_itemtype,
530: itemkey => p_itemkey,
531: aname => EDR_CONSTANTS_GRP.G_FINAL_DOCUMENT_STATUS,
532: text_value => L_SIGNATURE_STATUS);
533: --Bug 3207385: End

Line 551: WF_ENGINE.ADDITEMATTR(itemtype => p_itemtype,

547: P_STATUS => 'TIMEDOUT',
548: P_ERROR => l_error_num,
549: P_ERROR_MSG => l_error_mesg);
550: --Bug 3207385: Start
551: WF_ENGINE.ADDITEMATTR(itemtype => p_itemtype,
552: itemkey => p_itemkey,
553: aname => EDR_CONSTANTS_GRP.G_FINAL_DOCUMENT_STATUS,
554: text_value => L_SIGNATURE_STATUS);
555: --Bug 3207385: End

Line 727: where WNA.NOTIFICATION_ID = wf_engine.context_nid

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
730: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
731: and WNA.NAME = WMA.NAME

Line 742: where WNA.NOTIFICATION_ID = wf_engine.context_nid

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
745: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
746: and WNA.NAME = WMA.NAME

Line 755: where WNA.NOTIFICATION_ID = wf_engine.context_nid

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
758: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
759: and WNA.NAME = WMA.NAME

Line 868: l_voting_regime := wf_engine.GetitemAttrText

864:
865: --Bug 4074173 : end
866:
867: -- Bug 4577122: Start
868: l_voting_regime := wf_engine.GetitemAttrText
869: (p_itemtype, p_itemkey,'AME_VOTING_REGIME',
870: l_ignore_wfattr_notfound);
871: --Bug 4577122: End
872: -- Bug 5120197 : start

Line 879: -- Check if the recipient l_user_name is same as WF_ENGINE.CONTEXT_TEXT

875: FETCH signer_detail into l_original_recipient, l_user_name;
876: CLOSE signer_detail;
877:
878: -- Bug 3902969 : Start
879: -- Check if the recipient l_user_name is same as WF_ENGINE.CONTEXT_TEXT
880: -- if they are differnt then only call find wf ntf recipients API.
881:
882: IF( l_user_name = WF_ENGINE.CONTEXT_USER) THEN
883:

Line 882: IF( l_user_name = WF_ENGINE.CONTEXT_USER) THEN

878: -- Bug 3902969 : Start
879: -- Check if the recipient l_user_name is same as WF_ENGINE.CONTEXT_TEXT
880: -- if they are differnt then only call find wf ntf recipients API.
881:
882: IF( l_user_name = WF_ENGINE.CONTEXT_USER) THEN
883:
884: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',
885: p_itemtype,p_itemkey,
886: FND_MESSAGE.GET_STRING('EDR','EDR_EREC_REASSIGN_ERR'));

Line 895: l_SIGNER_TYPE := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'WF_SIGNER_TYPE');

891: -- Bug 5120197 : END
892:
893: IF (p_funcmode = 'RESPOND') THEN
894:
895: l_SIGNER_TYPE := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'WF_SIGNER_TYPE');
896: l_signer_reason := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'REASON_CODE');
897: IF l_signer_reason IS null OR l_SIGNER_TYPE IS NULL THEN
898: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
899: 'Signer Comment and Signing Reason code can not be null.');

Line 896: l_signer_reason := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'REASON_CODE');

892:
893: IF (p_funcmode = 'RESPOND') THEN
894:
895: l_SIGNER_TYPE := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'WF_SIGNER_TYPE');
896: l_signer_reason := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'REASON_CODE');
897: IF l_signer_reason IS null OR l_SIGNER_TYPE IS NULL THEN
898: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
899: 'Signer Comment and Signing Reason code can not be null.');
900: raise EDR_PSIG_NOT_NULL;

Line 911: L_RESPONSE_READ := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid, 'READ_RESPONSE');

907: IF GET_USER_RESPONSE_RESULT_REC.LOOKUP_CODE <> '#SIG_CANCEL' THEN
908: -- Begin Bug 3847779
909: -- The getattrtext has been wrapped in a being and end block to trap wf exception if
910: -- attribute is not found for previous notificaitons backward compitability.
911: L_RESPONSE_READ := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid, 'READ_RESPONSE');
912: -- End Bug 3847779
913: IF (L_RESPONSE_READ = 'N') THEN
914: WF_CORE.CONTEXT('EDR_PSIG_PAGE_FLOW', 'UPDATE_NOTIF_RESPONSE',p_itemtype, p_itemkey,
915: FND_MESSAGE.GET_STRING('EDR','EDR_EREC_NOT_REVIEWED_ERR'));

Line 948: WF_ENGINE.ITEMSTATUS ( itemtype => p_itemtype,

944: EXIT WHEN CURR_LIST_SIGNERS%NOTFOUND;
945:
946: lc_itemkey := lp_itemkey || '-' || SIGNER_LIST_REC.SIGNATURE_ID;
947:
948: WF_ENGINE.ITEMSTATUS ( itemtype => p_itemtype,
949: itemkey => lc_itemkey,
950: status => lp_status,
951: result => lp_result);
952:

Line 975: WF_ENGINE.ABORTPROCESS(itemtype => p_itemtype,

971:
972: end if;
973:
974:
975: WF_ENGINE.ABORTPROCESS(itemtype => p_itemtype,
976: itemkey => lc_itemkey
977: );
978:
979: end if;

Line 1008: l_psig_event := wf_engine.getItemAttrEvent(p_itemtype, p_itemkey,'#PSIG_EVENT');

1004:
1005: /* Following statements are to store data in PSIG evidance store */
1006: l_doc_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(l_item_type, l_item_key,'EDR_PSIG_DOC_ID');
1007: IF l_doc_id is null THEN
1008: l_psig_event := wf_engine.getItemAttrEvent(p_itemtype, p_itemkey,'#PSIG_EVENT');
1009: l_event_xml := l_psig_event.getEventData();
1010: l_event_name := l_psig_event.getEventName();
1011: l_event_key := l_psig_event.getEventKey();
1012: l_doc_id := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'PSIG_DOCUMENT_ID');

Line 1033: P_WF_NID => wf_engine.context_nid,

1029: P_PSIG_REQUESTER => GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER'),
1030: P_PSIG_SOURCE => GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SOURCE_APPLICATION_TYPE'),
1031: P_EVENT_NAME => l_event_name,
1032: P_EVENT_KEY => l_event_key,
1033: P_WF_NID => wf_engine.context_nid,
1034: P_DOCUMENT_ID => l_doc_id,
1035: P_ERROR => l_error_num,
1036: P_ERROR_MSG => L_ERROR_MESG);
1037: IF l_ERROR_NUM IS NOT NULL THEN

Line 1081: -- Check if the recipient l_user_name is same as WF_ENGINE.CONTEXT_TEXT

1077: FETCH signer_detail into l_original_recipient, l_user_name;
1078: CLOSE signer_detail;
1079:
1080: -- Bug 3902969 : Start
1081: -- Check if the recipient l_user_name is same as WF_ENGINE.CONTEXT_TEXT
1082: -- if they are differnt then only call find wf ntf recipients API.
1083:
1084: IF( l_user_name <> WF_ENGINE.CONTEXT_USER) THEN
1085:

Line 1084: IF( l_user_name <> WF_ENGINE.CONTEXT_USER) THEN

1080: -- Bug 3902969 : Start
1081: -- Check if the recipient l_user_name is same as WF_ENGINE.CONTEXT_TEXT
1082: -- if they are differnt then only call find wf ntf recipients API.
1083:
1084: IF( l_user_name <> WF_ENGINE.CONTEXT_USER) THEN
1085:
1086: EDR_STANDARD.FIND_WF_NTF_RECIPIENT(P_ORIGINAL_RECIPIENT => l_user_name,
1087: P_MESSAGE_TYPE => 'EDRPSIGF',
1088: P_MESSAGE_NAME => 'PSIG_EREC_MESSAGE_BLAF',

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 1105: P_USER_NAME => WF_ENGINE.context_text,

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,
1109: P_ERROR => l_error_num,

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 1116: P_USER_NAME => WF_ENGINE.context_text,

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,
1120: P_OVERRIDING_COMMENTS => l_overriding_comments,

Line 1165: NID =>wf_engine.context_nid,

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,
1169: PRIORITY =>L_NTF_PRIORITY,

Line 1184: WF_DIRECTORY.GETROLEDISPLAYNAME(WF_ENGINE.context_text));

1180:
1181:
1182: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,
1183: '#WF_SIGNER_ROLE_DISPLAY_NAME',
1184: WF_DIRECTORY.GETROLEDISPLAYNAME(WF_ENGINE.context_text));
1185: /* SKARIMIS Get the user List */
1186: OPEN GET_USER;
1187: LOOP
1188: fetch GET_USER into l_user;

Line 1223: NID =>wf_engine.context_nid,

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,
1227: PRIORITY =>L_NTF_PRIORITY,

Line 1290: l_voting_regime := wf_engine.GetitemAttrText

1286: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');
1287: --Bug 4074173 : end
1288:
1289: --Bug 4577122: Start
1290: l_voting_regime := wf_engine.GetitemAttrText
1291: (p_itemtype, p_itemkey,'AME_VOTING_REGIME',
1292: l_ignore_wfattr_notfound);
1293: --Bug 4577122: End
1294:

Line 1518: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

1514: l_item_key := p_itemkey ||'-'||SIGNER_LIST_REC.SIGNATURE_ID;
1515: --Bug 14762573 Not to create duplicate process for an existing one
1516: IF NOT WF_ITEM.Item_Exist(l_itemtype, l_item_key) THEN
1517: /* create the process */
1518: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
1519: itemkey => l_item_key,
1520: process => l_WorkflowProcess) ;
1521: /* set the item attributes */
1522:

Line 1524: l_voting_regime := wf_engine.GetitemAttrText

1520: process => l_WorkflowProcess) ;
1521: /* set the item attributes */
1522:
1523: --Bug 4577122: Start
1524: l_voting_regime := wf_engine.GetitemAttrText
1525: (p_itemtype, p_itemkey,'AME_VOTING_REGIME',
1526: l_ignore_wfattr_notfound);
1527:
1528: WF_ENGINE.ADDITEMATTR

Line 1528: WF_ENGINE.ADDITEMATTR

1524: l_voting_regime := wf_engine.GetitemAttrText
1525: (p_itemtype, p_itemkey,'AME_VOTING_REGIME',
1526: l_ignore_wfattr_notfound);
1527:
1528: WF_ENGINE.ADDITEMATTR
1529: (itemtype => l_itemtype,
1530: itemkey => l_item_key,
1531: aname => 'AME_VOTING_REGIME',
1532: text_value => l_voting_regime);

Line 1607: WF_ENGINE.SETITEMATTREVENT(itemtype => l_itemtype,itemkey => l_item_key,

1603: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1604: '#WF_SIGNER_ROLE' ,
1605: SIGNER_LIST_REC.USER_NAME);
1606: /* set the item attributes */
1607: WF_ENGINE.SETITEMATTREVENT(itemtype => l_itemtype,itemkey => l_item_key,
1608: name => '#PSIG_EVENT',
1609: event => wf_engine.GETITEMATTREVENT(p_itemtype, p_itemkey,'#PSIG_EVENT'));
1610: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,'#WF_ERECORD_TEXT',
1611: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ERECORD_TEXT'));

Line 1609: event => wf_engine.GETITEMATTREVENT(p_itemtype, p_itemkey,'#PSIG_EVENT'));

1605: SIGNER_LIST_REC.USER_NAME);
1606: /* set the item attributes */
1607: WF_ENGINE.SETITEMATTREVENT(itemtype => l_itemtype,itemkey => l_item_key,
1608: name => '#PSIG_EVENT',
1609: event => wf_engine.GETITEMATTREVENT(p_itemtype, p_itemkey,'#PSIG_EVENT'));
1610: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,'#WF_ERECORD_TEXT',
1611: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ERECORD_TEXT'));
1612:
1613: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

Line 1624: WF_ENGINE.ADDITEMATTR(itemtype => l_itemtype,itemkey => l_item_key,

1620: -- Bug: 3467353 - Start
1621:
1622: -- Bug 3903471 : Start
1623: BEGIN
1624: WF_ENGINE.ADDITEMATTR(itemtype => l_itemtype,itemkey => l_item_key,
1625: aname => 'EREC_TEMPLATE_TYPE',
1626: text_value => GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'EREC_TEMPLATE_TYPE'));
1627: EXCEPTION WHEN OTHERS THEN
1628: NULL;

Line 1657: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_item_key,

1653:
1654: --Bug 4122622: End
1655:
1656: /* Setting Patent Child association */
1657: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_item_key,
1658: parent_itemtype => p_itemtype,
1659: parent_itemkey=> p_itemkey,
1660: parent_context=> NULL);
1661: /* start the Workflow process */

Line 1665: wf_engine.setitemowner

1661: /* start the Workflow process */
1662:
1663:
1664: /* Set process Owner SKARIMIS for BLAF standard */
1665: wf_engine.setitemowner
1666: (ITEMTYPE=>l_itemtype,
1667: ITEMKEY=>l_item_key,
1668: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));
1669: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_item_key);

Line 1669: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_item_key);

1665: wf_engine.setitemowner
1666: (ITEMTYPE=>l_itemtype,
1667: ITEMKEY=>l_item_key,
1668: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));
1669: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_item_key);
1670: END IF; --Added by Bug 14762573 QZENG
1671: END LOOP;
1672: CLOSE CURR_LIST_SIGNERS;
1673: end if;

Line 1754: wf_engine.setitemowner

1750: --Bug 4160412: End
1751:
1752: IF p_funcmode='RUN' THEN
1753: /* Set process Owner SKARIMIS for BLAF standard */
1754: wf_engine.setitemowner
1755: (ITEMTYPE=>p_itemtype,
1756: ITEMKEY=>p_itemkey,
1757: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));
1758:

Line 1814: wf_engine.setitemattrtext(itemtype => p_itemtype,

1810:
1811: -- BUG 3271711 : Start Calling FND_DATE.DATE_TO_DISPLAYDT with server timezone
1812: -- Commenting the orignal code
1813: /*
1814: wf_engine.setitemattrtext(itemtype => p_itemtype,
1815: itemkey => p_itemkey,
1816: aname =>'PSIG_TIMESTAMP' ,
1817: avalue => FND_DATE.DATE_TO_DISPLAYDT(l_document_rec.PSIG_TIMESTAMP));
1818: */

Line 2115: l_psig_event := wf_engine.getItemAttrEvent(p_itemtype, p_itemkey,'#PSIG_EVENT');

2111: l_param_list WF_PARAMETER_LIST_T;
2112:
2113: BEGIN
2114:
2115: l_psig_event := wf_engine.getItemAttrEvent(p_itemtype, p_itemkey,'#PSIG_EVENT');
2116:
2117: l_orig_event_name := l_psig_event.getEventName();
2118:
2119: l_orig_event_key := l_psig_Event.getEventKey();

Line 2157: FND_WF_ENGINE.COMPLETEACTIVITY(P_ITEMTYPE, P_ITEMKEY, P_CURRENT_ACTIVITY , P_RESULT_CODE);

2153: IS
2154: PRAGMA AUTONOMOUS_TRANSACTION;
2155: BEGIN
2156: -- P_CURRENT_ACTIVITY => PSIG_ESIGN_SIGNER_LIST
2157: FND_WF_ENGINE.COMPLETEACTIVITY(P_ITEMTYPE, P_ITEMKEY, P_CURRENT_ACTIVITY , P_RESULT_CODE);
2158: COMMIT;
2159: EXCEPTION
2160: WHEN OTHERS THEN
2161: ROLLBACK;