APPS.CSE_ASSET_UTIL_PKG dependencies on FND_FLEX_KEY_API

Line 2546: l_flexfield fnd_flex_key_api.flexfield_type;

2542:
2543: PROCEDURE validate_ccid_required (x_asset_key_required out nocopy varchar2) IS
2544:
2545: l_asset_key_flex_struct number;
2546: l_flexfield fnd_flex_key_api.flexfield_type;
2547: l_structure fnd_flex_key_api.structure_type;
2548: l_num_segments number;
2549: l_segments fnd_flex_key_api.segment_list;
2550: l_segment fnd_flex_key_api.segment_type;

Line 2547: l_structure fnd_flex_key_api.structure_type;

2543: PROCEDURE validate_ccid_required (x_asset_key_required out nocopy varchar2) IS
2544:
2545: l_asset_key_flex_struct number;
2546: l_flexfield fnd_flex_key_api.flexfield_type;
2547: l_structure fnd_flex_key_api.structure_type;
2548: l_num_segments number;
2549: l_segments fnd_flex_key_api.segment_list;
2550: l_segment fnd_flex_key_api.segment_type;
2551:

Line 2549: l_segments fnd_flex_key_api.segment_list;

2545: l_asset_key_flex_struct number;
2546: l_flexfield fnd_flex_key_api.flexfield_type;
2547: l_structure fnd_flex_key_api.structure_type;
2548: l_num_segments number;
2549: l_segments fnd_flex_key_api.segment_list;
2550: l_segment fnd_flex_key_api.segment_type;
2551:
2552: l_asset_key_required varchar2(1) := 'N';
2553:

Line 2550: l_segment fnd_flex_key_api.segment_type;

2546: l_flexfield fnd_flex_key_api.flexfield_type;
2547: l_structure fnd_flex_key_api.structure_type;
2548: l_num_segments number;
2549: l_segments fnd_flex_key_api.segment_list;
2550: l_segment fnd_flex_key_api.segment_type;
2551:
2552: l_asset_key_required varchar2(1) := 'N';
2553:
2554: BEGIN

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

2556: SELECT asset_key_flex_structure
2557: INTO l_asset_key_flex_struct
2558: FROM fa_system_controls;
2559:
2560: fnd_flex_key_api.set_session_mode('seed_data');
2561:
2562: l_flexfield := fnd_flex_key_api.find_flexfield(
2563: appl_short_name => 'OFA',
2564: flex_code => 'KEY#');

Line 2562: l_flexfield := fnd_flex_key_api.find_flexfield(

2558: FROM fa_system_controls;
2559:
2560: fnd_flex_key_api.set_session_mode('seed_data');
2561:
2562: l_flexfield := fnd_flex_key_api.find_flexfield(
2563: appl_short_name => 'OFA',
2564: flex_code => 'KEY#');
2565:
2566: l_structure := fnd_flex_key_api.find_structure(

Line 2566: l_structure := fnd_flex_key_api.find_structure(

2562: l_flexfield := fnd_flex_key_api.find_flexfield(
2563: appl_short_name => 'OFA',
2564: flex_code => 'KEY#');
2565:
2566: l_structure := fnd_flex_key_api.find_structure(
2567: flexfield => l_flexfield,
2568: structure_number => l_asset_key_flex_struct);
2569:
2570: fnd_flex_key_api.get_segments(

Line 2570: fnd_flex_key_api.get_segments(

2566: l_structure := fnd_flex_key_api.find_structure(
2567: flexfield => l_flexfield,
2568: structure_number => l_asset_key_flex_struct);
2569:
2570: fnd_flex_key_api.get_segments(
2571: flexfield => l_flexfield,
2572: structure => l_structure,
2573: enabled_only => TRUE,
2574: nsegments => l_num_segments,

Line 2582: l_segment := fnd_flex_key_api.find_segment(l_flexfield,l_structure,l_segments(l_ind));

2578:
2579: IF l_num_segments > 0 THEN
2580: FOR l_ind IN 1 .. l_num_segments
2581: LOOP
2582: l_segment := fnd_flex_key_api.find_segment(l_flexfield,l_structure,l_segments(l_ind));
2583: IF l_segment.required_flag = 'Y' AND l_segment.enabled_flag = 'Y' THEN
2584: l_asset_key_required := 'Y';
2585: exit;
2586: END IF;