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

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

332: BEGIN
333: get_current_user_name(l_first_name, l_last_name);
334: get_current_user_company_name(l_company_name);
335:
336: wf_engine.SetItemAttrText (itemtype => itemtype,
337: itemkey => itemkey,
338: aname => 'COMPANY_NAME',
339: avalue => l_company_name);
340:

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

338: aname => 'COMPANY_NAME',
339: avalue => l_company_name);
340:
341:
342: wf_engine.SetItemAttrText (itemtype => itemtype,
343: itemkey => itemkey,
344: aname => 'FIRST_NAME',
345: avalue => l_first_name);
346:

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

343: itemkey => itemkey,
344: aname => 'FIRST_NAME',
345: avalue => l_first_name);
346:
347: wf_engine.SetItemAttrText (itemtype => itemtype,
348: itemkey => itemkey,
349: aname => 'LAST_NAME',
350: avalue => l_last_name);
351:

Line 445: wf_engine.CreateProcess(itemtype => l_itemtype,

441: get_wf_item_key (l_process,
442: To_char(p_vendor_id) || '_' || p_address_request_id,
443: l_itemkey);
444:
445: wf_engine.CreateProcess(itemtype => l_itemtype,
446: itemkey => l_itemkey,
447: process => l_process);
448: l_step := 6;
449: wf_engine.SetItemAttrText (itemtype => l_itemtype,

Line 449: wf_engine.SetItemAttrText (itemtype => l_itemtype,

445: wf_engine.CreateProcess(itemtype => l_itemtype,
446: itemkey => l_itemkey,
447: process => l_process);
448: l_step := 6;
449: wf_engine.SetItemAttrText (itemtype => l_itemtype,
450: itemkey => l_itemkey,
451: aname => 'RECEIVER',
452: avalue => l_receiver);
453:

Line 454: wf_engine.SetItemAttrText (itemtype => l_itemtype,

450: itemkey => l_itemkey,
451: aname => 'RECEIVER',
452: avalue => l_receiver);
453:
454: wf_engine.SetItemAttrText (itemtype => l_itemtype,
455: itemkey => l_itemkey,
456: aname => 'SUPPLIER_NAME',
457: avalue => l_supplier_name);
458:

Line 459: wf_engine.SetItemAttrText (itemtype => l_itemtype,

455: itemkey => l_itemkey,
456: aname => 'SUPPLIER_NAME',
457: avalue => l_supplier_name);
458:
459: wf_engine.SetItemAttrText (itemtype => l_itemtype,
460: itemkey => l_itemkey,
461: aname => 'ADDRESS_NAME',
462: avalue => l_address_name);
463: wf_engine.SetItemAttrText (itemtype => l_itemtype,

Line 463: wf_engine.SetItemAttrText (itemtype => l_itemtype,

459: wf_engine.SetItemAttrText (itemtype => l_itemtype,
460: itemkey => l_itemkey,
461: aname => 'ADDRESS_NAME',
462: avalue => l_address_name);
463: wf_engine.SetItemAttrText (itemtype => l_itemtype,
464: itemkey => l_itemkey,
465: aname => 'VENDOR_ID',
466: avalue => p_vendor_id);
467:

Line 468: wf_engine.SetItemAttrText (itemtype => l_itemtype,

464: itemkey => l_itemkey,
465: aname => 'VENDOR_ID',
466: avalue => p_vendor_id);
467:
468: wf_engine.SetItemAttrText (itemtype => l_itemtype,
469: itemkey => l_itemkey,
470: aname => 'URL',
471: avalue => pos_url_pkg.get_dest_page_url('POS_HT_SP_B_ADDR_BK', 'BUYER'));
472: l_step := 7;

Line 476: wf_engine.StartProcess(itemtype => l_itemtype,

472: l_step := 7;
473: setup_actioner_private(l_itemtype, l_itemkey);
474:
475: l_step := 8;
476: wf_engine.StartProcess(itemtype => l_itemtype,
477: itemkey => l_itemkey );
478: l_step := 9;
479: x_itemtype := l_itemtype;
480: x_itemkey := l_itemkey;

Line 629: wf_engine.CreateProcess(itemtype => l_itemtype,

625: To_char(p_vendor_id) || '_' || p_bus_class_request_id,
626: l_itemkey);
627:
628: l_step := 7;
629: wf_engine.CreateProcess(itemtype => l_itemtype,
630: itemkey => l_itemkey,
631: process => p_process);
632: l_step := 8;
633:

Line 634: wf_engine.SetItemAttrText (itemtype => l_itemtype,

630: itemkey => l_itemkey,
631: process => p_process);
632: l_step := 8;
633:
634: wf_engine.SetItemAttrText (itemtype => l_itemtype,
635: itemkey => l_itemkey,
636: aname => 'RECEIVER',
637: avalue => l_receiver);
638:

Line 639: wf_engine.SetItemAttrText (itemtype => l_itemtype,

635: itemkey => l_itemkey,
636: aname => 'RECEIVER',
637: avalue => l_receiver);
638:
639: wf_engine.SetItemAttrText (itemtype => l_itemtype,
640: itemkey => l_itemkey,
641: aname => 'SUPPLIER_NAME',
642: avalue => l_supplier_name);
643:

Line 644: wf_engine.SetItemAttrText (itemtype => l_itemtype,

640: itemkey => l_itemkey,
641: aname => 'SUPPLIER_NAME',
642: avalue => l_supplier_name);
643:
644: wf_engine.SetItemAttrText (itemtype => l_itemtype,
645: itemkey => l_itemkey,
646: aname => 'BUS_CLASS_NAME',
647: avalue => l_bus_class_name);
648:

Line 649: wf_engine.SetItemAttrText (itemtype => l_itemtype,

645: itemkey => l_itemkey,
646: aname => 'BUS_CLASS_NAME',
647: avalue => l_bus_class_name);
648:
649: wf_engine.SetItemAttrText (itemtype => l_itemtype,
650: itemkey => l_itemkey,
651: aname => 'VENDOR_ID',
652: avalue => p_vendor_id);
653:

Line 654: wf_engine.SetItemAttrText (itemtype => l_itemtype,

650: itemkey => l_itemkey,
651: aname => 'VENDOR_ID',
652: avalue => p_vendor_id);
653:
654: wf_engine.SetItemAttrText (itemtype => l_itemtype,
655: itemkey => l_itemkey,
656: aname => 'URL',
657: avalue => pos_url_pkg.get_dest_page_url ('POS_HT_SP_B_BUS_CLSS', 'BUYER'));
658: l_step := 9;

Line 664: wf_engine.StartProcess(itemtype => l_itemtype,

660: setup_actioner_private(l_itemtype, l_itemkey);
661:
662: l_step := 10;
663:
664: wf_engine.StartProcess(itemtype => l_itemtype,
665: itemkey => l_itemkey );
666:
667: l_step := 11;
668: x_itemtype := l_itemtype;

Line 820: wf_engine.CreateProcess(itemtype => l_itemtype,

816: To_char(p_vendor_id) || '_' || p_contact_request_id,
817: l_itemkey);
818:
819: l_step := 7;
820: wf_engine.CreateProcess(itemtype => l_itemtype,
821: itemkey => l_itemkey,
822: process => l_process);
823:
824: l_step := 8;

Line 825: wf_engine.SetItemAttrText (itemtype => l_itemtype,

821: itemkey => l_itemkey,
822: process => l_process);
823:
824: l_step := 8;
825: wf_engine.SetItemAttrText (itemtype => l_itemtype,
826: itemkey => l_itemkey,
827: aname => 'RECEIVER',
828: avalue => l_receiver);
829:

Line 830: wf_engine.SetItemAttrText (itemtype => l_itemtype,

826: itemkey => l_itemkey,
827: aname => 'RECEIVER',
828: avalue => l_receiver);
829:
830: wf_engine.SetItemAttrText (itemtype => l_itemtype,
831: itemkey => l_itemkey,
832: aname => 'SUPPLIER_NAME',
833: avalue => l_supplier_name);
834:

Line 835: wf_engine.SetItemAttrText (itemtype => l_itemtype,

831: itemkey => l_itemkey,
832: aname => 'SUPPLIER_NAME',
833: avalue => l_supplier_name);
834:
835: wf_engine.SetItemAttrText (itemtype => l_itemtype,
836: itemkey => l_itemkey,
837: aname => 'CONTACT_NAME',
838: avalue => l_contact_name);
839:

Line 840: wf_engine.SetItemAttrText (itemtype => l_itemtype,

836: itemkey => l_itemkey,
837: aname => 'CONTACT_NAME',
838: avalue => l_contact_name);
839:
840: wf_engine.SetItemAttrText (itemtype => l_itemtype,
841: itemkey => l_itemkey,
842: aname => 'VENDOR_ID',
843: avalue => p_vendor_id);
844:

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

841: itemkey => l_itemkey,
842: aname => 'VENDOR_ID',
843: avalue => p_vendor_id);
844:
845: wf_engine.SetItemAttrText (itemtype => l_itemtype,
846: itemkey => l_itemkey,
847: aname => 'URL',
848: avalue => pos_url_pkg.get_dest_page_url ('POS_HT_SP_B_CONT_DIR', 'BUYER'));
849:

Line 854: wf_engine.StartProcess(itemtype => l_itemtype,

850: l_step := 9;
851: setup_actioner_private(l_itemtype, l_itemkey);
852:
853: l_step := 10;
854: wf_engine.StartProcess(itemtype => l_itemtype,
855: itemkey => l_itemkey );
856:
857: l_step := 11;
858: x_itemtype := l_itemtype;

Line 963: wf_engine.CreateProcess(itemtype => l_itemtype,

959: To_char(p_vendor_id) || '_' || p_contact_party_id,
960: l_itemkey);
961:
962: l_step := 5;
963: wf_engine.CreateProcess(itemtype => l_itemtype,
964: itemkey => l_itemkey,
965: process => l_process);
966:
967: l_step := 6;

Line 968: wf_engine.SetItemAttrText (itemtype => l_itemtype,

964: itemkey => l_itemkey,
965: process => l_process);
966:
967: l_step := 6;
968: wf_engine.SetItemAttrText (itemtype => l_itemtype,
969: itemkey => l_itemkey,
970: aname => 'RECEIVER',
971: avalue => l_receiver);
972:

Line 973: wf_engine.SetItemAttrText (itemtype => l_itemtype,

969: itemkey => l_itemkey,
970: aname => 'RECEIVER',
971: avalue => l_receiver);
972:
973: wf_engine.SetItemAttrText (itemtype => l_itemtype,
974: itemkey => l_itemkey,
975: aname => 'SUPPLIER_NAME',
976: avalue => l_supplier_name);
977:

Line 978: wf_engine.SetItemAttrText (itemtype => l_itemtype,

974: itemkey => l_itemkey,
975: aname => 'SUPPLIER_NAME',
976: avalue => l_supplier_name);
977:
978: wf_engine.SetItemAttrText (itemtype => l_itemtype,
979: itemkey => l_itemkey,
980: aname => 'CONTACT_NAME',
981: avalue => l_contact_name);
982:

Line 983: wf_engine.SetItemAttrText (itemtype => l_itemtype,

979: itemkey => l_itemkey,
980: aname => 'CONTACT_NAME',
981: avalue => l_contact_name);
982:
983: wf_engine.SetItemAttrText (itemtype => l_itemtype,
984: itemkey => l_itemkey,
985: aname => 'VENDOR_ID',
986: avalue => p_vendor_id);
987:

Line 988: wf_engine.SetItemAttrText (itemtype => l_itemtype,

984: itemkey => l_itemkey,
985: aname => 'VENDOR_ID',
986: avalue => p_vendor_id);
987:
988: wf_engine.SetItemAttrText (itemtype => l_itemtype,
989: itemkey => l_itemkey,
990: aname => 'URL',
991: avalue => pos_url_pkg.get_dest_page_url ('POS_HT_SP_B_CONT_DIR', 'BUYER'));
992: l_step := 7;

Line 996: wf_engine.StartProcess(itemtype => l_itemtype,

992: l_step := 7;
993: setup_actioner_private(l_itemtype, l_itemkey);
994: l_step := 8;
995:
996: wf_engine.StartProcess(itemtype => l_itemtype,
997: itemkey => l_itemkey );
998:
999: l_step := 9;
1000: x_itemtype := l_itemtype;

Line 1102: wf_engine.CreateProcess(itemtype => l_itemtype,

1098: To_char(p_vendor_id),
1099: l_itemkey);
1100:
1101: l_step := 7;
1102: wf_engine.CreateProcess(itemtype => l_itemtype,
1103: itemkey => l_itemkey,
1104: process => p_process);
1105:
1106: l_step := 8;

Line 1107: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1103: itemkey => l_itemkey,
1104: process => p_process);
1105:
1106: l_step := 8;
1107: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1108: itemkey => l_itemkey,
1109: aname => 'RECEIVER',
1110: avalue => l_receiver);
1111:

Line 1112: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1108: itemkey => l_itemkey,
1109: aname => 'RECEIVER',
1110: avalue => l_receiver);
1111:
1112: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1113: itemkey => l_itemkey,
1114: aname => 'SUPPLIER_NAME',
1115: avalue => l_supplier_name);
1116:

Line 1117: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1113: itemkey => l_itemkey,
1114: aname => 'SUPPLIER_NAME',
1115: avalue => l_supplier_name);
1116:
1117: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1118: itemkey => l_itemkey,
1119: aname => 'VENDOR_ID',
1120: avalue => p_vendor_id);
1121:

Line 1122: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1118: itemkey => l_itemkey,
1119: aname => 'VENDOR_ID',
1120: avalue => p_vendor_id);
1121:
1122: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1123: itemkey => l_itemkey,
1124: aname => 'URL',
1125: avalue => pos_url_pkg.get_dest_page_url ('POS_HT_SP_B_PS', 'BUYER'));
1126:

Line 1131: wf_engine.StartProcess(itemtype => l_itemtype,

1127: l_step := 9;
1128: setup_actioner_private(l_itemtype, l_itemkey);
1129:
1130: l_step := 10;
1131: wf_engine.StartProcess(itemtype => l_itemtype,
1132: itemkey => l_itemkey );
1133:
1134: l_step := 11;
1135: x_itemtype := l_itemtype;

Line 1390: wf_engine.CreateProcess(itemtype => l_itemtype,

1386: To_char(p_vendor_id) || '_' || p_sup_reg_email,
1387: l_itemkey);
1388:
1389: l_step := 5;
1390: wf_engine.CreateProcess(itemtype => l_itemtype,
1391: itemkey => l_itemkey,
1392: process => l_process);
1393:
1394: l_step := 6;

Line 1395: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1391: itemkey => l_itemkey,
1392: process => l_process);
1393:
1394: l_step := 6;
1395: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1396: itemkey => l_itemkey,
1397: aname => 'RECEIVER',
1398: avalue => l_receiver);
1399:

Line 1400: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1396: itemkey => l_itemkey,
1397: aname => 'RECEIVER',
1398: avalue => l_receiver);
1399:
1400: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1401: itemkey => l_itemkey,
1402: aname => 'SUPPLIER_NAME',
1403: avalue => l_supplier_name);
1404:

Line 1405: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1401: itemkey => l_itemkey,
1402: aname => 'SUPPLIER_NAME',
1403: avalue => l_supplier_name);
1404:
1405: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1406: itemkey => l_itemkey,
1407: aname => 'ENTERPRISE_NAME',
1408: avalue => l_enterprise_name);
1409:

Line 1410: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1406: itemkey => l_itemkey,
1407: aname => 'ENTERPRISE_NAME',
1408: avalue => l_enterprise_name);
1409:
1410: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1411: itemkey => l_itemkey,
1412: aname => 'FIRST_NAME',
1413: avalue => p_first_name);
1414:

Line 1415: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1411: itemkey => l_itemkey,
1412: aname => 'FIRST_NAME',
1413: avalue => p_first_name);
1414:
1415: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1416: itemkey => l_itemkey,
1417: aname => 'LAST_NAME',
1418: avalue => p_last_name);
1419:

Line 1420: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1416: itemkey => l_itemkey,
1417: aname => 'LAST_NAME',
1418: avalue => p_last_name);
1419:
1420: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1421: itemkey => l_itemkey,
1422: aname => 'SUP_REG_EMAIL',
1423: avalue => p_sup_reg_email);
1424:

Line 1426: wf_engine.StartProcess(itemtype => l_itemtype,

1422: aname => 'SUP_REG_EMAIL',
1423: avalue => p_sup_reg_email);
1424:
1425: l_step := 7;
1426: wf_engine.StartProcess(itemtype => l_itemtype,
1427: itemkey => l_itemkey );
1428:
1429: l_step := 8;
1430: x_itemtype := l_itemtype;

