DBA Data[Home] [Help]

APPS.PAY_ECU_API dependencies on PAY_ELEMENT_CLASS_USAGES_F

Line 17: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;

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';

Line 18: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;

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: --

Line 19: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;

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

Line 20: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;

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: --

Line 134: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;

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;

Line 135: l_in_out_ele_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%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;

Line 136: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%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: --

Line 137: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;

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

Line 138: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;

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);

Line 139: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%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);
143: l_element_class_usage_id := p_element_class_usage_id;

Line 261: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;

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: --

Line 262: l_in_out_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;

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

Line 263: l_effective_start_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_START_DATE%TYPE;

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: --

Line 264: l_effective_end_date PAY_ELEMENT_CLASS_USAGES_F.EFFECTIVE_END_DATE%TYPE;

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);