APPS.HR_DTY_BUS dependencies on HR_STANDARD_LOOKUPS

Line 326: from hr_standard_lookups

322:
323: cursor csr_valid_active_flag(p_active_flg varchar2)
324: is
325: select 'X'
326: from hr_standard_lookups
327: where lookup_type = 'YES_NO'
328: and lookup_code = p_active_flg;
329:
330:

Line 349: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');

345: if csr_valid_active_flag%notfound then
346: close csr_valid_active_flag;
347: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
348: hr_utility.set_message_token('OBJECT', 'ACTIVE_FLAG');
349: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
350: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
351: hr_utility.raise_error;
352: hr_utility.set_location(l_proc, 10);
353: --

Line 415: from hr_standard_lookups

411:
412: cursor csr_valid_mul_occurence_flag(p_mul_occ_flag varchar2)
413: is
414: select 'X'
415: from hr_standard_lookups
416: where lookup_type = 'YES_NO'
417: and lookup_code = p_mul_occ_flag;
418:
419: --

Line 439: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');

435: close csr_valid_mul_occurence_flag;
436:
437: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
438: hr_utility.set_message_token('OBJECT', 'MULTIPLE_OCCURENCES_FLAG');
439: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
440: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
441: hr_utility.raise_error;
442: hr_utility.set_location(l_proc, 10);
443: --

Line 587: from hr_standard_lookups

583:
584: cursor csr_valid_auth_code(p_auth_code varchar2)
585: is
586: select 'X'
587: from hr_standard_lookups
588: where lookup_type = 'YES_NO'
589: and lookup_code = p_auth_code;
590:
591: --

Line 610: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');

606: if csr_valid_auth_code%notfound then
607: close csr_valid_auth_code;
608: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
609: hr_utility.set_message_token('OBJECT', 'AUTHORIZATION_REQUIRED');
610: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
611: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
612: hr_utility.raise_error;
613: hr_utility.set_location(l_proc, 10);
614: --

Line 741: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."

737: --
738: -- Call all supporting business operations
739: --
740: --
741: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."
742: --
743: -- Validate Dependent Attributes
744: --
745: --

Line 799: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."

795: hr_utility.set_location('Entering:'||l_proc, 5);
796: --
797: -- Call all supporting business operations
798: --
799: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."
800: --
801: -- Validate Dependent Attributes
802: --
803: chk_non_updateable_args