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 284: wf_engine.SetItemAttrText (itemtype => itemtype,

280: BEGIN
281: get_current_user_name(l_first_name, l_last_name);
282: get_current_user_company_name(l_company_name);
283:
284: wf_engine.SetItemAttrText (itemtype => itemtype,
285: itemkey => itemkey,
286: aname => 'COMPANY_NAME',
287: avalue => l_company_name);
288:

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

286: aname => 'COMPANY_NAME',
287: avalue => l_company_name);
288:
289:
290: wf_engine.SetItemAttrText (itemtype => itemtype,
291: itemkey => itemkey,
292: aname => 'FIRST_NAME',
293: avalue => l_first_name);
294:

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

291: itemkey => itemkey,
292: aname => 'FIRST_NAME',
293: avalue => l_first_name);
294:
295: wf_engine.SetItemAttrText (itemtype => itemtype,
296: itemkey => itemkey,
297: aname => 'LAST_NAME',
298: avalue => l_last_name);
299:

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

389: get_wf_item_key (l_process,
390: To_char(p_vendor_id) || '_' || p_address_request_id,
391: l_itemkey);
392:
393: wf_engine.CreateProcess(itemtype => l_itemtype,
394: itemkey => l_itemkey,
395: process => l_process);
396: l_step := 6;
397: wf_engine.SetItemAttrText (itemtype => l_itemtype,

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

393: wf_engine.CreateProcess(itemtype => l_itemtype,
394: itemkey => l_itemkey,
395: process => l_process);
396: l_step := 6;
397: wf_engine.SetItemAttrText (itemtype => l_itemtype,
398: itemkey => l_itemkey,
399: aname => 'RECEIVER',
400: avalue => l_receiver);
401:

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

398: itemkey => l_itemkey,
399: aname => 'RECEIVER',
400: avalue => l_receiver);
401:
402: wf_engine.SetItemAttrText (itemtype => l_itemtype,
403: itemkey => l_itemkey,
404: aname => 'SUPPLIER_NAME',
405: avalue => l_supplier_name);
406:

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

403: itemkey => l_itemkey,
404: aname => 'SUPPLIER_NAME',
405: avalue => l_supplier_name);
406:
407: wf_engine.SetItemAttrText (itemtype => l_itemtype,
408: itemkey => l_itemkey,
409: aname => 'ADDRESS_NAME',
410: avalue => l_address_name);
411: wf_engine.SetItemAttrText (itemtype => l_itemtype,

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

407: wf_engine.SetItemAttrText (itemtype => l_itemtype,
408: itemkey => l_itemkey,
409: aname => 'ADDRESS_NAME',
410: avalue => l_address_name);
411: wf_engine.SetItemAttrText (itemtype => l_itemtype,
412: itemkey => l_itemkey,
413: aname => 'VENDOR_ID',
414: avalue => p_vendor_id);
415:

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

412: itemkey => l_itemkey,
413: aname => 'VENDOR_ID',
414: avalue => p_vendor_id);
415:
416: wf_engine.SetItemAttrText (itemtype => l_itemtype,
417: itemkey => l_itemkey,
418: aname => 'URL',
419: avalue => pos_url_pkg.get_dest_page_url('POS_HT_SP_B_ADDR_BK', 'BUYER'));
420: l_step := 7;

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

420: l_step := 7;
421: setup_actioner_private(l_itemtype, l_itemkey);
422:
423: l_step := 8;
424: wf_engine.StartProcess(itemtype => l_itemtype,
425: itemkey => l_itemkey );
426: l_step := 9;
427: x_itemtype := l_itemtype;
428: x_itemkey := l_itemkey;

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

573: To_char(p_vendor_id) || '_' || p_bus_class_request_id,
574: l_itemkey);
575:
576: l_step := 7;
577: wf_engine.CreateProcess(itemtype => l_itemtype,
578: itemkey => l_itemkey,
579: process => p_process);
580: l_step := 8;
581:

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

578: itemkey => l_itemkey,
579: process => p_process);
580: l_step := 8;
581:
582: wf_engine.SetItemAttrText (itemtype => l_itemtype,
583: itemkey => l_itemkey,
584: aname => 'RECEIVER',
585: avalue => l_receiver);
586:

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

583: itemkey => l_itemkey,
584: aname => 'RECEIVER',
585: avalue => l_receiver);
586:
587: wf_engine.SetItemAttrText (itemtype => l_itemtype,
588: itemkey => l_itemkey,
589: aname => 'SUPPLIER_NAME',
590: avalue => l_supplier_name);
591:

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

588: itemkey => l_itemkey,
589: aname => 'SUPPLIER_NAME',
590: avalue => l_supplier_name);
591:
592: wf_engine.SetItemAttrText (itemtype => l_itemtype,
593: itemkey => l_itemkey,
594: aname => 'BUS_CLASS_NAME',
595: avalue => l_bus_class_name);
596:

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

593: itemkey => l_itemkey,
594: aname => 'BUS_CLASS_NAME',
595: avalue => l_bus_class_name);
596:
597: wf_engine.SetItemAttrText (itemtype => l_itemtype,
598: itemkey => l_itemkey,
599: aname => 'VENDOR_ID',
600: avalue => p_vendor_id);
601:

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

598: itemkey => l_itemkey,
599: aname => 'VENDOR_ID',
600: avalue => p_vendor_id);
601:
602: wf_engine.SetItemAttrText (itemtype => l_itemtype,
603: itemkey => l_itemkey,
604: aname => 'URL',
605: avalue => pos_url_pkg.get_dest_page_url ('POS_HT_SP_B_BUS_CLSS', 'BUYER'));
606: l_step := 9;

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

608: setup_actioner_private(l_itemtype, l_itemkey);
609:
610: l_step := 10;
611:
612: wf_engine.StartProcess(itemtype => l_itemtype,
613: itemkey => l_itemkey );
614:
615: l_step := 11;
616: x_itemtype := l_itemtype;

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

764: To_char(p_vendor_id) || '_' || p_contact_request_id,
765: l_itemkey);
766:
767: l_step := 7;
768: wf_engine.CreateProcess(itemtype => l_itemtype,
769: itemkey => l_itemkey,
770: process => l_process);
771:
772: l_step := 8;

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

769: itemkey => l_itemkey,
770: process => l_process);
771:
772: l_step := 8;
773: wf_engine.SetItemAttrText (itemtype => l_itemtype,
774: itemkey => l_itemkey,
775: aname => 'RECEIVER',
776: avalue => l_receiver);
777:

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

774: itemkey => l_itemkey,
775: aname => 'RECEIVER',
776: avalue => l_receiver);
777:
778: wf_engine.SetItemAttrText (itemtype => l_itemtype,
779: itemkey => l_itemkey,
780: aname => 'SUPPLIER_NAME',
781: avalue => l_supplier_name);
782:

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

779: itemkey => l_itemkey,
780: aname => 'SUPPLIER_NAME',
781: avalue => l_supplier_name);
782:
783: wf_engine.SetItemAttrText (itemtype => l_itemtype,
784: itemkey => l_itemkey,
785: aname => 'CONTACT_NAME',
786: avalue => l_contact_name);
787:

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

784: itemkey => l_itemkey,
785: aname => 'CONTACT_NAME',
786: avalue => l_contact_name);
787:
788: wf_engine.SetItemAttrText (itemtype => l_itemtype,
789: itemkey => l_itemkey,
790: aname => 'VENDOR_ID',
791: avalue => p_vendor_id);
792:

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

789: itemkey => l_itemkey,
790: aname => 'VENDOR_ID',
791: avalue => p_vendor_id);
792:
793: wf_engine.SetItemAttrText (itemtype => l_itemtype,
794: itemkey => l_itemkey,
795: aname => 'URL',
796: avalue => pos_url_pkg.get_dest_page_url ('POS_HT_SP_B_CONT_DIR', 'BUYER'));
797:

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

798: l_step := 9;
799: setup_actioner_private(l_itemtype, l_itemkey);
800:
801: l_step := 10;
802: wf_engine.StartProcess(itemtype => l_itemtype,
803: itemkey => l_itemkey );
804:
805: l_step := 11;
806: x_itemtype := l_itemtype;

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

907: To_char(p_vendor_id) || '_' || p_contact_party_id,
908: l_itemkey);
909:
910: l_step := 5;
911: wf_engine.CreateProcess(itemtype => l_itemtype,
912: itemkey => l_itemkey,
913: process => l_process);
914:
915: l_step := 6;

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

912: itemkey => l_itemkey,
913: process => l_process);
914:
915: l_step := 6;
916: wf_engine.SetItemAttrText (itemtype => l_itemtype,
917: itemkey => l_itemkey,
918: aname => 'RECEIVER',
919: avalue => l_receiver);
920:

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

917: itemkey => l_itemkey,
918: aname => 'RECEIVER',
919: avalue => l_receiver);
920:
921: wf_engine.SetItemAttrText (itemtype => l_itemtype,
922: itemkey => l_itemkey,
923: aname => 'SUPPLIER_NAME',
924: avalue => l_supplier_name);
925:

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

922: itemkey => l_itemkey,
923: aname => 'SUPPLIER_NAME',
924: avalue => l_supplier_name);
925:
926: wf_engine.SetItemAttrText (itemtype => l_itemtype,
927: itemkey => l_itemkey,
928: aname => 'CONTACT_NAME',
929: avalue => l_contact_name);
930:

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

927: itemkey => l_itemkey,
928: aname => 'CONTACT_NAME',
929: avalue => l_contact_name);
930:
931: wf_engine.SetItemAttrText (itemtype => l_itemtype,
932: itemkey => l_itemkey,
933: aname => 'VENDOR_ID',
934: avalue => p_vendor_id);
935:

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

932: itemkey => l_itemkey,
933: aname => 'VENDOR_ID',
934: avalue => p_vendor_id);
935:
936: wf_engine.SetItemAttrText (itemtype => l_itemtype,
937: itemkey => l_itemkey,
938: aname => 'URL',
939: avalue => pos_url_pkg.get_dest_page_url ('POS_HT_SP_B_CONT_DIR', 'BUYER'));
940: l_step := 7;

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

940: l_step := 7;
941: setup_actioner_private(l_itemtype, l_itemkey);
942: l_step := 8;
943:
944: wf_engine.StartProcess(itemtype => l_itemtype,
945: itemkey => l_itemkey );
946:
947: l_step := 9;
948: x_itemtype := l_itemtype;

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

1046: To_char(p_vendor_id),
1047: l_itemkey);
1048:
1049: l_step := 7;
1050: wf_engine.CreateProcess(itemtype => l_itemtype,
1051: itemkey => l_itemkey,
1052: process => p_process);
1053:
1054: l_step := 8;

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

1051: itemkey => l_itemkey,
1052: process => p_process);
1053:
1054: l_step := 8;
1055: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1056: itemkey => l_itemkey,
1057: aname => 'RECEIVER',
1058: avalue => l_receiver);
1059:

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

1056: itemkey => l_itemkey,
1057: aname => 'RECEIVER',
1058: avalue => l_receiver);
1059:
1060: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1061: itemkey => l_itemkey,
1062: aname => 'SUPPLIER_NAME',
1063: avalue => l_supplier_name);
1064:

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

1061: itemkey => l_itemkey,
1062: aname => 'SUPPLIER_NAME',
1063: avalue => l_supplier_name);
1064:
1065: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1066: itemkey => l_itemkey,
1067: aname => 'VENDOR_ID',
1068: avalue => p_vendor_id);
1069:

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

1066: itemkey => l_itemkey,
1067: aname => 'VENDOR_ID',
1068: avalue => p_vendor_id);
1069:
1070: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1071: itemkey => l_itemkey,
1072: aname => 'URL',
1073: avalue => pos_url_pkg.get_dest_page_url ('POS_HT_SP_B_PS', 'BUYER'));
1074:

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

1075: l_step := 9;
1076: setup_actioner_private(l_itemtype, l_itemkey);
1077:
1078: l_step := 10;
1079: wf_engine.StartProcess(itemtype => l_itemtype,
1080: itemkey => l_itemkey );
1081:
1082: l_step := 11;
1083: x_itemtype := l_itemtype;

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

1334: To_char(p_vendor_id) || '_' || p_sup_reg_email,
1335: l_itemkey);
1336:
1337: l_step := 5;
1338: wf_engine.CreateProcess(itemtype => l_itemtype,
1339: itemkey => l_itemkey,
1340: process => l_process);
1341:
1342: l_step := 6;

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

1339: itemkey => l_itemkey,
1340: process => l_process);
1341:
1342: l_step := 6;
1343: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1344: itemkey => l_itemkey,
1345: aname => 'RECEIVER',
1346: avalue => l_receiver);
1347:

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

1344: itemkey => l_itemkey,
1345: aname => 'RECEIVER',
1346: avalue => l_receiver);
1347:
1348: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1349: itemkey => l_itemkey,
1350: aname => 'SUPPLIER_NAME',
1351: avalue => l_supplier_name);
1352:

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

1349: itemkey => l_itemkey,
1350: aname => 'SUPPLIER_NAME',
1351: avalue => l_supplier_name);
1352:
1353: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1354: itemkey => l_itemkey,
1355: aname => 'ENTERPRISE_NAME',
1356: avalue => l_enterprise_name);
1357:

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

1354: itemkey => l_itemkey,
1355: aname => 'ENTERPRISE_NAME',
1356: avalue => l_enterprise_name);
1357:
1358: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1359: itemkey => l_itemkey,
1360: aname => 'FIRST_NAME',
1361: avalue => p_first_name);
1362:

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

1359: itemkey => l_itemkey,
1360: aname => 'FIRST_NAME',
1361: avalue => p_first_name);
1362:
1363: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1364: itemkey => l_itemkey,
1365: aname => 'LAST_NAME',
1366: avalue => p_last_name);
1367:

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

1364: itemkey => l_itemkey,
1365: aname => 'LAST_NAME',
1366: avalue => p_last_name);
1367:
1368: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1369: itemkey => l_itemkey,
1370: aname => 'SUP_REG_EMAIL',
1371: avalue => p_sup_reg_email);
1372:

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

1370: aname => 'SUP_REG_EMAIL',
1371: avalue => p_sup_reg_email);
1372:
1373: l_step := 7;
1374: wf_engine.StartProcess(itemtype => l_itemtype,
1375: itemkey => l_itemkey );
1376:
1377: l_step := 8;
1378: x_itemtype := l_itemtype;

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

1478: To_char(p_supplier_reg_id),
1479: l_itemkey);
1480:
1481: l_step := 8;
1482: wf_engine.CreateProcess(itemtype => l_itemtype,
1483: itemkey => l_itemkey,
1484: process => l_process);
1485:
1486: l_step := 9;

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

1483: itemkey => l_itemkey,
1484: process => l_process);
1485:
1486: l_step := 9;
1487: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1488: itemkey => l_itemkey,
1489: aname => 'RECEIVER',
1490: avalue => l_receiver);
1491:

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

1488: itemkey => l_itemkey,
1489: aname => 'RECEIVER',
1490: avalue => l_receiver);
1491:
1492: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1493: itemkey => l_itemkey,
1494: aname => 'SUPPLIER_NAME',
1495: avalue => l_supplier_name);
1496:

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

1493: itemkey => l_itemkey,
1494: aname => 'SUPPLIER_NAME',
1495: avalue => l_supplier_name);
1496:
1497: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1498: itemkey => l_itemkey,
1499: aname => 'URL',
1500: avalue => pos_url_pkg.get_internal_login_url);
1501:

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

1499: aname => 'URL',
1500: avalue => pos_url_pkg.get_internal_login_url);
1501:
1502: l_step := 10;
1503: wf_engine.StartProcess(itemtype => l_itemtype,
1504: itemkey => l_itemkey );
1505:
1506: l_step := 11;
1507: x_itemtype := l_itemtype;

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

1588: To_char(p_supplier_reg_id),
1589: l_itemkey);
1590:
1591: l_step := 3;
1592: wf_engine.CreateProcess(itemtype => l_itemtype,
1593: itemkey => l_itemkey,
1594: process => l_process);
1595:
1596: l_step := 4;

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

1593: itemkey => l_itemkey,
1594: process => l_process);
1595:
1596: l_step := 4;
1597: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1598: itemkey => l_itemkey,
1599: aname => 'RECEIVER',
1600: avalue => p_username);
1601:

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

1598: itemkey => l_itemkey,
1599: aname => 'RECEIVER',
1600: avalue => p_username);
1601:
1602: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1603: itemkey => l_itemkey,
1604: aname => 'ENTERPRISE_NAME',
1605: avalue => l_enterprise_name);
1606:

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

1603: itemkey => l_itemkey,
1604: aname => 'ENTERPRISE_NAME',
1605: avalue => l_enterprise_name);
1606:
1607: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1608: itemkey => l_itemkey,
1609: aname => 'USERNAME',
1610: avalue => p_username);
1611:

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

1608: itemkey => l_itemkey,
1609: aname => 'USERNAME',
1610: avalue => p_username);
1611:
1612: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1613: itemkey => l_itemkey,
1614: aname => 'PASSWORD',
1615: avalue => p_password);
1616:

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

1613: itemkey => l_itemkey,
1614: aname => 'PASSWORD',
1615: avalue => p_password);
1616:
1617: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1618: itemkey => l_itemkey,
1619: aname => 'URL',
1620: avalue => pos_url_pkg.get_external_login_url);
1621:

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

1618: itemkey => l_itemkey,
1619: aname => 'URL',
1620: avalue => pos_url_pkg.get_external_login_url);
1621:
1622: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1623: itemkey => l_itemkey,
1624: aname => 'ADMIN_EMAIL',
1625: avalue => get_admin_email);
1626:

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

1623: itemkey => l_itemkey,
1624: aname => 'ADMIN_EMAIL',
1625: avalue => get_admin_email);
1626:
1627: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1628: itemkey => l_itemkey,
1629: aname => 'BUYER_NOTE',
1630: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
1631: l_step := 5;

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

1628: itemkey => l_itemkey,
1629: aname => 'BUYER_NOTE',
1630: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
1631: l_step := 5;
1632: wf_engine.StartProcess(itemtype => l_itemtype,
1633: itemkey => l_itemkey );
1634: l_step := 6;
1635: x_itemtype := l_itemtype;
1636: x_itemkey := l_itemkey;

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

1673: To_char(p_supplier_reg_id) || '_' || p_username,
1674: l_itemkey);
1675:
1676: l_step := 4;
1677: wf_engine.CreateProcess(itemtype => l_itemtype,
1678: itemkey => l_itemkey,
1679: process => l_process);
1680:
1681: l_step := 5;

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

1678: itemkey => l_itemkey,
1679: process => l_process);
1680:
1681: l_step := 5;
1682: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1683: itemkey => l_itemkey,
1684: aname => 'RECEIVER',
1685: avalue => p_username);
1686:

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

1684: aname => 'RECEIVER',
1685: avalue => p_username);
1686:
1687: l_step := 6;
1688: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1689: itemkey => l_itemkey,
1690: aname => 'ENTERPRISE_NAME',
1691: avalue => l_enterprise_name);
1692:

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

1690: aname => 'ENTERPRISE_NAME',
1691: avalue => l_enterprise_name);
1692:
1693: l_step := 7;
1694: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1695: itemkey => l_itemkey,
1696: aname => 'USERNAME',
1697: avalue => p_username);
1698:

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

1696: aname => 'USERNAME',
1697: avalue => p_username);
1698:
1699: l_step := 8;
1700: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1701: itemkey => l_itemkey,
1702: aname => 'PASSWORD',
1703: avalue => p_password);
1704:

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

1702: aname => 'PASSWORD',
1703: avalue => p_password);
1704:
1705: l_step := 9;
1706: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1707: itemkey => l_itemkey,
1708: aname => 'URL',
1709: avalue => pos_url_pkg.get_external_login_url);
1710:

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

1708: aname => 'URL',
1709: avalue => pos_url_pkg.get_external_login_url);
1710:
1711: l_step := 10;
1712: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1713: itemkey => l_itemkey,
1714: aname => 'ADMIN_EMAIL',
1715: avalue => get_admin_email);
1716:

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

