45: l_proc varchar2(72) := g_package || 'update_sso_details';
46:
47: CURSOR csr_app_id IS
48: select external_application_id
49: from hr_ki_ext_applications
50: where ext_application_id=p_ext_application_id;
51:
52:
53: BEGIN
110: p_fname9 => p_fname9,
111: p_fval9 => p_fval9);
112:
113:
114: -- update record into hr_ki_ext_applications
115:
116: hr_eap_upd.upd
117: (
118: p_ext_application_id => p_ext_application_id
180: --
181: --
182: --
183: --
184: -- Update the hr_ki_ext_applications Row
185: --
186: update hr_ki_ext_applications
187: set
188: ext_application_id = p_rec.ext_application_id
182: --
183: --
184: -- Update the hr_ki_ext_applications Row
185: --
186: update hr_ki_ext_applications
187: set
188: ext_application_id = p_rec.ext_application_id
189: ,external_application_name = p_rec.external_application_name
190:
316: --
317: when hr_api.cannot_find_prog_unit then
318: --
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'HR_KI_EXT_APPLICATIONS'
321: ,p_hook_type => 'AU');
322: --
323: end;
324: --