[Home] [Help]
675: l_proc varchar2(72) := g_package||'insert_validate';
676: l_multiple_occurrences_flag ghr_pa_request_info_types.multiple_occurrences_flag%type;
677: --
678: l_person_id per_people_f.person_id%type;
679: l_position_id per_positions.position_id%type;
680: l_bus_group_id per_people_f.business_group_id%type;
681:
682: -- Bug#5729582 (i)added local variable l_effective_date
683: -- (ii) Modified the cursors c_get_perpos_ids,c_per_bus_group_id,c_pos_bus_group_id
693: from per_people_f ppf
694: where ppf.person_id = p_person_id
695: and l_effective_date between ppf.effective_start_date
696: and ppf.effective_end_date;
697: cursor c_pos_bus_group_id(p_position_id in per_positions.position_id%TYPE ) is
698: select pos.business_group_id
699: from hr_all_positions_f pos -- Venkat -- Position DT
700: where pos.position_id = p_position_id
701: and l_effective_date between pos.effective_start_date
812: */
813: -- Business group Id has to be populated for the server side DDF Validation
814: -- Get the Business Group Id as follows
815: -- Get the person_id/position_id from ghr_pa_requests using pa_request_id
816: -- With person_id/position_id get the business group id form per_peope_f/per_positions
817: -- Set the business group_id using fnd_profile.put
818: -- If there is no person_id or position_id in ghr_pa_requests do not validate using dflex -- ??
819:
820: --Getting Business Group Id
917: --
918: l_proc varchar2(72) := g_package||'update_validate';
919: --
920: l_person_id per_people_f.person_id%type;
921: l_position_id per_positions.position_id%type;
922: l_bus_group_id per_people_f.business_group_id%type;
923:
924: -- Bug#5729582 (i)added local variable l_effective_date
925: -- (ii) Modified the cursors c_get_perpos_ids,c_per_bus_group_id,c_pos_bus_group_id
935: from per_people_f ppf
936: where ppf.person_id = p_person_id
937: and l_effective_date between ppf.effective_start_date
938: and ppf.effective_end_date;
939: cursor c_pos_bus_group_id(p_position_id in per_positions.position_id%TYPE ) is
940: select pos.business_group_id
941: from hr_all_positions_f pos -- Venkat -- Position DT
942: where pos.position_id = p_position_id
943: and l_effective_date between pos.effective_start_date
1042: */
1043: -- Business group Id has to be populated for the server side DDF Validation
1044: -- Get the Business Group Id as follows
1045: -- Get the person_id/position_id from ghr_pa_requests using pa_request_id
1046: -- With person_id/position_id get the business group id form per_peope_f/per_positions
1047: -- Set the business group_id using fnd_profile.put
1048: -- If there is no person_id or position_id in ghr_pa_requests do not validate using dflex -- ??
1049:
1050: --Getting Business Group Id