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 377: l_basis_string fnd_descr_flex_contexts.descriptive_flex_context_code%type;

373:
374: l_flex FND_DFLEX.dflex_r;
375: l_flex_info FND_DFLEX.dflex_dr;
376:
377: l_basis_string fnd_descr_flex_contexts.descriptive_flex_context_code%type;
378:
379: BEGIN
380:
381: --

Line 789: from fnd_descr_flex_contexts fdfc

785: cursor c_missing(
786: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
787: )is
788: select fdfc.DESCRIPTIVE_FLEX_CONTEXT_CODE
789: from fnd_descr_flex_contexts fdfc
790: where descriptive_flexfield_name = p_flex_name
791: and fdfc.descriptive_flex_context_code <> 'Global Data Elements'
792: and not exists (
793: select 'Y'

Line 981: ,p_context_code in FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE

977: PROCEDURE create_segments(
978: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
979: ,p_context in FND_DFLEX.context_r
980: ,p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
981: ,p_context_code in FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE
982: ) is
983:
984: l_segments FND_DFLEX.segments_dr;
985: l_segment_index NUMBER;

Line 1100: FROM fnd_descr_flex_contexts_vl

1096:
1097: CURSOR get_max_sequence IS
1098: select max(to_number(substrB(DESCRIPTIVE_FLEX_CONTEXT_CODE,
1099: instr(DESCRIPTIVE_FLEX_CONTEXT_CODE,'-')+2)))
1100: FROM fnd_descr_flex_contexts_vl
1101: WHERE descriptive_flexfield_name = 'OTC Information Types'
1102: AND application_id = 809
1103: AND substrB(DESCRIPTIVE_FLEX_CONTEXT_CODE,0,
1104: instr(DESCRIPTIVE_FLEX_CONTEXT_CODE,'-')-2)

Line 1108: l_max_sequence_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;

1104: instr(DESCRIPTIVE_FLEX_CONTEXT_CODE,'-')-2)
1105: =substrB(DESCRIPTIVE_FLEX_CONTEXT_name,0,
1106: instr(DESCRIPTIVE_FLEX_CONTEXT_name,'-')-2)||'C';
1107:
1108: l_max_sequence_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
1109: l_max_sequence_no VARCHAR2(30);
1110: l_flex FND_DFLEX.dflex_r;
1111: l_flex_info FND_DFLEX.dflex_dr;
1112: l_contexts FND_DFLEX.contexts_dr;

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

1117: l_segment_index NUMBER;
1118: l_bld_blk_info_type_id NUMBER;
1119: l_segment_count NUMBER;
1120: l_count NUMBER;
1121: l_sequence_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE DEFAULT NULL;
1122: l_sequence_no NUMBER;
1123: l_message VARCHAR2(100);
1124: l_preserve BOOLEAN;
1125: BEGIN

Line 1471: from fnd_descr_flex_contexts_vl fdfc

1467: where reference_object = p_alias_context_code;
1468:
1469: cursor c_prompt (p_alias_context_code varchar2) is
1470: select fdfc.descriptive_flex_context_name
1471: from fnd_descr_flex_contexts_vl fdfc
1472: where application_id = 809
1473: and DESCRIPTIVE_FLEXFIELD_NAME = 'OTC Aliases'
1474: and fdfc.descriptive_flex_context_code = p_alias_context_code;
1475: