DBA Data[Home] [Help]

APPS.AP_WEB_PCARD_WORKFLOW_PKG dependencies on WF_ENGINE

Line 201: WF_ENGINE.CreateProcess(l_item_type,

197:
198: --------------------------------------------------
199: l_debug_info := 'Calling WorkFlow Create Process';
200: --------------------------------------------------
201: WF_ENGINE.CreateProcess(l_item_type,
202: l_item_key,
203: 'MAIN_PROCESS');
204:
205: -------------------------------------------------------------

Line 208: WF_ENGINE.SetItemAttrNumber(l_item_type,

204:
205: -------------------------------------------------------------
206: l_debug_info := 'Set Emp Notification ID Item Attribute';
207: -------------------------------------------------------------
208: WF_ENGINE.SetItemAttrNumber(l_item_type,
209: l_item_key,
210: 'EMPLOYEE_VERIFICATION_ID',
211: l_new_emp_verification_id);
212:

Line 216: WF_ENGINE.SetItemAttrText(l_item_type,

212:
213: -------------------------------------------------------------
214: l_debug_info := 'Set Emp Notification Method Item Attribute';
215: -------------------------------------------------------------
216: WF_ENGINE.SetItemAttrText(l_item_type,
217: l_item_key,
218: 'EMPLOYEE_NOTIFICATION_METHOD',
219: l_employee_notification_method);
220:

Line 234: WF_ENGINE.SetItemAttrNumber(l_item_type,

230:
231: ------------------------------------------------------
232: l_debug_info := 'Set WF Employee_ID Item Attribute';
233: ------------------------------------------------------
234: WF_ENGINE.SetItemAttrNumber(l_item_type,
235: l_item_key,
236: 'EMPLOYEE_ID',
237: l_employee_id);
238:

Line 242: WF_ENGINE.SetItemAttrText(l_item_type,

238:
239: ------------------------------------------------------
240: l_debug_info := 'Set WF Employee_Name Item Attribute';
241: ------------------------------------------------------
242: WF_ENGINE.SetItemAttrText(l_item_type,
243: l_item_key,
244: 'EMPLOYEE_NAME',
245: l_employee_name);
246:

Line 250: WF_ENGINE.SetItemAttrText(l_item_type,

246:
247: --------------------------------------------------------------
248: l_debug_info := 'Set WF Preparer_Display_Name Item Attribute';
249: --------------------------------------------------------------
250: WF_ENGINE.SetItemAttrText(l_item_type,
251: l_item_key,
252: 'EMPLOYEE_DISPLAY_NAME',
253: l_employee_display_name);
254:

Line 262: WF_ENGINE.SetItemAttrText(l_item_type,

258:
259: ------------------------------------------------------
260: l_debug_info := 'Set WF Employee_Name Item Attribute';
261: ------------------------------------------------------
262: WF_ENGINE.SetItemAttrText(l_item_type,
263: l_item_key,
264: 'STATUS_LOOKUP_CODE',
265: l_status_lookup_code);
266:

Line 282: WF_ENGINE.SetItemAttrText(l_item_type,

278: -----------------------------------------------------
279:
280: -- Be sure to clear these values. If we are resubmitting, we don't want
281: -- the values from the previous process traversal to hang around.
282: WF_ENGINE.SetItemAttrText(l_item_type,
283: l_item_key,
284: 'PCARD_TRANS_DETAILS',
285: l_url);
286: /*MOAC CHANGES MADE FOR PCARD PROJECT*/

Line 287: WF_ENGINE.SetItemAttrNumber(l_item_type,

283: l_item_key,
284: 'PCARD_TRANS_DETAILS',
285: l_url);
286: /*MOAC CHANGES MADE FOR PCARD PROJECT*/
287: WF_ENGINE.SetItemAttrNumber(l_item_type,
288: l_item_key,
289: 'ORG_ID',
290: nvl(p_org_id,mo_utils.get_default_org_id));
291:

Line 295: WF_ENGINE.StartProcess(l_item_type,

291:
292: ------------------------------------------------------------
293: l_debug_info := 'Start the Expense Report Workflow Process';
294: ------------------------------------------------------------
295: WF_ENGINE.StartProcess(l_item_type,
296: l_item_key);
297:
298: ELSE
299:

Line 486: WF_ENGINE.CreateProcess(l_item_type,

482:
483: --------------------------------------------------
484: l_debug_info := 'Calling WorkFlow Create Process';
485: --------------------------------------------------
486: WF_ENGINE.CreateProcess(l_item_type,
487: l_item_key,
488: 'AP_PC_MGR_APRVL_MAIN_PROCESS');
489:
490: ---------------------------------------------------------

Line 493: WF_ENGINE.SetItemAttrNumber(l_item_type,

489:
490: ---------------------------------------------------------
491: l_debug_info := 'Set Emp Notification ID Item Attribute';
492: ---------------------------------------------------------
493: WF_ENGINE.SetItemAttrNumber(l_item_type,
494: l_item_key,
495: 'MANAGER_APPROVAL_ID',
496: l_new_manager_approval_id);
497:

Line 501: WF_ENGINE.SetItemAttrText(l_item_type,

497:
498: -------------------------------------------------------------
499: l_debug_info := 'Set Emp Notification Method Item Attribute';
500: -------------------------------------------------------------
501: WF_ENGINE.SetItemAttrText(l_item_type,
502: l_item_key,
503: 'MANAGER_APPROVAL_METHOD',
504: l_manager_approval_method);
505:

Line 519: WF_ENGINE.SetItemAttrNumber(l_item_type,

515:
516: ---------------------------------------------------
517: l_debug_info := 'Set WF Manager_ID Item Attribute';
518: ---------------------------------------------------
519: WF_ENGINE.SetItemAttrNumber(l_item_type,
520: l_item_key,
521: 'MANAGER_ID',
522: l_manager_id);
523:

Line 527: WF_ENGINE.SetItemAttrText(l_item_type,

523:
524: ------------------------------------------------------
525: l_debug_info := 'Set WF Manager_Name Item Attribute';
526: ------------------------------------------------------
527: WF_ENGINE.SetItemAttrText(l_item_type,
528: l_item_key,
529: 'MANAGER_NAME',
530: l_manager_name);
531:

Line 535: WF_ENGINE.SetItemAttrText(l_item_type,

531:
532: --------------------------------------------------------------
533: l_debug_info := 'Set WF Manager_Display_Name Item Attribute';
534: --------------------------------------------------------------
535: WF_ENGINE.SetItemAttrText(l_item_type,
536: l_item_key,
537: 'MANAGER_DISPLAY_NAME',
538: l_manager_display_name);
539:

Line 555: WF_ENGINE.SetItemAttrNumber(l_item_type,

551:
552: ------------------------------------------------------
553: l_debug_info := 'Set WF Employee_ID Item Attribute';
554: ------------------------------------------------------
555: WF_ENGINE.SetItemAttrNumber(l_item_type,
556: l_item_key,
557: 'EMPLOYEE_ID',
558: l_employee_id);
559:

Line 563: WF_ENGINE.SetItemAttrText(l_item_type,

559:
560: ------------------------------------------------------
561: l_debug_info := 'Set WF Employee_Name Item Attribute';
562: ------------------------------------------------------
563: WF_ENGINE.SetItemAttrText(l_item_type,
564: l_item_key,
565: 'EMPLOYEE_NAME',
566: l_employee_name);
567:

Line 571: WF_ENGINE.SetItemAttrText(l_item_type,

567:
568: --------------------------------------------------------------
569: l_debug_info := 'Set WF Preparer_Display_Name Item Attribute';
570: --------------------------------------------------------------
571: WF_ENGINE.SetItemAttrText(l_item_type,
572: l_item_key,
573: 'EMPLOYEE_DISPLAY_NAME',
574: l_employee_display_name);
575:

Line 591: WF_ENGINE.SetItemAttrText(l_item_type,

587: -----------------------------------------------------
588:
589: -- Be sure to clear these values. If we are resubmitting, we don't want
590: -- the values from the previous process traversal to hang around.
591: WF_ENGINE.SetItemAttrText(l_item_type,
592: l_item_key,
593: 'PCARD_TRANS_DETAILS',
594: l_url);
595: /*MOAC CHANGES MADE FOR PCARD PROJECT*/

Line 596: WF_ENGINE.SetItemAttrNumber(l_item_type,

592: l_item_key,
593: 'PCARD_TRANS_DETAILS',
594: l_url);
595: /*MOAC CHANGES MADE FOR PCARD PROJECT*/
596: WF_ENGINE.SetItemAttrNumber(l_item_type,
597: l_item_key,
598: 'ORG_ID',
599: nvl(p_org_id,mo_utils.get_default_org_id));
600:

Line 605: WF_ENGINE.StartProcess(l_item_type,

601:
602: ------------------------------------------------------------
603: l_debug_info := 'Start the Expense Report Workflow Process';
604: ------------------------------------------------------------
605: WF_ENGINE.StartProcess(l_item_type,
606: l_item_key);
607:
608:
609: ELSE

Line 791: l_emp_notification_method := WF_ENGINE.GetItemAttrText(p_item_type,

787:
788: -------------------------------------------------------------
789: l_debug_info := 'Set Emp Notification Method Item Attribute';
790: -------------------------------------------------------------
791: l_emp_notification_method := WF_ENGINE.GetItemAttrText(p_item_type,
792: p_item_key,
793: 'EMPLOYEE_NOTIFICATION_METHOD');
794:
795: IF (l_emp_notification_method = 'I') THEN

Line 835: l_emp_verification_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

831:
832: -------------------------------------------------------------
833: l_debug_info := 'Set Emp Notification Method Item Attribute';
834: -------------------------------------------------------------
835: l_emp_verification_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
836: p_item_key,
837: 'EMPLOYEE_VERIFICATION_ID');
838:
839: --------------------------------------------------------

Line 842: l_status_lookup_code := WF_ENGINE.GetItemAttrText(p_item_type,

838:
839: --------------------------------------------------------
840: l_debug_info := 'Set Status Lookup Code Item Attribute';
841: ---------------------------------------------------------
842: l_status_lookup_code := WF_ENGINE.GetItemAttrText(p_item_type,
843: p_item_key,
844: 'STATUS_LOOKUP_CODE');
845:
846: ----------------------------------

Line 850: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,

846: ----------------------------------
847: l_debug_info := 'Set Org Context';
848: ----------------------------------
849: -- EmpVfyPCardSetOrgContext(l_emp_verification_id);
850: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
851: p_item_key,
852: 'ORG_ID');
853: Mo_Global.set_policy_context('S', l_org_id);
854: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

Line 854: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

850: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
851: p_item_key,
852: 'ORG_ID');
853: Mo_Global.set_policy_context('S', l_org_id);
854: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
855:
856:
857: -------------------------------------------
858: l_debug_info := 'Update Expense Feed Dists';

Line 902: l_emp_verification_id := WF_ENGINE.GetItemAttrText(p_item_type,

898:
899: -------------------------------------------------------------
900: l_debug_info := 'Set Emp Notification Method Item Attribute';
901: -------------------------------------------------------------
902: l_emp_verification_id := WF_ENGINE.GetItemAttrText(p_item_type,
903: p_item_key,
904: 'EMPLOYEE_VERIFICATION_ID');
905:
906: ----------------------------------

Line 910: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,

906: ----------------------------------
907: l_debug_info := 'Set Org Context';
908: ----------------------------------
909: --EmpVfyPCardSetOrgContext(l_emp_verification_id);
910: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
911: p_item_key,
912: 'ORG_ID');
913: Mo_Global.set_policy_context('S', l_org_id);
914: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

Line 914: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

910: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
911: p_item_key,
912: 'ORG_ID');
913: Mo_Global.set_policy_context('S', l_org_id);
914: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
915: BEGIN
916: --bug5058949
917: --Performance fix
918: UPDATE ap_expense_feed_dists fd

Line 971: l_emp_verification_id := WF_ENGINE.GetItemAttrText(p_item_type,

967:
968: -------------------------------------------------------------
969: l_debug_info := 'Set Emp Notification Method Item Attribute';
970: -------------------------------------------------------------
971: l_emp_verification_id := WF_ENGINE.GetItemAttrText(p_item_type,
972: p_item_key,
973: 'EMPLOYEE_VERIFICATION_ID');
974:
975: --------------------------------------------------------

Line 978: l_orig_status_lookup_code := WF_ENGINE.GetItemAttrText(p_item_type,

974:
975: --------------------------------------------------------
976: l_debug_info := 'Set Status Lookup Code Item Attribute';
977: ---------------------------------------------------------
978: l_orig_status_lookup_code := WF_ENGINE.GetItemAttrText(p_item_type,
979: p_item_key,
980: 'STATUS_LOOKUP_CODE');
981:
982: ----------------------------------

Line 986: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,

982: ----------------------------------
983: l_debug_info := 'Set Org Context';
984: ----------------------------------
985: --EmpVfyPCardSetOrgContext(l_emp_verification_id);
986: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
987: p_item_key,
988: 'ORG_ID');
989: Mo_Global.set_policy_context('S', l_org_id);
990: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

Line 990: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

986: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
987: p_item_key,
988: 'ORG_ID');
989: Mo_Global.set_policy_context('S', l_org_id);
990: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
991:
992:
993: SELECT count(*)
994: INTO l_num_dists_not_processed

Line 1078: l_emp_verification_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1074:
1075: --------------------------------------------------------------------
1076: l_debug_info := 'Retrieve Employee Verification ID Item Attribute';
1077: ---------------------------------------------------------------------
1078: l_emp_verification_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1079: p_item_key,
1080: 'EMPLOYEE_VERIFICATION_ID');
1081: l_org_id:=WF_ENGINE.GetItemAttrNumber(p_item_type,
1082: p_item_key,

Line 1081: l_org_id:=WF_ENGINE.GetItemAttrNumber(p_item_type,

1077: ---------------------------------------------------------------------
1078: l_emp_verification_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1079: p_item_key,
1080: 'EMPLOYEE_VERIFICATION_ID');
1081: l_org_id:=WF_ENGINE.GetItemAttrNumber(p_item_type,
1082: p_item_key,
1083: 'ORG_ID');
1084:
1085: Mo_Global.set_policy_context('S', l_org_id);

Line 1087: l_status_lookup_code := WF_ENGINE.GetItemAttrNumber(p_item_type,

1083: 'ORG_ID');
1084:
1085: Mo_Global.set_policy_context('S', l_org_id);
1086:
1087: l_status_lookup_code := WF_ENGINE.GetItemAttrNumber(p_item_type,
1088: p_item_key,
1089: 'STATUS_LOOKUP_CODE');
1090:
1091: IF (l_status_lookup_code = 'VALIDATED') THEN

Line 1112: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'EMPLOYEE_VERIFICATION_ID',l_emp_verification_id);

1108: END IF;
1109:
1110: fnd_message.set_name('SQLAP', l_message_name);
1111: l_message_text := FND_MESSAGE.Get;
1112: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'EMPLOYEE_VERIFICATION_ID',l_emp_verification_id);
1113: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1114:
1115: WF_ENGINE.SetItemAttrText(p_item_type,
1116: p_item_key,

Line 1113: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

1109:
1110: fnd_message.set_name('SQLAP', l_message_name);
1111: l_message_text := FND_MESSAGE.Get;
1112: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'EMPLOYEE_VERIFICATION_ID',l_emp_verification_id);
1113: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1114:
1115: WF_ENGINE.SetItemAttrText(p_item_type,
1116: p_item_key,
1117: 'EMP_VERIFY_MSG_INTRO',

Line 1115: WF_ENGINE.SetItemAttrText(p_item_type,

1111: l_message_text := FND_MESSAGE.Get;
1112: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'EMPLOYEE_VERIFICATION_ID',l_emp_verification_id);
1113: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1114:
1115: WF_ENGINE.SetItemAttrText(p_item_type,
1116: p_item_key,
1117: 'EMP_VERIFY_MSG_INTRO',
1118: l_message_text);
1119:

Line 1160: WF_ENGINE.SetItemAttrText(p_item_type,

1156:
1157: ------------------------------------------------------------------------
1158: l_debug_info := 'Set Line_Info Item Attribute with formatted expense line';
1159: ---------------------------------------------------------------------------
1160: WF_ENGINE.SetItemAttrText(p_item_type,
1161: p_item_key,
1162: l_attribute_name,
1163: l_line_info);
1164:

Line 1174: WF_ENGINE.SetItemAttrText(p_item_type,

1170:
1171: ---------------------------------------------------------
1172: l_debug_info := 'Set Line Justification Item Attribute';
1173: ---------------------------------------------------------
1174: WF_ENGINE.SetItemAttrText(p_item_type,
1175: p_item_key,
1176: l_attribute_name,
1177: '----> ' || l_description);
1178:

Line 1211: WF_ENGINE.SetItemAttrText(p_item_type,

1207:
1208: ---------------------------------------------------------
1209: l_debug_info := 'Set Item Attribute Line_Info_Body1';
1210: ---------------------------------------------------------
1211: WF_ENGINE.SetItemAttrText(p_item_type,
1212: p_item_key,
1213: 'LINE_BODY_00001',
1214: l_line_info_body1);
1215:

Line 1221: WF_ENGINE.SetItemAttrText(p_item_type,

1217:
1218: ---------------------------------------------------------
1219: l_debug_info := 'Set Item Attribute Line_Info_Body2';
1220: ---------------------------------------------------------
1221: WF_ENGINE.SetItemAttrText(p_item_type,
1222: p_item_key,
1223: 'LINE_BODY_00002',
1224: l_line_info_body2);
1225:

Line 1258: l_manager_approval_method := WF_ENGINE.GetItemAttrText(p_item_type,

1254:
1255: -------------------------------------------------------------
1256: l_debug_info := 'Set Emp Notification Method Item Attribute';
1257: -------------------------------------------------------------
1258: l_manager_approval_method := WF_ENGINE.GetItemAttrText(p_item_type,
1259: p_item_key,
1260: 'MANAGER_APPROVAL_METHOD');
1261:
1262: IF (l_manager_approval_method = 'I') THEN

Line 1305: l_manager_approval_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1301:
1302: -------------------------------------------------------------
1303: l_debug_info := 'Set Emp Notification Method Item Attribute';
1304: -------------------------------------------------------------
1305: l_manager_approval_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1306: p_item_key,
1307: 'MANAGER_APPROVAL_ID');
1308:
1309: ----------------------------------

Line 1313: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,

1309: ----------------------------------
1310: l_debug_info := 'Set Org Context';
1311: ----------------------------------
1312: --MgrAprvlPCardSetOrgContext(l_manager_approval_id);
1313: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
1314: p_item_key,
1315: 'ORG_ID');
1316: Mo_Global.set_policy_context('S', l_org_id);
1317: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

Line 1317: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

1313: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
1314: p_item_key,
1315: 'ORG_ID');
1316: Mo_Global.set_policy_context('S', l_org_id);
1317: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1318:
1319:
1320: BEGIN
1321: UPDATE ap_expense_feed_dists

Line 1364: l_manager_approval_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1360:
1361: -------------------------------------------------------------
1362: l_debug_info := 'Set Emp Notification Method Item Attribute';
1363: -------------------------------------------------------------
1364: l_manager_approval_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1365: p_item_key,
1366: 'MANAGER_APPROVAL_ID');
1367: ----------------------------------
1368: l_debug_info := 'Set Org Context';

Line 1371: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,

1367: ----------------------------------
1368: l_debug_info := 'Set Org Context';
1369: ----------------------------------
1370: --MgrAprvlPCardSetOrgContext(l_manager_approval_id);
1371: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
1372: p_item_key,
1373: 'ORG_ID');
1374: Mo_Global.set_policy_context('S', l_org_id);
1375: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

Line 1375: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

1371: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
1372: p_item_key,
1373: 'ORG_ID');
1374: Mo_Global.set_policy_context('S', l_org_id);
1375: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1376:
1377: BEGIN
1378: UPDATE ap_expense_feed_dists
1379: SET status_lookup_code = 'APPROVED'

Line 1457: l_manager_approval_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1453:
1454: --------------------------------------------------------------------
1455: l_debug_info := 'Retrieve Employee Verification ID Item Attribute';
1456: ---------------------------------------------------------------------
1457: l_manager_approval_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1458: p_item_key,
1459: 'MANAGER_APPROVAL_ID');
1460:
1461: ----------------------------------

Line 1465: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'MANAGER_APPROVAL_ID',l_manager_approval_id);

1461: ----------------------------------
1462: l_debug_info := 'Set Org Context';
1463: ----------------------------------
1464: --MgrAprvlPCardSetOrgContext(l_manager_approval_id);
1465: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'MANAGER_APPROVAL_ID',l_manager_approval_id);
1466: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
1467: p_item_key,
1468: 'ORG_ID');
1469: Mo_Global.set_policy_context('S', l_org_id);

Line 1466: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,

1462: l_debug_info := 'Set Org Context';
1463: ----------------------------------
1464: --MgrAprvlPCardSetOrgContext(l_manager_approval_id);
1465: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'MANAGER_APPROVAL_ID',l_manager_approval_id);
1466: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
1467: p_item_key,
1468: 'ORG_ID');
1469: Mo_Global.set_policy_context('S', l_org_id);
1470: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

Line 1470: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);

1466: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
1467: p_item_key,
1468: 'ORG_ID');
1469: Mo_Global.set_policy_context('S', l_org_id);
1470: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1471:
1472: --------------------------------------------
1473: l_debug_info := 'Open Expense Lines Cursor';
1474: --------------------------------------------

Line 1517: WF_ENGINE.SetItemAttrText(p_item_type,

1513:
1514: ------------------------------------------------------------------------
1515: l_debug_info := 'Set Line_Info Item Attribute with formatted expense line';
1516: ---------------------------------------------------------------------------
1517: WF_ENGINE.SetItemAttrText(p_item_type,
1518: p_item_key,
1519: l_attribute_name,
1520: l_line_info);
1521:

Line 1531: WF_ENGINE.SetItemAttrText(p_item_type,

1527:
1528: ---------------------------------------------------------
1529: l_debug_info := 'Set Line Justification Item Attribute';
1530: ---------------------------------------------------------
1531: WF_ENGINE.SetItemAttrText(p_item_type,
1532: p_item_key,
1533: l_attribute_name,
1534: '----> ' || l_description);
1535: */

Line 1568: WF_ENGINE.SetItemAttrText(p_item_type,

1564:
1565: ---------------------------------------------------------
1566: l_debug_info := 'Set Item Attribute Line_Info_Body1';
1567: ---------------------------------------------------------
1568: WF_ENGINE.SetItemAttrText(p_item_type,
1569: p_item_key,
1570: 'LINE_BODY_00001',
1571: l_line_info_body1);
1572:

Line 1578: WF_ENGINE.SetItemAttrText(p_item_type,

1574:
1575: ---------------------------------------------------------
1576: l_debug_info := 'Set Item Attribute Line_Info_Body2';
1577: ---------------------------------------------------------
1578: WF_ENGINE.SetItemAttrText(p_item_type,
1579: p_item_key,
1580: 'LINE_BODY_00002',
1581: l_line_info_body2);
1582: