[Home] [Help]
1522: hr_utility.set_location(l_proc,30);
1523: hr_utility.trace('start archive_assact');
1524: end if;
1525: --
1526: -- set global argument of pact in pay_jp_isdf_archive_pkg
1527: open csr_pact;
1528: fetch csr_pact into l_payroll_action_id;
1529: close csr_pact;
1530: --
1531: if g_debug then
1532: hr_utility.set_location(l_proc,40);
1533: end if;
1534: --
1535: pay_jp_isdf_archive_pkg.init_pact(
1536: p_payroll_action_id => l_payroll_action_id);
1537: --
1538: -- reset to force archive because of concurrent parameter might be N
1539: pay_jp_isdf_archive_pkg.g_archive_default_flag := 'Y';
1535: pay_jp_isdf_archive_pkg.init_pact(
1536: p_payroll_action_id => l_payroll_action_id);
1537: --
1538: -- reset to force archive because of concurrent parameter might be N
1539: pay_jp_isdf_archive_pkg.g_archive_default_flag := 'Y';
1540: --
1541: if g_debug then
1542: hr_utility.set_location(l_proc,50);
1543: end if;
1541: if g_debug then
1542: hr_utility.set_location(l_proc,50);
1543: end if;
1544: --
1545: -- set global argument of assact in pay_jp_isdf_archive_pkg
1546: pay_jp_isdf_archive_pkg.init_assact(
1547: p_assignment_action_id => l_assact_rec.assignment_action_id,
1548: p_assignment_id => l_assact_rec.assignment_id);
1549: --
1542: hr_utility.set_location(l_proc,50);
1543: end if;
1544: --
1545: -- set global argument of assact in pay_jp_isdf_archive_pkg
1546: pay_jp_isdf_archive_pkg.init_assact(
1547: p_assignment_action_id => l_assact_rec.assignment_action_id,
1548: p_assignment_id => l_assact_rec.assignment_id);
1549: --
1550: if g_debug then
1550: if g_debug then
1551: hr_utility.set_location(l_proc,60);
1552: end if;
1553: --
1554: pay_jp_isdf_archive_pkg.archive_assact(
1555: p_assignment_action_id => l_assact_rec.assignment_action_id,
1556: p_assignment_id => l_assact_rec.assignment_id);
1557: --
1558: if g_debug then
4016: l_is_ee_object_version_number number;
4017: l_is_datetrack_update_mode pay_jp_isdf_entry_v.is_datetrack_update_mode%type;
4018: l_status pay_jp_isdf_entry_v.status%type;
4019: --
4020: l_entry_rec pay_jp_isdf_archive_pkg.t_entry_rec;
4021: --
4022: cursor csr_pact
4023: is
4024: select /* +ORDERED */
4058: close csr_pact;
4059: --
4060: end if;
4061: --
4062: pay_jp_isdf_archive_pkg.fetch_entry(
4063: p_assignment_id => p_rec.assignment_id,
4064: p_business_group_id => g_business_group_id,
4065: p_effective_date => l_effective_date,
4066: p_entry_rec => l_entry_rec);
4146: p_create_warning => l_warning);
4147: --
4148: l_ins_element_entry_id := p_rec.ins_element_entry_id;
4149: l_ins_ee_object_version_number := p_rec.ins_ee_object_version_number;
4150: l_ins_datetrack_update_mode := pay_jp_isdf_archive_pkg.ee_datetrack_update_mode(p_rec.ins_element_entry_id,l_esd,l_eed,l_effective_date);
4151: --
4152: end if;
4153: --
4154: -- even if rec status is 'I', eev might setup by manually at transfer run time.
4214: p_create_warning => l_warning);
4215: --
4216: l_is_element_entry_id := p_rec.is_element_entry_id;
4217: l_is_ee_object_version_number := p_rec.is_ee_object_version_number;
4218: l_is_datetrack_update_mode := pay_jp_isdf_archive_pkg.ee_datetrack_update_mode(p_rec.is_element_entry_id,l_esd,l_eed,l_effective_date);
4219: --
4220: end if;
4221: --
4222: p_rec.object_version_number := p_rec.object_version_number + 1;
4364: p_create_warning => l_warning);
4365: --
4366: l_ins_element_entry_id := p_rec.ins_element_entry_id;
4367: l_ins_ee_object_version_number := p_rec.ins_ee_object_version_number;
4368: l_ins_datetrack_update_mode := pay_jp_isdf_archive_pkg.ee_datetrack_update_mode(p_rec.ins_element_entry_id,l_esd,l_eed,l_effective_date);
4369: --
4370: end if;
4371: --
4372: -- even if rec status is 'Q', eev might removed. specially if archive time is
4442: p_create_warning => l_warning);
4443: --
4444: l_is_element_entry_id := p_rec.is_element_entry_id;
4445: l_is_ee_object_version_number := p_rec.is_ee_object_version_number;
4446: l_is_datetrack_update_mode := pay_jp_isdf_archive_pkg.ee_datetrack_update_mode(p_rec.is_element_entry_id,l_esd,l_eed,l_effective_date);
4447: --
4448: end if;
4449: --
4450: p_rec.object_version_number := p_rec.object_version_number + 1;