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.AMW_GEN_APPROVAL_PVT dependencies on WF_ENGINE

Line 169: WF_ENGINE.SetItemAttrText

165: ||l_msg_data||fnd_global.local_chr(10) ;
166: l_cnt := l_cnt + 1 ;
167: END LOOP ;
168: x_error_msg := l_final_data;
169: WF_ENGINE.SetItemAttrText
170: (itemtype => p_itemtype,
171: itemkey => p_itemkey ,
172: aname => p_attr_name,
173: avalue => l_final_data );

Line 175: l_appr_meaning := wf_engine.GetItemAttrText(

171: itemkey => p_itemkey ,
172: aname => p_attr_name,
173: avalue => l_final_data );
174: --
175: l_appr_meaning := wf_engine.GetItemAttrText(
176: itemtype => p_itemtype,
177: itemkey => p_itemkey,
178: aname => 'AMW_APPROVAL_OBJECT_MEANING');
179:

Line 180: l_appr_obj_name := wf_engine.GetItemAttrText(

176: itemtype => p_itemtype,
177: itemkey => p_itemkey,
178: aname => 'AMW_APPROVAL_OBJECT_MEANING');
179:
180: l_appr_obj_name := wf_engine.GetItemAttrText(
181: itemtype => p_itemtype,
182: itemkey => p_itemkey,
183: aname => 'AMW_APPROVAL_OBJECT_NAME');
184: --

Line 191: Wf_Engine.SetItemAttrText

187: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
188:
189: l_gen_err_sub := SUBSTR(fnd_message.get,1,240);
190:
191: Wf_Engine.SetItemAttrText
192: (itemtype => p_itemtype,
193: itemkey => p_itemkey ,
194: aname => 'ERR_SUBJECT',
195: avalue => l_gen_err_sub );

Line 266: l_save_threshold NUMBER := wf_engine.threshold;

262: l_msg_count NUMBER;
263: l_msg_data VARCHAR2(4000);
264: l_error_msg VARCHAR2(4000);
265: l_index NUMBER;
266: l_save_threshold NUMBER := wf_engine.threshold;
267:
268: ---npanandi added this for timeout profile value.
269: l_timeout_profile NUMBER;
270:

Line 284: -- wf_engine.threshold := -1;

280:
281: AMW_Utility_PVT.debug_message('Start :Item Type : '||itemtype
282: ||' Item key : '||itemkey);
283:
284: -- wf_engine.threshold := -1;
285: WF_ENGINE.CreateProcess (itemtype => itemtype,
286: itemkey => itemkey ,
287: process => p_workflow_process);
288:

Line 285: WF_ENGINE.CreateProcess (itemtype => itemtype,

281: AMW_Utility_PVT.debug_message('Start :Item Type : '||itemtype
282: ||' Item key : '||itemkey);
283:
284: -- wf_engine.threshold := -1;
285: WF_ENGINE.CreateProcess (itemtype => itemtype,
286: itemkey => itemkey ,
287: process => p_workflow_process);
288:
289: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

Line 289: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

285: WF_ENGINE.CreateProcess (itemtype => itemtype,
286: itemkey => itemkey ,
287: process => p_workflow_process);
288:
289: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
290: itemkey => itemkey ,
291: userkey => itemuserkey);
292:
293: /*****************************************************************

Line 300: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

296:
297:
298:
299: -- OBJECT Type (Some of valid values are 'RISK, 'CTRL', etc.,,);
300: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
301: itemkey => itemkey,
302: aname => 'AMW_OBJECT_TYPE',
303: avalue => p_OBJECT_type );
304:

Line 306: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,

302: aname => 'AMW_OBJECT_TYPE',
303: avalue => p_OBJECT_type );
304:
305: -- OBJECT ID (primary Id of OBJECT Object)
306: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
307: itemkey => itemkey,
308: aname => 'AMW_OBJECT_ID',
309: avalue => p_OBJECT_id );
310:

Line 327: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,

323: ---CONVERT THE PROFILE VALUE FROM DAYS TO MINUTES
324: L_TIMEOUT_PROFILE := (L_TIMEOUT_PROFILE) * 1440;
325: END IF;
326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'L_TIMEOUT_PROFILE IN MINUTES: '||L_TIMEOUT_PROFILE);
327: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
328: itemkey => itemkey,
329: aname => 'AMW_NOTIFICATION_TIMEOUT',
330: avalue => l_timeout_profile);
331: ---npanandi ended

Line 334: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

330: avalue => l_timeout_profile);
331: ---npanandi ended
332:
333: -- Object Version Number
334: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
335: itemkey => itemkey,
336: aname => 'AMW_OBJECT_VERSION_NUMBER',
337: avalue => p_OBJECT_version_number );
338: /*

Line 340: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

336: aname => 'AMW_OBJECT_VERSION_NUMBER',
337: avalue => p_OBJECT_version_number );
338: /*
339: -- Notes from the requestor
340: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
341: itemkey => itemkey,
342: aname => 'AMW_NOTES_FROM_REQUESTOR',
343: avalue => nvl(p_notes_from_requestor,'') );
344: */

Line 345: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

341: itemkey => itemkey,
342: aname => 'AMW_NOTES_FROM_REQUESTOR',
343: avalue => nvl(p_notes_from_requestor,'') );
344: */
345: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'DOCUMENT_ID',
348: avalue => itemtype || ':' ||itemkey);
349:

Line 350: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

346: itemkey => itemkey,
347: aname => 'DOCUMENT_ID',
348: avalue => itemtype || ':' ||itemkey);
349:
350: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
351: itemkey => itemkey,
352: aname => 'AMW_REQUESTOR_ID',
353: avalue => p_requestor_userid );
354:

Line 355: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

351: itemkey => itemkey,
352: aname => 'AMW_REQUESTOR_ID',
353: avalue => p_requestor_userid );
354:
355: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
356: itemkey => itemkey,
357: aname => 'AMW_APPROVAL_TYPE',
358: avalue => p_approval_type );
359:

Line 379: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

375: p_name => l_requestor_role ,
376: p_display_name => l_role_display_name );
377:
378:
379: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
380: itemkey => itemkey,
381: aname => 'AMW_REQUESTOR',
382: avalue => l_requestor_role );
383:

Line 385: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

381: aname => 'AMW_REQUESTOR',
382: avalue => l_requestor_role );
383:
384:
385: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
386: itemkey => itemkey,
387: aname => 'AMW_GENERIC_FLAG',
388: avalue => p_gen_process_flag );
389:

Line 390: WF_ENGINE.SetItemOwner(itemtype => itemtype,

386: itemkey => itemkey,
387: aname => 'AMW_GENERIC_FLAG',
388: avalue => p_gen_process_flag );
389:
390: WF_ENGINE.SetItemOwner(itemtype => itemtype,
391: itemkey => itemkey,
392: owner => l_requestor_role);
393:
394: -- Start the Process

Line 395: WF_ENGINE.StartProcess (itemtype => itemtype,

391: itemkey => itemkey,
392: owner => l_requestor_role);
393:
394: -- Start the Process
395: WF_ENGINE.StartProcess (itemtype => itemtype,
396: itemkey => itemkey);
397:
398: -- wf_engine.threshold := l_save_threshold ;
399: EXCEPTION

Line 398: -- wf_engine.threshold := l_save_threshold ;

394: -- Start the Process
395: WF_ENGINE.StartProcess (itemtype => itemtype,
396: itemkey => itemkey);
397:
398: -- wf_engine.threshold := l_save_threshold ;
399: EXCEPTION
400:
401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO start_process;

Line 459: l_OBJECT_id := wf_engine.GetItemAttrNumber(

455: BEGIN
456: FND_MSG_PUB.initialize();
457: IF (funcmode = 'RUN') THEN
458: -- get the acitvity id
459: l_OBJECT_id := wf_engine.GetItemAttrNumber(
460: itemtype => itemtype,
461: itemkey => itemkey,
462: aname => 'AMW_OBJECT_ID' );
463:

Line 465: l_OBJECT_type := wf_engine.GetItemAttrText(

461: itemkey => itemkey,
462: aname => 'AMW_OBJECT_ID' );
463:
464: -- get the OBJECT type
465: l_OBJECT_type := wf_engine.GetItemAttrText(
466: itemtype => itemtype,
467: itemkey => itemkey,
468: aname => 'AMW_OBJECT_TYPE' );
469:

Line 470: l_approval_type := wf_engine.GetItemAttrText(

466: itemtype => itemtype,
467: itemkey => itemkey,
468: aname => 'AMW_OBJECT_TYPE' );
469:
470: l_approval_type := wf_engine.GetItemAttrText(
471: itemtype => itemtype,
472: itemkey => itemkey,
473: aname => 'AMW_APPROVAL_TYPE' );
474:

Line 603: l_OBJECT_id := Wf_Engine.GetItemAttrNumber(

599:
600: return ;
601: end if ;
602:
603: l_OBJECT_id := Wf_Engine.GetItemAttrNumber(
604: itemtype => itemtype,
605: itemkey => itemkey,
606: aname => 'AMW_OBJECT_ID' );
607:

Line 608: l_OBJECT_type := Wf_Engine.GetItemAttrText(

604: itemtype => itemtype,
605: itemkey => itemkey,
606: aname => 'AMW_OBJECT_ID' );
607:
608: l_OBJECT_type := Wf_Engine.GetItemAttrText(
609: itemtype => itemtype,
610: itemkey => itemkey,
611: aname => 'AMW_OBJECT_TYPE' );
612:

Line 613: l_version := Wf_Engine.GetItemAttrNumber(

609: itemtype => itemtype,
610: itemkey => itemkey,
611: aname => 'AMW_OBJECT_TYPE' );
612:
613: l_version := Wf_Engine.GetItemAttrNumber(
614: itemtype => itemtype,
615: itemkey => itemkey,
616: aname => 'AMW_OBJECT_VERSION_NUMBER' );
617:

Line 618: l_approval_type := Wf_Engine.GetItemAttrText(

614: itemtype => itemtype,
615: itemkey => itemkey,
616: aname => 'AMW_OBJECT_VERSION_NUMBER' );
617:
618: l_approval_type := Wf_Engine.GetItemAttrText(
619: itemtype => itemtype,
620: itemkey => itemkey,
621: aname => 'AMW_APPROVAL_TYPE' );
622:

Line 624: l_object_approver_id := wf_engine.GetItemAttrNumber(

620: itemkey => itemkey,
621: aname => 'AMW_APPROVAL_TYPE' );
622:
623: -- To start with the value of AMW_APPROVER_ID item attribute will be NULL
624: l_object_approver_id := wf_engine.GetItemAttrNumber(
625: itemtype => itemtype,
626: itemkey => itemkey,
627: aname => 'AMW_APPROVER_ID' ) ;
628:

Line 631: l_object_approval_status := WF_ENGINE.GetItemAttrText(

627: aname => 'AMW_APPROVER_ID' ) ;
628:
629: -- Obtain the value of UPDATE_GEN_STATUS item attribute
630: -- The very first entry into this activity this value will be NULL
631: l_object_approval_status := WF_ENGINE.GetItemAttrText(
632: itemtype => itemtype,
633: itemkey => itemkey,
634: aname => 'UPDATE_GEN_STATUS' ) ;
635:

Line 651: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

647: approverUserIdIn => NULL,
648: transactionTypeIn => l_OBJECT_type ) ;
649: END IF ;
650: /*
651: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
652: itemkey => itemkey,
653: aname => 'APPROVAL_NOTE',
654: avalue => 'ObjInfo:' || l_OBJECT_id || l_object_type );
655: */

Line 669: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

665: -- or no appprovers are returned by OAM
666: -- for now, the transaction is approved
667: resultout := 'COMPLETE:COMPLETE' ;
668:
669: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
670: itemkey => itemkey,
671: aname => 'AMW_ERROR_MSG',
672: avalue => 'No More Approvers' );
673:

Line 679: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

675: ELSIF ( l_nextApprover.approval_status = ame_util.exceptionStatus ) THEN
676: -- an error has occurred and Approvals Manager may return the admin approver
677: -- or it may just return a exception status. Write to log that there is an error
678:
679: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
680: itemkey => itemkey,
681: aname => 'AMW_ERROR_MSG',
682: avalue => 'Exception Status:' || l_nextApprover.approval_status );
683: resultout := 'COMPLETE:ERROR' ;

Line 696: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

692: THEN
693: -- Approvals Manager returned the next approver's person id
694: l_OBJECT_approver_id := l_nextApprover.person_id ;
695:
696: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
697: itemkey => itemkey,
698: aname => 'UPDATE_GEN_STATUS',
699: avalue => 'APPROVED' );
700: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

Line 700: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

696: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
697: itemkey => itemkey,
698: aname => 'UPDATE_GEN_STATUS',
699: avalue => 'APPROVED' );
700: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
701: itemkey => itemkey,
702: aname => 'AMW_ERROR_MSG',
703: avalue => 'Got Person Id:' || l_OBJECT_approver_id );
704:

Line 709: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

705: ELSIF ( l_nextApprover.user_id is not null )
706: THEN
707: -- Approvals Manager returned the next approver's user id
708: l_OBJECT_approver_id := l_nextApprover.user_id ;
709: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
710: itemkey => itemkey,
711: aname => 'UPDATE_GEN_STATUS',
712: avalue => 'APPROVED' );
713:

Line 719: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

715: p_user_id =>l_nextApprover.user_id,
716: x_person_id =>l_OBJECT_approver_id,
717: x_return_status =>l_return_status);
718:
719: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
720: itemkey => itemkey,
721: aname => 'AMW_ERROR_MSG',
722: avalue => 'Got User Id:' || l_OBJECT_approver_id );
723: END IF ;

Line 735: l_prev_approver_disp_name := wf_engine.GetItemAttrText(

731: RAISE FND_API.G_EXC_ERROR ;
732: END IF ;
733:
734: -- Get the current approver's display name, person who just approved the object
735: l_prev_approver_disp_name := wf_engine.GetItemAttrText(
736: itemtype => itemtype,
737: itemkey => itemkey,
738: aname => 'AMW_APPROVER_DISPLAY_NAME' );
739:

Line 741: wf_engine.SetItemAttrText( itemtype => itemtype,

737: itemkey => itemkey,
738: aname => 'AMW_APPROVER_DISPLAY_NAME' );
739:
740: -- Set the person who currently approved to previous approver display name
741: wf_engine.SetItemAttrText( itemtype => itemtype,
742: itemkey => itemkey,
743: aname => 'AMW_PREV_APPROVER_DISP_NAME',
744: avalue => l_prev_approver_disp_name);
745:

Line 747: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

743: aname => 'AMW_PREV_APPROVER_DISP_NAME',
744: avalue => l_prev_approver_disp_name);
745:
746: -- Get the current approver's approval note
747: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,
748: itemkey => itemkey,
749: aname => 'APPROVAL_NOTE');
750:
751: -- Set the current approver's notes to previous approval note

Line 752: wf_engine.SetItemAttrText( itemtype => itemtype,

748: itemkey => itemkey,
749: aname => 'APPROVAL_NOTE');
750:
751: -- Set the current approver's notes to previous approval note
752: wf_engine.SetItemAttrText( itemtype => itemtype,
753: itemkey => itemkey,
754: aname => 'AMW_PREV_APPROVER_NOTE',
755: avalue => l_note);
756:

Line 758: wf_engine.SetItemAttrText( itemtype => itemtype,

754: aname => 'AMW_PREV_APPROVER_NOTE',
755: avalue => l_note);
756:
757: -- Clear the value in approval note so that the next approval does not see the previous values
758: wf_engine.SetItemAttrText( itemtype => itemtype,
759: itemkey => itemkey,
760: aname => 'APPROVAL_NOTE',
761: avalue => null);
762:

Line 764: wf_engine.SetItemAttrText( itemtype => itemtype,

760: aname => 'APPROVAL_NOTE',
761: avalue => null);
762:
763: -- Set the next approver's display name obtained from Get_User_Role()
764: wf_engine.SetItemAttrText( itemtype => itemtype,
765: itemkey => itemkey,
766: aname => 'AMW_APPROVER_DISPLAY_NAME',
767: avalue => l_approver_display_name);
768:

Line 770: wf_engine.SetItemAttrText( itemtype => itemtype,

766: aname => 'AMW_APPROVER_DISPLAY_NAME',
767: avalue => l_approver_display_name);
768:
769: -- Set the next approver's role name obtained from Get_User_Role()
770: wf_engine.SetItemAttrText( itemtype => itemtype,
771: itemkey => itemkey,
772: aname => 'AMW_APPROVER',
773: avalue => l_approver);
774:

Line 776: wf_engine.SetItemAttrNumber(itemtype => itemtype,

772: aname => 'AMW_APPROVER',
773: avalue => l_approver);
774:
775: -- Set the next approver's id obtained from Get_User_Role()
776: wf_engine.SetItemAttrNumber(itemtype => itemtype,
777: itemkey => itemkey,
778: aname => 'AMW_APPROVER_ID',
779: avalue => l_OBJECT_approver_id);
780:

Line 873: l_approval_detail_id := wf_engine.GetItemAttrNumber(

869:
870: BEGIN
871: FND_MSG_PUB.initialize();
872: IF (funcmode = 'RUN') THEN
873: l_approval_detail_id := wf_engine.GetItemAttrNumber(
874: itemtype => itemtype,
875: itemkey => itemkey,
876: aname => 'AMW_APPROVAL_DETAIL_ID' );
877:

Line 878: l_current_seq := wf_engine.GetItemAttrText(

874: itemtype => itemtype,
875: itemkey => itemkey,
876: aname => 'AMW_APPROVAL_DETAIL_ID' );
877:
878: l_current_seq := wf_engine.GetItemAttrText(
879: itemtype => itemtype,
880: itemkey => itemkey,
881: aname => 'AMW_APPROVER_SEQ' );
882:

Line 883: l_approver_id := wf_engine.GetItemAttrNumber(

879: itemtype => itemtype,
880: itemkey => itemkey,
881: aname => 'AMW_APPROVER_SEQ' );
882:
883: l_approver_id := wf_engine.GetItemAttrNumber(
884: itemtype => itemtype,
885: itemkey => itemkey,
886: aname => 'AMW_APPROVER_ID' );
887:

Line 888: l_OBJECT_id := wf_engine.GetItemAttrNumber(

884: itemtype => itemtype,
885: itemkey => itemkey,
886: aname => 'AMW_APPROVER_ID' );
887:
888: l_OBJECT_id := wf_engine.GetItemAttrNumber(
889: itemtype => itemtype,
890: itemkey => itemkey,
891: aname => 'AMW_OBJECT_ID' );
892:

Line 893: l_OBJECT_type := wf_engine.GetItemAttrText(

889: itemtype => itemtype,
890: itemkey => itemkey,
891: aname => 'AMW_OBJECT_ID' );
892:
893: l_OBJECT_type := wf_engine.GetItemAttrText(
894: itemtype => itemtype,
895: itemkey => itemkey,
896: aname => 'AMW_OBJECT_TYPE' );
897:

Line 900: wf_engine.SetItemAttrText( itemtype => itemtype,

896: aname => 'AMW_OBJECT_TYPE' );
897:
898: -- Added for 11.5.9
899: -- Bug 2535600
900: wf_engine.SetItemAttrText( itemtype => itemtype,
901: itemkey => itemkey,
902: aname => 'AMW_APPROVAL_DATE',
903: avalue => trunc(sysdate));
904:

Line 905: l_version := Wf_Engine.GetItemAttrNumber(

901: itemkey => itemkey,
902: aname => 'AMW_APPROVAL_DATE',
903: avalue => trunc(sysdate));
904:
905: l_version := Wf_Engine.GetItemAttrNumber(
906: itemtype => itemtype,
907: itemkey => itemkey,
908: aname => 'AMW_OBJECT_VERSION_NUMBER' );
909:

Line 910: l_approval_type := Wf_Engine.GetItemAttrText(

906: itemtype => itemtype,
907: itemkey => itemkey,
908: aname => 'AMW_OBJECT_VERSION_NUMBER' );
909:
910: l_approval_type := Wf_Engine.GetItemAttrText(
911: itemtype => itemtype,
912: itemkey => itemkey,
913: aname => 'AMW_APPROVAL_TYPE' );
914:

Line 915: l_note := Wf_Engine.GetItemAttrText(

911: itemtype => itemtype,
912: itemkey => itemkey,
913: aname => 'AMW_APPROVAL_TYPE' );
914:
915: l_note := Wf_Engine.GetItemAttrText(
916: itemtype => itemtype,
917: itemkey => itemkey,
918: aname => 'APPROVAL_NOTE' );
919:

Line 927: wf_engine.SetItemAttrNumber(itemtype => itemtype,

923: p_current_seq => l_current_seq,
924: x_next_seq => l_next_seq,
925: x_required_flag => l_required_flag);
926: IF l_next_seq is not null THEN
927: wf_engine.SetItemAttrNumber(itemtype => itemtype,
928: itemkey => itemkey,
929: aname => 'AMW_APPROVER_SEQ',
930: avalue => l_next_seq);
931: resultout := 'COMPLETE:Y';

Line 1037: l_OBJECT_id := wf_engine.GetItemAttrNumber(

1033: -- RUN mode
1034: --
1035: IF (funcmode = 'RUN') THEN
1036: -- get the object id
1037: l_OBJECT_id := wf_engine.GetItemAttrNumber(
1038: itemtype => itemtype,
1039: itemkey => itemkey,
1040: aname => 'AMW_OBJECT_ID' );
1041: -- get the OBJECT type

Line 1042: l_OBJECT_type := wf_engine.GetItemAttrText(

1038: itemtype => itemtype,
1039: itemkey => itemkey,
1040: aname => 'AMW_OBJECT_ID' );
1041: -- get the OBJECT type
1042: l_OBJECT_type := wf_engine.GetItemAttrText(
1043: itemtype => itemtype,
1044: itemkey => itemkey,
1045: aname => 'AMW_OBJECT_TYPE' );
1046:

Line 1047: l_version := wf_engine.GetItemAttrNumber(

1043: itemtype => itemtype,
1044: itemkey => itemkey,
1045: aname => 'AMW_OBJECT_TYPE' );
1046:
1047: l_version := wf_engine.GetItemAttrNumber(
1048: itemtype => itemtype,
1049: itemkey => itemkey,
1050: aname => 'AMW_OBJECT_VERSION_NUMBER' );
1051:

Line 1052: l_approval_type := wf_engine.GetItemAttrText(

1048: itemtype => itemtype,
1049: itemkey => itemkey,
1050: aname => 'AMW_OBJECT_VERSION_NUMBER' );
1051:
1052: l_approval_type := wf_engine.GetItemAttrText(
1053: itemtype => itemtype,
1054: itemkey => itemkey,
1055: aname => 'AMW_APPROVAL_TYPE' );
1056:

Line 1058: l_orig_status_id := wf_engine.GetItemAttrNumber(

1054: itemkey => itemkey,
1055: aname => 'AMW_APPROVAL_TYPE' );
1056:
1057: /*
1058: l_orig_status_id := wf_engine.GetItemAttrNumber(
1059: itemtype => itemtype,
1060: itemkey => itemkey,
1061: aname => 'AMW_ORIG_STAT_ID' );
1062: */

Line 1064: Wf_Engine.SetItemAttrText(itemtype => itemtype,

1060: itemkey => itemkey,
1061: aname => 'AMW_ORIG_STAT_ID' );
1062: */
1063:
1064: Wf_Engine.SetItemAttrText(itemtype => itemtype,
1065: itemkey => itemkey,
1066: aname => 'UPDATE_GEN_STATUS',
1067: avalue => 'ERROR');
1068:

Line 1176: WF_ENGINE.AbortProcess (itemtype => itemtype,

1172: itemkey VARCHAR2(30) := p_itemkey ;
1173: itemtype VARCHAR2(30) := nvl(p_itemtype,'AMW_APPROVAL') ;
1174: BEGIN
1175: AMW_Utility_PVT.debug_message('Process Abort Process');
1176: WF_ENGINE.AbortProcess (itemtype => itemtype,
1177: itemkey => itemkey ,
1178: process => p_workflow_process);
1179: EXCEPTION
1180: WHEN OTHERS THEN

Line 1261: l_OBJECT_type := wf_engine.GetItemAttrText(

1257: BEGIN
1258: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMWGAPP');
1259: l_itemKey := substr(document_id, instr(document_id,':')+1);
1260:
1261: l_OBJECT_type := wf_engine.GetItemAttrText(
1262: itemtype => l_itemtype,
1263: itemkey => l_itemkey,
1264: aname => 'AMW_OBJECT_TYPE' );
1265:

Line 1266: l_approval_type := wf_engine.GetItemAttrText(

1262: itemtype => l_itemtype,
1263: itemkey => l_itemkey,
1264: aname => 'AMW_OBJECT_TYPE' );
1265:
1266: l_approval_type := wf_engine.GetItemAttrText(
1267: itemtype => l_itemtype,
1268: itemkey => l_itemkey,
1269: aname => 'AMW_APPROVAL_TYPE' );
1270:

Line 1336: l_OBJECT_type := wf_engine.GetItemAttrText(

1332: BEGIN
1333: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMWGAPP');
1334: l_itemKey := substr(document_id, instr(document_id,':')+1);
1335:
1336: l_OBJECT_type := wf_engine.GetItemAttrText(
1337: itemtype => l_itemtype,
1338: itemkey => l_itemkey,
1339: aname => 'AMW_OBJECT_TYPE' );
1340:

Line 1341: l_approval_type := wf_engine.GetItemAttrText(

1337: itemtype => l_itemtype,
1338: itemkey => l_itemkey,
1339: aname => 'AMW_OBJECT_TYPE' );
1340:
1341: l_approval_type := wf_engine.GetItemAttrText(
1342: itemtype => l_itemtype,
1343: itemkey => l_itemkey,
1344: aname => 'AMW_APPROVAL_TYPE' );
1345:

Line 1411: l_OBJECT_type := wf_engine.GetItemAttrText(

1407: BEGIN
1408: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMWGAPP');
1409: l_itemKey := substr(document_id, instr(document_id,':')+1);
1410:
1411: l_OBJECT_type := wf_engine.GetItemAttrText(
1412: itemtype => l_itemtype,
1413: itemkey => l_itemkey,
1414: aname => 'AMW_OBJECT_TYPE' );
1415:

Line 1416: l_approval_type := wf_engine.GetItemAttrText(

1412: itemtype => l_itemtype,
1413: itemkey => l_itemkey,
1414: aname => 'AMW_OBJECT_TYPE' );
1415:
1416: l_approval_type := wf_engine.GetItemAttrText(
1417: itemtype => l_itemtype,
1418: itemkey => l_itemkey,
1419: aname => 'AMW_APPROVAL_TYPE' );
1420:

Line 1486: l_OBJECT_type := wf_engine.GetItemAttrText(

1482: BEGIN
1483: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMWGAPP');
1484: l_itemKey := substr(document_id, instr(document_id,':')+1);
1485:
1486: l_OBJECT_type := wf_engine.GetItemAttrText(
1487: itemtype => l_itemtype,
1488: itemkey => l_itemkey,
1489: aname => 'AMW_OBJECT_TYPE' );
1490:

Line 1491: l_approval_type := wf_engine.GetItemAttrText(

1487: itemtype => l_itemtype,
1488: itemkey => l_itemkey,
1489: aname => 'AMW_OBJECT_TYPE' );
1490:
1491: l_approval_type := wf_engine.GetItemAttrText(
1492: itemtype => l_itemtype,
1493: itemkey => l_itemkey,
1494: aname => 'AMW_APPROVAL_TYPE' );
1495:

Line 1560: l_OBJECT_type := wf_engine.GetItemAttrText(

1556: BEGIN
1557: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMWGAPP');
1558: l_itemKey := substr(document_id, instr(document_id,':')+1);
1559:
1560: l_OBJECT_type := wf_engine.GetItemAttrText(
1561: itemtype => l_itemtype,
1562: itemkey => l_itemkey,
1563: aname => 'AMW_OBJECT_TYPE' );
1564:

Line 1565: l_approval_type := wf_engine.GetItemAttrText(

1561: itemtype => l_itemtype,
1562: itemkey => l_itemkey,
1563: aname => 'AMW_OBJECT_TYPE' );
1564:
1565: l_approval_type := wf_engine.GetItemAttrText(
1566: itemtype => l_itemtype,
1567: itemkey => l_itemkey,
1568: aname => 'AMW_APPROVAL_TYPE' );
1569:

Line 1642: l_OBJECT_type := wf_engine.GetItemAttrText(

1638: BEGIN
1639: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AMWGAPP');
1640: l_itemKey := substr(document_id, instr(document_id,':')+1);
1641:
1642: l_OBJECT_type := wf_engine.GetItemAttrText(
1643: itemtype => l_itemtype,
1644: itemkey => l_itemkey,
1645: aname => 'AMW_OBJECT_TYPE' );
1646:

Line 1647: l_approval_type := wf_engine.GetItemAttrText(

1643: itemtype => l_itemtype,
1644: itemkey => l_itemkey,
1645: aname => 'AMW_OBJECT_TYPE' );
1646:
1647: l_approval_type := wf_engine.GetItemAttrText(
1648: itemtype => l_itemtype,
1649: itemkey => l_itemkey,
1650: aname => 'AMW_APPROVAL_TYPE' );
1651:

Line 1652: l_appr_meaning := wf_engine.GetItemAttrText(

1648: itemtype => l_itemtype,
1649: itemkey => l_itemkey,
1650: aname => 'AMW_APPROVAL_TYPE' );
1651:
1652: l_appr_meaning := wf_engine.GetItemAttrText(
1653: itemtype => l_itemtype,
1654: itemkey => l_itemkey,
1655: aname => 'AMW_APPROVAL_OBJECT_MEANING');
1656:

Line 1657: l_appr_obj_name := wf_engine.GetItemAttrText(

1653: itemtype => l_itemtype,
1654: itemkey => l_itemkey,
1655: aname => 'AMW_APPROVAL_OBJECT_MEANING');
1656:
1657: l_appr_obj_name := wf_engine.GetItemAttrText(
1658: itemtype => l_itemtype,
1659: itemkey => l_itemkey,
1660: aname => 'AMW_APPROVAL_OBJECT_NAME');
1661:

Line 1676: l_errmsg := wf_engine.GetItemAttrText(

1672: EXECUTE IMMEDIATE dml_str USING IN document_id,IN display_type,IN OUT document, IN OUT document_type;
1673:
1674: elsif (l_return_stat = 'E') THEN -- no data found, generate a generic message
1675:
1676: l_errmsg := wf_engine.GetItemAttrText(
1677: itemtype => l_itemtype,
1678: itemkey => l_itemkey,
1679: aname => 'AMW_ERROR_MSG');
1680: fnd_message.set_name ('AMW', 'AMW_GEN_NTF_ERROR_BODY');

Line 1731: l_OBJECT_type := wf_engine.GetItemAttrText(

1727: l_approval_type varchar2(80);
1728:
1729:
1730: BEGIN
1731: l_OBJECT_type := wf_engine.GetItemAttrText(
1732: itemtype => itemtype,
1733: itemkey => itemkey,
1734: aname => 'AMW_OBJECT_TYPE' );
1735:

Line 1736: l_approval_type := wf_engine.GetItemAttrText(

1732: itemtype => itemtype,
1733: itemkey => itemkey,
1734: aname => 'AMW_OBJECT_TYPE' );
1735:
1736: l_approval_type := wf_engine.GetItemAttrText(
1737: itemtype => itemtype,
1738: itemkey => itemkey,
1739: aname => 'AMW_APPROVAL_TYPE' );
1740:

Line 1786: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

1782: resultout OUT NOCOPY varchar2 )
1783: IS
1784: BEGIN
1785: -- The Object is Approved. Set the item attribute UPDATE_GEN_STATUS to 'APPROVED'
1786: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1787: itemkey => itemkey,
1788: aname => 'UPDATE_GEN_STATUS',
1789: avalue => 'APPROVED' );
1790:

Line 1843: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

1839: l_error_msg VARCHAR2(4000);
1840: l_note VARCHAR2(4000);
1841: BEGIN
1842: -- The Object is Rejected. Set the item attribute UPDATE_GEN_STATUS to 'REJECTED'
1843: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1844: itemkey => itemkey,
1845: aname => 'UPDATE_GEN_STATUS',
1846: avalue => 'REJECTED');
1847:

Line 1848: l_OBJECT_id := Wf_Engine.GetItemAttrNumber(

1844: itemkey => itemkey,
1845: aname => 'UPDATE_GEN_STATUS',
1846: avalue => 'REJECTED');
1847:
1848: l_OBJECT_id := Wf_Engine.GetItemAttrNumber(
1849: itemtype => itemtype,
1850: itemkey => itemkey,
1851: aname => 'AMW_OBJECT_ID' );
1852:

Line 1854: l_OBJECT_type := Wf_Engine.GetItemAttrText(

1850: itemkey => itemkey,
1851: aname => 'AMW_OBJECT_ID' );
1852:
1853:
1854: l_OBJECT_type := Wf_Engine.GetItemAttrText(
1855: itemtype => itemtype,
1856: itemkey => itemkey,
1857: aname => 'AMW_OBJECT_TYPE' );
1858:

Line 1859: l_approver_seq := Wf_Engine.GetItemAttrNumber(

1855: itemtype => itemtype,
1856: itemkey => itemkey,
1857: aname => 'AMW_OBJECT_TYPE' );
1858:
1859: l_approver_seq := Wf_Engine.GetItemAttrNumber(
1860: itemtype => itemtype,
1861: itemkey => itemkey,
1862: aname => 'AMW_APPROVER_SEQ' );
1863:

Line 1864: l_version := Wf_Engine.GetItemAttrNumber(

1860: itemtype => itemtype,
1861: itemkey => itemkey,
1862: aname => 'AMW_APPROVER_SEQ' );
1863:
1864: l_version := Wf_Engine.GetItemAttrNumber(
1865: itemtype => itemtype,
1866: itemkey => itemkey,
1867: aname => 'AMW_OBJECT_VERSION_NUMBER' );
1868:

Line 1869: l_approver_id := Wf_Engine.GetItemAttrNumber(

1865: itemtype => itemtype,
1866: itemkey => itemkey,
1867: aname => 'AMW_OBJECT_VERSION_NUMBER' );
1868:
1869: l_approver_id := Wf_Engine.GetItemAttrNumber(
1870: itemtype => itemtype,
1871: itemkey => itemkey,
1872: aname => 'AMW_APPROVER_ID' );
1873:

Line 1874: l_approval_detail_id := Wf_Engine.GetItemAttrNumber(

1870: itemtype => itemtype,
1871: itemkey => itemkey,
1872: aname => 'AMW_APPROVER_ID' );
1873:
1874: l_approval_detail_id := Wf_Engine.GetItemAttrNumber(
1875: itemtype => itemtype,
1876: itemkey => itemkey,
1877: aname => 'AMW_APPROVAL_DETAIL_ID' );
1878:

Line 1879: l_approval_type := Wf_Engine.GetItemAttrText(

1875: itemtype => itemtype,
1876: itemkey => itemkey,
1877: aname => 'AMW_APPROVAL_DETAIL_ID' );
1878:
1879: l_approval_type := Wf_Engine.GetItemAttrText(
1880: itemtype => itemtype,
1881: itemkey => itemkey,
1882: aname => 'AMW_APPROVAL_TYPE' );
1883:

Line 1884: l_note := Wf_Engine.GetItemAttrText(

1880: itemtype => itemtype,
1881: itemkey => itemkey,
1882: aname => 'AMW_APPROVAL_TYPE' );
1883:
1884: l_note := Wf_Engine.GetItemAttrText(
1885: itemtype => itemtype,
1886: itemkey => itemkey,
1887: aname => 'APPROVAL_NOTE' );
1888: -- This needs to be last as it would change version number

Line 1967: l_requestor := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,

1963: -- RUN mode
1964: --
1965: IF (funcmode = 'RUN') THEN
1966: -- Get the Requestor
1967: l_requestor := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,
1968: itemkey => itemkey,
1969: aname => 'AMW_REQUESTOR_ID');
1970: -- Get the Approver
1971: l_approver := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,

Line 1971: l_approver := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,

1967: l_requestor := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,
1968: itemkey => itemkey,
1969: aname => 'AMW_REQUESTOR_ID');
1970: -- Get the Approver
1971: l_approver := Wf_Engine.GetItemAttrNumber(itemtype => itemtype,
1972: itemkey => itemkey,
1973: aname => 'AMW_APPROVER_ID');
1974: IF l_requestor = l_approver THEN
1975: resultout := 'COMPLETE:N';