APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on FND_DESCR_FLEX_CONTEXTS

Line 311: from fnd_descr_flex_contexts_vl c,

307: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
308: ,p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
309: ) is
310: select c.descriptive_flex_context_code, c.descriptive_flex_context_name
311: from fnd_descr_flex_contexts_vl c,
312: fnd_application a
313: where c.descriptive_flexfield_name = p_flex_name
314: and a.application_short_name = p_appl_short_name
315: and a.application_id = c.application_id

Line 456: l_basis_string fnd_descr_flex_contexts.descriptive_flex_context_code%type;

452:
453: l_flex FND_DFLEX.dflex_r;
454: l_flex_info FND_DFLEX.dflex_dr;
455:
456: l_basis_string fnd_descr_flex_contexts.descriptive_flex_context_code%type;
457:
458: /*
459: Added for 8645021 HR OTL Absence Integration
460: */

Line 888: from fnd_descr_flex_contexts fdfc

884: cursor c_missing(
885: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
886: )is
887: select fdfc.DESCRIPTIVE_FLEX_CONTEXT_CODE
888: from fnd_descr_flex_contexts fdfc
889: where descriptive_flexfield_name = p_flex_name
890: and fdfc.descriptive_flex_context_code <> 'Global Data Elements'
891: and not exists (
892: select 'Y'

Line 1080: ,p_context_code in FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE

1076: PROCEDURE create_segments(
1077: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
1078: ,p_context in FND_DFLEX.context_r
1079: ,p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
1080: ,p_context_code in FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE
1081: ) is
1082:
1083: l_segments FND_DFLEX.segments_dr;
1084: l_segment_index NUMBER;

Line 1199: FROM fnd_descr_flex_contexts_vl

1195:
1196: CURSOR get_max_sequence IS
1197: select max(to_number(substrB(DESCRIPTIVE_FLEX_CONTEXT_CODE,
1198: instr(DESCRIPTIVE_FLEX_CONTEXT_CODE,'-')+2)))
1199: FROM fnd_descr_flex_contexts_vl
1200: WHERE descriptive_flexfield_name = 'OTC Information Types'
1201: AND application_id = 809
1202: AND substrB(DESCRIPTIVE_FLEX_CONTEXT_CODE,0,
1203: instr(DESCRIPTIVE_FLEX_CONTEXT_CODE,'-')-2)

Line 1207: l_max_sequence_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;

1203: instr(DESCRIPTIVE_FLEX_CONTEXT_CODE,'-')-2)
1204: =substrB(DESCRIPTIVE_FLEX_CONTEXT_name,0,
1205: instr(DESCRIPTIVE_FLEX_CONTEXT_name,'-')-2)||'C';
1206:
1207: l_max_sequence_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
1208: l_max_sequence_no VARCHAR2(30);
1209: l_flex FND_DFLEX.dflex_r;
1210: l_flex_info FND_DFLEX.dflex_dr;
1211: l_contexts FND_DFLEX.contexts_dr;

Line 1220: l_sequence_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE DEFAULT NULL;

1216: l_segment_index NUMBER;
1217: l_bld_blk_info_type_id NUMBER;
1218: l_segment_count NUMBER;
1219: l_count NUMBER;
1220: l_sequence_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE DEFAULT NULL;
1221: l_sequence_no NUMBER;
1222: l_message VARCHAR2(100);
1223: l_preserve BOOLEAN;
1224: BEGIN

Line 1698: from fnd_descr_flex_contexts_vl fdfc

1694: where reference_object = p_alias_context_code;
1695:
1696: cursor c_prompt (p_alias_context_code varchar2) is
1697: select fdfc.descriptive_flex_context_name
1698: from fnd_descr_flex_contexts_vl fdfc
1699: where application_id = 809
1700: and DESCRIPTIVE_FLEXFIELD_NAME = 'OTC Aliases'
1701: and fdfc.descriptive_flex_context_code = p_alias_context_code;
1702: