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_ITEM

Line 41: FUNCTION GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype varchar2, p_itemkey varchar2,

37: -- Introducing new wrapper Apis for workflow and notification Apis to get and
38: -- set item attributes (number and text)
39:
40: -- returns wf number item attribute
41: FUNCTION GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype varchar2, p_itemkey varchar2,
42: p_attname varchar2)
43: RETURN NUMBER
44: IS
45: BEGIN

Line 48: END GET_WF_ITEM_ATTRIBUTE_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,
52: p_attname varchar2)

Line 51: FUNCTION GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype varchar2, p_itemkey varchar2,

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,
52: p_attname varchar2)
53: RETURN VARCHAR2
54: IS
55: BEGIN

Line 58: END GET_WF_ITEM_ATTRIBUTE_TEXT;

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,
62: p_attname varchar2, p_attvalue NUMBER)

Line 61: PROCEDURE SET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype varchar2, p_itemkey varchar2,

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,
62: p_attname varchar2, p_attvalue NUMBER)
63: IS
64: BEGIN
65: wf_engine.setitemattrnumber(p_itemtype,p_itemkey,p_attname,p_attvalue);

Line 68: END SET_WF_ITEM_ATTRIBUTE_NUMBER;

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:
70: -- sets wf text item attribute
71: PROCEDURE SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype varchar2, p_itemkey varchar2,
72: p_attname varchar2, p_attvalue varchar2)

Line 71: PROCEDURE SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype varchar2, p_itemkey varchar2,

67: NULL;
68: END SET_WF_ITEM_ATTRIBUTE_NUMBER;
69:
70: -- sets wf text item attribute
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);

Line 78: END SET_WF_ITEM_ATTRIBUTE_TEXT;

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:
80: -- returns workflow notification's number item attribute
81:
82: FUNCTION GET_NOTIF_ITEM_ATTR_NUMBER(p_nid NUMBER, p_attname VARCHAR2)

Line 128: l_eRecord_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype,p_itemkey,'EDR_PSIG_DOC_ID');

124: -- Bug #3368868 : Starts
125: -- Get the transaction status
126:
127: -- Bug 3903471 : Start
128: l_eRecord_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype,p_itemkey,'EDR_PSIG_DOC_ID');
129:
130: if l_eRecord_id is NULL THEN
131: l_eRecord_id := TO_NUMBER(GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID'),'999999999999.999999');
132: end if;

Line 131: l_eRecord_id := TO_NUMBER(GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID'),'999999999999.999999');

127: -- Bug 3903471 : Start
128: l_eRecord_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype,p_itemkey,'EDR_PSIG_DOC_ID');
129:
130: if l_eRecord_id is NULL THEN
131: l_eRecord_id := TO_NUMBER(GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID'),'999999999999.999999');
132: end if;
133:
134: l_trans_status := GET_TRANSACTIONSTATUS(l_eRecord_id) ;
135: -- Bug 3903471 : End

Line 145: L_POST_OP_API := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'POST_OPERATION_API');

141: -- Bug #3368868 : Starts
142: -- If transaction status is ERROR do not call post_op_api
143: IF l_trans_status <> 'ERROR' THEN
144: -- Bug #3368868 : Ends
145: L_POST_OP_API := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'POST_OPERATION_API');
146: END IF;
147:
148: IF nvl(L_POST_OP_API,'NONE') <> 'NONE' THEN
149: L_POST_OP_API := rtrim(L_POST_OP_API);

Line 322: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE','PSIG_NONE');

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');
325: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);
326:

Line 323: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);

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');
325: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);
326:
327: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'READ_RESPONSE','N');

Line 324: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE','AUTHOR');

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');
325: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);
326:
327: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'READ_RESPONSE','N');
328: p_resultout := 'COMPLETE:';

Line 325: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',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');
325: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);
326:
327: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'READ_RESPONSE','N');
328: p_resultout := 'COMPLETE:';
329: END IF;

Line 327: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'READ_RESPONSE','N');

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');
325: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);
326:
327: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'READ_RESPONSE','N');
328: p_resultout := 'COMPLETE:';
329: END IF;
330: EXCEPTION
331: WHEN OTHERS THEN

Line 372: l_doc_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID');

368: --Bug 3903471 : Start
369: --However #ERECORD_ID parameter is not used in older versions. Hence to
370: --support backward compatibility a conditional check would be provided.
371:
372: l_doc_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID');
373:
374: if l_doc_id is NULL THEN
375:
376: l_erecord_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#ERECORD_ID');

Line 376: l_erecord_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#ERECORD_ID');

372: l_doc_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID');
373:
374: if l_doc_id is NULL THEN
375:
376: l_erecord_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#ERECORD_ID');
377:
378: --Convert erecord id obtained in varchar2 to number format.
379: --To ensure that no problems occur in MLS environments appropriate number format is used.
380:

Line 409: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_STATUS','ERROR');

405: -- Modified Page flow status to 'ERROR'
406: -- As per cookbook get transaction status returns one of these
407: -- status ('SUCCESS','ERROR','REJECTED','PENDING','NOACTION')
408: -- based on this we need to send 'ERROR'
409: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_STATUS','ERROR');
410: p_resultout := 'COMPLETE:';
411: END IF;
412: EXCEPTION
413: WHEN EDR_PSIG_DOC_ERR THEN

Line 469: L_CURR_MODE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE');

465:
466: BEGIN
467:
468: --Bug 4074173 : start
469: L_CURR_MODE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE');
470: L_DEFER_MODE_ALLOWED := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED');
471: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
472: --Bug 4074173 : end
473:

Line 470: L_DEFER_MODE_ALLOWED := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED');

466: BEGIN
467:
468: --Bug 4074173 : start
469: L_CURR_MODE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE');
470: L_DEFER_MODE_ALLOWED := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED');
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

Line 471: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');

467:
468: --Bug 4074173 : start
469: L_CURR_MODE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE');
470: L_DEFER_MODE_ALLOWED := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED');
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

Line 482: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE','PSIG_NONE');

478: --Bug 4577122: End
479:
480: IF (p_funcmode = 'RUN') THEN
481:
482: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE','PSIG_NONE');
483: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);
484: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE','AUTHOR');
485:
486: --Bug 4577122: Start

Line 483: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);

479:
480: IF (p_funcmode = 'RUN') THEN
481:
482: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE','PSIG_NONE');
483: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);
484: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE','AUTHOR');
485:
486: --Bug 4577122: Start
487: --GET_PAGE_FLOW_STATUS(L_EVENT_ID,L_SIGNATURE_STATUS);

Line 484: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE','AUTHOR');

480: IF (p_funcmode = 'RUN') THEN
481:
482: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE','PSIG_NONE');
483: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT',null);
484: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE','AUTHOR');
485:
486: --Bug 4577122: Start
487: --GET_PAGE_FLOW_STATUS(L_EVENT_ID,L_SIGNATURE_STATUS);
488: GET_PAGE_FLOW_STATUS_NEW(L_EVENT_ID,l_voting_regime, L_SIGNATURE_STATUS);

Line 493: l_doc_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID');

489: --Bug 4577122: End
490:
491: IF L_SIGNATURE_STATUS in ('SUCCESS','REJECTED','TIMEDOUT') THEN
492:
493: l_doc_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID');
494:
495: --Bug 4577122: Start
496: --clear out the status etc fields of edr_psig_details IFF voting regime is F
497: if (l_voting_regime = ame_util.firstApproverVoting) then

Line 542: l_doc_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_DOCUMENT_ID');

538: ELSIF L_SIGNATURE_STATUS ='TIMEDOUT' THEN
539: /* Check for the first person timeout. In this case doc_id might be null.
540: so fetch it from PSIG_DOCUMENT_ID */
541: IF l_doc_id is NULL then
542: l_doc_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_DOCUMENT_ID');
543: END IF;
544:
545:
546: EDR_PSIG.changeDocumentStatus( P_DOCUMENT_ID => l_doc_id,

Line 570: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_STATUS',L_SIGNATURE_STATUS);

566: p_itemkey ,
567: L_SIGNATURE_STATUS);
568: END IF;
569:
570: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_STATUS',L_SIGNATURE_STATUS);
571: IF L_SIGNATURE_STATUS = 'SUCCESS' THEN
572: p_resultout := 'COMPLETE:RESP_DONE_COMPLETED';
573: ELSE
574: p_resultout := 'COMPLETE:PSIG_REJECTED';

Line 579: l_doc_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_DOCUMENT_ID');

575: END IF;
576:
577: ELSE -- Still Pending Cases are there
578:
579: l_doc_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_DOCUMENT_ID');
580:
581: -- Bug 4213923 : Start
582:
583: OPEN C1(l_doc_id);

Line 631: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_STATUS','FAILURE');

627: SET ERECORD_SIGNATURE_STATUS = 'FAILURE'
628: WHERE EVENT_ID = p_itemkey;
629:
630: p_resultout := 'COMPLETE:PSIG_INCOMPLETE';
631: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_STATUS','FAILURE');
632: IF l_doc_id IS NOT NULL THEN
633: EDR_PSIG.changeDocumentStatus( P_DOCUMENT_ID => l_doc_id,
634: P_STATUS => 'ERROR',
635: P_ERROR => l_error_num,

Line 642: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE','OFFLINE');

638: RAISE EDR_PSIG_DOC_ERR;
639: END IF;
640: END IF;
641: ELSE
642: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE','OFFLINE');
643: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_STATUS','PENDING');
644:
645: UPDATE EDR_ERECORDS
646: SET ERECORD_SIGNATURE_STATUS = 'PENDING'

Line 643: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_STATUS','PENDING');

639: END IF;
640: END IF;
641: ELSE
642: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE','OFFLINE');
643: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_STATUS','PENDING');
644:
645: UPDATE EDR_ERECORDS
646: SET ERECORD_SIGNATURE_STATUS = 'PENDING'
647: WHERE EVENT_ID = p_itemkey;

Line 853: l_item_type := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMTYPE');

849:
850: --Bug 4074173 : start
851:
852: l_doc_format := 'text/plain';
853: l_item_type := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMTYPE');
854: l_item_key := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
855: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'#WF_SIGN_REQUESTER');
856: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'#WF_SIGN_REQUESTER');
857:

Line 854: l_item_key := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');

850: --Bug 4074173 : start
851:
852: l_doc_format := 'text/plain';
853: l_item_type := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMTYPE');
854: l_item_key := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
855: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'#WF_SIGN_REQUESTER');
856: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'#WF_SIGN_REQUESTER');
857:
858: l_display_name :='eSignature Group';

Line 855: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'#WF_SIGN_REQUESTER');

851:
852: l_doc_format := 'text/plain';
853: l_item_type := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMTYPE');
854: l_item_key := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
855: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'#WF_SIGN_REQUESTER');
856: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'#WF_SIGN_REQUESTER');
857:
858: l_display_name :='eSignature Group';
859: l_group :='EDRPSIG_ROLE';

Line 856: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'#WF_SIGN_REQUESTER');

852: l_doc_format := 'text/plain';
853: l_item_type := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMTYPE');
854: l_item_key := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
855: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'#WF_SIGN_REQUESTER');
856: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'#WF_SIGN_REQUESTER');
857:
858: l_display_name :='eSignature Group';
859: l_group :='EDRPSIG_ROLE';
860: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');

Line 860: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');

856: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'#WF_SIGN_REQUESTER');
857:
858: l_display_name :='eSignature Group';
859: l_group :='EDRPSIG_ROLE';
860: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
861:
862: l_event_xml := null;
863: l_event_text := null;
864:

Line 957: from wf_item_activity_statuses where item_type=p_itemtype

953: if(lc_itemkey <> p_itemkey and lp_status = 'ACTIVE' ) then
954: BEGIN
955:
956: select notification_id into lp_notification_id
957: from wf_item_activity_statuses where item_type=p_itemtype
958: and item_key = lc_itemkey and notification_id is not null
959: and activity_status ='NOTIFIED';
960:
961: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1006: l_doc_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(l_item_type, l_item_key,'EDR_PSIG_DOC_ID');

1002: */
1003: --Bug 2674799 : End
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();

Line 1012: l_doc_id := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'PSIG_DOCUMENT_ID');

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');
1013:
1014: /* Fixed to take care of PDF format */
1015:
1016: l_erec_template_type := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey, 'EREC_TEMPLATE_TYPE');

Line 1016: l_erec_template_type := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey, 'EREC_TEMPLATE_TYPE');

1012: l_doc_id := GET_WF_ITEM_ATTRIBUTE_TEXT(l_item_type, l_item_key,'PSIG_DOCUMENT_ID');
1013:
1014: /* Fixed to take care of PDF format */
1015:
1016: l_erec_template_type := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey, 'EREC_TEMPLATE_TYPE');
1017:
1018: if (l_erec_template_type = 'RTF') then
1019: -- Bug 3474765 : Start
1020: /* Changing the file content type to be MIME Formatted */

Line 1029: P_PSIG_REQUESTER => GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER'),

1025:
1026: EDR_PSIG.updateDocument(P_PSIG_XML => l_event_xml,
1027: P_PSIG_DOCUMENT => l_event_xml,
1028: P_PSIG_DOCUMENTFORMAT => l_doc_format,
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,

Line 1030: P_PSIG_SOURCE => GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SOURCE_APPLICATION_TYPE'),

1026: EDR_PSIG.updateDocument(P_PSIG_XML => l_event_xml,
1027: P_PSIG_DOCUMENT => l_event_xml,
1028: P_PSIG_DOCUMENTFORMAT => l_doc_format,
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,

Line 1040: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_item_type, l_item_key,'EDR_PSIG_DOC_ID',l_doc_id);

1036: P_ERROR_MSG => L_ERROR_MESG);
1037: IF l_ERROR_NUM IS NOT NULL THEN
1038: RAISE EDR_PSIG_DOC_ERR;
1039: ELSE
1040: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_item_type, l_item_key,'EDR_PSIG_DOC_ID',l_doc_id);
1041: l_paramlist:=l_psig_event.Parameter_List;
1042: IF (l_paramlist is not null) THEN
1043: FOR i IN l_paramlist.first .. l_paramlist.last LOOP
1044:

Line 1138: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,

1134: EXIT WHEN GET_RESPONSE_ATTR%NOTFOUND;
1135: i := i + 1;
1136: /* To support WF_NOTE attribute SKARIMIS*/
1137: IF GET_RESPONSE_ATTR_REC.Name = 'WF_NOTE' THEN
1138: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,
1139: p_itemkey,
1140: 'SIGNERS_COMMENT',
1141: GET_RESPONSE_ATTR_REC.Meaning);
1142: GET_RESPONSE_ATTR_REC.Name:='SIGNERS_COMMENT';

Line 1173: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,

1169: PRIORITY =>L_NTF_PRIORITY,
1170: DUE_DATE =>L_NTF_DUE_DATE,
1171: STATUS =>L_NTF_STATUS);
1172:
1173: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,
1174: p_itemkey,
1175: 'NTF_RESPONDER',
1176: L_NTF_RESPOND_ROLE);
1177: END IF; -- Function Mode

Line 1182: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,

1178:
1179: IF (p_funcmode = 'RUN') THEN
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;

Line 1215: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,

1211: wf_directory.AddUsersToAdHocRole2(role_name=>'EDRPSIG_ROLE',
1212: role_users=>l_userlist);
1213: END IF;
1214:
1215: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,
1216: 'ESIG_GROUP' ,
1217: 'EDRPSIG_ROLE');
1218:
1219: END IF; -- RUN function ends

Line 1230: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,

1226: MESSAGE_NAME =>L_NTF_MESSAGE_NAME,
1227: PRIORITY =>L_NTF_PRIORITY,
1228: DUE_DATE =>L_NTF_DUE_DATE,
1229: STATUS =>L_NTF_STATUS);
1230: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,
1231: p_itemkey,
1232: 'NTF_RESPONDER',
1233: L_NTF_RESPOND_ROLE);
1234: END IF;

Line 1282: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');

1278:
1279: BEGIN
1280:
1281: --Bug 4074173 : start
1282: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1283: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1284: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');
1285: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');
1286: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');

Line 1283: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');

1279: BEGIN
1280:
1281: --Bug 4074173 : start
1282: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1283: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1284: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');
1285: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');
1286: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');
1287: --Bug 4074173 : end

Line 1284: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');

1280:
1281: --Bug 4074173 : start
1282: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1283: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1284: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');
1285: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');
1286: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');
1287: --Bug 4074173 : end
1288:

Line 1285: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');

1281: --Bug 4074173 : start
1282: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1283: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1284: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');
1285: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');
1286: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');
1287: --Bug 4074173 : end
1288:
1289: --Bug 4577122: Start

Line 1286: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');

1282: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1283: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1284: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');
1285: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');
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

Line 1383: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');

1379: l_count number;
1380: BEGIN
1381:
1382: --Bug 4074173 : start
1383: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1384: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1385: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');
1386: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');
1387: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');

Line 1384: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');

1380: BEGIN
1381:
1382: --Bug 4074173 : start
1383: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1384: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1385: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');
1386: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');
1387: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');
1388: --Bug 4074173 : end

Line 1385: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');

1381:
1382: --Bug 4074173 : start
1383: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1384: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1385: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');
1386: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');
1387: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');
1388: --Bug 4074173 : end
1389:

Line 1386: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');

1382: --Bug 4074173 : start
1383: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1384: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1385: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');
1386: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');
1387: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');
1388: --Bug 4074173 : end
1389:
1390:

Line 1387: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');

1383: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1384: l_EVENT_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1385: l_SIGNER_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'WF_SIGNER_TYPE');
1386: l_signer_reason := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'REASON_CODE');
1387: l_signer_comment := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNERS_COMMENT');
1388: --Bug 4074173 : end
1389:
1390:
1391:

Line 1433: FROM WF_ITEM_ACTIVITIES_HISTORY_V

1429: -- Bug 5223211 : start
1430: /*
1431: CURSOR CUR_NOTIFICATION IS
1432: SELECT NOTIFICATION_ID
1433: FROM WF_ITEM_ACTIVITIES_HISTORY_V
1434: WHERE ITEM_KEY = p_itemkey
1435: AND ITEM_TYPE = p_itemtype
1436: AND ACTIVITY_TYPE = 'NOTICE'
1437: AND NOTIFICATION_STATUS = 'OPEN'

Line 1441: SELECT NOTIFICATION_ID from WF_ITEM_ACTIVITY_STATUSES_V

1437: AND NOTIFICATION_STATUS = 'OPEN'
1438: ORDER BY BEGIN_DATE DESC;
1439: */
1440: CURSOR CUR_NOTIFICATION IS
1441: SELECT NOTIFICATION_ID from WF_ITEM_ACTIVITY_STATUSES_V
1442: WHERE ITEM_KEY = p_itemkey
1443: AND ITEM_TYPE = p_itemtype
1444: AND notification_id is not null
1445: ORDER BY activity_begin_date, execution_time;

Line 1482: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE ;

1478: AND SIGNATURE_STATUS = 'PENDING';
1479: --Bug 4272262: End
1480:
1481: SIGNER_LIST_REC CURR_LIST_SIGNERS%ROWTYPE;
1482: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE ;
1483: l_WorkflowProcess VARCHAR2(30) ;
1484: l_performer_name FND_USER.USER_NAME%TYPE ;
1485: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
1486: l_item_key VARCHAR2(100);

Line 1516: IF NOT WF_ITEM.Item_Exist(l_itemtype, l_item_key) THEN

1512: EXIT WHEN CURR_LIST_SIGNERS%NOTFOUND;
1513:
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) ;

Line 1536: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1532: text_value => l_voting_regime);
1533:
1534: --Bug 4577122: End
1535:
1536: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1537: '#WF_PAGEFLOW_ITEMKEY',
1538: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY'));
1539: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1540: '#WF_PAGEFLOW_ITEMTYPE',

Line 1538: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY'));

1534: --Bug 4577122: End
1535:
1536: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1537: '#WF_PAGEFLOW_ITEMKEY',
1538: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY'));
1539: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1540: '#WF_PAGEFLOW_ITEMTYPE',
1541: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMTYPE'));
1542: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

Line 1539: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1535:
1536: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1537: '#WF_PAGEFLOW_ITEMKEY',
1538: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY'));
1539: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1540: '#WF_PAGEFLOW_ITEMTYPE',
1541: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMTYPE'));
1542: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1543: 'DEFERRED',

Line 1541: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMTYPE'));

1537: '#WF_PAGEFLOW_ITEMKEY',
1538: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY'));
1539: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1540: '#WF_PAGEFLOW_ITEMTYPE',
1541: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMTYPE'));
1542: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1543: 'DEFERRED',
1544: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED'));
1545:

Line 1542: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1538: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY'));
1539: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1540: '#WF_PAGEFLOW_ITEMTYPE',
1541: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMTYPE'));
1542: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1543: 'DEFERRED',
1544: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED'));
1545:
1546: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

Line 1544: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED'));

1540: '#WF_PAGEFLOW_ITEMTYPE',
1541: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMTYPE'));
1542: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1543: 'DEFERRED',
1544: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED'));
1545:
1546: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1547: '#WF_ESIGN_ROW_ID' ,
1548: SIGNER_LIST_REC.SIGNATURE_ID);

Line 1546: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1542: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1543: 'DEFERRED',
1544: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED'));
1545:
1546: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1547: '#WF_ESIGN_ROW_ID' ,
1548: SIGNER_LIST_REC.SIGNATURE_ID);
1549: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1550: '#WF_CURRENT_MODE' ,

Line 1549: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1545:
1546: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1547: '#WF_ESIGN_ROW_ID' ,
1548: SIGNER_LIST_REC.SIGNATURE_ID);
1549: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1550: '#WF_CURRENT_MODE' ,
1551: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE'));
1552: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1553: 'PSIG_EVENT_NAME' ,

Line 1551: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE'));

1547: '#WF_ESIGN_ROW_ID' ,
1548: SIGNER_LIST_REC.SIGNATURE_ID);
1549: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1550: '#WF_CURRENT_MODE' ,
1551: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE'));
1552: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1553: 'PSIG_EVENT_NAME' ,
1554: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_EVENT_NAME'));
1555: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

Line 1552: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1548: SIGNER_LIST_REC.SIGNATURE_ID);
1549: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1550: '#WF_CURRENT_MODE' ,
1551: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE'));
1552: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1553: 'PSIG_EVENT_NAME' ,
1554: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_EVENT_NAME'));
1555: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1556: 'PSIG_TIMEZONE' ,

Line 1554: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_EVENT_NAME'));

1550: '#WF_CURRENT_MODE' ,
1551: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE'));
1552: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1553: 'PSIG_EVENT_NAME' ,
1554: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_EVENT_NAME'));
1555: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1556: 'PSIG_TIMEZONE' ,
1557: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMEZONE'));
1558: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

Line 1555: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1551: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE'));
1552: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1553: 'PSIG_EVENT_NAME' ,
1554: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_EVENT_NAME'));
1555: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1556: 'PSIG_TIMEZONE' ,
1557: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMEZONE'));
1558: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1559: 'PSIG_TIMESTAMP' ,

Line 1557: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMEZONE'));

1553: 'PSIG_EVENT_NAME' ,
1554: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_EVENT_NAME'));
1555: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1556: 'PSIG_TIMEZONE' ,
1557: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMEZONE'));
1558: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1559: 'PSIG_TIMESTAMP' ,
1560: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMESTAMP'));
1561:

Line 1558: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1554: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_EVENT_NAME'));
1555: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1556: 'PSIG_TIMEZONE' ,
1557: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMEZONE'));
1558: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1559: 'PSIG_TIMESTAMP' ,
1560: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMESTAMP'));
1561:
1562: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

Line 1560: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMESTAMP'));

1556: 'PSIG_TIMEZONE' ,
1557: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMEZONE'));
1558: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1559: 'PSIG_TIMESTAMP' ,
1560: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMESTAMP'));
1561:
1562: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1563: 'PSIG_USER_KEY_LABEL' ,
1564: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_LABEL'));

Line 1562: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1558: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1559: 'PSIG_TIMESTAMP' ,
1560: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMESTAMP'));
1561:
1562: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1563: 'PSIG_USER_KEY_LABEL' ,
1564: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_LABEL'));
1565: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1566: 'PSIG_USER_KEY_VALUE' ,

Line 1564: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_LABEL'));

1560: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_TIMESTAMP'));
1561:
1562: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1563: 'PSIG_USER_KEY_LABEL' ,
1564: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_LABEL'));
1565: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1566: 'PSIG_USER_KEY_VALUE' ,
1567: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_VALUE'));
1568:

Line 1565: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1561:
1562: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1563: 'PSIG_USER_KEY_LABEL' ,
1564: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_LABEL'));
1565: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1566: 'PSIG_USER_KEY_VALUE' ,
1567: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_VALUE'));
1568:
1569: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

Line 1567: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_VALUE'));

1563: 'PSIG_USER_KEY_LABEL' ,
1564: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_LABEL'));
1565: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1566: 'PSIG_USER_KEY_VALUE' ,
1567: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_VALUE'));
1568:
1569: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1570: 'SIGNATURE_HISTORY' ,
1571: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNATURE_HISTORY'));

Line 1569: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1565: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1566: 'PSIG_USER_KEY_VALUE' ,
1567: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_VALUE'));
1568:
1569: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1570: 'SIGNATURE_HISTORY' ,
1571: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNATURE_HISTORY'));
1572:
1573: /* Style Sheet Version Fix */

Line 1571: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNATURE_HISTORY'));

1567: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_USER_KEY_VALUE'));
1568:
1569: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1570: 'SIGNATURE_HISTORY' ,
1571: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNATURE_HISTORY'));
1572:
1573: /* Style Sheet Version Fix */
1574: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1575: 'TEXT_XSLNAME',

Line 1574: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1570: 'SIGNATURE_HISTORY' ,
1571: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'SIGNATURE_HISTORY'));
1572:
1573: /* Style Sheet Version Fix */
1574: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1575: 'TEXT_XSLNAME',
1576: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME'));
1577:
1578: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

Line 1576: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME'));

1572:
1573: /* Style Sheet Version Fix */
1574: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1575: 'TEXT_XSLNAME',
1576: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME'));
1577:
1578: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1579: 'TEXT_XSLVERSION' ,
1580: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION'));

Line 1578: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1574: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1575: 'TEXT_XSLNAME',
1576: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME'));
1577:
1578: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1579: 'TEXT_XSLVERSION' ,
1580: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION'));
1581:
1582: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,

Line 1580: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION'));

1576: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME'));
1577:
1578: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1579: 'TEXT_XSLVERSION' ,
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',

Line 1582: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,

1578: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1579: 'TEXT_XSLVERSION' ,
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 */

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 1588: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,

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,
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,

Line 1591: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TIMEOUT_RESEND_COUNT'));

1587:
1588: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1589: l_item_key,
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);

Line 1592: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,

1588: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype,
1589: l_item_key,
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:

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 1597: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype, l_item_key,'PSIG_DOCUMENT_ID',

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:
1600: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype, l_item_key,'EDR_PSIG_DOC_ID',
1601: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID'));

Line 1598: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'PSIG_DOCUMENT_ID'));

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:
1600: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype, l_item_key,'EDR_PSIG_DOC_ID',
1601: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID'));
1602:

Line 1600: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype, l_item_key,'EDR_PSIG_DOC_ID',

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:
1600: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype, l_item_key,'EDR_PSIG_DOC_ID',
1601: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID'));
1602:
1603: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1604: '#WF_SIGNER_ROLE' ,

Line 1601: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID'));

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:
1600: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype, l_item_key,'EDR_PSIG_DOC_ID',
1601: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID'));
1602:
1603: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1604: '#WF_SIGNER_ROLE' ,
1605: SIGNER_LIST_REC.USER_NAME);

Line 1603: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1599:
1600: SET_WF_ITEM_ATTRIBUTE_NUMBER(l_itemtype, l_item_key,'EDR_PSIG_DOC_ID',
1601: GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID'));
1602:
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,

Line 1610: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,'#WF_ERECORD_TEXT',

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,
1614: '#WF_SIGN_REQUESTER',

Line 1611: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ERECORD_TEXT'));

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,
1614: '#WF_SIGN_REQUESTER',
1615: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER'));

Line 1613: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

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,
1614: '#WF_SIGN_REQUESTER',
1615: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER'));
1616:
1617: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

Line 1615: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER'));

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,
1614: '#WF_SIGN_REQUESTER',
1615: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER'));
1616:
1617: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1618: '#ATTACHMENTS',
1619: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ATTACHMENTS'));

Line 1617: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,

1613: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1614: '#WF_SIGN_REQUESTER',
1615: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER'));
1616:
1617: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1618: '#ATTACHMENTS',
1619: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ATTACHMENTS'));
1620: -- Bug: 3467353 - Start
1621:

Line 1619: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ATTACHMENTS'));

1615: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER'));
1616:
1617: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,l_item_key,
1618: '#ATTACHMENTS',
1619: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ATTACHMENTS'));
1620: -- Bug: 3467353 - Start
1621:
1622: -- Bug 3903471 : Start
1623: BEGIN

Line 1626: text_value => GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'EREC_TEMPLATE_TYPE'));

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;
1629: END;
1630: --Bug 3903471 : End

Line 1634: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,

1630: --Bug 3903471 : End
1631:
1632: --Bug 3998932 : Start
1633: --Isign Checklist ER
1634: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,
1635: l_item_key,
1636: 'RELATED_APPLICATION',
1637: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'RELATED_APPLICATION'));
1638: --Bug 3998932 : End

Line 1637: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'RELATED_APPLICATION'));

1633: --Isign Checklist ER
1634: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,
1635: l_item_key,
1636: 'RELATED_APPLICATION',
1637: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'RELATED_APPLICATION'));
1638: --Bug 3998932 : End
1639:
1640: --Bug 4122622: Start
1641: --Fetch the related e-records and child e-record ids attribute values

Line 1644: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,

1640: --Bug 4122622: Start
1641: --Fetch the related e-records and child e-record ids attribute values
1642: --from the parent workflow process and set them on the child
1643: --workflow process.
1644: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,
1645: l_item_key,
1646: 'RELATED_ERECORDS',
1647: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'RELATED_ERECORDS'));
1648:

Line 1647: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'RELATED_ERECORDS'));

1643: --workflow process.
1644: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,
1645: l_item_key,
1646: 'RELATED_ERECORDS',
1647: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'RELATED_ERECORDS'));
1648:
1649: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,
1650: l_item_key,
1651: 'CHILD_ERECORD_IDS',

Line 1649: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,

1645: l_item_key,
1646: 'RELATED_ERECORDS',
1647: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'RELATED_ERECORDS'));
1648:
1649: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,
1650: l_item_key,
1651: 'CHILD_ERECORD_IDS',
1652: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'CHILD_ERECORD_IDS'));
1653:

Line 1652: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'CHILD_ERECORD_IDS'));

1648:
1649: SET_WF_ITEM_ATTRIBUTE_TEXT(l_itemtype,
1650: l_item_key,
1651: 'CHILD_ERECORD_IDS',
1652: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'CHILD_ERECORD_IDS'));
1653:
1654: --Bug 4122622: End
1655:
1656: /* Setting Patent Child association */

Line 1668: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));

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);
1670: END IF; --Added by Bug 14762573 QZENG
1671: END LOOP;
1672: CLOSE CURR_LIST_SIGNERS;

Line 1731: L_DOCUMENT_ID := nvl(GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID'),

1727: --Bug: 3903471 : Start
1728: --Old versions do not use #ERECORD_ID parameter.
1729: --Hence for backward compatibility we should verify with EDR_PSIG_DOC_ID attribute.
1730: --If the attribute does not exist, then #ERECORD_ID should be used.
1731: L_DOCUMENT_ID := nvl(GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID'),
1732: TO_NUMBER(GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID'),'999999999999.999999'));
1733: --Bug 3903471 : End
1734:
1735: l_wf_timeout := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT'),'999999999999.999999');

Line 1732: TO_NUMBER(GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID'),'999999999999.999999'));

1728: --Old versions do not use #ERECORD_ID parameter.
1729: --Hence for backward compatibility we should verify with EDR_PSIG_DOC_ID attribute.
1730: --If the attribute does not exist, then #ERECORD_ID should be used.
1731: L_DOCUMENT_ID := nvl(GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID'),
1732: TO_NUMBER(GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID'),'999999999999.999999'));
1733: --Bug 3903471 : End
1734:
1735: l_wf_timeout := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT'),'999999999999.999999');
1736: l_wf_timeout_interval := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT_INTERVAL'),'999999999999.999999');

Line 1739: L_SOURCE_APPL_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SOURCE_APPLICATION_TYPE');

1735: l_wf_timeout := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT'),'999999999999.999999');
1736: l_wf_timeout_interval := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT_INTERVAL'),'999999999999.999999');
1737: --Bug : 3499311 End.
1738:
1739: L_SOURCE_APPL_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SOURCE_APPLICATION_TYPE');
1740: L_DEFER_MODE_ALLOWED := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED');
1741: l_plsql_clob_api := 'PLSQLCLOB:wf_render.XML_STYLE_SHEET/#PSIG_EVENT:&'||'#NID';
1742: l_plsql_api := 'PLSQL:edr_xdoc_util_pkg.get_ntf_message_body/' || L_DOCUMENT_ID;
1743: l_history_api := 'PLSQL:EDR_UTILITIES.EDR_NTF_HISTORY/'||p_itemkey;

Line 1740: L_DEFER_MODE_ALLOWED := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED');

1736: l_wf_timeout_interval := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT_INTERVAL'),'999999999999.999999');
1737: --Bug : 3499311 End.
1738:
1739: L_SOURCE_APPL_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SOURCE_APPLICATION_TYPE');
1740: L_DEFER_MODE_ALLOWED := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED');
1741: l_plsql_clob_api := 'PLSQLCLOB:wf_render.XML_STYLE_SHEET/#PSIG_EVENT:&'||'#NID';
1742: l_plsql_api := 'PLSQL:edr_xdoc_util_pkg.get_ntf_message_body/' || L_DOCUMENT_ID;
1743: l_history_api := 'PLSQL:EDR_UTILITIES.EDR_NTF_HISTORY/'||p_itemkey;
1744:

Line 1749: l_signature_mode := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,EDR_CONSTANTS_GRP.G_SIGNATURE_MODE);

1745: --Bug 4074173 : end
1746:
1747: --Bug 4160412: Start
1748: --Obtain the value of the signature mode.
1749: l_signature_mode := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,EDR_CONSTANTS_GRP.G_SIGNATURE_MODE);
1750: --Bug 4160412: End
1751:
1752: IF p_funcmode='RUN' THEN
1753: /* Set process Owner SKARIMIS for BLAF standard */

Line 1757: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));

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:
1759: l_plsql_clob_api := l_plsql_clob_api ||'/'||
1760: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME')||'/'||
1761: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION')||'/'||

Line 1760: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME')||'/'||

1756: ITEMKEY=>p_itemkey,
1757: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));
1758:
1759: l_plsql_clob_api := l_plsql_clob_api ||'/'||
1760: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME')||'/'||
1761: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION')||'/'||
1762: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE') ||'/'||
1763: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLNAME')||'/'||
1764: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLVERSION')||'/'||

Line 1761: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION')||'/'||

1757: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));
1758:
1759: l_plsql_clob_api := l_plsql_clob_api ||'/'||
1760: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME')||'/'||
1761: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION')||'/'||
1762: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE') ||'/'||
1763: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLNAME')||'/'||
1764: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLVERSION')||'/'||
1765: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE');

Line 1762: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE') ||'/'||

1758:
1759: l_plsql_clob_api := l_plsql_clob_api ||'/'||
1760: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME')||'/'||
1761: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION')||'/'||
1762: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE') ||'/'||
1763: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLNAME')||'/'||
1764: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLVERSION')||'/'||
1765: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE');
1766:

Line 1763: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLNAME')||'/'||

1759: l_plsql_clob_api := l_plsql_clob_api ||'/'||
1760: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME')||'/'||
1761: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION')||'/'||
1762: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE') ||'/'||
1763: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLNAME')||'/'||
1764: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLVERSION')||'/'||
1765: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE');
1766:
1767:

