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 867: l_voting_regime := wf_engine.GetitemAttrText

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

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

878: -- Bug 5120197 : END
879:
880: IF (p_funcmode = 'RESPOND') THEN
881:
882: l_SIGNER_TYPE := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'WF_SIGNER_TYPE');
883: l_signer_reason := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'REASON_CODE');
884: IF l_signer_reason IS null OR l_SIGNER_TYPE IS NULL THEN
885: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
886: 'Signer Comment and Signing Reason code can not be null.');

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

879:
880: IF (p_funcmode = 'RESPOND') THEN
881:
882: l_SIGNER_TYPE := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'WF_SIGNER_TYPE');
883: l_signer_reason := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'REASON_CODE');
884: IF l_signer_reason IS null OR l_SIGNER_TYPE IS NULL THEN
885: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
886: 'Signer Comment and Signing Reason code can not be null.');
887: raise EDR_PSIG_NOT_NULL;

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

894: IF GET_USER_RESPONSE_RESULT_REC.LOOKUP_CODE <> '#SIG_CANCEL' THEN
895: -- Begin Bug 3847779
896: -- The getattrtext has been wrapped in a being and end block to trap wf exception if
897: -- attribute is not found for previous notificaitons backward compitability.
898: L_RESPONSE_READ := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid, 'READ_RESPONSE');
899: -- End Bug 3847779
900: IF (L_RESPONSE_READ = 'N') THEN
901: WF_CORE.CONTEXT('EDR_PSIG_PAGE_FLOW', 'UPDATE_NOTIF_RESPONSE',p_itemtype, p_itemkey,
902: FND_MESSAGE.GET_STRING('EDR','EDR_EREC_NOT_REVIEWED_ERR'));

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

931: EXIT WHEN CURR_LIST_SIGNERS%NOTFOUND;
932:
933: lc_itemkey := lp_itemkey || '-' || SIGNER_LIST_REC.SIGNATURE_ID;
934:
935: WF_ENGINE.ITEMSTATUS ( itemtype => p_itemtype,
936: itemkey => lc_itemkey,
937: status => lp_status,
938: result => lp_result);
939:

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

950:
951: end if;
952:
953:
954: WF_ENGINE.ABORTPROCESS(itemtype => p_itemtype,
955: itemkey => lc_itemkey
956: );
957:
958: end if;

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

983:
984: /* Following statements are to store data in PSIG evidance store */
985: l_doc_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(l_item_type, l_item_key,'EDR_PSIG_DOC_ID');
986: IF l_doc_id is null THEN
987: l_psig_event := wf_engine.getItemAttrEvent(p_itemtype, p_itemkey,'#PSIG_EVENT');
988: l_event_xml := l_psig_event.getEventData();
989: l_event_name := l_psig_event.getEventName();
990: l_event_key := l_psig_event.getEventKey();
991: l_doc_id := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'PSIG_DOCUMENT_ID');

Line 1012: P_WF_NID => wf_engine.context_nid,

1008: P_PSIG_REQUESTER => GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER'),
1009: P_PSIG_SOURCE => GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SOURCE_APPLICATION_TYPE'),
1010: P_EVENT_NAME => l_event_name,
1011: P_EVENT_KEY => l_event_key,
1012: P_WF_NID => wf_engine.context_nid,
1013: P_DOCUMENT_ID => l_doc_id,
1014: P_ERROR => l_error_num,
1015: P_ERROR_MSG => L_ERROR_MESG);
1016: IF l_ERROR_NUM IS NOT NULL THEN

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

1056: FETCH signer_detail into l_original_recipient, l_user_name;
1057: CLOSE signer_detail;
1058:
1059: -- Bug 3902969 : Start
1060: -- Check if the recipient l_user_name is same as WF_ENGINE.CONTEXT_TEXT
1061: -- if they are differnt then only call find wf ntf recipients API.
1062:
1063: IF( l_user_name <> WF_ENGINE.CONTEXT_USER) THEN
1064:

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

1059: -- Bug 3902969 : Start
1060: -- Check if the recipient l_user_name is same as WF_ENGINE.CONTEXT_TEXT
1061: -- if they are differnt then only call find wf ntf recipients API.
1062:
1063: IF( l_user_name <> WF_ENGINE.CONTEXT_USER) THEN
1064:
1065: EDR_STANDARD.FIND_WF_NTF_RECIPIENT(P_ORIGINAL_RECIPIENT => l_user_name,
1066: P_MESSAGE_TYPE => 'EDRPSIGF',
1067: P_MESSAGE_NAME => 'PSIG_EREC_MESSAGE_BLAF',

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

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

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

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

Line 1144: NID =>wf_engine.context_nid,

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

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

1159:
1160:
1161: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,
1162: '#WF_SIGNER_ROLE_DISPLAY_NAME',
1163: WF_DIRECTORY.GETROLEDISPLAYNAME(WF_ENGINE.context_text));
1164: /* SKARIMIS Get the user List */
1165: OPEN GET_USER;
1166: LOOP
1167: fetch GET_USER into l_user;

Line 1201: NID =>wf_engine.context_nid,

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

Line 1268: l_voting_regime := wf_engine.GetitemAttrText

1264: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');
1265: --Bug 4074173 : end
1266:
1267: --Bug 4577122: Start
1268: l_voting_regime := wf_engine.GetitemAttrText
1269: (p_itemtype, p_itemkey,'AME_VOTING_REGIME',
1270: l_ignore_wfattr_notfound);
1271: --Bug 4577122: End
1272:

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

1491:
1492: l_item_key := p_itemkey ||'-'||SIGNER_LIST_REC.SIGNATURE_ID;
1493:
1494: /* create the process */
1495: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
1496: itemkey => l_item_key,
1497: process => l_WorkflowProcess) ;
1498: /* set the item attributes */
1499:

Line 1501: l_voting_regime := wf_engine.GetitemAttrText

1497: process => l_WorkflowProcess) ;
1498: /* set the item attributes */
1499:
1500: --Bug 4577122: Start
1501: l_voting_regime := wf_engine.GetitemAttrText
1502: (p_itemtype, p_itemkey,'AME_VOTING_REGIME',
1503: l_ignore_wfattr_notfound);
1504:
1505: WF_ENGINE.ADDITEMATTR

Line 1505: WF_ENGINE.ADDITEMATTR

1501: l_voting_regime := wf_engine.GetitemAttrText
1502: (p_itemtype, p_itemkey,'AME_VOTING_REGIME',
1503: l_ignore_wfattr_notfound);
1504:
1505: WF_ENGINE.ADDITEMATTR
1506: (itemtype => l_itemtype,
1507: itemkey => l_item_key,
1508: aname => 'AME_VOTING_REGIME',
1509: text_value => l_voting_regime);

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

1580: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1581: '#WF_SIGNER_ROLE' ,
1582: SIGNER_LIST_REC.USER_NAME);
1583: /* set the item attributes */
1584: WF_ENGINE.SETITEMATTREVENT(itemtype => l_itemtype,itemkey => l_item_key,
1585: name => '#PSIG_EVENT',
1586: event => wf_engine.GETITEMATTREVENT(p_itemtype, p_itemkey,'#PSIG_EVENT'));
1587: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,'#WF_ERECORD_TEXT',
1588: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ERECORD_TEXT'));

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

1582: SIGNER_LIST_REC.USER_NAME);
1583: /* set the item attributes */
1584: WF_ENGINE.SETITEMATTREVENT(itemtype => l_itemtype,itemkey => l_item_key,
1585: name => '#PSIG_EVENT',
1586: event => wf_engine.GETITEMATTREVENT(p_itemtype, p_itemkey,'#PSIG_EVENT'));
1587: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,'#WF_ERECORD_TEXT',
1588: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ERECORD_TEXT'));
1589:
1590: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

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

1597: -- Bug: 3467353 - Start
1598:
1599: -- Bug 3903471 : Start
1600: BEGIN
1601: WF_ENGINE.ADDITEMATTR(itemtype => l_itemtype,itemkey => l_item_key,
1602: aname => 'EREC_TEMPLATE_TYPE',
1603: text_value => GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'EREC_TEMPLATE_TYPE'));
1604: EXCEPTION WHEN OTHERS THEN
1605: NULL;

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

1630:
1631: --Bug 4122622: End
1632:
1633: /* Setting Patent Child association */
1634: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_item_key,
1635: parent_itemtype => p_itemtype,
1636: parent_itemkey=> p_itemkey,
1637: parent_context=> NULL);
1638: /* start the Workflow process */

Line 1642: wf_engine.setitemowner

1638: /* start the Workflow process */
1639:
1640:
1641: /* Set process Owner SKARIMIS for BLAF standard */
1642: wf_engine.setitemowner
1643: (ITEMTYPE=>l_itemtype,
1644: ITEMKEY=>l_item_key,
1645: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));
1646: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_item_key);

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

1642: wf_engine.setitemowner
1643: (ITEMTYPE=>l_itemtype,
1644: ITEMKEY=>l_item_key,
1645: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));
1646: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_item_key);
1647:
1648: END LOOP;
1649: CLOSE CURR_LIST_SIGNERS;
1650: end if;

Line 1731: wf_engine.setitemowner

1727: --Bug 4160412: End
1728:
1729: IF p_funcmode='RUN' THEN
1730: /* Set process Owner SKARIMIS for BLAF standard */
1731: wf_engine.setitemowner
1732: (ITEMTYPE=>p_itemtype,
1733: ITEMKEY=>p_itemkey,
1734: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));
1735:

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

1787:
1788: -- BUG 3271711 : Start Calling FND_DATE.DATE_TO_DISPLAYDT with server timezone
1789: -- Commenting the orignal code
1790: /*
1791: wf_engine.setitemattrtext(itemtype => p_itemtype,
1792: itemkey => p_itemkey,
1793: aname =>'PSIG_TIMESTAMP' ,
1794: avalue => FND_DATE.DATE_TO_DISPLAYDT(l_document_rec.PSIG_TIMESTAMP));
1795: */

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

2086: l_param_list WF_PARAMETER_LIST_T;
2087:
2088: BEGIN
2089:
2090: l_psig_event := wf_engine.getItemAttrEvent(p_itemtype, p_itemkey,'#PSIG_EVENT');
2091:
2092: l_orig_event_name := l_psig_event.getEventName();
2093:
2094: l_orig_event_key := l_psig_Event.getEventKey();

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

2128: IS
2129: PRAGMA AUTONOMOUS_TRANSACTION;
2130: BEGIN
2131: -- P_CURRENT_ACTIVITY => PSIG_ESIGN_SIGNER_LIST
2132: FND_WF_ENGINE.COMPLETEACTIVITY(P_ITEMTYPE, P_ITEMKEY, P_CURRENT_ACTIVITY , P_RESULT_CODE);
2133: COMMIT;
2134: EXCEPTION
2135: WHEN OTHERS THEN
2136: ROLLBACK;