The following lines contain the word 'select', 'insert', 'update' or 'delete':
pqp_flxdu_columns_pkg.update_row
(x_flxdu_column_id => x_flxdu_column_id
,x_flxdu_column_name => x_flxdu_column_name
,x_flxdu_column_xml_tag => x_flxdu_column_xml_tag
,x_flxdu_column_data_type => x_flxdu_column_data_type
,x_flxdu_column_data_length => x_flxdu_column_data_length
,x_flxdu_seq_num => x_flxdu_seq_num
,x_flxdu_group_name => x_flxdu_group_name
,x_entity_type => x_entity_type
,x_required_flag => x_required_flag
,x_display_flag => x_display_flag
,x_description => x_description
,x_flxdu_column_xml_data => x_flxdu_column_xml_data
,x_object_version_number => x_object_version_number
,x_created_by => 1
,x_creation_date => sysdate
,x_last_update_date => sysdate
,x_last_updated_by => 1
,x_last_update_login => 0 );
pqp_flxdu_columns_pkg.insert_row
(x_flxdu_column_id => x_flxdu_column_id
,x_flxdu_column_name => x_flxdu_column_name
,x_flxdu_column_xml_tag => x_flxdu_column_xml_tag
,x_flxdu_column_data_type => x_flxdu_column_data_type
,x_flxdu_column_data_length => x_flxdu_column_data_length
,x_flxdu_seq_num => x_flxdu_seq_num
,x_flxdu_group_name => x_flxdu_group_name
,x_entity_type => x_entity_type
,x_required_flag => x_required_flag
,x_display_flag => x_display_flag
,x_description => x_description
,x_flxdu_column_xml_data => x_flxdu_column_xml_data
,x_object_version_number => x_object_version_number
,x_created_by => 1
,x_creation_date => sysdate
,x_last_update_date => sysdate
,x_last_updated_by => 1
,x_last_update_login => 0 );
PROCEDURE insert_row
(x_flxdu_column_id IN NUMBER
,x_flxdu_column_name IN VARCHAR2
,x_flxdu_column_xml_tag IN VARCHAR2
,x_flxdu_column_data_type IN VARCHAR2
,x_flxdu_column_data_length IN VARCHAR2
,x_flxdu_seq_num IN NUMBER
,x_flxdu_group_name IN VARCHAR2
,x_entity_type IN VARCHAR2
,x_required_flag IN VARCHAR2
,x_display_flag IN VARCHAR2
,x_description IN VARCHAR2
,x_flxdu_column_xml_data IN VARCHAR2
,x_object_version_number IN NUMBER
,x_created_by IN NUMBER
,x_creation_date IN DATE
,x_last_update_date IN DATE
,x_last_updated_by IN NUMBER
,x_last_update_login IN NUMBER) is
-- cursor to find no of rows being inserted
CURSOR cur_flxdu_columns IS
SELECT rowid
FROM pqp_flxdu_columns;
INSERT INTO pqp_flxdu_columns
(flxdu_column_id
,flxdu_column_name
,flxdu_column_xml_tag
,flxdu_column_data_type
,flxdu_column_data_length
,flxdu_seq_num
,flxdu_group_name
,entity_type
,required_flag
,display_flag
,description
,flxdu_column_xml_data
,object_version_number
,created_by
,creation_date
,last_update_date
,last_updated_by
,last_update_login)
VALUES
(x_flxdu_column_id
,x_flxdu_column_name
,x_flxdu_column_xml_tag
,x_flxdu_column_data_type
,x_flxdu_column_data_length
,x_flxdu_seq_num
,x_flxdu_group_name
,x_entity_type
,x_required_flag
,x_display_flag
,x_description
,x_flxdu_column_xml_data
,x_object_version_number
,x_created_by
,x_creation_date
,x_last_update_date
,x_last_updated_by
,x_last_update_login);
END insert_row;
PROCEDURE update_row
(x_flxdu_column_id IN NUMBER
,x_flxdu_column_name IN VARCHAR2
,x_flxdu_column_xml_tag IN VARCHAR2
,x_flxdu_column_data_type IN VARCHAR2
,x_flxdu_column_data_length IN VARCHAR2
,x_flxdu_seq_num IN NUMBER
,x_flxdu_group_name IN VARCHAR2
,x_entity_type IN VARCHAR2
,x_required_flag IN VARCHAR2
,x_display_flag IN VARCHAR2
,x_description IN VARCHAR2
,x_flxdu_column_xml_data IN VARCHAR2
,x_object_version_number IN NUMBER
,x_created_by IN NUMBER
,x_creation_date IN DATE
,x_last_update_date IN DATE
,x_last_updated_by IN NUMBER
,x_last_update_login IN NUMBER) IS
BEGIN
-- update table pqp_flxdu_columns
UPDATE pqp_flxdu_columns
SET flxdu_column_id = x_flxdu_column_id
,flxdu_column_name = x_flxdu_column_name
,flxdu_column_xml_tag = x_flxdu_column_xml_tag
,flxdu_column_data_type = x_flxdu_column_data_type
,flxdu_column_data_length = x_flxdu_column_data_length
,flxdu_seq_num = x_flxdu_seq_num
,flxdu_group_name = x_flxdu_group_name
,entity_type = x_entity_type
,required_flag = x_required_flag
,display_flag = x_display_flag
,description = x_description
,flxdu_column_xml_data = x_flxdu_column_xml_data
,object_version_number = x_object_version_number
,created_by = x_created_by
,creation_date = x_creation_date
,last_update_date = x_last_update_date
,last_updated_by = x_last_updated_by
,last_update_login = x_last_update_login
WHERE flxdu_column_id = x_flxdu_column_id;
END update_row;