Line 1764: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLVERSION')||'/'||

1760: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLNAME')||'/'||
1761: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION')||'/'||
1762: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE') ||'/'||
1763: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLNAME')||'/'||
1764: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLVERSION')||'/'||
1765: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE');
1766:
1767:
1768: -- Bug 3170251 : Start- Check if EREC_TEMPLATE TYPE IS XSL or RTF and based on that decide the ERECORD TEXT Content

Line 1765: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE');

1761: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEXT_XSLVERSION')||'/'||
1762: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE') ||'/'||
1763: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLNAME')||'/'||
1764: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'HTML_XSLVERSION')||'/'||
1765: GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'APPLICATION_CODE');
1766:
1767:
1768: -- Bug 3170251 : Start- Check if EREC_TEMPLATE TYPE IS XSL or RTF and based on that decide the ERECORD TEXT Content
1769: -- and Notification Subject Token

Line 1770: l_erec_template_type := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey, 'EREC_TEMPLATE_TYPE');

1766:
1767:
1768: -- Bug 3170251 : Start- Check if EREC_TEMPLATE TYPE IS XSL or RTF and based on that decide the ERECORD TEXT Content
1769: -- and Notification Subject Token
1770: l_erec_template_type := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey, 'EREC_TEMPLATE_TYPE');
1771:
1772: if (l_erec_template_type = 'RTF') then
1773: FND_MESSAGE.SET_NAME('EDR','EDR_WF_EREC_RTF_NTF_SUB');
1774: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

Line 1776: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'WF_MSG_SUB_EREC_TOKEN',FND_MESSAGE.GET());

1772: if (l_erec_template_type = 'RTF') then
1773: FND_MESSAGE.SET_NAME('EDR','EDR_WF_EREC_RTF_NTF_SUB');
1774: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1775:
1776: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'WF_MSG_SUB_EREC_TOKEN',FND_MESSAGE.GET());
1777: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_ERECORD_TEXT', l_plsql_api);
1778: else
1779: FND_MESSAGE.SET_NAME('EDR','EDR_WF_EREC_XSL_NTF_SUB');
1780: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

Line 1777: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_ERECORD_TEXT', l_plsql_api);

1773: FND_MESSAGE.SET_NAME('EDR','EDR_WF_EREC_RTF_NTF_SUB');
1774: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1775:
1776: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'WF_MSG_SUB_EREC_TOKEN',FND_MESSAGE.GET());
1777: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_ERECORD_TEXT', l_plsql_api);
1778: else
1779: FND_MESSAGE.SET_NAME('EDR','EDR_WF_EREC_XSL_NTF_SUB');
1780: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1781:

Line 1782: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'WF_MSG_SUB_EREC_TOKEN',FND_MESSAGE.GET());

1778: else
1779: FND_MESSAGE.SET_NAME('EDR','EDR_WF_EREC_XSL_NTF_SUB');
1780: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1781:
1782: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'WF_MSG_SUB_EREC_TOKEN',FND_MESSAGE.GET());
1783: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_ERECORD_TEXT', l_plsql_clob_api);
1784: end if;
1785: -- Bug 3170251 : End
1786:

Line 1783: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_ERECORD_TEXT', l_plsql_clob_api);

1779: FND_MESSAGE.SET_NAME('EDR','EDR_WF_EREC_XSL_NTF_SUB');
1780: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1781:
1782: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'WF_MSG_SUB_EREC_TOKEN',FND_MESSAGE.GET());
1783: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_ERECORD_TEXT', l_plsql_clob_api);
1784: end if;
1785: -- Bug 3170251 : End
1786:
1787: L_event_name := Get_event_disp_name(p_itemkey);

Line 1788: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,

1784: end if;
1785: -- Bug 3170251 : End
1786:
1787: L_event_name := Get_event_disp_name(p_itemkey);
1788: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,
1789: p_itemkey,
1790: 'PSIG_EVENT_NAME',
1791: L_EVENT_NAME);
1792:

Line 1804: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,

1800: x_doc_parameters_tbl => l_doc_param_tbl,
1801: x_signatures_tbl => l_sig_tbl);
1802:
1803: --Bug 3903471 : Start
1804: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,
1805: p_itemkey,
1806: 'PSIG_TIMEZONE' ,
1807: l_document_rec.PSIG_TIMEZONE);
1808: --Bug 3903471 : End

Line 1820: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,

1816: aname =>'PSIG_TIMESTAMP' ,
1817: avalue => FND_DATE.DATE_TO_DISPLAYDT(l_document_rec.PSIG_TIMESTAMP));
1818: */
1819: --Bug 3903471 : Start
1820: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,
1821: p_itemkey,
1822: 'PSIG_TIMESTAMP' ,
1823: FND_DATE.DATE_TO_DISPLAYDT(l_document_rec.PSIG_TIMESTAMP, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE));
1824: --Bug 3903471 : End

Line 1838: SET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype,

1834: -- Converting days into minutes
1835:
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:

Line 1843: 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,
1845: 'TIMEOUT_RESEND_COUNT',
1846: l_wf_timeout_interval);
1847:

Line 1850: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,

1846: l_wf_timeout_interval);
1847:
1848: l_message := FND_MESSAGE.GET_STRING('EDR','EDR_PSIG_PROCESS_ABORTED');
1849:
1850: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,
1851: p_itemkey,
1852: '#WF_PAGEFLOW_MESSAGE',
1853: l_message);
1854:

Line 1855: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,

1851: p_itemkey,
1852: '#WF_PAGEFLOW_MESSAGE',
1853: l_message);
1854:
1855: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,
1856: p_itemkey,
1857: 'SIGNATURE_HISTORY',
1858: l_history_api);
1859:

Line 1861: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE','OFFLINE');

1857: 'SIGNATURE_HISTORY',
1858: l_history_api);
1859:
1860: IF L_SOURCE_APPL_TYPE = 'DB' and L_DEFER_MODE_ALLOWED ='Y' THEN
1861: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE','OFFLINE');
1862: p_resultout := 'COMPLETE:TOTAL_OFFLINE';
1863: --Bug 2637353: Start
1864: --Set the result out value for MSCA source type.
1865: ELSIF L_SOURCE_APPL_TYPE='MSCA' then

