744: )
745: is
746: --
747: v_valid boolean;
748: v_flexfield fnd_flex_key_api.flexfield_type;
749: v_structure fnd_flex_key_api.structure_type;
750: v_segment fnd_flex_key_api.segment_type;
751: v_segment_list fnd_flex_key_api.segment_list;
752: v_nsegments number;
745: is
746: --
747: v_valid boolean;
748: v_flexfield fnd_flex_key_api.flexfield_type;
749: v_structure fnd_flex_key_api.structure_type;
750: v_segment fnd_flex_key_api.segment_type;
751: v_segment_list fnd_flex_key_api.segment_list;
752: v_nsegments number;
753: --
746: --
747: v_valid boolean;
748: v_flexfield fnd_flex_key_api.flexfield_type;
749: v_structure fnd_flex_key_api.structure_type;
750: v_segment fnd_flex_key_api.segment_type;
751: v_segment_list fnd_flex_key_api.segment_list;
752: v_nsegments number;
753: --
754: begin
747: v_valid boolean;
748: v_flexfield fnd_flex_key_api.flexfield_type;
749: v_structure fnd_flex_key_api.structure_type;
750: v_segment fnd_flex_key_api.segment_type;
751: v_segment_list fnd_flex_key_api.segment_list;
752: v_nsegments number;
753: --
754: begin
755: --
789: if p_error_segment_num is not null then
790: --
791: -- Get the name of the error segment
792: --
793: fnd_flex_key_api.set_session_mode('customer_data');
794: --
795: v_flexfield := fnd_flex_key_api.find_flexfield (
796: appl_short_name => 'PAY',
797: flex_code => 'COST'
791: -- Get the name of the error segment
792: --
793: fnd_flex_key_api.set_session_mode('customer_data');
794: --
795: v_flexfield := fnd_flex_key_api.find_flexfield (
796: appl_short_name => 'PAY',
797: flex_code => 'COST'
798: );
799: --
803: p_error_segment_name := null;
804: --
805: else
806: --
807: v_structure := fnd_flex_key_api.find_structure (
808: flexfield => v_flexfield,
809: structure_number => p_cost_id_flex_num
810: );
811: --
808: flexfield => v_flexfield,
809: structure_number => p_cost_id_flex_num
810: );
811: --
812: fnd_flex_key_api.get_segments (
813: flexfield => v_flexfield,
814: structure => v_structure,
815: enabled_only => true,
816: nsegments => v_nsegments,
818: );
819: --
820: p_error_segment_name := v_segment_list(p_error_segment_num);
821: --
822: v_segment := fnd_flex_key_api.find_segment (
823: flexfield => v_flexfield,
824: structure => v_structure,
825: segment_name => p_error_segment_name
826: );
865: p_cost_id_flex_num in number
866: ) return varchar2
867: is
868: --
869: v_flexfield fnd_flex_key_api.flexfield_type;
870: v_structure fnd_flex_key_api.structure_type;
871: --
872: begin
873: --
866: ) return varchar2
867: is
868: --
869: v_flexfield fnd_flex_key_api.flexfield_type;
870: v_structure fnd_flex_key_api.structure_type;
871: --
872: begin
873: --
874: fnd_flex_key_api.set_session_mode('customer_data');
870: v_structure fnd_flex_key_api.structure_type;
871: --
872: begin
873: --
874: fnd_flex_key_api.set_session_mode('customer_data');
875: --
876: v_flexfield := fnd_flex_key_api.find_flexfield (
877: appl_short_name => 'PAY',
878: flex_code => 'COST'
872: begin
873: --
874: fnd_flex_key_api.set_session_mode('customer_data');
875: --
876: v_flexfield := fnd_flex_key_api.find_flexfield (
877: appl_short_name => 'PAY',
878: flex_code => 'COST'
879: );
880: --
877: appl_short_name => 'PAY',
878: flex_code => 'COST'
879: );
880: --
881: v_structure := fnd_flex_key_api.find_structure (
882: flexfield => v_flexfield,
883: structure_number => p_cost_id_flex_num
884: );
885: --