eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PER_PEOPLE12_PKG dependencies on PER_PEOPLE3_PKG

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

609: --end if;
610: --
611: -- Ensure there are no future applicant assignments
612: --
613: --per_people3_pkg.check_future_apl(p_person_id => p_person_id
614: -- ,p_hire_date => greatest(p_hire_date
615: --,p_effective_start_date));
616: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',85);
617: --

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

694: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',110);
695: --
696: -- Ensure there are no future applicant assignments
697: --
698: /* per_people3_pkg.check_future_apl(p_person_id => p_person_id
699: ,p_hire_date => greatest(p_hire_date
700: p_effective_start_date));* commented for bug 5403222*/
701: --fix for bug 6600075
702: l_max_ele := p_tab.COUNT;

Line 705: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id

701: --fix for bug 6600075
702: l_max_ele := p_tab.COUNT;
703: -- ER FPT
704: if l_max_ele > 0 then
705: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id
706: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
707: ,p_table=>p_tab);
708: else
709: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id

Line 709: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id

705: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id
706: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
707: ,p_table=>p_tab);
708: else
709: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id
710: ,p_hire_date => greatest(p_hire_date,p_effective_start_date));
711: end if;
712:
713: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',115);

Line 797: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id

793: if l_max_ele > 0 then
794: -- there should not be any future 'E' asgs
795: -- there should not be any updates to the asgt on which it's hired >= hire date
796: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',127);
797: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id
798: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
799: ,p_table=>p_tab);
800:
801: else

Line 805: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id

801: else
802: -- there should not be any future 'E' (employee) asgs
803: -- there should not be any updates to the asgt on which it's hired or the appln chosen to End >= hire date
804: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',128);
805: per_people3_pkg.fpt_check_future_apl(p_person_id => p_person_id
806: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
807: ,p_assignment_id => p_new_primary_id);
808: end if;
809:

