DBA Data[Home] [Help]

APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on FND_DFLEX

Line 453: l_flex FND_DFLEX.dflex_r;

449: l_loop_var NUMBER default 0;
450: l_key_app VARCHAR2(30) := 'PAY';
451: l_key_flex_code VARCHAR2(30) := 'COST';
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:

Line 454: l_flex_info FND_DFLEX.dflex_dr;

450: l_key_app VARCHAR2(30) := 'PAY';
451: l_key_flex_code VARCHAR2(30) := 'COST';
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: /*

Line 1078: ,p_context in FND_DFLEX.context_r

1074:
1075:
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:

Line 1083: l_segments FND_DFLEX.segments_dr;

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;
1085: l_segment_count NUMBER;
1086:
1087:

Line 1090: FND_DFLEX.get_Segments(

1086:
1087:
1088: BEGIN
1089:
1090: FND_DFLEX.get_Segments(
1091: context => p_context
1092: ,segments => l_segments
1093: ,enabled_only => TRUE);
1094:

Line 1156: (p_contexts in FND_DFLEX.contexts_dr)

1152:
1153: END create_segments;
1154:
1155: FUNCTION check_contexts
1156: (p_contexts in FND_DFLEX.contexts_dr)
1157: RETURN BOOLEAN is
1158:
1159: -- Here we ascertain whether the flex
1160: -- we are duplicating only has

Line 1209: l_flex FND_DFLEX.dflex_r;

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;
1212: l_current_context FND_DFLEX.context_r;
1213: l_global_context FND_DFLEX.context_r;

Line 1210: l_flex_info FND_DFLEX.dflex_dr;

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;
1212: l_current_context FND_DFLEX.context_r;
1213: l_global_context FND_DFLEX.context_r;
1214: l_segments FND_DFLEX.segments_dr;

Line 1211: l_contexts FND_DFLEX.contexts_dr;

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;
1212: l_current_context FND_DFLEX.context_r;
1213: l_global_context FND_DFLEX.context_r;
1214: l_segments FND_DFLEX.segments_dr;
1215: l_context_index NUMBER;

Line 1212: l_current_context FND_DFLEX.context_r;

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;
1212: l_current_context FND_DFLEX.context_r;
1213: l_global_context FND_DFLEX.context_r;
1214: l_segments FND_DFLEX.segments_dr;
1215: l_context_index NUMBER;
1216: l_segment_index NUMBER;

Line 1213: l_global_context FND_DFLEX.context_r;

1209: l_flex FND_DFLEX.dflex_r;
1210: l_flex_info FND_DFLEX.dflex_dr;
1211: l_contexts FND_DFLEX.contexts_dr;
1212: l_current_context FND_DFLEX.context_r;
1213: l_global_context FND_DFLEX.context_r;
1214: l_segments FND_DFLEX.segments_dr;
1215: l_context_index NUMBER;
1216: l_segment_index NUMBER;
1217: l_bld_blk_info_type_id NUMBER;

Line 1214: l_segments FND_DFLEX.segments_dr;

1210: l_flex_info FND_DFLEX.dflex_dr;
1211: l_contexts FND_DFLEX.contexts_dr;
1212: l_current_context FND_DFLEX.context_r;
1213: l_global_context FND_DFLEX.context_r;
1214: l_segments FND_DFLEX.segments_dr;
1215: l_context_index NUMBER;
1216: l_segment_index NUMBER;
1217: l_bld_blk_info_type_id NUMBER;
1218: l_segment_count NUMBER;

Line 1242: FND_DFLEX.get_flexfield

1238: FND_FLEX_DSC_API.set_session_mode('seed_data');
1239: --
1240: -- First fetch the flexfield
1241: --
1242: FND_DFLEX.get_flexfield
1243: (appl_short_name => p_appl_short_name,
1244: flexfield_name => p_flexfield_name,
1245: flexfield => l_flex,
1246: flexinfo => l_flex_info);

Line 1250: FND_DFLEX.get_contexts

1246: flexinfo => l_flex_info);
1247: --
1248: -- Next get the contexts
1249: --
1250: FND_DFLEX.get_contexts
1251: (flexfield => l_flex,
1252: contexts => l_contexts
1253: );
1254: --

Line 1262: l_global_context := FND_DFLEX.make_context

1258: -- then have to do things slightly differently.
1259: --
1260:
1261: if (check_contexts(l_contexts)) then
1262: l_global_context := FND_DFLEX.make_context
1263: (flexfield => l_flex,
1264: context_code =>'Global Data Elements'
1265: );
1266: --

Line 1355: l_current_context := FND_DFLEX.make_context

1351: --
1352: -- Next get the segments for this context, and create them against
1353: -- OTC context, AOL require us to "make" the context first
1354: --
1355: l_current_context := FND_DFLEX.make_context
1356: (flexfield => l_flex,
1357: context_code =>l_contexts.context_code(l_context_index)
1358: );
1359:

Line 1475: fnd_dflex.make_context

1471: p_context_code=> l_sequence_code
1472: );
1473:
1474: l_current_context :=
1475: fnd_dflex.make_context
1476: (flexfield=> l_flex,
1477: context_code=> l_contexts.context_code(l_context_index)
1478: );
1479:

Line 1498: l_global_context := FND_DFLEX.make_context

1494: -- In this case, we've only got the global contexts
1495: -- just set up a p_context_prefix - global context.
1496: -- No loop needed, since there is only one context.
1497:
1498: l_global_context := FND_DFLEX.make_context
1499: (flexfield => l_flex,
1500: context_code =>'Global Data Elements'
1501: );
1502: