DBA Data[Home] [Help]

APPS.HR_KFLEX_UTILITY dependencies on FND_FLEX_EXT

Line 543: ,p_parameter in fnd_flex_ext.SegmentArray

539: procedure check_segment_combination
540: (p_appl_short_name in fnd_application.application_short_name%TYPE
541: ,p_flex_num in number
542: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
543: ,p_parameter in fnd_flex_ext.SegmentArray
544: ,p_too_many_segs in boolean
545: ,p_ccid out nocopy number
546: ,p_concat_segments_out out nocopy varchar2
547: )

Line 555: l_parameter_temp fnd_flex_ext.SegmentArray;

551: --
552: l_proc varchar2(72);
553: --
554: l_seg_plsql_row_num binary_integer;
555: l_parameter_temp fnd_flex_ext.SegmentArray;
556: l_delimiter varchar2(1);
557: l_concat_string varchar2(2000);
558: l_segment_value varchar2(2000);
559: l_first_seg boolean;

Line 588: l_delimiter := fnd_flex_ext.get_delimiter

584: --
585: -- Calls function to return delimeter for relevant flexfield
586: -- structure
587: --
588: l_delimiter := fnd_flex_ext.get_delimiter
589: (p_appl_short_name
590: ,p_flex_code
591: ,p_flex_num
592: );

Line 934: ,p_parameter out nocopy fnd_flex_ext.SegmentArray

930: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
931: ,p_flex_num in number
932: -- Bug fix 2148839. Application id passed.
933: ,p_application_id in number
934: ,p_parameter out nocopy fnd_flex_ext.SegmentArray
935: )
936: is
937: --
938: -- Declare cursors and local variables

Line 942: l_parameter_temp fnd_flex_ext.SegmentArray;

938: -- Declare cursors and local variables
939: --
940: l_proc varchar2(72);
941: --
942: l_parameter_temp fnd_flex_ext.SegmentArray;
943: l_parameter_sorted fnd_flex_ext.SegmentArray;
944: l_disp_no number;
945: l_seg_no number;
946: l_seg_count number := 0;

Line 943: l_parameter_sorted fnd_flex_ext.SegmentArray;

939: --
940: l_proc varchar2(72);
941: --
942: l_parameter_temp fnd_flex_ext.SegmentArray;
943: l_parameter_sorted fnd_flex_ext.SegmentArray;
944: l_disp_no number;
945: l_seg_no number;
946: l_seg_count number := 0;
947:

Line 1133: (p_parameter in fnd_flex_ext.SegmentArray

1129: -- {End Of Comments}
1130: --
1131: --
1132: function check_pop_segments
1133: (p_parameter in fnd_flex_ext.SegmentArray
1134: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1135: ,p_flex_num in number
1136: -- Bug fix 2148839.parameter p_application_id added.
1137: ,p_application_id in number

Line 1143: l_parameter_temp fnd_flex_ext.SegmentArray;

1139: is
1140: --
1141: l_proc varchar2(72);
1142: --
1143: l_parameter_temp fnd_flex_ext.SegmentArray;
1144: l_no_segments number;
1145: l_no_pop_segments number := 0;
1146: --
1147: begin

Line 1318: l_parameter_sorted fnd_flex_ext.SegmentArray;

1314: -- Declare cursors and local variables
1315: --
1316: l_proc varchar2(72) := 'ins_or_sel_keyflex_comb';
1317: --
1318: l_parameter_sorted fnd_flex_ext.SegmentArray;
1319: l_parameter_temp fnd_flex_ext.SegmentArray;
1320: l_too_many_segs boolean default FALSE;
1321: --
1322: l_flex_code varchar2(30) := NULL;

Line 1319: l_parameter_temp fnd_flex_ext.SegmentArray;

1315: --
1316: l_proc varchar2(72) := 'ins_or_sel_keyflex_comb';
1317: --
1318: l_parameter_sorted fnd_flex_ext.SegmentArray;
1319: l_parameter_temp fnd_flex_ext.SegmentArray;
1320: l_too_many_segs boolean default FALSE;
1321: --
1322: l_flex_code varchar2(30) := NULL;
1323: -- Bug fix 2148839.

Line 1636: l_parameter_temp fnd_flex_ext.SegmentArray;

1632: -- will store ALL the values passed in by the user,
1633: -- even if they are linked to segments which are not
1634: -- set for the KF structure
1635: --
1636: l_parameter_temp fnd_flex_ext.SegmentArray;
1637: --
1638: -- Holds original inserted seg array
1639: --
1640: l_parameter_original fnd_flex_ext.SegmentArray;

Line 1640: l_parameter_original fnd_flex_ext.SegmentArray;

1636: l_parameter_temp fnd_flex_ext.SegmentArray;
1637: --
1638: -- Holds original inserted seg array
1639: --
1640: l_parameter_original fnd_flex_ext.SegmentArray;
1641: --
1642: -- holds new seg array containing updated
1643: -- segment details
1644: --

Line 1645: l_parameter_new fnd_flex_ext.SegmentArray;

1641: --
1642: -- holds new seg array containing updated
1643: -- segment details
1644: --
1645: l_parameter_new fnd_flex_ext.SegmentArray;
1646: --
1647: -- holds complete seg array ready to send
1648: -- to AOL Validation
1649: --

Line 1650: l_parameter_updated fnd_flex_ext.SegmentArray;

1646: --
1647: -- holds complete seg array ready to send
1648: -- to AOL Validation
1649: --
1650: l_parameter_updated fnd_flex_ext.SegmentArray;
1651: -- Bug fix 2148839.
1652: l_application_id number;
1653: --
1654: -- 1141260 : Corrected order by of following cursor.

Line 1844: l_no_segments := fnd_flex_ext.breakup_segments

1840:
1841: -- Convert concatenated string returned into a PL*SQL
1842: -- table segment array
1843: --
1844: l_no_segments := fnd_flex_ext.breakup_segments
1845: (concatenated_segs => l_concat_string
1846: ,delimiter => l_delimiter
1847: ,segments => l_parameter_original
1848: );

Line 2434: fnd_flex_ext.clear_ccid_cache;

2430: l_proc varchar2(72) := g_package||' set_session_nls_language';
2431: begin
2432: -- dbms_session will raise an error is nls_language is invalid
2433: dbms_session.set_nls('NLS_LANGUAGE', ''''||p_nls_language||''''); -- Bug #2958520
2434: fnd_flex_ext.clear_ccid_cache;
2435: exception
2436: when others then
2437: hr_utility.set_location('Error in '||l_proc, 99);
2438: raise;