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.

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_ASSIGNMENTS_F

Line 25: FROM per_assignments_f asg

21: )
22: IS
23: SELECT asg.assignment_id
24: ,asg.object_version_number
25: FROM per_assignments_f asg
26: WHERE asg.person_id = csr_future_asgs.p_person_id
27: AND asg.effective_start_date > csr_future_asgs.p_effective_date
28: AND (p_assignment_id is null OR
29: (p_assignment_id is not null AND

Line 39: FROM per_assignments_f asg

35: )
36: IS
37: SELECT asg.assignment_id
38: ,asg.object_version_number
39: FROM per_assignments_f asg
40: ,per_assignment_status_types ast
41: WHERE asg.assignment_status_type_id = ast.assignment_status_type_id
42: AND asg.person_id = csr_nonaccepted_asgs.p_person_id
43: AND csr_nonaccepted_asgs.p_effective_date BETWEEN asg.effective_start_date

Line 57: FROM per_assignments_f asg

53: IS
54: SELECT asg.assignment_id
55: ,asg.object_version_number
56: ,asg.vacancy_id
57: FROM per_assignments_f asg
58: ,per_assignment_status_types ast
59: WHERE asg.assignment_status_type_id = ast.assignment_status_type_id
60: AND asg.person_id = csr_accepted_asgs.p_person_id
61: AND ( asg.assignment_id = csr_accepted_asgs.p_assignment_id

Line 75: FROM per_assignments_f asg

71: )
72: IS
73: SELECT asg.assignment_id
74: ,asg.object_version_number
75: FROM per_assignments_f asg
76: ,per_assignment_status_types ast
77: WHERE asg.assignment_status_type_id = ast.assignment_status_type_id
78: AND asg.person_id = csr_primary_asgs.p_person_id
79: AND csr_primary_asgs.p_effective_date BETWEEN asg.effective_start_date

Line 1515: l_assignment_id per_assignments_f.assignment_id%TYPE;

1511: --
1512: l_hire_date date;
1513: --
1514: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1515: l_assignment_id per_assignments_f.assignment_id%TYPE;
1516: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1517: --
1518: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1519: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;

Line 1516: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;

1512: l_hire_date date;
1513: --
1514: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1515: l_assignment_id per_assignments_f.assignment_id%TYPE;
1516: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1517: --
1518: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1519: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1520: l_employee_number per_all_people_f.employee_number%TYPE;

Line 1525: l_comment_id per_assignments_f.comment_id%TYPE;

1521: l_applicant_number per_all_people_f.applicant_number%TYPE;
1522: l_npw_number per_all_people_f.npw_number%TYPE;
1523: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1524: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1525: l_comment_id per_assignments_f.comment_id%TYPE;
1526: l_current_applicant_flag varchar2(1);
1527: l_current_emp_or_apl_flag varchar2(1);
1528: l_current_employee_flag varchar2(1);
1529: l_full_name per_all_people_f.full_name%TYPE;

Line 1540: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

1536: --
1537: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1538: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1539: --
1540: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1541: --
1542: l_primary_flag per_assignments_f.primary_flag%TYPE;
1543: --
1544: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 1542: l_primary_flag per_assignments_f.primary_flag%TYPE;

1538: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1539: --
1540: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1541: --
1542: l_primary_flag per_assignments_f.primary_flag%TYPE;
1543: --
1544: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1545: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1546: l_validation_start_date date;

Line 1544: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

1540: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1541: --
1542: l_primary_flag per_assignments_f.primary_flag%TYPE;
1543: --
1544: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1545: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1546: l_validation_start_date date;
1547: l_validation_end_date date;
1548: l_payroll_id_updated boolean;

Line 1545: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

1541: --
1542: l_primary_flag per_assignments_f.primary_flag%TYPE;
1543: --
1544: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1545: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1546: l_validation_start_date date;
1547: l_validation_end_date date;
1548: l_payroll_id_updated boolean;
1549: l_other_manager_warning boolean;

Line 1572: from per_assignments_f asg

1568: --
1569: --
1570: cursor csr_future_asg_changes is
1571: select 'x'
1572: from per_assignments_f asg
1573: where asg.person_id = p_person_id
1574: and asg.effective_start_date > p_hire_date;
1575: --
1576: cursor csr_get_devived_details is

Line 1600: from per_assignments_f asg,

1596: and nvl(pap.date_end,hr_api.g_eot);
1597: --
1598: cursor csr_chk_asg_status is
1599: select count(asg.assignment_id)
1600: from per_assignments_f asg,
1601: per_assignment_status_types pas
1602: where asg.assignment_status_type_id = pas.assignment_status_type_id
1603: and asg.person_id = p_person_id
1604: and pas.per_system_status = 'ACCEPTED'

Line 1612: per_assignments_f asg,

1608: cursor csr_chk_assignment_id is
1609: select per.person_id,
1610: pas.per_system_status
1611: from per_all_people_f per,
1612: per_assignments_f asg,
1613: per_assignment_status_types pas
1614: where asg.assignment_status_type_id = pas.assignment_status_type_id
1615: and per.person_id = asg.person_id
1616: and l_hire_date between per.effective_start_date

Line 1625: from per_assignments_f asg,

1621: --
1622: cursor csr_get_un_accepted is
1623: select asg.assignment_id,
1624: asg.object_version_number
1625: from per_assignments_f asg,
1626: per_assignment_status_types pas
1627: where asg.assignment_status_type_id = pas.assignment_status_type_id
1628: and asg.person_id = p_person_id
1629: and asg.assignment_type='A'

Line 1641: from per_assignments_f asg,

1637: select asg.assignment_id,
1638: asg.object_version_number,
1639: asg.effective_start_date,
1640: asg.vacancy_id
1641: from per_assignments_f asg,
1642: per_assignment_status_types pas
1643: where asg.assignment_status_type_id = pas.assignment_status_type_id
1644: and asg.person_id = p_person_id
1645: and l_hire_date between asg.effective_start_date

Line 1657: from per_assignments_f asg,

1653: asg.object_version_number,
1654: asg.effective_start_date,
1655: asg.vacancy_id
1656:
1657: from per_assignments_f asg,
1658: per_assignment_status_types pas
1659: where asg.assignment_status_type_id = pas.assignment_status_type_id
1660: and asg.person_id = p_person_id
1661: and l_hire_date between asg.effective_start_date

Line 1942: -- date in the PER_ASSIGNMENTS_F table has assignment status

1938: hr_utility.set_location(l_proc,120);
1939: --
1940: -- Check p_assignment is corresponding data.
1941: -- The assignment record specified by P_ASSIGNMENT_ID on the hire
1942: -- date in the PER_ASSIGNMENTS_F table has assignment status
1943: -- 'ACCEPTED'.
1944: --
1945: if p_primary_assignment_id is not null then
1946: --

Line 2029: -- by calling the del procedure in the PER_ASSIGNMENTS_F table handler

2025: );
2026: hr_utility.set_location(l_proc,190);
2027: --
2028: -- Set all unaccepted applicant assignments to have end date = p_hire_date -1
2029: -- by calling the del procedure in the PER_ASSIGNMENTS_F table handler
2030: -- (This is a datetrack DELETE mode operation)
2031: --
2032: open csr_get_un_accepted;
2033: loop

Line 2130: -- PER_ASSIGNMENTS_F table handler(This is a datetrack UPDATE mode

2126: -- All accepted applicant assignments are changed to employee assignments
2127: -- with default employee assignment.(ACTIVE_ASSIGN)
2128: -- 1) Derive assignment_status_type_id for default 'ACTIVE_ASSIGN'.
2129: -- 2) Update the assignments by calling the upd procedure in the
2130: -- PER_ASSIGNMENTS_F table handler(This is a datetrack UPDATE mode
2131: -- operation)
2132: -- 3) When the accepted assignments are multiple, the primary flag of the
2133: -- record not specified by P_ASSIGNMENT_ID is set to 'N'.
2134: --

Line 2609: UPDATE PER_ASSIGNMENTS_F PAF SET PAF.VACANCY_ID =l_asg_rec.vacancy_id ,

2605: hr_utility.set_location(l_proc, 271);
2606:
2607: --Fix For Bug # 5987409 Starts -----
2608:
2609: UPDATE PER_ASSIGNMENTS_F PAF SET PAF.VACANCY_ID =l_asg_rec.vacancy_id ,
2610: PAF.RECRUITER_ID =l_asg_rec.recruiter_id
2611: WHERE PAF.ASSIGNMENT_ID = l_primary_asg_id AND
2612: PAF.EFFECTIVE_START_DATE = l_effective_start_date AND
2613: PAF.EFFECTIVE_END_DATE = l_effective_end_date;

Line 3238: UPDATE PER_ASSIGNMENTS_F PAF SET PAF.VACANCY_ID =l_asg_rec.vacancy_id ,

3234:
3235:
3236: --Fix For Bug # 5987409 Starts -----
3237:
3238: UPDATE PER_ASSIGNMENTS_F PAF SET PAF.VACANCY_ID =l_asg_rec.vacancy_id ,
3239: PAF.RECRUITER_ID =l_asg_rec.recruiter_id
3240: WHERE PAF.ASSIGNMENT_ID = l_primary_asg_id AND
3241: PAF.EFFECTIVE_START_DATE = l_effective_start_date AND
3242: PAF.EFFECTIVE_END_DATE = l_effective_end_date;