294: -- cursor to get flex structures.
295: CURSOR get_flex_structs IS
296: SELECT category_flex_structure, location_flex_structure,
297: asset_key_flex_structure
298: FROM fa_system_controls;
299:
300: -- cursor to get employee.
301: CURSOR get_employee IS
302: SELECT name, employee_number
611: X_Return_Status OUT NOCOPY BOOLEAN
612: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
613: CURSOR get_cat_flex_struct IS
614: SELECT category_flex_structure
615: FROM FA_SYSTEM_CONTROLS;
616: l_cat_flex_struct NUMBER;
617: l_gsval BOOLEAN;
618: l_bal_segnum NUMBER;
619: l_numof_segs NUMBER;