1340: -- init global variables
1341: g_ErrorCode := '';
1342:
1343:
1344: -- delete records from MSC_SAFETY_STOCKS table for the given PlanId, if any
1345: BEGIN
1346: DELETE FROM MSC_SAFETY_STOCKS WHERE PLAN_ID=PlanIdVar;
1347: EXCEPTION WHEN others THEN
1348: NULL; -- do nothing
1342:
1343:
1344: -- delete records from MSC_SAFETY_STOCKS table for the given PlanId, if any
1345: BEGIN
1346: DELETE FROM MSC_SAFETY_STOCKS WHERE PLAN_ID=PlanIdVar;
1347: EXCEPTION WHEN others THEN
1348: NULL; -- do nothing
1349: END;
1350:
1349: END;
1350:
1351: BEGIN
1352: -- CODE GOES HERE
1353: INSERT INTO MSC_SAFETY_STOCKS (PLAN_ID,
1354: ORGANIZATION_ID,
1355: SR_INSTANCE_ID,
1356: INVENTORY_ITEM_ID,
1357: PERIOD_START_DATE,
1369: WHERE PLAN_ID=PlanIdVar;
1370: -- NOTE: Last four fields: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY are non-NULL,
1371: -- so I harcoded an arbitrary value
1372: EXCEPTION WHEN others THEN
1373: g_ErrorCode := 'ERROR_UPDATE_MSC_SAFETY_STOCKS_001001' || ' : ' || SQLERRM;
1374: raise;
1375: END;
1376:
1377: