60: l_effective_date date;
61: --
62: -- Declare OUT variables
63: --
64: l_balance_category_id pay_balance_categories_f.balance_category_id%TYPE;
65: l_object_version_number pay_balance_categories_f.object_version_number%TYPE;
66: l_effective_start_date pay_balance_categories_f.effective_start_date%TYPE;
67: l_effective_end_date pay_balance_categories_f.effective_end_date%TYPE;
68: --
61: --
62: -- Declare OUT variables
63: --
64: l_balance_category_id pay_balance_categories_f.balance_category_id%TYPE;
65: l_object_version_number pay_balance_categories_f.object_version_number%TYPE;
66: l_effective_start_date pay_balance_categories_f.effective_start_date%TYPE;
67: l_effective_end_date pay_balance_categories_f.effective_end_date%TYPE;
68: --
69: begin
62: -- Declare OUT variables
63: --
64: l_balance_category_id pay_balance_categories_f.balance_category_id%TYPE;
65: l_object_version_number pay_balance_categories_f.object_version_number%TYPE;
66: l_effective_start_date pay_balance_categories_f.effective_start_date%TYPE;
67: l_effective_end_date pay_balance_categories_f.effective_end_date%TYPE;
68: --
69: begin
70: hr_utility.set_location('Entering:'|| l_proc, 10);
63: --
64: l_balance_category_id pay_balance_categories_f.balance_category_id%TYPE;
65: l_object_version_number pay_balance_categories_f.object_version_number%TYPE;
66: l_effective_start_date pay_balance_categories_f.effective_start_date%TYPE;
67: l_effective_end_date pay_balance_categories_f.effective_end_date%TYPE;
68: --
69: begin
70: hr_utility.set_location('Entering:'|| l_proc, 10);
71: --
579: l_effective_date date;
580: --
581: -- Declare OUT variables
582: --
583: l_effective_start_date pay_balance_categories_f.effective_start_date%type;
584: l_effective_end_date pay_balance_categories_f.effective_end_date%type;
585: l_validation_start_date date;
586: l_validation_end_date date;
587: l_object_version_number pay_balance_categories_f.object_version_number%type;
580: --
581: -- Declare OUT variables
582: --
583: l_effective_start_date pay_balance_categories_f.effective_start_date%type;
584: l_effective_end_date pay_balance_categories_f.effective_end_date%type;
585: l_validation_start_date date;
586: l_validation_end_date date;
587: l_object_version_number pay_balance_categories_f.object_version_number%type;
588: begin
583: l_effective_start_date pay_balance_categories_f.effective_start_date%type;
584: l_effective_end_date pay_balance_categories_f.effective_end_date%type;
585: l_validation_start_date date;
586: l_validation_end_date date;
587: l_object_version_number pay_balance_categories_f.object_version_number%type;
588: begin
589: hr_utility.set_location('Entering:'|| l_proc, 5);
590: --
591: -- Issue a savepoint and assign in-out parameters to local variable