APPS.IGW_PROP_USER_ROLES_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_role_id               in		NUMBER,
	p_mode 			in 		VARCHAR2 default 'R',
	x_return_status         out NOCOPY  		VARCHAR2
	) is

cursor c is select ROWID from IGW_PROP_USER_ROLES
      where proposal_id = p_proposal_id
      and   user_id = p_user_id
      and   role_id = p_role_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_user_roles (
        proposal_id,
 	user_id,
 	role_id,
 	last_update_date,
 	last_updated_by,
 	creation_date,
 	created_by,
 	last_update_login,
 	record_version_number
  ) values (
        p_proposal_id,
 	p_user_id,
 	p_role_id,
 	l_last_update_date,
 	l_last_updated_by,
 	l_last_update_date,
 	l_last_updated_by,
 	l_last_update_login,
 	1
  );

Line: 80

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

Line: 85

END INSERT_ROW;

Line: 88

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

    l_last_update_date 		DATE;

Line: 99

    l_last_updated_by 		NUMBER;

Line: 100

    l_last_update_login 	NUMBER;

Line: 106

     l_last_update_date := SYSDATE;

Line: 108

          l_last_updated_by := 1;

Line: 109

          l_last_update_login := 0;

Line: 111

          l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 113

          if l_last_updated_by is NULL then
                l_last_updated_by := -1;

Line: 117

          l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 119

          if l_last_update_login is NULL then
                l_last_update_login := -1;

Line: 127

      update IGW_PROP_USER_ROLES set
    	    proposal_id = p_proposal_id,
 	    user_id = p_user_id,
 	    role_id = p_role_id,
 	    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: 147

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

Line: 152

END UPDATE_ROW;

Line: 155

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

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

Line: 178

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

Line: 183

END DELETE_ROW;

Line: 200

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

Line: 209

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

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

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

Line: 261

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