APPS.CSP_REQUIREMENT_HEADERS_CUHK SQL Statements

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

Line: 86

  PROCEDURE  Update_requirement_header_pre
  (
    px_requirement_header    IN OUT NOCOPY  CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_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: 121

END Update_requirement_header_pre;

Line: 123

  PROCEDURE  Update_requirement_header_post
  (
    px_requirement_header    IN OUT NOCOPY   CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_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: 158

END Update_requirement_header_post;

Line: 159

  PROCEDURE  Delete_requirement_header_pre
  (
    p_header_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: 194

END Delete_requirement_header_pre;

Line: 195

  PROCEDURE  Delete_requirement_header_post
  (
    p_header_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: 230

END Delete_requirement_header_post;