Line 1911: l_wf_timeout := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TIMEOUT_RESEND_COUNT');

1907:
1908: BEGIN
1909:
1910: --Bug 4074173 : start
1911: l_wf_timeout := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TIMEOUT_RESEND_COUNT');
1912: l_wf_temp_timeout := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TEMP_RESEND_COUNT');
1913: l_item_key := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1914:
1915: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');

Line 1912: l_wf_temp_timeout := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TEMP_RESEND_COUNT');

1908: BEGIN
1909:
1910: --Bug 4074173 : start
1911: l_wf_timeout := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TIMEOUT_RESEND_COUNT');
1912: l_wf_temp_timeout := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TEMP_RESEND_COUNT');
1913: l_item_key := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1914:
1915: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');
1916: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');

Line 1913: l_item_key := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');

1909:
1910: --Bug 4074173 : start
1911: l_wf_timeout := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TIMEOUT_RESEND_COUNT');
1912: l_wf_temp_timeout := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TEMP_RESEND_COUNT');
1913: l_item_key := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1914:
1915: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');
1916: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');
1917: l_display_name :='eSignature Group';

Line 1915: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');

1911: l_wf_timeout := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TIMEOUT_RESEND_COUNT');
1912: l_wf_temp_timeout := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TEMP_RESEND_COUNT');
1913: l_item_key := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1914:
1915: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');
1916: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');
1917: l_display_name :='eSignature Group';
1918: l_group :='EDRPSIG_ROLE';
1919: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');

Line 1916: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');

1912: l_wf_temp_timeout := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'TEMP_RESEND_COUNT');
1913: l_item_key := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
1914:
1915: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');
1916: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');
1917: l_display_name :='eSignature Group';
1918: l_group :='EDRPSIG_ROLE';
1919: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1920: --Bug 4074173 : end

Line 1919: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');

1915: l_userlist(1) := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');
1916: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');
1917: l_display_name :='eSignature Group';
1918: l_group :='EDRPSIG_ROLE';
1919: l_ESIGN_ID := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_ESIGN_ROW_ID');
1920: --Bug 4074173 : end
1921:
1922: IF p_funcmode='RUN' THEN
1923: /* Figure out if the count exceeded */

Line 1956: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,

1952: wf_directory.AddUsersToAdHocRole2(role_name=>'EDRPSIG_ROLE',
1953: role_users=>l_userlist);
1954: END IF;
1955:
1956: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,
1957: 'ESIG_GROUP' ,
1958: 'EDRPSIG_ROLE');
1959: UPDATE EDR_ESIGNATURES
1960: SET SIGNATURE_STATUS = 'TIMEDOUT'

Line 1964: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEMP_RESEND_COUNT',l_wf_temp_timeout+1);

1960: SET SIGNATURE_STATUS = 'TIMEDOUT'
1961: WHERE SIGNATURE_ID = l_ESIGN_ID;
1962: p_resultout := 'COMPLETE:Y';
1963: ELSE
1964: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'TEMP_RESEND_COUNT',l_wf_temp_timeout+1);
1965: p_resultout := 'COMPLETE:N';
1966: END IF;
1967: END IF;
1968: END CHECK_TIMEOUT;

Line 1981: from WF_ITEM_ACTIVITIES_HISTORY_V

1977: p_item_key out NOCOPY varchar2,
1978: p_item_type out NOCOPY varchar2) is
1979: cursor getItemKey is
1980: select ITEM_KEY, ITEM_TYPE
1981: from WF_ITEM_ACTIVITIES_HISTORY_V
1982: where NOTIFICATION_ID = p_notif;
1983: BEGIN
1984: open getItemKey;
1985: fetch getItemKey into p_item_key,p_item_type;

Line 2007: l_event_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');

2003: BEGIN
2004:
2005: --Bug 4074173 : start
2006: l_return_status := G_NO;
2007: l_event_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
2008: L_CURR_MODE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE');
2009: --Bug 4074173 : end
2010:
2011: --get the status of the signature process

Line 2008: L_CURR_MODE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE');

2004:
2005: --Bug 4074173 : start
2006: l_return_status := G_NO;
2007: l_event_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
2008: L_CURR_MODE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE');
2009: --Bug 4074173 : end
2010:
2011: --get the status of the signature process
2012: select ERECORD_SIGNATURE_STATUS into l_signature_status

Line 2045: l_event_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');

2041: BEGIN
2042:
2043: --Bug 4074173 : start
2044: l_return_status := G_NO;
2045: l_event_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
2046: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');
2047: --Bug 4074173 : end
2048:
2049: -- Bug 3315185 : Modified profile option access level to user level

Line 2046: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');

2042:
2043: --Bug 4074173 : start
2044: l_return_status := G_NO;
2045: l_event_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_ITEMKEY');
2046: l_requester := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SIGN_REQUESTER');
2047: --Bug 4074173 : end
2048:
2049: -- Bug 3315185 : Modified profile option access level to user level
2050: -- for accessing the requester's preference first.

Line 2122: l_erecord_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID');

2118:
2119: l_orig_event_key := l_psig_Event.getEventKey();
2120:
2121: --Obtain the e-record and event status from workflow from workflow.
2122: l_erecord_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID');
2123: l_event_status := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,EDR_CONSTANTS_GRP.G_FINAL_DOCUMENT_STATUS);
2124:
2125:
2126: l_event_name := EDR_CONSTANTS_GRP.G_APPROVAL_COMPLETION_EVT;

Line 2123: l_event_status := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,EDR_CONSTANTS_GRP.G_FINAL_DOCUMENT_STATUS);

2119: l_orig_event_key := l_psig_Event.getEventKey();
2120:
2121: --Obtain the e-record and event status from workflow from workflow.
2122: l_erecord_id := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID');
2123: l_event_status := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,EDR_CONSTANTS_GRP.G_FINAL_DOCUMENT_STATUS);
2124:
2125:
2126: l_event_name := EDR_CONSTANTS_GRP.G_APPROVAL_COMPLETION_EVT;
2127: l_event_key := l_erecord_id;