APPS.IGW_PROP_PERSON_QUESTIONS_TBH SQL Statements

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

Line: 4

PROCEDURE INSERT_ROW (
	x_rowid 		out NOCOPY 		VARCHAR2,
        p_proposal_id		in              NUMBER,
 	p_party_id              in 		NUMBER,
 	p_person_id             in 		NUMBER,
 	p_question_number       in              VARCHAR2,
	p_answer     		in		VARCHAR2,
 	p_explanation           in		VARCHAR2,
 	p_review_date           in              DATE,
	p_mode 			in 		VARCHAR2,
	x_return_status         out NOCOPY  		VARCHAR2
	) is

cursor c is select ROWID from IGW_PROP_PERSON_QUESTIONS
      where proposal_id = p_proposal_id
      and   party_id = p_party_id
      and   question_number = p_question_number;

Line: 22

      l_last_update_date 	DATE;

Line: 23

      l_last_updated_by 	NUMBER;

Line: 24

      l_last_update_login 	NUMBER;

Line: 29

  l_last_update_date := SYSDATE;

Line: 32

      l_last_updated_by := 1;

Line: 33

      l_last_update_login := 0;

Line: 35

       l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 37

       if l_last_updated_by is NULL then
            l_last_updated_by := -1;

Line: 41

       l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 43

       if l_last_update_login is NULL then
            l_last_update_login := -1;

Line: 51

insert into igw_prop_person_questions (
        proposal_id,
        party_id,
 	person_id,
 	question_number,
 	answer,
 	explanation,
 	review_date,
 	last_update_date,
 	last_updated_by,
 	creation_date,
 	created_by,
 	last_update_login,
 	record_version_number
  ) values (
        p_proposal_id,
        p_party_id,
 	p_person_id,
	p_question_number,
 	p_answer,
 	p_explanation,
 	p_review_date,
 	l_last_update_date,
 	l_last_updated_by,
 	l_last_update_date,
 	l_last_updated_by,
 	l_last_update_login,
 	1
  );

Line: 92

      			        p_procedure_name 	=> 	'INSERT_ROW',
      			        p_error_text  		=>  	 SUBSTRB(SQLERRM, 1, 240));

Line: 97

END INSERT_ROW;

Line: 100

PROCEDURE UPDATE_ROW (
	x_rowid 		in 		VARCHAR2,
	p_record_version_number in              NUMBER,
        p_proposal_id		in              NUMBER,
 	p_party_id              in 		NUMBER,
 	p_person_id             in 		NUMBER,
 	p_question_number       in              VARCHAR2,
	p_answer     		in		VARCHAR2,
 	p_explanation           in		VARCHAR2,
 	p_review_date           in              DATE,
	p_mode 			in 		VARCHAR2,
	x_return_status         out NOCOPY  		VARCHAR2
	) is

    l_last_update_date 		DATE;

Line: 115

    l_last_updated_by 		NUMBER;

Line: 116

    l_last_update_login 	NUMBER;

Line: 121

     l_last_update_date := SYSDATE;

Line: 123

          l_last_updated_by := 1;

Line: 124

          l_last_update_login := 0;

Line: 126

          l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 128

          if l_last_updated_by is NULL then
                l_last_updated_by := -1;

Line: 132

          l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 134

          if l_last_update_login is NULL then
                l_last_update_login := -1;

Line: 142

      update IGW_PROP_PERSON_QUESTIONS set
            proposal_id = p_proposal_id,
            party_id = p_party_id,
 	    person_id = p_person_id,
 	    question_number = p_question_number,
 	    answer = p_answer,
 	    explanation = p_explanation,
 	    review_date = p_review_date,
 	    last_update_date = l_last_update_date,
 	    last_updated_by = l_last_updated_by,
 	    last_update_login = l_last_update_login,
 	    record_version_number = record_version_number + 1
      where rowid = x_rowid
      and record_version_number = p_record_version_number;

Line: 167

         			   p_procedure_name 		=> 	'UPDATE_ROW',
         			   p_error_text  		=>  	 SUBSTRB(SQLERRM, 1, 240));

Line: 172

END UPDATE_ROW;

Line: 175

PROCEDURE DELETE_ROW (
  x_rowid 			in 	VARCHAR2,
  p_record_version_number 	in 	NUMBER,
  x_return_status       	out NOCOPY  	VARCHAR2
) is

BEGIN
 x_return_status := fnd_api.g_ret_sts_success;

Line: 184

       delete from IGW_PROP_PERSON_QUESTIONS
       where rowid = x_rowid
       and record_version_number = p_record_version_number;

Line: 198

         			   p_procedure_name 		=> 	'DELETE_ROW',
         			   p_error_text  		=>  	 SUBSTRB(SQLERRM, 1, 240));

Line: 203

END DELETE_ROW;