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 513: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

509: --
510: -- {End of Comments}
511: -- -----------------------------------------------------------------------------
512: PROCEDURE get_independent_sql
513: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
514: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
515: ,p_effective_date IN DATE
516: ,p_validation_sql OUT NOCOPY VARCHAR2
517: ,p_identification_sql OUT NOCOPY VARCHAR2

Line 514: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

510: -- {End of Comments}
511: -- -----------------------------------------------------------------------------
512: PROCEDURE get_independent_sql
513: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
514: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
515: ,p_effective_date IN DATE
516: ,p_validation_sql OUT NOCOPY VARCHAR2
517: ,p_identification_sql OUT NOCOPY VARCHAR2
518: ,p_has_meaning OUT NOCOPY BOOLEAN

Line 611: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

607: --
608: -- {End of Comments}
609: -- -----------------------------------------------------------------------------
610: PROCEDURE get_dependent_sql
611: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
612: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
613: ,p_effective_date IN DATE
614: ,p_validation_sql OUT NOCOPY VARCHAR2
615: ,p_identification_sql OUT NOCOPY VARCHAR2

Line 612: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

608: -- {End of Comments}
609: -- -----------------------------------------------------------------------------
610: PROCEDURE get_dependent_sql
611: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
612: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
613: ,p_effective_date IN DATE
614: ,p_validation_sql OUT NOCOPY VARCHAR2
615: ,p_identification_sql OUT NOCOPY VARCHAR2
616: ,p_has_meaning OUT NOCOPY BOOLEAN

Line 719: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

715: --
716: -- {End of Comments}
717: -- -----------------------------------------------------------------------------
718: PROCEDURE get_sql
719: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
720: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
721: ,p_validation_type IN fnd_flex_value_sets.validation_type%TYPE
722: ,p_effective_date IN DATE
723: ,p_validation_sql OUT NOCOPY VARCHAR2

Line 720: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

716: -- {End of Comments}
717: -- -----------------------------------------------------------------------------
718: PROCEDURE get_sql
719: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
720: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
721: ,p_validation_type IN fnd_flex_value_sets.validation_type%TYPE
722: ,p_effective_date IN DATE
723: ,p_validation_sql OUT NOCOPY VARCHAR2
724: ,p_identification_sql OUT NOCOPY VARCHAR2

Line 721: ,p_validation_type IN fnd_flex_value_sets.validation_type%TYPE

717: -- -----------------------------------------------------------------------------
718: PROCEDURE get_sql
719: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
720: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
721: ,p_validation_type IN fnd_flex_value_sets.validation_type%TYPE
722: ,p_effective_date IN DATE
723: ,p_validation_sql OUT NOCOPY VARCHAR2
724: ,p_identification_sql OUT NOCOPY VARCHAR2
725: ,p_id_column_type OUT NOCOPY VARCHAR2

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

734: IS
735: --
736: -- Local variables
737: --
738: l_table CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'F';
739: l_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'D';
740: l_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'I';
741: l_translatable_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'X';
742: l_translatable_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'Y';

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

735: --
736: -- Local variables
737: --
738: l_table CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'F';
739: l_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'D';
740: l_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'I';
741: l_translatable_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'X';
742: l_translatable_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'Y';
743: --

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

736: -- Local variables
737: --
738: l_table CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'F';
739: l_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'D';
740: l_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'I';
741: l_translatable_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'X';
742: l_translatable_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'Y';
743: --
744: BEGIN

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

737: --
738: l_table CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'F';
739: l_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'D';
740: l_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'I';
741: l_translatable_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'X';
742: l_translatable_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'Y';
743: --
744: BEGIN
745: --

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

738: l_table CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'F';
739: l_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'D';
740: l_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'I';
741: l_translatable_independent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'X';
742: l_translatable_dependent CONSTANT fnd_flex_value_sets.validation_type%TYPE := 'Y';
743: --
744: BEGIN
745: --
746: -- Get details based on validation type

Line 797: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

793: -- -----------------------------------------------------------------------------
794: -- |-------------------------------< value_set >-------------------------------|
795: -- -----------------------------------------------------------------------------
796: FUNCTION value_set
797: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
798: ,p_effective_date IN DATE
799: )
800: RETURN t_value_set
801: IS

Line 806: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

802: --
803: -- Local cursors
804: --
805: CURSOR csr_value_sets
806: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
807: )
808: IS
809: SELECT fvs.flex_value_set_id
810: ,fvs.alphanumeric_allowed_flag

Line 821: FROM fnd_flex_value_sets fvs

817: ,fvs.number_precision
818: ,fvs.numeric_mode_enabled_flag
819: ,fvs.uppercase_only_flag
820: ,fvs.validation_type
821: FROM fnd_flex_value_sets fvs
822: WHERE fvs.flex_value_set_id = p_flex_value_set_id;
823: --
824: -- Local variables
825: --