eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_NMF_BUS dependencies on HR_NAME_FORMATS

Line 31: from hr_name_formats nmf

27: -- Declare cursor
28: --
29: cursor csr_leg_code is
30: select nmf.legislation_code
31: from hr_name_formats nmf
32: where nmf.name_format_id = p_name_format_id;
33: --
34: -- Declare local variables
35: --

Line 121: Procedure chk_delete(p_name_format_id in hr_name_formats.name_format_id%TYPE

117: --
118: -- Access Status:
119: -- Internal Table Handler Use Only.
120: --
121: Procedure chk_delete(p_name_format_id in hr_name_formats.name_format_id%TYPE
122: ) IS
123: --
124: l_proc varchar2(72) := g_package || 'chk_delete';
125: l_created_by hr_name_formats.created_by%TYPE;

Line 125: l_created_by hr_name_formats.created_by%TYPE;

121: Procedure chk_delete(p_name_format_id in hr_name_formats.name_format_id%TYPE
122: ) IS
123: --
124: l_proc varchar2(72) := g_package || 'chk_delete';
125: l_created_by hr_name_formats.created_by%TYPE;
126: --
127: cursor csr_get_created_by(p_id hr_name_formats.name_format_id%TYPE) is
128: select created_by
129: from hr_name_formats

Line 127: cursor csr_get_created_by(p_id hr_name_formats.name_format_id%TYPE) is

123: --
124: l_proc varchar2(72) := g_package || 'chk_delete';
125: l_created_by hr_name_formats.created_by%TYPE;
126: --
127: cursor csr_get_created_by(p_id hr_name_formats.name_format_id%TYPE) is
128: select created_by
129: from hr_name_formats
130: where name_format_id = p_id;
131: --

Line 129: from hr_name_formats

125: l_created_by hr_name_formats.created_by%TYPE;
126: --
127: cursor csr_get_created_by(p_id hr_name_formats.name_format_id%TYPE) is
128: select created_by
129: from hr_name_formats
130: where name_format_id = p_id;
131: --
132: Begin
133: --

Line 273: (p_name_format_id in hr_name_formats.name_format_id%TYPE

269: -- Access Status:
270: -- Internal Row Handler Use Only.
271: --
272: Procedure chk_name_format_id
273: (p_name_format_id in hr_name_formats.name_format_id%TYPE
274: ) is
275: --
276: -- Local declarations
277: l_proc varchar2(72) := g_package||' chk_name_format_id';

Line 322: (p_name_format_id in hr_name_formats.name_format_id%TYPE

318: -- Access Status:
319: -- Internal Row Handler Use Only.
320: --
321: Procedure chk_format_name
322: (p_name_format_id in hr_name_formats.name_format_id%TYPE
323: ,p_format_name in hr_name_formats.format_name%TYPE
324: ,p_object_version_number in hr_name_formats.object_version_number%TYPE
325: ,p_effective_date in date
326: ) is

Line 323: ,p_format_name in hr_name_formats.format_name%TYPE

319: -- Internal Row Handler Use Only.
320: --
321: Procedure chk_format_name
322: (p_name_format_id in hr_name_formats.name_format_id%TYPE
323: ,p_format_name in hr_name_formats.format_name%TYPE
324: ,p_object_version_number in hr_name_formats.object_version_number%TYPE
325: ,p_effective_date in date
326: ) is
327: --

Line 324: ,p_object_version_number in hr_name_formats.object_version_number%TYPE

320: --
321: Procedure chk_format_name
322: (p_name_format_id in hr_name_formats.name_format_id%TYPE
323: ,p_format_name in hr_name_formats.format_name%TYPE
324: ,p_object_version_number in hr_name_formats.object_version_number%TYPE
325: ,p_effective_date in date
326: ) is
327: --
328: -- Local declarations

Line 376: (p_associated_column1 => 'HR_NAME_FORMATS.FORMAT_NAME') then

372: --
373: Exception
374: when app_exception.application_exception then
375: if hr_multi_message.exception_add
376: (p_associated_column1 => 'HR_NAME_FORMATS.FORMAT_NAME') then
377: if g_debug then
378: hr_utility.set_location(' Leaving:'||l_proc, 80);
379: end if;
380: raise;

Line 412: Procedure chk_legislation_code(p_legislation_code in hr_name_formats.legislation_code%TYPE) is

408: --
409: -- Access Status:
410: -- Internal Row Handler Use Only.
411: --
412: Procedure chk_legislation_code(p_legislation_code in hr_name_formats.legislation_code%TYPE) is
413: --
414: -- Local declarations
415: l_proc varchar2(72) := g_package||' chk_legislation_code';
416: l_value varchar2(240) := 'DUMMY';

Line 440: (p_associated_column1 => 'HR_NAME_FORMATS.LEGISLATION_CODE') then

436: --
437: Exception
438: when app_exception.application_exception then
439: if hr_multi_message.exception_add
440: (p_associated_column1 => 'HR_NAME_FORMATS.LEGISLATION_CODE') then
441: if g_debug then
442: hr_utility.set_location(' Leaving:'||l_proc, 80);
443: end if;
444: raise;

Line 481: (p_user_format_choice in hr_name_formats.user_format_choice%TYPE

477: -- Access Status:
478: -- Internal Row Handler Use Only.
479: --
480: Procedure chk_user_format_choice
481: (p_user_format_choice in hr_name_formats.user_format_choice%TYPE
482: ,p_format_name in hr_name_formats.format_name%TYPE
483: ,p_effective_date in date) is
484:
485: --

Line 482: ,p_format_name in hr_name_formats.format_name%TYPE

478: -- Internal Row Handler Use Only.
479: --
480: Procedure chk_user_format_choice
481: (p_user_format_choice in hr_name_formats.user_format_choice%TYPE
482: ,p_format_name in hr_name_formats.format_name%TYPE
483: ,p_effective_date in date) is
484:
485: --
486: -- Local declarations

Line 561: (p_associated_column1 => 'HR_NAME_FORMATS.USER_FORMAT_CHOICE') then

557: end if;
558: Exception
559: when app_exception.application_exception then
560: if hr_multi_message.exception_add
561: (p_associated_column1 => 'HR_NAME_FORMATS.USER_FORMAT_CHOICE') then
562: if g_debug then
563: hr_utility.set_location(' Leaving:'||l_proc, 80);
564: end if;
565: raise;

Line 606: (p_format_mask in hr_name_formats.format_mask%TYPE

602: -- Access Status:
603: -- Internal Row Handler Use Only.
604: --
605: Procedure chk_format_mask
606: (p_format_mask in hr_name_formats.format_mask%TYPE
607: ,p_effective_date in date) is
608: --
609: -- Local declarations
610: l_proc varchar2(72) := g_package||' chk_format_mask';

Line 611: l_format hr_name_formats.format_mask%TYPE;

607: ,p_effective_date in date) is
608: --
609: -- Local declarations
610: l_proc varchar2(72) := g_package||' chk_format_mask';
611: l_format hr_name_formats.format_mask%TYPE;
612: l_token_start_pos number;
613: l_token_end_pos number;
614: l_token fnd_lookup_values.lookup_code%TYPE;
615: --

Line 679: (p_associated_column1 => 'HR_NAME_FORMATS.FORMAT_MASK') then

675: end if;
676: Exception
677: when app_exception.application_exception then
678: if hr_multi_message.exception_add
679: (p_associated_column1 => 'HR_NAME_FORMATS.FORMAT_MASK') then
680: if g_debug then
681: hr_utility.set_location(' Leaving:'||l_proc, 80);
682: end if;
683: raise;

Line 718: (p_format_name in hr_name_formats.format_name%TYPE

714: -- Access Status:
715: -- Internal Row Handler Use Only.
716: --
717: Procedure chk_format_and_legislation
718: (p_format_name in hr_name_formats.format_name%TYPE
719: ,p_legislation_code in hr_name_formats.legislation_code%TYPE
720: ,p_user_format_choice in hr_name_formats.user_format_choice%TYPE
721: ) is
722: --

Line 719: ,p_legislation_code in hr_name_formats.legislation_code%TYPE

715: -- Internal Row Handler Use Only.
716: --
717: Procedure chk_format_and_legislation
718: (p_format_name in hr_name_formats.format_name%TYPE
719: ,p_legislation_code in hr_name_formats.legislation_code%TYPE
720: ,p_user_format_choice in hr_name_formats.user_format_choice%TYPE
721: ) is
722: --
723: -- Local declarations

Line 720: ,p_user_format_choice in hr_name_formats.user_format_choice%TYPE

716: --
717: Procedure chk_format_and_legislation
718: (p_format_name in hr_name_formats.format_name%TYPE
719: ,p_legislation_code in hr_name_formats.legislation_code%TYPE
720: ,p_user_format_choice in hr_name_formats.user_format_choice%TYPE
721: ) is
722: --
723: -- Local declarations
724: l_proc varchar2(72) := g_package||' chk_format_and_legislation';

Line 731: from HR_NAME_FORMATS

727: cursor csr_validate_combination(p_format_name varchar2
728: ,p_leg_code varchar2
729: ,p_user_choice varchar2) is
730: select 'Y'
731: from HR_NAME_FORMATS
732: where format_name = p_format_name
733: and (p_leg_code is null and legislation_code is null
734: or p_leg_code is not null and legislation_code = p_leg_code)
735: and user_format_choice = p_user_choice;

Line 769: (p_associated_column1 => 'HR_NAME_FORMATS.FORMAT_NAME'

765: end if;
766: Exception
767: when app_exception.application_exception then
768: if hr_multi_message.exception_add
769: (p_associated_column1 => 'HR_NAME_FORMATS.FORMAT_NAME'
770: ,p_associated_column2 => 'HR_NAME_FORMATS.LEGISLATION_CODE'
771: ,p_associated_column3 => 'HR_NAME_FORMATS.USER_FORMAT_CHOICE') then
772: if g_debug then
773: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 770: ,p_associated_column2 => 'HR_NAME_FORMATS.LEGISLATION_CODE'

766: Exception
767: when app_exception.application_exception then
768: if hr_multi_message.exception_add
769: (p_associated_column1 => 'HR_NAME_FORMATS.FORMAT_NAME'
770: ,p_associated_column2 => 'HR_NAME_FORMATS.LEGISLATION_CODE'
771: ,p_associated_column3 => 'HR_NAME_FORMATS.USER_FORMAT_CHOICE') then
772: if g_debug then
773: hr_utility.set_location(' Leaving:'||l_proc, 80);
774: end if;

Line 771: ,p_associated_column3 => 'HR_NAME_FORMATS.USER_FORMAT_CHOICE') then

767: when app_exception.application_exception then
768: if hr_multi_message.exception_add
769: (p_associated_column1 => 'HR_NAME_FORMATS.FORMAT_NAME'
770: ,p_associated_column2 => 'HR_NAME_FORMATS.LEGISLATION_CODE'
771: ,p_associated_column3 => 'HR_NAME_FORMATS.USER_FORMAT_CHOICE') then
772: if g_debug then
773: hr_utility.set_location(' Leaving:'||l_proc, 80);
774: end if;
775: raise;