1715: avalue => get_admin_email);
1716:
1717: l_step := 11;
1718:
1719: wf_engine.StartProcess(itemtype => l_itemtype,
1720: itemkey => l_itemkey );
1721: x_itemtype := l_itemtype;
1722: x_itemkey := l_itemkey;
1723:

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

1784: To_char(p_supplier_reg_id),
1785: l_itemkey);
1786:
1787: l_step := 8;
1788: wf_engine.CreateProcess(itemtype => l_itemtype,
1789: itemkey => l_itemkey,
1790: process => l_process);
1791:
1792: l_step := 9;

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

1789: itemkey => l_itemkey,
1790: process => l_process);
1791:
1792: l_step := 9;
1793: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1794: itemkey => l_itemkey,
1795: aname => 'RECEIVER',
1796: avalue => l_receiver);
1797:

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

1794: itemkey => l_itemkey,
1795: aname => 'RECEIVER',
1796: avalue => l_receiver);
1797:
1798: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1799: itemkey => l_itemkey,
1800: aname => 'ENTERPRISE_NAME',
1801: avalue => l_enterprise_name);
1802:

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

1799: itemkey => l_itemkey,
1800: aname => 'ENTERPRISE_NAME',
1801: avalue => l_enterprise_name);
1802:
1803: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1804: itemkey => l_itemkey,
1805: aname => 'BUYER_NOTE',
1806: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
1807:

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

1805: aname => 'BUYER_NOTE',
1806: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
1807:
1808: l_step := 10;
1809: wf_engine.StartProcess(itemtype => l_itemtype,
1810: itemkey => l_itemkey );
1811:
1812: l_step := 11;
1813: x_itemtype := l_itemtype;

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

1956: BEGIN
1957:
1958: IF ( funcmode = 'RUN' ) THEN
1959: l_vendor_id :=
1960: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
1961: create_adhoc_role('PACCOUNT_ACTION_' || l_vendor_id, l_receiver);
1962:
1963: wf_engine.SetItemAttrText (itemtype => itemtype,
1964: itemkey => itemkey,

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

1959: l_vendor_id :=
1960: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
1961: create_adhoc_role('PACCOUNT_ACTION_' || l_vendor_id, l_receiver);
1962:
1963: wf_engine.SetItemAttrText (itemtype => itemtype,
1964: itemkey => itemkey,
1965: aname => 'RECEIVER',
1966: avalue => l_receiver);
1967:

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

1997: BEGIN
1998: IF ( funcmode = 'RUN' ) THEN
1999:
2000: l_vendor_id :=
2001: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2002:
2003: l_bank_account_number :=
2004: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2005:

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

2000: l_vendor_id :=
2001: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2002:
2003: l_bank_account_number :=
2004: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2005:
2006: l_currency_code :=
2007: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2008:

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

2003: l_bank_account_number :=
2004: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2005:
2006: l_currency_code :=
2007: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2008:
2009: l_bank_account_name :=
2010: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2011:

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

2006: l_currency_code :=
2007: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2008:
2009: l_bank_account_name :=
2010: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2011:
2012: create_adhoc_role('PACCOUNT_UPDATED_'||l_bank_account_number, l_receiver);
2013:
2014: wf_engine.SetItemAttrText (itemtype => itemtype,

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

2010: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2011:
2012: create_adhoc_role('PACCOUNT_UPDATED_'||l_bank_account_number, l_receiver);
2013:
2014: wf_engine.SetItemAttrText (itemtype => itemtype,
2015: itemkey => itemkey,
2016: aname => 'RECEIVER',
2017: avalue => l_receiver);
2018:

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

2104: BEGIN
2105: IF ( funcmode = 'RUN' ) THEN
2106:
2107: l_vendor_id :=
2108: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2109:
2110: l_bank_account_number :=
2111: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2112:

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

2107: l_vendor_id :=
2108: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2109:
2110: l_bank_account_number :=
2111: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2112:
2113: l_currency_code :=
2114: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2115:

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

2110: l_bank_account_number :=
2111: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2112:
2113: l_currency_code :=
2114: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2115:
2116: l_bank_account_name :=
2117: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2118:

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

2113: l_currency_code :=
2114: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2115:
2116: l_bank_account_name :=
2117: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2118:
2119: create_adhoc_role('PACCOUNT_CREATED_'|| l_vendor_id, l_receiver);
2120:
2121: wf_engine.SetItemAttrText (itemtype => itemtype,

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

2117: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2118:
2119: create_adhoc_role('PACCOUNT_CREATED_'|| l_vendor_id, l_receiver);
2120:
2121: wf_engine.SetItemAttrText (itemtype => itemtype,
2122: itemkey => itemkey,
2123: aname => 'RECEIVER',
2124: avalue => l_receiver);
2125:

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

2186: To_char(p_vendor_id),
2187: l_itemkey);
2188:
2189: l_step := 3;
2190: wf_engine.CreateProcess(itemtype => l_itemtype,
2191: itemkey => l_itemkey,
2192: process => l_process);
2193:
2194: l_step := 4;

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

2191: itemkey => l_itemkey,
2192: process => l_process);
2193:
2194: l_step := 4;
2195: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2196: itemkey => l_itemkey,
2197: aname => 'URL',
2198: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2199:

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

2196: itemkey => l_itemkey,
2197: aname => 'URL',
2198: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2199:
2200: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2201: itemkey => l_itemkey,
2202: aname => 'SUPPLIER_NAME',
2203: avalue => l_supplier_name);
2204:

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

2201: itemkey => l_itemkey,
2202: aname => 'SUPPLIER_NAME',
2203: avalue => l_supplier_name);
2204:
2205: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2206: itemkey => l_itemkey,
2207: aname => 'VENDOR_ID',
2208: avalue => p_vendor_id);
2209:

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

2206: itemkey => l_itemkey,
2207: aname => 'VENDOR_ID',
2208: avalue => p_vendor_id);
2209:
2210: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2211: itemkey => l_itemkey,
2212: aname => 'BANK_NAME',
2213: avalue => p_bank_name);
2214:

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

2211: itemkey => l_itemkey,
2212: aname => 'BANK_NAME',
2213: avalue => p_bank_name);
2214:
2215: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2216: itemkey => l_itemkey,
2217: aname => 'BANK_ACCOUNT_NUMBER',
2218: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2219:

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

2216: itemkey => l_itemkey,
2217: aname => 'BANK_ACCOUNT_NUMBER',
2218: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2219:
2220: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2221: itemkey => l_itemkey,
2222: aname => 'FIRST_NAME',
2223: avalue => l_first_name);
2224:

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

2221: itemkey => l_itemkey,
2222: aname => 'FIRST_NAME',
2223: avalue => l_first_name);
2224:
2225: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2226: itemkey => l_itemkey,
2227: aname => 'LAST_NAME',
2228: avalue => l_last_name);
2229:

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

2227: aname => 'LAST_NAME',
2228: avalue => l_last_name);
2229:
2230: l_step := 5;
2231: wf_engine.StartProcess(itemtype => l_itemtype,
2232: itemkey => l_itemkey );
2233:
2234: x_itemtype := l_itemtype;
2235: x_itemkey := l_itemkey;

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

2277: l_itemkey);
2278:
2279: l_step := 3;
2280:
2281: wf_engine.CreateProcess(itemtype => l_itemtype,
2282: itemkey => l_itemkey,
2283: process => l_process);
2284:
2285: l_step := 4;

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

2283: process => l_process);
2284:
2285: l_step := 4;
2286:
2287: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2288: itemkey => l_itemkey,
2289: aname => 'URL',
2290: avalue => pos_url_pkg.get_external_login_url);
2291:

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

2288: itemkey => l_itemkey,
2289: aname => 'URL',
2290: avalue => pos_url_pkg.get_external_login_url);
2291:
2292: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2293: itemkey => l_itemkey,
2294: aname => 'SUPPLIER_NAME',
2295: avalue => l_supplier_name);
2296:

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

2293: itemkey => l_itemkey,
2294: aname => 'SUPPLIER_NAME',
2295: avalue => l_supplier_name);
2296:
2297: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2298: itemkey => l_itemkey,
2299: aname => 'VENDOR_ID',
2300: avalue => p_vendor_id);
2301:

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

2298: itemkey => l_itemkey,
2299: aname => 'VENDOR_ID',
2300: avalue => p_vendor_id);
2301:
2302: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2303: itemkey => l_itemkey,
2304: aname => 'BANK_NAME',
2305: avalue => p_bank_name);
2306:

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

2303: itemkey => l_itemkey,
2304: aname => 'BANK_NAME',
2305: avalue => p_bank_name);
2306:
2307: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2308: itemkey => l_itemkey,
2309: aname => 'BANK_ACCOUNT_NUMBER',
2310: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2311:

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

2308: itemkey => l_itemkey,
2309: aname => 'BANK_ACCOUNT_NUMBER',
2310: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2311:
2312: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2313: itemkey => l_itemkey,
2314: aname => 'ENTERPRISE_NAME',
2315: avalue => l_enterprise_name);
2316:

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

2313: itemkey => l_itemkey,
2314: aname => 'ENTERPRISE_NAME',
2315: avalue => l_enterprise_name);
2316:
2317: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2318: itemkey => l_itemkey,
2319: aname => 'FIRST_NAME',
2320: avalue => l_first_name);
2321:

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

2318: itemkey => l_itemkey,
2319: aname => 'FIRST_NAME',
2320: avalue => l_first_name);
2321:
2322: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2323: itemkey => l_itemkey,
2324: aname => 'LAST_NAME',
2325: avalue => l_last_name);
2326: l_step := 5;

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

2324: aname => 'LAST_NAME',
2325: avalue => l_last_name);
2326: l_step := 5;
2327:
2328: wf_engine.StartProcess(itemtype => l_itemtype,
2329: itemkey => l_itemkey );
2330:
2331: x_itemtype := l_itemtype;
2332: x_itemkey := l_itemkey;

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

2373: l_itemkey);
2374:
2375: l_step := 3;
2376:
2377: wf_engine.CreateProcess(itemtype => l_itemtype,
2378: itemkey => l_itemkey,
2379: process => l_process);
2380:
2381: l_step := 4;

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

2378: itemkey => l_itemkey,
2379: process => l_process);
2380:
2381: l_step := 4;
2382: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2383: itemkey => l_itemkey,
2384: aname => 'URL',
2385: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2386:

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

2383: itemkey => l_itemkey,
2384: aname => 'URL',
2385: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2386:
2387: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2388: itemkey => l_itemkey,
2389: aname => 'SUPPLIER_NAME',
2390: avalue => l_supplier_name);
2391:

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

2388: itemkey => l_itemkey,
2389: aname => 'SUPPLIER_NAME',
2390: avalue => l_supplier_name);
2391:
2392: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2393: itemkey => l_itemkey,
2394: aname => 'VENDOR_ID',
2395: avalue => p_vendor_id);
2396:

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

2393: itemkey => l_itemkey,
2394: aname => 'VENDOR_ID',
2395: avalue => p_vendor_id);
2396:
2397: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2398: itemkey => l_itemkey,
2399: aname => 'BANK_NAME',
2400: avalue => p_bank_name);
2401:

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

2398: itemkey => l_itemkey,
2399: aname => 'BANK_NAME',
2400: avalue => p_bank_name);
2401:
2402: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2403: itemkey => l_itemkey,
2404: aname => 'BANK_ACCOUNT_NUMBER',
2405: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2406:

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

2403: itemkey => l_itemkey,
2404: aname => 'BANK_ACCOUNT_NUMBER',
2405: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2406:
2407: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2408: itemkey => l_itemkey,
2409: aname => 'CURRENCY_CODE',
2410: avalue => p_currency_code);
2411:

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

2408: itemkey => l_itemkey,
2409: aname => 'CURRENCY_CODE',
2410: avalue => p_currency_code);
2411:
2412: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2413: itemkey => l_itemkey,
2414: aname => 'BANK_ACCOUNT_NAME',
2415: avalue => p_bank_account_name);
2416:

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

2413: itemkey => l_itemkey,
2414: aname => 'BANK_ACCOUNT_NAME',
2415: avalue => p_bank_account_name);
2416:
2417: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2418: itemkey => l_itemkey,
2419: aname => 'FIRST_NAME',
2420: avalue => l_first_name);
2421:

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

2418: itemkey => l_itemkey,
2419: aname => 'FIRST_NAME',
2420: avalue => l_first_name);
2421:
2422: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2423: itemkey => l_itemkey,
2424: aname => 'LAST_NAME',
2425: avalue => l_last_name);
2426:

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

2425: avalue => l_last_name);
2426:
2427: l_step := 5;
2428:
2429: wf_engine.StartProcess(itemtype => l_itemtype,
2430: itemkey => l_itemkey );
2431:
2432: x_itemtype := l_itemtype;
2433: x_itemkey := l_itemkey;

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

2475: l_itemkey);
2476:
2477: l_step := 3;
2478:
2479: wf_engine.CreateProcess(itemtype => l_itemtype,
2480: itemkey => l_itemkey,
2481: process => l_process);
2482:
2483: l_step := 4;

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

2481: process => l_process);
2482:
2483: l_step := 4;
2484:
2485: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2486: itemkey => l_itemkey,
2487: aname => 'URL',
2488: avalue => pos_url_pkg.get_external_login_url);
2489:

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

2486: itemkey => l_itemkey,
2487: aname => 'URL',
2488: avalue => pos_url_pkg.get_external_login_url);
2489:
2490: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2491: itemkey => l_itemkey,
2492: aname => 'SUPPLIER_NAME',
2493: avalue => l_supplier_name);
2494:

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

2491: itemkey => l_itemkey,
2492: aname => 'SUPPLIER_NAME',
2493: avalue => l_supplier_name);
2494:
2495: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2496: itemkey => l_itemkey,
2497: aname => 'VENDOR_ID',
2498: avalue => p_vendor_id);
2499:

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

2496: itemkey => l_itemkey,
2497: aname => 'VENDOR_ID',
2498: avalue => p_vendor_id);
2499:
2500: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2501: itemkey => l_itemkey,
2502: aname => 'BANK_NAME',
2503: avalue => p_bank_name);
2504:

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

2501: itemkey => l_itemkey,
2502: aname => 'BANK_NAME',
2503: avalue => p_bank_name);
2504:
2505: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2506: itemkey => l_itemkey,
2507: aname => 'BANK_ACCOUNT_NUMBER',
2508: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2509:

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

2506: itemkey => l_itemkey,
2507: aname => 'BANK_ACCOUNT_NUMBER',
2508: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2509:
2510: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2511: itemkey => l_itemkey,
2512: aname => 'CURRENCY_CODE',
2513: avalue => p_currency_code);
2514:

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

2511: itemkey => l_itemkey,
2512: aname => 'CURRENCY_CODE',
2513: avalue => p_currency_code);
2514:
2515: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2516: itemkey => l_itemkey,
2517: aname => 'BANK_ACCOUNT_NAME',
2518: avalue => p_bank_account_name);
2519:

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

2516: itemkey => l_itemkey,
2517: aname => 'BANK_ACCOUNT_NAME',
2518: avalue => p_bank_account_name);
2519:
2520: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2521: itemkey => l_itemkey,
2522: aname => 'FIRST_NAME',
2523: avalue => l_first_name);
2524:

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

2521: itemkey => l_itemkey,
2522: aname => 'FIRST_NAME',
2523: avalue => l_first_name);
2524:
2525: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2526: itemkey => l_itemkey,
2527: aname => 'LAST_NAME',
2528: avalue => l_last_name);
2529:

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

2528: avalue => l_last_name);
2529:
2530: l_step := 5;
2531:
2532: wf_engine.StartProcess(itemtype => l_itemtype,
2533: itemkey => l_itemkey );
2534:
2535: x_itemtype := l_itemtype;
2536: x_itemkey := l_itemkey;

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

2575: get_wf_item_key (l_process,To_char(p_vendor_id),l_itemkey);
2576:
2577: l_step := 3;
2578:
2579: wf_engine.CreateProcess(itemtype => l_itemtype,
2580: itemkey => l_itemkey,
2581: process => l_process);
2582:
2583: l_step := 4;

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

2580: itemkey => l_itemkey,
2581: process => l_process);
2582:
2583: l_step := 4;
2584: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2585: itemkey => l_itemkey,
2586: aname => 'VENDOR_ID',
2587: avalue => p_vendor_id);
2588:

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

2585: itemkey => l_itemkey,
2586: aname => 'VENDOR_ID',
2587: avalue => p_vendor_id);
2588:
2589: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2590: itemkey => l_itemkey,
2591: aname => 'BANK_NAME',
2592: avalue => p_bank_name);
2593:

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

2590: itemkey => l_itemkey,
2591: aname => 'BANK_NAME',
2592: avalue => p_bank_name);
2593:
2594: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2595: itemkey => l_itemkey,
2596: aname => 'BANK_ACCOUNT_NUMBER',
2597: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2598:

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

2595: itemkey => l_itemkey,
2596: aname => 'BANK_ACCOUNT_NUMBER',
2597: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2598:
2599: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2600: itemkey => l_itemkey,
2601: aname => 'BUYER_NOTE',
2602: avalue => 'PLSQL:POS_SPM_WF_PKG1.BANK_ACCT_BUYER_NOTE/'||p_note);
2603:

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

2603:
2604: IF l_process = 'PACCOUNT_VERIFY' OR l_process = 'PACCOUNT_VERIFY_FAILED'
2605: THEN
2606: get_enterprise_name(l_enterprise_name);
2607: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2608: itemkey => l_itemkey,
2609: aname => 'ENTERPRISE_NAME',
2610: avalue => l_enterprise_name);
2611: END IF;

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

2611: END IF;
2612:
2613: l_step := 5;
2614:
2615: wf_engine.StartProcess(itemtype => l_itemtype,
2616: itemkey => l_itemkey );
2617:
2618: x_itemtype := l_itemtype;
2619: x_itemkey := l_itemkey;

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

2640: BEGIN
2641: IF ( funcmode = 'RUN' ) THEN
2642:
2643: l_vendor_id :=
2644: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2645:
2646: l_bank_account_number :=
2647: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2648:

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

2643: l_vendor_id :=
2644: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID');
2645:
2646: l_bank_account_number :=
2647: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2648:
2649: l_currency_code :=
2650: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2651:

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

2646: l_bank_account_number :=
2647: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NUMBER');
2648:
2649: l_currency_code :=
2650: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2651:
2652: l_bank_branch_id :=
2653: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'BANK_BRANCH_ID');
2654:

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

2649: l_currency_code :=
2650: wf_engine.GetItemAttrText(itemtype, itemkey, 'CURRENCY_CODE');
2651:
2652: l_bank_branch_id :=
2653: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'BANK_BRANCH_ID');
2654:
2655: l_bank_account_name :=
2656: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2657:

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

2652: l_bank_branch_id :=
2653: wf_engine.GetItemAttrNumber(itemtype, itemkey, 'BANK_BRANCH_ID');
2654:
2655: l_bank_account_name :=
2656: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2657:
2658: create_adhoc_role('PACCT_ADDR_'|| l_vendor_id, l_receiver);
2659:
2660: wf_engine.SetItemAttrText (itemtype => itemtype,

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

2656: wf_engine.GetItemAttrText(itemtype, itemkey, 'BANK_ACCOUNT_NAME');
2657:
2658: create_adhoc_role('PACCT_ADDR_'|| l_vendor_id, l_receiver);
2659:
2660: wf_engine.SetItemAttrText (itemtype => itemtype,
2661: itemkey => itemkey,
2662: aname => 'RECEIVER',
2663: avalue => l_receiver);
2664:

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

2723: l_itemkey);
2724:
2725: l_step := 3;
2726:
2727: wf_engine.CreateProcess(itemtype => l_itemtype,
2728: itemkey => l_itemkey,
2729: process => l_process);
2730:
2731: l_step := 4;

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

2729: process => l_process);
2730:
2731: l_step := 4;
2732:
2733: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2734: itemkey => l_itemkey,
2735: aname => 'URL',
2736: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2737:

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

2734: itemkey => l_itemkey,
2735: aname => 'URL',
2736: avalue => pos_url_pkg.get_dest_page_url ('POS_SBD_BUYER_MAIN', 'BUYER'));
2737:
2738: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2739: itemkey => l_itemkey,
2740: aname => 'SUPPLIER_NAME',
2741: avalue => l_supplier_name);
2742:

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

2739: itemkey => l_itemkey,
2740: aname => 'SUPPLIER_NAME',
2741: avalue => l_supplier_name);
2742:
2743: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2744: itemkey => l_itemkey,
2745: aname => 'ADDRESS_NAME',
2746: avalue => p_party_site_name);
2747:

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

2744: itemkey => l_itemkey,
2745: aname => 'ADDRESS_NAME',
2746: avalue => p_party_site_name);
2747:
2748: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
2749: itemkey => l_itemkey,
2750: aname => 'VENDOR_ID',
2751: avalue => p_vendor_id);
2752:

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

2749: itemkey => l_itemkey,
2750: aname => 'VENDOR_ID',
2751: avalue => p_vendor_id);
2752:
2753: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2754: itemkey => l_itemkey,
2755: aname => 'BANK_NAME',
2756: avalue => p_bank_name);
2757:

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

2754: itemkey => l_itemkey,
2755: aname => 'BANK_NAME',
2756: avalue => p_bank_name);
2757:
2758: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2759: itemkey => l_itemkey,
2760: aname => 'BANK_ACCOUNT_NUMBER',
2761: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2762:

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

2759: itemkey => l_itemkey,
2760: aname => 'BANK_ACCOUNT_NUMBER',
2761: avalue => IBY_EXT_BANKACCT_PUB.Mask_Bank_Number(p_bank_account_number));
2762:
2763: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2764: itemkey => l_itemkey,
2765: aname => 'CURRENCY_CODE',
2766: avalue => p_currency_code);
2767:

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

2764: itemkey => l_itemkey,
2765: aname => 'CURRENCY_CODE',
2766: avalue => p_currency_code);
2767:
2768: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2769: itemkey => l_itemkey,
2770: aname => 'BANK_ACCOUNT_NAME',
2771: avalue => p_bank_account_name);
2772:

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

2769: itemkey => l_itemkey,
2770: aname => 'BANK_ACCOUNT_NAME',
2771: avalue => p_bank_account_name);
2772:
2773: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2774: itemkey => l_itemkey,
2775: aname => 'FIRST_NAME',
2776: avalue => l_first_name);
2777:

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

2774: itemkey => l_itemkey,
2775: aname => 'FIRST_NAME',
2776: avalue => l_first_name);
2777:
2778: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2779: itemkey => l_itemkey,
2780: aname => 'LAST_NAME',
2781: avalue => l_last_name);
2782:

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

2781: avalue => l_last_name);
2782:
2783: l_step := 5;
2784:
2785: wf_engine.StartProcess(itemtype => l_itemtype,
2786: itemkey => l_itemkey );
2787:
2788: x_itemtype := l_itemtype;
2789: x_itemkey := l_itemkey;

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

2914: display_name => l_receiver,
2915: email_address => l_rec.email_address
2916: );
2917:
2918: wf_engine.CreateProcess(itemtype => l_itemtype,
2919: itemkey => l_itemkey,
2920: process => l_process
2921: );
2922:

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

2919: itemkey => l_itemkey,
2920: process => l_process
2921: );
2922:
2923: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2924: itemkey => l_itemkey,
2925: aname => 'RECEIVER',
2926: avalue => l_receiver
2927: );

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

2927: );
2928:
2929: get_enterprise_name(l_enterprise_name);
2930:
2931: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2932: itemkey => l_itemkey,
2933: aname => 'ENTERPRISE_NAME',
2934: avalue => l_enterprise_name
2935: );

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

2933: aname => 'ENTERPRISE_NAME',
2934: avalue => l_enterprise_name
2935: );
2936:
2937: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2938: itemkey => l_itemkey,
2939: aname => 'URL',
2940: avalue => get_supplier_reg_url(l_rec.reg_key)
2941: );

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

2939: aname => 'URL',
2940: avalue => get_supplier_reg_url(l_rec.reg_key)
2941: );
2942:
2943: wf_engine.StartProcess (itemtype => l_itemtype,
2944: itemkey => l_itemkey
2945: );
2946:
2947: END send_supplier_invite_reg_ntf;

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

3011: );
3012: end if;
3013: end if;
3014:
3015: wf_engine.CreateProcess(itemtype => l_itemtype,
3016: itemkey => l_itemkey,
3017: process => l_process
3018: );
3019:

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

3016: itemkey => l_itemkey,
3017: process => l_process
3018: );
3019:
3020: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3021: itemkey => l_itemkey,
3022: aname => 'RECEIVER',
3023: avalue => l_receiver
3024: );

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

3024: );
3025:
3026: get_enterprise_name(l_enterprise_name);
3027:
3028: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3029: itemkey => l_itemkey,
3030: aname => 'ENTERPRISE_NAME',
3031: avalue => l_enterprise_name
3032: );

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

3030: aname => 'ENTERPRISE_NAME',
3031: avalue => l_enterprise_name
3032: );
3033:
3034: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3035: itemkey => l_itemkey,
3036: aname => 'URL',
3037: avalue => get_supplier_reg_url(l_rec.reg_key)
3038: );

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

3036: aname => 'URL',
3037: avalue => get_supplier_reg_url(l_rec.reg_key)
3038: );
3039:
3040: wf_engine.StartProcess (itemtype => l_itemtype,
3041: itemkey => l_itemkey
3042: );
3043:
3044: END send_supplier_reg_saved_ntf;

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

3087: -- create workflow process
3088: get_wf_item_type (l_itemtype);
3089: get_wf_item_key (l_process, p_vendor_id, l_itemkey);
3090:
3091: wf_engine.CreateProcess(itemtype => l_itemtype,
3092: itemkey => l_itemkey,
3093: process => l_process);
3094: l_step := 6;
3095: wf_engine.SetItemAttrText (itemtype => l_itemtype,

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

3091: wf_engine.CreateProcess(itemtype => l_itemtype,
3092: itemkey => l_itemkey,
3093: process => l_process);
3094: l_step := 6;
3095: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3096: itemkey => l_itemkey,
3097: aname => 'RECEIVER',
3098: avalue => l_receiver);
3099:

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

3096: itemkey => l_itemkey,
3097: aname => 'RECEIVER',
3098: avalue => l_receiver);
3099:
3100: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3101: itemkey => l_itemkey,
3102: aname => 'SUPPLIER_NAME',
3103: avalue => l_supplier_name);
3104:

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

3101: itemkey => l_itemkey,
3102: aname => 'SUPPLIER_NAME',
3103: avalue => l_supplier_name);
3104:
3105: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3106: itemkey => l_itemkey,
3107: aname => 'VENDOR_ID',
3108: avalue => p_vendor_id);
3109:

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

3106: itemkey => l_itemkey,
3107: aname => 'VENDOR_ID',
3108: avalue => p_vendor_id);
3109:
3110: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3111: itemkey => l_itemkey,
3112: aname => 'URL',
3113: avalue => pos_url_pkg.get_dest_page_url('POS_SBD_BUYER_MAIN', 'BUYER'));
3114: l_step := 7;

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

3114: l_step := 7;
3115: setup_actioner_private(l_itemtype, l_itemkey);
3116:
3117: l_step := 8;
3118: wf_engine.StartProcess(itemtype => l_itemtype,
3119: itemkey => l_itemkey );
3120: l_step := 9;
3121: x_itemtype := l_itemtype;
3122: x_itemkey := l_itemkey;

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

3156: To_char(p_supplier_reg_id),
3157: l_itemkey);
3158:
3159: l_step := 3;
3160: wf_engine.CreateProcess(itemtype => l_itemtype,
3161: itemkey => l_itemkey,
3162: process => l_process);
3163:
3164: l_step := 4;

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

3161: itemkey => l_itemkey,
3162: process => l_process);
3163:
3164: l_step := 4;
3165: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3166: itemkey => l_itemkey,
3167: aname => 'RECEIVER',
3168: avalue => p_username);
3169:

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

3166: itemkey => l_itemkey,
3167: aname => 'RECEIVER',
3168: avalue => p_username);
3169:
3170: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3171: itemkey => l_itemkey,
3172: aname => 'ENTERPRISE_NAME',
3173: avalue => l_enterprise_name);
3174:

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

3171: itemkey => l_itemkey,
3172: aname => 'ENTERPRISE_NAME',
3173: avalue => l_enterprise_name);
3174:
3175: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3176: itemkey => l_itemkey,
3177: aname => 'USERNAME',
3178: avalue => p_username);
3179:

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

3176: itemkey => l_itemkey,
3177: aname => 'USERNAME',
3178: avalue => p_username);
3179:
3180: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3181: itemkey => l_itemkey,
3182: aname => 'URL',
3183: avalue => pos_url_pkg.get_external_login_url);
3184:

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

3181: itemkey => l_itemkey,
3182: aname => 'URL',
3183: avalue => pos_url_pkg.get_external_login_url);
3184:
3185: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3186: itemkey => l_itemkey,
3187: aname => 'ADMIN_EMAIL',
3188: avalue => get_admin_email);
3189:

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

3186: itemkey => l_itemkey,
3187: aname => 'ADMIN_EMAIL',
3188: avalue => get_admin_email);
3189:
3190: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3191: itemkey => l_itemkey,
3192: aname => 'BUYER_NOTE',
3193: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
3194: l_step := 5;

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

3191: itemkey => l_itemkey,
3192: aname => 'BUYER_NOTE',
3193: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
3194: l_step := 5;
3195: wf_engine.StartProcess(itemtype => l_itemtype,
3196: itemkey => l_itemkey );
3197: l_step := 6;
3198: x_itemtype := l_itemtype;
3199: x_itemkey := l_itemkey;

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

3233: To_char(p_supplier_reg_id) || '_' || p_username,
3234: l_itemkey);
3235:
3236: l_step := 4;
3237: wf_engine.CreateProcess(itemtype => l_itemtype,
3238: itemkey => l_itemkey,
3239: process => l_process);
3240:
3241: l_step := 5;

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

3238: itemkey => l_itemkey,
3239: process => l_process);
3240:
3241: l_step := 5;
3242: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3243: itemkey => l_itemkey,
3244: aname => 'RECEIVER',
3245: avalue => p_username);
3246:

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

3244: aname => 'RECEIVER',
3245: avalue => p_username);
3246:
3247: l_step := 6;
3248: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3249: itemkey => l_itemkey,
3250: aname => 'ENTERPRISE_NAME',
3251: avalue => l_enterprise_name);
3252:

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

3250: aname => 'ENTERPRISE_NAME',
3251: avalue => l_enterprise_name);
3252:
3253: l_step := 7;
3254: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3255: itemkey => l_itemkey,
3256: aname => 'USERNAME',
3257: avalue => p_username);
3258:

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

3258:
3259: l_step := 8;
3260:
3261: l_step := 9;
3262: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3263: itemkey => l_itemkey,
3264: aname => 'URL',
3265: avalue => pos_url_pkg.get_external_login_url);
3266:

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

3264: aname => 'URL',
3265: avalue => pos_url_pkg.get_external_login_url);
3266:
3267: l_step := 10;
3268: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3269: itemkey => l_itemkey,
3270: aname => 'ADMIN_EMAIL',
3271: avalue => get_admin_email);
3272:

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

3271: avalue => get_admin_email);
3272:
3273: l_step := 11;
3274:
3275: wf_engine.StartProcess(itemtype => l_itemtype,
3276: itemkey => l_itemkey );
3277: x_itemtype := l_itemtype;
3278: x_itemkey := l_itemkey;
3279:

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

3425: IF ul > 0 THEN
3426:
3427: l_itemkey := l_itemtype||'_'||l_process||'_'||to_char(sysdate, 'JSSSSS')||'_'||'VENDOR_ID'||'_'||to_char(l_vendor_id);
3428:
3429: wf_engine.CreateProcess(itemtype => l_itemtype,
3430: itemkey => l_itemkey,
3431: process => l_process
3432: );
3433:

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

3432: );
3433:
3434: get_enterprise_name(l_enterprise_name);
3435:
3436: wf_engine.SetItemAttrText(itemtype => l_itemtype,
3437: itemkey => l_itemkey,
3438: aname => 'ENTERPRISE_NAME',
3439: avalue => l_enterprise_name
3440: );

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

3438: aname => 'ENTERPRISE_NAME',
3439: avalue => l_enterprise_name
3440: );
3441:
3442: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
3443: itemkey => l_itemkey,
3444: aname => 'VENDOR_ID',
3445: avalue => l_vendor_id
3446: );

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

3455: ELSE
3456: l_due_date := SYSDATE + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_REMIND_DAYS'));
3457: END IF;
3458:
3459: wf_engine.SetItemAttrText(itemtype => l_itemtype,
3460: itemkey => l_itemkey,
3461: aname => 'BC_RECERT_DUE_DATE',
3462: avalue => l_due_date
3463: );

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

3481: role_users => l_users,
3482: expiration_date => l_expiration_date
3483: );
3484:
3485: wf_engine.SetItemAttrText( itemtype => l_itemtype,
3486: itemkey => l_itemkey,
3487: aname => 'BUS_CLASS_RECERT_RECEIVERS',
3488: avalue => l_role_name
3489: );

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

3487: aname => 'BUS_CLASS_RECERT_RECEIVERS',
3488: avalue => l_role_name
3489: );
3490:
3491: wf_engine.StartProcess(itemtype => l_itemtype,
3492: itemkey => l_itemkey
3493: );
3494:
3495: END IF;