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

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

39: itemkey in varchar2) is
40: i integer;
41: begin
42: FOR I IN 1..9 LOOP
43: wf_engine.SetItemAttrText (itemtype => itemtype,
44: itemkey => itemkey,
45: aname => 'MESSAGE'||i,
46: avalue => '');
47: END LOOP;

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

64: j := NVL(FND_MSG_PUB.Count_Msg,0);
65: if (j=0) then return; end if;
66: if (j>9) then j:=9; end if;
67: FOR I IN 1..J LOOP
68: wf_engine.SetItemAttrText (itemtype => itemtype,
69: itemkey => itemkey,
70: aname => 'MESSAGE'||i,
71: avalue => FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
72: END LOOP;

Line 101: l_chr_id := wf_engine.GetItemAttrNumber(

97: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
98: 'itemtype: ' || itemtype ||
99: ' itemkey: ' || itemkey);
100: END IF;
101: l_chr_id := wf_engine.GetItemAttrNumber(
102: itemtype => itemtype,
103: itemkey => itemkey,
104: aname => 'CONTRACT_ID');
105:

Line 134: l_dummy := wf_engine.GetItemAttrText

130: ' x_user_name ='||l_salesrep_name);
131: END IF;
132: -- Check if SALESREP_HD_NAME item attribute exists, if not create one
133: BEGIN
134: l_dummy := wf_engine.GetItemAttrText
135: (
136: itemtype => itemtype,
137: itemkey => itemkey,
138: aname => 'SALESREP_HD_NAME'

Line 142: wf_engine.AddItemAttr

138: aname => 'SALESREP_HD_NAME'
139: );
140: EXCEPTION
141: WHEN OTHERS THEN
142: wf_engine.AddItemAttr
143: (
144: itemtype => itemtype,
145: itemkey => itemkey,
146: aname => 'SALESREP_HD_NAME'

Line 152: wf_engine.SetItemAttrText (

148: END;
149: -- In case of errors in deriving salesrep or help desk, send the
150: -- notification to the person who initiated the process
151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_salesrep_name IS NULL THEN
152: wf_engine.SetItemAttrText (
153: itemtype => itemtype,
154: itemkey => itemkey,
155: aname => 'SALESREP_HD_NAME',
156: avalue => wf_engine.GetItemAttrText(

Line 156: avalue => wf_engine.GetItemAttrText(

152: wf_engine.SetItemAttrText (
153: itemtype => itemtype,
154: itemkey => itemkey,
155: aname => 'SALESREP_HD_NAME',
156: avalue => wf_engine.GetItemAttrText(
157: itemtype => itemtype,
158: itemkey => itemkey,
159: aname => 'INITIATOR_NAME')
160: );

Line 162: wf_engine.SetItemAttrText (

158: itemkey => itemkey,
159: aname => 'INITIATOR_NAME')
160: );
161: ELSE
162: wf_engine.SetItemAttrText (
163: itemtype => itemtype,
164: itemkey => itemkey,
165: aname => 'SALESREP_HD_NAME',
166: avalue => l_salesrep_name);

Line 170: wf_engine.SetItemAttrText (

166: avalue => l_salesrep_name);
167: END IF;
168: EXCEPTION
169: WHEN OTHERS THEN
170: wf_engine.SetItemAttrText (
171: itemtype => itemtype,
172: itemkey => itemkey,
173: aname => 'SALESREP_HD_NAME',
174: avalue => wf_engine.GetItemAttrText(

Line 174: avalue => wf_engine.GetItemAttrText(

170: wf_engine.SetItemAttrText (
171: itemtype => itemtype,
172: itemkey => itemkey,
173: aname => 'SALESREP_HD_NAME',
174: avalue => wf_engine.GetItemAttrText(
175: itemtype => itemtype,
176: itemkey => itemkey,
177: aname => 'INITIATOR_NAME')
178: );

Line 204: l_initiator varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'INITIATOR_NAME');

200: x_name out nocopy varchar2
201: ) is
202:
203: l_api_name CONSTANT VARCHAR2(30) := 'select_next';
204: l_initiator varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'INITIATOR_NAME');
205: l_approver varchar2(100) :=
206: NVL(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'),
207: wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME'));
208: l_id number;

Line 206: NVL(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'),

202:
203: l_api_name CONSTANT VARCHAR2(30) := 'select_next';
204: l_initiator varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'INITIATOR_NAME');
205: l_approver varchar2(100) :=
206: NVL(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'),
207: wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME'));
208: l_id number;
209: l_item_classes ame_util.stringList;
210: l_item_ids ame_util.stringList;

Line 207: wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME'));

203: l_api_name CONSTANT VARCHAR2(30) := 'select_next';
204: l_initiator varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'INITIATOR_NAME');
205: l_approver varchar2(100) :=
206: NVL(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'),
207: wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME'));
208: l_id number;
209: l_item_classes ame_util.stringList;
210: l_item_ids ame_util.stringList;
211: l_completed ame_util.charList;

Line 271: x_role := wf_engine.GetItemAttrText(

267: --
268: -- Administrator is backup guy - here = initiator
269: --
270: if (p_role_type = 'ADMINISTRATOR') then
271: x_role := wf_engine.GetItemAttrText(
272: itemtype => itemtype,
273: itemkey => itemkey,
274: aname => 'INITIATOR_NAME');
275: x_name := wf_engine.GetItemAttrText(

Line 275: x_name := wf_engine.GetItemAttrText(

271: x_role := wf_engine.GetItemAttrText(
272: itemtype => itemtype,
273: itemkey => itemkey,
274: aname => 'INITIATOR_NAME');
275: x_name := wf_engine.GetItemAttrText(
276: itemtype => itemtype,
277: itemkey => itemkey,
278: aname => 'INITIATOR_DISPLAY_NAME');
279: --

Line 283: x_role := wf_engine.GetItemAttrText(

279: --
280: -- Signotory here = initiator
281: --
282: elsif (p_role_type = 'SIGNATORY') then
283: x_role := wf_engine.GetItemAttrText(
284: itemtype => itemtype,
285: itemkey => itemkey,
286: aname => 'INITIATOR_NAME');
287: x_name := wf_engine.GetItemAttrText(

Line 287: x_name := wf_engine.GetItemAttrText(

283: x_role := wf_engine.GetItemAttrText(
284: itemtype => itemtype,
285: itemkey => itemkey,
286: aname => 'INITIATOR_NAME');
287: x_name := wf_engine.GetItemAttrText(
288: itemtype => itemtype,
289: itemkey => itemkey,
290: aname => 'INITIATOR_DISPLAY_NAME');
291: --

Line 295: l_id := wf_engine.GetItemAttrNumber(

291: --
292: -- Approver - in cursor
293: --
294: elsif (p_role_type = 'APPROVER') then
295: l_id := wf_engine.GetItemAttrNumber(
296: itemtype => itemtype,
297: itemkey => itemkey,
298: aname => 'CONTRACT_ID');
299:

Line 434: open c1(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'));

430: --
431: -- RUN mode - normal process execution
432: --
433: if (funcmode = 'RUN') then
434: open c1(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'));
435: fetch c1 into l_dummy;
436: close c1;
437: resultout := 'COMPLETE:'||l_dummy;
438: end if;

Line 542: l_name varchar2(100):=wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');

538: itemkey in varchar2,
539: actid in number,
540: funcmode in varchar2,
541: resultout out nocopy varchar2 ) is
542: l_name varchar2(100):=wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
543: l_display_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'N_PERFORMER_DISPLAY_NAME');
544: l_context varchar2(100);
545: l_id varchar2(100);
546: l_original varchar2(100):=wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');

Line 543: l_display_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'N_PERFORMER_DISPLAY_NAME');

539: actid in number,
540: funcmode in varchar2,
541: resultout out nocopy varchar2 ) is
542: l_name varchar2(100):=wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
543: l_display_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'N_PERFORMER_DISPLAY_NAME');
544: l_context varchar2(100);
545: l_id varchar2(100);
546: l_original varchar2(100):=wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
547:

Line 546: l_original varchar2(100):=wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');

542: l_name varchar2(100):=wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
543: l_display_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'N_PERFORMER_DISPLAY_NAME');
544: l_context varchar2(100);
545: l_id varchar2(100);
546: l_original varchar2(100):=wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
547:
548: /* the cursor changed because of bug#2316572 -- INCORRECT APPROVER NAME FOR FORWARDED CONTRACT APPROVAL
549: cursor Actual_Performer_csr is
550: select --+ORDERED

Line 594: l_context := wf_engine.context_text;

590: -- RESPOND mode
591: -- and TRANSFER mode added after the bug#2316572
592: -- if (funcmode = 'RESPOND') then -- also bug#2316572 - we need handle TRANSFER as well
593: if (funcmode in('RESPOND','TRANSFER')) then
594: l_context := wf_engine.context_text;
595:
596: IF l_context like 'email:%' THEN
597: OPEN csr_actual_performer_1(l_context);
598: FETCH csr_actual_performer_1 INTO l_name, l_display_name;

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

602: FETCH csr_actual_performer_2 INTO l_name, l_display_name;
603: CLOSE csr_actual_performer_2;
604: END IF;
605:
606: wf_engine.SetItemAttrText (itemtype => itemtype,
607: itemkey => itemkey,
608: aname => 'ACTUAL_PERFORMER',
609: avalue => l_name);
610: wf_engine.SetItemAttrText (itemtype => itemtype,

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

606: wf_engine.SetItemAttrText (itemtype => itemtype,
607: itemkey => itemkey,
608: aname => 'ACTUAL_PERFORMER',
609: avalue => l_name);
610: wf_engine.SetItemAttrText (itemtype => itemtype,
611: itemkey => itemkey,
612: aname => 'ACTUAL_PERFORMER_D',
613: avalue => l_display_name);
614: wf_engine.SetItemAttrText (itemtype => itemtype,

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

610: wf_engine.SetItemAttrText (itemtype => itemtype,
611: itemkey => itemkey,
612: aname => 'ACTUAL_PERFORMER_D',
613: avalue => l_display_name);
614: wf_engine.SetItemAttrText (itemtype => itemtype,
615: itemkey => itemkey,
616: aname => 'FROM',
617: avalue => l_name);
618:

Line 685: l_context := wf_engine.context_text;

681: where u.NAME=p_context;
682:
683: begin
684: if (funcmode in('RESPOND','TRANSFER')) then
685: l_context := wf_engine.context_text;
686:
687: IF l_context like 'email:%' THEN
688: OPEN csr_actual_performer_1(l_context);
689: FETCH csr_actual_performer_1 INTO l_name, l_display_name;

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

693: FETCH csr_actual_performer_2 INTO l_name, l_display_name;
694: CLOSE csr_actual_performer_2;
695: END IF;
696:
697: wf_engine.SetItemAttrText (itemtype => itemtype,
698: itemkey => itemkey,
699: aname => 'SIGNATORY_USERNAME',
700: avalue => l_name);
701: wf_engine.SetItemAttrText (itemtype => itemtype,

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

697: wf_engine.SetItemAttrText (itemtype => itemtype,
698: itemkey => itemkey,
699: aname => 'SIGNATORY_USERNAME',
700: avalue => l_name);
701: wf_engine.SetItemAttrText (itemtype => itemtype,
702: itemkey => itemkey,
703: aname => 'SIGNATORY_DISPLAY_NAME',
704: avalue => l_display_name);
705: wf_engine.SetItemAttrText (itemtype => itemtype,

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

701: wf_engine.SetItemAttrText (itemtype => itemtype,
702: itemkey => itemkey,
703: aname => 'SIGNATORY_DISPLAY_NAME',
704: avalue => l_display_name);
705: wf_engine.SetItemAttrText (itemtype => itemtype,
706: itemkey => itemkey,
707: aname => 'FROM',
708: avalue => l_name);
709: return;

Line 742: where R.chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')

738: /* commented by GunA
739: cursor c1 is
740: select 'T'
741: from OKC_K_REL_OBJS_V R, ASO_Quote_Headers_ALL Q
742: where R.chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
743: -- and R.RTY_CODE = 'CONTRACTNEGOTIATESQUOTE'
744: and R.RTY_CODE like 'CONTRACT%IS%TERM%FOR%QUOTE'
745: and R.CLE_ID IS NULL
746: and Q.QUOTE_HEADER_ID = R.OBJECT1_ID1

Line 754: where chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')

750: -- Bug#2208391 - added check of profile option 'OKC_CREATE_ORDER_FROM_K'
751: CURSOR c1 is
752: select 'T'
753: from okc_k_rel_objs
754: where chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
755: and JTOT_OBJECT1_CODE = G_OBJECT_CODE
756: ---and RTY_CODE = G_TERMSFORQUOTE ;
757: -- and RTY_CODE in (G_TERMSFORQUOTE, G_NEGOTIATESQUOTE);
758: and (RTY_CODE=G_TERMSFORQUOTE OR RTY_CODE=G_NEGOTIATESQUOTE

Line 822: if (wf_engine.GetItemAttrText(itemtype,itemkey,'NOTE') is NULL) then

818: --
819: -- RUN mode - normal process execution
820: --
821: if (funcmode = 'RUN') then
822: if (wf_engine.GetItemAttrText(itemtype,itemkey,'NOTE') is NULL) then
823: resultout := 'COMPLETE:F';
824: else
825: resultout := 'COMPLETE:T';
826: end if;

Line 876: where id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')

872: -- Cursor to check if contract is a template
873: CURSOR c1 is
874: select 'T'
875: from okc_k_headers_v
876: where id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
877: and template_yn = 'Y';
878: --
879: BEGIN
880: --

Line 997: l_id := wf_engine.GetItemAttrNumber(

993: if (funcmode = 'RUN') then
994: --
995: -- Initiator/Initial
996: --
997: l_id := wf_engine.GetItemAttrNumber(
998: itemtype => itemtype,
999: itemkey => itemkey,
1000: aname => 'USER_ID');
1001: open C_INITIATOR_DISPLAY_NAME(l_id);

Line 1009: wf_engine.SetItemAttrText (

1005: IF (l_debug = 'Y') THEN
1006: okc_debug.log('OKSWCAPB: Initialize() USER_ID='||l_id, 2);
1007: END IF;
1008:
1009: wf_engine.SetItemAttrText (
1010: itemtype => itemtype,
1011: itemkey => itemkey,
1012: aname => 'INITIATOR_NAME',
1013: avalue => L_INITIATOR_NAME);

Line 1014: wf_engine.SetItemAttrText (

1010: itemtype => itemtype,
1011: itemkey => itemkey,
1012: aname => 'INITIATOR_NAME',
1013: avalue => L_INITIATOR_NAME);
1014: wf_engine.SetItemAttrText (
1015: itemtype => itemtype,
1016: itemkey => itemkey,
1017: aname => 'INITIATOR_DISPLAY_NAME',
1018: avalue => L_INITIATOR_DISPLAY_NAME);

Line 1019: wf_engine.SetItemAttrText (

1015: itemtype => itemtype,
1016: itemkey => itemkey,
1017: aname => 'INITIATOR_DISPLAY_NAME',
1018: avalue => L_INITIATOR_DISPLAY_NAME);
1019: wf_engine.SetItemAttrText (
1020: itemtype => itemtype,
1021: itemkey => itemkey,
1022: aname => 'FROM',
1023: avalue => L_INITIATOR_NAME);

Line 1032: wf_engine.SetItemAttrText (

1028: itemkey => itemkey,
1029: p_role_type => 'ADMINISTRATOR',
1030: x_role => L_CONTRACT_ADMIN_USERNAME,
1031: x_name => V_DUMMY);
1032: wf_engine.SetItemAttrText (
1033: itemtype => itemtype,
1034: itemkey => itemkey,
1035: aname => 'CONTRACT_ADMIN_USERNAME',
1036: avalue => L_CONTRACT_ADMIN_USERNAME);

Line 1045: wf_engine.SetItemAttrText (

1041: itemkey => itemkey,
1042: p_role_type => 'SIGNATORY',
1043: x_role => L_SIGNATORY_USERNAME,
1044: x_name => L_SIGNATORY_DISPLAY_NAME);
1045: wf_engine.SetItemAttrText (
1046: itemtype => itemtype,
1047: itemkey => itemkey,
1048: aname => 'SIGNATORY_USERNAME',
1049: avalue => L_SIGNATORY_USERNAME);

Line 1051: wf_engine.SetItemAttrText (

1047: itemkey => itemkey,
1048: aname => 'SIGNATORY_USERNAME',
1049: avalue => L_SIGNATORY_USERNAME);
1050:
1051: wf_engine.SetItemAttrText (
1052: itemtype => itemtype,
1053: itemkey => itemkey,
1054: aname => 'SIGNATORY_DISPLAY_NAME',
1055: avalue => L_SIGNATORY_DISPLAY_NAME);

Line 1057: l_id := wf_engine.GetItemAttrNumber(

1053: itemkey => itemkey,
1054: aname => 'SIGNATORY_DISPLAY_NAME',
1055: avalue => L_SIGNATORY_DISPLAY_NAME);
1056: --
1057: l_id := wf_engine.GetItemAttrNumber(
1058: itemtype => itemtype,
1059: itemkey => itemkey,
1060: aname => 'CONTRACT_ID');
1061: IF (l_debug = 'Y') THEN

Line 1076: wf_engine.SetItemAttrText (

1072:
1073: open C_K_SHORT_DESCRIPTION(l_id);
1074: fetch C_K_SHORT_DESCRIPTION into L_K_SHORT_DESCRIPTION;
1075: close C_K_SHORT_DESCRIPTION;
1076: wf_engine.SetItemAttrText (
1077: itemtype => itemtype,
1078: itemkey => itemkey,
1079: aname => 'K_SHORT_DESCRIPTION',
1080: avalue => L_K_SHORT_DESCRIPTION);

Line 1172: L_NEXT_PERFORMER_USERNAME := wf_engine.GetItemAttrText(

1168: --
1169: -- RUN mode - normal process execution
1170: --
1171: if (funcmode = 'RUN') then
1172: L_NEXT_PERFORMER_USERNAME := wf_engine.GetItemAttrText(
1173: itemtype => itemtype,
1174: itemkey => itemkey,
1175: aname => 'NEXT_PERFORMER_USERNAME');
1176: if (L_NEXT_PERFORMER_USERNAME is NULL) then -- just start

Line 1177: L_INITIATOR_DISPLAY_NAME := wf_engine.GetItemAttrText(

1173: itemtype => itemtype,
1174: itemkey => itemkey,
1175: aname => 'NEXT_PERFORMER_USERNAME');
1176: if (L_NEXT_PERFORMER_USERNAME is NULL) then -- just start
1177: L_INITIATOR_DISPLAY_NAME := wf_engine.GetItemAttrText(
1178: itemtype => itemtype,
1179: itemkey => itemkey,
1180: aname => 'INITIATOR_DISPLAY_NAME');
1181: -- Empty message attributes so that we can push new messages in case of errors

Line 1212: wf_engine.SetItemAttrText (

1208: END;
1209: -- just for common situation if no approvers at all
1210: -- then Contract is considered as approved by initiator
1211: if (L_NEXT_PERFORMER_USERNAME is NULL) then
1212: wf_engine.SetItemAttrText (
1213: itemtype => itemtype,
1214: itemkey => itemkey,
1215: aname => 'N_PERFORMER_DISPLAY_NAME',
1216: avalue => L_INITIATOR_DISPLAY_NAME);

Line 1217: wf_engine.SetItemAttrText (

1213: itemtype => itemtype,
1214: itemkey => itemkey,
1215: aname => 'N_PERFORMER_DISPLAY_NAME',
1216: avalue => L_INITIATOR_DISPLAY_NAME);
1217: wf_engine.SetItemAttrText (
1218: itemtype => itemtype,
1219: itemkey => itemkey,
1220: aname => 'FINAL_APPROVER_UNAME',
1221: avalue => NULL);

Line 1224: wf_engine.SetItemAttrText (

1220: aname => 'FINAL_APPROVER_UNAME',
1221: avalue => NULL);
1222: resultout := 'COMPLETE:F';
1223: else
1224: wf_engine.SetItemAttrText (
1225: itemtype => itemtype,
1226: itemkey => itemkey,
1227: aname => 'P_PERFORMER_DISPLAY_NAME',
1228: avalue => L_INITIATOR_DISPLAY_NAME);

Line 1229: wf_engine.SetItemAttrText (

1225: itemtype => itemtype,
1226: itemkey => itemkey,
1227: aname => 'P_PERFORMER_DISPLAY_NAME',
1228: avalue => L_INITIATOR_DISPLAY_NAME);
1229: wf_engine.SetItemAttrText (
1230: itemtype => itemtype,
1231: itemkey => itemkey,
1232: aname => 'NEXT_PERFORMER_USERNAME',
1233: avalue => L_NEXT_PERFORMER_USERNAME);

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

1230: itemtype => itemtype,
1231: itemkey => itemkey,
1232: aname => 'NEXT_PERFORMER_USERNAME',
1233: avalue => L_NEXT_PERFORMER_USERNAME);
1234: wf_engine.SetItemAttrText(itemtype => itemtype,
1235: itemkey => itemkey,
1236: aname => 'N_PERFORMER_DISPLAY_NAME',
1237: avalue => L_N_PERFORMER_DISPLAY_NAME);
1238: resultout := 'COMPLETE:T';

Line 1242: wf_engine.SetItemAttrText

1238: resultout := 'COMPLETE:T';
1239: end if;
1240: return;
1241: else
1242: wf_engine.SetItemAttrText
1243: (
1244: itemtype => itemtype,
1245: itemkey => itemkey,
1246: aname => 'P_PERFORMER_DISPLAY_NAME',

Line 1247: avalue => wf_engine.GetItemAttrText(

1243: (
1244: itemtype => itemtype,
1245: itemkey => itemkey,
1246: aname => 'P_PERFORMER_DISPLAY_NAME',
1247: avalue => wf_engine.GetItemAttrText(
1248: itemtype => itemtype,
1249: itemkey => itemkey,
1250: aname => 'N_PERFORMER_DISPLAY_NAME')
1251: );

Line 1282: wf_engine.SetItemAttrText (

1278: resultout := 'COMPLETE:';
1279: return;
1280: END;
1281: if (L_NEXT_PERFORMER_USERNAME_OUT is NULL) then
1282: wf_engine.SetItemAttrText (
1283: itemtype => itemtype,
1284: itemkey => itemkey,
1285: aname => 'FINAL_APPROVER_UNAME',
1286: avalue => wf_engine.GetItemAttrText(

Line 1286: avalue => wf_engine.GetItemAttrText(

1282: wf_engine.SetItemAttrText (
1283: itemtype => itemtype,
1284: itemkey => itemkey,
1285: aname => 'FINAL_APPROVER_UNAME',
1286: avalue => wf_engine.GetItemAttrText(
1287: itemtype => itemtype,
1288: itemkey => itemkey,
1289: aname => 'NEXT_PERFORMER_USERNAME'));
1290:

Line 1291: wf_engine.SetItemAttrText (

1287: itemtype => itemtype,
1288: itemkey => itemkey,
1289: aname => 'NEXT_PERFORMER_USERNAME'));
1290:
1291: wf_engine.SetItemAttrText (
1292: itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => 'NEXT_PERFORMER_USERNAME',
1295: avalue => NULL);

Line 1300: wf_engine.SetItemAttrText (

1296: resultout := 'COMPLETE:F';
1297:
1298: else
1299:
1300: wf_engine.SetItemAttrText (
1301: itemtype => itemtype,
1302: itemkey => itemkey,
1303: aname => 'NEXT_PERFORMER_USERNAME',
1304: avalue => L_NEXT_PERFORMER_USERNAME_OUT);

Line 1306: wf_engine.SetItemAttrText(

1302: itemkey => itemkey,
1303: aname => 'NEXT_PERFORMER_USERNAME',
1304: avalue => L_NEXT_PERFORMER_USERNAME_OUT);
1305:
1306: wf_engine.SetItemAttrText(
1307: itemtype => itemtype,
1308: itemkey => itemkey,
1309: aname => 'N_PERFORMER_DISPLAY_NAME',
1310: avalue => L_N_PERFORMER_DISPLAY_NAME);

Line 1374: transactionIdIn => wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ID'),

1370:
1371: ame_api2.updateApprovalStatus2(
1372: applicationIdIn => G_APPLICATION_ID,
1373: transactionTypeIn => G_TRANSACTION_TYPE,
1374: transactionIdIn => wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ID'),
1375: approvalStatusIn => ame_util.approvedStatus,
1376: approverNameIn => wf_engine.GetItemAttrText(itemtype,itemkey,'ACTUAL_PERFORMER'),
1377: forwardeeIn => ame_util.emptyApproverRecord2
1378: );

Line 1376: approverNameIn => wf_engine.GetItemAttrText(itemtype,itemkey,'ACTUAL_PERFORMER'),

1372: applicationIdIn => G_APPLICATION_ID,
1373: transactionTypeIn => G_TRANSACTION_TYPE,
1374: transactionIdIn => wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ID'),
1375: approvalStatusIn => ame_util.approvedStatus,
1376: approverNameIn => wf_engine.GetItemAttrText(itemtype,itemkey,'ACTUAL_PERFORMER'),
1377: forwardeeIn => ame_util.emptyApproverRecord2
1378: );
1379:
1380: end;

Line 1406: L_NEXT_INFORMED_USERNAME := wf_engine.GetItemAttrText(

1402: -- RUN mode - normal process execution
1403: --
1404: if (funcmode = 'RUN') then
1405:
1406: L_NEXT_INFORMED_USERNAME := wf_engine.GetItemAttrText(
1407: itemtype => itemtype,
1408: itemkey => itemkey,
1409: aname => 'NEXT_INFORMED_USERNAME');
1410:

Line 1418: wf_engine.SetItemAttrText (

1414: p_current => L_NEXT_INFORMED_USERNAME,
1415: x_role => L_NEXT_INFORMED_USERNAME_OUT,
1416: x_name => V_DUMMY);
1417:
1418: wf_engine.SetItemAttrText (
1419: itemtype => itemtype,
1420: itemkey => itemkey,
1421: aname => 'NEXT_INFORMED_USERNAME',
1422: avalue => L_NEXT_INFORMED_USERNAME_OUT);

Line 1539: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(

1535: if (funcmode = 'RUN') then
1536:
1537: empty_mess( itemtype,
1538: itemkey );
1539: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
1540: itemtype => itemtype,
1541: itemkey => itemkey,
1542: aname => 'CONTRACT_ID');
1543: OKC_CONTRACT_APPROVAL_PUB.k_approved(

Line 1549: wf_engine.SetItemAttrDate (

1545: x_return_status => x_return_status);
1546: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
1547: then
1548: --
1549: wf_engine.SetItemAttrDate (
1550: itemtype => itemtype,
1551: itemkey => itemkey,
1552: aname => 'DATE_SIGNED',
1553: avalue => sysdate);

Line 1620: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(

1616: if (funcmode = 'RUN') then
1617: --
1618: empty_mess( itemtype,
1619: itemkey );
1620: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
1621: itemtype => itemtype,
1622: itemkey => itemkey,
1623: aname => 'CONTRACT_ID');
1624: OKC_CONTRACT_APPROVAL_PUB.k_erase_approved(

Line 1697: L_DATE_SIGNED := wf_engine.GetItemAttrDate (

1693: if (funcmode = 'RUN') then
1694: --
1695: empty_mess( itemtype,
1696: itemkey );
1697: L_DATE_SIGNED := wf_engine.GetItemAttrDate (
1698: itemtype => itemtype,
1699: itemkey => itemkey,
1700: aname => 'DATE_SIGNED');
1701: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(

Line 1701: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(

1697: L_DATE_SIGNED := wf_engine.GetItemAttrDate (
1698: itemtype => itemtype,
1699: itemkey => itemkey,
1700: aname => 'DATE_SIGNED');
1701: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
1702: itemtype => itemtype,
1703: itemkey => itemkey,
1704: aname => 'CONTRACT_ID');
1705: OKC_CONTRACT_APPROVAL_PUB.k_signed(

Line 1782: l_contract_id := wf_engine.GetItemAttrNumber(

1778:
1779: empty_mess(itemtype,
1780: itemkey );
1781:
1782: l_contract_id := wf_engine.GetItemAttrNumber(
1783: itemtype => itemtype,
1784: itemkey => itemkey,
1785: aname => 'CONTRACT_ID');
1786:

Line 1867: if (wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME') is NULL) then

1863: --
1864: -- RUN mode - normal process execution
1865: --
1866: if (funcmode = 'RUN') then
1867: if (wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME') is NULL) then
1868: resultout := 'COMPLETE:F';
1869: else
1870: resultout := 'COMPLETE:T';
1871: end if;

Line 1936: l_contract_id := wf_engine.GetItemAttrNumber(

1932: --
1933: If (funcmode = 'RUN') then
1934: --
1935:
1936: l_contract_id := wf_engine.GetItemAttrNumber(
1937: itemtype => itemtype,
1938: itemkey => itemkey,
1939: aname => 'CONTRACT_ID');
1940: empty_mess( itemtype,

Line 2004: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(

2000: if (funcmode = 'RUN') then
2001: --
2002: empty_mess( itemtype,
2003: itemkey );
2004: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
2005: itemtype => itemtype,
2006: itemkey => itemkey,
2007: aname => 'CONTRACT_ID');
2008: OKC_CONTRACT_APPROVAL_PUB.activate_template(

Line 2092: wf_engine.SetItemAttrNumber (

2088: OPEN csr_session_id;
2089: FETCH csr_session_id INTO l_session_id;
2090: CLOSE csr_session_id;
2091:
2092: wf_engine.SetItemAttrNumber (
2093: itemtype => itemtype,
2094: itemkey=> itemkey,
2095: aname => 'QUOTE_SESSION_ID',
2096: avalue=> l_session_id);

Line 2098: l_contract_id := wf_engine.GetItemAttrNumber(

2094: itemkey=> itemkey,
2095: aname => 'QUOTE_SESSION_ID',
2096: avalue=> l_session_id);
2097: --
2098: l_contract_id := wf_engine.GetItemAttrNumber(
2099: itemtype => itemtype,
2100: itemkey => itemkey,
2101: aname => 'CONTRACT_ID');
2102:

Line 2204: l_contract_id := wf_engine.GetItemAttrNumber(

2200: --
2201: IF (funcmode = 'RUN') THEN
2202: empty_mess( itemtype, itemkey );
2203:
2204: l_contract_id := wf_engine.GetItemAttrNumber(
2205: itemtype => itemtype,
2206: itemkey => itemkey,
2207: aname => 'CONTRACT_ID');
2208:

Line 2310: l_contract_id := wf_engine.GetItemAttrNumber(

2306: --
2307: IF (funcmode = 'RUN') THEN
2308: empty_mess( itemtype, itemkey );
2309:
2310: l_contract_id := wf_engine.GetItemAttrNumber(
2311: itemtype => itemtype,
2312: itemkey => itemkey,
2313: aname => 'CONTRACT_ID');
2314: