The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into po_supplier_item_capacity
(CAPACITY_ID,
ASL_ID,
USING_ORGANIZATION_ID,
FROM_DATE,
TO_DATE,
CAPACITY_PER_DAY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATION_DATE,
CREATED_BY)
values (
po_supplier_item_capacity_s.nextval,
to_number(p_asl_id),
-1,
to_date(p_from_date, 'YYYY-MM-DD'),
to_date(p_to_date, 'YYYY-MM-DD'),
p_capacity_per_day,
sysdate,
p_user_id,
p_user_id,
sysdate,
p_user_id);
PROCEDURE Update_Line
( p_asl_id IN VARCHAR2
, p_capacity_id IN NUMBER
, p_from_date IN VARCHAR2
, p_to_date IN VARCHAR2
, p_capacity_per_day IN NUMBER
, p_user_id IN NUMBER
)
IS
sourcedate date;
UPDATE po_supplier_item_capacity
SET
FROM_DATE = sourcedate,
TO_DATE = destdate,
CAPACITY_PER_DAY = p_capacity_per_day,
last_update_date = Sysdate,
last_updated_by = p_user_id,
last_update_login = p_user_id
WHERE
asl_id = To_number(p_asl_id) AND capacity_id = p_capacity_id;
END update_line;
PROCEDURE Delete_Line
( p_asl_id IN VARCHAR2
, p_capacity_id IN NUMBER
)
IS
BEGIN
DELETE from po_supplier_item_capacity
WHERE
asl_id = To_number(p_asl_id) AND capacity_id = p_capacity_id;
END delete_line;