DBA Data[Home] [Help]

APPS.PAY_RUN_TYPE_USAGE_API dependencies on PAY_RUN_TYPE_USAGES_F

Line 33: l_run_type_usage_id pay_run_type_usages_f.run_type_usage_id%TYPE;

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

Line 34: l_object_version_number pay_run_type_usages_f.object_version_number%TYPE;

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

Line 35: l_effective_start_date pay_run_type_usages_f.effective_start_date%TYPE;

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

Line 36: l_effective_end_date pay_run_type_usages_f.effective_end_date%TYPE;

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

Line 189: l_effective_start_date pay_run_type_usages_f.effective_start_date%TYPE;

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

Line 190: l_effective_end_date pay_run_type_usages_f.effective_end_date%TYPE;

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;

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

Line 338: l_effective_start_date pay_run_type_usages_f.effective_start_date%type;

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

Line 339: l_effective_end_date pay_run_type_usages_f.effective_end_date%type;

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

Line 340: l_object_version_number pay_run_type_usages_f.object_version_number%type;

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