APPS.IGW_PROP_USERS_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_user_id               in 		NUMBER,
	p_start_date_active     in		DATE,
 	p_end_date_active       in		DATE,
	p_mode 			in 		VARCHAR2 default 'R',
	x_return_status         out NOCOPY  		VARCHAR2
	) is

cursor c is select ROWID from IGW_PROP_USERS
      where proposal_id = p_proposal_id
      and   user_id = p_user_id;

Line: 18

      l_last_update_date 	DATE;

Line: 19

      l_last_updated_by 	NUMBER;

Line: 20

      l_last_update_login 	NUMBER;

Line: 25

  l_last_update_date := SYSDATE;

Line: 28

      l_last_updated_by := 1;

Line: 29

      l_last_update_login := 0;

Line: 31

       l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 33

       if l_last_updated_by is NULL then
            l_last_updated_by := -1;

Line: 37

       l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 39

       if l_last_update_login is NULL then
            l_last_update_login := -1;

Line: 47

insert into igw_prop_users (
        proposal_id,
 	user_id,
 	start_date_active,
 	end_date_active,
 	last_update_date,
 	last_updated_by,
 	creation_date,
 	created_by,
 	last_update_login,
 	record_version_number
  ) values (
        p_proposal_id,
 	p_user_id,
	p_start_date_active,
 	p_end_date_active,
 	l_last_update_date,
 	l_last_updated_by,
 	l_last_update_date,
 	l_last_updated_by,
 	l_last_update_login,
 	1
  );

Line: 82

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

Line: 87

END INSERT_ROW;

Line: 90

PROCEDURE UPDATE_ROW (
  	x_rowid 		in  		VARCHAR2,
  	p_record_version_number in              NUMBER,
        p_proposal_id		in              NUMBER,
 	p_user_id               in 		NUMBER,
	p_start_date_active     in		DATE,
 	p_end_date_active       in		DATE,
	p_mode 			in 		VARCHAR2 default 'R',
	x_return_status         out NOCOPY  		VARCHAR2
	) is

    l_last_update_date 		DATE;

Line: 102

    l_last_updated_by 		NUMBER;

Line: 103

    l_last_update_login 	NUMBER;

Line: 108

     l_last_update_date := SYSDATE;

Line: 110

          l_last_updated_by := 1;

Line: 111

          l_last_update_login := 0;

Line: 113

          l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 115

          if l_last_updated_by is NULL then
                l_last_updated_by := -1;

Line: 119

          l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 121

          if l_last_update_login is NULL then
                l_last_update_login := -1;

Line: 129

      update IGW_PROP_USERS set
            proposal_id = p_proposal_id,
 	    user_id = p_user_id,
 	    start_date_active = p_start_date_active,
 	    end_date_active = p_end_date_active,
 	    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: 151

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

Line: 156

END UPDATE_ROW;

Line: 159

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: 168

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

Line: 182

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

Line: 187

END DELETE_ROW;

Line: 203

  cursor c1 is select rowid from IGW_BUSINESS_RULES_ALL
     where RULE_ID = X_RULE_ID
  ;

Line: 212

    INSERT_ROW (
     X_ROWID,
     X_RULE_ID,
     X_RULE_SEQUENCE_NUMBER,
     X_ORGANIZATION_ID,
     X_RULE_NAME,
     X_RULE_TYPE,
     X_MAP_ID,
     X_VALID_FLAG,
     X_START_DATE_ACTIVE,
     X_END_DATE_ACTIVE,
     X_MODE);

Line: 227

  UPDATE_ROW (
   X_RULE_ID,
   X_RULE_SEQUENCE_NUMBER,
   X_ORGANIZATION_ID,
   X_RULE_NAME,
   X_RULE_TYPE,
   X_MAP_ID,
   X_VALID_FLAG,
   X_START_DATE_ACTIVE,
   X_END_DATE_ACTIVE,
   X_MODE);

Line: 254

  cursor c1 is select *
    from IGW_BUSINESS_RULES_ALL
    where ROWID = X_ROWID
    for update of RULE_ID nowait;

Line: 264

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');