DBA Data[Home] [Help]

APPS.XDPCORE_BUNDLE dependencies on WF_ENGINE

Line 462: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => AreAllBundlesDone.itemtype,

458: x_Progress VARCHAR2(2000);
459:
460: begin
461:
462: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => AreAllBundlesDone.itemtype,
463: itemkey => AreAllBundlesDone.itemkey,
464: aname => 'ORDER_ID');
465:
466: l_PrevBundleSeq := wf_engine.GetItemAttrNumber(itemtype => AreAllBundlesDone.itemtype,

Line 466: l_PrevBundleSeq := wf_engine.GetItemAttrNumber(itemtype => AreAllBundlesDone.itemtype,

462: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => AreAllBundlesDone.itemtype,
463: itemkey => AreAllBundlesDone.itemkey,
464: aname => 'ORDER_ID');
465:
466: l_PrevBundleSeq := wf_engine.GetItemAttrNumber(itemtype => AreAllBundlesDone.itemtype,
467: itemkey => AreAllBundlesDone.itemkey,
468: aname => 'CURRENT_BUNDLE_SEQUENCE');
469:
470:

Line 560: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcesses.itemtype,

556: ErrStr varchar2(1996);
557:
558: begin
559:
560: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcesses.itemtype,
561: itemkey => LaunchBundleProcesses.itemkey,
562: aname => 'ORDER_ID');
563:
564: open c_GetIndBundle(l_OrderID);

Line 582: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),

578: t_ChildTypes(l_Counter) := 'XDPPROV';
579: t_ChildKeys(l_Counter) := l_tempKey;
580:
581:
582: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
583: itemkey => t_ChildKeys(l_Counter),
584: process => 'INDEPENDENT_BUNDLE_PROCESS');
585:
586: wf_engine.setItemParent(itemtype => t_ChildTypes(l_Counter),

Line 586: wf_engine.setItemParent(itemtype => t_ChildTypes(l_Counter),

582: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
583: itemkey => t_ChildKeys(l_Counter),
584: process => 'INDEPENDENT_BUNDLE_PROCESS');
585:
586: wf_engine.setItemParent(itemtype => t_ChildTypes(l_Counter),
587: itemkey => t_ChildKeys(l_Counter),
588: parent_itemtype => itemtype,
589: parent_itemkey => itemkey,
590: parent_context => 'WAITFORFLOW-BUNDLE-DEP');

Line 592: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

588: parent_itemtype => itemtype,
589: parent_itemkey => itemkey,
590: parent_context => 'WAITFORFLOW-BUNDLE-DEP');
591:
592: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
593: itemkey => t_ChildKeys(l_Counter),
594: aname => 'ORDER_ID',
595: avalue => l_OrderID);
596:

Line 653: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),

649: l_tempKey := to_char(l_OrderID) || '-BUNDLE-' || to_char(l_BundleID) || '-' || l_tempKey;
650:
651: t_ChildKeys(l_Counter) := l_tempKey;
652:
653: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
654: itemkey => t_ChildKeys(l_Counter),
655: process => 'DEPENDENT_BUNDLE_PROCESS');
656:
657: wf_engine.setItemParent(itemtype => t_ChildTypes(l_Counter),

Line 657: wf_engine.setItemParent(itemtype => t_ChildTypes(l_Counter),

653: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
654: itemkey => t_ChildKeys(l_Counter),
655: process => 'DEPENDENT_BUNDLE_PROCESS');
656:
657: wf_engine.setItemParent(itemtype => t_ChildTypes(l_Counter),
658: itemkey => t_ChildKeys(l_Counter),
659: parent_itemtype => itemtype,
660: parent_itemkey => itemkey,
661: parent_context => null);

Line 663: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

659: parent_itemtype => itemtype,
660: parent_itemkey => itemkey,
661: parent_context => null);
662:
663: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
664: itemkey => t_ChildKeys(l_Counter),
665: aname => 'ORDER_ID',
666: avalue => l_OrderID);
667:

Line 712: wf_engine.StartProcess(itemtype => t_ChildTypes(i),

708: /* Launch all the Child Processes */
709: for i in 1..l_Counter loop
710:
711: -- dbms_output.put_line('launching Bundles: ' || t_ChildKeys(i));
712: wf_engine.StartProcess(itemtype => t_ChildTypes(i),
713: itemkey => t_ChildKeys(i));
714: end loop;
715:
716: exception

Line 822: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchLineForBundleProcess.itemtype,

818: ErrCode number;
819: ErrStr varchar2(1996);
820:
821: begin
822: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchLineForBundleProcess.itemtype,
823: itemkey => LaunchLineForBundleProcess.itemkey,
824: aname => 'ORDER_ID');
825:
826: l_BundleID := wf_engine.GetItemAttrNumber(itemtype => LaunchLineForBundleProcess.itemtype,

Line 826: l_BundleID := wf_engine.GetItemAttrNumber(itemtype => LaunchLineForBundleProcess.itemtype,

822: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchLineForBundleProcess.itemtype,
823: itemkey => LaunchLineForBundleProcess.itemkey,
824: aname => 'ORDER_ID');
825:
826: l_BundleID := wf_engine.GetItemAttrNumber(itemtype => LaunchLineForBundleProcess.itemtype,
827: itemkey => LaunchLineForBundleProcess.itemkey,
828: aname => 'BUNDLE_ID');
829:
830: l_IndBundleFlag := wf_engine.GetItemAttrText(itemtype => LaunchLineForBundleProcess.itemtype,

Line 830: l_IndBundleFlag := wf_engine.GetItemAttrText(itemtype => LaunchLineForBundleProcess.itemtype,

826: l_BundleID := wf_engine.GetItemAttrNumber(itemtype => LaunchLineForBundleProcess.itemtype,
827: itemkey => LaunchLineForBundleProcess.itemkey,
828: aname => 'BUNDLE_ID');
829:
830: l_IndBundleFlag := wf_engine.GetItemAttrText(itemtype => LaunchLineForBundleProcess.itemtype,
831: itemkey => LaunchLineForBundleProcess.itemkey,
832: aname => 'INDEPENDENT_BUNDLE_FLAG');
833:
834:

Line 868: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),

864: t_ChildTypes(l_Counter) := 'XDPPROV';
865: t_ChildKeys(l_Counter) := l_tempKey;
866:
867:
868: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
869: itemkey => t_ChildKeys(l_Counter),
870: process => 'LINE_PROCESSING_PROCESS');
871:
872: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

Line 872: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

868: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
869: itemkey => t_ChildKeys(l_Counter),
870: process => 'LINE_PROCESSING_PROCESS');
871:
872: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),
873: itemkey => t_ChildKeys(l_Counter),
874: parent_itemtype => LaunchLineForBundleProcess.itemtype,
875: parent_itemkey => LaunchLineForBundleProcess.itemkey,
876: parent_context => null);

Line 878: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

874: parent_itemtype => LaunchLineForBundleProcess.itemtype,
875: parent_itemkey => LaunchLineForBundleProcess.itemkey,
876: parent_context => null);
877:
878: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
879: itemkey => t_ChildKeys(l_Counter),
880: aname => 'ORDER_ID',
881: avalue => l_OrderID);
882:

Line 883: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

879: itemkey => t_ChildKeys(l_Counter),
880: aname => 'ORDER_ID',
881: avalue => l_OrderID);
882:
883: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
884: itemkey => t_ChildKeys(l_Counter),
885: aname => 'LINE_ITEM_ID',
886: avalue => l_LineItemID);
887:

Line 947: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),

943: t_ChildTypes(l_Counter) := 'XDPPROV';
944: t_ChildKeys(l_Counter) := l_tempKey;
945:
946:
947: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
948: itemkey => t_ChildKeys(l_Counter),
949: process => 'LINE_SEQ_PROCESSING');
950:
951: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

Line 951: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

947: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
948: itemkey => t_ChildKeys(l_Counter),
949: process => 'LINE_SEQ_PROCESSING');
950:
951: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),
952: itemkey => t_ChildKeys(l_Counter),
953: parent_itemtype => LaunchLineForBundleProcess.itemtype,
954: parent_itemkey => LaunchLineForBundleProcess.itemkey,
955: parent_context => null);

Line 957: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

953: parent_itemtype => LaunchLineForBundleProcess.itemtype,
954: parent_itemkey => LaunchLineForBundleProcess.itemkey,
955: parent_context => null);
956:
957: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
958: itemkey => t_ChildKeys(l_Counter),
959: aname => 'ORDER_ID',
960: avalue => l_OrderID);
961:

Line 962: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

958: itemkey => t_ChildKeys(l_Counter),
959: aname => 'ORDER_ID',
960: avalue => l_OrderID);
961:
962: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
963: itemkey => t_ChildKeys(l_Counter),
964: aname => 'LINE_ITEM_ID',
965: avalue => l_LineItemID);
966:

Line 1045: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),

1041: t_ChildTypes(l_Counter) := 'XDPPROV';
1042: t_ChildKeys(l_Counter) := l_tempKey;
1043:
1044:
1045: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
1046: itemkey => t_ChildKeys(l_Counter),
1047: process => 'LINE_PROCESSING_PROCESS');
1048:
1049: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

Line 1049: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

1045: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
1046: itemkey => t_ChildKeys(l_Counter),
1047: process => 'LINE_PROCESSING_PROCESS');
1048:
1049: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),
1050: itemkey => t_ChildKeys(l_Counter),
1051: parent_itemtype => LaunchLineForBundleProcess.itemtype,
1052: parent_itemkey => LaunchLineForBundleProcess.itemkey,
1053: parent_context => null);

Line 1055: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

1051: parent_itemtype => LaunchLineForBundleProcess.itemtype,
1052: parent_itemkey => LaunchLineForBundleProcess.itemkey,
1053: parent_context => null);
1054:
1055: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
1056: itemkey => t_ChildKeys(l_Counter),
1057: aname => 'ORDER_ID',
1058: avalue => l_OrderID);
1059:

Line 1060: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

1056: itemkey => t_ChildKeys(l_Counter),
1057: aname => 'ORDER_ID',
1058: avalue => l_OrderID);
1059:
1060: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
1061: itemkey => t_ChildKeys(l_Counter),
1062: aname => 'LINE_ITEM_ID',
1063: avalue => l_LineItemID);
1064:

Line 1124: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),

1120:
1121: t_ChildTypes(l_Counter) := 'XDPPROV';
1122: t_ChildKeys(l_Counter) := l_tempKey;
1123:
1124: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
1125: itemkey => t_ChildKeys(l_Counter),
1126: process => 'LINE_SEQ_PROCESSING');
1127:
1128: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

Line 1128: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

1124: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
1125: itemkey => t_ChildKeys(l_Counter),
1126: process => 'LINE_SEQ_PROCESSING');
1127:
1128: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),
1129: itemkey => t_ChildKeys(l_Counter),
1130: parent_itemtype => LaunchLineForBundleProcess.itemtype,
1131: parent_itemkey => LaunchLineForBundleProcess.itemkey,
1132: parent_context => null);

Line 1134: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

1130: parent_itemtype => LaunchLineForBundleProcess.itemtype,
1131: parent_itemkey => LaunchLineForBundleProcess.itemkey,
1132: parent_context => null);
1133:
1134: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
1135: itemkey => t_ChildKeys(l_Counter),
1136: aname => 'ORDER_ID',
1137: avalue => l_OrderID);
1138:

Line 1139: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

1135: itemkey => t_ChildKeys(l_Counter),
1136: aname => 'ORDER_ID',
1137: avalue => l_OrderID);
1138:
1139: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
1140: itemkey => t_ChildKeys(l_Counter),
1141: aname => 'LINE_ITEM_ID',
1142: avalue => l_LineItemID);
1143:

Line 1214: wf_engine.StartProcess(t_ChildTypes(i),

1210:
1211: /* Now start the workflow process */
1212: FOR i in 1..l_Counter LOOP
1213:
1214: wf_engine.StartProcess(t_ChildTypes(i),
1215: t_ChildKeys(i));
1216:
1217: END LOOP;
1218:

Line 1288: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcessSeq.itemtype,

1284:
1285: ErrCode number;
1286: ErrStr varchar2(1996);
1287: begin
1288: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcessSeq.itemtype,
1289: itemkey => LaunchBundleProcessSeq.itemkey,
1290: aname => 'ORDER_ID');
1291:
1292: l_PrevBundleSeq := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcessSeq.itemtype,

Line 1292: l_PrevBundleSeq := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcessSeq.itemtype,

1288: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcessSeq.itemtype,
1289: itemkey => LaunchBundleProcessSeq.itemkey,
1290: aname => 'ORDER_ID');
1291:
1292: l_PrevBundleSeq := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcessSeq.itemtype,
1293: itemkey => LaunchBundleProcessSeq.itemkey,
1294: aname => 'CURRENT_BUNDLE_SEQUENCE');
1295:
1296: open c_BundleSeq(l_OrderID, l_PrevBundleSeq);

Line 1319: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),

1315: t_ChildTypes(l_Counter) := 'XDPPROV';
1316: t_ChildKeys(l_Counter) := l_tempKey;
1317:
1318:
1319: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
1320: itemkey => t_ChildKeys(l_Counter),
1321: process => 'LINE_PROCESSING_PROCESS');
1322:
1323: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

Line 1323: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

1319: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
1320: itemkey => t_ChildKeys(l_Counter),
1321: process => 'LINE_PROCESSING_PROCESS');
1322:
1323: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),
1324: itemkey => t_ChildKeys(l_Counter),
1325: parent_itemtype => LaunchBundleProcessSeq.itemtype,
1326: parent_itemkey => LaunchBundleProcessSeq.itemkey,
1327: parent_context => null);

Line 1329: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

1325: parent_itemtype => LaunchBundleProcessSeq.itemtype,
1326: parent_itemkey => LaunchBundleProcessSeq.itemkey,
1327: parent_context => null);
1328:
1329: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
1330: itemkey => t_ChildKeys(l_Counter),
1331: aname => 'ORDER_ID',
1332: avalue => l_OrderID);
1333:

Line 1334: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

1330: itemkey => t_ChildKeys(l_Counter),
1331: aname => 'ORDER_ID',
1332: avalue => l_OrderID);
1333:
1334: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
1335: itemkey => t_ChildKeys(l_Counter),
1336: aname => 'LINE_ITEM_ID',
1337: avalue => l_LineItemID);
1338:

Line 1399: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),

1395:
1396: t_ChildTypes(l_Counter) := 'XDPPROV';
1397: t_ChildKeys(l_Counter) := l_tempKey;
1398:
1399: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
1400: itemkey => t_ChildKeys(l_Counter),
1401: process => 'LINE_SEQ_PROCESSING');
1402:
1403: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

Line 1403: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),

1399: wf_engine.CreateProcess(itemtype => t_ChildTypes(l_Counter),
1400: itemkey => t_ChildKeys(l_Counter),
1401: process => 'LINE_SEQ_PROCESSING');
1402:
1403: wf_engine.SetItemParent(itemtype => t_ChildTypes(l_Counter),
1404: itemkey => t_ChildKeys(l_Counter),
1405: parent_itemtype => LaunchBundleProcessSeq.itemtype,
1406: parent_itemkey => LaunchBundleProcessSeq.itemkey,
1407: parent_context => null);

Line 1409: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

1405: parent_itemtype => LaunchBundleProcessSeq.itemtype,
1406: parent_itemkey => LaunchBundleProcessSeq.itemkey,
1407: parent_context => null);
1408:
1409: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
1410: itemkey => t_ChildKeys(l_Counter),
1411: aname => 'ORDER_ID',
1412: avalue => l_OrderID);
1413:

Line 1414: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),

1410: itemkey => t_ChildKeys(l_Counter),
1411: aname => 'ORDER_ID',
1412: avalue => l_OrderID);
1413:
1414: wf_engine.SetItemAttrNumber(itemtype => t_ChildTypes(l_Counter),
1415: itemkey => t_ChildKeys(l_Counter),
1416: aname => 'LINE_ITEM_ID',
1417: avalue => l_LineItemID);
1418:

Line 1492: wf_engine.StartProcess(t_ChildTypes(i),

1488: end if;
1489:
1490:
1491: FOR i in 1..l_Counter LOOP
1492: wf_engine.StartProcess(t_ChildTypes(i),
1493: t_ChildKeys(i));
1494: END LOOP;
1495:
1496: end if;

Line 1519: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => InitializeBundle.itemtype,

1515: e_AddAttributeException EXCEPTION;
1516:
1517: begin
1518:
1519: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => InitializeBundle.itemtype,
1520: itemkey => InitializeBundle.itemkey,
1521: aname => 'ORDER_ID');
1522:
1523: l_BundleID := wf_engine.GetItemAttrNumber(itemtype => InitializeBundle.itemtype,

Line 1523: l_BundleID := wf_engine.GetItemAttrNumber(itemtype => InitializeBundle.itemtype,

1519: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => InitializeBundle.itemtype,
1520: itemkey => InitializeBundle.itemkey,
1521: aname => 'ORDER_ID');
1522:
1523: l_BundleID := wf_engine.GetItemAttrNumber(itemtype => InitializeBundle.itemtype,
1524: itemkey => InitializeBundle.itemkey,
1525: aname => 'BUNDLE_ID');
1526:
1527: -- if l_BundleID > 0 then

Line 1579: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepBundles.itemtype,

1575: and BUNDLE_SEQUENCE > 0;
1576:
1577: BEGIN
1578:
1579: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepBundles.itemtype,
1580: itemkey => ResolveIndDepBundles.itemkey,
1581: aname => 'ORDER_ID');
1582:
1583:

Line 1640: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchAllIndBundles.itemtype,

1636:
1637:
1638: BEGIN
1639:
1640: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchAllIndBundles.itemtype,
1641: itemkey => LaunchAllIndBundles.itemkey,
1642: aname => 'ORDER_ID');
1643:
1644:

Line 1656: wf_engine.CreateProcess(itemtype => 'XDPPROV',

1652: l_tempKey := to_char(l_OrderID) || '-BUNDLE-' || l_tempKey;
1653:
1654: t_ChildKeys(l_Counter) := l_tempKey;
1655:
1656: wf_engine.CreateProcess(itemtype => 'XDPPROV',
1657: itemkey => t_ChildKeys(l_Counter),
1658: process => 'BUNDLE_PROCESS');
1659:
1660: wf_engine.setItemParent(itemtype => 'XDPPROV',

Line 1660: wf_engine.setItemParent(itemtype => 'XDPPROV',

1656: wf_engine.CreateProcess(itemtype => 'XDPPROV',
1657: itemkey => t_ChildKeys(l_Counter),
1658: process => 'BUNDLE_PROCESS');
1659:
1660: wf_engine.setItemParent(itemtype => 'XDPPROV',
1661: itemkey => t_ChildKeys(l_Counter),
1662: parent_itemtype => itemtype,
1663: parent_itemkey => itemkey,
1664: parent_context => 'WAITFORFLOW-BUNDLE-IND');

Line 1666: wf_engine.SetItemAttrText(itemtype => 'XDPPROV',

1662: parent_itemtype => itemtype,
1663: parent_itemkey => itemkey,
1664: parent_context => 'WAITFORFLOW-BUNDLE-IND');
1665:
1666: wf_engine.SetItemAttrText(itemtype => 'XDPPROV',
1667: itemkey => t_ChildKeys(l_Counter),
1668: aname => 'MASTER_TO_CONTINUE',
1669: avalue => 'WAITFORFLOW-BUNDLE-IND');
1670:

Line 1671: wf_engine.SetItemAttrNumber(itemtype => 'XDPPROV',

1667: itemkey => t_ChildKeys(l_Counter),
1668: aname => 'MASTER_TO_CONTINUE',
1669: avalue => 'WAITFORFLOW-BUNDLE-IND');
1670:
1671: wf_engine.SetItemAttrNumber(itemtype => 'XDPPROV',
1672: itemkey => t_ChildKeys(l_Counter),
1673: aname => 'ORDER_ID',
1674: avalue => l_OrderID);
1675:

Line 1691: wf_engine.StartProcess(itemtype => 'XDPPROV', itemkey => t_ChildKeys(i));

1687: END LOOP;
1688:
1689: for i in 1..l_Counter loop
1690:
1691: wf_engine.StartProcess(itemtype => 'XDPPROV', itemkey => t_ChildKeys(i));
1692: end loop;
1693:
1694: return l_result;
1695:

Line 1770: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcess.itemtype,

1766:
1767: BEGIN
1768:
1769:
1770: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcess.itemtype,
1771: itemkey => LaunchBundleProcess.itemkey,
1772: aname => 'ORDER_ID');
1773:
1774: l_PrevBundleSeq := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcess.itemtype,

Line 1774: l_PrevBundleSeq := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcess.itemtype,

1770: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcess.itemtype,
1771: itemkey => LaunchBundleProcess.itemkey,
1772: aname => 'ORDER_ID');
1773:
1774: l_PrevBundleSeq := wf_engine.GetItemAttrNumber(itemtype => LaunchBundleProcess.itemtype,
1775: itemkey => LaunchBundleProcess.itemkey,
1776: aname => 'CURRENT_BUNDLE_SEQUENCE');
1777:
1778:

Line 1786: wf_engine.CreateProcess(itemtype => 'XDPPROV',

1782:
1783: select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;
1784: l_tempKey := to_char(l_OrderID) || '-BUNDLE-' || to_char(l_LineItemID) || l_tempKey;
1785:
1786: wf_engine.CreateProcess(itemtype => 'XDPPROV',
1787: itemkey => l_tempKey,
1788: process => 'BUNDLE_PROCESS');
1789:
1790: wf_engine.setItemParent(itemtype => 'XDPPROV',

Line 1790: wf_engine.setItemParent(itemtype => 'XDPPROV',

1786: wf_engine.CreateProcess(itemtype => 'XDPPROV',
1787: itemkey => l_tempKey,
1788: process => 'BUNDLE_PROCESS');
1789:
1790: wf_engine.setItemParent(itemtype => 'XDPPROV',
1791: itemkey => l_tempKey,
1792: parent_itemtype => itemtype,
1793: parent_itemkey => itemkey,
1794: parent_context => 'WAITFORFLOW-BUNDLE-DEP');

Line 1796: wf_engine.SetItemAttrNumber(itemtype => 'XDPPROV',

1792: parent_itemtype => itemtype,
1793: parent_itemkey => itemkey,
1794: parent_context => 'WAITFORFLOW-BUNDLE-DEP');
1795:
1796: wf_engine.SetItemAttrNumber(itemtype => 'XDPPROV',
1797: itemkey => l_tempKey,
1798: aname => 'ORDER_ID',
1799: avalue => l_OrderID);
1800:

Line 1801: wf_engine.SetItemAttrText(itemtype => 'XDPPROV',

1797: itemkey => l_tempKey,
1798: aname => 'ORDER_ID',
1799: avalue => l_OrderID);
1800:
1801: wf_engine.SetItemAttrText(itemtype => 'XDPPROV',
1802: itemkey => l_tempKey,
1803: aname => 'MASTER_TO_CONTINUE',
1804: avalue => 'WAITFORFLOW-BUNDLE-DEP');
1805:

Line 1832: wf_engine.StartProcess('XDPPROV', l_tempKey );

1828: raise e_AddAttributeException;
1829: end if;
1830:
1831: --Start the process...
1832: wf_engine.StartProcess('XDPPROV', l_tempKey );
1833:
1834: END LOOP;
1835:
1836: XDPCORE.CheckNAddItemAttrNumber (itemtype => LaunchBundleProcess.itemtype,

Line 1906: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepLinesForBun.itemtype,

1902:
1903:
1904: begin
1905:
1906: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepLinesForBun.itemtype,
1907: itemkey => ResolveIndDepLinesForBun.itemkey,
1908: aname => 'ORDER_ID');
1909:
1910: l_BundleID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepLinesForBun.itemtype,

Line 1910: l_BundleID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepLinesForBun.itemtype,

1906: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepLinesForBun.itemtype,
1907: itemkey => ResolveIndDepLinesForBun.itemkey,
1908: aname => 'ORDER_ID');
1909:
1910: l_BundleID := wf_engine.GetItemAttrNumber(itemtype => ResolveIndDepLinesForBun.itemtype,
1911: itemkey => ResolveIndDepLinesForBun.itemkey,
1912: aname => 'BUNDLE_ID');
1913:
1914: if l_BundleID is null or l_BundleID = -1 then