[Home] [Help]
359: where defined_balance_id = p_def_bal;
360: --
361: cursor csr_def_bals is
362: select db.defined_balance_id
363: from pay_defined_balances db
364: where db.balance_type_id = p_balance_type_id
365: for update;
366: --
367: begin
383: hr_utility.set_location('balance_type_cascade_delete', 20);
384: --
385: -- Make sure defined balance is not used by an organization payment
386: -- method or a backpay set.
387: pay_defined_balances_pkg.chk_delete_defined_balance
388: (v_db_rec.defined_balance_id);
389: --
390: -- need to delete child rows of pay_defined_balances. User entities are don
391: -- in trigger pay_defined_balances_brd, going to delete for new table
386: -- method or a backpay set.
387: pay_defined_balances_pkg.chk_delete_defined_balance
388: (v_db_rec.defined_balance_id);
389: --
390: -- need to delete child rows of pay_defined_balances. User entities are don
391: -- in trigger pay_defined_balances_brd, going to delete for new table
392: -- pay_balance_attributes here.
393: --
394: hr_utility.set_location('balance_type_cascade_delete',2);
387: pay_defined_balances_pkg.chk_delete_defined_balance
388: (v_db_rec.defined_balance_id);
389: --
390: -- need to delete child rows of pay_defined_balances. User entities are don
391: -- in trigger pay_defined_balances_brd, going to delete for new table
392: -- pay_balance_attributes here.
393: --
394: hr_utility.set_location('balance_type_cascade_delete',2);
395: --
398: (p_balance_attribute_id => each_pba.balance_attribute_id);
399: end loop;
400: --
401: hr_utility.set_location('balance_type_cascade_delete',3);
402: delete from pay_defined_balances
403: where current of csr_def_bals;
404: --
405: end loop;
406: --