APPS.HXC_TIMECARD_SEARCH_PKG dependencies on FND_VSET

Line 149: l_vset fnd_vset.valueset_r;

145: l_contexts fnd_dflex.contexts_dr;
146: i BINARY_INTEGER;
147: j BINARY_INTEGER;
148: l_segments fnd_dflex.segments_dr;
149: l_vset fnd_vset.valueset_r;
150: l_fmt fnd_vset.valueset_dr;
151: l_found BOOLEAN;
152: l_row NUMBER;
153: l_value fnd_vset.value_dr;

Line 150: l_fmt fnd_vset.valueset_dr;

146: i BINARY_INTEGER;
147: j BINARY_INTEGER;
148: l_segments fnd_dflex.segments_dr;
149: l_vset fnd_vset.valueset_r;
150: l_fmt fnd_vset.valueset_dr;
151: l_found BOOLEAN;
152: l_row NUMBER;
153: l_value fnd_vset.value_dr;
154: l_select_st varchar2(10000);

Line 153: l_value fnd_vset.value_dr;

149: l_vset fnd_vset.valueset_r;
150: l_fmt fnd_vset.valueset_dr;
151: l_found BOOLEAN;
152: l_row NUMBER;
153: l_value fnd_vset.value_dr;
154: l_select_st varchar2(10000);
155: l_meaning_column varchar2(300);
156: l_value_column varchar2(300);
157: l_id_column varchar2(300);

Line 231: fnd_vset.get_valueset(l_segments.value_set(j), l_vset, l_fmt);

227: IF ( l_segments.application_column_name(j) = p_flex_segment )
228: THEN
229: IF (l_segments.value_set(j) is not null)
230: THEN
231: fnd_vset.get_valueset(l_segments.value_set(j), l_vset, l_fmt);
232:
233: -- Get select statement for value set
234: fnd_flex_val_api.get_table_vset_select(
235: p_value_set_id => l_vset.vsid,