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

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

17: itemkey in varchar2) is
18: i integer;
19: begin
20: FOR I IN 1..9 LOOP
21: wf_engine.SetItemAttrText (itemtype => itemtype,
22: itemkey => itemkey,
23: aname => 'MESSAGE'||i,
24: avalue => '');
25: END LOOP;

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

42: j := NVL(FND_MSG_PUB.Count_Msg,0);
43: if (j=0) then return; end if;
44: if (j>9) then j:=9; end if;
45: FOR I IN 1..J LOOP
46: wf_engine.SetItemAttrText (itemtype => itemtype,
47: itemkey => itemkey,
48: aname => 'MESSAGE'||i,
49: avalue => FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
50: END LOOP;

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

142: -- COLUMN="\"WF Role Name\"(30)"
143:
144: */
145:
146: l_initiator varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'INITIATOR_NAME');
147: l_approver varchar2(100) :=
148: NVL(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'),
149: wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME'));
150:

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

144: */
145:
146: l_initiator varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'INITIATOR_NAME');
147: l_approver varchar2(100) :=
148: NVL(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'),
149: wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME'));
150:
151: --
152: -- Next Informed Cursor = Initiator + Approver

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

145:
146: l_initiator varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'INITIATOR_NAME');
147: l_approver varchar2(100) :=
148: NVL(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'),
149: wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME'));
150:
151: --
152: -- Next Informed Cursor = Initiator + Approver
153: --

Line 218: x_role := wf_engine.GetItemAttrText(

214: --
215: -- Administrator is backup guy - here = initiator
216: --
217: if (p_role_type = 'ADMINISTRATOR') then
218: x_role := wf_engine.GetItemAttrText(
219: itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'INITIATOR_NAME');
222: x_name := wf_engine.GetItemAttrText(

Line 222: x_name := wf_engine.GetItemAttrText(

218: x_role := wf_engine.GetItemAttrText(
219: itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'INITIATOR_NAME');
222: x_name := wf_engine.GetItemAttrText(
223: itemtype => itemtype,
224: itemkey => itemkey,
225: aname => 'INITIATOR_DISPLAY_NAME');
226: --

Line 230: x_role := wf_engine.GetItemAttrText(

226: --
227: -- Signotory here = initiator
228: --
229: elsif (p_role_type = 'SIGNATORY') then
230: x_role := wf_engine.GetItemAttrText(
231: itemtype => itemtype,
232: itemkey => itemkey,
233: aname => 'INITIATOR_NAME');
234: x_name := wf_engine.GetItemAttrText(

Line 234: x_name := wf_engine.GetItemAttrText(

230: x_role := wf_engine.GetItemAttrText(
231: itemtype => itemtype,
232: itemkey => itemkey,
233: aname => 'INITIATOR_NAME');
234: x_name := wf_engine.GetItemAttrText(
235: itemtype => itemtype,
236: itemkey => itemkey,
237: aname => 'INITIATOR_DISPLAY_NAME');
238: --

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

295: --
296: -- RUN mode - normal process execution
297: --
298: if (funcmode = 'RUN') then
299: open c1(wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME'));
300: fetch c1 into l_dummy;
301: close c1;
302: resultout := 'COMPLETE:'||l_dummy;
303: end if;

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

401: itemkey in varchar2,
402: actid in number,
403: funcmode in varchar2,
404: resultout out nocopy varchar2 ) is
405: l_name varchar2(100):=wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
406: l_display_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'N_PERFORMER_DISPLAY_NAME');
407: l_context varchar2(100);
408: /* the cursor changed because of bug#2316572 -- INCORRECT APPROVER NAME FOR FORWARDED CONTRACT APPROVAL
409: cursor Actual_Performer_csr is

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

402: actid in number,
403: funcmode in varchar2,
404: resultout out nocopy varchar2 ) is
405: l_name varchar2(100):=wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
406: l_display_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'N_PERFORMER_DISPLAY_NAME');
407: l_context varchar2(100);
408: /* the cursor changed because of bug#2316572 -- INCORRECT APPROVER NAME FOR FORWARDED CONTRACT APPROVAL
409: cursor Actual_Performer_csr is
410: select --+ORDERED

Line 443: l_context := wf_engine.context_text;

439: -- RESPOND mode
440: -- and TRANSFER mode added after the bug#2316572
441: -- if (funcmode = 'RESPOND') then -- also bug#2316572 - we need handle TRANSFER as well
442: if (funcmode in('RESPOND','TRANSFER')) then
443: l_context := wf_engine.context_text;
444: open Actual_Performer_csr;
445: fetch Actual_Performer_csr into l_name, l_display_name;
446: close Actual_Performer_csr;
447: wf_engine.SetItemAttrText (itemtype => itemtype,

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

443: l_context := wf_engine.context_text;
444: open Actual_Performer_csr;
445: fetch Actual_Performer_csr into l_name, l_display_name;
446: close Actual_Performer_csr;
447: wf_engine.SetItemAttrText (itemtype => itemtype,
448: itemkey => itemkey,
449: aname => 'ACTUAL_PERFORMER',
450: avalue => l_name);
451: wf_engine.SetItemAttrText (itemtype => itemtype,

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

447: wf_engine.SetItemAttrText (itemtype => itemtype,
448: itemkey => itemkey,
449: aname => 'ACTUAL_PERFORMER',
450: avalue => l_name);
451: wf_engine.SetItemAttrText (itemtype => itemtype,
452: itemkey => itemkey,
453: aname => 'ACTUAL_PERFORMER_D',
454: avalue => l_display_name);
455: return;

Line 506: l_context := wf_engine.context_text;

502: (l_context like 'email:%' and u.EMAIL_ADDRESS=substr(l_context,7))
503: );
504: begin
505: if (funcmode in('RESPOND','TRANSFER')) then
506: l_context := wf_engine.context_text;
507: open Actual_Performer_csr;
508: fetch Actual_Performer_csr into l_name, l_display_name;
509: close Actual_Performer_csr;
510: wf_engine.SetItemAttrText (itemtype => itemtype,

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

506: l_context := wf_engine.context_text;
507: open Actual_Performer_csr;
508: fetch Actual_Performer_csr into l_name, l_display_name;
509: close Actual_Performer_csr;
510: wf_engine.SetItemAttrText (itemtype => itemtype,
511: itemkey => itemkey,
512: aname => 'SIGNATORY_USERNAME',
513: avalue => l_name);
514: wf_engine.SetItemAttrText (itemtype => itemtype,

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

510: wf_engine.SetItemAttrText (itemtype => itemtype,
511: itemkey => itemkey,
512: aname => 'SIGNATORY_USERNAME',
513: avalue => l_name);
514: wf_engine.SetItemAttrText (itemtype => itemtype,
515: itemkey => itemkey,
516: aname => 'SIGNATORY_DISPLAY_NAME',
517: avalue => l_display_name);
518: return;

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

547: /* commented by GunA
548: cursor c1 is
549: select 'T'
550: from OKC_K_REL_OBJS_V R, ASO_Quote_Headers_ALL Q
551: where R.chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
552: -- and R.RTY_CODE = 'CONTRACTNEGOTIATESQUOTE'
553: and R.RTY_CODE like 'CONTRACT%IS%TERM%FOR%QUOTE'
554: and R.CLE_ID IS NULL
555: and Q.QUOTE_HEADER_ID = R.OBJECT1_ID1

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

559: -- Bug#2208391 - added check of profile option 'OKC_CREATE_ORDER_FROM_K'
560: CURSOR c1 is
561: select 'T'
562: from okc_k_rel_objs
563: where chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
564: and JTOT_OBJECT1_CODE = G_OBJECT_CODE
565: ---and RTY_CODE = G_TERMSFORQUOTE ;
566: -- and RTY_CODE in (G_TERMSFORQUOTE, G_NEGOTIATESQUOTE);
567: and (RTY_CODE=G_TERMSFORQUOTE OR RTY_CODE=G_NEGOTIATESQUOTE

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

627: --
628: -- RUN mode - normal process execution
629: --
630: if (funcmode = 'RUN') then
631: if (wf_engine.GetItemAttrText(itemtype,itemkey,'NOTE') is NULL) then
632: resultout := 'COMPLETE:F';
633: else
634: resultout := 'COMPLETE:T';
635: end if;

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

681: -- Cursor to check if contract is a template
682: CURSOR c1 is
683: select 'T'
684: from okc_k_headers_v
685: where id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
686: and template_yn = 'Y';
687: --
688: BEGIN
689: --

Line 803: l_id := wf_engine.GetItemAttrNumber(

799: if (funcmode = 'RUN') then
800: --
801: -- Initiator/Initial
802: --
803: l_id := wf_engine.GetItemAttrNumber(
804: itemtype => itemtype,
805: itemkey => itemkey,
806: aname => 'USER_ID');
807: open C_INITIATOR_DISPLAY_NAME(l_id);

Line 810: wf_engine.SetItemAttrText (

806: aname => 'USER_ID');
807: open C_INITIATOR_DISPLAY_NAME(l_id);
808: fetch C_INITIATOR_DISPLAY_NAME into L_INITIATOR_NAME,L_INITIATOR_DISPLAY_NAME;
809: close C_INITIATOR_DISPLAY_NAME;
810: wf_engine.SetItemAttrText (
811: itemtype => itemtype,
812: itemkey => itemkey,
813: aname => 'INITIATOR_NAME',
814: avalue => L_INITIATOR_NAME);

Line 815: wf_engine.SetItemAttrText (

811: itemtype => itemtype,
812: itemkey => itemkey,
813: aname => 'INITIATOR_NAME',
814: avalue => L_INITIATOR_NAME);
815: wf_engine.SetItemAttrText (
816: itemtype => itemtype,
817: itemkey => itemkey,
818: aname => 'INITIATOR_DISPLAY_NAME',
819: avalue => L_INITIATOR_DISPLAY_NAME);

Line 828: wf_engine.SetItemAttrText (

824: itemkey => itemkey,
825: p_role_type => 'ADMINISTRATOR',
826: x_role => L_CONTRACT_ADMIN_USERNAME,
827: x_name => V_DUMMY);
828: wf_engine.SetItemAttrText (
829: itemtype => itemtype,
830: itemkey => itemkey,
831: aname => 'CONTRACT_ADMIN_USERNAME',
832: avalue => L_CONTRACT_ADMIN_USERNAME);

Line 841: wf_engine.SetItemAttrText (

837: itemkey => itemkey,
838: p_role_type => 'SIGNATORY',
839: x_role => L_SIGNATORY_USERNAME,
840: x_name => L_SIGNATORY_DISPLAY_NAME);
841: wf_engine.SetItemAttrText (
842: itemtype => itemtype,
843: itemkey => itemkey,
844: aname => 'SIGNATORY_USERNAME',
845: avalue => L_SIGNATORY_USERNAME);

Line 847: wf_engine.SetItemAttrText (

843: itemkey => itemkey,
844: aname => 'SIGNATORY_USERNAME',
845: avalue => L_SIGNATORY_USERNAME);
846:
847: wf_engine.SetItemAttrText (
848: itemtype => itemtype,
849: itemkey => itemkey,
850: aname => 'SIGNATORY_DISPLAY_NAME',
851: avalue => L_SIGNATORY_DISPLAY_NAME);

Line 853: l_id := wf_engine.GetItemAttrNumber(

849: itemkey => itemkey,
850: aname => 'SIGNATORY_DISPLAY_NAME',
851: avalue => L_SIGNATORY_DISPLAY_NAME);
852: --
853: l_id := wf_engine.GetItemAttrNumber(
854: itemtype => itemtype,
855: itemkey => itemkey,
856: aname => 'CONTRACT_ID');
857: open C_K_SHORT_DESCRIPTION(l_id);

Line 860: wf_engine.SetItemAttrText (

856: aname => 'CONTRACT_ID');
857: open C_K_SHORT_DESCRIPTION(l_id);
858: fetch C_K_SHORT_DESCRIPTION into L_K_SHORT_DESCRIPTION;
859: close C_K_SHORT_DESCRIPTION;
860: wf_engine.SetItemAttrText (
861: itemtype => itemtype,
862: itemkey => itemkey,
863: aname => 'K_SHORT_DESCRIPTION',
864: avalue => L_K_SHORT_DESCRIPTION);

Line 929: L_NEXT_PERFORMER_USERNAME := wf_engine.GetItemAttrText(

925: --
926: -- RUN mode - normal process execution
927: --
928: if (funcmode = 'RUN') then
929: L_NEXT_PERFORMER_USERNAME := wf_engine.GetItemAttrText(
930: itemtype => itemtype,
931: itemkey => itemkey,
932: aname => 'NEXT_PERFORMER_USERNAME');
933: if (L_NEXT_PERFORMER_USERNAME is NULL)

Line 935: L_INITIATOR_DISPLAY_NAME := wf_engine.GetItemAttrText(

931: itemkey => itemkey,
932: aname => 'NEXT_PERFORMER_USERNAME');
933: if (L_NEXT_PERFORMER_USERNAME is NULL)
934: then -- just start
935: L_INITIATOR_DISPLAY_NAME := wf_engine.GetItemAttrText(
936: itemtype => itemtype,
937: itemkey => itemkey,
938: aname => 'INITIATOR_DISPLAY_NAME');
939: select_next(itemtype => itemtype,

Line 948: wf_engine.SetItemAttrText (

944: x_name => L_N_PERFORMER_DISPLAY_NAME);
945: -- just for common situation if no approvers at all
946: -- then Contract is considered as approved by initiator
947: if (L_NEXT_PERFORMER_USERNAME is NULL) then
948: wf_engine.SetItemAttrText (
949: itemtype => itemtype,
950: itemkey => itemkey,
951: aname => 'N_PERFORMER_DISPLAY_NAME',
952: avalue => L_INITIATOR_DISPLAY_NAME);

Line 953: wf_engine.SetItemAttrText (

949: itemtype => itemtype,
950: itemkey => itemkey,
951: aname => 'N_PERFORMER_DISPLAY_NAME',
952: avalue => L_INITIATOR_DISPLAY_NAME);
953: wf_engine.SetItemAttrText (
954: itemtype => itemtype,
955: itemkey => itemkey,
956: aname => 'FINAL_APPROVER_UNAME',
957: avalue => NULL);

Line 960: wf_engine.SetItemAttrText (

956: aname => 'FINAL_APPROVER_UNAME',
957: avalue => NULL);
958: resultout := 'COMPLETE:F';
959: else
960: wf_engine.SetItemAttrText (
961: itemtype => itemtype,
962: itemkey => itemkey,
963: aname => 'P_PERFORMER_DISPLAY_NAME',
964: avalue => L_INITIATOR_DISPLAY_NAME);

Line 965: wf_engine.SetItemAttrText (

961: itemtype => itemtype,
962: itemkey => itemkey,
963: aname => 'P_PERFORMER_DISPLAY_NAME',
964: avalue => L_INITIATOR_DISPLAY_NAME);
965: wf_engine.SetItemAttrText (
966: itemtype => itemtype,
967: itemkey => itemkey,
968: aname => 'NEXT_PERFORMER_USERNAME',
969: avalue => L_NEXT_PERFORMER_USERNAME);

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

966: itemtype => itemtype,
967: itemkey => itemkey,
968: aname => 'NEXT_PERFORMER_USERNAME',
969: avalue => L_NEXT_PERFORMER_USERNAME);
970: wf_engine.SetItemAttrText(itemtype => itemtype,
971: itemkey => itemkey,
972: aname => 'N_PERFORMER_DISPLAY_NAME',
973: avalue => L_N_PERFORMER_DISPLAY_NAME);
974: resultout := 'COMPLETE:T';

Line 978: wf_engine.SetItemAttrText

974: resultout := 'COMPLETE:T';
975: end if;
976: return;
977: else
978: wf_engine.SetItemAttrText
979: (
980: itemtype => itemtype,
981: itemkey => itemkey,
982: aname => 'P_PERFORMER_DISPLAY_NAME',

Line 983: avalue => wf_engine.GetItemAttrText(

979: (
980: itemtype => itemtype,
981: itemkey => itemkey,
982: aname => 'P_PERFORMER_DISPLAY_NAME',
983: avalue => wf_engine.GetItemAttrText(
984: itemtype => itemtype,
985: itemkey => itemkey,
986: aname => 'N_PERFORMER_DISPLAY_NAME')
987: );

Line 997: wf_engine.SetItemAttrText (

993: x_role => L_NEXT_PERFORMER_USERNAME_OUT,
994: x_name => L_N_PERFORMER_DISPLAY_NAME);
995:
996: if (L_NEXT_PERFORMER_USERNAME_OUT is NULL) then
997: wf_engine.SetItemAttrText (
998: itemtype => itemtype,
999: itemkey => itemkey,
1000: aname => 'FINAL_APPROVER_UNAME',
1001: avalue => wf_engine.GetItemAttrText(

Line 1001: avalue => wf_engine.GetItemAttrText(

997: wf_engine.SetItemAttrText (
998: itemtype => itemtype,
999: itemkey => itemkey,
1000: aname => 'FINAL_APPROVER_UNAME',
1001: avalue => wf_engine.GetItemAttrText(
1002: itemtype => itemtype,
1003: itemkey => itemkey,
1004: aname => 'NEXT_PERFORMER_USERNAME'));
1005:

Line 1006: wf_engine.SetItemAttrText (

1002: itemtype => itemtype,
1003: itemkey => itemkey,
1004: aname => 'NEXT_PERFORMER_USERNAME'));
1005:
1006: wf_engine.SetItemAttrText (
1007: itemtype => itemtype,
1008: itemkey => itemkey,
1009: aname => 'NEXT_PERFORMER_USERNAME',
1010: avalue => NULL);

Line 1015: wf_engine.SetItemAttrText (

1011: resultout := 'COMPLETE:F';
1012:
1013: else
1014:
1015: wf_engine.SetItemAttrText (
1016: itemtype => itemtype,
1017: itemkey => itemkey,
1018: aname => 'NEXT_PERFORMER_USERNAME',
1019: avalue => L_NEXT_PERFORMER_USERNAME_OUT);

Line 1021: wf_engine.SetItemAttrText(

1017: itemkey => itemkey,
1018: aname => 'NEXT_PERFORMER_USERNAME',
1019: avalue => L_NEXT_PERFORMER_USERNAME_OUT);
1020:
1021: wf_engine.SetItemAttrText(
1022: itemtype => itemtype,
1023: itemkey => itemkey,
1024: aname => 'N_PERFORMER_DISPLAY_NAME',
1025: avalue => L_N_PERFORMER_DISPLAY_NAME);

Line 1086: L_NEXT_INFORMED_USERNAME := wf_engine.GetItemAttrText(

1082: -- RUN mode - normal process execution
1083: --
1084: if (funcmode = 'RUN') then
1085:
1086: L_NEXT_INFORMED_USERNAME := wf_engine.GetItemAttrText(
1087: itemtype => itemtype,
1088: itemkey => itemkey,
1089: aname => 'NEXT_INFORMED_USERNAME');
1090:

Line 1098: wf_engine.SetItemAttrText (

1094: p_current => L_NEXT_INFORMED_USERNAME,
1095: x_role => L_NEXT_INFORMED_USERNAME_OUT,
1096: x_name => V_DUMMY);
1097:
1098: wf_engine.SetItemAttrText (
1099: itemtype => itemtype,
1100: itemkey => itemkey,
1101: aname => 'NEXT_INFORMED_USERNAME',
1102: avalue => L_NEXT_INFORMED_USERNAME_OUT);

Line 1181: l_contract_id := wf_engine.GetItemAttrNumber(

1177: funcmode,
1178: resultout);
1179: IF resultout = 'COMPLETE:F' THEN
1180:
1181: l_contract_id := wf_engine.GetItemAttrNumber(
1182: itemtype => itemtype,
1183: itemkey => itemkey,
1184: aname => 'CONTRACT_ID');
1185:

Line 1251: l_contract_id := wf_engine.GetItemAttrNumber(

1247: resultout);
1248:
1249: IF resultout = 'COMPLETE:F' THEN
1250:
1251: l_contract_id := wf_engine.GetItemAttrNumber(
1252: itemtype => itemtype,
1253: itemkey => itemkey,
1254: aname => 'CONTRACT_ID');
1255:

Line 1320: l_contract_id := wf_engine.GetItemAttrNumber(

1316: funcmode,
1317: resultout);
1318: IF resultout = 'COMPLETE:F' THEN
1319:
1320: l_contract_id := wf_engine.GetItemAttrNumber(
1321: itemtype => itemtype,
1322: itemkey => itemkey,
1323: aname => 'CONTRACT_ID');
1324:

Line 1388: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(

1384: if (funcmode = 'RUN') then
1385: --
1386: empty_mess( itemtype,
1387: itemkey );
1388: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
1389: itemtype => itemtype,
1390: itemkey => itemkey,
1391: aname => 'CONTRACT_ID');
1392: OKC_CONTRACT_APPROVAL_PUB.k_approved(

Line 1398: wf_engine.SetItemAttrDate (

1394: x_return_status => x_return_status);
1395: if (x_return_status = OKC_API.G_RET_STS_SUCCESS)
1396: then
1397: --
1398: wf_engine.SetItemAttrDate (
1399: itemtype => itemtype,
1400: itemkey => itemkey,
1401: aname => 'DATE_SIGNED',
1402: avalue => sysdate);

Line 1469: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(

1465: if (funcmode = 'RUN') then
1466: --
1467: empty_mess( itemtype,
1468: itemkey );
1469: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
1470: itemtype => itemtype,
1471: itemkey => itemkey,
1472: aname => 'CONTRACT_ID');
1473: OKC_CONTRACT_APPROVAL_PUB.k_erase_approved(

Line 1546: L_DATE_SIGNED := wf_engine.GetItemAttrDate (

1542: if (funcmode = 'RUN') then
1543: --
1544: empty_mess( itemtype,
1545: itemkey );
1546: L_DATE_SIGNED := wf_engine.GetItemAttrDate (
1547: itemtype => itemtype,
1548: itemkey => itemkey,
1549: aname => 'DATE_SIGNED');
1550: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(

Line 1550: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(

1546: L_DATE_SIGNED := wf_engine.GetItemAttrDate (
1547: itemtype => itemtype,
1548: itemkey => itemkey,
1549: aname => 'DATE_SIGNED');
1550: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
1551: itemtype => itemtype,
1552: itemkey => itemkey,
1553: aname => 'CONTRACT_ID');
1554: OKC_CONTRACT_APPROVAL_PUB.k_signed(

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

1618: --
1619: -- RUN mode - normal process execution
1620: --
1621: if (funcmode = 'RUN') then
1622: if (wf_engine.GetItemAttrText(itemtype,itemkey,'FINAL_APPROVER_UNAME') is NULL) then
1623: resultout := 'COMPLETE:F';
1624: else
1625: resultout := 'COMPLETE:T';
1626: end if;

Line 1691: l_contract_id := wf_engine.GetItemAttrNumber(

1687: --
1688: If (funcmode = 'RUN') then
1689: --
1690:
1691: l_contract_id := wf_engine.GetItemAttrNumber(
1692: itemtype => itemtype,
1693: itemkey => itemkey,
1694: aname => 'CONTRACT_ID');
1695: empty_mess( itemtype,

Line 1759: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(

1755: if (funcmode = 'RUN') then
1756: --
1757: empty_mess( itemtype,
1758: itemkey );
1759: L_CONTRACT_ID := wf_engine.GetItemAttrNumber(
1760: itemtype => itemtype,
1761: itemkey => itemkey,
1762: aname => 'CONTRACT_ID');
1763: OKC_CONTRACT_APPROVAL_PUB.activate_template(

Line 1847: wf_engine.SetItemAttrNumber (

1843: OPEN csr_session_id;
1844: FETCH csr_session_id INTO l_session_id;
1845: CLOSE csr_session_id;
1846:
1847: wf_engine.SetItemAttrNumber (
1848: itemtype => itemtype,
1849: itemkey=> itemkey,
1850: aname => 'QUOTE_SESSION_ID',
1851: avalue=> l_session_id);

Line 1853: l_contract_id := wf_engine.GetItemAttrNumber(

1849: itemkey=> itemkey,
1850: aname => 'QUOTE_SESSION_ID',
1851: avalue=> l_session_id);
1852: --
1853: l_contract_id := wf_engine.GetItemAttrNumber(
1854: itemtype => itemtype,
1855: itemkey => itemkey,
1856: aname => 'CONTRACT_ID');
1857:

Line 1959: l_contract_id := wf_engine.GetItemAttrNumber(

1955: --
1956: IF (funcmode = 'RUN') THEN
1957: empty_mess( itemtype, itemkey );
1958:
1959: l_contract_id := wf_engine.GetItemAttrNumber(
1960: itemtype => itemtype,
1961: itemkey => itemkey,
1962: aname => 'CONTRACT_ID');
1963:

Line 2065: l_contract_id := wf_engine.GetItemAttrNumber(

2061: --
2062: IF (funcmode = 'RUN') THEN
2063: empty_mess( itemtype, itemkey );
2064:
2065: l_contract_id := wf_engine.GetItemAttrNumber(
2066: itemtype => itemtype,
2067: itemkey => itemkey,
2068: aname => 'CONTRACT_ID');
2069: