APPS.MTL_MGD_INV_POSITIONS_PKG SQL Statements

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

Line: 29

PROCEDURE Insert_Row
( p_data_set_name             IN  VARCHAR2
, p_bucket_name               IN  VARCHAR2
, p_organization_code         IN  VARCHAR2
, p_inventory_item_code       IN  VARCHAR2
, p_creation_date             IN  DATE DEFAULT NULL
, p_created_by                IN   NUMBER  DEFAULT NULL
, p_last_update_date          IN  DATE DEFAULT NULL
, p_last_updated_by           IN  NUMBER DEFAULT NULL
, p_last_update_login         IN  NUMBER DEFAULT NULL
, p_request_id                IN  NUMBER DEFAULT NULL
, p_program_application_id    IN  NUMBER DEFAULT NULL
, p_program_id                IN  NUMBER DEFAULT NULL
, p_program_update_date       IN  DATE DEFAULT NULL
, p_hierarchy_id              IN  NUMBER
, p_hierarchy_name            IN  VARCHAR2
, p_parent_organization_code  IN  VARCHAR2
, p_parent_organization_id    IN  VARCHAR2
, p_bucket_size_code          IN  VARCHAR2
, p_bucket_start_date         IN  DATE
, p_bucket_end_date           IN  DATE
, p_inventory_item_id         IN  NUMBER
, p_organization_id           IN  NUMBER
, p_hierarchy_delta_qty       IN  NUMBER
, p_hierarchy_end_on_hand_qty IN  NUMBER
, p_org_received_qty          IN  NUMBER
, p_org_issued_qty            IN  NUMBER
, p_org_delta_qty             IN  NUMBER
, p_org_end_on_hand_qty       IN  NUMBER
)
IS
BEGIN
  INSERT INTO mtl_mgd_inventory_positions
  ( data_set_name
  , bucket_name
  , organization_code
  , inventory_item_code
  , creation_date
  , created_by
  , last_update_date
  , last_updated_by
  , last_update_login
  , request_id
  , program_application_id
  , program_id
  , program_update_date
  , hierarchy_id
  , hierarchy_name
  , parent_organization_code
  , parent_organization_id
  , bucket_size_code
  , bucket_start_date
  , bucket_end_date
  , inventory_item_id
  , organization_id
  , hierarchy_delta_qty
  , hierarchy_end_on_hand_qty
  , org_received_qty
  , org_issued_qty
  , org_delta_qty
  , org_end_on_hand_qty
  )
  VALUES
  ( p_data_set_name
  , p_bucket_name
  , p_organization_code
  , p_inventory_item_code
  , NVL(p_creation_date, SYSDATE)
  , NVL(p_created_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
  , NVL(p_last_update_date, SYSDATE)
  , NVL(p_last_updated_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
  , NVL(p_last_update_login, TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')))
  , NVL(p_request_id, TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID')))
  , NVL(p_program_application_id,TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID')))
  , NVL(p_program_id, TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID')))
  , NVL(p_program_update_date, SYSDATE)
  , p_hierarchy_id
  , p_hierarchy_name
  , p_parent_organization_code
  , p_parent_organization_id
  , p_bucket_size_code
  , p_bucket_start_date
  , p_bucket_end_date
  , p_inventory_item_id
  , p_organization_id
  , p_hierarchy_delta_qty
  , p_hierarchy_end_on_hand_qty
  , p_org_received_qty
  , p_org_issued_qty
  , p_org_delta_qty
  , p_org_end_on_hand_qty
  );

Line: 121

END Insert_Row;

Line: 133

PROCEDURE Update_Hierarchy_Data
( p_data_set_name             IN  VARCHAR2
, p_bucket_name               IN  VARCHAR2
, p_organization_id           IN  NUMBER
, p_inventory_item_id         IN  NUMBER
, p_last_update_date          IN  DATE   DEFAULT NULL
, p_last_updated_by           IN  NUMBER DEFAULT NULL
, p_last_update_login         IN  NUMBER DEFAULT NULL
, p_request_id                IN  NUMBER DEFAULT NULL
, p_program_application_id    IN  NUMBER DEFAULT NULL
, p_program_id                IN  NUMBER DEFAULT NULL
, p_program_update_date       IN  DATE   DEFAULT NULL
, p_hierarchy_delta_qty       IN  NUMBER
, p_hierarchy_end_on_hand_qty IN  NUMBER
)
IS
BEGIN

  UPDATE mtl_mgd_inventory_positions
    SET  last_update_date          = NVL(p_last_update_date, SYSDATE)
      ,  last_updated_by           = NVL
                                     ( p_last_updated_by
                                     , NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0)
                                     )
      ,  last_update_login         = NVL
                                     ( p_last_update_login
                                     , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
                                     )
      ,  request_id                = NVL
                                    ( p_request_id
                                    , TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID'))
                                    )
      ,  program_application_id    = NVL
                                     ( p_program_application_id
                                     , TO_NUMBER
                                       (FND_PROFILE.Value('PROG_APPL_ID'))
                                     )
      ,  program_id                = NVL
                                     ( p_program_id
                                     , TO_NUMBER
                                       (FND_PROFILE.Value('CONC_PROG_ID'))
                                     )
      ,  program_update_date       = NVL(p_program_update_date, SYSDATE)
      ,  hierarchy_delta_qty       = p_hierarchy_delta_qty
      ,  hierarchy_end_on_hand_qty = p_hierarchy_end_on_hand_qty
   WHERE data_set_name     = p_data_set_name
     AND bucket_name       = p_bucket_name
     AND organization_id   = p_organization_id
     AND inventory_item_id = p_inventory_item_id;

Line: 183

END Update_Hierarchy_Data;

Line: 193

PROCEDURE Delete
( p_data_set_name             IN  VARCHAR2 DEFAULT NULL
, p_created_by                IN  NUMBER   DEFAULT NULL
, p_creation_date             IN  DATE     DEFAULT NULL
)
IS
BEGIN
  DELETE
    FROM  mtl_mgd_inventory_positions
    WHERE data_set_name  = NVL(p_data_set_name, data_set_name)
      AND created_by     = NVL(p_created_by, created_by)
      AND creation_date <= NVL(p_creation_date, creation_date);

Line: 205

END Delete;

Line: 211

PROCEDURE Delete_All
IS
BEGIN
  DELETE
    FROM  mtl_mgd_inventory_positions;

Line: 216

END Delete_All;