DBA Data[Home] [Help]

APPS.INV_MWB_QUERY_MANAGER dependencies on FND_DFLEX

Line 2440: v_flexfield fnd_dflex.dflex_r;

2436: END CASE;
2437: END add_group_clause;
2438:
2439: FUNCTION build_attribute_qf_onhand(p_entity IN VARCHAR2) RETURN VARCHAR2 IS
2440: v_flexfield fnd_dflex.dflex_r;
2441: v_flexinfo fnd_dflex.dflex_dr;
2442: v_contexts fnd_dflex.contexts_dr;
2443: v_segments fnd_dflex.segments_dr;
2444:

Line 2441: v_flexinfo fnd_dflex.dflex_dr;

2437: END add_group_clause;
2438:
2439: FUNCTION build_attribute_qf_onhand(p_entity IN VARCHAR2) RETURN VARCHAR2 IS
2440: v_flexfield fnd_dflex.dflex_r;
2441: v_flexinfo fnd_dflex.dflex_dr;
2442: v_contexts fnd_dflex.contexts_dr;
2443: v_segments fnd_dflex.segments_dr;
2444:
2445: l_application_short_name VARCHAR2(10);

Line 2442: v_contexts fnd_dflex.contexts_dr;

2438:
2439: FUNCTION build_attribute_qf_onhand(p_entity IN VARCHAR2) RETURN VARCHAR2 IS
2440: v_flexfield fnd_dflex.dflex_r;
2441: v_flexinfo fnd_dflex.dflex_dr;
2442: v_contexts fnd_dflex.contexts_dr;
2443: v_segments fnd_dflex.segments_dr;
2444:
2445: l_application_short_name VARCHAR2(10);
2446: l_flex_name VARCHAR2(30);

Line 2443: v_segments fnd_dflex.segments_dr;

2439: FUNCTION build_attribute_qf_onhand(p_entity IN VARCHAR2) RETURN VARCHAR2 IS
2440: v_flexfield fnd_dflex.dflex_r;
2441: v_flexinfo fnd_dflex.dflex_dr;
2442: v_contexts fnd_dflex.contexts_dr;
2443: v_segments fnd_dflex.segments_dr;
2444:
2445: l_application_short_name VARCHAR2(10);
2446: l_flex_name VARCHAR2(30);
2447: l_delimiter VARCHAR2(100);

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

2469: l_bind_variable := ':onh_serial_attribute';
2470:
2471: END CASE;
2472:
2473: fnd_dflex.get_flexfield(l_application_short_name, l_flex_name, v_flexfield, v_flexinfo);
2474: l_delimiter := v_flexinfo.segment_delimeter;
2475:
2476: fnd_dflex.get_contexts(v_flexfield, v_contexts);
2477: FOR i IN 1..v_contexts.ncontexts LOOP

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

2472:
2473: fnd_dflex.get_flexfield(l_application_short_name, l_flex_name, v_flexfield, v_flexinfo);
2474: l_delimiter := v_flexinfo.segment_delimeter;
2475:
2476: fnd_dflex.get_contexts(v_flexfield, v_contexts);
2477: FOR i IN 1..v_contexts.ncontexts LOOP
2478: IF UPPER(v_contexts.context_code(i)) = UPPER(l_context_name) THEN
2479: fnd_dflex.get_segments(
2480: fnd_dflex.make_context(

Line 2479: fnd_dflex.get_segments(

2475:
2476: fnd_dflex.get_contexts(v_flexfield, v_contexts);
2477: FOR i IN 1..v_contexts.ncontexts LOOP
2478: IF UPPER(v_contexts.context_code(i)) = UPPER(l_context_name) THEN
2479: fnd_dflex.get_segments(
2480: fnd_dflex.make_context(
2481: v_flexfield,
2482: v_contexts.context_code(i)
2483: ),

Line 2480: fnd_dflex.make_context(

2476: fnd_dflex.get_contexts(v_flexfield, v_contexts);
2477: FOR i IN 1..v_contexts.ncontexts LOOP
2478: IF UPPER(v_contexts.context_code(i)) = UPPER(l_context_name) THEN
2479: fnd_dflex.get_segments(
2480: fnd_dflex.make_context(
2481: v_flexfield,
2482: v_contexts.context_code(i)
2483: ),
2484: v_segments,