APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on FND_VSET

Line 2818: r_valueset fnd_vset.valueset_r;

2814:
2815: l_sql LONG;
2816: l_vs_sql LONG;
2817:
2818: r_valueset fnd_vset.valueset_r;
2819: r_format fnd_vset.valueset_dr;
2820:
2821: l_where_clause VARCHAR2(32000);
2822: l_sql_ok BOOLEAN;

Line 2819: r_format fnd_vset.valueset_dr;

2815: l_sql LONG;
2816: l_vs_sql LONG;
2817:
2818: r_valueset fnd_vset.valueset_r;
2819: r_format fnd_vset.valueset_dr;
2820:
2821: l_where_clause VARCHAR2(32000);
2822: l_sql_ok BOOLEAN;
2823:

Line 2880: fnd_vset.GET_VALUESET (

2876: , p_vs_sql => TRUE );
2877:
2878: -- Now get the value set sql
2879:
2880: fnd_vset.GET_VALUESET (
2881: VALUESET_ID => l_comps_r.flex_value_set_id
2882: ,VALUESET => r_valueset
2883: ,FORMAT => r_format );
2884:

Line 4351: l_valueset_r fnd_vset.valueset_r;

4347: -- Declare local variables
4348: --
4349: l_sql_text LONG;
4350: l_sql_text_id LONG;
4351: l_valueset_r fnd_vset.valueset_r;
4352: l_valueset_dr fnd_vset.valueset_dr;
4353: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
4354: l_proc varchar2(72);
4355: l_order_by_start NUMBER;

Line 4352: l_valueset_dr fnd_vset.valueset_dr;

4348: --
4349: l_sql_text LONG;
4350: l_sql_text_id LONG;
4351: l_valueset_r fnd_vset.valueset_r;
4352: l_valueset_dr fnd_vset.valueset_dr;
4353: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
4354: l_proc varchar2(72);
4355: l_order_by_start NUMBER;
4356: l_from_start NUMBER;

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

4370:
4371:
4372: l_value_set_id := p_flex_value_set_id;
4373:
4374: fnd_vset.get_valueset(l_value_set_id,l_valueset_r,l_valueset_dr);
4375:
4376: --
4377: -- Initailize the SQL text columns.
4378: --