DBA Data[Home] [Help]

APPS.PER_SEU_UPD dependencies on PER_SEU_SHD

Line 56: (p_rec in out nocopy per_seu_shd.g_rec_type

52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy per_seu_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: --

Line 88: per_seu_shd.constraint_error

84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: per_seu_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --

Line 93: per_seu_shd.constraint_error

89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: per_seu_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --

Line 98: per_seu_shd.constraint_error

94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: per_seu_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: --
102: Raise;

Line 138: (p_rec in per_seu_shd.g_rec_type

134: --
135: -- {End Of Comments}
136: -- ----------------------------------------------------------------------------
137: Procedure pre_update
138: (p_rec in per_seu_shd.g_rec_type
139: ) is
140: --
141: l_proc varchar2(72) := g_package||'pre_update';
142: --

Line 183: ,p_rec in per_seu_shd.g_rec_type

179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure post_update
182: (p_effective_date in date
183: ,p_rec in per_seu_shd.g_rec_type
184: ,p_del_static_lists_warning out nocopy boolean
185: ) is
186: --
187: l_proc varchar2(72) := g_package||'post_update';

Line 200: IF NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)

196: -- A change to the user or security profile means that
197: -- existing permissions stored in the static list are
198: -- incorrect and should be removed.
199: --
200: IF NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
201: <> NVL(p_rec.user_id, hr_api.g_number)
202: OR NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
203: <> NVL(p_rec.security_profile_id, hr_api.g_number)
204: THEN

Line 202: OR NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)

198: -- incorrect and should be removed.
199: --
200: IF NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
201: <> NVL(p_rec.user_id, hr_api.g_number)
202: OR NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
203: <> NVL(p_rec.security_profile_id, hr_api.g_number)
204: THEN
205: --
206: -- Set the warning flag to true if the user has static lists

Line 215: (p_user_id => per_seu_shd.g_old_rec.user_id

211: END IF;
212:
213: p_del_static_lists_warning :=
214: hr_security_internal.user_in_static_lists
215: (p_user_id => per_seu_shd.g_old_rec.user_id
216: ,p_security_profile_id => per_seu_shd.g_old_rec.security_profile_id);
217:
218: IF p_del_static_lists_warning THEN
219: --

Line 216: ,p_security_profile_id => per_seu_shd.g_old_rec.security_profile_id);

212:
213: p_del_static_lists_warning :=
214: hr_security_internal.user_in_static_lists
215: (p_user_id => per_seu_shd.g_old_rec.user_id
216: ,p_security_profile_id => per_seu_shd.g_old_rec.security_profile_id);
217:
218: IF p_del_static_lists_warning THEN
219: --
220: -- Delete the static lists for this user.

Line 227: (p_user_id => per_seu_shd.g_old_rec.user_id

223: hr_utility.set_location(l_proc, 15);
224: END IF;
225:
226: hr_security_internal.delete_static_lists_for_user
227: (p_user_id => per_seu_shd.g_old_rec.user_id
228: ,p_security_profile_id => per_seu_shd.g_old_rec.security_profile_id);
229:
230: END IF;
231:

Line 228: ,p_security_profile_id => per_seu_shd.g_old_rec.security_profile_id);

224: END IF;
225:
226: hr_security_internal.delete_static_lists_for_user
227: (p_user_id => per_seu_shd.g_old_rec.user_id
228: ,p_security_profile_id => per_seu_shd.g_old_rec.security_profile_id);
229:
230: END IF;
231:
232: END IF;

Line 246: ,p_user_id_o => per_seu_shd.g_old_rec.user_id

242: ,p_user_id => p_rec.user_id
243: ,p_security_profile_id => p_rec.security_profile_id
244: ,p_process_in_next_run_flag => p_rec.process_in_next_run_flag
245: ,p_object_version_number => p_rec.object_version_number
246: ,p_user_id_o => per_seu_shd.g_old_rec.user_id
247: ,p_security_profile_id_o => per_seu_shd.g_old_rec.security_profile_id
248: ,p_process_in_next_run_flag_o => per_seu_shd.g_old_rec.process_in_next_run_flag
249: ,p_object_version_number_o => per_seu_shd.g_old_rec.object_version_number
250: ,p_del_static_lists_warning => p_del_static_lists_warning

Line 247: ,p_security_profile_id_o => per_seu_shd.g_old_rec.security_profile_id

243: ,p_security_profile_id => p_rec.security_profile_id
244: ,p_process_in_next_run_flag => p_rec.process_in_next_run_flag
245: ,p_object_version_number => p_rec.object_version_number
246: ,p_user_id_o => per_seu_shd.g_old_rec.user_id
247: ,p_security_profile_id_o => per_seu_shd.g_old_rec.security_profile_id
248: ,p_process_in_next_run_flag_o => per_seu_shd.g_old_rec.process_in_next_run_flag
249: ,p_object_version_number_o => per_seu_shd.g_old_rec.object_version_number
250: ,p_del_static_lists_warning => p_del_static_lists_warning
251: );

Line 248: ,p_process_in_next_run_flag_o => per_seu_shd.g_old_rec.process_in_next_run_flag

244: ,p_process_in_next_run_flag => p_rec.process_in_next_run_flag
245: ,p_object_version_number => p_rec.object_version_number
246: ,p_user_id_o => per_seu_shd.g_old_rec.user_id
247: ,p_security_profile_id_o => per_seu_shd.g_old_rec.security_profile_id
248: ,p_process_in_next_run_flag_o => per_seu_shd.g_old_rec.process_in_next_run_flag
249: ,p_object_version_number_o => per_seu_shd.g_old_rec.object_version_number
250: ,p_del_static_lists_warning => p_del_static_lists_warning
251: );
252: --

Line 249: ,p_object_version_number_o => per_seu_shd.g_old_rec.object_version_number

245: ,p_object_version_number => p_rec.object_version_number
246: ,p_user_id_o => per_seu_shd.g_old_rec.user_id
247: ,p_security_profile_id_o => per_seu_shd.g_old_rec.security_profile_id
248: ,p_process_in_next_run_flag_o => per_seu_shd.g_old_rec.process_in_next_run_flag
249: ,p_object_version_number_o => per_seu_shd.g_old_rec.object_version_number
250: ,p_del_static_lists_warning => p_del_static_lists_warning
251: );
252: --
253: exception

Line 313: (p_rec in out nocopy per_seu_shd.g_rec_type

309: --
310: -- {End Of Comments}
311: -- ----------------------------------------------------------------------------
312: Procedure convert_defs
313: (p_rec in out nocopy per_seu_shd.g_rec_type
314: ) is
315: --
316: Begin
317: --

Line 325: per_seu_shd.g_old_rec.user_id;

321: -- is being used then we must set to the 'current' argument value.
322: --
323: If (p_rec.user_id = hr_api.g_number) then
324: p_rec.user_id :=
325: per_seu_shd.g_old_rec.user_id;
326: End If;
327: If (p_rec.security_profile_id = hr_api.g_number) then
328: p_rec.security_profile_id :=
329: per_seu_shd.g_old_rec.security_profile_id;

Line 329: per_seu_shd.g_old_rec.security_profile_id;

325: per_seu_shd.g_old_rec.user_id;
326: End If;
327: If (p_rec.security_profile_id = hr_api.g_number) then
328: p_rec.security_profile_id :=
329: per_seu_shd.g_old_rec.security_profile_id;
330: End If;
331: --
332: End convert_defs;
333: --

Line 339: ,p_rec in out nocopy per_seu_shd.g_rec_type

335: -- |---------------------------------< upd >----------------------------------|
336: -- ----------------------------------------------------------------------------
337: Procedure upd
338: (p_effective_date in date
339: ,p_rec in out nocopy per_seu_shd.g_rec_type
340: ,p_del_static_lists_warning out nocopy boolean
341: ) is
342: --
343: l_proc varchar2(72) := g_package||'upd';

Line 351: per_seu_shd.lck

347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: -- We must lock the row which we need to update.
350: --
351: per_seu_shd.lck
352: (p_rec.security_user_id
353: ,p_rec.object_version_number
354: );
355: --

Line 410: l_rec per_seu_shd.g_rec_type;

406: ,p_process_in_next_run_flag in varchar2 default hr_api.g_varchar2
407: ,p_del_static_lists_warning out nocopy boolean
408: ) is
409: --
410: l_rec per_seu_shd.g_rec_type;
411: l_proc varchar2(72) := g_package||'upd';
412: l_del_static_lists_warning boolean;
413: --
414: Begin

Line 421: per_seu_shd.convert_args

417: -- Call conversion function to turn arguments into the
418: -- l_rec structure.
419: --
420: l_rec :=
421: per_seu_shd.convert_args
422: (p_security_user_id
423: ,p_user_id
424: ,p_security_profile_id
425: ,p_process_in_next_run_flag