29: l_effective_date date;
30: --
31: -- Declare OUT variables
32: --
33: l_run_type_usage_id pay_run_type_usages_f.run_type_usage_id%TYPE;
34: l_object_version_number pay_run_type_usages_f.object_version_number%TYPE;
35: l_effective_start_date pay_run_type_usages_f.effective_start_date%TYPE;
36: l_effective_end_date pay_run_type_usages_f.effective_end_date%TYPE;
37: --
30: --
31: -- Declare OUT variables
32: --
33: l_run_type_usage_id pay_run_type_usages_f.run_type_usage_id%TYPE;
34: l_object_version_number pay_run_type_usages_f.object_version_number%TYPE;
35: l_effective_start_date pay_run_type_usages_f.effective_start_date%TYPE;
36: l_effective_end_date pay_run_type_usages_f.effective_end_date%TYPE;
37: --
38: begin
31: -- Declare OUT variables
32: --
33: l_run_type_usage_id pay_run_type_usages_f.run_type_usage_id%TYPE;
34: l_object_version_number pay_run_type_usages_f.object_version_number%TYPE;
35: l_effective_start_date pay_run_type_usages_f.effective_start_date%TYPE;
36: l_effective_end_date pay_run_type_usages_f.effective_end_date%TYPE;
37: --
38: begin
39: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: l_run_type_usage_id pay_run_type_usages_f.run_type_usage_id%TYPE;
34: l_object_version_number pay_run_type_usages_f.object_version_number%TYPE;
35: l_effective_start_date pay_run_type_usages_f.effective_start_date%TYPE;
36: l_effective_end_date pay_run_type_usages_f.effective_end_date%TYPE;
37: --
38: begin
39: hr_utility.set_location('Entering:'|| l_proc, 10);
40: --
185: l_effective_date date;
186: --
187: -- Declare OUT variables
188: --
189: l_effective_start_date pay_run_type_usages_f.effective_start_date%TYPE;
190: l_effective_end_date pay_run_type_usages_f.effective_end_date%TYPE;
191: --
192: -- Declare IN OUT variable
193: --
186: --
187: -- Declare OUT variables
188: --
189: l_effective_start_date pay_run_type_usages_f.effective_start_date%TYPE;
190: l_effective_end_date pay_run_type_usages_f.effective_end_date%TYPE;
191: --
192: -- Declare IN OUT variable
193: --
194: l_object_version_number pay_run_type_usages_f.object_version_number%TYPE;
190: l_effective_end_date pay_run_type_usages_f.effective_end_date%TYPE;
191: --
192: -- Declare IN OUT variable
193: --
194: l_object_version_number pay_run_type_usages_f.object_version_number%TYPE;
195: --
196: begin
197: hr_utility.set_location('Entering:'|| l_proc, 10);
198: --
334: l_effective_date date;
335: --
336: -- Declare OUT variables
337: --
338: l_effective_start_date pay_run_type_usages_f.effective_start_date%type;
339: l_effective_end_date pay_run_type_usages_f.effective_end_date%type;
340: l_object_version_number pay_run_type_usages_f.object_version_number%type;
341: begin
342: hr_utility.set_location('Entering:'|| l_proc, 5);
335: --
336: -- Declare OUT variables
337: --
338: l_effective_start_date pay_run_type_usages_f.effective_start_date%type;
339: l_effective_end_date pay_run_type_usages_f.effective_end_date%type;
340: l_object_version_number pay_run_type_usages_f.object_version_number%type;
341: begin
342: hr_utility.set_location('Entering:'|| l_proc, 5);
343: --
336: -- Declare OUT variables
337: --
338: l_effective_start_date pay_run_type_usages_f.effective_start_date%type;
339: l_effective_end_date pay_run_type_usages_f.effective_end_date%type;
340: l_object_version_number pay_run_type_usages_f.object_version_number%type;
341: begin
342: hr_utility.set_location('Entering:'|| l_proc, 5);
343: --
344: -- Issue a savepoint