APPS.CSP_REQUIREMENT_LINES_CUHK SQL Statements

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

Line: 89

  PROCEDURE  Update_requirement_line_pre
  (
    px_requirement_line      IN OUT NOCOPY  CSP_REQUIREMENT_LINES_PVT.Requirement_Line_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) := 'create_inventory_location_Pre' ;

Line: 124

END Update_requirement_line_Pre;

Line: 126

  PROCEDURE  Update_requirement_line_post
  (
    px_requirement_line      IN OUT NOCOPY   CSP_REQUIREMENT_LINES_PVT.Requirement_Line_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) := 'create_inventory_location_Pre' ;

Line: 161

END Update_requirement_line_Post;

Line: 162

  PROCEDURE  Delete_requirement_line_pre
  (
    p_line_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) := 'create_inventory_location_Pre' ;

Line: 197

END Delete_requirement_line_Pre;

Line: 198

  PROCEDURE  Delete_requirement_line_post
  (
    p_line_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) := 'create_inventory_location_Pre' ;

Line: 233

END delete_requirement_line_post;