DBA Data[Home] [Help]

APPS.PER_PEOPLE12_PKG dependencies on PER_PEOPLE3_PKG

Line 826: --per_people3_pkg.check_future_apl(p_person_id => p_person_id

822: --end if;
823: --
824: -- Ensure there are no future applicant assignments
825: --
826: --per_people3_pkg.check_future_apl(p_person_id => p_person_id
827: -- ,p_hire_date => greatest(p_hire_date
828: --,p_effective_start_date));
829: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',85);
830: --

Line 912: /* per_people3_pkg.check_future_apl(p_person_id => p_person_id

908: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',110);
909: --
910: -- Ensure there are no future applicant assignments
911: --
912: /* per_people3_pkg.check_future_apl(p_person_id => p_person_id
913: ,p_hire_date => greatest(p_hire_date
914: p_effective_start_date));* commented for bug 5403222*/
915: --fix for bug 6600075
916: l_max_ele := p_tab.COUNT;

Line 919: per_people3_pkg.check_future_apl(p_person_id => p_person_id

915: --fix for bug 6600075
916: l_max_ele := p_tab.COUNT;
917:
918: if l_max_ele > 0 then
919: per_people3_pkg.check_future_apl(p_person_id => p_person_id
920: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
921: ,p_table=>p_tab);
922: else
923: per_people3_pkg.check_future_apl(p_person_id => p_person_id

Line 923: per_people3_pkg.check_future_apl(p_person_id => p_person_id

919: per_people3_pkg.check_future_apl(p_person_id => p_person_id
920: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
921: ,p_table=>p_tab);
922: else
923: per_people3_pkg.check_future_apl(p_person_id => p_person_id
924: ,p_hire_date => greatest(p_hire_date,p_effective_start_date));
925: end if;
926:
927: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',115);

Line 1003: /* per_people3_pkg.check_future_apl(p_person_id => p_person_id

999: end if;
1000: --
1001: -- Ensure there are no future applicant assignments
1002: --
1003: /* per_people3_pkg.check_future_apl(p_person_id => p_person_id
1004: ,p_hire_date => greatest(p_hire_date
1005: ,p_effective_start_date));* commented for bug 5403222*/
1006: --fix for bug 6600075
1007: l_max_ele := p_tab.COUNT;

Line 1010: per_people3_pkg.check_future_apl(p_person_id => p_person_id

1006: --fix for bug 6600075
1007: l_max_ele := p_tab.COUNT;
1008:
1009: if l_max_ele > 0 then
1010: per_people3_pkg.check_future_apl(p_person_id => p_person_id
1011: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
1012: ,p_table=>p_tab);
1013: else
1014: per_people3_pkg.check_future_apl(p_person_id => p_person_id

Line 1014: per_people3_pkg.check_future_apl(p_person_id => p_person_id

1010: per_people3_pkg.check_future_apl(p_person_id => p_person_id
1011: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
1012: ,p_table=>p_tab);
1013: else
1014: per_people3_pkg.check_future_apl(p_person_id => p_person_id
1015: ,p_hire_date => greatest(p_hire_date,p_effective_start_date));
1016: end if;
1017:
1018: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',130);

Line 1040: per_people3_pkg.vacancy_chk(p_person_id => p_person_id

1036: -- on return l_vacancy_id starts the cursor at the
1037: -- relevant point.
1038: --
1039: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',140);
1040: per_people3_pkg.vacancy_chk(p_person_id => p_person_id
1041: ,p_fire_warning => l_fire_warning
1042: ,p_vacancy_id => p_vacancy_id
1043: -- **** Start new code for bug 2264569 ****************
1044: ,p_table => p_tab -- #2381925

Line 1061: if (per_people3_pkg.chk_events_exist(p_person_id =>p_person_id

1057: end if; -- End of VACANCY_CHECK
1058: --
1059: if p_status = 'BOOKINGS_EXIST' then
1060: -- VT 09/18/96 #288087, #380280 , #2172590
1061: if (per_people3_pkg.chk_events_exist(p_person_id =>p_person_id
1062: ,p_business_group_id =>p_business_group_id
1063: ,p_hire_date => greatest(p_hire_date,p_session_date))) then
1064: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',165);
1065: return;

Line 1103: -- per_people3_pkg.get_accepted_appls(p_person_id => p_person_id

1099: --
1100: -- Get all the accepted applicants
1101: --
1102: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',190);
1103: -- per_people3_pkg.get_accepted_appls(p_person_id => p_person_id
1104: -- ,p_num_accepted_appls => l_num_accepted_appls
1105: -- ,p_new_primary_id =>p_new_primary_id);
1106: --
1107: -- Get all current applicant assignments.

Line 1110: -- per_people3_pkg.get_all_current_appls(p_person_id => p_person_id

1106: --
1107: -- Get all current applicant assignments.
1108: --
1109: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',195);
1110: -- per_people3_pkg.get_all_current_appls(p_person_id => p_person_id
1111: -- ,p_num_appls => l_num_appls);
1112: --
1113: -- if p_system_person_type = 'EMP_APL' then
1114: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',200);

Line 1618: per_people3_pkg.run_alu_ee(p_alu_mode => 'CHANGE_PQC'

1614: -- code for Change of Personal qualifying conditions.
1615: --
1616: --
1617: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',282);
1618: per_people3_pkg.run_alu_ee(p_alu_mode => 'CHANGE_PQC'
1619: ,p_business_group_id=>p_business_group_id
1620: ,p_person_id =>p_person_id
1621: ,p_old_start =>p_s_hire_date
1622: ,p_start_date => p_last_update_date

Line 1647: per_people3_pkg.update_period(p_person_id =>p_person_id

1643: --
1644: -- Update the period of service for the employee
1645: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',290);
1646: --
1647: per_people3_pkg.update_period(p_person_id =>p_person_id
1648: ,p_hire_date => p_s_hire_date
1649: ,p_new_hire_date =>p_hire_date
1650: ,p_adjusted_svc_date => p_adjusted_svc_date);
1651: --

Line 1733: per_people3_pkg.run_alu_ee(p_alu_mode => 'ASG_CRITERIA'

1729: --
1730: -- Run the assignment_link_usages and Element_entry
1731: -- code for Assignment Criteria.
1732: --
1733: per_people3_pkg.run_alu_ee(p_alu_mode => 'ASG_CRITERIA'
1734: ,p_business_group_id=>p_business_group_id
1735: ,p_person_id =>p_person_id
1736: ,p_old_start =>p_s_hire_date
1737: ,p_start_date => p_hire_date);