67: RETURN VARCHAR2
68: IS
69: CURSOR c_lock IS
70: SELECT *
71: FROM xla_appli_amb_contexts
72: WHERE application_id = p_application_id
73: AND amb_context_code = p_amb_context_code
74: FOR UPDATE OF application_id NOWAIT;
75:
380: p_module => l_log_module,
381: p_level => C_LEVEL_PROCEDURE);
382: END IF;
383:
384: UPDATE xla_appli_amb_contexts
385: SET updated_flag = 'Y'
386: ,creation_date = sysdate
387: ,created_by = xla_environment_pkg.g_usr_id
388: ,last_update_date = sysdate