The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure insert_row
( p_seq_id IN OUT NOCOPY number
, p_created_by IN OUT NOCOPY number
, p_creation_date IN OUT NOCOPY date
, p_last_updated_by IN OUT NOCOPY number
, p_last_update_date IN OUT NOCOPY date
, p_last_update_login IN OUT NOCOPY number
, p_object_version_number IN OUT NOCOPY number
, p_icon_file_name IN varchar2
, p_description IN varchar2
, P_RANKING IN number
, P_ACTIVE IN VARCHAR2
)
is
begin
if p_created_by is null then
p_created_by := fnd_global.user_id;
if p_last_updated_by is null then
p_last_updated_by := fnd_global.user_id;
if p_last_update_login is null then
p_last_update_login := fnd_global.login_id;
if p_last_update_date is null then
p_last_update_date := sysdate;
insert into csf_gnticons_setup_b
( seq_id
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, object_version_number
, icon_file_name
, description
, ranking
, active
)
values
( p_seq_id
, p_created_by
, p_creation_date
, p_last_updated_by
, p_last_update_date
, p_last_update_login
, p_object_version_number
, p_icon_file_name
, p_description
, p_ranking
, p_active
);
end insert_row;
procedure update_row
( p_seq_id IN OUT NOCOPY number
, p_created_by IN OUT NOCOPY number
, p_creation_date IN OUT NOCOPY date
, p_last_updated_by IN OUT NOCOPY number
, p_last_update_date IN OUT NOCOPY date
, p_last_update_login IN OUT NOCOPY number
, p_object_version_number IN OUT NOCOPY number
, p_icon_file_name IN varchar2
, p_description IN varchar2
, p_RANKING IN number
, p_ACTIVE IN VARCHAR2
)
is
begin
if p_last_updated_by is null then
p_last_updated_by := fnd_global.user_id;
if p_last_update_login is null then
p_last_update_login := fnd_global.login_id;
if p_last_update_date is null then
p_last_update_date := sysdate;
update csf_gnticons_setup_b
set
last_updated_by = p_last_updated_by
, last_update_date = p_last_update_date
, last_update_login = p_last_update_login
, object_version_number = p_object_version_number
, icon_file_name = p_icon_file_name
, description = p_description
, ranking = p_ranking
, active = p_active
where seq_id = p_seq_id;
end update_row;
l_update_date date ;
l_update_date := sysdate;
update_row
( p_seq_id => l_seq_id
, p_created_by => l_user
, p_creation_date => l_update_date
, p_last_updated_by => l_user
, p_last_update_date => l_update_date
, p_last_update_login => l_user
, p_object_version_number => l_object_version_number
, p_icon_file_name => p_icon_file_name
, p_description => p_description
, p_ranking => to_number(p_ranking)
, p_active => p_active
);
insert_row
( p_seq_id => l_seq_id
, p_created_by => l_user
, p_creation_date => l_update_date
, p_last_updated_by => l_user
, p_last_update_date => l_update_date
, p_last_update_login => l_user
, p_object_version_number => l_object_version_number
, p_icon_file_name => p_icon_file_name
, p_description => p_description
, p_ranking => to_number(p_ranking)
, p_active => p_active
);
PROCEDURE insert_rows
( p_setup_type IN varchar2
, p_tooltip_setup_tbl IN tooltip_setup_tbl
, p_delete_rows IN boolean
, p_user_id IN number
, p_login_id IN number
)
IS
BEGIN
for i in p_tooltip_setup_tbl.first..p_tooltip_setup_tbl.last
loop
insert into csf_gantt_chart_setup
(created_by,creation_date,last_updated_by, last_update_date, last_update_login, user_id, setup_type, seq_no, field_name, field_value)
values (p_user_id, sysdate, p_user_id,sysdate,p_login_id, p_user_id,p_setup_type,p_tooltip_setup_tbl(i).seq_no,p_tooltip_setup_tbl(i).field_name,p_tooltip_setup_tbl(i).field_value);
END INSERT_ROWS;