DBA Data[Home] [Help]

APPS.HR_NMF_BUS dependencies on FND_LOOKUP_VALUES

Line 303: -- Check that the format_name exists in FND_LOOKUP_VALUES.

299: -- |--------------------< chk_format_name >------------------------|
300: -- -----------------------------------------------------------------
301: --
302: -- Description:
303: -- Check that the format_name exists in FND_LOOKUP_VALUES.
304: --
305: -- Pre-Requisites:
306: -- None
307: --

Line 456: -- Check that the user_format_choice exists in fnd_lookup_values.

452: -- |-----------------< chk_user_format_choice >----------------------|
453: -- -----------------------------------------------------------------
454: --
455: -- Description:
456: -- Check that the user_format_choice exists in fnd_lookup_values.
457: -- The only acceptable values are 'G' and 'L'.
458: -- If format_name is DISPLAY_NAME or LIST_NAME then this is mandatory.
459: -- If format_name is FULL_NAME or ORDER_NAME then user_format_choice
460: -- must be 'L'.

Line 578: -- Valid tokens are stored in FND_LOOKUP_VALUES table

574: -- -----------------------------------------------------------------
575: --
576: -- Description:
577: -- Check that the format_mask does not contain invalid tokens.
578: -- Valid tokens are stored in FND_LOOKUP_VALUES table
579: -- where LOOKUP TYPE = 'PER_FORMAT_MASK_TOKENS'
580: --
581: -- The format mask has been stored as follows:
582: -- [prefix] space $TOKEN space [suffix]

Line 614: l_token fnd_lookup_values.lookup_code%TYPE;

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: --
616: begin
617: if g_debug then
618: hr_utility.set_location('Entering:'||l_proc, 5);