DBA Data[Home] [Help]

APPS.PER_SEU_BUS dependencies on HR_API

Line 59: hr_api.mandatory_arg_error

55: hr_utility.set_location('Entering:'|| l_proc, 10);
56: --
57: -- Ensure that all the mandatory parameter are not null
58: --
59: hr_api.mandatory_arg_error
60: (p_api_name => l_proc
61: ,p_argument => 'security_user_id'
62: ,p_argument_value => p_security_user_id
63: );

Line 90: hr_api.set_security_group_id

86: close csr_sec_grp;
87: --
88: -- Set the security_group_id in CLIENT_INFO
89: --
90: hr_api.set_security_group_id
91: (p_security_group_id => l_security_group_id
92: );
93: --
94: -- Set the sessions legislation context in HR_SESSION_DATA

Line 96: hr_api.set_legislation_context(l_legislation_code);

92: );
93: --
94: -- Set the sessions legislation context in HR_SESSION_DATA
95: --
96: hr_api.set_legislation_context(l_legislation_code);
97: end if;
98: --
99: hr_utility.set_location(' Leaving:'|| l_proc, 20);
100: --

Line 142: hr_api.mandatory_arg_error

138: hr_utility.set_location('Entering:'|| l_proc, 10);
139: --
140: -- Ensure that all the mandatory parameter are not null
141: --
142: hr_api.mandatory_arg_error
143: (p_api_name => l_proc
144: ,p_argument => 'security_user_id'
145: ,p_argument_value => p_security_user_id
146: );

Line 148: if ( nvl(per_seu_bus.g_security_user_id, hr_api.g_number)

144: ,p_argument => 'security_user_id'
145: ,p_argument_value => p_security_user_id
146: );
147: --
148: if ( nvl(per_seu_bus.g_security_user_id, hr_api.g_number)
149: = p_security_user_id) then
150: --
151: -- The legislation code has already been found with a previous
152: -- call to this function. Just return the value in the global

Line 271: fndu.start_date and NVL(fndu.end_date, hr_api.g_eot);

267: SELECT fndu.user_id
268: FROM fnd_user_view fndu
269: WHERE fndu.user_id = p_user_id
270: AND p_effective_date BETWEEN
271: fndu.start_date and NVL(fndu.end_date, hr_api.g_eot);
272: --
273: Begin
274:
275: IF g_debug THEN

Line 290: AND NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)

286: (p_security_user_id => p_security_user_id
287: ,p_object_version_number => p_object_version_number);
288:
289: IF (l_api_updating
290: AND NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
291: = NVL(p_user_id, hr_api.g_number)) THEN
292: RETURN;
293: END IF;
294:

Line 291: = NVL(p_user_id, hr_api.g_number)) THEN

287: ,p_object_version_number => p_object_version_number);
288:
289: IF (l_api_updating
290: AND NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
291: = NVL(p_user_id, hr_api.g_number)) THEN
292: RETURN;
293: END IF;
294:
295: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 295: hr_api.mandatory_arg_error(p_api_name => l_proc,

291: = NVL(p_user_id, hr_api.g_number)) THEN
292: RETURN;
293: END IF;
294:
295: hr_api.mandatory_arg_error(p_api_name => l_proc,
296: p_argument => 'p_user_id',
297: p_argument_value => p_user_id);
298:
299:

Line 368: AND NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)

364: (p_security_user_id => p_security_user_id
365: ,p_object_version_number => p_object_version_number);
366:
367: IF (l_api_updating
368: AND NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
369: = NVL(p_security_profile_id, hr_api.g_number)) THEN
370: RETURN;
371: END IF;
372:

Line 369: = NVL(p_security_profile_id, hr_api.g_number)) THEN

365: ,p_object_version_number => p_object_version_number);
366:
367: IF (l_api_updating
368: AND NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
369: = NVL(p_security_profile_id, hr_api.g_number)) THEN
370: RETURN;
371: END IF;
372:
373: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 373: hr_api.mandatory_arg_error(p_api_name => l_proc,

369: = NVL(p_security_profile_id, hr_api.g_number)) THEN
370: RETURN;
371: END IF;
372:
373: hr_api.mandatory_arg_error(p_api_name => l_proc,
374: p_argument => 'p_security_profile_id',
375: p_argument_value => p_security_profile_id);
376:
377:

Line 430: AND seu.security_user_id <> NVL(p_security_profile_id, hr_api.g_number);

426: SELECT seu.user_id
427: FROM per_security_users seu
428: WHERE seu.user_id = p_user_id
429: AND seu.security_profile_id = p_security_profile_id
430: AND seu.security_user_id <> NVL(p_security_profile_id, hr_api.g_number);
431:
432: --
433: Begin
434:

Line 450: AND NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)

446: (p_security_user_id => p_security_user_id
447: ,p_object_version_number => p_object_version_number);
448:
449: IF (l_api_updating
450: AND NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
451: = NVL(p_user_id, hr_api.g_number)
452: AND NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
453: = NVL(p_security_profile_id, hr_api.g_number)) THEN
454: RETURN;

Line 451: = NVL(p_user_id, hr_api.g_number)

447: ,p_object_version_number => p_object_version_number);
448:
449: IF (l_api_updating
450: AND NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
451: = NVL(p_user_id, hr_api.g_number)
452: AND NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
453: = NVL(p_security_profile_id, hr_api.g_number)) THEN
454: RETURN;
455: END IF;

Line 452: AND NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)

448:
449: IF (l_api_updating
450: AND NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
451: = NVL(p_user_id, hr_api.g_number)
452: AND NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
453: = NVL(p_security_profile_id, hr_api.g_number)) THEN
454: RETURN;
455: END IF;
456:

Line 453: = NVL(p_security_profile_id, hr_api.g_number)) THEN

449: IF (l_api_updating
450: AND NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
451: = NVL(p_user_id, hr_api.g_number)
452: AND NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
453: = NVL(p_security_profile_id, hr_api.g_number)) THEN
454: RETURN;
455: END IF;
456:
457: IF hr_multi_message.no_exclusive_error

Line 530: AND NVL(per_seu_shd.g_old_rec.process_in_next_run_flag, hr_api.g_varchar2)

526: (p_security_user_id => p_security_user_id
527: ,p_object_version_number => p_object_version_number);
528:
529: IF (l_api_updating
530: AND NVL(per_seu_shd.g_old_rec.process_in_next_run_flag, hr_api.g_varchar2)
531: = NVL(p_process_in_next_run_flag, hr_api.g_varchar2)) THEN
532: RETURN;
533: END IF;
534:

Line 531: = NVL(p_process_in_next_run_flag, hr_api.g_varchar2)) THEN

527: ,p_object_version_number => p_object_version_number);
528:
529: IF (l_api_updating
530: AND NVL(per_seu_shd.g_old_rec.process_in_next_run_flag, hr_api.g_varchar2)
531: = NVL(p_process_in_next_run_flag, hr_api.g_varchar2)) THEN
532: RETURN;
533: END IF;
534:
535: IF p_process_in_next_run_flag NOT IN (NULL,'Y','N')