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

Line 56: l_save_threshold NUMBER := wf_engine.threshold;

52:
53: l_msg_count NUMBER;
54: l_msg_data VARCHAR2(4000);
55: l_error_msg VARCHAR2(4000);
56: l_save_threshold NUMBER := wf_engine.threshold;
57: l_index NUMBER;
58: l_return_status varchar2(1);
59: l_counter NUMBER;
60: l_timeout NUMBER;

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

71: BEGIN
72:
73: fnd_msg_pub.initialize;
74:
75: -- wf_engine.threshold := -1;
76: WF_ENGINE.CreateProcess (itemtype => itemtype,
77: itemkey => itemkey ,
78: process => p_workflowprocess);
79:

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

72:
73: fnd_msg_pub.initialize;
74:
75: -- wf_engine.threshold := -1;
76: WF_ENGINE.CreateProcess (itemtype => itemtype,
77: itemkey => itemkey ,
78: process => p_workflowprocess);
79:
80: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

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

76: WF_ENGINE.CreateProcess (itemtype => itemtype,
77: itemkey => itemkey ,
78: process => p_workflowprocess);
79:
80: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
81: itemkey => itemkey ,
82: userkey => itemuserkey);
83:
84:

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

84:
85: /*****************************************************************
86: Initialize Workflow Item Attributes
87: *****************************************************************/
88: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
89: itemkey => itemkey,
90: aname => 'OBJECT_TYPE',
91: avalue => p_object );
92:

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

99: THEN
100: -- Reema:
101: -- Set the Value of Application Usage Code
102: -- This value can then be used in other procedures.
103: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
104: itemkey => itemkey,
105: aname => 'APPLICATION_USG_CODE',
106: avalue => p_application_usg_code);
107: END IF;

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

106: avalue => p_application_usg_code);
107: END IF;
108:
109: -- Activity ID (primary Id of Activity Object)
110: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype ,
111: itemkey => itemkey,
112: aname => 'OBJECT_ID',
113: avalue => p_activity_id );
114:

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

111: itemkey => itemkey,
112: aname => 'OBJECT_ID',
113: avalue => p_activity_id );
114:
115: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
116: itemkey => itemkey,
117: aname => 'ORG_STATUS_ID',
118: avalue => p_orig_status_code );
119:

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

116: itemkey => itemkey,
117: aname => 'ORG_STATUS_ID',
118: avalue => p_orig_status_code );
119:
120: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
121: itemkey => itemkey,
122: aname => 'NEW_STATUS_ID',
123: avalue => P_NEW_STATUS_CODE );
124:

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

121: itemkey => itemkey,
122: aname => 'NEW_STATUS_ID',
123: avalue => P_NEW_STATUS_CODE );
124:
125: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
126: itemkey => itemkey,
127: aname => 'REJECT_STATUS_ID',
128: avalue => p_reject_status_code );
129:

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

126: itemkey => itemkey,
127: aname => 'REJECT_STATUS_ID',
128: avalue => p_reject_status_code );
129:
130: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
131: itemkey => itemkey,
132: aname => 'OBJECT_VER',
133: avalue => p_object_version_number );
134:

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

131: itemkey => itemkey,
132: aname => 'OBJECT_VER',
133: avalue => p_object_version_number );
134:
135: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
136: itemkey => itemkey,
137: aname => 'REQUESTER_ID',
138: avalue => p_requester_userid );
139:

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

136: itemkey => itemkey,
137: aname => 'REQUESTER_ID',
138: avalue => p_requester_userid );
139:
140: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
141: itemkey => itemkey,
142: aname => 'REQUESTER_NOTE',
143: avalue => nvl(p_notes_from_requester,''));
144:

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

141: itemkey => itemkey,
142: aname => 'REQUESTER_NOTE',
143: avalue => nvl(p_notes_from_requester,''));
144:
145: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
146: itemkey => itemkey,
147: aname => 'APPROVAL_TYPE',
148: avalue => p_approval_type );
149:

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

146: itemkey => itemkey,
147: aname => 'APPROVAL_TYPE',
148: avalue => p_approval_type );
149:
150: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
151: itemkey => itemkey,
152: aname => 'REQUEST_TIME',
153: avalue => SYSDATE );
154:

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

151: itemkey => itemkey,
152: aname => 'REQUEST_TIME',
153: avalue => SYSDATE );
154:
155: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
156: itemkey => itemkey,
157: aname => 'DOCUMENT_ID',
158: avalue => itemtype || ':' ||itemkey);
159:

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

166:
167: FND_MESSAGE.Set_Name('AHL','AHL_APRV_NO_COUNTER');
168: FND_MSG_PUB.Add;
169: else
170: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
171: itemkey => itemkey,
172: aname => 'COUNTER',
173: avalue => l_counter );
174:

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

182:
183: FND_MESSAGE.Set_Name('AHL','AHL_APRV_NO_TIMEOUT');
184: FND_MSG_PUB.Add;
185: else
186: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
187: itemkey => itemkey,
188: aname => 'TIMEOUT',
189: avalue => l_timeout );
190:

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

220:
221: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
222: RAISE FND_API.G_EXC_ERROR;
223: ELSE
224: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
225: itemkey => itemkey,
226: aname => 'REQUESTER',
227: avalue => l_requester_role );
228:

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

226: aname => 'REQUESTER',
227: avalue => l_requester_role );
228:
229: -- Setting the WF Owner
230: WF_ENGINE.SetItemOwner(itemtype => itemtype,
231: itemkey => itemkey,
232: owner => l_requester_role);
233: END IF;
234:

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

232: owner => l_requester_role);
233: END IF;
234:
235: -- Start the Process
236: WF_ENGINE.StartProcess (itemtype => itemtype,
237: itemkey => itemkey);
238:
239:
240: -- wf_engine.threshold := l_save_threshold ;

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

236: WF_ENGINE.StartProcess (itemtype => itemtype,
237: itemkey => itemkey);
238:
239:
240: -- wf_engine.threshold := l_save_threshold ;
241: EXCEPTION
242: WHEN OTHERS THEN
243: -- wf_engine.threshold := l_save_threshold ;
244: FND_MSG_PUB.Count_And_Get (

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

239:
240: -- wf_engine.threshold := l_save_threshold ;
241: EXCEPTION
242: WHEN OTHERS THEN
243: -- wf_engine.threshold := l_save_threshold ;
244: FND_MSG_PUB.Count_And_Get (
245: p_encoded => FND_API.G_FALSE,
246: p_count => l_msg_count,
247: p_data => l_msg_data);

Line 303: l_object := wf_engine.GetItemAttrText(

299: FND_MSG_PUB.initialize();
300: IF (funcmode = 'RUN') THEN
301:
302: -- get approval object
303: l_object := wf_engine.GetItemAttrText(
304: itemtype => itemtype,
305: itemkey => itemkey,
306: aname => 'OBJECT_TYPE' );
307:

Line 309: l_approval_type := wf_engine.GetItemAttrText(

305: itemkey => itemkey,
306: aname => 'OBJECT_TYPE' );
307:
308:
309: l_approval_type := wf_engine.GetItemAttrText(
310: itemtype => itemtype,
311: itemkey => itemkey,
312: aname => 'APPROVAL_TYPE' );
313:

Line 445: l_approval_rule_id := wf_engine.GetItemAttrNumber(

441:
442: FND_MSG_PUB.initialize();
443:
444: IF (funcmode = 'RUN') THEN
445: l_approval_rule_id := wf_engine.GetItemAttrNumber(
446: itemtype => itemtype,
447: itemkey => itemkey,
448: aname => 'RULE_ID' );
449:

Line 450: l_current_seq := wf_engine.GetItemAttrNumber(

446: itemtype => itemtype,
447: itemkey => itemkey,
448: aname => 'RULE_ID' );
449:
450: l_current_seq := wf_engine.GetItemAttrNumber(
451: itemtype => itemtype,
452: itemkey => itemkey,
453: aname => 'APPROVER_SEQ' );
454:

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

474:
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477:
478: wf_engine.SetItemAttrText( itemtype => itemtype,
479: itemkey => itemkey,
480: aname => 'APPROVER',
481: avalue => l_approver);
482:

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

479: itemkey => itemkey,
480: aname => 'APPROVER',
481: avalue => l_approver);
482:
483: wf_engine.SetItemAttrNumber(itemtype => itemtype,
484: itemkey => itemkey,
485: aname => 'APPROVER_ID',
486: avalue => l_object_approver_id);
487:

Line 566: l_approval_rule_id := wf_engine.GetItemAttrNumber(

562: BEGIN
563:
564: FND_MSG_PUB.initialize();
565: IF (funcmode = 'RUN') THEN
566: l_approval_rule_id := wf_engine.GetItemAttrNumber(
567: itemtype => itemtype,
568: itemkey => itemkey,
569: aname => 'RULE_ID' );
570:

Line 571: l_current_seq := wf_engine.GetItemAttrNumber(

567: itemtype => itemtype,
568: itemkey => itemkey,
569: aname => 'RULE_ID' );
570:
571: l_current_seq := wf_engine.GetItemAttrNumber(
572: itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'APPROVER_SEQ' );
575:

Line 576: l_approver_id := wf_engine.GetItemAttrNumber(

572: itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'APPROVER_SEQ' );
575:
576: l_approver_id := wf_engine.GetItemAttrNumber(
577: itemtype => itemtype,
578: itemkey => itemkey,
579: aname => 'APPROVER_ID' );
580:

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

585: x_next_seq => l_next_seq,
586: x_required_flag => l_required_flag);
587:
588: IF l_next_seq is not null THEN
589: wf_engine.SetItemAttrNumber(itemtype => itemtype,
590: itemkey => itemkey,
591: aname => 'APPROVER_SEQ',
592: avalue => l_next_seq);
593: resultout := 'COMPLETE:Y';

Line 674: l_object := wf_engine.GetItemAttrText(

670: BEGIN
671: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AHLGAPP');
672: l_itemKey := substr(document_id, instr(document_id,':')+1);
673:
674: l_object := wf_engine.GetItemAttrText(
675: itemtype => l_itemtype,
676: itemkey => l_itemkey,
677: aname => 'OBJECT_TYPE' );
678:

Line 679: l_approval_type := wf_engine.GetItemAttrText(

675: itemtype => l_itemtype,
676: itemkey => l_itemkey,
677: aname => 'OBJECT_TYPE' );
678:
679: l_approval_type := wf_engine.GetItemAttrText(
680: itemtype => l_itemtype,
681: itemkey => l_itemkey,
682: aname => 'APPROVAL_TYPE' );
683:

Line 750: l_object := wf_engine.GetItemAttrText(

746: BEGIN
747: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AHLGAPP');
748: l_itemKey := substr(document_id, instr(document_id,':')+1);
749:
750: l_object := wf_engine.GetItemAttrText(
751: itemtype => l_itemtype,
752: itemkey => l_itemkey,
753: aname => 'OBJECT_TYPE' );
754:

Line 755: l_approval_type := wf_engine.GetItemAttrText(

751: itemtype => l_itemtype,
752: itemkey => l_itemkey,
753: aname => 'OBJECT_TYPE' );
754:
755: l_approval_type := wf_engine.GetItemAttrText(
756: itemtype => l_itemtype,
757: itemkey => l_itemkey,
758: aname => 'APPROVAL_TYPE' );
759:

Line 826: l_object := wf_engine.GetItemAttrText(

822: BEGIN
823: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AHLGAPP');
824: l_itemKey := substr(document_id, instr(document_id,':')+1);
825:
826: l_object := wf_engine.GetItemAttrText(
827: itemtype => l_itemtype,
828: itemkey => l_itemkey,
829: aname => 'OBJECT_TYPE' );
830:

Line 831: l_approval_type := wf_engine.GetItemAttrText(

827: itemtype => l_itemtype,
828: itemkey => l_itemkey,
829: aname => 'OBJECT_TYPE' );
830:
831: l_approval_type := wf_engine.GetItemAttrText(
832: itemtype => l_itemtype,
833: itemkey => l_itemkey,
834: aname => 'APPROVAL_TYPE' );
835:

Line 904: l_object := wf_engine.GetItemAttrText(

900: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AHLGAPP');
901:
902: l_itemKey := substr(document_id, instr(document_id,':')+1);
903:
904: l_object := wf_engine.GetItemAttrText(
905: itemtype => l_itemtype,
906: itemkey => l_itemkey,
907: aname => 'OBJECT_TYPE' );
908:

Line 909: l_approval_type := wf_engine.GetItemAttrText(

905: itemtype => l_itemtype,
906: itemkey => l_itemkey,
907: aname => 'OBJECT_TYPE' );
908:
909: l_approval_type := wf_engine.GetItemAttrText(
910: itemtype => l_itemtype,
911: itemkey => l_itemkey,
912: aname => 'APPROVAL_TYPE' );
913:

Line 980: l_object := wf_engine.GetItemAttrText(

976: BEGIN
977: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AHLGAPP');
978: l_itemKey := substr(document_id, instr(document_id,':')+1);
979:
980: l_object := wf_engine.GetItemAttrText(
981: itemtype => l_itemtype,
982: itemkey => l_itemkey,
983: aname => 'OBJECT_TYPE' );
984:

Line 985: l_approval_type := wf_engine.GetItemAttrText(

981: itemtype => l_itemtype,
982: itemkey => l_itemkey,
983: aname => 'OBJECT_TYPE' );
984:
985: l_approval_type := wf_engine.GetItemAttrText(
986: itemtype => l_itemtype,
987: itemkey => l_itemkey,
988: aname => 'APPROVAL_TYPE' );
989:

Line 1056: l_object := wf_engine.GetItemAttrText(

1052: BEGIN
1053: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AHLGAPP');
1054: l_itemKey := substr(document_id, instr(document_id,':')+1);
1055:
1056: l_object := wf_engine.GetItemAttrText(
1057: itemtype => l_itemtype,
1058: itemkey => l_itemkey,
1059: aname => 'OBJECT_TYPE' );
1060:

Line 1061: l_approval_type := wf_engine.GetItemAttrText(

1057: itemtype => l_itemtype,
1058: itemkey => l_itemkey,
1059: aname => 'OBJECT_TYPE' );
1060:
1061: l_approval_type := wf_engine.GetItemAttrText(
1062: itemtype => l_itemtype,
1063: itemkey => l_itemkey,
1064: aname => 'APPROVAL_TYPE' );
1065:

Line 1131: l_object := wf_engine.GetItemAttrText(

1127: BEGIN
1128: l_itemType := nvl(substr(document_id, 1,instr(document_id,':')-1),'AHLGAPP');
1129: l_itemKey := substr(document_id, instr(document_id,':')+1);
1130:
1131: l_object := wf_engine.GetItemAttrText(
1132: itemtype => l_itemtype,
1133: itemkey => l_itemkey,
1134: aname => 'OBJECT_TYPE' );
1135:

Line 1136: l_approval_type := wf_engine.GetItemAttrText(

1132: itemtype => l_itemtype,
1133: itemkey => l_itemkey,
1134: aname => 'OBJECT_TYPE' );
1135:
1136: l_approval_type := wf_engine.GetItemAttrText(
1137: itemtype => l_itemtype,
1138: itemkey => l_itemkey,
1139: aname => 'APPROVAL_TYPE' );
1140:

Line 1205: l_object := wf_engine.GetItemAttrText(

1201: l_error_msg VARCHAR2(4000);
1202: l_return_status varchar2(1);
1203: BEGIN
1204: FND_MSG_PUB.initialize();
1205: l_object := wf_engine.GetItemAttrText(
1206: itemtype => itemtype,
1207: itemkey => itemkey,
1208: aname => 'OBJECT_TYPE' );
1209:

Line 1210: l_approval_type := wf_engine.GetItemAttrText(

1206: itemtype => itemtype,
1207: itemkey => itemkey,
1208: aname => 'OBJECT_TYPE' );
1209:
1210: l_approval_type := wf_engine.GetItemAttrText(
1211: itemtype => itemtype,
1212: itemkey => itemkey,
1213: aname => 'APPROVAL_TYPE' );
1214:

Line 1274: l_approved_status := wf_engine.GetItemAttrText(

1270: l_error_msg VARCHAR2(4000);
1271:
1272: BEGIN
1273:
1274: l_approved_status := wf_engine.GetItemAttrText(
1275: itemtype => itemtype,
1276: itemkey => itemkey,
1277: aname => 'NEW_STATUS_ID' );
1278:

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

1275: itemtype => itemtype,
1276: itemkey => itemkey,
1277: aname => 'NEW_STATUS_ID' );
1278:
1279: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1280: itemkey => itemkey,
1281: aname => 'UPDATE_GEN_STATUS',
1282: avalue => l_approved_status );
1283:

Line 1323: l_rejected_status := wf_engine.GetItemAttrText(

1319: l_error_msg VARCHAR2(4000);
1320:
1321: BEGIN
1322:
1323: l_rejected_status := wf_engine.GetItemAttrText(
1324: itemtype => itemtype,
1325: itemkey => itemkey,
1326: aname => 'REJECT_STATUS_ID' );
1327:

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

1324: itemtype => itemtype,
1325: itemkey => itemkey,
1326: aname => 'REJECT_STATUS_ID' );
1327:
1328: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1329: itemkey => itemkey,
1330: aname => 'UPDATE_GEN_STATUS',
1331: avalue => l_rejected_status );
1332:

Line 1375: l_object := wf_engine.GetItemAttrText(

1371: l_error_msg VARCHAR2(4000);
1372: l_return_stat varchar2(1);
1373: BEGIN
1374: FND_MSG_PUB.initialize();
1375: l_object := wf_engine.GetItemAttrText(
1376: itemtype => itemtype,
1377: itemkey => itemkey,
1378: aname => 'OBJECT_TYPE' );
1379:

Line 1380: l_approval_type := wf_engine.GetItemAttrText(

1376: itemtype => itemtype,
1377: itemkey => itemkey,
1378: aname => 'OBJECT_TYPE' );
1379:
1380: l_approval_type := wf_engine.GetItemAttrText(
1381: itemtype => itemtype,
1382: itemkey => itemkey,
1383: aname => 'APPROVAL_TYPE' );
1384:

Line 1767: WF_ENGINE.SetItemAttrText

1763: END LOOP ;
1764:
1765: x_error_msg := l_final_data;
1766:
1767: WF_ENGINE.SetItemAttrText
1768: (itemtype => p_itemtype,
1769: itemkey => p_itemkey ,
1770: aname => p_attr_name,
1771: avalue => l_final_data );