13: ,p_effective_start_date out nocopy date
14: ,p_effective_end_date out nocopy date
15: ) is
16: --
17: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
18: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
19: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
20: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
21: l_proc varchar2(72) := g_package||'.create_ele_class_usages';
14: ,p_effective_end_date out nocopy date
15: ) is
16: --
17: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
18: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
19: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
20: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
21: l_proc varchar2(72) := g_package||'.create_ele_class_usages';
22: --
15: ) is
16: --
17: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
18: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
19: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
20: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
21: l_proc varchar2(72) := g_package||'.create_ele_class_usages';
22: --
23: begin
16: --
17: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
18: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
19: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
20: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
21: l_proc varchar2(72) := g_package||'.create_ele_class_usages';
22: --
23: begin
24: --
130: ) is
131: --
132: l_proc varchar2(72) :=g_package || '.update_ele_class_usages';
133: --
134: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
135: l_in_out_ele_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
136: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
137: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
138: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
131: --
132: l_proc varchar2(72) :=g_package || '.update_ele_class_usages';
133: --
134: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
135: l_in_out_ele_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
136: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
137: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
138: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
139: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
132: l_proc varchar2(72) :=g_package || '.update_ele_class_usages';
133: --
134: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
135: l_in_out_ele_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
136: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
137: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
138: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
139: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
140: --
133: --
134: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
135: l_in_out_ele_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
136: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
137: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
138: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
139: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
140: --
141: begin
134: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
135: l_in_out_ele_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
136: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
137: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
138: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
139: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
140: --
141: begin
142: hr_utility.set_location(' Entering : '||l_proc,10);
135: l_in_out_ele_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
136: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
137: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
138: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
139: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
140: --
141: begin
142: hr_utility.set_location(' Entering : '||l_proc,10);
143: l_element_class_usage_id := p_element_class_usage_id;
257: ) is
258: --
259: l_proc varchar2(72) :=g_package || '.delete_ele_class_usages';
260: --
261: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
262: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
263: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
264: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
265: --
258: --
259: l_proc varchar2(72) :=g_package || '.delete_ele_class_usages';
260: --
261: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
262: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
263: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
264: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
265: --
266: begin
259: l_proc varchar2(72) :=g_package || '.delete_ele_class_usages';
260: --
261: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
262: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
263: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
264: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
265: --
266: begin
267: --
260: --
261: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
262: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
263: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;
264: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;
265: --
266: begin
267: --
268: hr_utility.set_location(' Entering : '||l_proc,10);