[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:
2425: actid in number,
2426: funcmode in varchar2,
2427: resultout out NOCOPY varchar2) is
2428: l_is_callback varchar2(3) :=
2429: wf_engine.GetItemAttrText( itemtype => itemtype,
2430: itemkey => itemkey,
2431: aname => 'IS_CALL_BACK');
2432:
2433: BEGIN
2535:
2536:
2537:
2538: l_exception_type number :=
2539: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2540: itemkey => itemkey,
2541: aname => 'EXCEPTION_TYPE_ID');
2542:
2543: l_demand_id number :=
2540: itemkey => itemkey,
2541: aname => 'EXCEPTION_TYPE_ID');
2542:
2543: l_demand_id number :=
2544: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2545: itemkey => itemkey,
2546: aname => 'TRANSACTION_ID');
2547:
2548: l_order_type number :=
2545: itemkey => itemkey,
2546: aname => 'TRANSACTION_ID');
2547:
2548: l_order_type number :=
2549: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2550: itemkey => itemkey,
2551: aname => 'ORDER_TYPE_CODE');
2552:
2553: l_inventory_item_id number :=
2550: itemkey => itemkey,
2551: aname => 'ORDER_TYPE_CODE');
2552:
2553: l_inventory_item_id number :=
2554: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2555: itemkey => itemkey,
2556: aname => 'INVENTORY_ITEM_ID');
2557:
2558: l_plan_id number :=
2555: itemkey => itemkey,
2556: aname => 'INVENTORY_ITEM_ID');
2557:
2558: l_plan_id number :=
2559: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2560: itemkey => itemkey,
2561: aname => 'PLAN_ID');
2562:
2563: l_org_id number :=
2560: itemkey => itemkey,
2561: aname => 'PLAN_ID');
2562:
2563: l_org_id number :=
2564: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2565: itemkey => itemkey,
2566: aname => 'ORGANIZATION_ID');
2567:
2568: l_instance_id number :=
2565: itemkey => itemkey,
2566: aname => 'ORGANIZATION_ID');
2567:
2568: l_instance_id number :=
2569: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2570: itemkey => itemkey,
2571: aname => 'INSTANCE_ID');
2572:
2573: l_from_project_number varchar2(100) :=
2570: itemkey => itemkey,
2571: aname => 'INSTANCE_ID');
2572:
2573: l_from_project_number varchar2(100) :=
2574: wf_engine.GetItemAttrText( itemtype => itemtype,
2575: itemkey => itemkey,
2576: aname => 'PROJECT_NUMBER');
2577:
2578: l_to_project_number varchar2(100) :=
2575: itemkey => itemkey,
2576: aname => 'PROJECT_NUMBER');
2577:
2578: l_to_project_number varchar2(100) :=
2579: wf_engine.GetItemAttrText( itemtype => itemtype,
2580: itemkey => itemkey,
2581: aname => 'TO_PROJECT_NUMBER');
2582:
2583: l_from_task_number varchar2(100) :=
2580: itemkey => itemkey,
2581: aname => 'TO_PROJECT_NUMBER');
2582:
2583: l_from_task_number varchar2(100) :=
2584: wf_engine.GetItemAttrText( itemtype => itemtype,
2585: itemkey => itemkey,
2586: aname => 'TASK_NUMBER');
2587:
2588: l_to_task_number varchar2(100) :=
2585: itemkey => itemkey,
2586: aname => 'TASK_NUMBER');
2587:
2588: l_to_task_number varchar2(100) :=
2589: wf_engine.GetItemAttrText( itemtype => itemtype,
2590: itemkey => itemkey,
2591: aname => 'TO_TASK_NUMBER');
2592:
2593: l_exception_id number :=
2590: itemkey => itemkey,
2591: aname => 'TO_TASK_NUMBER');
2592:
2593: l_exception_id number :=
2594: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2595: itemkey => itemkey,
2596: aname => 'EXCEPTION_ID');
2597:
2598: l_buyer varchar2(30);
2634:
2635: --l_buyer := 'MFG';
2636:
2637: if (l_buyer is not null) then
2638: wf_engine.setItemAttrText( itemtype => itemtype,
2639: itemkey => itemkey,
2640: aname => 'BUYER',
2641: avalue => l_buyer);
2642: END IF;
2651:
2652: -- l_supcnt := 'MFG';
2653:
2654: if (l_supcnt is not null) then
2655: wf_engine.setItemAttrText( itemtype => itemtype,
2656: itemkey => itemkey,
2657: aname => 'SUPCNT',
2658: avalue => l_supcnt);
2659: END IF;
2671: end if;
2672:
2673: -- l_salesrep := '1208';
2674: if (l_salesrep is not null) then
2675: wf_engine.setItemAttrText( itemtype => itemtype,
2676: itemkey => itemkey,
2677: aname => 'SALESREP',
2678: avalue => l_salesrep);
2679: END IF;
2689: end if;
2690: -- l_custcnt := 'MFG';
2691:
2692: if (l_custcnt is not null) then
2693: wf_engine.setItemAttrText( itemtype => itemtype,
2694: itemkey => itemkey,
2695: aname => 'CUSTCNT',
2696: avalue => l_custcnt);
2697: END IF;
2711: end if;
2712: --l_from_prj_mgr := 'MFG';
2713:
2714: if (l_from_prj_mgr is not null) then
2715: wf_engine.setItemAttrText( itemtype => itemtype,
2716: itemkey => itemkey,
2717: aname => 'FROM_PRJ_MGR',
2718: avalue => l_from_prj_mgr);
2719: END IF;
2731: end if;
2732:
2733: --l_to_prj_mgr := 'MFG';
2734: if (l_to_prj_mgr is not null) then
2735: wf_engine.setItemAttrText( itemtype => itemtype,
2736: itemkey => itemkey,
2737: aname => 'TO_PRJ_MGR',
2738: avalue => l_to_prj_mgr);
2739: END IF;
2768: funcmode in varchar2,
2769: resultout out NOCOPY varchar2) is
2770:
2771: l_planner varchar2(20) :=
2772: wf_engine.GetItemAttrText( itemtype => itemtype,
2773: itemkey => itemkey,
2774: aname => 'PLANNER');
2775: l_buyer varchar2(50) :=
2776: wf_engine.GetItemAttrText( itemtype => itemtype,
2772: wf_engine.GetItemAttrText( itemtype => itemtype,
2773: itemkey => itemkey,
2774: aname => 'PLANNER');
2775: l_buyer varchar2(50) :=
2776: wf_engine.GetItemAttrText( itemtype => itemtype,
2777: itemkey => itemkey,
2778: aname => 'BUYER');
2779: BEGIN
2780: if (funcmode = 'RUN') then
2809: funcmode in varchar2,
2810: resultout out NOCOPY varchar2) is
2811:
2812: l_db_link varchar2(30) :=
2813: wf_engine.GetItemAttrText( itemtype => itemtype,
2814: itemkey => itemkey,
2815: aname => 'DB_LINK');
2816:
2817: l_exception_type number :=
2814: itemkey => itemkey,
2815: aname => 'DB_LINK');
2816:
2817: l_exception_type number :=
2818: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2819: itemkey => itemkey,
2820: aname => 'EXCEPTION_TYPE_ID');
2821:
2822: l_transaction_id number :=
2819: itemkey => itemkey,
2820: aname => 'EXCEPTION_TYPE_ID');
2821:
2822: l_transaction_id number :=
2823: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2824: itemkey => itemkey,
2825: aname => 'TRANSACTION_ID');
2826:
2827: l_order_type number :=
2824: itemkey => itemkey,
2825: aname => 'TRANSACTION_ID');
2826:
2827: l_order_type number :=
2828: wf_engine.GetItemAttrNumber( itemtype => itemtype,
2829: itemkey => itemkey,
2830: aname => 'ORDER_TYPE_CODE');
2831:
2832: l_sr_item_type varchar2(50) := 'MRPEXWFS';
2855: l_sr_process := 'MSC_PRJ_SR_PROCESS';
2856: end if;
2857: l_sr_item_key := itemkey || '-' || l_sr_process;
2858:
2859: sql_stmt := 'begin wf_engine.CreateProcess' || l_db_link ||
2860: '( itemtype => :l_itemtype,' ||
2861: 'itemkey => :l_itemkey, ' ||
2862: 'process => :l_process);end;';
2863: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type, l_sr_item_key,
2867: -- we could only copy those insterested attributes,
2868: -- but we copy all for debug purpose.
2869:
2870: -- ORDER_TYPE_CODE
2871: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2872: '(itemtype => :item_type,' ||
2873: ' itemkey => :item_key,' ||
2874: ' aname => ''ORDER_TYPE_CODE'',' ||
2875: ' avalue => :l_numb);end;';
2875: ' avalue => :l_numb);end;';
2876: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_order_type;
2877:
2878: -- EXCEPTION_TYPE_ID.
2879: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2880: '(itemtype => :item_type,' ||
2881: ' itemkey => :item_key,' ||
2882: ' aname => ''EXCEPTION_TYPE_ID'',' ||
2883: ' avalue => :l_numb);end;';
2883: ' avalue => :l_numb);end;';
2884: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_exception_type;
2885:
2886:
2887: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2888: '(itemtype => :item_type,' ||
2889: ' itemkey => :item_key,' ||
2890: ' aname => ''TRANSACTION_ID'',' ||
2891: ' avalue => :l_numb);end;';
2891: ' avalue => :l_numb);end;';
2892: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_transaction_id;
2893:
2894: -- APPS_PS_DBLINK
2895: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2896: '(itemtype => :item_type,' ||
2897: ' itemkey => :item_key,' ||
2898: ' aname => ''APPS_PS_DBLINK'',' ||
2899: ' avalue => :l_text);end;';
2899: ' avalue => :l_text);end;';
2900: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_db_link;
2901:
2902: --BUYER. we don't need to set back BUYER, set it for debug
2903: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2904: itemkey => itemkey,
2905: aname => 'BUYER');
2906: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2907: '(itemtype => :item_type,' ||
2902: --BUYER. we don't need to set back BUYER, set it for debug
2903: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2904: itemkey => itemkey,
2905: aname => 'BUYER');
2906: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2907: '(itemtype => :item_type,' ||
2908: ' itemkey => :item_key,' ||
2909: ' aname => ''BUYER'',' ||
2910: ' avalue => :l_text);end;';
2909: ' aname => ''BUYER'',' ||
2910: ' avalue => :l_text);end;';
2911: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2912:
2913: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2914: itemkey => itemkey,
2915: aname => 'SALESREP');
2916: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2917: '(itemtype => :item_type,' ||
2912:
2913: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2914: itemkey => itemkey,
2915: aname => 'SALESREP');
2916: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2917: '(itemtype => :item_type,' ||
2918: ' itemkey => :item_key,' ||
2919: ' aname => ''SALESREP'',' ||
2920: ' avalue => :l_text);end;';
2920: ' avalue => :l_text);end;';
2921: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2922:
2923: -- we don't need to set back CUSTCNT, for debug only
2924: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2925: itemkey => itemkey,
2926: aname => 'CUSTCNT');
2927: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2928: '(itemtype => :item_type,' ||
2923: -- we don't need to set back CUSTCNT, for debug only
2924: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2925: itemkey => itemkey,
2926: aname => 'CUSTCNT');
2927: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2928: '(itemtype => :item_type,' ||
2929: ' itemkey => :item_key,' ||
2930: ' aname => ''CUSTCNT'',' ||
2931: ' avalue => :l_text);end;';
2931: ' avalue => :l_text);end;';
2932: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2933:
2934: -- customer_name
2935: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2936: itemkey => itemkey,
2937: aname => 'CUSTOMER_NAME');
2938: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2939: '(itemtype => :item_type,' ||
2934: -- customer_name
2935: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2936: itemkey => itemkey,
2937: aname => 'CUSTOMER_NAME');
2938: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2939: '(itemtype => :item_type,' ||
2940: ' itemkey => :item_key,' ||
2941: ' aname => ''CUSTOMER_NAME'',' ||
2942: ' avalue => :l_text);end;';
2942: ' avalue => :l_text);end;';
2943: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2944:
2945: -- customer_ID.
2946: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2947: itemkey => itemkey,
2948: aname => 'CUSTOMER_ID');
2949: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2950: '(itemtype => :item_type,' ||
2945: -- customer_ID.
2946: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2947: itemkey => itemkey,
2948: aname => 'CUSTOMER_ID');
2949: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2950: '(itemtype => :item_type,' ||
2951: ' itemkey => :item_key,' ||
2952: ' aname => ''CUSTOMER_ID'',' ||
2953: ' avalue => :l_numb);end;';
2954: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
2955:
2956:
2957: -- Days_compressed
2958: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2959: itemkey => itemkey,
2960: aname => 'DAYS_COMPRESSED');
2961: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2962: '(itemtype => :item_type,' ||
2957: -- Days_compressed
2958: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2959: itemkey => itemkey,
2960: aname => 'DAYS_COMPRESSED');
2961: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
2962: '(itemtype => :item_type,' ||
2963: ' itemkey => :item_key,' ||
2964: ' aname => ''DAYS_COMPRESSED'',' ||
2965: ' avalue => :l_numb);end;';
2965: ' avalue => :l_numb);end;';
2966: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
2967:
2968: -- APPS_PS_DBLINK. we may not need.
2969: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2970: itemkey => itemkey,
2971: aname => 'APPS_PS_DBLINK');
2972: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2973: '(itemtype => :item_type,' ||
2968: -- APPS_PS_DBLINK. we may not need.
2969: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2970: itemkey => itemkey,
2971: aname => 'APPS_PS_DBLINK');
2972: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2973: '(itemtype => :item_type,' ||
2974: ' itemkey => :item_key,' ||
2975: ' aname => ''APPS_PS_DBLINK'',' ||
2976: ' avalue => :l_text);end;';
2976: ' avalue => :l_text);end;';
2977: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2978:
2979: -- DEPARTMENT_LINE_CODE.
2980: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2981: itemkey => itemkey,
2982: aname => 'DEPARTMENT_LINE_CODE');
2983: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2984: '(itemtype => :item_type,' ||
2979: -- DEPARTMENT_LINE_CODE.
2980: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
2981: itemkey => itemkey,
2982: aname => 'DEPARTMENT_LINE_CODE');
2983: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
2984: '(itemtype => :item_type,' ||
2985: ' itemkey => :item_key,' ||
2986: ' aname => ''DEPARTMENT_LINE_CODE'',' ||
2987: ' avalue => :l_text);end;';
2987: ' avalue => :l_text);end;';
2988: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
2989:
2990: -- due_date.
2991: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
2992: itemkey => itemkey,
2993: aname => 'DUE_DATE');
2994: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
2995: '(itemtype => :item_type,' ||
2990: -- due_date.
2991: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
2992: itemkey => itemkey,
2993: aname => 'DUE_DATE');
2994: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
2995: '(itemtype => :item_type,' ||
2996: ' itemkey => :item_key,' ||
2997: ' aname => ''DUE_DATE'',' ||
2998: ' avalue => :l_date);end;';
2998: ' avalue => :l_date);end;';
2999: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3000:
3001: -- end_item_display_name.
3002: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3003: itemkey => itemkey,
3004: aname => 'END_ITEM_DISPLAY_NAME');
3005: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3006: '(itemtype => :item_type,' ||
3001: -- end_item_display_name.
3002: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3003: itemkey => itemkey,
3004: aname => 'END_ITEM_DISPLAY_NAME');
3005: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3006: '(itemtype => :item_type,' ||
3007: ' itemkey => :item_key,' ||
3008: ' aname => ''END_ITEM_DISPLAY_NAME'',' ||
3009: ' avalue => :l_text);end;';
3010: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3011:
3012: -- end_item_description
3013:
3014: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3015: itemkey => itemkey,
3016: aname => 'END_ITEM_DESCRIPTION');
3017: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3018: '(itemtype => :item_type,' ||
3013:
3014: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3015: itemkey => itemkey,
3016: aname => 'END_ITEM_DESCRIPTION');
3017: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3018: '(itemtype => :item_type,' ||
3019: ' itemkey => :item_key,' ||
3020: ' aname => ''END_ITEM_DESCRIPTION'',' ||
3021: ' avalue => :l_text);end;';
3022: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3023:
3024:
3025: --END_ORDER_NUMBER
3026: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3027: itemkey => itemkey,
3028: aname => 'END_ORDER_NUMBER');
3029: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3030: '(itemtype => :item_type,' ||
3025: --END_ORDER_NUMBER
3026: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3027: itemkey => itemkey,
3028: aname => 'END_ORDER_NUMBER');
3029: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3030: '(itemtype => :item_type,' ||
3031: ' itemkey => :item_key,' ||
3032: ' aname => ''END_ORDER_NUMBER'',' ||
3033: ' avalue => :l_text);end;';
3033: ' avalue => :l_text);end;';
3034: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3035:
3036: -- EXCEPTION_DESCRIPTION
3037: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3038: itemkey => itemkey,
3039: aname => 'EXCEPTION_DESCRIPTION');
3040: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3041: '(itemtype => :item_type,' ||
3036: -- EXCEPTION_DESCRIPTION
3037: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3038: itemkey => itemkey,
3039: aname => 'EXCEPTION_DESCRIPTION');
3040: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3041: '(itemtype => :item_type,' ||
3042: ' itemkey => :item_key,' ||
3043: ' aname => ''EXCEPTION_DESCRIPTION'',' ||
3044: ' avalue => :l_text);end;';
3044: ' avalue => :l_text);end;';
3045: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3046:
3047: --EXCEPTION_ID
3048: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3049: itemkey => itemkey,
3050: aname => 'EXCEPTION_ID');
3051: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3052: '(itemtype => :item_type,' ||
3047: --EXCEPTION_ID
3048: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3049: itemkey => itemkey,
3050: aname => 'EXCEPTION_ID');
3051: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3052: '(itemtype => :item_type,' ||
3053: ' itemkey => :item_key,' ||
3054: ' aname => ''EXCEPTION_ID'',' ||
3055: ' avalue => :l_numb);end;';
3055: ' avalue => :l_numb);end;';
3056: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3057:
3058: -- FROM_DATE
3059: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3060: itemkey => itemkey,
3061: aname => 'FROM_DATE');
3062: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3063: '(itemtype => :item_type,' ||
3058: -- FROM_DATE
3059: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3060: itemkey => itemkey,
3061: aname => 'FROM_DATE');
3062: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3063: '(itemtype => :item_type,' ||
3064: ' itemkey => :item_key,' ||
3065: ' aname => ''FROM_DATE'',' ||
3066: ' avalue => :l_date);end;';
3066: ' avalue => :l_date);end;';
3067: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3068:
3069: -- FROM_PRJ_MGR
3070: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3071: itemkey => itemkey,
3072: aname => 'FROM_PRJ_MGR');
3073: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3074: '(itemtype => :item_type,' ||
3069: -- FROM_PRJ_MGR
3070: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3071: itemkey => itemkey,
3072: aname => 'FROM_PRJ_MGR');
3073: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3074: '(itemtype => :item_type,' ||
3075: ' itemkey => :item_key,' ||
3076: ' aname => ''FROM_PRJ_MGR'',' ||
3077: ' avalue => :l_text);end;';
3077: ' avalue => :l_text);end;';
3078: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3079:
3080: --INSTANCE_ID
3081: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3082: itemkey => itemkey,
3083: aname => 'INSTANCE_ID');
3084: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3085: '(itemtype => :item_type,' ||
3080: --INSTANCE_ID
3081: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3082: itemkey => itemkey,
3083: aname => 'INSTANCE_ID');
3084: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3085: '(itemtype => :item_type,' ||
3086: ' itemkey => :item_key,' ||
3087: ' aname => ''INSTANCE_ID'',' ||
3088: ' avalue => :l_numb);end;';
3088: ' avalue => :l_numb);end;';
3089: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3090:
3091: --INVENTORY_ITEM_ID
3092: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3093: itemkey => itemkey,
3094: aname => 'INVENTORY_ITEM_ID');
3095: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3096: '(itemtype => :item_type,' ||
3091: --INVENTORY_ITEM_ID
3092: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3093: itemkey => itemkey,
3094: aname => 'INVENTORY_ITEM_ID');
3095: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3096: '(itemtype => :item_type,' ||
3097: ' itemkey => :item_key,' ||
3098: ' aname => ''INVENTORY_ITEM_ID'',' ||
3099: ' avalue => :l_numb);end;';
3099: ' avalue => :l_numb);end;';
3100: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3101:
3102: -- ITEM_DISPLAY_NAME
3103: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3104: itemkey => itemkey,
3105: aname => 'ITEM_DISPLAY_NAME');
3106: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3107: '(itemtype => :item_type,' ||
3102: -- ITEM_DISPLAY_NAME
3103: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3104: itemkey => itemkey,
3105: aname => 'ITEM_DISPLAY_NAME');
3106: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3107: '(itemtype => :item_type,' ||
3108: ' itemkey => :item_key,' ||
3109: ' aname => ''ITEM_DISPLAY_NAME'',' ||
3110: ' avalue => :l_text);end;';
3111: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3112:
3113: -- ITEM DESCRIPTION
3114:
3115: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3116: itemkey => itemkey,
3117: aname => 'ITEM_DESCRIPTION');
3118: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3119: '(itemtype => :item_type,' ||
3114:
3115: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3116: itemkey => itemkey,
3117: aname => 'ITEM_DESCRIPTION');
3118: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3119: '(itemtype => :item_type,' ||
3120: ' itemkey => :item_key,' ||
3121: ' aname => ''ITEM_DESCRIPTION'',' ||
3122: ' avalue => :l_text);end;';
3123: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3124:
3125:
3126: -- LOT_NUMBER
3127: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3128: itemkey => itemkey,
3129: aname => 'LOT_NUMBER');
3130: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3131: '(itemtype => :item_type,' ||
3126: -- LOT_NUMBER
3127: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3128: itemkey => itemkey,
3129: aname => 'LOT_NUMBER');
3130: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3131: '(itemtype => :item_type,' ||
3132: ' itemkey => :item_key,' ||
3133: ' aname => ''LOT_NUMBER'',' ||
3134: ' avalue => :l_text);end;';
3134: ' avalue => :l_text);end;';
3135: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3136:
3137: -- ORDER_NUMBER
3138: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3139: itemkey => itemkey,
3140: aname => 'ORDER_NUMBER');
3141: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3142: '(itemtype => :item_type,' ||
3137: -- ORDER_NUMBER
3138: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3139: itemkey => itemkey,
3140: aname => 'ORDER_NUMBER');
3141: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3142: '(itemtype => :item_type,' ||
3143: ' itemkey => :item_key,' ||
3144: ' aname => ''ORDER_NUMBER'',' ||
3145: ' avalue => :l_text);end;';
3145: ' avalue => :l_text);end;';
3146: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3147:
3148: -- ORGANIZATION_CODE
3149: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3150: itemkey => itemkey,
3151: aname => 'ORGANIZATION_CODE');
3152: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3153: '(itemtype => :item_type,' ||
3148: -- ORGANIZATION_CODE
3149: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3150: itemkey => itemkey,
3151: aname => 'ORGANIZATION_CODE');
3152: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3153: '(itemtype => :item_type,' ||
3154: ' itemkey => :item_key,' ||
3155: ' aname => ''ORGANIZATION_CODE'',' ||
3156: ' avalue => :l_text);end;';
3156: ' avalue => :l_text);end;';
3157: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3158:
3159: --ORGANIZATION_ID
3160: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3161: itemkey => itemkey,
3162: aname => 'ORGANIZATION_ID');
3163: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3164: '(itemtype => :item_type,' ||
3159: --ORGANIZATION_ID
3160: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3161: itemkey => itemkey,
3162: aname => 'ORGANIZATION_ID');
3163: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3164: '(itemtype => :item_type,' ||
3165: ' itemkey => :item_key,' ||
3166: ' aname => ''ORGANIZATION_ID'',' ||
3167: ' avalue => :l_numb);end;';
3167: ' avalue => :l_numb);end;';
3168: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3169:
3170: --PLAN_ID
3171: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3172: itemkey => itemkey,
3173: aname => 'PLAN_ID');
3174: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3175: '(itemtype => :item_type,' ||
3170: --PLAN_ID
3171: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3172: itemkey => itemkey,
3173: aname => 'PLAN_ID');
3174: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3175: '(itemtype => :item_type,' ||
3176: ' itemkey => :item_key,' ||
3177: ' aname => ''PLAN_ID'',' ||
3178: ' avalue => :l_numb);end;';
3178: ' avalue => :l_numb);end;';
3179: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3180:
3181: -- PLAN_NAME
3182: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3183: itemkey => itemkey,
3184: aname => 'PLAN_NAME');
3185: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3186: '(itemtype => :item_type,' ||
3181: -- PLAN_NAME
3182: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3183: itemkey => itemkey,
3184: aname => 'PLAN_NAME');
3185: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3186: '(itemtype => :item_type,' ||
3187: ' itemkey => :item_key,' ||
3188: ' aname => ''PLAN_NAME'',' ||
3189: ' avalue => :l_text);end;';
3189: ' avalue => :l_text);end;';
3190: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3191:
3192: -- PLANNER
3193: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3194: itemkey => itemkey,
3195: aname => 'PLANNER');
3196: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3197: '(itemtype => :item_type,' ||
3192: -- PLANNER
3193: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3194: itemkey => itemkey,
3195: aname => 'PLANNER');
3196: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3197: '(itemtype => :item_type,' ||
3198: ' itemkey => :item_key,' ||
3199: ' aname => ''PLANNER'',' ||
3200: ' avalue => :l_text);end;';
3200: ' avalue => :l_text);end;';
3201: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3202:
3203: -- PLANNING_GROUP
3204: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3205: itemkey => itemkey,
3206: aname => 'PLANNING_GROUP');
3207: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3208: '(itemtype => :item_type,' ||
3203: -- PLANNING_GROUP
3204: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3205: itemkey => itemkey,
3206: aname => 'PLANNING_GROUP');
3207: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3208: '(itemtype => :item_type,' ||
3209: ' itemkey => :item_key,' ||
3210: ' aname => ''PLANNING_GROUP'',' ||
3211: ' avalue => :l_text);end;';
3211: ' avalue => :l_text);end;';
3212: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3213:
3214: -- PROJECT_NUMBER
3215: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3216: itemkey => itemkey,
3217: aname => 'PROJECT_NUMBER');
3218: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3219: '(itemtype => :item_type,' ||
3214: -- PROJECT_NUMBER
3215: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3216: itemkey => itemkey,
3217: aname => 'PROJECT_NUMBER');
3218: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3219: '(itemtype => :item_type,' ||
3220: ' itemkey => :item_key,' ||
3221: ' aname => ''PROJECT_NUMBER'',' ||
3222: ' avalue => :l_text);end;';
3222: ' avalue => :l_text);end;';
3223: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3224:
3225: --PRE_PROCESSING_LEAD_TIME
3226: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3227: itemkey => itemkey,
3228: aname => 'PRE_PRSNG_LEAD_TIME');
3229: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3230: '(itemtype => :item_type,' ||
3225: --PRE_PROCESSING_LEAD_TIME
3226: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3227: itemkey => itemkey,
3228: aname => 'PRE_PRSNG_LEAD_TIME');
3229: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3230: '(itemtype => :item_type,' ||
3231: ' itemkey => :item_key,' ||
3232: ' aname => ''PRE_PRSNG_LEAD_TIME'',' ||
3233: ' avalue => :l_text);end;';
3233: ' avalue => :l_text);end;';
3234: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3235:
3236: --PROCESSING_LEAD_TIME
3237: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3238: itemkey => itemkey,
3239: aname => 'PRSNG_LEAD_TIME');
3240: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3241: '(itemtype => :item_type,' ||
3236: --PROCESSING_LEAD_TIME
3237: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3238: itemkey => itemkey,
3239: aname => 'PRSNG_LEAD_TIME');
3240: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3241: '(itemtype => :item_type,' ||
3242: ' itemkey => :item_key,' ||
3243: ' aname => ''PRSNG_LEAD_TIME'',' ||
3244: ' avalue => :l_text);end;';
3244: ' avalue => :l_text);end;';
3245: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3246:
3247: --POST_PROCESSING_LEAD_TIME
3248: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3249: itemkey => itemkey,
3250: aname => 'POST_PRSNG_LEAD_TIME');
3251: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3252: '(itemtype => :item_type,' ||
3247: --POST_PROCESSING_LEAD_TIME
3248: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3249: itemkey => itemkey,
3250: aname => 'POST_PRSNG_LEAD_TIME');
3251: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3252: '(itemtype => :item_type,' ||
3253: ' itemkey => :item_key,' ||
3254: ' aname => ''POST_PRSNG_LEAD_TIME'',' ||
3255: ' avalue => :l_text);end;';
3257:
3258:
3259:
3260: -- QUANTITY
3261: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3262: itemkey => itemkey,
3263: aname => 'QUANTITY');
3264: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3265: '(itemtype => :item_type,' ||
3260: -- QUANTITY
3261: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3262: itemkey => itemkey,
3263: aname => 'QUANTITY');
3264: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3265: '(itemtype => :item_type,' ||
3266: ' itemkey => :item_key,' ||
3267: ' aname => ''QUANTITY'',' ||
3268: ' avalue => :l_text);end;';
3268: ' avalue => :l_text);end;';
3269: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3270:
3271: -- RESOURCE_CODE
3272: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3273: itemkey => itemkey,
3274: aname => 'RESOURCE_CODE');
3275: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3276: '(itemtype => :item_type,' ||
3271: -- RESOURCE_CODE
3272: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3273: itemkey => itemkey,
3274: aname => 'RESOURCE_CODE');
3275: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3276: '(itemtype => :item_type,' ||
3277: ' itemkey => :item_key,' ||
3278: ' aname => ''RESOURCE_CODE'',' ||
3279: ' avalue => :l_text);end;';
3279: ' avalue => :l_text);end;';
3280: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3281:
3282: -- SUPCNT
3283: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3284: itemkey => itemkey,
3285: aname => 'SUPCNT');
3286: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3287: '(itemtype => :item_type,' ||
3282: -- SUPCNT
3283: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3284: itemkey => itemkey,
3285: aname => 'SUPCNT');
3286: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3287: '(itemtype => :item_type,' ||
3288: ' itemkey => :item_key,' ||
3289: ' aname => ''SUPCNT'',' ||
3290: ' avalue => :l_text);end;';
3290: ' avalue => :l_text);end;';
3291: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3292:
3293: --SUPPLIER_ID
3294: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3295: itemkey => itemkey,
3296: aname => 'SUPPLIER_ID');
3297: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3298: '(itemtype => :item_type,' ||
3293: --SUPPLIER_ID
3294: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3295: itemkey => itemkey,
3296: aname => 'SUPPLIER_ID');
3297: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3298: '(itemtype => :item_type,' ||
3299: ' itemkey => :item_key,' ||
3300: ' aname => ''SUPPLIER_ID'',' ||
3301: ' avalue => :l_numb);end;';
3301: ' avalue => :l_numb);end;';
3302: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3303:
3304: -- SUPPLIER_NAME
3305: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3306: itemkey => itemkey,
3307: aname => 'SUPPLIER_NAME');
3308: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3309: '(itemtype => :item_type,' ||
3304: -- SUPPLIER_NAME
3305: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3306: itemkey => itemkey,
3307: aname => 'SUPPLIER_NAME');
3308: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3309: '(itemtype => :item_type,' ||
3310: ' itemkey => :item_key,' ||
3311: ' aname => ''SUPPLIER_NAME'',' ||
3312: ' avalue => :l_text);end;';
3312: ' avalue => :l_text);end;';
3313: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3314:
3315: -- SUPPLIER_SITE_CODE
3316: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3317: itemkey => itemkey,
3318: aname => 'SUPPLIER_SITE_CODE');
3319: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3320: '(itemtype => :item_type,' ||
3315: -- SUPPLIER_SITE_CODE
3316: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3317: itemkey => itemkey,
3318: aname => 'SUPPLIER_SITE_CODE');
3319: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3320: '(itemtype => :item_type,' ||
3321: ' itemkey => :item_key,' ||
3322: ' aname => ''SUPPLIER_SITE_CODE'',' ||
3323: ' avalue => :l_text);end;';
3323: ' avalue => :l_text);end;';
3324: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3325:
3326: --SUPPLIER_SITE_ID
3327: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3328: itemkey => itemkey,
3329: aname => 'SUPPLIER_SITE_ID');
3330: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3331: '(itemtype => :item_type,' ||
3326: --SUPPLIER_SITE_ID
3327: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3328: itemkey => itemkey,
3329: aname => 'SUPPLIER_SITE_ID');
3330: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3331: '(itemtype => :item_type,' ||
3332: ' itemkey => :item_key,' ||
3333: ' aname => ''SUPPLIER_SITE_ID'',' ||
3334: ' avalue => :l_numb);end;';
3334: ' avalue => :l_numb);end;';
3335: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3336:
3337: -- SUPPLy_TYPE
3338: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3339: itemkey => itemkey,
3340: aname => 'SUPPLY_TYPE');
3341: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3342: '(itemtype => :item_type,' ||
3337: -- SUPPLy_TYPE
3338: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3339: itemkey => itemkey,
3340: aname => 'SUPPLY_TYPE');
3341: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3342: '(itemtype => :item_type,' ||
3343: ' itemkey => :item_key,' ||
3344: ' aname => ''SUPPLY_TYPE'',' ||
3345: ' avalue => :l_text);end;';
3345: ' avalue => :l_text);end;';
3346: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3347:
3348: -- TASK_NUMBER
3349: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3350: itemkey => itemkey,
3351: aname => 'TASK_NUMBER');
3352: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3353: '(itemtype => :item_type,' ||
3348: -- TASK_NUMBER
3349: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3350: itemkey => itemkey,
3351: aname => 'TASK_NUMBER');
3352: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3353: '(itemtype => :item_type,' ||
3354: ' itemkey => :item_key,' ||
3355: ' aname => ''TASK_NUMBER'',' ||
3356: ' avalue => :l_text);end;';
3356: ' avalue => :l_text);end;';
3357: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3358:
3359: -- TO_DATE
3360: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3361: itemkey => itemkey,
3362: aname => 'TO_DATE');
3363: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3364: '(itemtype => :item_type,' ||
3359: -- TO_DATE
3360: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3361: itemkey => itemkey,
3362: aname => 'TO_DATE');
3363: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3364: '(itemtype => :item_type,' ||
3365: ' itemkey => :item_key,' ||
3366: ' aname => ''TO_DATE'',' ||
3367: ' avalue => :l_date);end;';
3367: ' avalue => :l_date);end;';
3368: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3369:
3370: -- TO_PRJ_MGR
3371: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3372: itemkey => itemkey,
3373: aname => 'TO_PRJ_MGR');
3374: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3375: '(itemtype => :item_type,' ||
3370: -- TO_PRJ_MGR
3371: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3372: itemkey => itemkey,
3373: aname => 'TO_PRJ_MGR');
3374: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3375: '(itemtype => :item_type,' ||
3376: ' itemkey => :item_key,' ||
3377: ' aname => ''TO_PRJ_MGR'',' ||
3378: ' avalue => :l_text);end;';
3378: ' avalue => :l_text);end;';
3379: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3380:
3381: -- TO_PROJECT_NUMBER
3382: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3383: itemkey => itemkey,
3384: aname => 'TO_PROJECT_NUMBER');
3385: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3386: '(itemtype => :item_type,' ||
3381: -- TO_PROJECT_NUMBER
3382: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3383: itemkey => itemkey,
3384: aname => 'TO_PROJECT_NUMBER');
3385: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3386: '(itemtype => :item_type,' ||
3387: ' itemkey => :item_key,' ||
3388: ' aname => ''TO_PROJECT_NUMBER'',' ||
3389: ' avalue => :l_text);end;';
3389: ' avalue => :l_text);end;';
3390: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3391:
3392: -- TO_TASK_NUMBER
3393: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3394: itemkey => itemkey,
3395: aname => 'TO_TASK_NUMBER');
3396: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3397: '(itemtype => :item_type,' ||
3392: -- TO_TASK_NUMBER
3393: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3394: itemkey => itemkey,
3395: aname => 'TO_TASK_NUMBER');
3396: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3397: '(itemtype => :item_type,' ||
3398: ' itemkey => :item_key,' ||
3399: ' aname => ''TO_TASK_NUMBER'',' ||
3400: ' avalue => :l_text);end;';
3400: ' avalue => :l_text);end;';
3401: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3402:
3403: -- URL1
3404: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3405: itemkey => itemkey,
3406: aname => 'URL1');
3407: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3408: '(itemtype => :item_type,' ||
3403: -- URL1
3404: l_text := wf_engine.GetItemAttrText( itemtype => itemtype,
3405: itemkey => itemkey,
3406: aname => 'URL1');
3407: sql_stmt := 'begin wf_engine.SetItemAttrText' || l_db_link ||
3408: '(itemtype => :item_type,' ||
3409: ' itemkey => :item_key,' ||
3410: ' aname => ''URL1'',' ||
3411: ' avalue => :l_text);end;';
3411: ' avalue => :l_text);end;';
3412: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_text;
3413:
3414: -- UTILIZATION_RATE
3415: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3416: itemkey => itemkey,
3417: aname => 'UTILIZATION_RATE');
3418: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3419: '(itemtype => :item_type,' ||
3414: -- UTILIZATION_RATE
3415: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3416: itemkey => itemkey,
3417: aname => 'UTILIZATION_RATE');
3418: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3419: '(itemtype => :item_type,' ||
3420: ' itemkey => :item_key,' ||
3421: ' aname => ''UTILIZATION_RATE'',' ||
3422: ' avalue => :l_numb);end;';
3423: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3424:
3425:
3426: -- CAPACITY_REQUIREMENT
3427: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3428: itemkey => itemkey,
3429: aname => 'CAPACITY_REQUIREMENT');
3430: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3431: '(itemtype => :item_type,' ||
3426: -- CAPACITY_REQUIREMENT
3427: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3428: itemkey => itemkey,
3429: aname => 'CAPACITY_REQUIREMENT');
3430: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3431: '(itemtype => :item_type,' ||
3432: ' itemkey => :item_key,' ||
3433: ' aname => ''CAPACITY_REQUIREMENT'',' ||
3434: ' avalue => :l_numb);end;';
3435: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3436:
3437:
3438: --REQUIRED_QUANTITY
3439: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3440: itemkey => itemkey,
3441: aname => 'REQUIRED_QUANTITY');
3442: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3443: '(itemtype => :item_type,' ||
3438: --REQUIRED_QUANTITY
3439: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3440: itemkey => itemkey,
3441: aname => 'REQUIRED_QUANTITY');
3442: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3443: '(itemtype => :item_type,' ||
3444: ' itemkey => :item_key,' ||
3445: ' aname => ''REQUIRED_QUANTITY'',' ||
3446: ' avalue => :l_numb);end;';
3447: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3448:
3449:
3450: --PROJECTED_AVAILABLE_BALANCE
3451: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3452: itemkey => itemkey,
3453: aname => 'PROJECTED_AVAILABLE_BALANCE');
3454: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3455: '(itemtype => :item_type,' ||
3450: --PROJECTED_AVAILABLE_BALANCE
3451: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3452: itemkey => itemkey,
3453: aname => 'PROJECTED_AVAILABLE_BALANCE');
3454: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3455: '(itemtype => :item_type,' ||
3456: ' itemkey => :item_key,' ||
3457: ' aname => ''PROJECTED_AVAILABLE_BALANCE'',' ||
3458: ' avalue => :l_numb);end;';
3458: ' avalue => :l_numb);end;';
3459: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3460:
3461: --AVAILABLE_QUANTITY
3462: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3463: itemkey => itemkey,
3464: aname => 'AVAILABLE_QUANTITY');
3465: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3466: '(itemtype => :item_type,' ||
3461: --AVAILABLE_QUANTITY
3462: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3463: itemkey => itemkey,
3464: aname => 'AVAILABLE_QUANTITY');
3465: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3466: '(itemtype => :item_type,' ||
3467: ' itemkey => :item_key,' ||
3468: ' aname => ''AVAILABLE_QUANTITY'',' ||
3469: ' avalue => :l_numb);end;';
3469: ' avalue => :l_numb);end;';
3470: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_numb;
3471:
3472: --QTY_RELATED_VALUES
3473: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3474: itemkey => itemkey,
3475: aname => 'QTY_RELATED_VALUES');
3476: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3477: '(itemtype => :item_type,' ||
3472: --QTY_RELATED_VALUES
3473: l_numb := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3474: itemkey => itemkey,
3475: aname => 'QTY_RELATED_VALUES');
3476: sql_stmt := 'begin wf_engine.SetItemAttrNumber' || l_db_link ||
3477: '(itemtype => :item_type,' ||
3478: ' itemkey => :item_key,' ||
3479: ' aname => ''QTY_RELATED_VALUES'',' ||
3480: ' avalue => :l_numb);end;';
3482:
3483:
3484:
3485: if (l_exception_type =70 ) then
3486: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3487: itemkey => itemkey,
3488: aname => 'DATE1');
3489: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3490: '(itemtype => :item_type,' ||
3485: if (l_exception_type =70 ) then
3486: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3487: itemkey => itemkey,
3488: aname => 'DATE1');
3489: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3490: '(itemtype => :item_type,' ||
3491: ' itemkey => :item_key,' ||
3492: ' aname => ''DATE1'',' ||
3493: ' avalue => :l_date);end;';
3492: ' aname => ''DATE1'',' ||
3493: ' avalue => :l_date);end;';
3494: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3495:
3496: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3497: itemkey => itemkey,
3498: aname => 'DATE2');
3499: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3500: '(itemtype => :item_type,' ||
3495:
3496: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3497: itemkey => itemkey,
3498: aname => 'DATE2');
3499: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3500: '(itemtype => :item_type,' ||
3501: ' itemkey => :item_key,' ||
3502: ' aname => ''DATE2'',' ||
3503: ' avalue => :l_date);end;';
3501: ' itemkey => :item_key,' ||
3502: ' aname => ''DATE2'',' ||
3503: ' avalue => :l_date);end;';
3504: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3505: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3506: itemkey => itemkey,
3507: aname => 'DATE3');
3508: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3509: '(itemtype => :item_type,' ||
3504: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3505: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3506: itemkey => itemkey,
3507: aname => 'DATE3');
3508: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3509: '(itemtype => :item_type,' ||
3510: ' itemkey => :item_key,' ||
3511: ' aname => ''DATE3'',' ||
3512: ' avalue => :l_date);end;';
3510: ' itemkey => :item_key,' ||
3511: ' aname => ''DATE3'',' ||
3512: ' avalue => :l_date);end;';
3513: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3514: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3515: itemkey => itemkey,
3516: aname => 'DATE4');
3517: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3518: '(itemtype => :item_type,' ||
3513: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3514: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3515: itemkey => itemkey,
3516: aname => 'DATE4');
3517: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3518: '(itemtype => :item_type,' ||
3519: ' itemkey => :item_key,' ||
3520: ' aname => ''DATE4'',' ||
3521: ' avalue => :l_date);end;';
3519: ' itemkey => :item_key,' ||
3520: ' aname => ''DATE4'',' ||
3521: ' avalue => :l_date);end;';
3522: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3523: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3524: itemkey => itemkey,
3525: aname => 'DATE5');
3526: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3527: '(itemtype => :item_type,' ||
3522: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3523: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3524: itemkey => itemkey,
3525: aname => 'DATE5');
3526: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3527: '(itemtype => :item_type,' ||
3528: ' itemkey => :item_key,' ||
3529: ' aname => ''DATE5'',' ||
3530: ' avalue => :l_date);end;';
3528: ' itemkey => :item_key,' ||
3529: ' aname => ''DATE5'',' ||
3530: ' avalue => :l_date);end;';
3531: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3532: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3533: itemkey => itemkey,
3534: aname => 'DATE6');
3535: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3536: '(itemtype => :item_type,' ||
3531: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3532: l_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3533: itemkey => itemkey,
3534: aname => 'DATE6');
3535: sql_stmt := 'begin wf_engine.SetItemAttrDate' || l_db_link ||
3536: '(itemtype => :item_type,' ||
3537: ' itemkey => :item_key,' ||
3538: ' aname => ''DATE6'',' ||
3539: ' avalue => :l_date);end;';
3540: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key,l_date;
3541: end if; -- end of if (l_exception_type = 70)
3542: -- now start wf process at destination instance
3543:
3544: sql_stmt := 'begin wf_engine.StartProcess'|| l_db_link ||
3545: '( itemtype => :itemtype,' ||
3546: ' itemkey => :itemkey);end;';
3547: EXECUTE IMMEDIATE sql_stmt USING l_sr_item_type,l_sr_item_key;
3548:
3552: execute immediate 'alter session close database link '||
3553: ltrim(l_db_link,'@');
3554: exception
3555: when others then
3556: wf_engine.SetItemAttrNumber( itemtype => itemtype,
3557: itemkey => itemkey,
3558: aname => 'SR_REQUEST_ID',
3559: avalue => -1);
3560: end;
3558: aname => 'SR_REQUEST_ID',
3559: avalue => -1);
3560: end;
3561: end if;
3562: wf_engine.SetItemAttrNumber( itemtype => itemtype,
3563: itemkey => itemkey,
3564: aname => 'SR_REQUEST_ID',
3565: avalue => p_request_id);
3566:
3634: end loop;
3635: if v_dummy = 1 then
3636: FND_FILE.PUT_LINE(FND_FILE.LOG,
3637: 'start backgroud process for'||p_item_type);
3638: wf_engine.background(p_item_type);
3639: end if;
3640: END start_deferred_activity;
3641:
3642: FUNCTION demand_order_type (p_plan_id number,