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_ALL_ASSIGNMENTS_F

Line 20: ,p_assignment_id IN per_all_assignments_f.assignment_id%type --2264191 added

16: --
17: CURSOR csr_future_asgs
18: (p_person_id IN per_all_people_f.person_id%TYPE
19: ,p_effective_date IN DATE
20: ,p_assignment_id IN per_all_assignments_f.assignment_id%type --2264191 added
21: )
22: IS
23: SELECT asg.assignment_id
24: ,asg.object_version_number

Line 51: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT hr_api.g_number

47: --
48: CURSOR csr_accepted_asgs
49: (p_person_id IN per_all_people_f.person_id%TYPE
50: ,p_effective_date IN DATE
51: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT hr_api.g_number
52: )
53: IS
54: SELECT asg.assignment_id
55: ,asg.object_version_number

Line 167: ,p_assignment_id IN per_all_assignments_f.assignment_id%type DEFAULT NULL --2264191 added

163: --
164: FUNCTION future_asgs_count
165: (p_person_id IN per_all_people_f.person_id%TYPE
166: ,p_effective_date IN DATE
167: ,p_assignment_id IN per_all_assignments_f.assignment_id%type DEFAULT NULL --2264191 added
168: )
169: RETURN INTEGER
170: IS
171: --

Line 637: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

633: ,p_hire_date IN DATE
634: ,p_person_id IN per_all_people_f.person_id%TYPE
635: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
636: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
637: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
638: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
639: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
640: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
641: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 701: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

697: ,p_hire_date IN DATE
698: ,p_person_id IN per_all_people_f.person_id%TYPE
699: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
700: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
701: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
702: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
703: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
704: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
705: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 765: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

761: ,p_person_id IN per_all_people_f.person_id%TYPE
762: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
763: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
764: ,p_hire_all_accepted_asgs IN VARCHAR2
765: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
766: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
767: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
768: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
769: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 784: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;

780: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
781: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
782: l_person_type_id1 per_person_types.person_type_id%TYPE;
783: --
784: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
785: l_hire_all_accepted_asgs VARCHAR2(1);
786: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;
787: --
788: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;

Line 786: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;

782: l_person_type_id1 per_person_types.person_type_id%TYPE;
783: --
784: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
785: l_hire_all_accepted_asgs VARCHAR2(1);
786: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;
787: --
788: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
789: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
790: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;

Line 802: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

798: l_nonaccepted_asgs_count INTEGER;
799: l_accepted_asgs_count INTEGER;
800: l_primary_asgs_count INTEGER;
801: l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
802: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
803: --
804: l_effective_start_date DATE;
805: l_effective_end_date DATE;
806: l_validation_start_date DATE;

Line 837: from per_all_assignments_f asg

833: from per_all_vacancies vac
834: where vac.vacancy_id=p_vacancy_id
835: and vac.number_of_openings <
836: (select count(distinct assignment_id)
837: from per_all_assignments_f asg
838: where asg.vacancy_id=p_vacancy_id
839: and asg.assignment_type='E');
840: --
841: cursor csr_future_per_changes(p_effective_date DATE) is

Line 1555: l_primary_asg_id per_all_assignments_f.assignment_id%type;

1551: l_org_now_no_manager_warning boolean;
1552: l_hourly_salaried_warning boolean;
1553: l_datetrack_update_mode varchar2(30);
1554: --
1555: l_primary_asg_id per_all_assignments_f.assignment_id%type;
1556: l_primary_ovn per_all_assignments_f.object_version_number%type;
1557: l_dummy number;
1558: l_dummy1 number;
1559: l_dummy2 number;

Line 1556: l_primary_ovn per_all_assignments_f.object_version_number%type;

1552: l_hourly_salaried_warning boolean;
1553: l_datetrack_update_mode varchar2(30);
1554: --
1555: l_primary_asg_id per_all_assignments_f.assignment_id%type;
1556: l_primary_ovn per_all_assignments_f.object_version_number%type;
1557: l_dummy number;
1558: l_dummy1 number;
1559: l_dummy2 number;
1560: l_dummyv varchar2(700);

Line 1669: from per_all_assignments_f

1665: --
1666: --
1667: cursor get_primary is
1668: select assignment_id,object_version_number, period_of_service_id -- #2468916
1669: from per_all_assignments_f
1670: where person_id=p_person_id
1671: and primary_flag='Y'
1672: and l_hire_date between effective_start_date and effective_end_date
1673: and assignment_type='E';

Line 1677: from per_all_assignments_f asg

1673: and assignment_type='E';
1674: --
1675: cursor get_asg(p_assignment_id number) is
1676: select *
1677: from per_all_assignments_f asg
1678: where asg.assignment_id=p_assignment_id
1679: and l_hire_date between asg.effective_start_date
1680: and asg.effective_end_date;
1681: --

Line 1682: l_asg_rec per_all_assignments_f%rowtype;

1678: where asg.assignment_id=p_assignment_id
1679: and l_hire_date between asg.effective_start_date
1680: and asg.effective_end_date;
1681: --
1682: l_asg_rec per_all_assignments_f%rowtype;
1683: l_primary_asg_rec per_all_assignments_f%rowtype;
1684: --
1685: cursor get_pgp(p_people_group_id number) is
1686: select *

Line 1683: l_primary_asg_rec per_all_assignments_f%rowtype;

1679: and l_hire_date between asg.effective_start_date
1680: and asg.effective_end_date;
1681: --
1682: l_asg_rec per_all_assignments_f%rowtype;
1683: l_primary_asg_rec per_all_assignments_f%rowtype;
1684: --
1685: cursor get_pgp(p_people_group_id number) is
1686: select *
1687: from pay_people_groups

Line 1715: from per_all_assignments_f asg

1711: from per_all_vacancies vac
1712: where vac.vacancy_id=p_vacancy_id
1713: and vac.number_of_openings <
1714: (select count(distinct assignment_id)
1715: from per_all_assignments_f asg
1716: where asg.vacancy_id=p_vacancy_id
1717: and asg.assignment_type='E');
1718: --
1719: -- Bug 4644830 Start

Line 1720: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is

1716: where asg.vacancy_id=p_vacancy_id
1717: and asg.assignment_type='E');
1718: --
1719: -- Bug 4644830 Start
1720: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1721: select pay_proposal_id,object_version_number,proposed_salary_n, change_date, proposal_reason -- Added For Bug 5987409 --
1722: from per_pay_proposals
1723: where assignment_id=ass_id
1724: and approved = 'N'

Line 1738: l_pspl_asg_id per_all_assignments_f.assignment_id%type;

1734: l_proposal_reason per_pay_proposals.proposal_reason%TYPE; -- Added For Bug 5987409 --
1735: -- Bug 4644830 End
1736: --
1737: -- start of bug 4641965
1738: l_pspl_asg_id per_all_assignments_f.assignment_id%type;
1739: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1740: select pay_proposal_id,object_version_number
1741: from per_pay_proposals
1742: where assignment_id=ass_id

Line 1739: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is

1735: -- Bug 4644830 End
1736: --
1737: -- start of bug 4641965
1738: l_pspl_asg_id per_all_assignments_f.assignment_id%type;
1739: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1740: select pay_proposal_id,object_version_number
1741: from per_pay_proposals
1742: where assignment_id=ass_id
1743: and APPROVED='N';

Line 1750: from per_all_assignments_f PAAF

1746: --Bug 4959033 starts here
1747:
1748: cursor get_business_group(p_asg_id number) is
1749: select distinct PAAF.business_group_id
1750: from per_all_assignments_f PAAF
1751: where PAAF.assignment_id=p_asg_id;
1752: l_bg_id number;
1753:
1754: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is

Line 1754: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is

1750: from per_all_assignments_f PAAF
1751: where PAAF.assignment_id=p_asg_id;
1752: l_bg_id number;
1753:
1754: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1755: select pay_proposal_id
1756: from per_pay_proposals
1757: where assignment_id=ass_id
1758: and APPROVED='Y';

Line 1763: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;

1759:
1760: --Bug 4959033 ends here
1761: --
1762: --Bug 5102289 starts here
1763: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
1764: l_approved varchar2(10);
1765: cursor get_primary_pay_basis(p_asg_id number) is
1766: select PAAF.pay_basis_id
1767: from per_all_assignments_f PAAF

Line 1767: from per_all_assignments_f PAAF

1763: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
1764: l_approved varchar2(10);
1765: cursor get_primary_pay_basis(p_asg_id number) is
1766: select PAAF.pay_basis_id
1767: from per_all_assignments_f PAAF
1768: where PAAF.assignment_id=p_asg_id;
1769: --Bug 5102289 ends here
1770: --
1771: begin

Line 3475: ,p_id per_all_assignments_f.assignment_id%TYPE)

3471: -- LOCATE_ELEMENT:
3472: -- Returns the location of a particular ID in the array.
3473: -- +-------------------------------------------------------------------------+
3474: function locate_element(p_table t_ApplTable
3475: ,p_id per_all_assignments_f.assignment_id%TYPE)
3476: return binary_integer is
3477: --
3478: l_index number;
3479: l_max_ele number;

Line 3543: ,p_id per_all_assignments_f.assignment_id%TYPE)

3539: -- 1: if END DATE value has been stored in
3540: -- 2: a different value has been found.
3541: -- +-------------------------------------------------------------------------+
3542: function end_date_exists(p_table t_ApplTable
3543: ,p_id per_all_assignments_f.assignment_id%TYPE)
3544: return integer is
3545: l_index binary_integer;
3546: begin
3547: l_index := locate_element(p_table, p_id);

Line 3568: ,p_id per_all_assignments_f.assignment_id%TYPE)

3564: -- assignments that have been ACCEPTED. The null value reflects a default
3565: -- value of 'Convert into secondary'.
3566: -- +-------------------------------------------------------------------------+
3567: function is_convert(p_table t_ApplTable
3568: ,p_id per_all_assignments_f.assignment_id%TYPE)
3569: return boolean is
3570: l_index binary_integer;
3571: begin
3572: