[Home] [Help]
939: */
940: -- End of 3335915
941: ---------------------------------------------------------
942: -- Payroll Object Group functionality - requires call to
943: -- pay_pog_all_assignments_pkg. This is designed to be called from a row
944: -- handler user hook, hence has many parameters that are not available here.
945: -- So a cursor is used to return the values, to pass to the pog procedure.
946: --
947: cur_asg_rec per_asg_shd.g_rec_type;
1632: --
1633: p_future_spp_warning := l_future_spp_warnings;
1634: --
1635: -- Payroll Object Group functionality, requires call to
1636: -- pay_pog_all_assignments_pkg. This is designed to be called from a row
1637: -- handler user hook, hence has many parameters that are not available here.
1638: -- So a cursor is used to return the current assignment values, to pass to
1639: -- the pog procedure. The 'old' values were stored in a global record, as
1640: -- part of the pre_update_bundle procedure, ready for use here.
1652: --
1653:
1654: hr_utility.set_location(l_proc,357);
1655:
1656: pay_pog_all_assignments_pkg.after_update
1657: (p_effective_date => p_sess_date
1658: ,p_datetrack_mode => p_upd_mode
1659: ,p_validation_start_date => p_val_st_date
1660: ,p_validation_end_date => p_val_end_date
2272: --
2273: end if;
2274: --
2275: -- Payroll Object Group functionality, requires call to
2276: -- pay_pog_all_assignments_pkg. This is designed to be called from a row
2277: -- handler user hook, hence has many parameters that are not available here.
2278: -- So a cursor is used to return the values, to pass to the pog procedure.
2279: --
2280: IF g_debug THEN
2305: IF g_debug THEN
2306: hr_utility.set_location( g_package || l_proc, 80);
2307: END IF;
2308:
2309: pay_pog_all_assignments_pkg.after_insert
2310: (p_effective_date => p_sess_date
2311: ,p_validation_start_date => l_vsd
2312: ,p_validation_end_date => l_ved
2313: ,P_APPLICANT_RANK => ins_asg_rec.applicant_rank
2461: --
2462: l_proc VARCHAR2(72) := g_package||'post_delete';
2463: --
2464: -- Payroll Object Group functionality. Not all the values required for call
2465: -- to pay_pog_all_assignments_pkg are available, so cursor is used to get the
2466: -- values.
2467: --
2468: cursor cur_asg_details(p_asg_id number
2469: ,p_eff_date date)
2679: p_future_spp_warning := l_future_spp_warnings;
2680: --
2681: --
2682: -- Payroll Object Group functionality, requires call to
2683: -- pay_pog_all_assignments_pkg. This is designed to be called from a row
2684: -- handler user hook, hence has many parameters that are not available here.
2685: -- So a cursor is used to return those values that are not available to this
2686: -- procedure. The 'old' values have been selected into a record in the
2687: -- pre_delete procedure
2707: --
2708: -- call temporary POG package
2709: --
2710: hr_utility.set_location(l_proc,100);
2711: pay_pog_all_assignments_pkg.after_delete
2712: (p_effective_date => p_sess_date
2713: ,p_datetrack_mode => p_del_mode
2714: ,p_validation_start_date => p_val_st_date
2715: ,p_validation_end_date => p_val_end_date