APPS.HRI_BPL_FLEX dependencies on FND_FLEX_VALUE_SETS

Line 15: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

11: /******************************************************************************/
12: /* Returns the LOV sql for a table validated value set */
13: /******************************************************************************/
14: PROCEDURE get_table_value_set_sql
15: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
16: ,p_sql_stmt OUT NOCOPY VARCHAR2
17: ,p_distinct_flag IN VARCHAR2) IS
18:
19: /* Code from HR_FLEX_VALUE_SET_INFO (hrfvsinf.pkb) */

Line 108: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

104: /******************************************************************************/
105: /* Formats the sql for a dependent/independent value set */
106: /******************************************************************************/
107: PROCEDURE get_flex_value_set_sql
108: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
109: ,p_sql_stmt OUT NOCOPY VARCHAR2
110: ,p_distinct_flag IN VARCHAR2) IS
111:
112: l_distinct_clause VARCHAR2(30);

Line 145: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

141: /******************************************************************************/
142: /* Returns sql to be used to create a lov based on a value set */
143: /******************************************************************************/
144: PROCEDURE get_value_set_lov_sql
145: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
146: ,p_sql_stmt OUT NOCOPY VARCHAR2
147: ,p_distinct_flag IN VARCHAR2) IS
148:
149: /* Get the value set details */

Line 152: FROM fnd_flex_value_sets fvs

148:
149: /* Get the value set details */
150: CURSOR csr_value_sets IS
151: SELECT fvs.validation_type
152: FROM fnd_flex_value_sets fvs
153: WHERE fvs.flex_value_set_id = p_flex_value_set_id;
154:
155: l_flex_validation_type VARCHAR2(30);
156: l_sql_stmt VARCHAR2(4000);