DBA Data[Home] [Help]

APPS.HXC_TIMECARD_SEARCH_PKG dependencies on FND_DFLEX

Line 143: l_flexfield fnd_dflex.dflex_r;

139: ,p_user_set IN VARCHAR2 DEFAULT 'Y'
140: )
141: RETURN VARCHAR2
142: IS
143: l_flexfield fnd_dflex.dflex_r;
144: l_flexinfo fnd_dflex.dflex_dr;
145: l_contexts fnd_dflex.contexts_dr;
146: i BINARY_INTEGER;
147: j BINARY_INTEGER;

Line 144: l_flexinfo fnd_dflex.dflex_dr;

140: )
141: RETURN VARCHAR2
142: IS
143: l_flexfield fnd_dflex.dflex_r;
144: l_flexinfo fnd_dflex.dflex_dr;
145: l_contexts fnd_dflex.contexts_dr;
146: i BINARY_INTEGER;
147: j BINARY_INTEGER;
148: l_segments fnd_dflex.segments_dr;

Line 145: l_contexts fnd_dflex.contexts_dr;

141: RETURN VARCHAR2
142: IS
143: l_flexfield fnd_dflex.dflex_r;
144: l_flexinfo fnd_dflex.dflex_dr;
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;

Line 148: l_segments fnd_dflex.segments_dr;

144: l_flexinfo fnd_dflex.dflex_dr;
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;

Line 197: fnd_dflex.get_flexfield(

193: end if;
194:
195:
196: -- Get the flex field
197: fnd_dflex.get_flexfield(
198: p_application_short_name,
199: p_flex_name,
200: l_flexfield,
201: l_flexinfo

Line 206: fnd_dflex.get_contexts(l_flexfield, l_contexts);

202: );
203:
204:
205: -- Get the contexts for the flex field
206: fnd_dflex.get_contexts(l_flexfield, l_contexts);
207:
208: -- Loop for all contexts
209: FOR i IN 1 .. l_contexts.ncontexts LOOP
210: fnd_dflex.get_segments(

Line 210: fnd_dflex.get_segments(

206: fnd_dflex.get_contexts(l_flexfield, l_contexts);
207:
208: -- Loop for all contexts
209: FOR i IN 1 .. l_contexts.ncontexts LOOP
210: fnd_dflex.get_segments(
211: fnd_dflex.make_context(
212: l_flexfield,
213: l_contexts.context_code(i)
214: ),

Line 211: fnd_dflex.make_context(

207:
208: -- Loop for all contexts
209: FOR i IN 1 .. l_contexts.ncontexts LOOP
210: fnd_dflex.get_segments(
211: fnd_dflex.make_context(
212: l_flexfield,
213: l_contexts.context_code(i)
214: ),
215: l_segments,