867: */
868: -- End of 3335915
869: ---------------------------------------------------------
870: -- Payroll Object Group functionality - requires call to
871: -- pay_pog_all_assignments_pkg. This is designed to be called from a row
872: -- handler user hook, hence has many parameters that are not available here.
873: -- So a cursor is used to return the values, to pass to the pog procedure.
874: --
875: cur_asg_rec per_asg_shd.g_rec_type;
1541: --
1542: p_future_spp_warning := l_future_spp_warnings;
1543: --
1544: -- Payroll Object Group functionality, requires call to
1545: -- pay_pog_all_assignments_pkg. This is designed to be called from a row
1546: -- handler user hook, hence has many parameters that are not available here.
1547: -- So a cursor is used to return the current assignment values, to pass to
1548: -- the pog procedure. The 'old' values were stored in a global record, as
1549: -- part of the pre_update_bundle procedure, ready for use here.
1561: --
1562:
1563: hr_utility.set_location(l_proc,357);
1564:
1565: pay_pog_all_assignments_pkg.after_update
1566: (p_effective_date => p_sess_date
1567: ,p_datetrack_mode => p_upd_mode
1568: ,p_validation_start_date => p_val_st_date
1569: ,p_validation_end_date => p_val_end_date
2175: --
2176: end if;
2177: --
2178: -- Payroll Object Group functionality, requires call to
2179: -- pay_pog_all_assignments_pkg. This is designed to be called from a row
2180: -- handler user hook, hence has many parameters that are not available here.
2181: -- So a cursor is used to return the values, to pass to the pog procedure.
2182: --
2183: IF g_debug THEN
2208: IF g_debug THEN
2209: hr_utility.set_location( g_package || l_proc, 80);
2210: END IF;
2211:
2212: pay_pog_all_assignments_pkg.after_insert
2213: (p_effective_date => p_sess_date
2214: ,p_validation_start_date => l_vsd
2215: ,p_validation_end_date => l_ved
2216: ,P_APPLICANT_RANK => ins_asg_rec.applicant_rank
2364: --
2365: l_proc VARCHAR2(72) := g_package||'post_delete';
2366: --
2367: -- Payroll Object Group functionality. Not all the values required for call
2368: -- to pay_pog_all_assignments_pkg are available, so cursor is used to get the
2369: -- values.
2370: --
2371: cursor cur_asg_details(p_asg_id number
2372: ,p_eff_date date)
2573: p_future_spp_warning := l_future_spp_warnings;
2574: --
2575: --
2576: -- Payroll Object Group functionality, requires call to
2577: -- pay_pog_all_assignments_pkg. This is designed to be called from a row
2578: -- handler user hook, hence has many parameters that are not available here.
2579: -- So a cursor is used to return those values that are not available to this
2580: -- procedure. The 'old' values have been selected into a record in the
2581: -- pre_delete procedure
2601: --
2602: -- call temporary POG package
2603: --
2604: hr_utility.set_location(l_proc,100);
2605: pay_pog_all_assignments_pkg.after_delete
2606: (p_effective_date => p_sess_date
2607: ,p_datetrack_mode => p_del_mode
2608: ,p_validation_start_date => p_val_st_date
2609: ,p_validation_end_date => p_val_end_date