113: TYPE cv_typ IS REF CURSOR;
114: cv_get_context cv_typ;
115: get_context_rec cv_get_context%TYPE;
116:
117: ln_application_id fnd_descr_flex_contexts.application_id%TYPE;
118: lv_desc_flexfield_name fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
119: lv_desc_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
120: lv_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;
121: lv_global_flag fnd_descr_flex_contexts.global_flag%TYPE;
114: cv_get_context cv_typ;
115: get_context_rec cv_get_context%TYPE;
116:
117: ln_application_id fnd_descr_flex_contexts.application_id%TYPE;
118: lv_desc_flexfield_name fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
119: lv_desc_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
120: lv_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;
121: lv_global_flag fnd_descr_flex_contexts.global_flag%TYPE;
122: lv_desc_flex_context_name fnd_descr_flex_contexts_tl.descriptive_flex_context_name%TYPE;
115: get_context_rec cv_get_context%TYPE;
116:
117: ln_application_id fnd_descr_flex_contexts.application_id%TYPE;
118: lv_desc_flexfield_name fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
119: lv_desc_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
120: lv_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;
121: lv_global_flag fnd_descr_flex_contexts.global_flag%TYPE;
122: lv_desc_flex_context_name fnd_descr_flex_contexts_tl.descriptive_flex_context_name%TYPE;
123: lv_description fnd_descr_flex_contexts_tl.description%TYPE;
116:
117: ln_application_id fnd_descr_flex_contexts.application_id%TYPE;
118: lv_desc_flexfield_name fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
119: lv_desc_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
120: lv_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;
121: lv_global_flag fnd_descr_flex_contexts.global_flag%TYPE;
122: lv_desc_flex_context_name fnd_descr_flex_contexts_tl.descriptive_flex_context_name%TYPE;
123: lv_description fnd_descr_flex_contexts_tl.description%TYPE;
124: lv_language fnd_descr_flex_contexts_tl.language%TYPE;
117: ln_application_id fnd_descr_flex_contexts.application_id%TYPE;
118: lv_desc_flexfield_name fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
119: lv_desc_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
120: lv_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;
121: lv_global_flag fnd_descr_flex_contexts.global_flag%TYPE;
122: lv_desc_flex_context_name fnd_descr_flex_contexts_tl.descriptive_flex_context_name%TYPE;
123: lv_description fnd_descr_flex_contexts_tl.description%TYPE;
124: lv_language fnd_descr_flex_contexts_tl.language%TYPE;
125:
118: lv_desc_flexfield_name fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
119: lv_desc_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
120: lv_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;
121: lv_global_flag fnd_descr_flex_contexts.global_flag%TYPE;
122: lv_desc_flex_context_name fnd_descr_flex_contexts_tl.descriptive_flex_context_name%TYPE;
123: lv_description fnd_descr_flex_contexts_tl.description%TYPE;
124: lv_language fnd_descr_flex_contexts_tl.language%TYPE;
125:
126: /* CURSOR c_get_context IS
119: lv_desc_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
120: lv_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;
121: lv_global_flag fnd_descr_flex_contexts.global_flag%TYPE;
122: lv_desc_flex_context_name fnd_descr_flex_contexts_tl.descriptive_flex_context_name%TYPE;
123: lv_description fnd_descr_flex_contexts_tl.description%TYPE;
124: lv_language fnd_descr_flex_contexts_tl.language%TYPE;
125:
126: /* CURSOR c_get_context IS
127: select fdfc.application_id,
120: lv_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;
121: lv_global_flag fnd_descr_flex_contexts.global_flag%TYPE;
122: lv_desc_flex_context_name fnd_descr_flex_contexts_tl.descriptive_flex_context_name%TYPE;
123: lv_description fnd_descr_flex_contexts_tl.description%TYPE;
124: lv_language fnd_descr_flex_contexts_tl.language%TYPE;
125:
126: /* CURSOR c_get_context IS
127: select fdfc.application_id,
128: fdfc.DESCRIPTIVE_FLEXFIELD_NAME
132: --,fdfc.SECURITY_GROUP_ID
133: ,fdfctl.DESCRIPTIVE_FLEX_CONTEXT_NAME
134: ,fdfctl.DESCRIPTION
135: ,fdfctl.language
136: from fnd_descr_flex_contexts fdfc,
137: fnd_descr_flex_contexts_tl fdfctl
138: where fdfc.APPLICATION_ID = fdfctl.APPLICATION_ID
139: AND fdfc.DESCRIPTIVE_FLEX_CONTEXT_CODE = fdfctl.DESCRIPTIVE_FLEX_CONTEXT_CODE
140: AND fdfc.DESCRIPTIVE_FLEXFIELD_NAME = fdfctl.DESCRIPTIVE_FLEXFIELD_NAME
133: ,fdfctl.DESCRIPTIVE_FLEX_CONTEXT_NAME
134: ,fdfctl.DESCRIPTION
135: ,fdfctl.language
136: from fnd_descr_flex_contexts fdfc,
137: fnd_descr_flex_contexts_tl fdfctl
138: where fdfc.APPLICATION_ID = fdfctl.APPLICATION_ID
139: AND fdfc.DESCRIPTIVE_FLEX_CONTEXT_CODE = fdfctl.DESCRIPTIVE_FLEX_CONTEXT_CODE
140: AND fdfc.DESCRIPTIVE_FLEXFIELD_NAME = fdfctl.DESCRIPTIVE_FLEXFIELD_NAME
141: AND fdfc.DESCRIPTIVE_FLEXFIELD_NAME = 'Element Developer DF'
199: --,fdfc.SECURITY_GROUP_ID
200: ,fdfctl.DESCRIPTIVE_FLEX_CONTEXT_NAME
201: ,fdfctl.DESCRIPTION
202: ,fdfctl.language
203: from fnd_descr_flex_contexts fdfc,
204: fnd_descr_flex_contexts_tl fdfctl
205: where fdfc.APPLICATION_ID = fdfctl.APPLICATION_ID
206: AND fdfc.DESCRIPTIVE_FLEX_CONTEXT_CODE = fdfctl.DESCRIPTIVE_FLEX_CONTEXT_CODE
207: AND fdfc.DESCRIPTIVE_FLEXFIELD_NAME = fdfctl.DESCRIPTIVE_FLEXFIELD_NAME
200: ,fdfctl.DESCRIPTIVE_FLEX_CONTEXT_NAME
201: ,fdfctl.DESCRIPTION
202: ,fdfctl.language
203: from fnd_descr_flex_contexts fdfc,
204: fnd_descr_flex_contexts_tl fdfctl
205: where fdfc.APPLICATION_ID = fdfctl.APPLICATION_ID
206: AND fdfc.DESCRIPTIVE_FLEX_CONTEXT_CODE = fdfctl.DESCRIPTIVE_FLEX_CONTEXT_CODE
207: AND fdfc.DESCRIPTIVE_FLEXFIELD_NAME = fdfctl.DESCRIPTIVE_FLEXFIELD_NAME
208: AND fdfctl.language = userenv (''LANG'')