DBA Data[Home] [Help]

APPS.OKL_SEC_AGREEMENT_WF dependencies on WF_ENGINE

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

823: l_return_status := OKL_API.G_RET_STS_SUCCESS;
824:
825: -- "RUN"
826: IF (funcmode = 'RUN') THEN
827: l_user_id := wf_engine.GetItemAttrText (itemtype => itemtype,
828: itemkey => itemkey,
829: aname => G_WF_ITM_REQUESTER_ID);
830:
831: l_ia_number := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 831: l_ia_number := wf_engine.GetItemAttrText (itemtype => itemtype,

827: l_user_id := wf_engine.GetItemAttrText (itemtype => itemtype,
828: itemkey => itemkey,
829: aname => G_WF_ITM_REQUESTER_ID);
830:
831: l_ia_number := wf_engine.GetItemAttrText (itemtype => itemtype,
832: itemkey => itemkey,
833: aname => G_WF_ITM_INV_AGRMNT_NUMBER);
834:
835: resultout := 'COMPLETE:NOT_FOUND'; -- default

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

835: resultout := 'COMPLETE:NOT_FOUND'; -- default
836: IF l_user_id IS NOT NULL THEN
837: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id)
838: LOOP
839: wf_engine.SetItemAttrText (itemtype => itemtype,
840: itemkey => itemkey,
841: aname => G_WF_ITM_APPROVER,
842: avalue => l_fnd_users_rec.user_name);
843:

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

841: aname => G_WF_ITM_APPROVER,
842: avalue => l_fnd_users_rec.user_name);
843:
844:
845: wf_engine.SetItemAttrText (itemtype => itemtype,
846: itemkey => itemkey,
847: aname => G_WF_ITM_MESSAGE_SUBJECT,
848: avalue => get_message('OKL_IA_ADD_KHR_APPROVAL_SUB',l_ia_number));
849:

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

846: itemkey => itemkey,
847: aname => G_WF_ITM_MESSAGE_SUBJECT,
848: avalue => get_message('OKL_IA_ADD_KHR_APPROVAL_SUB',l_ia_number));
849:
850: wf_engine.SetItemAttrDocument (itemtype => itemtype,
851: itemkey => itemkey,
852: aname => G_WF_ITM_MESSAGE_DOC,
853: documentid => 'plsql:OKL_SEC_AGREEMENT_WF.pop_approval_doc/'||itemkey);
854:

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

908: BEGIN
909: SAVEPOINT set_atts;
910: IF (funcmode = 'RUN') THEN
911: -- Get current approval status
912: l_result := wf_engine.GetItemAttrText (itemtype => itemtype,
913: itemkey => itemkey,
914: aname => G_WF_ITM_RESULT);
915:
916: l_parent_key := wf_engine.GetItemAttrText (itemtype => itemtype,

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

912: l_result := wf_engine.GetItemAttrText (itemtype => itemtype,
913: itemkey => itemkey,
914: aname => G_WF_ITM_RESULT);
915:
916: l_parent_key := wf_engine.GetItemAttrText (itemtype => itemtype,
917: itemkey => itemkey,
918: aname => G_WF_ITM_PARENT_ITEM_KEY);
919:
920: l_parent_type := wf_engine.GetItemAttrText (itemtype => itemtype,

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

916: l_parent_key := wf_engine.GetItemAttrText (itemtype => itemtype,
917: itemkey => itemkey,
918: aname => G_WF_ITM_PARENT_ITEM_KEY);
919:
920: l_parent_type := wf_engine.GetItemAttrText (itemtype => itemtype,
921: itemkey => itemkey,
922: aname => G_WF_ITM_PARENT_ITEM_TYPE);
923:
924: l_ia_number := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 924: l_ia_number := wf_engine.GetItemAttrText (itemtype => itemtype,

920: l_parent_type := wf_engine.GetItemAttrText (itemtype => itemtype,
921: itemkey => itemkey,
922: aname => G_WF_ITM_PARENT_ITEM_TYPE);
923:
924: l_ia_number := wf_engine.GetItemAttrText (itemtype => itemtype,
925: itemkey => itemkey,
926: aname => G_WF_ITM_INV_AGRMNT_NUMBER);
927:
928: IF l_result = G_WF_ITM_RESULT_APPROVED THEN

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

926: aname => G_WF_ITM_INV_AGRMNT_NUMBER);
927:
928: IF l_result = G_WF_ITM_RESULT_APPROVED THEN
929: l_approved_yn := G_WF_ITM_APPROVED_YN_YES;
930: wf_engine.SetItemAttrText (itemtype => itemtype,
931: itemkey => itemkey,
932: aname => G_WF_ITM_MESSAGE_SUBJECT,
933: avalue => get_message('OKL_IA_ADD_KHR_APPROVED_SUB',l_ia_number));
934: ELSE

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

932: aname => G_WF_ITM_MESSAGE_SUBJECT,
933: avalue => get_message('OKL_IA_ADD_KHR_APPROVED_SUB',l_ia_number));
934: ELSE
935: l_approved_yn := G_WF_ITM_APPROVED_YN_NO;
936: wf_engine.SetItemAttrText (itemtype => itemtype,
937: itemkey => itemkey,
938: aname => G_WF_ITM_MESSAGE_SUBJECT,
939: avalue => get_message('OKL_IA_ADD_KHR_REJECTED_SUB',l_ia_number));
940: END IF;

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

938: aname => G_WF_ITM_MESSAGE_SUBJECT,
939: avalue => get_message('OKL_IA_ADD_KHR_REJECTED_SUB',l_ia_number));
940: END IF;
941:
942: wf_engine.SetItemAttrText(itemtype => l_parent_type,
943: itemkey => l_parent_key,
944: aname => G_WF_ITM_APPROVED_YN,
945: avalue => l_approved_yn);
946: resultout := 'COMPLETE:';

Line 1020: l_pool_trans_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1016: l_api_version := 1.0;
1017: l_init_msg_list := OKL_API.G_FALSE;
1018:
1019: -- We getting the pool_trans_Id from WF
1020: l_pool_trans_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1021: itemkey => itemkey,
1022: aname => G_WF_ITM_POOL_TRANSACTION_ID);
1023: -- We getting the pool_Id from WF
1024: l_pool_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1024: l_pool_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1020: l_pool_trans_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1021: itemkey => itemkey,
1022: aname => G_WF_ITM_POOL_TRANSACTION_ID);
1023: -- We getting the pool_Id from WF
1024: l_pool_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1025: itemkey => itemkey,
1026: aname => G_WF_ITM_POOL_ID);
1027: --Run Mode
1028: IF funcmode = 'RUN' THEN

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

1025: itemkey => itemkey,
1026: aname => G_WF_ITM_POOL_ID);
1027: --Run Mode
1028: IF funcmode = 'RUN' THEN
1029: l_approved_yn := wf_engine.GetItemAttrText (itemtype => itemtype,
1030: itemkey => itemkey,
1031: aname => G_WF_ITM_APPROVED_YN);
1032: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1033: itemkey => itemkey,

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

1028: IF funcmode = 'RUN' THEN
1029: l_approved_yn := wf_engine.GetItemAttrText (itemtype => itemtype,
1030: itemkey => itemkey,
1031: aname => G_WF_ITM_APPROVED_YN);
1032: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1033: itemkey => itemkey,
1034: aname => 'APPROVED_YN');
1035:
1036: IF (l_approved_yn = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = G_WF_ITM_APPROVED_YN_YES)THEN

Line 1075: resultout := wf_engine.eng_null;

1071: RETURN;
1072: END IF;
1073: --Transfer Mode
1074: IF funcmode = 'TRANSFER' THEN
1075: resultout := wf_engine.eng_null;
1076: RETURN;
1077: END IF;
1078: -- CANCEL mode
1079: IF (funcmode = 'CANCEL') THEN

Line 1139: l_inv_agrmnt_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,

1135: l_inv_agrmnt_id NUMBER;
1136: l_pool_id NUMBER;
1137: l_pool_trans_id okl_pool_transactions.ID%TYPE;
1138: BEGIN
1139: l_inv_agrmnt_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,
1140: itemkey => document_id,
1141: aname => G_WF_ITM_INVESTOR_AGRMNT_ID);
1142:
1143: l_pool_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,

Line 1143: l_pool_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,

1139: l_inv_agrmnt_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,
1140: itemkey => document_id,
1141: aname => G_WF_ITM_INVESTOR_AGRMNT_ID);
1142:
1143: l_pool_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,
1144: itemkey => document_id,
1145: aname => G_WF_ITM_POOL_ID);
1146:
1147: l_pool_trans_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,

Line 1147: l_pool_trans_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,

1143: l_pool_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,
1144: itemkey => document_id,
1145: aname => G_WF_ITM_POOL_ID);
1146:
1147: l_pool_trans_id := wf_engine.GetItemAttrText (itemtype => G_ITEM_TYPE_WF,
1148: itemkey => document_id,
1149: aname => G_WF_ITM_POOL_TRANSACTION_ID);
1150:
1151:

Line 1194: l_inv_agrmnt_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1190: IF (funcmode = 'RUN') THEN
1191: l_approval_option := fnd_profile.value(G_IA_ADD_KHR_APPROVAL_PROCESS);
1192: IF l_approval_option = G_IA_ADD_KHR_APPROVAL_AME THEN
1193:
1194: l_inv_agrmnt_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1195: itemkey => itemkey,
1196: aname => G_WF_ITM_INVESTOR_AGRMNT_ID);
1197:
1198: l_inv_agrmnt_number := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1198: l_inv_agrmnt_number := wf_engine.GetItemAttrText(itemtype => itemtype,

1194: l_inv_agrmnt_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1195: itemkey => itemkey,
1196: aname => G_WF_ITM_INVESTOR_AGRMNT_ID);
1197:
1198: l_inv_agrmnt_number := wf_engine.GetItemAttrText(itemtype => itemtype,
1199: itemkey => itemkey,
1200: aname => G_WF_ITM_INV_AGRMNT_NUMBER);
1201: l_pool_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1202: itemkey => itemkey,

Line 1201: l_pool_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1197:
1198: l_inv_agrmnt_number := wf_engine.GetItemAttrText(itemtype => itemtype,
1199: itemkey => itemkey,
1200: aname => G_WF_ITM_INV_AGRMNT_NUMBER);
1201: l_pool_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1202: itemkey => itemkey,
1203: aname => G_WF_ITM_POOL_ID);
1204: l_pool_number := wf_engine.GetItemAttrText(itemtype => itemtype,
1205: itemkey => itemkey,

Line 1204: l_pool_number := wf_engine.GetItemAttrText(itemtype => itemtype,

1200: aname => G_WF_ITM_INV_AGRMNT_NUMBER);
1201: l_pool_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1202: itemkey => itemkey,
1203: aname => G_WF_ITM_POOL_ID);
1204: l_pool_number := wf_engine.GetItemAttrText(itemtype => itemtype,
1205: itemkey => itemkey,
1206: aname => G_WF_ITM_POOL_NUMBER);
1207:
1208: l_pool_trans_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1208: l_pool_trans_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1204: l_pool_number := wf_engine.GetItemAttrText(itemtype => itemtype,
1205: itemkey => itemkey,
1206: aname => G_WF_ITM_POOL_NUMBER);
1207:
1208: l_pool_trans_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1209: itemkey => itemkey,
1210: aname => G_WF_ITM_POOL_TRANSACTION_ID);
1211:
1212:

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

1209: itemkey => itemkey,
1210: aname => G_WF_ITM_POOL_TRANSACTION_ID);
1211:
1212:
1213: wf_engine.SetItemAttrText (itemtype => itemtype,
1214: itemkey => itemkey,
1215: aname => G_WF_ITM_MESSAGE_DESCRIPTION,
1216: avalue => compile_msg_for_add_req(l_inv_agrmnt_id, l_pool_id,l_pool_trans_id));
1217:

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

1214: itemkey => itemkey,
1215: aname => G_WF_ITM_MESSAGE_DESCRIPTION,
1216: avalue => compile_msg_for_add_req(l_inv_agrmnt_id, l_pool_id,l_pool_trans_id));
1217:
1218: wf_engine.SetItemAttrText (itemtype => itemtype,
1219: itemkey => itemkey,
1220: aname => G_WF_ITM_APP_REQUEST_SUB,
1221: avalue => get_message('OKL_IA_ADD_KHR_APPROVAL_SUB',l_inv_agrmnt_number));
1222:

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

1219: itemkey => itemkey,
1220: aname => G_WF_ITM_APP_REQUEST_SUB,
1221: avalue => get_message('OKL_IA_ADD_KHR_APPROVAL_SUB',l_inv_agrmnt_number));
1222:
1223: wf_engine.SetItemAttrText (itemtype => itemtype,
1224: itemkey => itemkey,
1225: aname => G_WF_ITM_APP_REMINDER_SUB,
1226: avalue => get_message('OKL_IA_ADD_KHR_APPROVAL_REM',l_inv_agrmnt_number));
1227: wf_engine.SetItemAttrText (itemtype => itemtype,

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

1223: wf_engine.SetItemAttrText (itemtype => itemtype,
1224: itemkey => itemkey,
1225: aname => G_WF_ITM_APP_REMINDER_SUB,
1226: avalue => get_message('OKL_IA_ADD_KHR_APPROVAL_REM',l_inv_agrmnt_number));
1227: wf_engine.SetItemAttrText (itemtype => itemtype,
1228: itemkey => itemkey,
1229: aname => G_WF_ITM_APP_REMINDER_HEAD,
1230: avalue => get_message('OKL_IA_ADD_KHR_APPROVAL_REM',l_inv_agrmnt_number));
1231:

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

1228: itemkey => itemkey,
1229: aname => G_WF_ITM_APP_REMINDER_HEAD,
1230: avalue => get_message('OKL_IA_ADD_KHR_APPROVAL_REM',l_inv_agrmnt_number));
1231:
1232: wf_engine.SetItemAttrText (itemtype => itemtype,
1233: itemkey => itemkey,
1234: aname => G_WF_ITM_APP_APPROVED_SUB,
1235: avalue => get_message('OKL_IA_ADD_KHR_APPROVED_SUB',l_inv_agrmnt_number));
1236: wf_engine.SetItemAttrText (itemtype => itemtype,

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

1232: wf_engine.SetItemAttrText (itemtype => itemtype,
1233: itemkey => itemkey,
1234: aname => G_WF_ITM_APP_APPROVED_SUB,
1235: avalue => get_message('OKL_IA_ADD_KHR_APPROVED_SUB',l_inv_agrmnt_number));
1236: wf_engine.SetItemAttrText (itemtype => itemtype,
1237: itemkey => itemkey,
1238: aname => G_WF_ITM_APP_APPROVED_HEAD,
1239: avalue => get_message('OKL_IA_ADD_KHR_APPROVED_SUB',l_inv_agrmnt_number));
1240:

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

1237: itemkey => itemkey,
1238: aname => G_WF_ITM_APP_APPROVED_HEAD,
1239: avalue => get_message('OKL_IA_ADD_KHR_APPROVED_SUB',l_inv_agrmnt_number));
1240:
1241: wf_engine.SetItemAttrText (itemtype => itemtype,
1242: itemkey => itemkey,
1243: aname => G_WF_ITM_APP_REJECTED_SUB,
1244: avalue => get_message('OKL_IA_ADD_KHR_REJECTED_SUB',l_inv_agrmnt_number));
1245: wf_engine.SetItemAttrText (itemtype => itemtype,

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

1241: wf_engine.SetItemAttrText (itemtype => itemtype,
1242: itemkey => itemkey,
1243: aname => G_WF_ITM_APP_REJECTED_SUB,
1244: avalue => get_message('OKL_IA_ADD_KHR_REJECTED_SUB',l_inv_agrmnt_number));
1245: wf_engine.SetItemAttrText (itemtype => itemtype,
1246: itemkey => itemkey,
1247: aname => G_WF_ITM_APP_REJECTED_HEAD,
1248: avalue => get_message('OKL_IA_ADD_KHR_REJECTED_SUB',l_inv_agrmnt_number));
1249:

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

1326: CLOSE l_wf_item_key_csr;
1327:
1328: IF (funcmode = 'RUN') THEN
1329:
1330: wf_engine.CreateProcess(itemtype => l_item_type,
1331: itemkey => l_key,
1332: process => l_process);
1333:
1334: wf_engine.SetItemParent(itemtype => l_item_type,

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

1330: wf_engine.CreateProcess(itemtype => l_item_type,
1331: itemkey => l_key,
1332: process => l_process);
1333:
1334: wf_engine.SetItemParent(itemtype => l_item_type,
1335: itemkey => l_key,
1336: parent_itemtype => itemtype,
1337: parent_itemkey => itemkey,
1338: parent_context => G_WF_ITM_MASTER);

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

1336: parent_itemtype => itemtype,
1337: parent_itemkey => itemkey,
1338: parent_context => G_WF_ITM_MASTER);
1339:
1340: wf_engine.SetItemAttrText (itemtype => l_item_type,
1341: itemkey => l_key,
1342: aname => G_WF_ITM_PARENT_ITEM_KEY,
1343: avalue => itemkey);
1344:

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

1341: itemkey => l_key,
1342: aname => G_WF_ITM_PARENT_ITEM_KEY,
1343: avalue => itemkey);
1344:
1345: wf_engine.SetItemAttrText (itemtype => l_item_type,
1346: itemkey => l_key,
1347: aname => G_WF_ITM_PARENT_ITEM_TYPE,
1348: avalue => itemtype);
1349:

Line 1352: l_agreement_id := wf_engine.GetItemAttrText (itemtype => itemtype,

1348: avalue => itemtype);
1349:
1350: -- Re populate Item Attributes for the Detail Process
1351:
1352: l_agreement_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1353: itemkey => itemkey,
1354: aname => G_WF_ITM_INVESTOR_AGRMNT_ID);
1355:
1356: l_agreement_number := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1356: l_agreement_number := wf_engine.GetItemAttrText (itemtype => itemtype,

1352: l_agreement_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1353: itemkey => itemkey,
1354: aname => G_WF_ITM_INVESTOR_AGRMNT_ID);
1355:
1356: l_agreement_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1357: itemkey => itemkey,
1358: aname => G_WF_ITM_INV_AGRMNT_NUMBER);
1359:
1360: l_requester := wf_engine.GetItemAttrText (itemtype => itemtype,

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

1356: l_agreement_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1357: itemkey => itemkey,
1358: aname => G_WF_ITM_INV_AGRMNT_NUMBER);
1359:
1360: l_requester := wf_engine.GetItemAttrText (itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => G_WF_ITM_REQUESTER);
1363:
1364: l_requester_id := wf_engine.GetItemAttrText (itemtype => itemtype,

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

1360: l_requester := wf_engine.GetItemAttrText (itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => G_WF_ITM_REQUESTER);
1363:
1364: l_requester_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1365: itemkey => itemkey,
1366: aname => G_WF_ITM_REQUESTER_ID);
1367:
1368: l_pool_id := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1368: l_pool_id := wf_engine.GetItemAttrText (itemtype => itemtype,

1364: l_requester_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1365: itemkey => itemkey,
1366: aname => G_WF_ITM_REQUESTER_ID);
1367:
1368: l_pool_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1369: itemkey => itemkey,
1370: aname => G_WF_ITM_POOL_ID);
1371: l_pool_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1372: itemkey => itemkey,

Line 1371: l_pool_number := wf_engine.GetItemAttrText (itemtype => itemtype,

1367:
1368: l_pool_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1369: itemkey => itemkey,
1370: aname => G_WF_ITM_POOL_ID);
1371: l_pool_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1372: itemkey => itemkey,
1373: aname => G_WF_ITM_POOL_NUMBER);
1374: l_pool_trans_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1375: itemkey => itemkey,

Line 1374: l_pool_trans_id := wf_engine.GetItemAttrText (itemtype => itemtype,

1370: aname => G_WF_ITM_POOL_ID);
1371: l_pool_number := wf_engine.GetItemAttrText (itemtype => itemtype,
1372: itemkey => itemkey,
1373: aname => G_WF_ITM_POOL_NUMBER);
1374: l_pool_trans_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1375: itemkey => itemkey,
1376: aname => G_WF_ITM_POOL_TRANSACTION_ID);
1377:
1378: wf_engine.SetItemAttrText (itemtype => l_item_type,

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

1374: l_pool_trans_id := wf_engine.GetItemAttrText (itemtype => itemtype,
1375: itemkey => itemkey,
1376: aname => G_WF_ITM_POOL_TRANSACTION_ID);
1377:
1378: wf_engine.SetItemAttrText (itemtype => l_item_type,
1379: itemkey => l_key,
1380: aname => G_WF_ITM_POOL_NUMBER,
1381: avalue => l_pool_number);
1382:

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

1379: itemkey => l_key,
1380: aname => G_WF_ITM_POOL_NUMBER,
1381: avalue => l_pool_number);
1382:
1383: wf_engine.SetItemAttrText (itemtype => l_item_type,
1384: itemkey => l_key,
1385: aname => G_WF_ITM_POOL_ID,
1386: avalue => l_pool_id);
1387: wf_engine.SetItemAttrText (itemtype => l_item_type,

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

1383: wf_engine.SetItemAttrText (itemtype => l_item_type,
1384: itemkey => l_key,
1385: aname => G_WF_ITM_POOL_ID,
1386: avalue => l_pool_id);
1387: wf_engine.SetItemAttrText (itemtype => l_item_type,
1388: itemkey => l_key,
1389: aname => G_WF_ITM_POOL_TRANSACTION_ID,
1390: avalue => l_pool_trans_id);
1391:

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

1388: itemkey => l_key,
1389: aname => G_WF_ITM_POOL_TRANSACTION_ID,
1390: avalue => l_pool_trans_id);
1391:
1392: wf_engine.SetItemAttrText (itemtype => l_item_type,
1393: itemkey => l_key,
1394: aname => G_WF_ITM_INVESTOR_AGRMNT_ID,
1395: avalue => l_agreement_id);
1396:

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

1393: itemkey => l_key,
1394: aname => G_WF_ITM_INVESTOR_AGRMNT_ID,
1395: avalue => l_agreement_id);
1396:
1397: wf_engine.SetItemAttrText (itemtype => l_item_type,
1398: itemkey => l_key,
1399: aname => G_WF_ITM_INV_AGRMNT_NUMBER,
1400: avalue => l_agreement_number);
1401:

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

1398: itemkey => l_key,
1399: aname => G_WF_ITM_INV_AGRMNT_NUMBER,
1400: avalue => l_agreement_number);
1401:
1402: wf_engine.SetItemAttrText (itemtype => l_item_type,
1403: itemkey => l_key,
1404: aname => G_WF_ITM_REQUESTER,
1405: avalue => l_requester);
1406:

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

1403: itemkey => l_key,
1404: aname => G_WF_ITM_REQUESTER,
1405: avalue => l_requester);
1406:
1407: wf_engine.SetItemAttrText (itemtype => l_item_type,
1408: itemkey => l_key,
1409: aname => G_WF_ITM_REQUESTER_ID,
1410: avalue => l_requester_id);
1411:

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

1409: aname => G_WF_ITM_REQUESTER_ID,
1410: avalue => l_requester_id);
1411:
1412: -- Set the Message Document
1413: wf_engine.SetItemAttrDocument (itemtype => l_item_type,
1414: itemkey => l_key,
1415: aname => G_WF_ITM_MESSAGE_DOC,
1416: documentid => 'plsql:OKL_SEC_AGREEMENT_WF.pop_approval_doc/'||l_key);
1417:

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

1415: aname => G_WF_ITM_MESSAGE_DOC,
1416: documentid => 'plsql:OKL_SEC_AGREEMENT_WF.pop_approval_doc/'||l_key);
1417:
1418: -- Now, Start the Detail Process
1419: wf_engine.StartProcess(itemtype => l_item_type,
1420: itemkey => l_key);
1421:
1422: resultout := 'COMPLETE:';
1423: RETURN;

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

1475:
1476: BEGIN
1477:
1478: IF (funcmode = 'RUN') THEN
1479: wf_engine.SetItemAttrDocument (itemtype => itemtype,
1480: itemkey => itemkey,
1481: aname => G_WF_ITM_MESSAGE_DOC,
1482: documentid => 'plsql:OKL_SEC_AGREEMENT_WF.pop_approval_doc/'||itemkey);
1483: