APPS.PQH_FR_EMP_STAT_SITUATION_API dependencies on PQH_FR_EMP_STAT_SITUATION_API

Line 1: PACKAGE BODY PQH_FR_EMP_STAT_SITUATION_API as

1: PACKAGE BODY PQH_FR_EMP_STAT_SITUATION_API as
2: /* $Header: pqpsuapi.pkb 120.0 2005/05/29 02:19:33 appldev noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' PQH_FR_EMP_STAT_SITUATION_API.';

2: /* $Header: pqpsuapi.pkb 120.0 2005/05/29 02:19:33 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PQH_FR_EMP_STAT_SITUATION_API.';
7: --
8: --
9: --
10: PROCEDURE update_assignments(p_person_id IN NUMBER

Line 742: pqh_fr_emp_stat_situation_api.update_emp_stat_situation(p_emp_stat_situation_id => p_emp_stat_situation_id

738: hr_multi_message.add(p_associated_column1=> 'P_DURATION_UNITS');
739: END IF;
740: l_upd_sit_ovn := lr_currec.object_version_number;
741: --Extend the civil servant situation by the said duration and create a new renewal situation record
742: pqh_fr_emp_stat_situation_api.update_emp_stat_situation(p_emp_stat_situation_id => p_emp_stat_situation_id
743: ,p_effective_date => lr_currec.provisional_end_date
744: ,p_object_version_number => l_upd_sit_ovn
745: ,p_provisional_end_date => l_new_prov_end_date);
746: pqh_fr_emp_stat_situation_api.create_emp_stat_situation( p_effective_date => trunc(lr_currec.provisional_end_date+1)

Line 746: pqh_fr_emp_stat_situation_api.create_emp_stat_situation( p_effective_date => trunc(lr_currec.provisional_end_date+1)

742: pqh_fr_emp_stat_situation_api.update_emp_stat_situation(p_emp_stat_situation_id => p_emp_stat_situation_id
743: ,p_effective_date => lr_currec.provisional_end_date
744: ,p_object_version_number => l_upd_sit_ovn
745: ,p_provisional_end_date => l_new_prov_end_date);
746: pqh_fr_emp_stat_situation_api.create_emp_stat_situation( p_effective_date => trunc(lr_currec.provisional_end_date+1)
747: ,p_emp_stat_situation_id => l_new_sit_id
748: ,p_statutory_situation_id => lr_currec.statutory_situation_id
749: ,p_person_id => lr_currec.person_id
750: ,p_provisional_start_date => trunc(lr_currec.provisional_end_date+1)

Line 820: pqh_fr_emp_stat_situation_api.update_emp_stat_situation(p_emp_stat_situation_id => p_emp_stat_situation_id

816: END IF;
817: CLOSE csr_current_situation_dtls;
818: l_upd_sit_ovn := lr_currec.object_version_number;
819: --End Date the current situation and create a new situation with default situation for the employee.
820: pqh_fr_emp_stat_situation_api.update_emp_stat_situation(p_emp_stat_situation_id => p_emp_stat_situation_id
821: ,p_effective_date => trunc(p_reinstate_date)-1
822: ,p_object_version_number => l_upd_sit_ovn
823: ,p_actual_end_date => trunc(p_reinstate_date)-1);
824: OPEN csr_prov_end_date(p_emp_stat_situation_id,p_person_id,p_reinstate_date);

Line 827: pqh_fr_emp_stat_situation_api.create_emp_stat_situation( p_effective_date => trunc(p_reinstate_date)

823: ,p_actual_end_date => trunc(p_reinstate_date)-1);
824: OPEN csr_prov_end_date(p_emp_stat_situation_id,p_person_id,p_reinstate_date);
825: FETCH csr_prov_end_date INTO l_next_sit_end_dt;
826: CLOSE csr_prov_end_date;
827: pqh_fr_emp_stat_situation_api.create_emp_stat_situation( p_effective_date => trunc(p_reinstate_date)
828: ,p_emp_stat_situation_id => l_new_sit_id
829: ,p_statutory_situation_id => l_reinstate_sit_id
830: ,p_person_id => lr_currec.person_id
831: ,p_provisional_start_date => trunc(p_reinstate_date)

Line 855: end PQH_FR_EMP_STAT_SITUATION_API;

851: hr_utility.set_location(' Leaving:'||l_proc, 42);
852: fnd_message.raise_error;
853: END REINSTATE_EMP_STAT_SITUATION;
854: --
855: end PQH_FR_EMP_STAT_SITUATION_API;