86: RETURN VARCHAR2
87: IS
88: CURSOR c IS
89: SELECT *
90: FROM xla_appli_amb_contexts
91: WHERE application_id = g_application_id
92: AND amb_context_code = g_amb_context_code
93: FOR UPDATE OF application_id NOWAIT;
94:
92: AND amb_context_code = g_amb_context_code
93: FOR UPDATE OF application_id NOWAIT;
94:
95: l_lock_error BOOLEAN;
96: l_recinfo xla_appli_amb_contexts%ROWTYPE;
97: l_retcode VARCHAR2(30);
98: l_log_module VARCHAR2(240);
99: BEGIN
100: IF g_log_enabled THEN
185: IS
186:
187: CURSOR c_updated IS
188: SELECT 1
189: FROM xla_appli_amb_contexts
190: WHERE amb_context_code = g_amb_context_code
191: AND application_id = g_application_id
192: AND updated_flag = 'N';
193: