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

Line 922: l_user_id := wf_engine.GetItemAttrText (itemtype => itemtype,

918:
919: -- "RUN"
920: IF (funcmode = 'RUN') THEN
921: --l_user_id := fnd_profile.value('OKL_LEASE_CONTRACT_APPROVER');
922: l_user_id := wf_engine.GetItemAttrText (itemtype => itemtype,
923: itemkey => itemkey,
924: aname => G_WF_ITM_REQUESTER_ID);
925:
926: l_contract_number := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 926: l_contract_number := wf_engine.GetItemAttrText (itemtype => itemtype,

922: l_user_id := wf_engine.GetItemAttrText (itemtype => itemtype,
923: itemkey => itemkey,
924: aname => G_WF_ITM_REQUESTER_ID);
925:
926: l_contract_number := wf_engine.GetItemAttrText (itemtype => itemtype,
927: itemkey => itemkey,
928: aname => G_WF_ITM_CONTRACT_NUMBER);
929:
930: resultout := 'COMPLETE:NOT_FOUND'; -- default

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

930: resultout := 'COMPLETE:NOT_FOUND'; -- default
931: IF l_user_id IS NOT NULL THEN
932: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)
933: LOOP
934: wf_engine.SetItemAttrText (itemtype => itemtype,
935: itemkey => itemkey,
936: aname => G_WF_ITM_APPROVER,
937: avalue => l_fnd_users_rec.user_name);
938:

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

936: aname => G_WF_ITM_APPROVER,
937: avalue => l_fnd_users_rec.user_name);
938:
939:
940: wf_engine.SetItemAttrText (itemtype => itemtype,
941: itemkey => itemkey,
942: aname => G_WF_ITM_MESSAGE_SUBJECT,
943: avalue => get_message('OKL_CRTLINE_APPROVAL_SUMMARY',l_contract_number));
944:

Line 1002: l_result := wf_engine.GetItemAttrText (itemtype => itemtype,

998: BEGIN
999: SAVEPOINT set_atts;
1000: IF (funcmode = 'RUN') THEN
1001: -- Get current approval status
1002: l_result := wf_engine.GetItemAttrText (itemtype => itemtype,
1003: itemkey => itemkey,
1004: aname => G_WF_ITM_RESULT);
1005:
1006: l_parent_key := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1006: l_parent_key := wf_engine.GetItemAttrText (itemtype => itemtype,

1002: l_result := wf_engine.GetItemAttrText (itemtype => itemtype,
1003: itemkey => itemkey,
1004: aname => G_WF_ITM_RESULT);
1005:
1006: l_parent_key := wf_engine.GetItemAttrText (itemtype => itemtype,
1007: itemkey => itemkey,
1008: aname => G_WF_ITM_PARENT_ITEM_KEY);
1009:
1010: l_parent_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1010: l_parent_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1006: l_parent_key := wf_engine.GetItemAttrText (itemtype => itemtype,
1007: itemkey => itemkey,
1008: aname => G_WF_ITM_PARENT_ITEM_KEY);
1009:
1010: l_parent_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1011: itemkey => itemkey,
1012: aname => G_WF_ITM_PARENT_ITEM_TYPE);
1013:
1014: l_contract_number := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1014: l_contract_number := wf_engine.GetItemAttrText (itemtype => itemtype,

1010: l_parent_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1011: itemkey => itemkey,
1012: aname => G_WF_ITM_PARENT_ITEM_TYPE);
1013:
1014: l_contract_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1015: itemkey => itemkey,
1016: aname => G_WF_ITM_CONTRACT_NUMBER);
1017:
1018: IF l_result = G_WF_ITM_RESULT_APPROVED THEN

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

1016: aname => G_WF_ITM_CONTRACT_NUMBER);
1017:
1018: IF l_result = G_WF_ITM_RESULT_APPROVED THEN
1019: l_approved_yn := G_WF_ITM_APPROVED_YN_YES;
1020: wf_engine.SetItemAttrText (itemtype => itemtype,
1021: itemkey => itemkey,
1022: aname => G_WF_ITM_MESSAGE_SUBJECT,
1023: avalue => get_message('OKL_LLA_REQUEST_APPROVED_SUB',l_contract_number));
1024: ELSE

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

1022: aname => G_WF_ITM_MESSAGE_SUBJECT,
1023: avalue => get_message('OKL_LLA_REQUEST_APPROVED_SUB',l_contract_number));
1024: ELSE
1025: l_approved_yn := G_WF_ITM_APPROVED_YN_NO;
1026: wf_engine.SetItemAttrText (itemtype => itemtype,
1027: itemkey => itemkey,
1028: aname => G_WF_ITM_MESSAGE_SUBJECT,
1029: avalue => get_message('OKL_LLA_REQUEST_REJECTED_SUB',l_contract_number));
1030: END IF;

Line 1032: wf_engine.SetItemAttrText(itemtype => l_parent_type,

1028: aname => G_WF_ITM_MESSAGE_SUBJECT,
1029: avalue => get_message('OKL_LLA_REQUEST_REJECTED_SUB',l_contract_number));
1030: END IF;
1031:
1032: wf_engine.SetItemAttrText(itemtype => l_parent_type,
1033: itemkey => l_parent_key,
1034: aname => G_WF_ITM_APPROVED_YN,
1035: avalue => l_approved_yn);
1036: resultout := 'COMPLETE:';

Line 1110: l_chrv_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1106: l_api_version := 1.0;
1107: l_init_msg_list := OKL_API.G_FALSE;
1108:
1109: -- We getting the contract_Id from WF
1110: l_chrv_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1111: itemkey => itemkey,
1112: aname => G_WF_ITM_CONTRACT_ID);
1113: --Run Mode
1114: IF funcmode = 'RUN' THEN

Line 1115: l_approved_yn := wf_engine.GetItemAttrText (itemtype => itemtype,

1111: itemkey => itemkey,
1112: aname => G_WF_ITM_CONTRACT_ID);
1113: --Run Mode
1114: IF funcmode = 'RUN' THEN
1115: l_approved_yn := wf_engine.GetItemAttrText (itemtype => itemtype,
1116: itemkey => itemkey,
1117: aname => G_WF_ITM_APPROVED_YN);
1118: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1119: itemkey => itemkey,

Line 1118: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,

1114: IF funcmode = 'RUN' THEN
1115: l_approved_yn := wf_engine.GetItemAttrText (itemtype => itemtype,
1116: itemkey => itemkey,
1117: aname => G_WF_ITM_APPROVED_YN);
1118: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1119: itemkey => itemkey,
1120: aname => 'APPROVED_YN');
1121:
1122: IF (l_approved_yn = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = G_WF_ITM_APPROVED_YN_YES)THEN

Line 1155: l_trx_number := wf_engine.GetItemAttrText (itemtype => itemtype,

1151: END IF;
1152: END IF;
1153:
1154: -- trx's trx_number IS wf's trx_id
1155: l_trx_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1156: itemkey => itemkey,
1157: aname => G_WF_ITM_TRANSACTION_ID);
1158:
1159: FOR l_okl_trx_contracts_rec IN l_okl_trx_contracts_csr(l_trx_number)

Line 1186: resultout := wf_engine.eng_null;

1182: RETURN;
1183: END IF;
1184: --Transfer Mode
1185: IF funcmode = 'TRANSFER' THEN
1186: resultout := wf_engine.eng_null;
1187: RETURN;
1188: END IF;
1189: -- CANCEL mode
1190: IF (funcmode = 'CANCEL') THEN

Line 1249: l_contract_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,

1245: l_message VARCHAR2(32000);
1246: l_contract_id NUMBER;
1247: BEGIN
1248:
1249: l_contract_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,
1250: itemkey => document_id,
1251: aname => G_WF_ITM_CONTRACT_ID);
1252: document := compile_message(l_contract_id);
1253: document_type := display_type;

