APPS.INV_MWB_QUERY_MANAGER dependencies on FND_DFLEX

Line 2157: v_flexfield fnd_dflex.dflex_r;

2153: END CASE;
2154: END add_group_clause;
2155:
2156: FUNCTION build_attribute_qf_onhand(p_entity IN VARCHAR2) RETURN VARCHAR2 IS
2157: v_flexfield fnd_dflex.dflex_r;
2158: v_flexinfo fnd_dflex.dflex_dr;
2159: v_contexts fnd_dflex.contexts_dr;
2160: v_segments fnd_dflex.segments_dr;
2161:

Line 2158: v_flexinfo fnd_dflex.dflex_dr;

2154: END add_group_clause;
2155:
2156: FUNCTION build_attribute_qf_onhand(p_entity IN VARCHAR2) RETURN VARCHAR2 IS
2157: v_flexfield fnd_dflex.dflex_r;
2158: v_flexinfo fnd_dflex.dflex_dr;
2159: v_contexts fnd_dflex.contexts_dr;
2160: v_segments fnd_dflex.segments_dr;
2161:
2162: l_application_short_name VARCHAR2(10);

Line 2159: v_contexts fnd_dflex.contexts_dr;

2155:
2156: FUNCTION build_attribute_qf_onhand(p_entity IN VARCHAR2) RETURN VARCHAR2 IS
2157: v_flexfield fnd_dflex.dflex_r;
2158: v_flexinfo fnd_dflex.dflex_dr;
2159: v_contexts fnd_dflex.contexts_dr;
2160: v_segments fnd_dflex.segments_dr;
2161:
2162: l_application_short_name VARCHAR2(10);
2163: l_flex_name VARCHAR2(30);

Line 2160: v_segments fnd_dflex.segments_dr;

2156: FUNCTION build_attribute_qf_onhand(p_entity IN VARCHAR2) RETURN VARCHAR2 IS
2157: v_flexfield fnd_dflex.dflex_r;
2158: v_flexinfo fnd_dflex.dflex_dr;
2159: v_contexts fnd_dflex.contexts_dr;
2160: v_segments fnd_dflex.segments_dr;
2161:
2162: l_application_short_name VARCHAR2(10);
2163: l_flex_name VARCHAR2(30);
2164: l_delimiter VARCHAR2(100);

Line 2190: fnd_dflex.get_flexfield(l_application_short_name, l_flex_name, v_flexfield, v_flexinfo);

2186: l_bind_variable := ':onh_serial_attribute';
2187:
2188: END CASE;
2189:
2190: fnd_dflex.get_flexfield(l_application_short_name, l_flex_name, v_flexfield, v_flexinfo);
2191: l_delimiter := v_flexinfo.segment_delimeter;
2192:
2193: fnd_dflex.get_contexts(v_flexfield, v_contexts);
2194: FOR i IN 1..v_contexts.ncontexts LOOP

Line 2193: fnd_dflex.get_contexts(v_flexfield, v_contexts);

2189:
2190: fnd_dflex.get_flexfield(l_application_short_name, l_flex_name, v_flexfield, v_flexinfo);
2191: l_delimiter := v_flexinfo.segment_delimeter;
2192:
2193: fnd_dflex.get_contexts(v_flexfield, v_contexts);
2194: FOR i IN 1..v_contexts.ncontexts LOOP
2195: IF UPPER(v_contexts.context_code(i)) = UPPER(l_context_name) THEN
2196: fnd_dflex.get_segments(
2197: fnd_dflex.make_context(

Line 2196: fnd_dflex.get_segments(

2192:
2193: fnd_dflex.get_contexts(v_flexfield, v_contexts);
2194: FOR i IN 1..v_contexts.ncontexts LOOP
2195: IF UPPER(v_contexts.context_code(i)) = UPPER(l_context_name) THEN
2196: fnd_dflex.get_segments(
2197: fnd_dflex.make_context(
2198: v_flexfield,
2199: v_contexts.context_code(i)
2200: ),

Line 2197: fnd_dflex.make_context(

2193: fnd_dflex.get_contexts(v_flexfield, v_contexts);
2194: FOR i IN 1..v_contexts.ncontexts LOOP
2195: IF UPPER(v_contexts.context_code(i)) = UPPER(l_context_name) THEN
2196: fnd_dflex.get_segments(
2197: fnd_dflex.make_context(
2198: v_flexfield,
2199: v_contexts.context_code(i)
2200: ),
2201: v_segments,