adm_cache_api

This document contains the API documentation for the adm_cache_api package.

Functions and Procedures

update_subshared_files_cache

Updates the subshared files cache for a specific user by running the user accessible documents query and storing the results in adm_subshared_files_cache table

Signature:

procedure update_subshared_files_cache (
  p_username in varchar2 default sys_context(adm_context_api.c_ctx_namespace,
  adm_context_api.c_ctx_username
);

Parameters:

Name	Direction	Type	Description
p_username	in	varchar2 default sys_context(adm_context_api.c_ctx_namespace	The username to update the cache for

---

update_subshared_files_cache_by_id

Updates the subshared files cache for a specific user by user_id

Signature:

procedure update_subshared_files_cache_by_id (
  p_user_id in adm_users.user_id%type
);

Parameters:

Name	Direction	Type	Description
p_user_id	in	adm_users.user_id%type	The user_id to update the cache for

---

mark_subshared_files_cache_outdated

Marks the subshared files cache as outdated for a specific user

Signature:

procedure mark_subshared_files_cache_outdated (
  p_username in varchar2 default sys_context(adm_context_api.c_ctx_namespace,
  adm_context_api.c_ctx_username
);

Parameters:

Name	Direction	Type	Description
p_username	in	varchar2 default sys_context(adm_context_api.c_ctx_namespace	The username to mark cache as outdated

---

mark_subshared_files_cache_outdated_by_id

Marks the subshared files cache as outdated for a specific user by user_id

Signature:

procedure mark_subshared_files_cache_outdated_by_id (
  p_user_id in adm_users.user_id%type
);

Parameters:

Name	Direction	Type	Description
p_user_id	in	adm_users.user_id%type	The user_id to mark cache as outdated

---

trigger_background_cache_update

Triggers a background cache update for a specific user using dbms_scheduler This will mark the cache as outdated and schedule a job to update it

Signature:

procedure trigger_background_cache_update (
  p_username in adm_users.username%type
);

Parameters:

Name	Direction	Type	Description
p_username	in	adm_users.username%type	-

---