APPS.GMS_AWARD_MANAGER_PKG SQL Statements

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

Line: 4

PROCEDURE insert_award_manager_id
(
 x_AWARD_ID in number ,
 x_qk_award_manager_id in number,
 x_start_date_active in date
)
IS
personnel_id number;

Line: 12

x_last_update_date date;

Line: 13

x_last_updated_by number;

Line: 14

x_last_update_login number;

Line: 18

x_last_update_date := sysdate;

Line: 19

x_last_updated_by := fnd_global.user_id;

Line: 20

x_last_update_login := fnd_global.user_id;

Line: 23

select gms_personnel_s.nextval
into personnel_id
from dual;

Line: 26

insert into gms_personnel
(AWARD_ID   ,
PERSON_ID    ,
AWARD_ROLE    ,
START_DATE_ACTIVE,
LAST_UPDATE_DATE       ,
LAST_UPDATED_BY        ,
CREATION_DATE          ,
CREATED_BY         ,
LAST_UPDATE_LOGIN   ,
PERSONNEL_ID )
values
(
 x_AWARD_ID,
 x_qk_award_manager_id,
 'AM',
 x_start_date_active,
 x_last_update_date ,
 x_last_updated_by,
 x_creation_date ,
 x_created_by ,
 x_last_update_login ,
 personnel_id
);