DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on FND_FLEX_KEY_API

Line 1309: l_key_flex_field fnd_flex_key_api.flexfield_type;

1305: p_structure_number IN NUMBER)
1306: RETURN VARCHAR2
1307: IS
1308:
1309: l_key_flex_field fnd_flex_key_api.flexfield_type;
1310: l_structure_type fnd_flex_key_api.structure_type;
1311: l_segment_type fnd_flex_key_api.segment_type;
1312: l_segment_list fnd_flex_key_api.segment_list;
1313: l_segment_array fnd_flex_ext.SegmentArray;

Line 1310: l_structure_type fnd_flex_key_api.structure_type;

1306: RETURN VARCHAR2
1307: IS
1308:
1309: l_key_flex_field fnd_flex_key_api.flexfield_type;
1310: l_structure_type fnd_flex_key_api.structure_type;
1311: l_segment_type fnd_flex_key_api.segment_type;
1312: l_segment_list fnd_flex_key_api.segment_list;
1313: l_segment_array fnd_flex_ext.SegmentArray;
1314: l_num_segments NUMBER;

Line 1311: l_segment_type fnd_flex_key_api.segment_type;

1307: IS
1308:
1309: l_key_flex_field fnd_flex_key_api.flexfield_type;
1310: l_structure_type fnd_flex_key_api.structure_type;
1311: l_segment_type fnd_flex_key_api.segment_type;
1312: l_segment_list fnd_flex_key_api.segment_list;
1313: l_segment_array fnd_flex_ext.SegmentArray;
1314: l_num_segments NUMBER;
1315: l_flag BOOLEAN;

Line 1312: l_segment_list fnd_flex_key_api.segment_list;

1308:
1309: l_key_flex_field fnd_flex_key_api.flexfield_type;
1310: l_structure_type fnd_flex_key_api.structure_type;
1311: l_segment_type fnd_flex_key_api.segment_type;
1312: l_segment_list fnd_flex_key_api.segment_list;
1313: l_segment_array fnd_flex_ext.SegmentArray;
1314: l_num_segments NUMBER;
1315: l_flag BOOLEAN;
1316: l_concat VARCHAR2(2000);

Line 1321: fnd_flex_key_api.set_session_mode('seed_data');

1317: j NUMBER;
1318: i NUMBER;
1319: BEGIN
1320:
1321: fnd_flex_key_api.set_session_mode('seed_data');
1322:
1323: l_key_flex_field :=
1324: fnd_flex_key_api.find_flexfield(p_appl_short_name,
1325: p_key_flex_code);

Line 1324: fnd_flex_key_api.find_flexfield(p_appl_short_name,

1320:
1321: fnd_flex_key_api.set_session_mode('seed_data');
1322:
1323: l_key_flex_field :=
1324: fnd_flex_key_api.find_flexfield(p_appl_short_name,
1325: p_key_flex_code);
1326:
1327: l_structure_type :=
1328: fnd_flex_key_api.find_structure(l_key_flex_field,

Line 1328: fnd_flex_key_api.find_structure(l_key_flex_field,

1324: fnd_flex_key_api.find_flexfield(p_appl_short_name,
1325: p_key_flex_code);
1326:
1327: l_structure_type :=
1328: fnd_flex_key_api.find_structure(l_key_flex_field,
1329: p_structure_number);
1330:
1331: fnd_flex_key_api.get_segments(l_key_flex_field, l_structure_type,
1332: TRUE, l_num_segments, l_segment_list);

Line 1331: fnd_flex_key_api.get_segments(l_key_flex_field, l_structure_type,

1327: l_structure_type :=
1328: fnd_flex_key_api.find_structure(l_key_flex_field,
1329: p_structure_number);
1330:
1331: fnd_flex_key_api.get_segments(l_key_flex_field, l_structure_type,
1332: TRUE, l_num_segments, l_segment_list);
1333:
1334:
1335: --

Line 1341: fnd_flex_key_api.find_segment(l_key_flex_field,

1337: -- i.e. sorted by segment number.
1338: --
1339: for i in 1..l_num_segments loop
1340: l_segment_type :=
1341: fnd_flex_key_api.find_segment(l_key_flex_field,
1342: l_structure_type,
1343: l_segment_list(i));
1344: j := to_number(substr(l_segment_type.column_name,8));
1345: l_segment_array(i) := g_kf_segment_values(j);