DBA Data[Home] [Help]

APPS.PAY_JP_DEF_ARCHIVE dependencies on PAY_BALANCE_PKG

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

200: -- Reset global variable in case of multiple threads.
201: initialization_code(p_payroll_action_id);
202: --
203: for l_asg_rec in csr_asg loop
204: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_effective_date));
205: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_asg_rec.assignment_id));
206: l_organization_id := pay_balance_pkg.run_db_item(c_organization_iv_name, g_business_group_id, g_legislation_code);
207: --
208: if l_organization_id = g_organization_id then

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

201: initialization_code(p_payroll_action_id);
202: --
203: for l_asg_rec in csr_asg loop
204: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_effective_date));
205: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_asg_rec.assignment_id));
206: l_organization_id := pay_balance_pkg.run_db_item(c_organization_iv_name, g_business_group_id, g_legislation_code);
207: --
208: if l_organization_id = g_organization_id then
209: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);

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

202: --
203: for l_asg_rec in csr_asg loop
204: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_effective_date));
205: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_asg_rec.assignment_id));
206: l_organization_id := pay_balance_pkg.run_db_item(c_organization_iv_name, g_business_group_id, g_legislation_code);
207: --
208: if l_organization_id = g_organization_id then
209: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
210: if l_tax_type in ('M_KOU', 'D_KOU') then

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

205: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_asg_rec.assignment_id));
206: l_organization_id := pay_balance_pkg.run_db_item(c_organization_iv_name, g_business_group_id, g_legislation_code);
207: --
208: if l_organization_id = g_organization_id then
209: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
210: if l_tax_type in ('M_KOU', 'D_KOU') then
211: hr_utility.trace('assignment_id : ' || l_asg_rec.assignment_id);
212: --
213: select pay_assignment_actions_s.nextval

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

247: where assignment_action_id = p_assignment_action_id;
248: --
249: -- Derive Tax Type input value
250: --
251: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(p_effective_date));
252: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_assignment_id));
253: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
254: --
255: if l_tax_type not in ('M_KOU', 'D_KOU') then

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

248: --
249: -- Derive Tax Type input value
250: --
251: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(p_effective_date));
252: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_assignment_id));
253: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
254: --
255: if l_tax_type not in ('M_KOU', 'D_KOU') then
256: fnd_message.set_name('PAY', 'PAY_JP_INVALID_TAX_TYPE');

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

249: -- Derive Tax Type input value
250: --
251: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(p_effective_date));
252: pay_balance_pkg.set_context('ASSIGNMENT_ID', fnd_number.number_to_canonical(l_assignment_id));
253: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
254: --
255: if l_tax_type not in ('M_KOU', 'D_KOU') then
256: fnd_message.set_name('PAY', 'PAY_JP_INVALID_TAX_TYPE');
257: fnd_message.raise_error;