Line 832: per_people3_pkg.vacancy_chk(p_person_id => p_person_id

828: -- on return l_vacancy_id starts the cursor at the
829: -- relevant point.
830: --
831: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',140);
832: per_people3_pkg.vacancy_chk(p_person_id => p_person_id
833: ,p_fire_warning => l_fire_warning
834: ,p_vacancy_id => p_vacancy_id
835: -- **** Start new code for bug 2264569 ****************
836: ,p_table => p_tab -- #2381925

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

849: end if; -- End of VACANCY_CHECK
850: --
851: if p_status = 'BOOKINGS_EXIST' then
852: -- VT 09/18/96 #288087, #380280 , #2172590
853: if (per_people3_pkg.chk_events_exist(p_person_id =>p_person_id
854: ,p_business_group_id =>p_business_group_id
855: ,p_hire_date => greatest(p_hire_date,p_session_date))) then
856: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',165);
857: return;

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

1891: -- code for Change of Personal qualifying conditions.
1892: --
1893: --
1894: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',282);
1895: per_people3_pkg.run_alu_ee(p_alu_mode => 'CHANGE_PQC'
1896: ,p_business_group_id=>p_business_group_id
1897: ,p_person_id =>p_person_id
1898: ,p_old_start =>p_s_hire_date
1899: ,p_start_date => p_last_update_date

Line 1924: per_people3_pkg.update_period(p_person_id =>p_person_id

1920: --
1921: -- Update the period of service for the employee
1922: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',290);
1923: --
1924: per_people3_pkg.update_period(p_person_id =>p_person_id
1925: ,p_hire_date => p_s_hire_date
1926: ,p_new_hire_date =>p_hire_date
1927: ,p_adjusted_svc_date => p_adjusted_svc_date);
1928: --

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

2006: --
2007: -- Run the assignment_link_usages and Element_entry
2008: -- code for Assignment Criteria.
2009: --
2010: per_people3_pkg.run_alu_ee(p_alu_mode => 'ASG_CRITERIA'
2011: ,p_business_group_id=>p_business_group_id
2012: ,p_person_id =>p_person_id
2013: ,p_old_start =>p_s_hire_date
2014: ,p_start_date => p_hire_date);

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

3083: --end if;
3084: --
3085: -- Ensure there are no future applicant assignments
3086: --
3087: --per_people3_pkg.check_future_apl(p_person_id => p_person_id
3088: -- ,p_hire_date => greatest(p_hire_date
3089: --,p_effective_start_date));
3090: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',85);
3091: --

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

3169: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',110);
3170: --
3171: -- Ensure there are no future applicant assignments
3172: --
3173: /* per_people3_pkg.check_future_apl(p_person_id => p_person_id
3174: ,p_hire_date => greatest(p_hire_date
3175: p_effective_start_date));* commented for bug 5403222*/
3176: --fix for bug 6600075
3177: l_max_ele := p_tab.COUNT;

Line 3180: per_people3_pkg.check_future_apl(p_person_id => p_person_id

3176: --fix for bug 6600075
3177: l_max_ele := p_tab.COUNT;
3178:
3179: if l_max_ele > 0 then
3180: per_people3_pkg.check_future_apl(p_person_id => p_person_id
3181: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
3182: ,p_table=>p_tab);
3183: else
3184: per_people3_pkg.check_future_apl(p_person_id => p_person_id

Line 3184: per_people3_pkg.check_future_apl(p_person_id => p_person_id

3180: per_people3_pkg.check_future_apl(p_person_id => p_person_id
3181: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
3182: ,p_table=>p_tab);
3183: else
3184: per_people3_pkg.check_future_apl(p_person_id => p_person_id
3185: ,p_hire_date => greatest(p_hire_date,p_effective_start_date));
3186: end if;
3187:
3188: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',115);

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

3260: end if;
3261: --
3262: -- Ensure there are no future applicant assignments
3263: --
3264: /* per_people3_pkg.check_future_apl(p_person_id => p_person_id
3265: ,p_hire_date => greatest(p_hire_date
3266: ,p_effective_start_date));* commented for bug 5403222*/
3267: --fix for bug 6600075
3268: l_max_ele := p_tab.COUNT;

Line 3271: per_people3_pkg.check_future_apl(p_person_id => p_person_id

3267: --fix for bug 6600075
3268: l_max_ele := p_tab.COUNT;
3269:
3270: if l_max_ele > 0 then
3271: per_people3_pkg.check_future_apl(p_person_id => p_person_id
3272: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
3273: ,p_table=>p_tab);
3274: else
3275: per_people3_pkg.check_future_apl(p_person_id => p_person_id

Line 3275: per_people3_pkg.check_future_apl(p_person_id => p_person_id

3271: per_people3_pkg.check_future_apl(p_person_id => p_person_id
3272: ,p_hire_date => greatest(p_hire_date,p_effective_start_date)
3273: ,p_table=>p_tab);
3274: else
3275: per_people3_pkg.check_future_apl(p_person_id => p_person_id
3276: ,p_hire_date => greatest(p_hire_date,p_effective_start_date));
3277: end if;
3278:
3279: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',130);

Line 3301: per_people3_pkg.vacancy_chk(p_person_id => p_person_id

3297: -- on return l_vacancy_id starts the cursor at the
3298: -- relevant point.
3299: --
3300: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',140);
3301: per_people3_pkg.vacancy_chk(p_person_id => p_person_id
3302: ,p_fire_warning => l_fire_warning
3303: ,p_vacancy_id => p_vacancy_id
3304: -- **** Start new code for bug 2264569 ****************
3305: ,p_table => p_tab -- #2381925

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

3318: end if; -- End of VACANCY_CHECK
3319: --
3320: if p_status = 'BOOKINGS_EXIST' then
3321: -- VT 09/18/96 #288087, #380280 , #2172590
3322: if (per_people3_pkg.chk_events_exist(p_person_id =>p_person_id
3323: ,p_business_group_id =>p_business_group_id
3324: ,p_hire_date => greatest(p_hire_date,p_session_date))) then
3325: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',165);
3326: return;

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

3360: --
3361: -- Get all the accepted applicants
3362: --
3363: --hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',190);
3364: -- per_people3_pkg.get_accepted_appls(p_person_id => p_person_id
3365: -- ,p_num_accepted_appls => l_num_accepted_appls
3366: -- ,p_new_primary_id =>p_new_primary_id);
3367: --
3368: -- Get all current applicant assignments.

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

3367: --
3368: -- Get all current applicant assignments.
3369: --
3370: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',195);
3371: -- per_people3_pkg.get_all_current_appls(p_person_id => p_person_id
3372: -- ,p_num_appls => l_num_appls);
3373: --
3374: -- if p_system_person_type = 'EMP_APL' then
3375: -- hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',200);

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

3896: -- code for Change of Personal qualifying conditions.
3897: --
3898: --
3899: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',282);
3900: per_people3_pkg.run_alu_ee(p_alu_mode => 'CHANGE_PQC'
3901: ,p_business_group_id=>p_business_group_id
3902: ,p_person_id =>p_person_id
3903: ,p_old_start =>p_s_hire_date
3904: ,p_start_date => p_last_update_date

Line 3929: per_people3_pkg.update_period(p_person_id =>p_person_id

3925: --
3926: -- Update the period of service for the employee
3927: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',290);
3928: --
3929: per_people3_pkg.update_period(p_person_id =>p_person_id
3930: ,p_hire_date => p_s_hire_date
3931: ,p_new_hire_date =>p_hire_date
3932: ,p_adjusted_svc_date => p_adjusted_svc_date);
3933: --

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

4011: --
4012: -- Run the assignment_link_usages and Element_entry
4013: -- code for Assignment Criteria.
4014: --
4015: per_people3_pkg.run_alu_ee(p_alu_mode => 'ASG_CRITERIA'
4016: ,p_business_group_id=>p_business_group_id
4017: ,p_person_id =>p_person_id
4018: ,p_old_start =>p_s_hire_date
4019: ,p_start_date => p_hire_date);