[Home] [Help]
PACKAGE BODY: APPS.PAY_BALANCE_TYPES_DATA_PUMP
Source
1 PACKAGE BODY pay_balance_types_data_pump AS
2 /* $Header: pybltdpm.pkb 120.0 2005/05/29 03:20:59 appldev noship $ */
3
4 ------------------------------ user_key_to_id ---------------------------------
5 --
6 -- Returns an ID value from hr_pump_batch_line_user_keys alone.
7 -- Utility function to get _ID functions.
8 --
9 Function user_key_to_id(p_user_key_value in varchar2)
10 return number is
11 l_id number;
12 Begin
13 select unique_key_id
14 into l_id
15 from hr_pump_batch_line_user_keys
16 where user_key_value = p_user_key_value;
17 return(l_id);
18 End user_key_to_id;
19 --
20
21 ----------------------------- get_balance_category_id -----------------------------
22 --
23 -- Returns the balance_category id
24 --
25 Function get_balance_category_id
26 (p_effective_date in date
27 ,p_business_group_id in number
28 ,p_category_name in varchar2
29 ) return number is
30 --
31 l_balance_category_id pay_balance_types.balance_category_id%type;
32 --
33 Begin
34 select balance_category_id
35 into l_balance_category_id
36 from pay_balance_categories_f
37 where category_name = p_category_name
38 and nvl(business_group_id, nvl(p_business_group_id,-1))
39 = nvl(p_business_group_id,-1)
40 and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))
41 = nvl(hr_api.return_legislation_code(p_business_group_id),' ')
42 and p_effective_date between effective_start_date
43 and effective_end_date;
44
45 --
46 return (l_balance_category_id);
47 Exception
48 when others then
49 hr_data_pump.fail('get_balance_category_id', sqlerrm, p_category_name,
50 p_business_group_id,p_effective_date);
51 raise;
52 End get_balance_category_id;
53 --
54 ------------------------------get_base_balance_type_id------------------------------------
55 --
56 -- Return the formula id.
57 --
58
59 Function get_base_balance_type_id( p_base_balance_Name in varchar2,
60 p_business_group_id in number
61 ) return number is
62
63 l_balance_type_id number ;
64
65 Begin
66
67 select balance_type_id
68 into l_balance_type_id
69 from pay_balance_types
70 where base_balance_type_id is null
71 and balance_name = p_base_balance_name
72 and nvl(business_group_id, nvl(p_business_group_id,-1))
73 = nvl(p_business_group_id,-1)
74 and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))
75 = nvl(hr_api.return_legislation_code(p_business_group_id),' ');
76
77 RETURN(l_balance_type_id);
78
79 Exception
80 When OTHERS Then
81 hr_data_pump.fail('get_base_balance_type_id', sqlerrm, p_base_balance_Name,
82 p_business_group_id);
83 RAISE;
84 End get_base_balance_type_id;
85 --
86 -----------------------------get_input_value_id-----------------------------
87
88 Function get_input_value_id (p_element_name in varchar2,
89 p_input_name in varchar2,
90 p_business_group_id in number,
91 p_effective_date in date,
92 p_language_code in varchar2
93 ) return number is
94
95 l_input_value_id number;
96
97 Begin
98
99 l_input_value_id := hr_pump_get.get_input_value_id
100 (p_input_name,
101 p_element_name ,
102 p_business_group_id ,
103 p_effective_date ,
104 p_language_code );
105
106 return(l_input_value_id);
107
108 Exception
109 When OTHERS Then
110 hr_data_pump.fail('get_input_value_id', sqlerrm,
111 p_element_name,p_input_name,
112 p_business_group_id , p_effective_date,
113 p_language_code
114 );
115 RAISE;
116 End get_input_value_id;
117 --
118 --
119 ------------------------- get_balance_type_ovn -------------------------
120 --
121 -- Returns the object version number of the balance type and requires a
122 -- user key.
123 --
124 Function get_balance_type_ovn
125 (p_balance_type_user_key in varchar2
126 )
127 return number is
128 --
129 l_blt_ovn number;
130 --
131 Begin
132 select blt.object_version_number
133 into l_blt_ovn
134 from pay_balance_types blt,
135 hr_pump_batch_line_user_keys key
136 where key.user_key_value = p_balance_type_user_key
137 and blt.balance_type_id = key.unique_key_id;
138 --
139 return(l_blt_ovn);
140 exception
141 when others then
142 hr_data_pump.fail('get_balance_type_ovn'
143 ,sqlerrm
144 ,p_balance_type_user_key
145 );
146 raise;
147 End get_balance_type_ovn;
148 --
149 -------------------------- get_balance_type_id -------------------------
150 --
151 -- Returns a balance_types_id and requires a user_key.
152 --
153 function get_balance_type_id
154 (
155 p_balance_type_user_key in varchar2
156 ) return number is
157 l_balance_type_id number;
158 begin
159 l_balance_type_id := user_key_to_id(p_balance_type_user_key);
160 return(l_balance_type_id);
161 exception
162 when others then
163 hr_data_pump.fail('get_balance_type_id', sqlerrm, p_balance_type_user_key);
164 raise;
165 end get_balance_type_id;
166 --
167 END pay_balance_types_data_pump ;