[Home] [Help]
1075: lv_inventory_item_id :=inventory_item_id;
1076: lv_exception_type := exception_type;
1077: msc_util.msc_debug('Inside the start process');
1078: -- Note that with MSC the unique key is plan_id || exception_id
1079: --wf_engine.threshold := -1;
1080: wf_engine.CreateProcess( itemtype => item_type,
1081: itemkey => item_key,
1082: process => workflow_process);
1083:
1076: lv_exception_type := exception_type;
1077: msc_util.msc_debug('Inside the start process');
1078: -- Note that with MSC the unique key is plan_id || exception_id
1079: --wf_engine.threshold := -1;
1080: wf_engine.CreateProcess( itemtype => item_type,
1081: itemkey => item_key,
1082: process => workflow_process);
1083:
1084: wf_engine.SetItemAttrNumber( itemtype => item_type,
1080: wf_engine.CreateProcess( itemtype => item_type,
1081: itemkey => item_key,
1082: process => workflow_process);
1083:
1084: wf_engine.SetItemAttrNumber( itemtype => item_type,
1085: itemkey => item_key,
1086: aname => 'EXCEPTION_ID',
1087: avalue => l_exception_id);
1088:
1086: aname => 'EXCEPTION_ID',
1087: avalue => l_exception_id);
1088:
1089: if l_exception_id in (37, 28) then
1090: wf_engine.SetItemAttrText( itemtype => item_type,
1091: itemkey => item_key,
1092: aname => 'URL1',
1093: avalue => l_url);
1094: end if;
1227:
1228: end if;
1229:
1230:
1231: wf_engine.SetItemAttrText( itemtype => item_type,
1232: itemkey => item_key,
1233: aname => 'PLAN_NAME',
1234: avalue => compile_designator);
1235:
1232: itemkey => item_key,
1233: aname => 'PLAN_NAME',
1234: avalue => compile_designator);
1235:
1236: wf_engine.SetItemAttrText( itemtype => item_type,
1237: itemkey => item_key,
1238: aname => 'PRE_PRSNG_LEAD_TIME',
1239: avalue => pre_prsng_lead_time);
1240:
1237: itemkey => item_key,
1238: aname => 'PRE_PRSNG_LEAD_TIME',
1239: avalue => pre_prsng_lead_time);
1240:
1241: wf_engine.SetItemAttrText( itemtype => item_type,
1242: itemkey => item_key,
1243: aname => 'PRSNG_LEAD_TIME',
1244: avalue => prsng_lead_time);
1245:
1242: itemkey => item_key,
1243: aname => 'PRSNG_LEAD_TIME',
1244: avalue => prsng_lead_time);
1245:
1246: wf_engine.SetItemAttrText( itemtype => item_type,
1247: itemkey => item_key,
1248: aname => 'POST_PRSNG_LEAD_TIME',
1249: avalue => post_prsng_lead_time);
1250:
1247: itemkey => item_key,
1248: aname => 'POST_PRSNG_LEAD_TIME',
1249: avalue => post_prsng_lead_time);
1250:
1251: wf_engine.SetItemAttrNumber( itemtype => item_type,
1252: itemkey => item_key,
1253: aname => 'ORGANIZATION_ID',
1254: avalue => organization_id);
1255: wf_engine.SetItemAttrNumber( itemtype => item_type,
1251: wf_engine.SetItemAttrNumber( itemtype => item_type,
1252: itemkey => item_key,
1253: aname => 'ORGANIZATION_ID',
1254: avalue => organization_id);
1255: wf_engine.SetItemAttrNumber( itemtype => item_type,
1256: itemkey => item_key,
1257: aname => 'INSTANCE_ID',
1258: avalue => instance_id);
1259: wf_engine.SetItemAttrNumber( itemtype => item_type,
1255: wf_engine.SetItemAttrNumber( itemtype => item_type,
1256: itemkey => item_key,
1257: aname => 'INSTANCE_ID',
1258: avalue => instance_id);
1259: wf_engine.SetItemAttrNumber( itemtype => item_type,
1260: itemkey => item_key,
1261: aname => 'INVENTORY_ITEM_ID',
1262: avalue => inventory_item_id);
1263: wf_engine.SetItemAttrNumber( itemtype => item_type,
1259: wf_engine.SetItemAttrNumber( itemtype => item_type,
1260: itemkey => item_key,
1261: aname => 'INVENTORY_ITEM_ID',
1262: avalue => inventory_item_id);
1263: wf_engine.SetItemAttrNumber( itemtype => item_type,
1264: itemkey => item_key,
1265: aname => 'EXCEPTION_TYPE_ID',
1266: avalue => exception_type);
1267: wf_engine.SetItemAttrNumber( itemtype => item_type,
1263: wf_engine.SetItemAttrNumber( itemtype => item_type,
1264: itemkey => item_key,
1265: aname => 'EXCEPTION_TYPE_ID',
1266: avalue => exception_type);
1267: wf_engine.SetItemAttrNumber( itemtype => item_type,
1268: itemkey => item_key,
1269: aname => 'TRANSACTION_ID',
1270: avalue => transaction_id);
1271: wf_engine.SetItemAttrText( itemtype => item_type,
1267: wf_engine.SetItemAttrNumber( itemtype => item_type,
1268: itemkey => item_key,
1269: aname => 'TRANSACTION_ID',
1270: avalue => transaction_id);
1271: wf_engine.SetItemAttrText( itemtype => item_type,
1272: itemkey => item_key,
1273: aname => 'ORGANIZATION_CODE',
1274: avalue => organization_code);
1275: wf_engine.SetItemAttrText( itemtype => item_type,
1271: wf_engine.SetItemAttrText( itemtype => item_type,
1272: itemkey => item_key,
1273: aname => 'ORGANIZATION_CODE',
1274: avalue => organization_code);
1275: wf_engine.SetItemAttrText( itemtype => item_type,
1276: itemkey => item_key,
1277: aname => 'ITEM_DISPLAY_NAME',
1278: avalue => item_segments);
1279: wf_engine.SetItemAttrText( itemtype => item_type,
1275: wf_engine.SetItemAttrText( itemtype => item_type,
1276: itemkey => item_key,
1277: aname => 'ITEM_DISPLAY_NAME',
1278: avalue => item_segments);
1279: wf_engine.SetItemAttrText( itemtype => item_type,
1280: itemkey => item_key,
1281: aname => 'ITEM_DESCRIPTION',
1282: avalue => item_description);
1283: wf_engine.SetItemAttrText( itemtype => item_type,
1279: wf_engine.SetItemAttrText( itemtype => item_type,
1280: itemkey => item_key,
1281: aname => 'ITEM_DESCRIPTION',
1282: avalue => item_description);
1283: wf_engine.SetItemAttrText( itemtype => item_type,
1284: itemkey => item_key,
1285: aname => 'EXCEPTION_DESCRIPTION',
1286: avalue => exception_type_text);
1287: wf_engine.SetItemAttrText( itemtype => item_type,
1283: wf_engine.SetItemAttrText( itemtype => item_type,
1284: itemkey => item_key,
1285: aname => 'EXCEPTION_DESCRIPTION',
1286: avalue => exception_type_text);
1287: wf_engine.SetItemAttrText( itemtype => item_type,
1288: itemkey => item_key,
1289: aname => 'PROJECT_NUMBER',
1290: avalue => project_number);
1291: wf_engine.SetItemAttrText( itemtype => item_type,
1287: wf_engine.SetItemAttrText( itemtype => item_type,
1288: itemkey => item_key,
1289: aname => 'PROJECT_NUMBER',
1290: avalue => project_number);
1291: wf_engine.SetItemAttrText( itemtype => item_type,
1292: itemkey => item_key,
1293: aname => 'TO_PROJECT_NUMBER',
1294: avalue => to_project_number);
1295: wf_engine.SetItemAttrText( itemtype => item_type,
1291: wf_engine.SetItemAttrText( itemtype => item_type,
1292: itemkey => item_key,
1293: aname => 'TO_PROJECT_NUMBER',
1294: avalue => to_project_number);
1295: wf_engine.SetItemAttrText( itemtype => item_type,
1296: itemkey => item_key,
1297: aname => 'TASK_NUMBER',
1298: avalue => task_number);
1299: wf_engine.SetItemAttrText( itemtype => item_type,
1295: wf_engine.SetItemAttrText( itemtype => item_type,
1296: itemkey => item_key,
1297: aname => 'TASK_NUMBER',
1298: avalue => task_number);
1299: wf_engine.SetItemAttrText( itemtype => item_type,
1300: itemkey => item_key,
1301: aname => 'TO_TASK_NUMBER',
1302: avalue => to_task_number);
1303: wf_engine.SetItemAttrText( itemtype => item_type,
1299: wf_engine.SetItemAttrText( itemtype => item_type,
1300: itemkey => item_key,
1301: aname => 'TO_TASK_NUMBER',
1302: avalue => to_task_number);
1303: wf_engine.SetItemAttrText( itemtype => item_type,
1304: itemkey => item_key,
1305: aname => 'PLANNING_GROUP',
1306: avalue => planning_group);
1307: wf_engine.SetItemAttrNumber( itemtype => item_type,
1303: wf_engine.SetItemAttrText( itemtype => item_type,
1304: itemkey => item_key,
1305: aname => 'PLANNING_GROUP',
1306: avalue => planning_group);
1307: wf_engine.SetItemAttrNumber( itemtype => item_type,
1308: itemkey => item_key,
1309: aname => 'QTY_RELATED_VALUES',
1310: avalue => qty_related_values);
1311:
1308: itemkey => item_key,
1309: aname => 'QTY_RELATED_VALUES',
1310: avalue => qty_related_values);
1311:
1312: wf_engine.SetItemAttrDate( itemtype => item_type,
1313: itemkey => item_key,
1314: aname => 'DUE_DATE',
1315: avalue => due_date);
1316:
1313: itemkey => item_key,
1314: aname => 'DUE_DATE',
1315: avalue => due_date);
1316:
1317: wf_engine.SetItemAttrDate( itemtype => item_type,
1318: itemkey => item_key,
1319: aname => 'FROM_DATE',
1320: avalue => from_date);
1321:
1318: itemkey => item_key,
1319: aname => 'FROM_DATE',
1320: avalue => from_date);
1321:
1322: wf_engine.SetItemAttrDate( itemtype => item_type,
1323: itemkey => item_key,
1324: aname => 'TO_DATE',
1325: avalue => p_to_date);
1326:
1323: itemkey => item_key,
1324: aname => 'TO_DATE',
1325: avalue => p_to_date);
1326:
1327: wf_engine.SetItemAttrNumber( itemtype => item_type,
1328: itemkey => item_key,
1329: aname => 'DAYS_COMPRESSED',
1330: avalue => days_compressed);
1331: wf_engine.SetItemAttrText( itemtype => item_type,
1327: wf_engine.SetItemAttrNumber( itemtype => item_type,
1328: itemkey => item_key,
1329: aname => 'DAYS_COMPRESSED',
1330: avalue => days_compressed);
1331: wf_engine.SetItemAttrText( itemtype => item_type,
1332: itemkey => item_key,
1333: aname => 'QUANTITY',
1334: avalue => quantity);
1335:
1332: itemkey => item_key,
1333: aname => 'QUANTITY',
1334: avalue => quantity);
1335:
1336: wf_engine.SetItemAttrText( itemtype => item_type,
1337: itemkey => item_key,
1338: aname => 'LOT_NUMBER',
1339: avalue => lot_number);
1340:
1337: itemkey => item_key,
1338: aname => 'LOT_NUMBER',
1339: avalue => lot_number);
1340:
1341: wf_engine.SetItemAttrText( itemtype => item_type,
1342: itemkey => item_key,
1343: aname => 'ORDER_NUMBER',
1344: avalue => order_number);
1345:
1342: itemkey => item_key,
1343: aname => 'ORDER_NUMBER',
1344: avalue => order_number);
1345:
1346: wf_engine.SetItemAttrNumber( itemtype => item_type,
1347: itemkey => item_key,
1348: aname => 'ORDER_TYPE_CODE',
1349: avalue => order_type_code);
1350:
1347: itemkey => item_key,
1348: aname => 'ORDER_TYPE_CODE',
1349: avalue => order_type_code);
1350:
1351: wf_engine.SetItemAttrText( itemtype => item_type,
1352: itemkey => item_key,
1353: aname => 'SUPPLY_TYPE',
1354: avalue => supply_type);
1355:
1352: itemkey => item_key,
1353: aname => 'SUPPLY_TYPE',
1354: avalue => supply_type);
1355:
1356: wf_engine.SetItemAttrText( itemtype => item_type,
1357: itemkey => item_key,
1358: aname => 'END_ITEM_DISPLAY_NAME',
1359: avalue => end_item_segments);
1360:
1357: itemkey => item_key,
1358: aname => 'END_ITEM_DISPLAY_NAME',
1359: avalue => end_item_segments);
1360:
1361: wf_engine.SetItemAttrText( itemtype => item_type,
1362: itemkey => item_key,
1363: aname => 'END_ITEM_DESCRIPTION',
1364: avalue => end_item_description);
1365:
1362: itemkey => item_key,
1363: aname => 'END_ITEM_DESCRIPTION',
1364: avalue => end_item_description);
1365:
1366: wf_engine.SetItemAttrText( itemtype => item_type,
1367: itemkey => item_key,
1368: aname => 'END_ORDER_NUMBER',
1369: avalue => end_order_number);
1370:
1367: itemkey => item_key,
1368: aname => 'END_ORDER_NUMBER',
1369: avalue => end_order_number);
1370:
1371: wf_engine.SetItemAttrText( itemtype => item_type,
1372: itemkey => item_key,
1373: aname => 'DEPARTMENT_LINE_CODE',
1374: avalue => department_line_code);
1375:
1372: itemkey => item_key,
1373: aname => 'DEPARTMENT_LINE_CODE',
1374: avalue => department_line_code);
1375:
1376: wf_engine.SetItemAttrText( itemtype => item_type,
1377: itemkey => item_key,
1378: aname => 'RESOURCE_CODE',
1379: avalue => resource_code);
1380:
1377: itemkey => item_key,
1378: aname => 'RESOURCE_CODE',
1379: avalue => resource_code);
1380:
1381: wf_engine.SetItemAttrNumber( itemtype => item_type,
1382: itemkey => item_key,
1383: aname => 'UTILIZATION_RATE',
1384: avalue => utilization_rate);
1385:
1391: lv_cap_req:=utilization_rate/100;
1392: end if;
1393:
1394:
1395: wf_engine.SetItemAttrNumber( itemtype => item_type,
1396: itemkey => item_key,
1397: aname => 'CAPACITY_REQUIREMENT',
1398: avalue => lv_cap_req);
1399:
1397: aname => 'CAPACITY_REQUIREMENT',
1398: avalue => lv_cap_req);
1399:
1400:
1401: wf_engine.SetItemAttrNumber( itemtype => item_type,
1402: itemkey => item_key,
1403: aname => 'REQUIRED_QUANTITY',
1404: avalue => lv_req_quantity);
1405:
1403: aname => 'REQUIRED_QUANTITY',
1404: avalue => lv_req_quantity);
1405:
1406:
1407: wf_engine.SetItemAttrNumber( itemtype => item_type,
1408: itemkey => item_key,
1409: aname => 'AVAILABLE_QUANTITY',
1410: avalue => lv_ava_quantity);
1411:
1408: itemkey => item_key,
1409: aname => 'AVAILABLE_QUANTITY',
1410: avalue => lv_ava_quantity);
1411:
1412: wf_engine.SetItemAttrNumber( itemtype => item_type,
1413: itemkey => item_key,
1414: aname => 'PROJECTED_AVAILABLE_BALANCE',
1415: avalue => lv_pab);
1416:
1414: aname => 'PROJECTED_AVAILABLE_BALANCE',
1415: avalue => lv_pab);
1416:
1417:
1418: wf_engine.SetItemAttrNumber( itemtype => item_type,
1419: itemkey => item_key,
1420: aname => 'SUPPLIER_ID',
1421: avalue => supplier_id);
1422:
1419: itemkey => item_key,
1420: aname => 'SUPPLIER_ID',
1421: avalue => supplier_id);
1422:
1423: wf_engine.SetItemAttrText( itemtype => item_type,
1424: itemkey => item_key,
1425: aname => 'SUPPLIER_NAME',
1426: avalue => supplier_name);
1427:
1424: itemkey => item_key,
1425: aname => 'SUPPLIER_NAME',
1426: avalue => supplier_name);
1427:
1428: wf_engine.SetItemAttrNumber( itemtype => item_type,
1429: itemkey => item_key,
1430: aname => 'SUPPLIER_SITE_ID',
1431: avalue => supplier_site_id);
1432:
1429: itemkey => item_key,
1430: aname => 'SUPPLIER_SITE_ID',
1431: avalue => supplier_site_id);
1432:
1433: wf_engine.SetItemAttrText( itemtype => item_type,
1434: itemkey => item_key,
1435: aname => 'SUPPLIER_SITE_CODE',
1436: avalue => supplier_site_code);
1437:
1434: itemkey => item_key,
1435: aname => 'SUPPLIER_SITE_CODE',
1436: avalue => supplier_site_code);
1437:
1438: wf_engine.SetItemAttrNumber( itemtype => item_type,
1439: itemkey => item_key,
1440: aname => 'CUSTOMER_ID',
1441: avalue => customer_id);
1442:
1439: itemkey => item_key,
1440: aname => 'CUSTOMER_ID',
1441: avalue => customer_id);
1442:
1443: wf_engine.SetItemAttrText( itemtype => item_type,
1444: itemkey => item_key,
1445: aname => 'CUSTOMER_NAME',
1446: avalue => customer_name);
1447:
1444: itemkey => item_key,
1445: aname => 'CUSTOMER_NAME',
1446: avalue => customer_name);
1447:
1448: wf_engine.SetItemAttrText( itemtype => item_type,
1449: itemkey => item_key,
1450: aname => 'PLANNER_WORKBENCH',
1451: avalue => (workbench_function||
1452: ': instance_id=' || instance_id ||
1452: ': instance_id=' || instance_id ||
1453: ' org_id=' ||
1454: to_char(organization_id)) );
1455:
1456: wf_engine.SetItemAttrNumber( itemtype => item_type,
1457: itemkey => item_key,
1458: aname => 'PLAN_ID',
1459: avalue => p_plan_id);
1460:
1457: itemkey => item_key,
1458: aname => 'PLAN_ID',
1459: avalue => p_plan_id);
1460:
1461: wf_engine.SetItemAttrText( itemtype => item_type,
1462: itemkey => item_key,
1463: aname => 'DB_LINK',
1464: avalue => db_link);
1465:
1462: itemkey => item_key,
1463: aname => 'DB_LINK',
1464: avalue => db_link);
1465:
1466: wf_engine.SetItemAttrText( itemtype => item_type,
1467: itemkey => item_key,
1468: aname => 'APPS_PS_DBLINK',
1469: avalue => l_a2m_db_link);
1470:
1472: OPEN SO_C;
1473: FETCH SO_C INTO so_rec;
1474: CLOSE SO_C;
1475:
1476: wf_engine.SetItemAttrNumber( itemtype => item_type,
1477: itemkey => item_key,
1478: aname => 'TRANSACTION_ID',
1479: avalue => so_rec.demand_id);
1480: wf_engine.SetItemAttrNumber( itemtype => item_type,
1476: wf_engine.SetItemAttrNumber( itemtype => item_type,
1477: itemkey => item_key,
1478: aname => 'TRANSACTION_ID',
1479: avalue => so_rec.demand_id);
1480: wf_engine.SetItemAttrNumber( itemtype => item_type,
1481: itemkey => item_key,
1482: aname => 'PRE_PRSNG_LEAD_TIME',
1483: avalue => so_rec.old_lead_time);
1484:
1481: itemkey => item_key,
1482: aname => 'PRE_PRSNG_LEAD_TIME',
1483: avalue => so_rec.old_lead_time);
1484:
1485: wf_engine.SetItemAttrNumber( itemtype => item_type,
1486: itemkey => item_key,
1487: aname => 'POST_PRSNG_LEAD_TIME',
1488: avalue => so_rec.new_lead_time);
1489:
1486: itemkey => item_key,
1487: aname => 'POST_PRSNG_LEAD_TIME',
1488: avalue => so_rec.new_lead_time);
1489:
1490: wf_engine.SetItemAttrText( itemtype => item_type,
1491: itemkey => item_key,
1492: aname => 'ORGANIZATION_CODE',
1493: avalue => so_rec.org_code);
1494: wf_engine.SetItemAttrText( itemtype => item_type,
1490: wf_engine.SetItemAttrText( itemtype => item_type,
1491: itemkey => item_key,
1492: aname => 'ORGANIZATION_CODE',
1493: avalue => so_rec.org_code);
1494: wf_engine.SetItemAttrText( itemtype => item_type,
1495: itemkey => item_key,
1496: aname => 'DEPARTMENT_LINE_CODE',
1497: avalue => so_rec.to_org);
1498: wf_engine.SetItemAttrDate( itemtype => item_type,
1494: wf_engine.SetItemAttrText( itemtype => item_type,
1495: itemkey => item_key,
1496: aname => 'DEPARTMENT_LINE_CODE',
1497: avalue => so_rec.to_org);
1498: wf_engine.SetItemAttrDate( itemtype => item_type,
1499: itemkey => item_key,
1500: aname => 'FROM_DATE',
1501: avalue => so_rec.old_ship_date);
1502:
1499: itemkey => item_key,
1500: aname => 'FROM_DATE',
1501: avalue => so_rec.old_ship_date);
1502:
1503: wf_engine.SetItemAttrDate( itemtype => item_type,
1504: itemkey => item_key,
1505: aname => 'TO_DATE',
1506: avalue => so_rec.new_ship_date);
1507:
1504: itemkey => item_key,
1505: aname => 'TO_DATE',
1506: avalue => so_rec.new_ship_date);
1507:
1508: wf_engine.SetItemAttrDate( itemtype => item_type,
1509: itemkey => item_key,
1510: aname => 'DATE1',
1511: avalue => so_rec.old_arrival_date);
1512:
1509: itemkey => item_key,
1510: aname => 'DATE1',
1511: avalue => so_rec.old_arrival_date);
1512:
1513: wf_engine.SetItemAttrDate( itemtype => item_type,
1514: itemkey => item_key,
1515: aname => 'DATE2',
1516: avalue => so_rec.new_arrival_date);
1517:
1515: aname => 'DATE2',
1516: avalue => so_rec.new_arrival_date);
1517:
1518:
1519: wf_engine.SetItemAttrDate( itemtype => item_type,
1520: itemkey => item_key,
1521: aname => 'DATE3',
1522: avalue => so_rec.promise_arrival_date);
1523:
1520: itemkey => item_key,
1521: aname => 'DATE3',
1522: avalue => so_rec.promise_arrival_date);
1523:
1524: wf_engine.SetItemAttrDate( itemtype => item_type,
1525: itemkey => item_key,
1526: aname => 'DATE4',
1527: avalue => so_rec.promise_ship_date);
1528:
1525: itemkey => item_key,
1526: aname => 'DATE4',
1527: avalue => so_rec.promise_ship_date);
1528:
1529: wf_engine.SetItemAttrDate( itemtype => item_type,
1530: itemkey => item_key,
1531: aname => 'DATE5',
1532: avalue => so_rec.request_arrival_date);
1533:
1530: itemkey => item_key,
1531: aname => 'DATE5',
1532: avalue => so_rec.request_arrival_date);
1533:
1534: wf_engine.SetItemAttrDate( itemtype => item_type,
1535: itemkey => item_key,
1536: aname => 'DATE6',
1537: avalue => so_rec.request_ship_date);
1538:
1536: aname => 'DATE6',
1537: avalue => so_rec.request_ship_date);
1538:
1539:
1540: wf_engine.SetItemAttrDate( itemtype => item_type,
1541: itemkey => item_key,
1542: aname => 'DUE_DATE',
1543: avalue => so_rec.latest_acceptable_date);
1544: wf_engine.SetItemAttrText( itemtype => item_type,
1540: wf_engine.SetItemAttrDate( itemtype => item_type,
1541: itemkey => item_key,
1542: aname => 'DUE_DATE',
1543: avalue => so_rec.latest_acceptable_date);
1544: wf_engine.SetItemAttrText( itemtype => item_type,
1545: itemkey => item_key,
1546: aname => 'RESOURCE_CODE',
1547: avalue => so_rec.customer_site);
1548:
1545: itemkey => item_key,
1546: aname => 'RESOURCE_CODE',
1547: avalue => so_rec.customer_site);
1548:
1549: wf_engine.SetItemAttrText( itemtype => item_type,
1550: itemkey => item_key,
1551: aname => 'SUPPLIER_NAME',
1552: avalue => so_rec.old_ship_method);
1553:
1550: itemkey => item_key,
1551: aname => 'SUPPLIER_NAME',
1552: avalue => so_rec.old_ship_method);
1553:
1554: wf_engine.SetItemAttrText( itemtype => item_type,
1555: itemkey => item_key,
1556: aname => 'SUPPLIER_SITE_CODE',
1557: avalue => so_rec.new_ship_method);
1558:
1555: itemkey => item_key,
1556: aname => 'SUPPLIER_SITE_CODE',
1557: avalue => so_rec.new_ship_method);
1558:
1559: wf_engine.SetItemAttrText( itemtype => item_type,
1560: itemkey => item_key,
1561: aname => 'PLANNING_GROUP',
1562: avalue => so_rec.atp_override_flag);
1563:
1563:
1564: end if; -- end of if (lv_exception_type = 70)
1565: msc_util.msc_debug('Before start process:'|| item_type || ':' || item_key);
1566:
1567: wf_engine.StartProcess( itemtype => item_type,
1568: itemkey => item_key);
1569:
1570:
1571: EXCEPTION
1585: funcmode in varchar2,
1586: resultout out NOCOPY varchar2 ) is
1587:
1588: l_sr_status varchar2(10) :=
1589: wf_engine.GetItemAttrText( itemtype => itemtype,
1590: itemkey => itemkey,
1591: aname => 'SR_RESULT');
1592:
1593: l_organization_id number :=
1590: itemkey => itemkey,
1591: aname => 'SR_RESULT');
1592:
1593: l_organization_id number :=
1594: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1595: itemkey => itemkey,
1596: aname => 'ORGANIZATION_ID');
1597:
1598: l_inventory_item_id number :=
1595: itemkey => itemkey,
1596: aname => 'ORGANIZATION_ID');
1597:
1598: l_inventory_item_id number :=
1599: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1600: itemkey => itemkey,
1601: aname => 'INVENTORY_ITEM_ID');
1602:
1603: l_plan_id number :=
1600: itemkey => itemkey,
1601: aname => 'INVENTORY_ITEM_ID');
1602:
1603: l_plan_id number :=
1604: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1605: itemkey => itemkey,
1606: aname => 'PLAN_ID');
1607:
1608: l_instance_id number :=
1605: itemkey => itemkey,
1606: aname => 'PLAN_ID');
1607:
1608: l_instance_id number :=
1609: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1610: itemkey => itemkey,
1611: aname => 'INSTANCE_ID');
1612:
1613: l_exception_type number :=
1610: itemkey => itemkey,
1611: aname => 'INSTANCE_ID');
1612:
1613: l_exception_type number :=
1614: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1615: itemkey => itemkey,
1616: aname => 'EXCEPTION_TYPE_ID');
1617:
1618: l_order_type number :=
1615: itemkey => itemkey,
1616: aname => 'EXCEPTION_TYPE_ID');
1617:
1618: l_order_type number :=
1619: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1620: itemkey => itemkey,
1621: aname => 'ORDER_TYPE_CODE');
1622:
1623: l_stage number :=
1620: itemkey => itemkey,
1621: aname => 'ORDER_TYPE_CODE');
1622:
1623: l_stage number :=
1624: wf_engine.GetActivityAttrNumber( itemtype => itemtype,
1625: itemkey => itemkey,
1626: actid => actid,
1627: aname => 'STAGE');
1628:
1645: l_planner := FND_GLOBAL.USER_NAME;
1646: FND_FILE.PUT_LINE(FND_FILE.LOG,'no planner defined for this item, sent notification to '||l_planner);
1647: end if;
1648:
1649: wf_engine.SetItemAttrText( itemtype => itemtype,
1650: itemkey => itemkey,
1651: aname => 'PLANNER',
1652: avalue => l_planner);
1653: else
1651: aname => 'PLANNER',
1652: avalue => l_planner);
1653: else
1654: l_planner :=
1655: wf_engine.GetItemAttrText( itemtype => itemtype,
1656: itemkey => itemkey,
1657: aname => 'PLANNER');
1658: end if;
1659: msc_util.msc_debug('planner:'||l_planner);
1662: l_msg := GetPlannerMsgName(l_exception_type,
1663: l_order_type,
1664: l_stage,
1665: l_sr_status);
1666: wf_engine.SetItemAttrText( itemtype => itemtype,
1667: itemkey => itemkey,
1668: aname => 'MESSAGE_NAME',
1669: avalue => l_msg);
1670: msc_util.msc_debug('msg name:'||l_msg);
1843: funcmode in varchar2,
1844: resultout out NOCOPY varchar2) is
1845:
1846: l_exception_id number :=
1847: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1848: itemkey => itemkey,
1849: aname => 'EXCEPTION_ID');
1850:
1851: l_order_type number :=
1848: itemkey => itemkey,
1849: aname => 'EXCEPTION_ID');
1850:
1851: l_order_type number :=
1852: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1853: itemkey => itemkey,
1854: aname => 'ORDER_TYPE_CODE');
1855:
1856:
1913: funcmode in varchar2,
1914: resultout out NOCOPY varchar2) is
1915:
1916: l_plan_id number :=
1917: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1918: itemkey => itemkey,
1919: aname => 'PLAN_ID');
1920:
1921: l_transaction_id number :=
1918: itemkey => itemkey,
1919: aname => 'PLAN_ID');
1920:
1921: l_transaction_id number :=
1922: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1923: itemkey => itemkey,
1924: aname => 'TRANSACTION_ID');
1925: l_exception_type number :=
1926: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1922: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1923: itemkey => itemkey,
1924: aname => 'TRANSACTION_ID');
1925: l_exception_type number :=
1926: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1927: itemkey => itemkey,
1928: aname => 'EXCEPTION_TYPE_ID');
1929:
1930: l_order_type number :=
1927: itemkey => itemkey,
1928: aname => 'EXCEPTION_TYPE_ID');
1929:
1930: l_order_type number :=
1931: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1932: itemkey => itemkey,
1933: aname => 'ORDER_TYPE_CODE');
1934: l_planner varchar2(200) :=
1935: wf_engine.GetItemAttrText( itemtype => itemtype,
1931: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1932: itemkey => itemkey,
1933: aname => 'ORDER_TYPE_CODE');
1934: l_planner varchar2(200) :=
1935: wf_engine.GetItemAttrText( itemtype => itemtype,
1936: itemkey => itemkey,
1937: aname => 'PLANNER');
1938: p_request_id number;
1939: begin
1955: commit;
1956: exception when others then
1957: p_request_id :=0;
1958: end;
1959: wf_engine.SetItemAttrNumber( itemtype => itemtype,
1960: itemkey => itemkey,
1961: aname => 'SR_REQUEST_ID',
1962: avalue => p_request_id);
1963:
2419: actid in number,
2420: funcmode in varchar2,
2421: resultout out NOCOPY varchar2) is
2422: l_is_callback varchar2(3) :=
2423: wf_engine.GetItemAttrText( itemtype => itemtype,
2424: itemkey => itemkey,
2425: aname => 'IS_CALL_BACK');
2426:
2427: BEGIN
2529:
2530:
2531:
2532: l_exception_type number :=
2533: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2534: itemkey => itemkey,
2535: aname => 'EXCEPTION_TYPE_ID');
2536:
2537: l_demand_id number :=
2534: itemkey => itemkey,
2535: aname => 'EXCEPTION_TYPE_ID');
2536:
2537: l_demand_id number :=
2538: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2539: itemkey => itemkey,
2540: aname => 'TRANSACTION_ID');
2541:
2542: l_order_type number :=
2539: itemkey => itemkey,
2540: aname => 'TRANSACTION_ID');
2541:
2542: l_order_type number :=
2543: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2544: itemkey => itemkey,
2545: aname => 'ORDER_TYPE_CODE');
2546:
2547: l_inventory_item_id number :=
2544: itemkey => itemkey,
2545: aname => 'ORDER_TYPE_CODE');
2546:
2547: l_inventory_item_id number :=
2548: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2549: itemkey => itemkey,
2550: aname => 'INVENTORY_ITEM_ID');
2551:
2552: l_plan_id number :=
2549: itemkey => itemkey,
2550: aname => 'INVENTORY_ITEM_ID');
2551:
2552: l_plan_id number :=
2553: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2554: itemkey => itemkey,
2555: aname => 'PLAN_ID');
2556:
2557: l_org_id number :=
2554: itemkey => itemkey,
2555: aname => 'PLAN_ID');
2556:
2557: l_org_id number :=
2558: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2559: itemkey => itemkey,
2560: aname => 'ORGANIZATION_ID');
2561:
2562: l_instance_id number :=
2559: itemkey => itemkey,
2560: aname => 'ORGANIZATION_ID');
2561:
2562: l_instance_id number :=
2563: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2564: itemkey => itemkey,
2565: aname => 'INSTANCE_ID');
2566:
2567: l_from_project_number varchar2(100) :=
2564: itemkey => itemkey,
2565: aname => 'INSTANCE_ID');
2566:
2567: l_from_project_number varchar2(100) :=
2568: wf_engine.GetItemAttrText( itemtype => itemtype,
2569: itemkey => itemkey,
2570: aname => 'PROJECT_NUMBER');
2571:
2572: l_to_project_number varchar2(100) :=
2569: itemkey => itemkey,
2570: aname => 'PROJECT_NUMBER');
2571:
2572: l_to_project_number varchar2(100) :=
2573: wf_engine.GetItemAttrText( itemtype => itemtype,
2574: itemkey => itemkey,
2575: aname => 'TO_PROJECT_NUMBER');
2576:
2577: l_from_task_number varchar2(100) :=
2574: itemkey => itemkey,
2575: aname => 'TO_PROJECT_NUMBER');
2576:
2577: l_from_task_number varchar2(100) :=
2578: wf_engine.GetItemAttrText( itemtype => itemtype,
2579: itemkey => itemkey,
2580: aname => 'TASK_NUMBER');
2581:
2582: l_to_task_number varchar2(100) :=
2579: itemkey => itemkey,
2580: aname => 'TASK_NUMBER');
2581:
2582: l_to_task_number varchar2(100) :=
2583: wf_engine.GetItemAttrText( itemtype => itemtype,
2584: itemkey => itemkey,
2585: aname => 'TO_TASK_NUMBER');
2586:
2587: l_exception_id number :=
2584: itemkey => itemkey,
2585: aname => 'TO_TASK_NUMBER');
2586:
2587: l_exception_id number :=
2588: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2589: itemkey => itemkey,
2590: aname => 'EXCEPTION_ID');
2591:
2592: l_buyer varchar2(30);
2628:
2629: --l_buyer := 'MFG';
2630:
2631: if (l_buyer is not null) then
2632: wf_engine.setItemAttrText( itemtype => itemtype,
2633: itemkey => itemkey,
2634: aname => 'BUYER',
2635: avalue => l_buyer);
2636: END IF;
2645:
2646: -- l_supcnt := 'MFG';
2647:
2648: if (l_supcnt is not null) then
2649: wf_engine.setItemAttrText( itemtype => itemtype,
2650: itemkey => itemkey,
2651: aname => 'SUPCNT',
2652: avalue => l_supcnt);
2653: END IF;
2665: end if;
2666:
2667: -- l_salesrep := '1208';
2668: if (l_salesrep is not null) then
2669: wf_engine.setItemAttrText( itemtype => itemtype,
2670: itemkey => itemkey,
2671: aname => 'SALESREP',
2672: avalue => l_salesrep);
2673: END IF;
2683: end if;
2684: -- l_custcnt := 'MFG';
2685:
2686: if (l_custcnt is not null) then
2687: wf_engine.setItemAttrText( itemtype => itemtype,
2688: itemkey => itemkey,
2689: aname => 'CUSTCNT',
2690: avalue => l_custcnt);
2691: END IF;
2705: end if;
2706: --l_from_prj_mgr := 'MFG';
2707:
2708: if (l_from_prj_mgr is not null) then
2709: wf_engine.setItemAttrText( itemtype => itemtype,
2710: itemkey => itemkey,
2711: aname => 'FROM_PRJ_MGR',
2712: avalue => l_from_prj_mgr);
2713: END IF;
2725: end if;
2726:
2727: --l_to_prj_mgr := 'MFG';
2728: if (l_to_prj_mgr is not null) then
2729: wf_engine.setItemAttrText( itemtype => itemtype,
2730: itemkey => itemkey,
2731: aname => 'TO_PRJ_MGR',
2732: avalue => l_to_prj_mgr);
2733: END IF;
2762: funcmode in varchar2,
2763: resultout out NOCOPY varchar2) is
2764:
2765: l_planner varchar2(20) :=
2766: wf_engine.GetItemAttrText( itemtype => itemtype,
2767: itemkey => itemkey,
2768: aname => 'PLANNER');
2769: l_buyer varchar2(50) :=
2770: wf_engine.GetItemAttrText( itemtype => itemtype,
2766: wf_engine.GetItemAttrText( itemtype => itemtype,
2767: itemkey => itemkey,
2768: aname => 'PLANNER');
2769: l_buyer varchar2(50) :=
2770: wf_engine.GetItemAttrText( itemtype => itemtype,
2771: itemkey => itemkey,
2772: aname => 'BUYER');
2773: BEGIN
2774: if (funcmode = 'RUN') then
2803: funcmode in varchar2,
2804: resultout out NOCOPY varchar2) is
2805:
2806: l_db_link varchar2(30) :=
2807: wf_engine.GetItemAttrText( itemtype => itemtype,
2808: itemkey => itemkey,
2809: aname => 'DB_LINK');
2810:
2811: l_exception_type number :=
2808: itemkey => itemkey,
2809: aname => 'DB_LINK');
2810:
2811: l_exception_type number :=
2812: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2813: itemkey => itemkey,
2814: aname => 'EXCEPTION_TYPE_ID');
2815:
2816: l_transaction_id number :=
2813: itemkey => itemkey,
2814: aname => 'EXCEPTION_TYPE_ID');
2815:
2816: l_transaction_id number :=
2817: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2818: itemkey => itemkey,
2819: aname => 'TRANSACTION_ID');
2820:
2821: l_order_type number :=
2818: itemkey => itemkey,
2819: aname => 'TRANSACTION_ID');
2820:
2821: l_order_type number :=
2822: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2823: itemkey => itemkey,
2824: aname => 'ORDER_TYPE_CODE');
2825:
2826: l_sr_item_type varchar2(50) := 'MRPEXWFS';
2849: l_sr_process := 'MSC_PRJ_SR_PROCESS';
2850: end if;
2851: l_sr_item_key := itemkey || '-' || l_sr_process;
2852:
2853: sql_stmt := 'begin wf_engine.CreateProcess' || l_db_link ||
2854: '( itemtype => :l_itemtype,' ||
2855: 'itemkey => :l_itemkey, ' ||
2856: 'process => :l_process);end;';
2857: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type, l_sr_item_key,
2861: -- we could only copy those insterested attributes,
2862: -- but we copy all for debug purpose.
2863:
2864: -- ORDER_TYPE_CODE
2865: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2866: '(itemtype => :item_type,' ||
2867: ' itemkey => :item_key,' ||
2868: ' aname => ''ORDER_TYPE_CODE'',' ||
2869: ' avalue => :l_numb);end;';
2869: ' avalue => :l_numb);end;';
2870: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_order_type;
2871:
2872: -- EXCEPTION_TYPE_ID.
2873: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2874: '(itemtype => :item_type,' ||
2875: ' itemkey => :item_key,' ||
2876: ' aname => ''EXCEPTION_TYPE_ID'',' ||
2877: ' avalue => :l_numb);end;';
2877: ' avalue => :l_numb);end;';
2878: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_exception_type;
2879:
2880:
2881: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2882: '(itemtype => :item_type,' ||
2883: ' itemkey => :item_key,' ||
2884: ' aname => ''TRANSACTION_ID'',' ||
2885: ' avalue => :l_numb);end;';
2885: ' avalue => :l_numb);end;';
2886: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_transaction_id;
2887:
2888: -- APPS_PS_DBLINK
2889: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2890: '(itemtype => :item_type,' ||
2891: ' itemkey => :item_key,' ||
2892: ' aname => ''APPS_PS_DBLINK'',' ||
2893: ' avalue => :l_text);end;';
2893: ' avalue => :l_text);end;';
2894: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_db_link;
2895:
2896: --BUYER. we don't need to set back BUYER, set it for debug
2897: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2898: itemkey => itemkey,
2899: aname => 'BUYER');
2900: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2901: '(itemtype => :item_type,' ||
2896: --BUYER. we don't need to set back BUYER, set it for debug
2897: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2898: itemkey => itemkey,
2899: aname => 'BUYER');
2900: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2901: '(itemtype => :item_type,' ||
2902: ' itemkey => :item_key,' ||
2903: ' aname => ''BUYER'',' ||
2904: ' avalue => :l_text);end;';
2903: ' aname => ''BUYER'',' ||
2904: ' avalue => :l_text);end;';
2905: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2906:
2907: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2908: itemkey => itemkey,
2909: aname => 'SALESREP');
2910: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2911: '(itemtype => :item_type,' ||
2906:
2907: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2908: itemkey => itemkey,
2909: aname => 'SALESREP');
2910: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2911: '(itemtype => :item_type,' ||
2912: ' itemkey => :item_key,' ||
2913: ' aname => ''SALESREP'',' ||
2914: ' avalue => :l_text);end;';
2914: ' avalue => :l_text);end;';
2915: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2916:
2917: -- we don't need to set back CUSTCNT, for debug only
2918: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2919: itemkey => itemkey,
2920: aname => 'CUSTCNT');
2921: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2922: '(itemtype => :item_type,' ||
2917: -- we don't need to set back CUSTCNT, for debug only
2918: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2919: itemkey => itemkey,
2920: aname => 'CUSTCNT');
2921: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2922: '(itemtype => :item_type,' ||
2923: ' itemkey => :item_key,' ||
2924: ' aname => ''CUSTCNT'',' ||
2925: ' avalue => :l_text);end;';
2925: ' avalue => :l_text);end;';
2926: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2927:
2928: -- customer_name
2929: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2930: itemkey => itemkey,
2931: aname => 'CUSTOMER_NAME');
2932: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2933: '(itemtype => :item_type,' ||
2928: -- customer_name
2929: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2930: itemkey => itemkey,
2931: aname => 'CUSTOMER_NAME');
2932: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2933: '(itemtype => :item_type,' ||
2934: ' itemkey => :item_key,' ||
2935: ' aname => ''CUSTOMER_NAME'',' ||
2936: ' avalue => :l_text);end;';
2936: ' avalue => :l_text);end;';
2937: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2938:
2939: -- customer_ID.
2940: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2941: itemkey => itemkey,
2942: aname => 'CUSTOMER_ID');
2943: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2944: '(itemtype => :item_type,' ||
2939: -- customer_ID.
2940: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2941: itemkey => itemkey,
2942: aname => 'CUSTOMER_ID');
2943: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2944: '(itemtype => :item_type,' ||
2945: ' itemkey => :item_key,' ||
2946: ' aname => ''CUSTOMER_ID'',' ||
2947: ' avalue => :l_numb);end;';
2948: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
2949:
2950:
2951: -- Days_compressed
2952: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2953: itemkey => itemkey,
2954: aname => 'DAYS_COMPRESSED');
2955: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2956: '(itemtype => :item_type,' ||
2951: -- Days_compressed
2952: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2953: itemkey => itemkey,
2954: aname => 'DAYS_COMPRESSED');
2955: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2956: '(itemtype => :item_type,' ||
2957: ' itemkey => :item_key,' ||
2958: ' aname => ''DAYS_COMPRESSED'',' ||
2959: ' avalue => :l_numb);end;';
2959: ' avalue => :l_numb);end;';
2960: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
2961:
2962: -- APPS_PS_DBLINK. we may not need.
2963: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2964: itemkey => itemkey,
2965: aname => 'APPS_PS_DBLINK');
2966: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2967: '(itemtype => :item_type,' ||
2962: -- APPS_PS_DBLINK. we may not need.
2963: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2964: itemkey => itemkey,
2965: aname => 'APPS_PS_DBLINK');
2966: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2967: '(itemtype => :item_type,' ||
2968: ' itemkey => :item_key,' ||
2969: ' aname => ''APPS_PS_DBLINK'',' ||
2970: ' avalue => :l_text);end;';
2970: ' avalue => :l_text);end;';
2971: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2972:
2973: -- DEPARTMENT_LINE_CODE.
2974: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2975: itemkey => itemkey,
2976: aname => 'DEPARTMENT_LINE_CODE');
2977: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2978: '(itemtype => :item_type,' ||
2973: -- DEPARTMENT_LINE_CODE.
2974: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2975: itemkey => itemkey,
2976: aname => 'DEPARTMENT_LINE_CODE');
2977: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2978: '(itemtype => :item_type,' ||
2979: ' itemkey => :item_key,' ||
2980: ' aname => ''DEPARTMENT_LINE_CODE'',' ||
2981: ' avalue => :l_text);end;';
2981: ' avalue => :l_text);end;';
2982: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2983:
2984: -- due_date.
2985: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
2986: itemkey => itemkey,
2987: aname => 'DUE_DATE');
2988: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
2989: '(itemtype => :item_type,' ||
2984: -- due_date.
2985: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
2986: itemkey => itemkey,
2987: aname => 'DUE_DATE');
2988: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
2989: '(itemtype => :item_type,' ||
2990: ' itemkey => :item_key,' ||
2991: ' aname => ''DUE_DATE'',' ||
2992: ' avalue => :l_date);end;';
2992: ' avalue => :l_date);end;';
2993: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
2994:
2995: -- end_item_display_name.
2996: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2997: itemkey => itemkey,
2998: aname => 'END_ITEM_DISPLAY_NAME');
2999: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3000: '(itemtype => :item_type,' ||
2995: -- end_item_display_name.
2996: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2997: itemkey => itemkey,
2998: aname => 'END_ITEM_DISPLAY_NAME');
2999: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3000: '(itemtype => :item_type,' ||
3001: ' itemkey => :item_key,' ||
3002: ' aname => ''END_ITEM_DISPLAY_NAME'',' ||
3003: ' avalue => :l_text);end;';
3004: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3005:
3006: -- end_item_description
3007:
3008: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3009: itemkey => itemkey,
3010: aname => 'END_ITEM_DESCRIPTION');
3011: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3012: '(itemtype => :item_type,' ||
3007:
3008: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3009: itemkey => itemkey,
3010: aname => 'END_ITEM_DESCRIPTION');
3011: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3012: '(itemtype => :item_type,' ||
3013: ' itemkey => :item_key,' ||
3014: ' aname => ''END_ITEM_DESCRIPTION'',' ||
3015: ' avalue => :l_text);end;';
3016: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3017:
3018:
3019: --END_ORDER_NUMBER
3020: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3021: itemkey => itemkey,
3022: aname => 'END_ORDER_NUMBER');
3023: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3024: '(itemtype => :item_type,' ||
3019: --END_ORDER_NUMBER
3020: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3021: itemkey => itemkey,
3022: aname => 'END_ORDER_NUMBER');
3023: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3024: '(itemtype => :item_type,' ||
3025: ' itemkey => :item_key,' ||
3026: ' aname => ''END_ORDER_NUMBER'',' ||
3027: ' avalue => :l_text);end;';
3027: ' avalue => :l_text);end;';
3028: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3029:
3030: -- EXCEPTION_DESCRIPTION
3031: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3032: itemkey => itemkey,
3033: aname => 'EXCEPTION_DESCRIPTION');
3034: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3035: '(itemtype => :item_type,' ||
3030: -- EXCEPTION_DESCRIPTION
3031: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3032: itemkey => itemkey,
3033: aname => 'EXCEPTION_DESCRIPTION');
3034: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3035: '(itemtype => :item_type,' ||
3036: ' itemkey => :item_key,' ||
3037: ' aname => ''EXCEPTION_DESCRIPTION'',' ||
3038: ' avalue => :l_text);end;';
3038: ' avalue => :l_text);end;';
3039: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3040:
3041: --EXCEPTION_ID
3042: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3043: itemkey => itemkey,
3044: aname => 'EXCEPTION_ID');
3045: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3046: '(itemtype => :item_type,' ||
3041: --EXCEPTION_ID
3042: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3043: itemkey => itemkey,
3044: aname => 'EXCEPTION_ID');
3045: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3046: '(itemtype => :item_type,' ||
3047: ' itemkey => :item_key,' ||
3048: ' aname => ''EXCEPTION_ID'',' ||
3049: ' avalue => :l_numb);end;';
3049: ' avalue => :l_numb);end;';
3050: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3051:
3052: -- FROM_DATE
3053: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3054: itemkey => itemkey,
3055: aname => 'FROM_DATE');
3056: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3057: '(itemtype => :item_type,' ||
3052: -- FROM_DATE
3053: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3054: itemkey => itemkey,
3055: aname => 'FROM_DATE');
3056: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3057: '(itemtype => :item_type,' ||
3058: ' itemkey => :item_key,' ||
3059: ' aname => ''FROM_DATE'',' ||
3060: ' avalue => :l_date);end;';
3060: ' avalue => :l_date);end;';
3061: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3062:
3063: -- FROM_PRJ_MGR
3064: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3065: itemkey => itemkey,
3066: aname => 'FROM_PRJ_MGR');
3067: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3068: '(itemtype => :item_type,' ||
3063: -- FROM_PRJ_MGR
3064: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3065: itemkey => itemkey,
3066: aname => 'FROM_PRJ_MGR');
3067: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3068: '(itemtype => :item_type,' ||
3069: ' itemkey => :item_key,' ||
3070: ' aname => ''FROM_PRJ_MGR'',' ||
3071: ' avalue => :l_text);end;';
3071: ' avalue => :l_text);end;';
3072: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3073:
3074: --INSTANCE_ID
3075: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3076: itemkey => itemkey,
3077: aname => 'INSTANCE_ID');
3078: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3079: '(itemtype => :item_type,' ||
3074: --INSTANCE_ID
3075: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3076: itemkey => itemkey,
3077: aname => 'INSTANCE_ID');
3078: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3079: '(itemtype => :item_type,' ||
3080: ' itemkey => :item_key,' ||
3081: ' aname => ''INSTANCE_ID'',' ||
3082: ' avalue => :l_numb);end;';
3082: ' avalue => :l_numb);end;';
3083: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3084:
3085: --INVENTORY_ITEM_ID
3086: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3087: itemkey => itemkey,
3088: aname => 'INVENTORY_ITEM_ID');
3089: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3090: '(itemtype => :item_type,' ||
3085: --INVENTORY_ITEM_ID
3086: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3087: itemkey => itemkey,
3088: aname => 'INVENTORY_ITEM_ID');
3089: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3090: '(itemtype => :item_type,' ||
3091: ' itemkey => :item_key,' ||
3092: ' aname => ''INVENTORY_ITEM_ID'',' ||
3093: ' avalue => :l_numb);end;';
3093: ' avalue => :l_numb);end;';
3094: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3095:
3096: -- ITEM_DISPLAY_NAME
3097: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3098: itemkey => itemkey,
3099: aname => 'ITEM_DISPLAY_NAME');
3100: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3101: '(itemtype => :item_type,' ||
3096: -- ITEM_DISPLAY_NAME
3097: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3098: itemkey => itemkey,
3099: aname => 'ITEM_DISPLAY_NAME');
3100: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3101: '(itemtype => :item_type,' ||
3102: ' itemkey => :item_key,' ||
3103: ' aname => ''ITEM_DISPLAY_NAME'',' ||
3104: ' avalue => :l_text);end;';
3105: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3106:
3107: -- ITEM DESCRIPTION
3108:
3109: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3110: itemkey => itemkey,
3111: aname => 'ITEM_DESCRIPTION');
3112: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3113: '(itemtype => :item_type,' ||
3108:
3109: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3110: itemkey => itemkey,
3111: aname => 'ITEM_DESCRIPTION');
3112: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3113: '(itemtype => :item_type,' ||
3114: ' itemkey => :item_key,' ||
3115: ' aname => ''ITEM_DESCRIPTION'',' ||
3116: ' avalue => :l_text);end;';
3117: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3118:
3119:
3120: -- LOT_NUMBER
3121: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3122: itemkey => itemkey,
3123: aname => 'LOT_NUMBER');
3124: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3125: '(itemtype => :item_type,' ||
3120: -- LOT_NUMBER
3121: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3122: itemkey => itemkey,
3123: aname => 'LOT_NUMBER');
3124: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3125: '(itemtype => :item_type,' ||
3126: ' itemkey => :item_key,' ||
3127: ' aname => ''LOT_NUMBER'',' ||
3128: ' avalue => :l_text);end;';
3128: ' avalue => :l_text);end;';
3129: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3130:
3131: -- ORDER_NUMBER
3132: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3133: itemkey => itemkey,
3134: aname => 'ORDER_NUMBER');
3135: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3136: '(itemtype => :item_type,' ||
3131: -- ORDER_NUMBER
3132: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3133: itemkey => itemkey,
3134: aname => 'ORDER_NUMBER');
3135: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3136: '(itemtype => :item_type,' ||
3137: ' itemkey => :item_key,' ||
3138: ' aname => ''ORDER_NUMBER'',' ||
3139: ' avalue => :l_text);end;';
3139: ' avalue => :l_text);end;';
3140: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3141:
3142: -- ORGANIZATION_CODE
3143: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3144: itemkey => itemkey,
3145: aname => 'ORGANIZATION_CODE');
3146: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3147: '(itemtype => :item_type,' ||
3142: -- ORGANIZATION_CODE
3143: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3144: itemkey => itemkey,
3145: aname => 'ORGANIZATION_CODE');
3146: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3147: '(itemtype => :item_type,' ||
3148: ' itemkey => :item_key,' ||
3149: ' aname => ''ORGANIZATION_CODE'',' ||
3150: ' avalue => :l_text);end;';
3150: ' avalue => :l_text);end;';
3151: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3152:
3153: --ORGANIZATION_ID
3154: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3155: itemkey => itemkey,
3156: aname => 'ORGANIZATION_ID');
3157: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3158: '(itemtype => :item_type,' ||
3153: --ORGANIZATION_ID
3154: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3155: itemkey => itemkey,
3156: aname => 'ORGANIZATION_ID');
3157: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3158: '(itemtype => :item_type,' ||
3159: ' itemkey => :item_key,' ||
3160: ' aname => ''ORGANIZATION_ID'',' ||
3161: ' avalue => :l_numb);end;';
3161: ' avalue => :l_numb);end;';
3162: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3163:
3164: --PLAN_ID
3165: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3166: itemkey => itemkey,
3167: aname => 'PLAN_ID');
3168: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3169: '(itemtype => :item_type,' ||
3164: --PLAN_ID
3165: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3166: itemkey => itemkey,
3167: aname => 'PLAN_ID');
3168: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3169: '(itemtype => :item_type,' ||
3170: ' itemkey => :item_key,' ||
3171: ' aname => ''PLAN_ID'',' ||
3172: ' avalue => :l_numb);end;';
3172: ' avalue => :l_numb);end;';
3173: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3174:
3175: -- PLAN_NAME
3176: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3177: itemkey => itemkey,
3178: aname => 'PLAN_NAME');
3179: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3180: '(itemtype => :item_type,' ||
3175: -- PLAN_NAME
3176: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3177: itemkey => itemkey,
3178: aname => 'PLAN_NAME');
3179: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3180: '(itemtype => :item_type,' ||
3181: ' itemkey => :item_key,' ||
3182: ' aname => ''PLAN_NAME'',' ||
3183: ' avalue => :l_text);end;';
3183: ' avalue => :l_text);end;';
3184: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3185:
3186: -- PLANNER
3187: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3188: itemkey => itemkey,
3189: aname => 'PLANNER');
3190: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3191: '(itemtype => :item_type,' ||
3186: -- PLANNER
3187: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3188: itemkey => itemkey,
3189: aname => 'PLANNER');
3190: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3191: '(itemtype => :item_type,' ||
3192: ' itemkey => :item_key,' ||
3193: ' aname => ''PLANNER'',' ||
3194: ' avalue => :l_text);end;';
3194: ' avalue => :l_text);end;';
3195: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3196:
3197: -- PLANNING_GROUP
3198: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3199: itemkey => itemkey,
3200: aname => 'PLANNING_GROUP');
3201: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3202: '(itemtype => :item_type,' ||
3197: -- PLANNING_GROUP
3198: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3199: itemkey => itemkey,
3200: aname => 'PLANNING_GROUP');
3201: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3202: '(itemtype => :item_type,' ||
3203: ' itemkey => :item_key,' ||
3204: ' aname => ''PLANNING_GROUP'',' ||
3205: ' avalue => :l_text);end;';
3205: ' avalue => :l_text);end;';
3206: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3207:
3208: -- PROJECT_NUMBER
3209: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3210: itemkey => itemkey,
3211: aname => 'PROJECT_NUMBER');
3212: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3213: '(itemtype => :item_type,' ||
3208: -- PROJECT_NUMBER
3209: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3210: itemkey => itemkey,
3211: aname => 'PROJECT_NUMBER');
3212: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3213: '(itemtype => :item_type,' ||
3214: ' itemkey => :item_key,' ||
3215: ' aname => ''PROJECT_NUMBER'',' ||
3216: ' avalue => :l_text);end;';
3216: ' avalue => :l_text);end;';
3217: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3218:
3219: --PRE_PROCESSING_LEAD_TIME
3220: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3221: itemkey => itemkey,
3222: aname => 'PRE_PRSNG_LEAD_TIME');
3223: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3224: '(itemtype => :item_type,' ||
3219: --PRE_PROCESSING_LEAD_TIME
3220: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3221: itemkey => itemkey,
3222: aname => 'PRE_PRSNG_LEAD_TIME');
3223: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3224: '(itemtype => :item_type,' ||
3225: ' itemkey => :item_key,' ||
3226: ' aname => ''PRE_PRSNG_LEAD_TIME'',' ||
3227: ' avalue => :l_text);end;';
3227: ' avalue => :l_text);end;';
3228: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3229:
3230: --PROCESSING_LEAD_TIME
3231: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3232: itemkey => itemkey,
3233: aname => 'PRSNG_LEAD_TIME');
3234: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3235: '(itemtype => :item_type,' ||
3230: --PROCESSING_LEAD_TIME
3231: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3232: itemkey => itemkey,
3233: aname => 'PRSNG_LEAD_TIME');
3234: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3235: '(itemtype => :item_type,' ||
3236: ' itemkey => :item_key,' ||
3237: ' aname => ''PRSNG_LEAD_TIME'',' ||
3238: ' avalue => :l_text);end;';
3238: ' avalue => :l_text);end;';
3239: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3240:
3241: --POST_PROCESSING_LEAD_TIME
3242: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3243: itemkey => itemkey,
3244: aname => 'POST_PRSNG_LEAD_TIME');
3245: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3246: '(itemtype => :item_type,' ||
3241: --POST_PROCESSING_LEAD_TIME
3242: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3243: itemkey => itemkey,
3244: aname => 'POST_PRSNG_LEAD_TIME');
3245: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3246: '(itemtype => :item_type,' ||
3247: ' itemkey => :item_key,' ||
3248: ' aname => ''POST_PRSNG_LEAD_TIME'',' ||
3249: ' avalue => :l_text);end;';
3251:
3252:
3253:
3254: -- QUANTITY
3255: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3256: itemkey => itemkey,
3257: aname => 'QUANTITY');
3258: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3259: '(itemtype => :item_type,' ||
3254: -- QUANTITY
3255: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3256: itemkey => itemkey,
3257: aname => 'QUANTITY');
3258: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3259: '(itemtype => :item_type,' ||
3260: ' itemkey => :item_key,' ||
3261: ' aname => ''QUANTITY'',' ||
3262: ' avalue => :l_text);end;';
3262: ' avalue => :l_text);end;';
3263: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3264:
3265: -- RESOURCE_CODE
3266: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3267: itemkey => itemkey,
3268: aname => 'RESOURCE_CODE');
3269: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3270: '(itemtype => :item_type,' ||
3265: -- RESOURCE_CODE
3266: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3267: itemkey => itemkey,
3268: aname => 'RESOURCE_CODE');
3269: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3270: '(itemtype => :item_type,' ||
3271: ' itemkey => :item_key,' ||
3272: ' aname => ''RESOURCE_CODE'',' ||
3273: ' avalue => :l_text);end;';
3273: ' avalue => :l_text);end;';
3274: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3275:
3276: -- SUPCNT
3277: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3278: itemkey => itemkey,
3279: aname => 'SUPCNT');
3280: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3281: '(itemtype => :item_type,' ||
3276: -- SUPCNT
3277: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3278: itemkey => itemkey,
3279: aname => 'SUPCNT');
3280: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3281: '(itemtype => :item_type,' ||
3282: ' itemkey => :item_key,' ||
3283: ' aname => ''SUPCNT'',' ||
3284: ' avalue => :l_text);end;';
3284: ' avalue => :l_text);end;';
3285: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3286:
3287: --SUPPLIER_ID
3288: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3289: itemkey => itemkey,
3290: aname => 'SUPPLIER_ID');
3291: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3292: '(itemtype => :item_type,' ||
3287: --SUPPLIER_ID
3288: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3289: itemkey => itemkey,
3290: aname => 'SUPPLIER_ID');
3291: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3292: '(itemtype => :item_type,' ||
3293: ' itemkey => :item_key,' ||
3294: ' aname => ''SUPPLIER_ID'',' ||
3295: ' avalue => :l_numb);end;';
3295: ' avalue => :l_numb);end;';
3296: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3297:
3298: -- SUPPLIER_NAME
3299: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3300: itemkey => itemkey,
3301: aname => 'SUPPLIER_NAME');
3302: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3303: '(itemtype => :item_type,' ||
3298: -- SUPPLIER_NAME
3299: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3300: itemkey => itemkey,
3301: aname => 'SUPPLIER_NAME');
3302: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3303: '(itemtype => :item_type,' ||
3304: ' itemkey => :item_key,' ||
3305: ' aname => ''SUPPLIER_NAME'',' ||
3306: ' avalue => :l_text);end;';
3306: ' avalue => :l_text);end;';
3307: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3308:
3309: -- SUPPLIER_SITE_CODE
3310: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3311: itemkey => itemkey,
3312: aname => 'SUPPLIER_SITE_CODE');
3313: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3314: '(itemtype => :item_type,' ||
3309: -- SUPPLIER_SITE_CODE
3310: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3311: itemkey => itemkey,
3312: aname => 'SUPPLIER_SITE_CODE');
3313: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3314: '(itemtype => :item_type,' ||
3315: ' itemkey => :item_key,' ||
3316: ' aname => ''SUPPLIER_SITE_CODE'',' ||
3317: ' avalue => :l_text);end;';
3317: ' avalue => :l_text);end;';
3318: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3319:
3320: --SUPPLIER_SITE_ID
3321: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3322: itemkey => itemkey,
3323: aname => 'SUPPLIER_SITE_ID');
3324: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3325: '(itemtype => :item_type,' ||
3320: --SUPPLIER_SITE_ID
3321: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3322: itemkey => itemkey,
3323: aname => 'SUPPLIER_SITE_ID');
3324: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3325: '(itemtype => :item_type,' ||
3326: ' itemkey => :item_key,' ||
3327: ' aname => ''SUPPLIER_SITE_ID'',' ||
3328: ' avalue => :l_numb);end;';
3328: ' avalue => :l_numb);end;';
3329: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3330:
3331: -- SUPPLy_TYPE
3332: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3333: itemkey => itemkey,
3334: aname => 'SUPPLY_TYPE');
3335: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3336: '(itemtype => :item_type,' ||
3331: -- SUPPLy_TYPE
3332: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3333: itemkey => itemkey,
3334: aname => 'SUPPLY_TYPE');
3335: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3336: '(itemtype => :item_type,' ||
3337: ' itemkey => :item_key,' ||
3338: ' aname => ''SUPPLY_TYPE'',' ||
3339: ' avalue => :l_text);end;';
3339: ' avalue => :l_text);end;';
3340: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3341:
3342: -- TASK_NUMBER
3343: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3344: itemkey => itemkey,
3345: aname => 'TASK_NUMBER');
3346: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3347: '(itemtype => :item_type,' ||
3342: -- TASK_NUMBER
3343: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3344: itemkey => itemkey,
3345: aname => 'TASK_NUMBER');
3346: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3347: '(itemtype => :item_type,' ||
3348: ' itemkey => :item_key,' ||
3349: ' aname => ''TASK_NUMBER'',' ||
3350: ' avalue => :l_text);end;';
3350: ' avalue => :l_text);end;';
3351: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3352:
3353: -- TO_DATE
3354: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3355: itemkey => itemkey,
3356: aname => 'TO_DATE');
3357: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3358: '(itemtype => :item_type,' ||
3353: -- TO_DATE
3354: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3355: itemkey => itemkey,
3356: aname => 'TO_DATE');
3357: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3358: '(itemtype => :item_type,' ||
3359: ' itemkey => :item_key,' ||
3360: ' aname => ''TO_DATE'',' ||
3361: ' avalue => :l_date);end;';
3361: ' avalue => :l_date);end;';
3362: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3363:
3364: -- TO_PRJ_MGR
3365: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3366: itemkey => itemkey,
3367: aname => 'TO_PRJ_MGR');
3368: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3369: '(itemtype => :item_type,' ||
3364: -- TO_PRJ_MGR
3365: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3366: itemkey => itemkey,
3367: aname => 'TO_PRJ_MGR');
3368: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3369: '(itemtype => :item_type,' ||
3370: ' itemkey => :item_key,' ||
3371: ' aname => ''TO_PRJ_MGR'',' ||
3372: ' avalue => :l_text);end;';
3372: ' avalue => :l_text);end;';
3373: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3374:
3375: -- TO_PROJECT_NUMBER
3376: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3377: itemkey => itemkey,
3378: aname => 'TO_PROJECT_NUMBER');
3379: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3380: '(itemtype => :item_type,' ||
3375: -- TO_PROJECT_NUMBER
3376: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3377: itemkey => itemkey,
3378: aname => 'TO_PROJECT_NUMBER');
3379: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3380: '(itemtype => :item_type,' ||
3381: ' itemkey => :item_key,' ||
3382: ' aname => ''TO_PROJECT_NUMBER'',' ||
3383: ' avalue => :l_text);end;';
3383: ' avalue => :l_text);end;';
3384: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3385:
3386: -- TO_TASK_NUMBER
3387: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3388: itemkey => itemkey,
3389: aname => 'TO_TASK_NUMBER');
3390: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3391: '(itemtype => :item_type,' ||
3386: -- TO_TASK_NUMBER
3387: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3388: itemkey => itemkey,
3389: aname => 'TO_TASK_NUMBER');
3390: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3391: '(itemtype => :item_type,' ||
3392: ' itemkey => :item_key,' ||
3393: ' aname => ''TO_TASK_NUMBER'',' ||
3394: ' avalue => :l_text);end;';
3394: ' avalue => :l_text);end;';
3395: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3396:
3397: -- URL1
3398: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3399: itemkey => itemkey,
3400: aname => 'URL1');
3401: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3402: '(itemtype => :item_type,' ||
3397: -- URL1
3398: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3399: itemkey => itemkey,
3400: aname => 'URL1');
3401: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3402: '(itemtype => :item_type,' ||
3403: ' itemkey => :item_key,' ||
3404: ' aname => ''URL1'',' ||
3405: ' avalue => :l_text);end;';
3405: ' avalue => :l_text);end;';
3406: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3407:
3408: -- UTILIZATION_RATE
3409: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3410: itemkey => itemkey,
3411: aname => 'UTILIZATION_RATE');
3412: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3413: '(itemtype => :item_type,' ||
3408: -- UTILIZATION_RATE
3409: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3410: itemkey => itemkey,
3411: aname => 'UTILIZATION_RATE');
3412: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3413: '(itemtype => :item_type,' ||
3414: ' itemkey => :item_key,' ||
3415: ' aname => ''UTILIZATION_RATE'',' ||
3416: ' avalue => :l_numb);end;';
3417: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3418:
3419:
3420: -- CAPACITY_REQUIREMENT
3421: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3422: itemkey => itemkey,
3423: aname => 'CAPACITY_REQUIREMENT');
3424: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3425: '(itemtype => :item_type,' ||
3420: -- CAPACITY_REQUIREMENT
3421: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3422: itemkey => itemkey,
3423: aname => 'CAPACITY_REQUIREMENT');
3424: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3425: '(itemtype => :item_type,' ||
3426: ' itemkey => :item_key,' ||
3427: ' aname => ''CAPACITY_REQUIREMENT'',' ||
3428: ' avalue => :l_numb);end;';
3429: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3430:
3431:
3432: --REQUIRED_QUANTITY
3433: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3434: itemkey => itemkey,
3435: aname => 'REQUIRED_QUANTITY');
3436: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3437: '(itemtype => :item_type,' ||
3432: --REQUIRED_QUANTITY
3433: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3434: itemkey => itemkey,
3435: aname => 'REQUIRED_QUANTITY');
3436: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3437: '(itemtype => :item_type,' ||
3438: ' itemkey => :item_key,' ||
3439: ' aname => ''REQUIRED_QUANTITY'',' ||
3440: ' avalue => :l_numb);end;';
3441: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3442:
3443:
3444: --PROJECTED_AVAILABLE_BALANCE
3445: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3446: itemkey => itemkey,
3447: aname => 'PROJECTED_AVAILABLE_BALANCE');
3448: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3449: '(itemtype => :item_type,' ||
3444: --PROJECTED_AVAILABLE_BALANCE
3445: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3446: itemkey => itemkey,
3447: aname => 'PROJECTED_AVAILABLE_BALANCE');
3448: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3449: '(itemtype => :item_type,' ||
3450: ' itemkey => :item_key,' ||
3451: ' aname => ''PROJECTED_AVAILABLE_BALANCE'',' ||
3452: ' avalue => :l_numb);end;';
3452: ' avalue => :l_numb);end;';
3453: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3454:
3455: --AVAILABLE_QUANTITY
3456: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3457: itemkey => itemkey,
3458: aname => 'AVAILABLE_QUANTITY');
3459: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3460: '(itemtype => :item_type,' ||
3455: --AVAILABLE_QUANTITY
3456: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3457: itemkey => itemkey,
3458: aname => 'AVAILABLE_QUANTITY');
3459: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3460: '(itemtype => :item_type,' ||
3461: ' itemkey => :item_key,' ||
3462: ' aname => ''AVAILABLE_QUANTITY'',' ||
3463: ' avalue => :l_numb);end;';
3463: ' avalue => :l_numb);end;';
3464: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3465:
3466: --QTY_RELATED_VALUES
3467: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3468: itemkey => itemkey,
3469: aname => 'QTY_RELATED_VALUES');
3470: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3471: '(itemtype => :item_type,' ||
3466: --QTY_RELATED_VALUES
3467: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3468: itemkey => itemkey,
3469: aname => 'QTY_RELATED_VALUES');
3470: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3471: '(itemtype => :item_type,' ||
3472: ' itemkey => :item_key,' ||
3473: ' aname => ''QTY_RELATED_VALUES'',' ||
3474: ' avalue => :l_numb);end;';
3476:
3477:
3478:
3479: if (l_exception_type =70 ) then
3480: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3481: itemkey => itemkey,
3482: aname => 'DATE1');
3483: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3484: '(itemtype => :item_type,' ||
3479: if (l_exception_type =70 ) then
3480: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3481: itemkey => itemkey,
3482: aname => 'DATE1');
3483: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3484: '(itemtype => :item_type,' ||
3485: ' itemkey => :item_key,' ||
3486: ' aname => ''DATE1'',' ||
3487: ' avalue => :l_date);end;';
3486: ' aname => ''DATE1'',' ||
3487: ' avalue => :l_date);end;';
3488: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3489:
3490: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3491: itemkey => itemkey,
3492: aname => 'DATE2');
3493: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3494: '(itemtype => :item_type,' ||
3489:
3490: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3491: itemkey => itemkey,
3492: aname => 'DATE2');
3493: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3494: '(itemtype => :item_type,' ||
3495: ' itemkey => :item_key,' ||
3496: ' aname => ''DATE2'',' ||
3497: ' avalue => :l_date);end;';
3495: ' itemkey => :item_key,' ||
3496: ' aname => ''DATE2'',' ||
3497: ' avalue => :l_date);end;';
3498: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3499: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3500: itemkey => itemkey,
3501: aname => 'DATE3');
3502: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3503: '(itemtype => :item_type,' ||
3498: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3499: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3500: itemkey => itemkey,
3501: aname => 'DATE3');
3502: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3503: '(itemtype => :item_type,' ||
3504: ' itemkey => :item_key,' ||
3505: ' aname => ''DATE3'',' ||
3506: ' avalue => :l_date);end;';
3504: ' itemkey => :item_key,' ||
3505: ' aname => ''DATE3'',' ||
3506: ' avalue => :l_date);end;';
3507: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3508: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3509: itemkey => itemkey,
3510: aname => 'DATE4');
3511: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3512: '(itemtype => :item_type,' ||
3507: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3508: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3509: itemkey => itemkey,
3510: aname => 'DATE4');
3511: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3512: '(itemtype => :item_type,' ||
3513: ' itemkey => :item_key,' ||
3514: ' aname => ''DATE4'',' ||
3515: ' avalue => :l_date);end;';
3513: ' itemkey => :item_key,' ||
3514: ' aname => ''DATE4'',' ||
3515: ' avalue => :l_date);end;';
3516: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3517: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3518: itemkey => itemkey,
3519: aname => 'DATE5');
3520: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3521: '(itemtype => :item_type,' ||
3516: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3517: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3518: itemkey => itemkey,
3519: aname => 'DATE5');
3520: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3521: '(itemtype => :item_type,' ||
3522: ' itemkey => :item_key,' ||
3523: ' aname => ''DATE5'',' ||
3524: ' avalue => :l_date);end;';
3522: ' itemkey => :item_key,' ||
3523: ' aname => ''DATE5'',' ||
3524: ' avalue => :l_date);end;';
3525: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3526: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3527: itemkey => itemkey,
3528: aname => 'DATE6');
3529: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3530: '(itemtype => :item_type,' ||
3525: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3526: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3527: itemkey => itemkey,
3528: aname => 'DATE6');
3529: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3530: '(itemtype => :item_type,' ||
3531: ' itemkey => :item_key,' ||
3532: ' aname => ''DATE6'',' ||
3533: ' avalue => :l_date);end;';
3534: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3535: end if; -- end of if (l_exception_type = 70)
3536: -- now start wf process at destination instance
3537:
3538: sql_stmt := 'begin wf_engine.StartProcess'|| l_db_link ||
3539: '( itemtype => :itemtype,' ||
3540: ' itemkey => :itemkey);end;';
3541: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key;
3542:
3546: execute immediate 'alter session close database link '||
3547: ltrim(l_db_link,'@');
3548: exception
3549: when others then
3550: wf_engine.SetItemAttrNumber( itemtype => itemtype,
3551: itemkey => itemkey,
3552: aname => 'SR_REQUEST_ID',
3553: avalue => -1);
3554: end;
3552: aname => 'SR_REQUEST_ID',
3553: avalue => -1);
3554: end;
3555: end if;
3556: wf_engine.SetItemAttrNumber( itemtype => itemtype,
3557: itemkey => itemkey,
3558: aname => 'SR_REQUEST_ID',
3559: avalue => p_request_id);
3560:
3628: end loop;
3629: if v_dummy = 1 then
3630: FND_FILE.PUT_LINE(FND_FILE.LOG,
3631: 'start backgroud process for'||p_item_type);
3632: wf_engine.background(p_item_type);
3633: end if;
3634: END start_deferred_activity;
3635:
3636: FUNCTION demand_order_type (p_plan_id number,