The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE delete_user_preferences(x_application_id NUMBER, x_organization_id NUMBER,
x_user_id NUMBER) IS
PRAGMA AUTONOMOUS_TRANSACTION;
delete from wip_preferences
where application_id = x_application_id
and user_id = x_user_id
and organization_id = x_organization_id;
END delete_user_preferences;
PROCEDURE delete_user_preferences(x_application_id NUMBER, x_organization_id NUMBER,
x_user_id NUMBER,
x_module_id NUMBER) IS
PRAGMA AUTONOMOUS_TRANSACTION;
delete from wip_preferences
where application_id = x_application_id
and user_id = x_user_id
and organization_id = x_organization_id
and module_id = x_module_id;
END delete_user_preferences;
PROCEDURE delete_user_preferences(x_application_id NUMBER, x_organization_id NUMBER,
x_user_id NUMBER,
x_module_id NUMBER,
x_preference_type NUMBER) IS
PRAGMA AUTONOMOUS_TRANSACTION;
delete from wip_preferences
where application_id = x_application_id
and user_id = x_user_id
and organization_id = x_organization_id
and module_id = x_module_id
and preference_type = x_preference_type;
END delete_user_preferences;
* This will insert a record into the preference table.
*/
PROCEDURE insert_preference(x_application_id NUMBER,
x_organization_id NUMBER,
x_user_id NUMBER,
x_preference_type NUMBER,
x_value VARCHAR2,
x_value_index NUMBER) IS
PRAGMA AUTONOMOUS_TRANSACTION;
insert into wip_preferences (preference_id,
application_id,
organization_id,
user_id,
preference_type,
value,
value_index,
last_update_date,
last_updated_by,
creation_date,
created_by)
values (wip_preferences_seq.nextval,
x_application_id,
x_organization_id,
x_user_id,
x_preference_type,
x_value,
x_value_index,
sysdate,
x_user_id,
sysdate,
x_user_id);
END insert_preference;
PROCEDURE insert_preference(x_application_id NUMBER,
x_organization_id NUMBER,
x_user_id NUMBER,
x_preference_type NUMBER,
x_value VARCHAR2,
x_value_index NUMBER,
x_module_id NUMBER) IS
PRAGMA AUTONOMOUS_TRANSACTION;
insert into wip_preferences (preference_id,
application_id,
organization_id,
user_id,
preference_type,
value,
value_index,
last_update_date,
last_updated_by,
creation_date,
created_by,
module_id)
values (wip_preferences_seq.nextval,
x_application_id,
x_organization_id,
x_user_id,
x_preference_type,
x_value,
x_value_index,
sysdate,
x_user_id,
sysdate,
x_user_id,
x_module_id);
END insert_preference;