APPS.WIP_WPS_PREFERENCES_PKG SQL Statements

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

Line: 7

  PROCEDURE delete_user_preferences(x_application_id NUMBER, x_organization_id NUMBER,
				    x_user_id NUMBER) IS

     PRAGMA AUTONOMOUS_TRANSACTION;

Line: 12

     delete from wip_preferences
     where application_id = x_application_id
       and user_id = x_user_id
       and organization_id = x_organization_id;

Line: 19

  END delete_user_preferences;

Line: 22

  PROCEDURE delete_user_preferences(x_application_id NUMBER, x_organization_id NUMBER,
				    x_user_id NUMBER,
				    x_module_id NUMBER) IS

     PRAGMA AUTONOMOUS_TRANSACTION;

Line: 29

     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;

Line: 37

  END delete_user_preferences;

Line: 39

  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;

Line: 47

     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;

Line: 56

  END delete_user_preferences;

Line: 59

   * 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;

Line: 70

      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);

Line: 96

   END insert_preference;

Line: 99

   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;

Line: 109

      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);

Line: 137

   END insert_preference;