APPS.POS_SUPPLIER_ITEM_CAPACITY_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

   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);

Line: 56

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;

Line: 74

   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;

Line: 90

END update_line;

Line: 93

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;

Line: 108

END delete_line;