DBA Data[Home] [Help]

APPS.HR_KFLEX_UTILITY dependencies on FND_FLEX_EXT

Line 542: ,p_parameter in fnd_flex_ext.SegmentArray

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

Line 554: l_parameter_temp fnd_flex_ext.SegmentArray;

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

Line 587: l_delimiter := fnd_flex_ext.get_delimiter

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

Line 925: ,p_parameter out nocopy fnd_flex_ext.SegmentArray

921: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
922: ,p_flex_num in number
923: -- Bug fix 2148839. Application id passed.
924: ,p_application_id in number
925: ,p_parameter out nocopy fnd_flex_ext.SegmentArray
926: )
927: is
928: --
929: -- Declare cursors and local variables

Line 933: l_parameter_temp fnd_flex_ext.SegmentArray;

929: -- Declare cursors and local variables
930: --
931: l_proc varchar2(72);
932: --
933: l_parameter_temp fnd_flex_ext.SegmentArray;
934: l_parameter_sorted fnd_flex_ext.SegmentArray;
935: l_disp_no number;
936: l_seg_no number;
937: l_seg_count number := 0;

Line 934: l_parameter_sorted fnd_flex_ext.SegmentArray;

930: --
931: l_proc varchar2(72);
932: --
933: l_parameter_temp fnd_flex_ext.SegmentArray;
934: l_parameter_sorted fnd_flex_ext.SegmentArray;
935: l_disp_no number;
936: l_seg_no number;
937: l_seg_count number := 0;
938:

Line 1124: (p_parameter in fnd_flex_ext.SegmentArray

1120: -- {End Of Comments}
1121: --
1122: --
1123: function check_pop_segments
1124: (p_parameter in fnd_flex_ext.SegmentArray
1125: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1126: ,p_flex_num in number
1127: -- Bug fix 2148839.parameter p_application_id added.
1128: ,p_application_id in number

Line 1134: l_parameter_temp fnd_flex_ext.SegmentArray;

1130: is
1131: --
1132: l_proc varchar2(72);
1133: --
1134: l_parameter_temp fnd_flex_ext.SegmentArray;
1135: l_no_segments number;
1136: l_no_pop_segments number := 0;
1137: --
1138: begin

Line 1309: l_parameter_sorted fnd_flex_ext.SegmentArray;

1305: -- Declare cursors and local variables
1306: --
1307: l_proc varchar2(72) := 'ins_or_sel_keyflex_comb';
1308: --
1309: l_parameter_sorted fnd_flex_ext.SegmentArray;
1310: l_parameter_temp fnd_flex_ext.SegmentArray;
1311: l_too_many_segs boolean default FALSE;
1312: --
1313: l_flex_code varchar2(30) := NULL;

Line 1310: l_parameter_temp fnd_flex_ext.SegmentArray;

1306: --
1307: l_proc varchar2(72) := 'ins_or_sel_keyflex_comb';
1308: --
1309: l_parameter_sorted fnd_flex_ext.SegmentArray;
1310: l_parameter_temp fnd_flex_ext.SegmentArray;
1311: l_too_many_segs boolean default FALSE;
1312: --
1313: l_flex_code varchar2(30) := NULL;
1314: -- Bug fix 2148839.

Line 1627: l_parameter_temp fnd_flex_ext.SegmentArray;

1623: -- will store ALL the values passed in by the user,
1624: -- even if they are linked to segments which are not
1625: -- set for the KF structure
1626: --
1627: l_parameter_temp fnd_flex_ext.SegmentArray;
1628: --
1629: -- Holds original inserted seg array
1630: --
1631: l_parameter_original fnd_flex_ext.SegmentArray;

Line 1631: l_parameter_original fnd_flex_ext.SegmentArray;

1627: l_parameter_temp fnd_flex_ext.SegmentArray;
1628: --
1629: -- Holds original inserted seg array
1630: --
1631: l_parameter_original fnd_flex_ext.SegmentArray;
1632: --
1633: -- holds new seg array containing updated
1634: -- segment details
1635: --

Line 1636: l_parameter_new fnd_flex_ext.SegmentArray;

1632: --
1633: -- holds new seg array containing updated
1634: -- segment details
1635: --
1636: l_parameter_new fnd_flex_ext.SegmentArray;
1637: --
1638: -- holds complete seg array ready to send
1639: -- to AOL Validation
1640: --

Line 1641: l_parameter_updated fnd_flex_ext.SegmentArray;

1637: --
1638: -- holds complete seg array ready to send
1639: -- to AOL Validation
1640: --
1641: l_parameter_updated fnd_flex_ext.SegmentArray;
1642: -- Bug fix 2148839.
1643: l_application_id number;
1644: --
1645: -- 1141260 : Corrected order by of following cursor.

Line 1835: l_no_segments := fnd_flex_ext.breakup_segments

1831:
1832: -- Convert concatenated string returned into a PL*SQL
1833: -- table segment array
1834: --
1835: l_no_segments := fnd_flex_ext.breakup_segments
1836: (concatenated_segs => l_concat_string
1837: ,delimiter => l_delimiter
1838: ,segments => l_parameter_original
1839: );

Line 2419: fnd_flex_ext.clear_ccid_cache;

2415: l_proc varchar2(72) := g_package||' set_session_nls_language';
2416: begin
2417: -- dbms_session will raise an error is nls_language is invalid
2418: dbms_session.set_nls('NLS_LANGUAGE', ''''||p_nls_language||''''); -- Bug #2958520
2419: fnd_flex_ext.clear_ccid_cache;
2420: exception
2421: when others then
2422: hr_utility.set_location('Error in '||l_proc, 99);
2423: raise;