[Home] [Help]
PACKAGE: APPS.HR_UTIL_FLEX_WEB
Source
1 package hr_util_flex_web AUTHID CURRENT_USER as
2 /* $Header: hrutlflw.pkh 115.0 99/07/17 18:18:26 porting ship $ */
3 --
4 g_flexfield_not_found exception;
5 g_both_seg_name_invalid exception;
6 g_seg_name1_invalid exception;
7 g_seg_name2_invalid exception;
8 --
9 -- ---------------------------------------------------------------------------
10 -- -------------------- <get_keyflex_mapped_column_name> ---------------------
11 -- ---------------------------------------------------------------------------
12 Procedure get_keyflex_mapped_column_name
13 (p_business_group_id in number
14 ,p_keyflex_code in varchar2
15 ,p_mapped_col_name1 out varchar2
16 ,p_mapped_col_name2 out varchar2
17 ,p_keyflex_id_flex_num out number
18 ,p_segment_separator out varchar2
19 ,p_warning out varchar2);
20 --
21 -- ---------------------------------------------------------------------------
22 -- ------------------------< validate_seg_col_name > -------------------------
23 ------------------------------------------------------------------------------
24 Procedure validate_seg_col_name(p_segment_name1 in varchar2 default null
25 ,p_segment_name2 in varchar2 default null
26 ,p_app_short_name in varchar2
27 ,p_flex_code in varchar2
28 ,p_id_flex_num in number
29 ,p_segment_name_valid out varchar2
30 ,p_tbl_col_name_used out varchar2
31 ,p_flexfield_rec out
32 fnd_flex_key_api.flexfield_type
33 ,p_structure_rec out
34 fnd_flex_key_api.structure_type);
35 --
36 -- ---------------------------------------------------------------------------
37 -- ------------------------- <get_keyflex_info> ------------------------------
38 -- ---------------------------------------------------------------------------
39 Procedure get_keyflex_info(p_app_short_name in varchar2
40 ,p_flex_code in varchar2
41 ,p_id_flex_num in number
42 ,p_segment_name1 in varchar2 default null
43 ,p_segment_name2 in varchar2 default null
44 ,p_mapped_tbl_col_name1 out varchar2
45 ,p_mapped_tbl_col_name2 out varchar2
46 ,p_flexfield_rec in
47 fnd_flex_key_api.flexfield_type
48 ,p_structure_rec in
49 fnd_flex_key_api.structure_type);
50 -- ---------------------------------------------------------------------------
51 --
52 END hr_util_flex_web;