DBA Data[Home] [Help]

APPS.PAY_US_GROSSUP_UPD dependencies on HR_UTILITY

Line 23: hr_utility.trace('Updated defined balance id : '||l_defbal_id);

19: update pay_defined_balances
20: set grossup_allowed_flag = 'Y'
21: where defined_balance_id = l_defbal_id;
22:
23: hr_utility.trace('Updated defined balance id : '||l_defbal_id);
24: --
25: EXCEPTION
26: when no_data_found then
27: --

Line 42: hr_utility.trace('Inserted balance_type_id : '||p_baltype_id);

38: p_baldim_id,
39: 'US',
40: 'N',
41: 'Y');
42: hr_utility.trace('Inserted balance_type_id : '||p_baltype_id);
43: hr_utility.trace('Inserted balance_dim_id : '||p_baldim_id);
44:
45: END;
46: --

Line 43: hr_utility.trace('Inserted balance_dim_id : '||p_baldim_id);

39: 'US',
40: 'N',
41: 'Y');
42: hr_utility.trace('Inserted balance_type_id : '||p_baltype_id);
43: hr_utility.trace('Inserted balance_dim_id : '||p_baldim_id);
44:
45: END;
46: --
47: END setup_grossup_bal;

Line 86: --hr_utility.trace('Deleted context value '||latebal_rec.latest_balance_id);

82:
83: delete from pay_balance_context_values
84: where latest_balance_id = latebal_rec.latest_balance_id;
85:
86: --hr_utility.trace('Deleted context value '||latebal_rec.latest_balance_id);
87:
88: --
89: delete from pay_assignment_latest_balances
90: where latest_balance_id = latebal_rec.latest_balance_id;

Line 92: --hr_utility.trace('Deleted asg late bal '||latebal_rec.latest_balance_id);

88: --
89: delete from pay_assignment_latest_balances
90: where latest_balance_id = latebal_rec.latest_balance_id;
91:
92: --hr_utility.trace('Deleted asg late bal '||latebal_rec.latest_balance_id);
93:
94: if l_count = 100 then
95: l_count := 0;
96: commit;