Line 1292: l_contract_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1288: IF (funcmode = 'RUN') THEN
1289: l_approval_option := fnd_profile.value('OKL_CREDIT_LINE_APPROVAL_PROCESS');
1290: IF l_approval_option = G_LEASE_CONTRACT_APPROVAL_AME THEN
1291:
1292: l_contract_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => G_WF_ITM_CONTRACT_ID);
1295:
1296: l_contract_number := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1296: l_contract_number := wf_engine.GetItemAttrText(itemtype => itemtype,

1292: l_contract_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => G_WF_ITM_CONTRACT_ID);
1295:
1296: l_contract_number := wf_engine.GetItemAttrText(itemtype => itemtype,
1297: itemkey => itemkey,
1298: aname => G_WF_ITM_CONTRACT_NUMBER);
1299:
1300: wf_engine.SetItemAttrText (itemtype => itemtype,

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

1296: l_contract_number := wf_engine.GetItemAttrText(itemtype => itemtype,
1297: itemkey => itemkey,
1298: aname => G_WF_ITM_CONTRACT_NUMBER);
1299:
1300: wf_engine.SetItemAttrText (itemtype => itemtype,
1301: itemkey => itemkey,
1302: aname => G_WF_ITM_MESSAGE_DESCRIPTION,
1303: avalue => compile_message(l_contract_id));
1304:

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

1301: itemkey => itemkey,
1302: aname => G_WF_ITM_MESSAGE_DESCRIPTION,
1303: avalue => compile_message(l_contract_id));
1304:
1305: wf_engine.SetItemAttrText (itemtype => itemtype,
1306: itemkey => itemkey,
1307: aname => G_WF_ITM_APP_REQUEST_SUB,
1308: avalue => get_message('OKL_LLA_REQUEST_APPROVAL_SUB',l_contract_number));
1309:

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

1306: itemkey => itemkey,
1307: aname => G_WF_ITM_APP_REQUEST_SUB,
1308: avalue => get_message('OKL_LLA_REQUEST_APPROVAL_SUB',l_contract_number));
1309:
1310: wf_engine.SetItemAttrText (itemtype => itemtype,
1311: itemkey => itemkey,
1312: aname => G_WF_ITM_APP_REMINDER_SUB,
1313: avalue => get_message('OKL_LLA_REQ_APPR_SUB_REMINDER',l_contract_number));
1314:

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

1311: itemkey => itemkey,
1312: aname => G_WF_ITM_APP_REMINDER_SUB,
1313: avalue => get_message('OKL_LLA_REQ_APPR_SUB_REMINDER',l_contract_number));
1314:
1315: wf_engine.SetItemAttrText (itemtype => itemtype,
1316: itemkey => itemkey,
1317: aname => G_WF_ITM_APP_APPROVED_SUB,
1318: avalue => get_message('OKL_LLA_REQUEST_APPROVED_SUB',l_contract_number));
1319:

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

1316: itemkey => itemkey,
1317: aname => G_WF_ITM_APP_APPROVED_SUB,
1318: avalue => get_message('OKL_LLA_REQUEST_APPROVED_SUB',l_contract_number));
1319:
1320: wf_engine.SetItemAttrText (itemtype => itemtype,
1321: itemkey => itemkey,
1322: aname => G_WF_ITM_APP_REJECTED_SUB,
1323: avalue => get_message('OKL_LLA_REQUEST_REJECTED_SUB',l_contract_number));
1324:

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

1321: itemkey => itemkey,
1322: aname => G_WF_ITM_APP_REJECTED_SUB,
1323: avalue => get_message('OKL_LLA_REQUEST_REJECTED_SUB',l_contract_number));
1324:
1325: wf_engine.SetItemAttrText (itemtype => itemtype,
1326: itemkey => itemkey,
1327: aname => G_WF_ITM_APP_REMINDER_HEAD,
1328: avalue => get_message('OKL_LLA_REQ_APPROVAL_REMINDER',l_contract_number));
1329:

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

1326: itemkey => itemkey,
1327: aname => G_WF_ITM_APP_REMINDER_HEAD,
1328: avalue => get_message('OKL_LLA_REQ_APPROVAL_REMINDER',l_contract_number));
1329:
1330: wf_engine.SetItemAttrText (itemtype => itemtype,
1331: itemkey => itemkey,
1332: aname => G_WF_ITM_APP_APPROVED_HEAD,
1333: avalue => get_message('OKL_LLA_REQUEST_APPROVED_SUB',l_contract_number));
1334:

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

1331: itemkey => itemkey,
1332: aname => G_WF_ITM_APP_APPROVED_HEAD,
1333: avalue => get_message('OKL_LLA_REQUEST_APPROVED_SUB',l_contract_number));
1334:
1335: wf_engine.SetItemAttrText (itemtype => itemtype,
1336: itemkey => itemkey,
1337: aname => G_WF_ITM_APP_REJECTED_HEAD,
1338: avalue => get_message('OKL_LLA_REQUEST_REJECTED_SUB',l_contract_number));
1339:

Line 1418: wf_engine.CreateProcess(itemtype => l_item_type,

1414: CLOSE l_wf_item_key_csr;
1415:
1416: IF (funcmode = 'RUN') THEN
1417:
1418: wf_engine.CreateProcess(itemtype => l_item_type,
1419: itemkey => l_key,
1420: process => l_process);
1421:
1422: wf_engine.SetItemParent(itemtype => l_item_type,

Line 1422: wf_engine.SetItemParent(itemtype => l_item_type,

1418: wf_engine.CreateProcess(itemtype => l_item_type,
1419: itemkey => l_key,
1420: process => l_process);
1421:
1422: wf_engine.SetItemParent(itemtype => l_item_type,
1423: itemkey => l_key,
1424: parent_itemtype => itemtype,
1425: parent_itemkey => itemkey,
1426: parent_context => G_WF_ITM_MASTER);

Line 1428: wf_engine.SetItemAttrText (itemtype => l_item_type,

1424: parent_itemtype => itemtype,
1425: parent_itemkey => itemkey,
1426: parent_context => G_WF_ITM_MASTER);
1427:
1428: wf_engine.SetItemAttrText (itemtype => l_item_type,
1429: itemkey => l_key,
1430: aname => G_WF_ITM_PARENT_ITEM_KEY,
1431: avalue => itemkey);
1432:

Line 1433: wf_engine.SetItemAttrText (itemtype => l_item_type,

1429: itemkey => l_key,
1430: aname => G_WF_ITM_PARENT_ITEM_KEY,
1431: avalue => itemkey);
1432:
1433: wf_engine.SetItemAttrText (itemtype => l_item_type,
1434: itemkey => l_key,
1435: aname => G_WF_ITM_PARENT_ITEM_TYPE,
1436: avalue => itemtype);
1437:

Line 1440: l_contract_id := wf_engine.GetItemAttrText (itemtype => itemtype,

1436: avalue => itemtype);
1437:
1438: -- Re populate Item Attributes for the Detail Process
1439:
1440: l_contract_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1441: itemkey => itemkey,
1442: aname => G_WF_ITM_CONTRACT_ID);
1443:
1444: l_contract_number := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1444: l_contract_number := wf_engine.GetItemAttrText (itemtype => itemtype,

1440: l_contract_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1441: itemkey => itemkey,
1442: aname => G_WF_ITM_CONTRACT_ID);
1443:
1444: l_contract_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1445: itemkey => itemkey,
1446: aname => G_WF_ITM_CONTRACT_NUMBER);
1447:
1448: l_requester := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1448: l_requester := wf_engine.GetItemAttrText (itemtype => itemtype,

1444: l_contract_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1445: itemkey => itemkey,
1446: aname => G_WF_ITM_CONTRACT_NUMBER);
1447:
1448: l_requester := wf_engine.GetItemAttrText (itemtype => itemtype,
1449: itemkey => itemkey,
1450: aname => G_WF_ITM_REQUESTER);
1451:
1452: l_requester_id := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1452: l_requester_id := wf_engine.GetItemAttrText (itemtype => itemtype,

1448: l_requester := wf_engine.GetItemAttrText (itemtype => itemtype,
1449: itemkey => itemkey,
1450: aname => G_WF_ITM_REQUESTER);
1451:
1452: l_requester_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1453: itemkey => itemkey,
1454: aname => G_WF_ITM_REQUESTER_ID);
1455:
1456: wf_engine.SetItemAttrText (itemtype => l_item_type,

Line 1456: wf_engine.SetItemAttrText (itemtype => l_item_type,

1452: l_requester_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1453: itemkey => itemkey,
1454: aname => G_WF_ITM_REQUESTER_ID);
1455:
1456: wf_engine.SetItemAttrText (itemtype => l_item_type,
1457: itemkey => l_key,
1458: aname => G_WF_ITM_CONTRACT_ID,
1459: avalue => l_contract_id);
1460:

Line 1461: wf_engine.SetItemAttrText (itemtype => l_item_type,

1457: itemkey => l_key,
1458: aname => G_WF_ITM_CONTRACT_ID,
1459: avalue => l_contract_id);
1460:
1461: wf_engine.SetItemAttrText (itemtype => l_item_type,
1462: itemkey => l_key,
1463: aname => G_WF_ITM_CONTRACT_NUMBER,
1464: avalue => l_contract_number);
1465:

Line 1466: wf_engine.SetItemAttrText (itemtype => l_item_type,

1462: itemkey => l_key,
1463: aname => G_WF_ITM_CONTRACT_NUMBER,
1464: avalue => l_contract_number);
1465:
1466: wf_engine.SetItemAttrText (itemtype => l_item_type,
1467: itemkey => l_key,
1468: aname => G_WF_ITM_REQUESTER,
1469: avalue => l_requester);
1470:

Line 1471: wf_engine.SetItemAttrText (itemtype => l_item_type,

1467: itemkey => l_key,
1468: aname => G_WF_ITM_REQUESTER,
1469: avalue => l_requester);
1470:
1471: wf_engine.SetItemAttrText (itemtype => l_item_type,
1472: itemkey => l_key,
1473: aname => G_WF_ITM_REQUESTER_ID,
1474: avalue => l_requester_id);
1475: -- Set the Message Document

Line 1476: wf_engine.SetItemAttrDocument (itemtype => l_item_type,

1472: itemkey => l_key,
1473: aname => G_WF_ITM_REQUESTER_ID,
1474: avalue => l_requester_id);
1475: -- Set the Message Document
1476: wf_engine.SetItemAttrDocument (itemtype => l_item_type,
1477: itemkey => l_key,
1478: aname => G_WF_ITM_MESSAGE_DOC,
1479: documentid => 'plsql:OKL_CREDIT_LINE_WF.pop_approval_doc/'||l_key);
1480:

Line 1482: wf_engine.StartProcess(itemtype => l_item_type,

1478: aname => G_WF_ITM_MESSAGE_DOC,
1479: documentid => 'plsql:OKL_CREDIT_LINE_WF.pop_approval_doc/'||l_key);
1480:
1481: -- Now, Start the Detail Process
1482: wf_engine.StartProcess(itemtype => l_item_type,
1483: itemkey => l_key);
1484:
1485: resultout := 'COMPLETE:';
1486: RETURN;

Line 1542: wf_engine.SetItemAttrDocument (itemtype => itemtype,

1538:
1539: BEGIN
1540:
1541: IF (funcmode = 'RUN') THEN
1542: wf_engine.SetItemAttrDocument (itemtype => itemtype,
1543: itemkey => itemkey,
1544: aname => G_WF_ITM_MESSAGE_DOC,
1545: documentid => 'plsql:OKL_CREDIT_LINE_WF.pop_approval_doc/'||itemkey);
1546: