DBA Data[Home] [Help]

APPS.PER_PEOPLE12_PKG dependencies on HR_EMPLOYEE_APPLICANT_API

Line 213: ,p_tab IN OUT NOCOPY HR_EMPLOYEE_APPLICANT_API.t_ApplTable

209: ,p_npw_number IN OUT NOCOPY VARCHAR2
210: ,p_current_npw_flag VARCHAR2
211: -- Start new code for bug 2264569 ****************************
212: -- added pl/sql table
213: ,p_tab IN OUT NOCOPY HR_EMPLOYEE_APPLICANT_API.t_ApplTable
214: -- End new code for bug 2264569 ******************************
215: ,p_order_name IN VARCHAR2
216: ,p_global_name IN VARCHAR2
217: ,p_local_name IN VARCHAR2

Line 1049: if hr_employee_applicant_api.retain_exists(p_tab) then

1045: -- p_actual_termination_date => p_effective_start_date-1);
1046: --
1047: -- **** START new code for bug 2264569 ******************************************
1048: -- Update the system person type to EMP_APL if user is keeping active APPLS.
1049: if hr_employee_applicant_api.retain_exists(p_tab) then
1050: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',260);
1051: p_system_person_type := 'EMP_APL';
1052: open c_apl_flag(p_system_person_type);
1053: fetch c_apl_flag into p_current_applicant_flag;

Line 1091: if NOT hr_employee_applicant_api.retain_exists(p_tab) then

1087: -- Bug 3637893 Ends
1088: --
1089: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',260);
1090: -- **** Start new code for bug 2264569 **********************************
1091: if NOT hr_employee_applicant_api.retain_exists(p_tab) then
1092: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',262);
1093: -- **** End new code for bug 2264569 **********************************
1094:
1095: -- ER FPT

Line 2210: l_table HR_EMPLOYEE_APPLICANT_API.t_ApplTable;

2206:
2207: ) is
2208: l_sys_per_type varchar2(150);
2209: l_current_apl varchar2(150);
2210: l_table HR_EMPLOYEE_APPLICANT_API.t_ApplTable;
2211: begin
2212: l_sys_per_type := p_system_person_type;
2213: l_current_apl := p_current_applicant_flag;
2214:

Line 2553: ,p_tab IN OUT NOCOPY HR_EMPLOYEE_APPLICANT_API.t_ApplTable

2549: ,p_npw_number IN OUT NOCOPY VARCHAR2
2550: ,p_current_npw_flag VARCHAR2
2551: -- Start new code for bug 2264569 ****************************
2552: -- added pl/sql table
2553: ,p_tab IN OUT NOCOPY HR_EMPLOYEE_APPLICANT_API.t_ApplTable
2554: -- End new code for bug 2264569 ******************************
2555: ,p_order_name IN VARCHAR2
2556: ,p_global_name IN VARCHAR2
2557: ,p_local_name IN VARCHAR2

Line 3527: if hr_employee_applicant_api.retain_exists(p_tab) then

3523: -- p_actual_termination_date => p_effective_start_date-1);
3524: --
3525: -- **** START new code for bug 2264569 ******************************************
3526: -- Update the system person type to EMP_APL if user is keeping active APPLS.
3527: if hr_employee_applicant_api.retain_exists(p_tab) then
3528: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);
3529: p_system_person_type := 'EMP_APL';
3530: open c_apl_flag(p_system_person_type);
3531: fetch c_apl_flag into p_current_applicant_flag;

Line 3570: if NOT hr_employee_applicant_api.retain_exists(p_tab) then

3566: -- Bug 3637893 Ends
3567: --
3568: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',260);
3569: -- **** Start new code for bug 2264569 **********************************
3570: if NOT hr_employee_applicant_api.retain_exists(p_tab) then
3571: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',262);
3572: -- **** End new code for bug 2264569 **********************************
3573: hr_per_type_usage_internal.maintain_person_type_usage
3574: (p_effective_date => p_effective_start_date