APPS.CSF_DEBRIEF_LINES_CUHK SQL Statements

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

Line: 84

  PROCEDURE  Update_debrief_line_pre
  (
    px_debrief_line    IN OUT NOCOPY  CSF_DEBRIEF_PUB.DEBRIEF_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_debrief_line_Pre' ;

Line: 119

END Update_debrief_line_pre;

Line: 121

  PROCEDURE  Update_debrief_line_post
  (
    px_debrief_line    IN OUT NOCOPY   CSF_DEBRIEF_PUB.DEBRIEF_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_debrief_line_Pre' ;

Line: 156

END Update_debrief_line_post;

Line: 157

  PROCEDURE  Delete_debrief_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_debrief_line_Pre' ;

Line: 192

END Delete_debrief_line_pre;

Line: 193

  PROCEDURE  Delete_debrief_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_debrief_line_Pre' ;

Line: 228

END Delete_debrief_line_post;