Line 1534: wf_engine.CreateProcess(itemtype => l_itemtype,

1530: To_char(p_supplier_reg_id),
1531: l_itemkey);
1532:
1533: l_step := 8;
1534: wf_engine.CreateProcess(itemtype => l_itemtype,
1535: itemkey => l_itemkey,
1536: process => l_process);
1537:
1538: l_step := 9;

Line 1539: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1535: itemkey => l_itemkey,
1536: process => l_process);
1537:
1538: l_step := 9;
1539: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1540: itemkey => l_itemkey,
1541: aname => 'RECEIVER',
1542: avalue => l_receiver);
1543:

Line 1544: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1540: itemkey => l_itemkey,
1541: aname => 'RECEIVER',
1542: avalue => l_receiver);
1543:
1544: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1545: itemkey => l_itemkey,
1546: aname => 'SUPPLIER_NAME',
1547: avalue => l_supplier_name);
1548:

Line 1549: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1545: itemkey => l_itemkey,
1546: aname => 'SUPPLIER_NAME',
1547: avalue => l_supplier_name);
1548:
1549: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1550: itemkey => l_itemkey,
1551: aname => 'URL',
1552: avalue => pos_url_pkg.get_buyer_login_url);
1553:

Line 1555: wf_engine.StartProcess(itemtype => l_itemtype,

1551: aname => 'URL',
1552: avalue => pos_url_pkg.get_buyer_login_url);
1553:
1554: l_step := 10;
1555: wf_engine.StartProcess(itemtype => l_itemtype,
1556: itemkey => l_itemkey );
1557:
1558: l_step := 11;
1559: x_itemtype := l_itemtype;

Line 1644: wf_engine.CreateProcess(itemtype => l_itemtype,

1640: To_char(p_supplier_reg_id),
1641: l_itemkey);
1642:
1643: l_step := 3;
1644: wf_engine.CreateProcess(itemtype => l_itemtype,
1645: itemkey => l_itemkey,
1646: process => l_process);
1647:
1648: l_step := 4;

Line 1649: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1645: itemkey => l_itemkey,
1646: process => l_process);
1647:
1648: l_step := 4;
1649: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1650: itemkey => l_itemkey,
1651: aname => 'RECEIVER',
1652: avalue => p_username);
1653:

Line 1654: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1650: itemkey => l_itemkey,
1651: aname => 'RECEIVER',
1652: avalue => p_username);
1653:
1654: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1655: itemkey => l_itemkey,
1656: aname => 'ENTERPRISE_NAME',
1657: avalue => l_enterprise_name);
1658:

Line 1659: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1655: itemkey => l_itemkey,
1656: aname => 'ENTERPRISE_NAME',
1657: avalue => l_enterprise_name);
1658:
1659: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1660: itemkey => l_itemkey,
1661: aname => 'USERNAME',
1662: avalue => p_username);
1663:

Line 1664: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1660: itemkey => l_itemkey,
1661: aname => 'USERNAME',
1662: avalue => p_username);
1663:
1664: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1665: itemkey => l_itemkey,
1666: aname => 'PASSWORD',
1667: avalue => p_password);
1668:

Line 1669: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1665: itemkey => l_itemkey,
1666: aname => 'PASSWORD',
1667: avalue => p_password);
1668:
1669: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1670: itemkey => l_itemkey,
1671: aname => 'URL',
1672: avalue => pos_url_pkg.get_external_login_url);
1673:

Line 1674: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1670: itemkey => l_itemkey,
1671: aname => 'URL',
1672: avalue => pos_url_pkg.get_external_login_url);
1673:
1674: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1675: itemkey => l_itemkey,
1676: aname => 'ADMIN_EMAIL',
1677: avalue => get_admin_email);
1678:

Line 1680: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1676: aname => 'ADMIN_EMAIL',
1677: avalue => get_admin_email);
1678:
1679: /*
1680: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1681: itemkey => l_itemkey,
1682: aname => 'BUYER_NOTE',
1683: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
1684: */

Line 1688: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1684: */
1685:
1686: -- Bug 8325979 - Following attributes have been replaced with FND Messages
1687:
1688: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1689: itemkey => l_itemkey,
1690: aname => 'POS_APPROVE_SUPPLIER_SUBJECT',
1691: avalue => GET_APPRV_SUPPLIER_SUBJECT(l_enterprise_name));
1692:

Line 1694: wf_engine.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey,

1690: aname => 'POS_APPROVE_SUPPLIER_SUBJECT',
1691: avalue => GET_APPRV_SUPPLIER_SUBJECT(l_enterprise_name));
1692:
1693:
1694: wf_engine.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey,
1695: aname => 'POS_APPROVE_SUPPLIER_BODY',
1696: avalue => 'PLSQLCLOB:pos_spm_wf_pkg1.GENERATE_APPRV_SUPPLIER_BODY/'||l_itemtype ||':' ||l_itemkey ||'#'||p_supplier_reg_id
1697: );
1698:

Line 1700: wf_engine.StartProcess(itemtype => l_itemtype,

1696: avalue => 'PLSQLCLOB:pos_spm_wf_pkg1.GENERATE_APPRV_SUPPLIER_BODY/'||l_itemtype ||':' ||l_itemkey ||'#'||p_supplier_reg_id
1697: );
1698:
1699: l_step := 5;
1700: wf_engine.StartProcess(itemtype => l_itemtype,
1701: itemkey => l_itemkey );
1702: l_step := 6;
1703: x_itemtype := l_itemtype;
1704: x_itemkey := l_itemkey;

Line 1745: wf_engine.CreateProcess(itemtype => l_itemtype,

1741: To_char(p_supplier_reg_id) || '_' || p_username,
1742: l_itemkey);
1743:
1744: l_step := 4;
1745: wf_engine.CreateProcess(itemtype => l_itemtype,
1746: itemkey => l_itemkey,
1747: process => l_process);
1748:
1749: l_step := 5;

Line 1750: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1746: itemkey => l_itemkey,
1747: process => l_process);
1748:
1749: l_step := 5;
1750: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1751: itemkey => l_itemkey,
1752: aname => 'RECEIVER',
1753: avalue => p_username);
1754:

Line 1756: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1752: aname => 'RECEIVER',
1753: avalue => p_username);
1754:
1755: l_step := 6;
1756: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1757: itemkey => l_itemkey,
1758: aname => 'ENTERPRISE_NAME',
1759: avalue => l_enterprise_name);
1760:

Line 1762: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1758: aname => 'ENTERPRISE_NAME',
1759: avalue => l_enterprise_name);
1760:
1761: l_step := 7;
1762: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1763: itemkey => l_itemkey,
1764: aname => 'USERNAME',
1765: avalue => p_username);
1766:

Line 1768: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1764: aname => 'USERNAME',
1765: avalue => p_username);
1766:
1767: l_step := 8;
1768: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1769: itemkey => l_itemkey,
1770: aname => 'PASSWORD',
1771: avalue => p_password);
1772:

Line 1774: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1770: aname => 'PASSWORD',
1771: avalue => p_password);
1772:
1773: l_step := 9;
1774: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1775: itemkey => l_itemkey,
1776: aname => 'URL',
1777: avalue => pos_url_pkg.get_external_login_url);
1778:

Line 1780: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1776: aname => 'URL',
1777: avalue => pos_url_pkg.get_external_login_url);
1778:
1779: l_step := 10;
1780: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1781: itemkey => l_itemkey,
1782: aname => 'ADMIN_EMAIL',
1783: avalue => get_admin_email);
1784:

Line 1787: wf_engine.StartProcess(itemtype => l_itemtype,

1783: avalue => get_admin_email);
1784:
1785: l_step := 11;
1786:
1787: wf_engine.StartProcess(itemtype => l_itemtype,
1788: itemkey => l_itemkey );
1789: x_itemtype := l_itemtype;
1790: x_itemkey := l_itemkey;
1791:

Line 1856: wf_engine.CreateProcess(itemtype => l_itemtype,

1852: To_char(p_supplier_reg_id),
1853: l_itemkey);
1854:
1855: l_step := 8;
1856: wf_engine.CreateProcess(itemtype => l_itemtype,
1857: itemkey => l_itemkey,
1858: process => l_process);
1859:
1860: l_step := 9;

Line 1861: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1857: itemkey => l_itemkey,
1858: process => l_process);
1859:
1860: l_step := 9;
1861: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1862: itemkey => l_itemkey,
1863: aname => 'RECEIVER',
1864: avalue => l_receiver);
1865:

Line 1866: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1862: itemkey => l_itemkey,
1863: aname => 'RECEIVER',
1864: avalue => l_receiver);
1865:
1866: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1867: itemkey => l_itemkey,
1868: aname => 'ENTERPRISE_NAME',
1869: avalue => l_enterprise_name);
1870:

Line 1871: wf_engine.SetItemAttrText (itemtype => l_itemtype,

1867: itemkey => l_itemkey,
1868: aname => 'ENTERPRISE_NAME',
1869: avalue => l_enterprise_name);
1870:
1871: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1872: itemkey => l_itemkey,
1873: aname => 'BUYER_NOTE',
1874: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
1875:

Line 1877: wf_engine.StartProcess(itemtype => l_itemtype,

1873: aname => 'BUYER_NOTE',
1874: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
1875:
1876: l_step := 10;
1877: wf_engine.StartProcess(itemtype => l_itemtype,
1878: itemkey => l_itemkey );
1879:
1880: l_step := 11;
1881: x_itemtype := l_itemtype;

Line 2028: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');

2024: BEGIN
2025:
2026: IF ( funcmode = 'RUN' ) THEN
2027: l_vendor_id :=
2028: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2029: create_adhoc_role('PACCOUNT_ACTION_' || l_vendor_id, l_receiver);
2030:
2031: wf_engine.SetItemAttrText (itemtype => itemtype,
2032: itemkey => itemkey,

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

2027: l_vendor_id :=
2028: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2029: create_adhoc_role('PACCOUNT_ACTION_' || l_vendor_id, l_receiver);
2030:
2031: wf_engine.SetItemAttrText (itemtype => itemtype,
2032: itemkey => itemkey,
2033: aname => 'RECEIVER',
2034: avalue => l_receiver);
2035:

Line 2069: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');

2065: BEGIN
2066: IF ( funcmode = 'RUN' ) THEN
2067:
2068: l_vendor_id :=
2069: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2070:
2071: l_bank_account_number :=
2072: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2073:

Line 2072: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');

2068: l_vendor_id :=
2069: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2070:
2071: l_bank_account_number :=
2072: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2073:
2074: l_currency_code :=
2075: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2076:

Line 2075: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');

2071: l_bank_account_number :=
2072: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2073:
2074: l_currency_code :=
2075: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2076:
2077: l_bank_account_name :=
2078: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2079:

Line 2078: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');

2074: l_currency_code :=
2075: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2076:
2077: l_bank_account_name :=
2078: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2079:
2080: create_adhoc_role('PACCOUNT_UPDATED_'||l_bank_account_number, l_receiver);
2081:
2082: wf_engine.SetItemAttrText (itemtype => itemtype,

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

2078: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2079:
2080: create_adhoc_role('PACCOUNT_UPDATED_'||l_bank_account_number, l_receiver);
2081:
2082: wf_engine.SetItemAttrText (itemtype => itemtype,
2083: itemkey => itemkey,
2084: aname => 'RECEIVER',
2085: avalue => l_receiver);
2086:

Line 2176: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');

2172: BEGIN
2173: IF ( funcmode = 'RUN' ) THEN
2174:
2175: l_vendor_id :=
2176: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2177:
2178: l_bank_account_number :=
2179: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2180:

Line 2179: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');

2175: l_vendor_id :=
2176: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2177:
2178: l_bank_account_number :=
2179: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2180:
2181: l_currency_code :=
2182: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2183:

Line 2182: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');

2178: l_bank_account_number :=
2179: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2180:
2181: l_currency_code :=
2182: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2183:
2184: l_bank_account_name :=
2185: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2186:

Line 2185: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');

2181: l_currency_code :=
2182: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2183:
2184: l_bank_account_name :=
2185: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2186:
2187: create_adhoc_role('PACCOUNT_CREATED_'|| l_vendor_id, l_receiver);
2188:
2189: wf_engine.SetItemAttrText (itemtype => itemtype,

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

2185: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2186:
2187: create_adhoc_role('PACCOUNT_CREATED_'|| l_vendor_id, l_receiver);
2188:
2189: wf_engine.SetItemAttrText (itemtype => itemtype,
2190: itemkey => itemkey,
2191: aname => 'RECEIVER',
2192: avalue => l_receiver);
2193:

Line 2258: wf_engine.CreateProcess(itemtype => l_itemtype,

2254: To_char(p_vendor_id),
2255: l_itemkey);
2256:
2257: l_step := 3;
2258: wf_engine.CreateProcess(itemtype => l_itemtype,
2259: itemkey => l_itemkey,
2260: process => l_process);
2261:
2262: l_step := 4;

Line 2263: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2259: itemkey => l_itemkey,
2260: process => l_process);
2261:
2262: l_step := 4;
2263: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2264: itemkey => l_itemkey,
2265: aname => 'URL',
2266: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2267:

Line 2268: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2264: itemkey => l_itemkey,
2265: aname => 'URL',
2266: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2267:
2268: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2269: itemkey => l_itemkey,
2270: aname => 'SUPPLIER_NAME',
2271: avalue => l_supplier_name);
2272:

Line 2273: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,

2269: itemkey => l_itemkey,
2270: aname => 'SUPPLIER_NAME',
2271: avalue => l_supplier_name);
2272:
2273: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2274: itemkey => l_itemkey,
2275: aname => 'VENDOR_ID',
2276: avalue => p_vendor_id);
2277:

Line 2278: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2274: itemkey => l_itemkey,
2275: aname => 'VENDOR_ID',
2276: avalue => p_vendor_id);
2277:
2278: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2279: itemkey => l_itemkey,
2280: aname => 'BANK_NAME',
2281: avalue => p_bank_name);
2282:

Line 2283: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2279: itemkey => l_itemkey,
2280: aname => 'BANK_NAME',
2281: avalue => p_bank_name);
2282:
2283: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2284: itemkey => l_itemkey,
2285: aname => 'BANK_ACCOUNT_NUMBER',
2286: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2287:

Line 2288: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2284: itemkey => l_itemkey,
2285: aname => 'BANK_ACCOUNT_NUMBER',
2286: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2287:
2288: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2289: itemkey => l_itemkey,
2290: aname => 'FIRST_NAME',
2291: avalue => l_first_name);
2292:

Line 2293: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2289: itemkey => l_itemkey,
2290: aname => 'FIRST_NAME',
2291: avalue => l_first_name);
2292:
2293: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2294: itemkey => l_itemkey,
2295: aname => 'LAST_NAME',
2296: avalue => l_last_name);
2297:

Line 2299: wf_engine.StartProcess(itemtype => l_itemtype,

2295: aname => 'LAST_NAME',
2296: avalue => l_last_name);
2297:
2298: l_step := 5;
2299: wf_engine.StartProcess(itemtype => l_itemtype,
2300: itemkey => l_itemkey );
2301:
2302: x_itemtype := l_itemtype;
2303: x_itemkey := l_itemkey;

Line 2349: wf_engine.CreateProcess(itemtype => l_itemtype,

2345: l_itemkey);
2346:
2347: l_step := 3;
2348:
2349: wf_engine.CreateProcess(itemtype => l_itemtype,
2350: itemkey => l_itemkey,
2351: process => l_process);
2352:
2353: l_step := 4;

Line 2355: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2351: process => l_process);
2352:
2353: l_step := 4;
2354:
2355: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2356: itemkey => l_itemkey,
2357: aname => 'URL',
2358: avalue => pos_url_pkg.get_external_login_url);
2359:

Line 2360: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2356: itemkey => l_itemkey,
2357: aname => 'URL',
2358: avalue => pos_url_pkg.get_external_login_url);
2359:
2360: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2361: itemkey => l_itemkey,
2362: aname => 'SUPPLIER_NAME',
2363: avalue => l_supplier_name);
2364:

Line 2365: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,

2361: itemkey => l_itemkey,
2362: aname => 'SUPPLIER_NAME',
2363: avalue => l_supplier_name);
2364:
2365: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2366: itemkey => l_itemkey,
2367: aname => 'VENDOR_ID',
2368: avalue => p_vendor_id);
2369:

Line 2370: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2366: itemkey => l_itemkey,
2367: aname => 'VENDOR_ID',
2368: avalue => p_vendor_id);
2369:
2370: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2371: itemkey => l_itemkey,
2372: aname => 'BANK_NAME',
2373: avalue => p_bank_name);
2374:

Line 2375: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2371: itemkey => l_itemkey,
2372: aname => 'BANK_NAME',
2373: avalue => p_bank_name);
2374:
2375: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2376: itemkey => l_itemkey,
2377: aname => 'BANK_ACCOUNT_NUMBER',
2378: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2379:

Line 2380: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2376: itemkey => l_itemkey,
2377: aname => 'BANK_ACCOUNT_NUMBER',
2378: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2379:
2380: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2381: itemkey => l_itemkey,
2382: aname => 'ENTERPRISE_NAME',
2383: avalue => l_enterprise_name);
2384:

Line 2385: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2381: itemkey => l_itemkey,
2382: aname => 'ENTERPRISE_NAME',
2383: avalue => l_enterprise_name);
2384:
2385: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2386: itemkey => l_itemkey,
2387: aname => 'FIRST_NAME',
2388: avalue => l_first_name);
2389:

Line 2390: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2386: itemkey => l_itemkey,
2387: aname => 'FIRST_NAME',
2388: avalue => l_first_name);
2389:
2390: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2391: itemkey => l_itemkey,
2392: aname => 'LAST_NAME',
2393: avalue => l_last_name);
2394: l_step := 5;

Line 2396: wf_engine.StartProcess(itemtype => l_itemtype,

2392: aname => 'LAST_NAME',
2393: avalue => l_last_name);
2394: l_step := 5;
2395:
2396: wf_engine.StartProcess(itemtype => l_itemtype,
2397: itemkey => l_itemkey );
2398:
2399: x_itemtype := l_itemtype;
2400: x_itemkey := l_itemkey;

Line 2445: wf_engine.CreateProcess(itemtype => l_itemtype,

2441: l_itemkey);
2442:
2443: l_step := 3;
2444:
2445: wf_engine.CreateProcess(itemtype => l_itemtype,
2446: itemkey => l_itemkey,
2447: process => l_process);
2448:
2449: l_step := 4;

Line 2450: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2446: itemkey => l_itemkey,
2447: process => l_process);
2448:
2449: l_step := 4;
2450: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2451: itemkey => l_itemkey,
2452: aname => 'URL',
2453: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2454:

Line 2455: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2451: itemkey => l_itemkey,
2452: aname => 'URL',
2453: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2454:
2455: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2456: itemkey => l_itemkey,
2457: aname => 'SUPPLIER_NAME',
2458: avalue => l_supplier_name);
2459:

Line 2460: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,

2456: itemkey => l_itemkey,
2457: aname => 'SUPPLIER_NAME',
2458: avalue => l_supplier_name);
2459:
2460: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2461: itemkey => l_itemkey,
2462: aname => 'VENDOR_ID',
2463: avalue => p_vendor_id);
2464:

Line 2465: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2461: itemkey => l_itemkey,
2462: aname => 'VENDOR_ID',
2463: avalue => p_vendor_id);
2464:
2465: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2466: itemkey => l_itemkey,
2467: aname => 'BANK_NAME',
2468: avalue => p_bank_name);
2469:

Line 2470: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2466: itemkey => l_itemkey,
2467: aname => 'BANK_NAME',
2468: avalue => p_bank_name);
2469:
2470: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2471: itemkey => l_itemkey,
2472: aname => 'BANK_ACCOUNT_NUMBER',
2473: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2474:

Line 2475: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2471: itemkey => l_itemkey,
2472: aname => 'BANK_ACCOUNT_NUMBER',
2473: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2474:
2475: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2476: itemkey => l_itemkey,
2477: aname => 'CURRENCY_CODE',
2478: avalue => p_currency_code);
2479:

Line 2480: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2476: itemkey => l_itemkey,
2477: aname => 'CURRENCY_CODE',
2478: avalue => p_currency_code);
2479:
2480: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2481: itemkey => l_itemkey,
2482: aname => 'BANK_ACCOUNT_NAME',
2483: avalue => p_bank_account_name);
2484:

Line 2485: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2481: itemkey => l_itemkey,
2482: aname => 'BANK_ACCOUNT_NAME',
2483: avalue => p_bank_account_name);
2484:
2485: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2486: itemkey => l_itemkey,
2487: aname => 'FIRST_NAME',
2488: avalue => l_first_name);
2489:

Line 2490: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2486: itemkey => l_itemkey,
2487: aname => 'FIRST_NAME',
2488: avalue => l_first_name);
2489:
2490: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2491: itemkey => l_itemkey,
2492: aname => 'LAST_NAME',
2493: avalue => l_last_name);
2494:

Line 2497: wf_engine.StartProcess(itemtype => l_itemtype,

2493: avalue => l_last_name);
2494:
2495: l_step := 5;
2496:
2497: wf_engine.StartProcess(itemtype => l_itemtype,
2498: itemkey => l_itemkey );
2499:
2500: x_itemtype := l_itemtype;
2501: x_itemkey := l_itemkey;

Line 2547: wf_engine.CreateProcess(itemtype => l_itemtype,

2543: l_itemkey);
2544:
2545: l_step := 3;
2546:
2547: wf_engine.CreateProcess(itemtype => l_itemtype,
2548: itemkey => l_itemkey,
2549: process => l_process);
2550:
2551: l_step := 4;

Line 2553: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2549: process => l_process);
2550:
2551: l_step := 4;
2552:
2553: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2554: itemkey => l_itemkey,
2555: aname => 'URL',
2556: avalue => pos_url_pkg.get_external_login_url);
2557:

Line 2558: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2554: itemkey => l_itemkey,
2555: aname => 'URL',
2556: avalue => pos_url_pkg.get_external_login_url);
2557:
2558: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2559: itemkey => l_itemkey,
2560: aname => 'SUPPLIER_NAME',
2561: avalue => l_supplier_name);
2562:

Line 2563: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,

2559: itemkey => l_itemkey,
2560: aname => 'SUPPLIER_NAME',
2561: avalue => l_supplier_name);
2562:
2563: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2564: itemkey => l_itemkey,
2565: aname => 'VENDOR_ID',
2566: avalue => p_vendor_id);
2567:

Line 2568: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2564: itemkey => l_itemkey,
2565: aname => 'VENDOR_ID',
2566: avalue => p_vendor_id);
2567:
2568: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2569: itemkey => l_itemkey,
2570: aname => 'BANK_NAME',
2571: avalue => p_bank_name);
2572:

Line 2573: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2569: itemkey => l_itemkey,
2570: aname => 'BANK_NAME',
2571: avalue => p_bank_name);
2572:
2573: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2574: itemkey => l_itemkey,
2575: aname => 'BANK_ACCOUNT_NUMBER',
2576: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2577:

Line 2578: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2574: itemkey => l_itemkey,
2575: aname => 'BANK_ACCOUNT_NUMBER',
2576: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2577:
2578: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2579: itemkey => l_itemkey,
2580: aname => 'CURRENCY_CODE',
2581: avalue => p_currency_code);
2582:

Line 2583: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2579: itemkey => l_itemkey,
2580: aname => 'CURRENCY_CODE',
2581: avalue => p_currency_code);
2582:
2583: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2584: itemkey => l_itemkey,
2585: aname => 'BANK_ACCOUNT_NAME',
2586: avalue => p_bank_account_name);
2587:

Line 2588: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2584: itemkey => l_itemkey,
2585: aname => 'BANK_ACCOUNT_NAME',
2586: avalue => p_bank_account_name);
2587:
2588: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2589: itemkey => l_itemkey,
2590: aname => 'FIRST_NAME',
2591: avalue => l_first_name);
2592:

Line 2593: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2589: itemkey => l_itemkey,
2590: aname => 'FIRST_NAME',
2591: avalue => l_first_name);
2592:
2593: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2594: itemkey => l_itemkey,
2595: aname => 'LAST_NAME',
2596: avalue => l_last_name);
2597:

Line 2600: wf_engine.StartProcess(itemtype => l_itemtype,

2596: avalue => l_last_name);
2597:
2598: l_step := 5;
2599:
2600: wf_engine.StartProcess(itemtype => l_itemtype,
2601: itemkey => l_itemkey );
2602:
2603: x_itemtype := l_itemtype;
2604: x_itemkey := l_itemkey;

Line 2647: wf_engine.CreateProcess(itemtype => l_itemtype,

2643: get_wf_item_key (l_process,To_char(p_vendor_id),l_itemkey);
2644:
2645: l_step := 3;
2646:
2647: wf_engine.CreateProcess(itemtype => l_itemtype,
2648: itemkey => l_itemkey,
2649: process => l_process);
2650:
2651: l_step := 4;

Line 2652: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,

2648: itemkey => l_itemkey,
2649: process => l_process);
2650:
2651: l_step := 4;
2652: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2653: itemkey => l_itemkey,
2654: aname => 'VENDOR_ID',
2655: avalue => p_vendor_id);
2656:

Line 2657: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2653: itemkey => l_itemkey,
2654: aname => 'VENDOR_ID',
2655: avalue => p_vendor_id);
2656:
2657: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2658: itemkey => l_itemkey,
2659: aname => 'BANK_NAME',
2660: avalue => p_bank_name);
2661:

Line 2662: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2658: itemkey => l_itemkey,
2659: aname => 'BANK_NAME',
2660: avalue => p_bank_name);
2661:
2662: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2663: itemkey => l_itemkey,
2664: aname => 'BANK_ACCOUNT_NUMBER',
2665: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2666:

Line 2667: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2663: itemkey => l_itemkey,
2664: aname => 'BANK_ACCOUNT_NUMBER',
2665: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2666:
2667: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2668: itemkey => l_itemkey,
2669: aname => 'BUYER_NOTE',
2670: avalue => 'PLSQL:POS_SPM_WF_PKG1.BANK_ACCT_BUYER_NOTE/'||p_note);
2671:

Line 2675: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2671:
2672: IF l_process = 'PACCOUNT_VERIFY' OR l_process = 'PACCOUNT_VERIFY_FAILED'
2673: THEN
2674: get_enterprise_name(l_enterprise_name);
2675: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2676: itemkey => l_itemkey,
2677: aname => 'ENTERPRISE_NAME',
2678: avalue => l_enterprise_name);
2679: END IF;

Line 2683: wf_engine.StartProcess(itemtype => l_itemtype,

2679: END IF;
2680:
2681: l_step := 5;
2682:
2683: wf_engine.StartProcess(itemtype => l_itemtype,
2684: itemkey => l_itemkey );
2685:
2686: x_itemtype := l_itemtype;
2687: x_itemkey := l_itemkey;

Line 2712: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');

2708: BEGIN
2709: IF ( funcmode = 'RUN' ) THEN
2710:
2711: l_vendor_id :=
2712: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2713:
2714: l_bank_account_number :=
2715: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2716:

Line 2715: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');

2711: l_vendor_id :=
2712: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2713:
2714: l_bank_account_number :=
2715: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2716:
2717: l_currency_code :=
2718: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2719:

Line 2718: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');

2714: l_bank_account_number :=
2715: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2716:
2717: l_currency_code :=
2718: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2719:
2720: l_bank_branch_id :=
2721: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'BANK_BRANCH_ID');
2722:

Line 2721: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'BANK_BRANCH_ID');

2717: l_currency_code :=
2718: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2719:
2720: l_bank_branch_id :=
2721: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'BANK_BRANCH_ID');
2722:
2723: l_bank_account_name :=
2724: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2725:

Line 2724: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');

2720: l_bank_branch_id :=
2721: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'BANK_BRANCH_ID');
2722:
2723: l_bank_account_name :=
2724: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2725:
2726: create_adhoc_role('PACCT_ADDR_'|| l_vendor_id, l_receiver);
2727:
2728: wf_engine.SetItemAttrText (itemtype => itemtype,

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

2724: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2725:
2726: create_adhoc_role('PACCT_ADDR_'|| l_vendor_id, l_receiver);
2727:
2728: wf_engine.SetItemAttrText (itemtype => itemtype,
2729: itemkey => itemkey,
2730: aname => 'RECEIVER',
2731: avalue => l_receiver);
2732:

Line 2795: wf_engine.CreateProcess(itemtype => l_itemtype,

2791: l_itemkey);
2792:
2793: l_step := 3;
2794:
2795: wf_engine.CreateProcess(itemtype => l_itemtype,
2796: itemkey => l_itemkey,
2797: process => l_process);
2798:
2799: l_step := 4;

Line 2801: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2797: process => l_process);
2798:
2799: l_step := 4;
2800:
2801: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2802: itemkey => l_itemkey,
2803: aname => 'URL',
2804: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2805:

Line 2806: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2802: itemkey => l_itemkey,
2803: aname => 'URL',
2804: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2805:
2806: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2807: itemkey => l_itemkey,
2808: aname => 'SUPPLIER_NAME',
2809: avalue => l_supplier_name);
2810:

Line 2811: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2807: itemkey => l_itemkey,
2808: aname => 'SUPPLIER_NAME',
2809: avalue => l_supplier_name);
2810:
2811: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2812: itemkey => l_itemkey,
2813: aname => 'ADDRESS_NAME',
2814: avalue => p_party_site_name);
2815:

Line 2816: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,

2812: itemkey => l_itemkey,
2813: aname => 'ADDRESS_NAME',
2814: avalue => p_party_site_name);
2815:
2816: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2817: itemkey => l_itemkey,
2818: aname => 'VENDOR_ID',
2819: avalue => p_vendor_id);
2820:

Line 2821: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2817: itemkey => l_itemkey,
2818: aname => 'VENDOR_ID',
2819: avalue => p_vendor_id);
2820:
2821: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2822: itemkey => l_itemkey,
2823: aname => 'BANK_NAME',
2824: avalue => p_bank_name);
2825:

Line 2826: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2822: itemkey => l_itemkey,
2823: aname => 'BANK_NAME',
2824: avalue => p_bank_name);
2825:
2826: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2827: itemkey => l_itemkey,
2828: aname => 'BANK_ACCOUNT_NUMBER',
2829: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2830:

Line 2831: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2827: itemkey => l_itemkey,
2828: aname => 'BANK_ACCOUNT_NUMBER',
2829: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2830:
2831: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2832: itemkey => l_itemkey,
2833: aname => 'CURRENCY_CODE',
2834: avalue => p_currency_code);
2835:

Line 2836: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2832: itemkey => l_itemkey,
2833: aname => 'CURRENCY_CODE',
2834: avalue => p_currency_code);
2835:
2836: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2837: itemkey => l_itemkey,
2838: aname => 'BANK_ACCOUNT_NAME',
2839: avalue => p_bank_account_name);
2840:

Line 2841: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2837: itemkey => l_itemkey,
2838: aname => 'BANK_ACCOUNT_NAME',
2839: avalue => p_bank_account_name);
2840:
2841: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2842: itemkey => l_itemkey,
2843: aname => 'FIRST_NAME',
2844: avalue => l_first_name);
2845:

Line 2846: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2842: itemkey => l_itemkey,
2843: aname => 'FIRST_NAME',
2844: avalue => l_first_name);
2845:
2846: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2847: itemkey => l_itemkey,
2848: aname => 'LAST_NAME',
2849: avalue => l_last_name);
2850:

Line 2853: wf_engine.StartProcess(itemtype => l_itemtype,

2849: avalue => l_last_name);
2850:
2851: l_step := 5;
2852:
2853: wf_engine.StartProcess(itemtype => l_itemtype,
2854: itemkey => l_itemkey );
2855:
2856: x_itemtype := l_itemtype;
2857: x_itemkey := l_itemkey;

Line 2986: wf_engine.CreateProcess(itemtype => l_itemtype,

2982: display_name => l_receiver,
2983: email_address => l_rec.email_address
2984: );
2985:
2986: wf_engine.CreateProcess(itemtype => l_itemtype,
2987: itemkey => l_itemkey,
2988: process => l_process
2989: );
2990:

Line 2991: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2987: itemkey => l_itemkey,
2988: process => l_process
2989: );
2990:
2991: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2992: itemkey => l_itemkey,
2993: aname => 'RECEIVER',
2994: avalue => l_receiver
2995: );

Line 2999: wf_engine.SetItemAttrText (itemtype => l_itemtype,

2995: );
2996:
2997: get_enterprise_name(l_enterprise_name);
2998:
2999: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3000: itemkey => l_itemkey,
3001: aname => 'ENTERPRISE_NAME',
3002: avalue => l_enterprise_name
3003: );

Line 3005: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3001: aname => 'ENTERPRISE_NAME',
3002: avalue => l_enterprise_name
3003: );
3004:
3005: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3006: itemkey => l_itemkey,
3007: aname => 'URL',
3008: avalue => get_supplier_reg_url(l_rec.reg_key)
3009: );

