DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on FND_FLEX_KEY_API

Line 1315: l_key_flex_field fnd_flex_key_api.flexfield_type;

1311: p_structure_number IN NUMBER)
1312: RETURN VARCHAR2
1313: IS
1314:
1315: l_key_flex_field fnd_flex_key_api.flexfield_type;
1316: l_structure_type fnd_flex_key_api.structure_type;
1317: l_segment_type fnd_flex_key_api.segment_type;
1318: l_segment_list fnd_flex_key_api.segment_list;
1319: l_segment_array fnd_flex_ext.SegmentArray;

Line 1316: l_structure_type fnd_flex_key_api.structure_type;

1312: RETURN VARCHAR2
1313: IS
1314:
1315: l_key_flex_field fnd_flex_key_api.flexfield_type;
1316: l_structure_type fnd_flex_key_api.structure_type;
1317: l_segment_type fnd_flex_key_api.segment_type;
1318: l_segment_list fnd_flex_key_api.segment_list;
1319: l_segment_array fnd_flex_ext.SegmentArray;
1320: l_num_segments NUMBER;

Line 1317: l_segment_type fnd_flex_key_api.segment_type;

1313: IS
1314:
1315: l_key_flex_field fnd_flex_key_api.flexfield_type;
1316: l_structure_type fnd_flex_key_api.structure_type;
1317: l_segment_type fnd_flex_key_api.segment_type;
1318: l_segment_list fnd_flex_key_api.segment_list;
1319: l_segment_array fnd_flex_ext.SegmentArray;
1320: l_num_segments NUMBER;
1321: l_flag BOOLEAN;

Line 1318: l_segment_list fnd_flex_key_api.segment_list;

1314:
1315: l_key_flex_field fnd_flex_key_api.flexfield_type;
1316: l_structure_type fnd_flex_key_api.structure_type;
1317: l_segment_type fnd_flex_key_api.segment_type;
1318: l_segment_list fnd_flex_key_api.segment_list;
1319: l_segment_array fnd_flex_ext.SegmentArray;
1320: l_num_segments NUMBER;
1321: l_flag BOOLEAN;
1322: l_concat VARCHAR2(2000);

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

1323: j NUMBER;
1324: i NUMBER;
1325: BEGIN
1326:
1327: fnd_flex_key_api.set_session_mode('seed_data');
1328:
1329: l_key_flex_field :=
1330: fnd_flex_key_api.find_flexfield(p_appl_short_name,
1331: p_key_flex_code);

Line 1330: fnd_flex_key_api.find_flexfield(p_appl_short_name,

1326:
1327: fnd_flex_key_api.set_session_mode('seed_data');
1328:
1329: l_key_flex_field :=
1330: fnd_flex_key_api.find_flexfield(p_appl_short_name,
1331: p_key_flex_code);
1332:
1333: l_structure_type :=
1334: fnd_flex_key_api.find_structure(l_key_flex_field,

Line 1334: fnd_flex_key_api.find_structure(l_key_flex_field,

1330: fnd_flex_key_api.find_flexfield(p_appl_short_name,
1331: p_key_flex_code);
1332:
1333: l_structure_type :=
1334: fnd_flex_key_api.find_structure(l_key_flex_field,
1335: p_structure_number);
1336:
1337: fnd_flex_key_api.get_segments(l_key_flex_field, l_structure_type,
1338: TRUE, l_num_segments, l_segment_list);

Line 1337: fnd_flex_key_api.get_segments(l_key_flex_field, l_structure_type,

1333: l_structure_type :=
1334: fnd_flex_key_api.find_structure(l_key_flex_field,
1335: p_structure_number);
1336:
1337: fnd_flex_key_api.get_segments(l_key_flex_field, l_structure_type,
1338: TRUE, l_num_segments, l_segment_list);
1339:
1340:
1341: --

Line 1347: fnd_flex_key_api.find_segment(l_key_flex_field,

1343: -- i.e. sorted by segment number.
1344: --
1345: for i in 1..l_num_segments loop
1346: l_segment_type :=
1347: fnd_flex_key_api.find_segment(l_key_flex_field,
1348: l_structure_type,
1349: l_segment_list(i));
1350: j := to_number(substr(l_segment_type.column_name,8));
1351: l_segment_array(i) := g_kf_segment_values(j);