46: -- ========================================
47: -- Procedure Name: Get_contexts
48: -- returns the contexts in a flexfield ordered by the creation_date
49: -- ========================================
50: PROCEDURE get_contexts(flexfield IN FND_DFLEX.DFLEX_R,
51: contexts OUT FND_DFLEX.CONTEXTS_DR)
52: IS
53: CURSOR context_c IS
54: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
47: -- Procedure Name: Get_contexts
48: -- returns the contexts in a flexfield ordered by the creation_date
49: -- ========================================
50: PROCEDURE get_contexts(flexfield IN FND_DFLEX.DFLEX_R,
51: contexts OUT FND_DFLEX.CONTEXTS_DR)
52: IS
53: CURSOR context_c IS
54: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
55: description, global_flag, enabled_flag
78: AND descriptive_flexfield_name = flexfield.flexfield_name
79: ORDER BY creation_date, descriptive_flex_context_code ;
80:
81: i BINARY_INTEGER := 0;
82: rv FND_DFLEX.CONTEXTS_DR;
83:
84: BEGIN
85: rv.global_context := 0;
86: -- Bug 6819715
693: -- ---
694: -- ============================================================================
695: PROCEDURE add_desc_flexfield_segments
696: ( p_nContexts_flag IN BOOLEAN
697: , p_Flexfield IN FND_DFLEX.DFLEX_R
698: , p_Flexinfo IN FND_DFLEX.DFLEX_DR
699: , p_Context_Code IN
700: FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE
701: , p_Context_Num IN NUMBER
694: -- ============================================================================
695: PROCEDURE add_desc_flexfield_segments
696: ( p_nContexts_flag IN BOOLEAN
697: , p_Flexfield IN FND_DFLEX.DFLEX_R
698: , p_Flexinfo IN FND_DFLEX.DFLEX_DR
699: , p_Context_Code IN
700: FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE
701: , p_Context_Num IN NUMBER
702: , p_Prefix IN VARCHAR2
714: , p_schema IN VARCHAR2 --schema name
715: )
716: IS
717: --
718: l_segments FND_DFLEX.SEGMENTS_DR;
719: --
720: l_prefix VARCHAR(100);
721: l_count NUMBER;
722: l_context_code VARCHAR2(100) := NULL;
738: -- l_context_code := '^' || p_Context_Code;
739: l_context_code := '^' || TO_CHAR(p_Context_Num);
740: END IF;
741: --
742: FND_DFLEX.GET_SEGMENTS
743: ( context => FND_DFLEX.MAKE_CONTEXT
744: ( flexfield => p_flexfield
745: , context_code => p_Context_Code
746: )
739: l_context_code := '^' || TO_CHAR(p_Context_Num);
740: END IF;
741: --
742: FND_DFLEX.GET_SEGMENTS
743: ( context => FND_DFLEX.MAKE_CONTEXT
744: ( flexfield => p_flexfield
745: , context_code => p_Context_Code
746: )
747: , segments => l_segments
936: )
937: IS
938: --
939: i NUMBER;
940: l_flexfield FND_DFLEX.DFLEX_R;
941: l_flexinfo FND_DFLEX.DFLEX_DR;
942: l_contexts FND_DFLEX.CONTEXTS_DR;
943: l_segments FND_DFLEX.SEGMENTS_DR;
944: --
937: IS
938: --
939: i NUMBER;
940: l_flexfield FND_DFLEX.DFLEX_R;
941: l_flexinfo FND_DFLEX.DFLEX_DR;
942: l_contexts FND_DFLEX.CONTEXTS_DR;
943: l_segments FND_DFLEX.SEGMENTS_DR;
944: --
945: l_ATT_CATEGORY_flag BOOLEAN := TRUE;
938: --
939: i NUMBER;
940: l_flexfield FND_DFLEX.DFLEX_R;
941: l_flexinfo FND_DFLEX.DFLEX_DR;
942: l_contexts FND_DFLEX.CONTEXTS_DR;
943: l_segments FND_DFLEX.SEGMENTS_DR;
944: --
945: l_ATT_CATEGORY_flag BOOLEAN := TRUE;
946: l_nContexts_flag BOOLEAN;
939: i NUMBER;
940: l_flexfield FND_DFLEX.DFLEX_R;
941: l_flexinfo FND_DFLEX.DFLEX_DR;
942: l_contexts FND_DFLEX.CONTEXTS_DR;
943: l_segments FND_DFLEX.SEGMENTS_DR;
944: --
945: l_ATT_CATEGORY_flag BOOLEAN := TRUE;
946: l_nContexts_flag BOOLEAN;
947: l_count NUMBER := 0;
964: bis_debug_pub.Add('FND_INSTALLATION.GET_APP_INFO returned with error');
965: end if;
966:
967: x_return_status := FND_API.G_RET_STS_SUCCESS;
968: FND_DFLEX.GET_FLEXFIELD( appl_short_name => p_Application_Name
969: , flexfield_name => p_Desc_Flex_Name
970: , flexfield => l_flexfield
971: , flexinfo => l_flexinfo
972: );