DBA Data[Home] [Help]

APPS.PAY_JP_DEF_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 217: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_effective_date));

213: -- Reset global variable in case of multiple threads.
214: initialization_code(p_payroll_action_id);
215: --
216: for l_asg_rec in csr_asg loop
217: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_effective_date));
218: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_asg_rec.assignment_id));
219: l_organization_id := pay_balance_pkg.run_db_item(c_organization_iv_name, g_business_group_id, g_legislation_code);
220: --
221: if l_organization_id = g_organization_id then

Line 218: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_asg_rec.assignment_id));

214: initialization_code(p_payroll_action_id);
215: --
216: for l_asg_rec in csr_asg loop
217: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_effective_date));
218: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_asg_rec.assignment_id));
219: l_organization_id := pay_balance_pkg.run_db_item(c_organization_iv_name, g_business_group_id, g_legislation_code);
220: --
221: if l_organization_id = g_organization_id then
222: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);

Line 219: l_organization_id := pay_balance_pkg.run_db_item(c_organization_iv_name, g_business_group_id, g_legislation_code);

215: --
216: for l_asg_rec in csr_asg loop
217: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_effective_date));
218: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_asg_rec.assignment_id));
219: l_organization_id := pay_balance_pkg.run_db_item(c_organization_iv_name, g_business_group_id, g_legislation_code);
220: --
221: if l_organization_id = g_organization_id then
222: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
223: if l_tax_type in ('M_KOU', 'D_KOU') then

Line 222: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);

218: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_asg_rec.assignment_id));
219: l_organization_id := pay_balance_pkg.run_db_item(c_organization_iv_name, g_business_group_id, g_legislation_code);
220: --
221: if l_organization_id = g_organization_id then
222: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
223: if l_tax_type in ('M_KOU', 'D_KOU') then
224: hr_utility.trace('assignment_id : ' || l_asg_rec.assignment_id);
225: --
226: select pay_assignment_actions_s.nextval

Line 265: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(p_effective_date));

261: where assignment_action_id = p_assignment_action_id;
262: --
263: -- Derive Tax Type input value
264: --
265: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(p_effective_date));
266: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_assignment_id));
267: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
268: --
269: if l_tax_type not in ('M_KOU', 'D_KOU') then

Line 266: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_assignment_id));

262: --
263: -- Derive Tax Type input value
264: --
265: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(p_effective_date));
266: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_assignment_id));
267: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
268: --
269: if l_tax_type not in ('M_KOU', 'D_KOU') then
270: fnd_message.set_name('PAY', 'PAY_JP_INVALID_TAX_TYPE');

Line 267: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);

263: -- Derive Tax Type input value
264: --
265: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(p_effective_date));
266: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_assignment_id));
267: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
268: --
269: if l_tax_type not in ('M_KOU', 'D_KOU') then
270: fnd_message.set_name('PAY', 'PAY_JP_INVALID_TAX_TYPE');
271: fnd_message.raise_error;