DBA Data[Home] [Help]

APPS.PAY_IP_UTILITY dependencies on FND_DESCR_FLEX_CONTEXTS

Line 117: ln_application_id fnd_descr_flex_contexts.application_id%TYPE;

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;

Line 118: lv_desc_flexfield_name fnd_descr_flex_contexts.descriptive_flexfield_name%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;

Line 119: lv_desc_flex_context_code fnd_descr_flex_contexts.descriptive_flex_context_code%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;

Line 120: lv_enabled_flag fnd_descr_flex_contexts.enabled_flag%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;

Line 121: lv_global_flag fnd_descr_flex_contexts.global_flag%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:

Line 122: lv_desc_flex_context_name fnd_descr_flex_contexts_tl.descriptive_flex_context_name%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:
126: /* CURSOR c_get_context IS

Line 123: lv_description fnd_descr_flex_contexts_tl.description%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
127: select fdfc.application_id,

Line 124: lv_language fnd_descr_flex_contexts_tl.language%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,
128: fdfc.DESCRIPTIVE_FLEXFIELD_NAME

Line 136: from fnd_descr_flex_contexts fdfc,

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

Line 137: fnd_descr_flex_contexts_tl fdfctl

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'

Line 203: from fnd_descr_flex_contexts fdfc,

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

Line 204: fnd_descr_flex_contexts_tl fdfctl

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'')