Line 3011: wf_engine.StartProcess (itemtype => l_itemtype,

3007: aname => 'URL',
3008: avalue => get_supplier_reg_url(l_rec.reg_key)
3009: );
3010:
3011: wf_engine.StartProcess (itemtype => l_itemtype,
3012: itemkey => l_itemkey
3013: );
3014:
3015: END send_supplier_invite_reg_ntf;

Line 3086: wf_engine.CreateProcess(itemtype => l_itemtype,

3082: );
3083: end if;
3084: end if;
3085:
3086: wf_engine.CreateProcess(itemtype => l_itemtype,
3087: itemkey => l_itemkey,
3088: process => l_process
3089: );
3090:

Line 3091: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3087: itemkey => l_itemkey,
3088: process => l_process
3089: );
3090:
3091: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3092: itemkey => l_itemkey,
3093: aname => 'RECEIVER',
3094: avalue => l_receiver
3095: );

Line 3099: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3095: );
3096:
3097: get_enterprise_name(l_enterprise_name);
3098:
3099: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3100: itemkey => l_itemkey,
3101: aname => 'ENTERPRISE_NAME',
3102: avalue => l_enterprise_name
3103: );

Line 3105: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3101: aname => 'ENTERPRISE_NAME',
3102: avalue => l_enterprise_name
3103: );
3104:
3105: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3106: itemkey => l_itemkey,
3107: aname => 'URL',
3108: avalue => get_supplier_reg_url(l_rec.reg_key)
3109: );

Line 3111: wf_engine.StartProcess (itemtype => l_itemtype,

3107: aname => 'URL',
3108: avalue => get_supplier_reg_url(l_rec.reg_key)
3109: );
3110:
3111: wf_engine.StartProcess (itemtype => l_itemtype,
3112: itemkey => l_itemkey
3113: );
3114:
3115: END send_supplier_reg_saved_ntf;

Line 3187: WF_ENGINE.CREATEPROCESS(ITEMTYPE => L_ITEMTYPE,

3183: -- GENERATING THE PROCESS KEY
3184: GET_WF_ITEM_KEY (l_process,To_char(p_supplier_reg_id),L_ITEMKEY);
3185:
3186: -- CREATE WORKFLOW PROCESS
3187: WF_ENGINE.CREATEPROCESS(ITEMTYPE => L_ITEMTYPE,
3188: ITEMKEY => L_ITEMKEY,
3189: PROCESS => L_PROCESS);
3190:
3191: WF_ENGINE.SETITEMATTRTEXT(ITEMTYPE => L_ITEMTYPE,

Line 3191: WF_ENGINE.SETITEMATTRTEXT(ITEMTYPE => L_ITEMTYPE,

3187: WF_ENGINE.CREATEPROCESS(ITEMTYPE => L_ITEMTYPE,
3188: ITEMKEY => L_ITEMKEY,
3189: PROCESS => L_PROCESS);
3190:
3191: WF_ENGINE.SETITEMATTRTEXT(ITEMTYPE => L_ITEMTYPE,
3192: ITEMKEY => L_ITEMKEY,
3193: ANAME => '#FROM_ROLE',
3194: AVALUE => L_FROM_NAME);
3195:

Line 3196: WF_ENGINE.SETITEMATTRTEXT (ITEMTYPE => L_ITEMTYPE,

3192: ITEMKEY => L_ITEMKEY,
3193: ANAME => '#FROM_ROLE',
3194: AVALUE => L_FROM_NAME);
3195:
3196: WF_ENGINE.SETITEMATTRTEXT (ITEMTYPE => L_ITEMTYPE,
3197: ITEMKEY => L_ITEMKEY,
3198: ANAME => 'NOTIF_RECEIVER_ROLE',
3199: AVALUE => l_receiver);
3200:

Line 3201: WF_ENGINE.SETITEMATTRTEXT (ITEMTYPE => L_ITEMTYPE,

3197: ITEMKEY => L_ITEMKEY,
3198: ANAME => 'NOTIF_RECEIVER_ROLE',
3199: AVALUE => l_receiver);
3200:
3201: WF_ENGINE.SETITEMATTRTEXT (ITEMTYPE => L_ITEMTYPE,
3202: ITEMKEY => L_ITEMKEY,
3203: ANAME => 'SUPPMSGSUB',
3204: AVALUE => p_msg_subject);
3205:

Line 3206: WF_ENGINE.SETITEMATTRTEXT (ITEMTYPE => L_ITEMTYPE,

3202: ITEMKEY => L_ITEMKEY,
3203: ANAME => 'SUPPMSGSUB',
3204: AVALUE => p_msg_subject);
3205:
3206: WF_ENGINE.SETITEMATTRTEXT (ITEMTYPE => L_ITEMTYPE,
3207: ITEMKEY => L_ITEMKEY,
3208: ANAME => 'SUPPMSGBD',
3209: AVALUE => p_msg_body);
3210: --Bug 10113987 unable to configure the notification messages in the oracle slm in html format

Line 3212: WF_ENGINE.SETITEMATTRTEXT (ITEMTYPE => L_ITEMTYPE,

3208: ANAME => 'SUPPMSGBD',
3209: AVALUE => p_msg_body);
3210: --Bug 10113987 unable to configure the notification messages in the oracle slm in html format
3211: --Use the new attribute URL
3212: WF_ENGINE.SETITEMATTRTEXT (ITEMTYPE => L_ITEMTYPE,
3213: ITEMKEY => L_ITEMKEY,
3214: --ANAME => 'SUPPADTMSG',
3215: ANAME => 'URL',
3216: AVALUE => get_supplier_reg_url(l_rec.reg_key));

Line 3218: WF_ENGINE.STARTPROCESS(ITEMTYPE => L_ITEMTYPE,

3214: --ANAME => 'SUPPADTMSG',
3215: ANAME => 'URL',
3216: AVALUE => get_supplier_reg_url(l_rec.reg_key));
3217:
3218: WF_ENGINE.STARTPROCESS(ITEMTYPE => L_ITEMTYPE,
3219: ITEMKEY => L_ITEMKEY );
3220:
3221: COMMIT;
3222:

Line 3276: wf_engine.CreateProcess(itemtype => l_itemtype,

3272: -- create workflow process
3273: get_wf_item_type (l_itemtype);
3274: get_wf_item_key (l_process, p_vendor_id, l_itemkey);
3275:
3276: wf_engine.CreateProcess(itemtype => l_itemtype,
3277: itemkey => l_itemkey,
3278: process => l_process);
3279: l_step := 6;
3280: wf_engine.SetItemAttrText (itemtype => l_itemtype,

Line 3280: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3276: wf_engine.CreateProcess(itemtype => l_itemtype,
3277: itemkey => l_itemkey,
3278: process => l_process);
3279: l_step := 6;
3280: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3281: itemkey => l_itemkey,
3282: aname => 'RECEIVER',
3283: avalue => l_receiver);
3284:

Line 3285: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3281: itemkey => l_itemkey,
3282: aname => 'RECEIVER',
3283: avalue => l_receiver);
3284:
3285: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3286: itemkey => l_itemkey,
3287: aname => 'SUPPLIER_NAME',
3288: avalue => l_supplier_name);
3289:

Line 3290: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3286: itemkey => l_itemkey,
3287: aname => 'SUPPLIER_NAME',
3288: avalue => l_supplier_name);
3289:
3290: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3291: itemkey => l_itemkey,
3292: aname => 'VENDOR_ID',
3293: avalue => p_vendor_id);
3294:

Line 3295: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3291: itemkey => l_itemkey,
3292: aname => 'VENDOR_ID',
3293: avalue => p_vendor_id);
3294:
3295: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3296: itemkey => l_itemkey,
3297: aname => 'URL',
3298: avalue => pos_url_pkg.get_dest_page_url('POS_SBD_BUYER_MAIN', 'BUYER'));
3299: l_step := 7;

Line 3303: wf_engine.StartProcess(itemtype => l_itemtype,

3299: l_step := 7;
3300: setup_actioner_private(l_itemtype, l_itemkey);
3301:
3302: l_step := 8;
3303: wf_engine.StartProcess(itemtype => l_itemtype,
3304: itemkey => l_itemkey );
3305: l_step := 9;
3306: x_itemtype := l_itemtype;
3307: x_itemkey := l_itemkey;

Line 3345: wf_engine.CreateProcess(itemtype => l_itemtype,

3341: To_char(p_supplier_reg_id),
3342: l_itemkey);
3343:
3344: l_step := 3;
3345: wf_engine.CreateProcess(itemtype => l_itemtype,
3346: itemkey => l_itemkey,
3347: process => l_process);
3348:
3349: l_step := 4;

Line 3350: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3346: itemkey => l_itemkey,
3347: process => l_process);
3348:
3349: l_step := 4;
3350: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3351: itemkey => l_itemkey,
3352: aname => 'RECEIVER',
3353: avalue => p_username);
3354:

Line 3355: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3351: itemkey => l_itemkey,
3352: aname => 'RECEIVER',
3353: avalue => p_username);
3354:
3355: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3356: itemkey => l_itemkey,
3357: aname => 'ENTERPRISE_NAME',
3358: avalue => l_enterprise_name);
3359:

Line 3360: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3356: itemkey => l_itemkey,
3357: aname => 'ENTERPRISE_NAME',
3358: avalue => l_enterprise_name);
3359:
3360: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3361: itemkey => l_itemkey,
3362: aname => 'USERNAME',
3363: avalue => p_username);
3364:

Line 3365: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3361: itemkey => l_itemkey,
3362: aname => 'USERNAME',
3363: avalue => p_username);
3364:
3365: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3366: itemkey => l_itemkey,
3367: aname => 'URL',
3368: avalue => pos_url_pkg.get_external_login_url);
3369:

Line 3370: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3366: itemkey => l_itemkey,
3367: aname => 'URL',
3368: avalue => pos_url_pkg.get_external_login_url);
3369:
3370: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3371: itemkey => l_itemkey,
3372: aname => 'ADMIN_EMAIL',
3373: avalue => get_admin_email);
3374:

Line 3375: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3371: itemkey => l_itemkey,
3372: aname => 'ADMIN_EMAIL',
3373: avalue => get_admin_email);
3374:
3375: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3376: itemkey => l_itemkey,
3377: aname => 'BUYER_NOTE',
3378: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
3379:

Line 3384: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3380: --
3381: -- Begin Supplier Hub: OSN Integration
3382: -- See FUNCTION get_osn_message for more info.
3383: --
3384: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3385: itemkey => l_itemkey,
3386: aname => 'OSN_MESSAGE',
3387: avalue => get_osn_message);
3388: --

Line 3393: wf_engine.StartProcess(itemtype => l_itemtype,

3389: -- End Supplier Hub: OSN Integration
3390: --
3391:
3392: l_step := 5;
3393: wf_engine.StartProcess(itemtype => l_itemtype,
3394: itemkey => l_itemkey );
3395: l_step := 6;
3396: x_itemtype := l_itemtype;
3397: x_itemkey := l_itemkey;

Line 3435: wf_engine.CreateProcess(itemtype => l_itemtype,

3431: To_char(p_supplier_reg_id) || '_' || p_username,
3432: l_itemkey);
3433:
3434: l_step := 4;
3435: wf_engine.CreateProcess(itemtype => l_itemtype,
3436: itemkey => l_itemkey,
3437: process => l_process);
3438:
3439: l_step := 5;

Line 3440: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3436: itemkey => l_itemkey,
3437: process => l_process);
3438:
3439: l_step := 5;
3440: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3441: itemkey => l_itemkey,
3442: aname => 'RECEIVER',
3443: avalue => p_username);
3444:

Line 3446: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3442: aname => 'RECEIVER',
3443: avalue => p_username);
3444:
3445: l_step := 6;
3446: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3447: itemkey => l_itemkey,
3448: aname => 'ENTERPRISE_NAME',
3449: avalue => l_enterprise_name);
3450:

Line 3452: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3448: aname => 'ENTERPRISE_NAME',
3449: avalue => l_enterprise_name);
3450:
3451: l_step := 7;
3452: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3453: itemkey => l_itemkey,
3454: aname => 'USERNAME',
3455: avalue => p_username);
3456:

Line 3460: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3456:
3457: l_step := 8;
3458:
3459: l_step := 9;
3460: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3461: itemkey => l_itemkey,
3462: aname => 'URL',
3463: avalue => pos_url_pkg.get_external_login_url);
3464:

Line 3466: wf_engine.SetItemAttrText (itemtype => l_itemtype,

3462: aname => 'URL',
3463: avalue => pos_url_pkg.get_external_login_url);
3464:
3465: l_step := 10;
3466: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3467: itemkey => l_itemkey,
3468: aname => 'ADMIN_EMAIL',
3469: avalue => get_admin_email);
3470:

Line 3473: wf_engine.StartProcess(itemtype => l_itemtype,

3469: avalue => get_admin_email);
3470:
3471: l_step := 11;
3472:
3473: wf_engine.StartProcess(itemtype => l_itemtype,
3474: itemkey => l_itemkey );
3475: x_itemtype := l_itemtype;
3476: x_itemkey := l_itemkey;
3477:

Line 3653: wf_engine.CreateProcess(itemtype => l_itemtype,

3649: IF ul > 0 THEN
3650:
3651: l_itemkey := l_itemtype||'_'||l_process||'_'||to_char(sysdate, 'JSSSSS')||'_'||'VENDOR_ID'||'_'||to_char(l_vendor_id);
3652:
3653: wf_engine.CreateProcess(itemtype => l_itemtype,
3654: itemkey => l_itemkey,
3655: process => l_process
3656: );
3657:

Line 3660: wf_engine.SetItemAttrText(itemtype => l_itemtype,

3656: );
3657:
3658: get_enterprise_name(l_enterprise_name);
3659:
3660: wf_engine.SetItemAttrText(itemtype => l_itemtype,
3661: itemkey => l_itemkey,
3662: aname => 'ENTERPRISE_NAME',
3663: avalue => l_enterprise_name
3664: );

Line 3666: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,

3662: aname => 'ENTERPRISE_NAME',
3663: avalue => l_enterprise_name
3664: );
3665:
3666: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
3667: itemkey => l_itemkey,
3668: aname => 'VENDOR_ID',
3669: avalue => l_vendor_id
3670: );

Line 3683: wf_engine.SetItemAttrText(itemtype => l_itemtype,

3679: ELSE
3680: l_due_date := SYSDATE + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_REMIND_DAYS'));
3681: END IF;
3682:
3683: wf_engine.SetItemAttrText(itemtype => l_itemtype,
3684: itemkey => l_itemkey,
3685: aname => 'BC_RECERT_DUE_DATE',
3686: avalue => l_due_date
3687: );

Line 3709: wf_engine.SetItemAttrText( itemtype => l_itemtype,

3705: role_users => l_users,
3706: expiration_date => l_expiration_date
3707: );
3708:
3709: wf_engine.SetItemAttrText( itemtype => l_itemtype,
3710: itemkey => l_itemkey,
3711: aname => 'BUS_CLASS_RECERT_RECEIVERS',
3712: avalue => l_role_name
3713: );

Line 3715: wf_engine.StartProcess(itemtype => l_itemtype,

3711: aname => 'BUS_CLASS_RECERT_RECEIVERS',
3712: avalue => l_role_name
3713: );
3714:
3715: wf_engine.StartProcess(itemtype => l_itemtype,
3716: itemkey => l_itemkey
3717: );
3718:
3719: END IF;

Line 3845: l_enterprisename := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3841: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_item_key ' || l_itemkey);
3842: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_supplier_reg_id ' || l_supplier_reg_id);
3843: END IF;
3844:
3845: l_enterprisename := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3846: itemkey => l_itemkey,
3847: aname => 'ENTERPRISE_NAME');
3848:
3849: l_username := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3849: l_username := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3845: l_enterprisename := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3846: itemkey => l_itemkey,
3847: aname => 'ENTERPRISE_NAME');
3848:
3849: l_username := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3850: itemkey => l_itemkey,
3851: aname => 'USERNAME');
3852:
3853: l_password := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3853: l_password := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3849: l_username := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3850: itemkey => l_itemkey,
3851: aname => 'USERNAME');
3852:
3853: l_password := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3854: itemkey => l_itemkey,
3855: aname => 'PASSWORD');
3856:
3857: l_url := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3857: l_url := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3853: l_password := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3854: itemkey => l_itemkey,
3855: aname => 'PASSWORD');
3856:
3857: l_url := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3858: itemkey => l_itemkey,
3859: aname => 'URL');
3860:
3861: l_adminemail := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3861: l_adminemail := wf_engine.GetItemAttrText (itemtype => l_itemtype,

3857: l_url := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3858: itemkey => l_itemkey,
3859: aname => 'URL');
3860:
3861: l_adminemail := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3862: itemkey => l_itemkey,
3863: aname => 'ADMIN_EMAIL');
3864:
3865: