APPS.HRHIRAPL dependencies on HR_EMPLOYEE_APPLICANT_API

Line 23: ,p_table IN HR_EMPLOYEE_APPLICANT_API.t_ApplTable

19: ,p_emp_apl VARCHAR2
20: ,p_adjusted_svc_date IN DATE
21: ,p_session_date IN DATE -- Bug 3564129
22: -- #2264569
23: ,p_table IN HR_EMPLOYEE_APPLICANT_API.t_ApplTable
24: ) IS
25: /*
26: NAME
27: employ_applicant

Line 736: if not hr_employee_applicant_api.retain_exists(p_table)

732: -- +-----------------------------------------------------------------------+
733: -- +------------------------ End Application -----------------------------+
734: -- +-----------------------------------------------------------------------+
735: -- Does the Retain value exist in the table ?
736: if not hr_employee_applicant_api.retain_exists(p_table)
737: then
738: -- we are "double-checking" that previous updates were successfull
739: -- that is why where clause checks for accepted and unaccepted, despite
740: -- the fact the table does not have stored a retain value .

Line 813: if hr_employee_applicant_api.is_convert(p_table

809: p_assignment_id := l_asg_rec.assignment_id;
810: --
811: --
812: -- Ensure (R)etain or (E)nd date flags have not been set
813: if hr_employee_applicant_api.is_convert(p_table
814: ,l_asg_rec.assignment_id)
815: then
816: hr_utility.set_location('hrhirapl.make_secondary',333);
817: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));

Line 1415: elsif hr_employee_applicant_api.end_date_exists(p_table

1411: -- +--------------------------------------------------+
1412: --
1413: -- Did user explicity choose END Date ?
1414: l_chk_assg_end_dated :='N'; -- bug 6310975
1415: elsif hr_employee_applicant_api.end_date_exists(p_table
1416: ,l_asg_rec.assignment_id) = 1
1417: then
1418: -- +--------------------------------------------------+
1419: -- +--- End Date assignment --------------------------+

Line 1560: if hr_employee_applicant_api.is_convert(p_table

1556: p_assignment_id := l_asg_rec.assignment_id;
1557: --
1558: --
1559: -- Ensure (R)etain or (E)nd date flags have not been set
1560: if hr_employee_applicant_api.is_convert(p_table
1561: ,l_asg_rec.assignment_id)
1562: then
1563: hr_utility.set_location('hrhirapl.make_secondary',401);
1564: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));

Line 2032: elsif hr_employee_applicant_api.end_date_exists(p_table

2028: -- +--- END Convert assignment into secondary --------+
2029: -- +--------------------------------------------------+
2030: --
2031: -- Did user explicity choose END Date ?
2032: elsif hr_employee_applicant_api.end_date_exists(p_table
2033: ,l_asg_rec.assignment_id) = 1
2034: then
2035: -- +--------------------------------------------------+
2036: -- +--- End Date assignment --------------------------+

Line 2099: if hr_employee_applicant_api.is_convert(p_table

2095: p_assignment_id := l_asg_rec.assignment_id;
2096: --
2097: --
2098: -- Ensure (R)etain or (E)nd date flags have not been set
2099: if hr_employee_applicant_api.is_convert(p_table
2100: ,l_asg_rec.assignment_id)
2101: then
2102: hr_utility.set_location('hrhirapl.make_secondary',404);
2103: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));

Line 2569: elsif hr_employee_applicant_api.end_date_exists(p_table

2565: -- +--- END Convert assignment into secondary --------+
2566: -- +--------------------------------------------------+
2567: --
2568: -- Did user explicity choose END Date ?
2569: elsif hr_employee_applicant_api.end_date_exists(p_table
2570: ,l_asg_rec.assignment_id) = 1
2571: then
2572: -- +--------------------------------------------------+
2573: -- +--- End Date assignment --------------------------+

Line 4939: ,p_table IN HR_EMPLOYEE_APPLICANT_API.t_ApplTable

4935: ,p_business_group_id IN INTEGER
4936: ,p_legislation_code IN VARCHAR2
4937: ,p_end_date IN DATE
4938: -- #2264569
4939: ,p_table IN HR_EMPLOYEE_APPLICANT_API.t_ApplTable
4940: ) IS
4941:
4942: /*
4943: NAME

Line 5004: if hr_employee_applicant_api.end_date_exists(p_table,l_asgid) <> 2 then

5000: loop
5001: fetch unacc_cur into l_asgid;
5002: exit when unacc_cur%NOTFOUND;
5003: begin
5004: if hr_employee_applicant_api.end_date_exists(p_table,l_asgid) <> 2 then
5005: hr_utility.set_location('hrhirapl.end_unaccepted_app_assign',305);
5006: hr_utility.trace(' **** Asg ID : '||to_char(l_asgid));
5007:
5008: update per_assignments pa