DBA Data[Home] [Help]

APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on FND_DFLEX

Line 374: l_flex FND_DFLEX.dflex_r;

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

Line 375: l_flex_info FND_DFLEX.dflex_dr;

371: l_key_app VARCHAR2(30) := 'PAY';
372: l_key_flex_code VARCHAR2(30) := 'COST';
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

Line 979: ,p_context in FND_DFLEX.context_r

975:
976:
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:

Line 984: l_segments FND_DFLEX.segments_dr;

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;
986: l_segment_count NUMBER;
987:
988:

Line 991: FND_DFLEX.get_Segments(

987:
988:
989: BEGIN
990:
991: FND_DFLEX.get_Segments(
992: context => p_context
993: ,segments => l_segments
994: ,enabled_only => TRUE);
995:

Line 1057: (p_contexts in FND_DFLEX.contexts_dr)

1053:
1054: END create_segments;
1055:
1056: FUNCTION check_contexts
1057: (p_contexts in FND_DFLEX.contexts_dr)
1058: RETURN BOOLEAN is
1059:
1060: -- Here we ascertain whether the flex
1061: -- we are duplicating only has

Line 1110: l_flex FND_DFLEX.dflex_r;

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;
1113: l_current_context FND_DFLEX.context_r;
1114: l_global_context FND_DFLEX.context_r;

Line 1111: l_flex_info FND_DFLEX.dflex_dr;

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;
1113: l_current_context FND_DFLEX.context_r;
1114: l_global_context FND_DFLEX.context_r;
1115: l_segments FND_DFLEX.segments_dr;

Line 1112: l_contexts FND_DFLEX.contexts_dr;

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;
1113: l_current_context FND_DFLEX.context_r;
1114: l_global_context FND_DFLEX.context_r;
1115: l_segments FND_DFLEX.segments_dr;
1116: l_context_index NUMBER;

Line 1113: l_current_context FND_DFLEX.context_r;

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;
1113: l_current_context FND_DFLEX.context_r;
1114: l_global_context FND_DFLEX.context_r;
1115: l_segments FND_DFLEX.segments_dr;
1116: l_context_index NUMBER;
1117: l_segment_index NUMBER;

Line 1114: l_global_context FND_DFLEX.context_r;

1110: l_flex FND_DFLEX.dflex_r;
1111: l_flex_info FND_DFLEX.dflex_dr;
1112: l_contexts FND_DFLEX.contexts_dr;
1113: l_current_context FND_DFLEX.context_r;
1114: l_global_context FND_DFLEX.context_r;
1115: l_segments FND_DFLEX.segments_dr;
1116: l_context_index NUMBER;
1117: l_segment_index NUMBER;
1118: l_bld_blk_info_type_id NUMBER;

Line 1115: l_segments FND_DFLEX.segments_dr;

1111: l_flex_info FND_DFLEX.dflex_dr;
1112: l_contexts FND_DFLEX.contexts_dr;
1113: l_current_context FND_DFLEX.context_r;
1114: l_global_context FND_DFLEX.context_r;
1115: l_segments FND_DFLEX.segments_dr;
1116: l_context_index NUMBER;
1117: l_segment_index NUMBER;
1118: l_bld_blk_info_type_id NUMBER;
1119: l_segment_count NUMBER;

Line 1143: FND_DFLEX.get_flexfield

1139: FND_FLEX_DSC_API.set_session_mode('seed_data');
1140: --
1141: -- First fetch the flexfield
1142: --
1143: FND_DFLEX.get_flexfield
1144: (appl_short_name => p_appl_short_name,
1145: flexfield_name => p_flexfield_name,
1146: flexfield => l_flex,
1147: flexinfo => l_flex_info);

Line 1151: FND_DFLEX.get_contexts

1147: flexinfo => l_flex_info);
1148: --
1149: -- Next get the contexts
1150: --
1151: FND_DFLEX.get_contexts
1152: (flexfield => l_flex,
1153: contexts => l_contexts
1154: );
1155: --

Line 1163: l_global_context := FND_DFLEX.make_context

1159: -- then have to do things slightly differently.
1160: --
1161:
1162: if (check_contexts(l_contexts)) then
1163: l_global_context := FND_DFLEX.make_context
1164: (flexfield => l_flex,
1165: context_code =>'Global Data Elements'
1166: );
1167: --

Line 1256: l_current_context := FND_DFLEX.make_context

1252: --
1253: -- Next get the segments for this context, and create them against
1254: -- OTC context, AOL require us to "make" the context first
1255: --
1256: l_current_context := FND_DFLEX.make_context
1257: (flexfield => l_flex,
1258: context_code =>l_contexts.context_code(l_context_index)
1259: );
1260:

Line 1376: fnd_dflex.make_context

1372: p_context_code=> l_sequence_code
1373: );
1374:
1375: l_current_context :=
1376: fnd_dflex.make_context
1377: (flexfield=> l_flex,
1378: context_code=> l_contexts.context_code(l_context_index)
1379: );
1380:

Line 1399: l_global_context := FND_DFLEX.make_context

1395: -- In this case, we've only got the global contexts
1396: -- just set up a p_context_prefix - global context.
1397: -- No loop needed, since there is only one context.
1398:
1399: l_global_context := FND_DFLEX.make_context
1400: (flexfield => l_flex,
1401: context_code =>'Global Data Elements'
1402: );
1403: