APPS.PER_SEU_BUS dependencies on PER_SECURITY_USERS

Line 40: , per_security_users seu

36: cursor csr_sec_grp is
37: select pbg.security_group_id,
38: pbg.legislation_code
39: from per_business_groups_perf pbg
40: , per_security_users seu
41: , per_security_profiles psp
42: where seu.security_user_id = p_security_user_id
43: and seu.security_profile_id = psp.security_profile_id
44: and psp.business_group_id is not null

Line 124: , per_security_users seu

120:
121: cursor csr_leg_code is
122: select pbg.legislation_code
123: from per_business_groups_perf pbg
124: , per_security_users seu
125: , per_security_profiles psp
126: where seu.security_user_id = p_security_user_id
127: and seu.security_profile_id = psp.security_profile_id
128: and psp.business_group_id is not null

Line 315: (p_associated_column1 => 'PER_SECURITY_USERS.USER_ID');

311: END IF;
312:
313: hr_utility.set_message(800, 'HR_50128_INVALID_USER');
314: hr_multi_message.add
315: (p_associated_column1 => 'PER_SECURITY_USERS.USER_ID');
316:
317: END IF;
318:
319: IF g_debug THEN

Line 393: (p_associated_column1 => 'PER_SECURITY_USERS.SECURITY_PROFILE_ID');

389: END IF;
390:
391: hr_utility.set_message(800, 'HR_50143_INVALID_SEC_PROF');
392: hr_multi_message.add
393: (p_associated_column1 => 'PER_SECURITY_USERS.SECURITY_PROFILE_ID');
394:
395: END IF;
396:
397: IF g_debug THEN

Line 427: FROM per_security_users seu

423: -- security profile.
424: --
425: CURSOR csr_chk_unique IS
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:

Line 458: (p_check_column1 => 'PER_SECURITY_USERS.USER_ID'

454: RETURN;
455: END IF;
456:
457: IF hr_multi_message.no_exclusive_error
458: (p_check_column1 => 'PER_SECURITY_USERS.USER_ID'
459: ,p_check_column2 => 'PER_SECURITY_USERS.SECURITY_PROFILE_ID')
460: THEN
461: --
462: -- Only proceed if the dependent validation has not errored.

Line 459: ,p_check_column2 => 'PER_SECURITY_USERS.SECURITY_PROFILE_ID')

455: END IF;
456:
457: IF hr_multi_message.no_exclusive_error
458: (p_check_column1 => 'PER_SECURITY_USERS.USER_ID'
459: ,p_check_column2 => 'PER_SECURITY_USERS.SECURITY_PROFILE_ID')
460: THEN
461: --
462: -- Only proceed if the dependent validation has not errored.
463: --

Line 483: (p_associated_column1 => 'PER_SECURITY_USERS.USER_ID'

479: END IF;
480:
481: hr_utility.set_message(800, 'HR_50145_SEU_NOT_UNIQUE');
482: hr_multi_message.add
483: (p_associated_column1 => 'PER_SECURITY_USERS.USER_ID'
484: ,p_associated_column2 => 'PER_SECURITY_USERS.SECURITY_PROFILE_ID');
485:
486: END IF;
487:

Line 484: ,p_associated_column2 => 'PER_SECURITY_USERS.SECURITY_PROFILE_ID');

480:
481: hr_utility.set_message(800, 'HR_50145_SEU_NOT_UNIQUE');
482: hr_multi_message.add
483: (p_associated_column1 => 'PER_SECURITY_USERS.USER_ID'
484: ,p_associated_column2 => 'PER_SECURITY_USERS.SECURITY_PROFILE_ID');
485:
486: END IF;
487:
488: END IF;

Line 543: (p_associated_column1 => 'PER_SECURITY_USERS.PROCESS_IN_NEXT_RUN_FLAG');

539: -- raise an error message informing the user of this fact.
540: --
541: hr_utility.set_message(800, 'HR_50292_INVALID_PINR_FLAG');
542: hr_multi_message.add
543: (p_associated_column1 => 'PER_SECURITY_USERS.PROCESS_IN_NEXT_RUN_FLAG');
544:
545: IF g_debug THEN
546: hr_utility.set_location(l_proc, 69);
547: hr_utility.set_location('process_in_next_run_flag is not null Y or N',69);