1301: BEGIN
1302:
1303: -- Create Internal Transaction
1304:
1305: l_pdt_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1306: itemkey => itemkey,
1307: aname => G_WF_ITM_PRODUCT_ID);
1308:
1309:
1336: IF l_application_id = l_trans_appl_id THEN
1337:
1338: l_message := '
The Product will be completed following your approval.
';
1343: avalue => l_message);
1344:
1345:
1346:
1347: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1348: itemkey => itemkey,
1349: aname => G_WF_ITM_PRODUCT_ID,
1350: avalue => l_pdt_id);
1351:
1349: aname => G_WF_ITM_PRODUCT_ID,
1350: avalue => l_pdt_id);
1351:
1352:
1353: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1354: itemkey => itemkey,
1355: aname => G_WF_ITM_APPLICATION_ID,
1356: avalue => l_application_id);
1357:
1354: itemkey => itemkey,
1355: aname => G_WF_ITM_APPLICATION_ID,
1356: avalue => l_application_id);
1357:
1358: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1359: itemkey => itemkey,
1360: aname => G_WF_ITM_TRANSACTION_TYPE_ID,
1361: avalue => 'OKLLPPAP');
1362:
1359: itemkey => itemkey,
1360: aname => G_WF_ITM_TRANSACTION_TYPE_ID,
1361: avalue => 'OKLLPPAP');
1362:
1363: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1364: itemkey => itemkey,
1365: aname => G_WF_ITM_REQUESTER,
1366: avalue => l_requester);
1367:
1365: aname => G_WF_ITM_REQUESTER,
1366: avalue => l_requester);
1367:
1368:
1369: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1370: itemkey => itemkey,
1371: aname => G_WF_ITM_REQUESTER_ID,
1372: avalue => l_requester_id);
1373:
1544: l_approved_yn VARCHAR2(30);
1545:
1546: BEGIN
1547: -- We getting the contract_Id from WF
1548: l_pdt_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1549: itemkey => itemkey,
1550: aname => 'TRANSACTION_ID');
1551:
1552:
1551:
1552:
1553: --Run Mode
1554: IF funcmode = 'RUN' THEN
1555: l_approved_yn := wf_engine.GetItemAttrText (itemtype => itemtype,
1556: itemkey => itemkey,
1557: aname => G_WF_ITM_APPROVED_YN);
1558:
1559: IF l_approved_yn = G_WF_ITM_APPROVED_YN_YES THEN
1600: END IF;
1601:
1602: --Transfer Mode
1603: IF funcmode = 'TRANSFER' THEN
1604: resultout := wf_engine.eng_null;
1605: RETURN;
1606: END IF;
1607: -- CANCEL mode
1608: IF (funcmode = 'CANCEL') THEN