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