APPS.CSP_INV_LOC_ASSIGNMENTS_CUHK SQL Statements

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

Line: 86

  PROCEDURE  Update_inventory_location_pre
  (
    px_inv_loc_assignment    IN OUT NOCOPY  CSP_INV_LOC_ASSIGNMENTS_PKG.inv_loc_assignments_rec_type,
    x_return_status          OUT NOCOPY   VARCHAR2,
    x_msg_count              OUT NOCOPY   NUMBER,
    x_msg_data               OUT NOCOPY   VARCHAR2
  ) IS
      l_api_name varchar2(200) := 'Update_inventory_location_Pre' ;

Line: 120

END Update_inventory_location_pre;

Line: 123

  PROCEDURE  Update_inventory_location_post
  (
    px_inv_loc_assignment    IN OUT NOCOPY   CSP_INV_LOC_ASSIGNMENTS_PKG.inv_loc_assignments_rec_type,
    x_return_status          OUT NOCOPY   VARCHAR2,
    x_msg_count              OUT NOCOPY   NUMBER,
    x_msg_data               OUT NOCOPY   VARCHAR2
  ) IS
        l_api_name varchar2(200) := 'Update_inventory_location_post' ;

Line: 157

END Update_inventory_location_post;

Line: 158

  PROCEDURE  Delete_inventory_location_pre
  (
    p_inv_loc_assignment_id  IN   NUMBER,
    x_return_status          OUT NOCOPY   VARCHAR2,
    x_msg_count              OUT NOCOPY   NUMBER,
    x_msg_data               OUT NOCOPY   VARCHAR2
  ) IS
   l_api_name varchar2(200) := 'Delete_inventory_location_Pre' ;

Line: 192

  END Delete_inventory_location_pre;

Line: 193

  PROCEDURE  Delete_inventory_location_post
  (
    p_inv_loc_assignment_id  IN   NUMBER,
    x_return_status          OUT NOCOPY   VARCHAR2,
    x_msg_count              OUT NOCOPY   NUMBER,
    x_msg_data               OUT NOCOPY   VARCHAR2
  ) IS
     l_api_name varchar2(200) := 'Delete_inventory_location_post' ;

Line: 227

 END Delete_inventory_location_post;