[Home] [Help]
145: -----------------------------------------------------------------------------
146: -- function set_save_run_bals_flag
147: -- Description - sets the value of save_run_balance on pay_defined_balances,
148: -- the value is determined by the values of save_run_balance_enabled on
149: -- pay_balance_categories_f and pay_balance_dimensions.
150: -----------------------------------------------------------------------------
151: function set_save_run_bals_flag(p_balance_category_id number
152: ,p_effective_date date
153: ,p_balance_dimension_id number)
157: cursor get_cat_flag(p_cat_id number
158: ,p_eff_date date)
159: is
160: select pbc.save_run_balance_enabled
161: from pay_balance_categories_f pbc
162: where pbc.balance_category_id = (p_cat_id)
163: and p_eff_date between pbc.effective_start_date
164: and pbc.effective_end_date;
165: --
169: from pay_balance_dimensions dim
170: where dim.balance_dimension_id = p_dim_id
171: and dim.dimension_type = 'R';
172: --
173: l_cat_flag pay_balance_categories_f.save_run_balance_enabled%type;
174: l_dim_flag pay_balance_dimensions.save_run_balance_enabled%type;
175: l_save_run_bal_flag pay_defined_balances.save_run_balance%type;
176: --
177: BEGIN
302: is
303: select pbd.attribute_id
304: , pbd.bal_attribute_default_id
305: from pay_bal_attribute_defaults pbd
306: , pay_balance_categories_f pbc
307: , pay_bal_attribute_definitions bad
308: where bad.attribute_id = pbd.attribute_id
309: and ((ctl_business_group_id is not null
310: and bad.alterable = 'Y')
417: where session_id = userenv('sessionid');
418: --
419: l_exists number ;
420: l_save_run_bal_flag pay_defined_balances.save_run_balance%type;
421: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
422: l_eff_date date;
423: --
424: BEGIN
425: hr_utility.set_location('Entering pay_defined_balances_pkg.insert_row', 5);