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_FLEX_VALUE_SET_INFO dependencies on FND_FLEX_VALUE_SETS

Line 32: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

28: --
29: -- {End of Comments}
30: -- -----------------------------------------------------------------------------
31: FUNCTION parent_value_set_name
32: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
33: )
34: RETURN fnd_flex_value_sets.flex_value_set_name%TYPE
35: IS
36: --

Line 34: RETURN fnd_flex_value_sets.flex_value_set_name%TYPE

30: -- -----------------------------------------------------------------------------
31: FUNCTION parent_value_set_name
32: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
33: )
34: RETURN fnd_flex_value_sets.flex_value_set_name%TYPE
35: IS
36: --
37: -- Local cursors
38: --

Line 40: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

36: --
37: -- Local cursors
38: --
39: CURSOR csr_value_sets
40: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
41: )
42: IS
43: SELECT ind.flex_value_set_name parent_value_set_name
44: FROM fnd_flex_value_sets ind

Line 44: FROM fnd_flex_value_sets ind

40: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
41: )
42: IS
43: SELECT ind.flex_value_set_name parent_value_set_name
44: FROM fnd_flex_value_sets ind
45: ,fnd_flex_value_sets dep
46: WHERE ind.flex_value_set_id = dep.parent_flex_value_set_id
47: AND dep.flex_value_set_id = p_flex_value_set_id;
48: --

Line 45: ,fnd_flex_value_sets dep

41: )
42: IS
43: SELECT ind.flex_value_set_name parent_value_set_name
44: FROM fnd_flex_value_sets ind
45: ,fnd_flex_value_sets dep
46: WHERE ind.flex_value_set_id = dep.parent_flex_value_set_id
47: AND dep.flex_value_set_id = p_flex_value_set_id;
48: --
49: -- Local variables

Line 317: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

313: --
314: -- {End of Comments}
315: -- -----------------------------------------------------------------------------
316: PROCEDURE get_table_sql
317: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
318: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
319: ,p_effective_date IN DATE
320: ,p_validation_sql OUT NOCOPY VARCHAR2
321: ,p_identification_sql OUT NOCOPY VARCHAR2

Line 318: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

314: -- {End of Comments}
315: -- -----------------------------------------------------------------------------
316: PROCEDURE get_table_sql
317: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
318: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
319: ,p_effective_date IN DATE
320: ,p_validation_sql OUT NOCOPY VARCHAR2
321: ,p_identification_sql OUT NOCOPY VARCHAR2
322: ,p_id_column_type OUT NOCOPY VARCHAR2

Line 339: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

335: --
336: -- Local cursors
337: --
338: CURSOR csr_validation_tables
339: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
340: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
341: )
342: IS
343: SELECT DECODE(fvt.value_column_type

Line 340: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

336: -- Local cursors
337: --
338: CURSOR csr_validation_tables
339: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
340: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
341: )
342: IS
343: SELECT DECODE(fvt.value_column_type
344: ,'D','fnd_date.date_to_displaydate('||fvt.value_column_name||')'

Line 504: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

500: --
501: -- {End of Comments}
502: -- -----------------------------------------------------------------------------
503: PROCEDURE get_independent_sql
504: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
505: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
506: ,p_effective_date IN DATE
507: ,p_validation_sql OUT NOCOPY VARCHAR2
508: ,p_identification_sql OUT NOCOPY VARCHAR2

Line 505: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

501: -- {End of Comments}
502: -- -----------------------------------------------------------------------------
503: PROCEDURE get_independent_sql
504: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
505: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
506: ,p_effective_date IN DATE
507: ,p_validation_sql OUT NOCOPY VARCHAR2
508: ,p_identification_sql OUT NOCOPY VARCHAR2
509: ,p_has_meaning OUT NOCOPY BOOLEAN

Line 602: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

598: --
599: -- {End of Comments}
600: -- -----------------------------------------------------------------------------
601: PROCEDURE get_dependent_sql
602: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
603: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
604: ,p_effective_date IN DATE
605: ,p_validation_sql OUT NOCOPY VARCHAR2
606: ,p_identification_sql OUT NOCOPY VARCHAR2

Line 603: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

599: -- {End of Comments}
600: -- -----------------------------------------------------------------------------
601: PROCEDURE get_dependent_sql
602: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
603: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
604: ,p_effective_date IN DATE
605: ,p_validation_sql OUT NOCOPY VARCHAR2
606: ,p_identification_sql OUT NOCOPY VARCHAR2
607: ,p_has_meaning OUT NOCOPY BOOLEAN

Line 710: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

706: --
707: -- {End of Comments}
708: -- -----------------------------------------------------------------------------
709: PROCEDURE get_sql
710: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
711: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
712: ,p_validation_type IN fnd_flex_value_sets.validation_type%TYPE
713: ,p_effective_date IN DATE
714: ,p_validation_sql OUT NOCOPY VARCHAR2

Line 711: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

707: -- {End of Comments}
708: -- -----------------------------------------------------------------------------
709: PROCEDURE get_sql
710: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
711: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
712: ,p_validation_type IN fnd_flex_value_sets.validation_type%TYPE
713: ,p_effective_date IN DATE
714: ,p_validation_sql OUT NOCOPY VARCHAR2
715: ,p_identification_sql OUT NOCOPY VARCHAR2

Line 712: ,p_validation_type IN fnd_flex_value_sets.validation_type%TYPE

708: -- -----------------------------------------------------------------------------
709: PROCEDURE get_sql
710: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
711: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
712: ,p_validation_type IN fnd_flex_value_sets.validation_type%TYPE
713: ,p_effective_date IN DATE
714: ,p_validation_sql OUT NOCOPY VARCHAR2
715: ,p_identification_sql OUT NOCOPY VARCHAR2
716: ,p_id_column_type OUT NOCOPY VARCHAR2

Line 729: l_table CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'F';

725: IS
726: --
727: -- Local variables
728: --
729: l_table CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'F';
730: l_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'D';
731: l_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'I';
732: l_translatable_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'X';
733: l_translatable_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'Y';

Line 730: l_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'D';

726: --
727: -- Local variables
728: --
729: l_table CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'F';
730: l_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'D';
731: l_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'I';
732: l_translatable_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'X';
733: l_translatable_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'Y';
734: --

Line 731: l_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'I';

727: -- Local variables
728: --
729: l_table CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'F';
730: l_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'D';
731: l_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'I';
732: l_translatable_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'X';
733: l_translatable_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'Y';
734: --
735: BEGIN

Line 732: l_translatable_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'X';

728: --
729: l_table CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'F';
730: l_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'D';
731: l_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'I';
732: l_translatable_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'X';
733: l_translatable_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'Y';
734: --
735: BEGIN
736: --

Line 733: l_translatable_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'Y';

729: l_table CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'F';
730: l_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'D';
731: l_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'I';
732: l_translatable_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'X';
733: l_translatable_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'Y';
734: --
735: BEGIN
736: --
737: -- Get details based on validation type

Line 788: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

784: -- -----------------------------------------------------------------------------
785: -- |-------------------------------< value_set >-------------------------------|
786: -- -----------------------------------------------------------------------------
787: FUNCTION value_set
788: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
789: ,p_effective_date IN DATE
790: )
791: RETURN t_value_set
792: IS

Line 797: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

793: --
794: -- Local cursors
795: --
796: CURSOR csr_value_sets
797: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
798: )
799: IS
800: SELECT fvs.flex_value_set_id
801: ,fvs.alphanumeric_allowed_flag

Line 812: FROM fnd_flex_value_sets fvs

808: ,fvs.number_precision
809: ,fvs.numeric_mode_enabled_flag
810: ,fvs.uppercase_only_flag
811: ,fvs.validation_type
812: FROM fnd_flex_value_sets fvs
813: WHERE fvs.flex_value_set_id = p_flex_value_set_id;
814: --
815: -- Local variables
816: --