APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on FND_VSET

Line 2793: r_valueset fnd_vset.valueset_r;

2789:
2790: l_sql LONG;
2791: l_vs_sql LONG;
2792:
2793: r_valueset fnd_vset.valueset_r;
2794: r_format fnd_vset.valueset_dr;
2795:
2796: l_where_clause VARCHAR2(32000);
2797: l_sql_ok BOOLEAN;

Line 2794: r_format fnd_vset.valueset_dr;

2790: l_sql LONG;
2791: l_vs_sql LONG;
2792:
2793: r_valueset fnd_vset.valueset_r;
2794: r_format fnd_vset.valueset_dr;
2795:
2796: l_where_clause VARCHAR2(32000);
2797: l_sql_ok BOOLEAN;
2798:

Line 2855: fnd_vset.GET_VALUESET (

2851: , p_vs_sql => TRUE );
2852:
2853: -- Now get the value set sql
2854:
2855: fnd_vset.GET_VALUESET (
2856: VALUESET_ID => l_comps_r.flex_value_set_id
2857: ,VALUESET => r_valueset
2858: ,FORMAT => r_format );
2859:

Line 4234: l_valueset_r fnd_vset.valueset_r;

4230: -- Declare local variables
4231: --
4232: l_sql_text LONG;
4233: l_sql_text_id LONG;
4234: l_valueset_r fnd_vset.valueset_r;
4235: l_valueset_dr fnd_vset.valueset_dr;
4236: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
4237: l_proc varchar2(72);
4238: l_order_by_start NUMBER;

Line 4235: l_valueset_dr fnd_vset.valueset_dr;

4231: --
4232: l_sql_text LONG;
4233: l_sql_text_id LONG;
4234: l_valueset_r fnd_vset.valueset_r;
4235: l_valueset_dr fnd_vset.valueset_dr;
4236: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
4237: l_proc varchar2(72);
4238: l_order_by_start NUMBER;
4239: l_from_start NUMBER;

Line 4257: fnd_vset.get_valueset(l_value_set_id,l_valueset_r,l_valueset_dr);

4253:
4254:
4255: l_value_set_id := p_flex_value_set_id;
4256:
4257: fnd_vset.get_valueset(l_value_set_id,l_valueset_r,l_valueset_dr);
4258:
4259: --
4260: -- Initailize the SQL text columns.
4261: --