52: IS
53: CURSOR context_c IS
54: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
55: description, global_flag, enabled_flag
56: FROM fnd_descr_flex_contexts_vl
57: WHERE application_id = flexfield.application_id
58: AND descriptive_flexfield_name = flexfield.flexfield_name
59: ORDER BY creation_date;
60:
58: AND descriptive_flexfield_name = flexfield.flexfield_name
59: ORDER BY creation_date;
60:
61: CURSOR context_c_with_hints IS
62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
63: use_nl(fnd_descr_flex_contexts_vl.b)
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
59: ORDER BY creation_date;
60:
61: CURSOR context_c_with_hints IS
62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
63: use_nl(fnd_descr_flex_contexts_vl.b)
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
67: description, global_flag, enabled_flag
60:
61: CURSOR context_c_with_hints IS
62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
63: use_nl(fnd_descr_flex_contexts_vl.b)
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
67: description, global_flag, enabled_flag
68: FROM fnd_descr_flex_contexts_vl
61: CURSOR context_c_with_hints IS
62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
63: use_nl(fnd_descr_flex_contexts_vl.b)
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
67: description, global_flag, enabled_flag
68: FROM fnd_descr_flex_contexts_vl
69: WHERE application_id = flexfield.application_id
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
67: description, global_flag, enabled_flag
68: FROM fnd_descr_flex_contexts_vl
69: WHERE application_id = flexfield.application_id
70: AND descriptive_flexfield_name = flexfield.flexfield_name
71: ORDER BY creation_date;
72:
72:
73: CURSOR context_c_new IS
74: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
75: description, global_flag, enabled_flag
76: FROM fnd_descr_flex_contexts_vl
77: WHERE application_id = flexfield.application_id
78: AND descriptive_flexfield_name = flexfield.flexfield_name
79: ORDER BY creation_date, descriptive_flex_context_code ;
80:
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
703: , p_decode IN BOOLEAN
704: , p_Table_Alias IN VARCHAR2