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_SUPERVISOR_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 164: FROM per_all_assignments_f paf

160: -- NOTE: We need to use the primary assignment because we're trying to
161: -- derive the manager id of the login person, not the action employee.
162: CURSOR csr_get_mgr_id_of_login IS
163: SELECT paf.supervisor_id
164: FROM per_all_assignments_f paf
165: ,per_all_people_f ppf
166: WHERE ppf.person_id = ln_creator_person_id
167: and paf.person_id = ppf.person_id
168: and ld_effective_date between ppf.effective_start_date

Line 228: select primary_flag into dummy from per_all_assignments_f where

224: hr_utility.trace('In (if lv_term_sup_flag = Y)'|| l_proc);
225: resultout := 'COMPLETE:'|| 'N';
226: lv_no_access_to_some_cc := 'N';
227:
228: select primary_flag into dummy from per_all_assignments_f where
229: assignment_id=ln_assignment_id and ld_effective_date between
230: effective_start_date and effective_end_date;
231:
232: l_term_sec_asg := wf_engine.getitemattrtext(itemtype, itemkey,

Line 503: || DESCRIPTION: This changes the per_all_assignments_f.supervisor_id attribute

499:
500: /*
501: ||===========================================================================
502: || PROCEDURE: update_supervisor
503: || DESCRIPTION: This changes the per_all_assignments_f.supervisor_id attribute
504: || to the value of the passed in parm p_supervisor_id.
505: ||===========================================================================
506: */
507:

Line 520: -- Changed from per_assignments_f to per_all_assignments_f. This is

516: p_validate BOOLEAN )
517: IS
518:
519: -- Bug 2130066 Fix Begins: 01/11/2002
520: -- Changed from per_assignments_f to per_all_assignments_f. This is
521: -- necessary because when a Supervisor Security profile restrict to 1 level,
522: -- we cannot get data for 2 levels down or beyond. This will happen when
523: -- the 1st level employee is terminated, we need to change all his direct
524: -- reports to another employee. In this case, the direct reports of the

Line 530: FROM per_all_assignments_f -- Bug 2130066 fix

526: -- profile is restricted to 1 level.
527: CURSOR lc_object_version_no IS
528: SELECT object_version_number,
529: assignment_type
530: FROM per_all_assignments_f -- Bug 2130066 fix
531: WHERE assignment_id = p_assignment_id
532: AND (p_effective_date BETWEEN
533: NVL ( effective_start_date , p_effective_date)
534: AND NVL ( effective_end_date , p_effective_date )) ;

Line 537: ln_assignment_type per_all_assignments_f.assignment_type%type;

533: NVL ( effective_start_date , p_effective_date)
534: AND NVL ( effective_end_date , p_effective_date )) ;
535:
536: ln_object_version_no NUMBER ;
537: ln_assignment_type per_all_assignments_f.assignment_type%type;
538: ln_comment_id NUMBER ;
539: ld_effective_start_date DATE;
540: ld_effective_end_date DATE;
541: lb_no_managers_warning BOOLEAN ;

Line 788: -- Changed from per_assignments_f to per_all_assignments_f. This is

784:
785: IS
786:
787: -- Bug 2130066 Fix Begins: 01/11/2002
788: -- Changed from per_assignments_f to per_all_assignments_f. This is
789: -- necessary because when a Supervisor Security profile restrict to 1 level
790: -- ,we cannot get data for 2 levels down or beyond. This will happen when
791: -- the 1st level employee is terminated, we need to change all his direct
792: -- reports to another employee. In this case, the direct reports of the

Line 798: FROM per_all_assignments_f paf, -- Bug 2130066 fix

794: -- Security profile is restricted to 1 level.
795: --
796: cursor lc_assignment_id ( p_person_id NUMBER, p_effective_date date) is
797: SELECT distinct paf.assignment_id
798: FROM per_all_assignments_f paf, -- Bug 2130066 fix
799: per_all_people_f ppf
800: WHERE ppf.person_id = p_person_id
801: AND p_effective_date BETWEEN
802: ppf.effective_start_date AND ppf.effective_end_date

Line 1776: -- Changed from per_assignments_f to per_all_assignments_f. This is

1772: lb_other_manager_warn boolean;
1773: lb_validate BOOLEAN ;
1774:
1775: -- Bug 2130066 Fix Begins: 01/11/2002
1776: -- Changed from per_assignments_f to per_all_assignments_f. This is
1777: -- necessary because when a Supervisor Security profile restrict to 1 level
1778: -- ,we cannot get data for 2 levels down or beyond. This will happen when
1779: -- the 1st level employee is terminated, we need to change all his direct
1780: -- reports to another employee. In this case, the direct reports of the

Line 1787: FROM per_all_assignments_f -- Bug 2130066 fix

1783: --
1784:
1785: CURSOR lc_object_version_no(l_assignment_id number) IS
1786: SELECT object_version_number, assignment_type
1787: FROM per_all_assignments_f -- Bug 2130066 fix
1788: WHERE assignment_id = l_assignment_id
1789: AND (p_effective_date BETWEEN
1790: NVL ( effective_start_date , p_effective_date)
1791: AND NVL ( effective_end_date , p_effective_date )) ;

Line 1799: l_assignment_type per_all_assignments_f.assignment_type%type;

1795: ln_object_version_no NUMBER ;
1796:
1797: -- variables and cursor for applicant_hire
1798: l_object_version_number number;
1799: l_assignment_type per_all_assignments_f.assignment_type%type;
1800: l_per_object_version_number number;
1801: l_employee_number varchar2(30);
1802: l_person_id number;
1803: l_person_name per_all_people_f.global_name%type;

Line 1805: l_appl_assignment_type per_all_assignments_f.assignment_type%type;

1801: l_employee_number varchar2(30);
1802: l_person_id number;
1803: l_person_name per_all_people_f.global_name%type;
1804: l_assignment_id number;
1805: l_appl_assignment_type per_all_assignments_f.assignment_type%type;
1806: l_per_effective_start_date date;
1807: l_per_effective_end_date date;
1808: l_unaccepted_asg_del_warning boolean;
1809: l_assign_payroll_warning boolean;

Line 1826: -- assignment_type from per_all_assignments_f, for assinging

1822: and p_appl_effective_date between effective_start_date
1823: and effective_end_date;
1824:
1825: -- cursor to get the applicant object_version_number,person_id
1826: -- assignment_type from per_all_assignments_f, for assinging
1827: -- a new manager
1828: cursor asg_appl_rec_assign_manager(p_appl_assign_id in number,
1829: p_appl_effective_date in date) is
1830: select object_version_number,

Line 1833: from per_all_assignments_f

1829: p_appl_effective_date in date) is
1830: select object_version_number,
1831: assignment_type,
1832: person_id
1833: from per_all_assignments_f
1834: where assignment_id = p_appl_assign_id
1835: and p_appl_effective_date between effective_start_date
1836: and effective_end_date;
1837:

Line 1839: -- assignment_type from per_all_assignments_f, for assigning

1835: and p_appl_effective_date between effective_start_date
1836: and effective_end_date;
1837:
1838: -- cursor to get the applicant object_version_number
1839: -- assignment_type from per_all_assignments_f, for assigning
1840: -- a new direct reports
1841: cursor asg_appl_rec_assign_directs(p_appl_person_id in number,
1842: p_appl_effective_date in date) is
1843: select object_version_number,

Line 1845: from per_all_assignments_f

1841: cursor asg_appl_rec_assign_directs(p_appl_person_id in number,
1842: p_appl_effective_date in date) is
1843: select object_version_number,
1844: assignment_type
1845: from per_all_assignments_f
1846: where person_id = p_appl_person_id
1847: and p_appl_effective_date between effective_start_date
1848: and effective_end_date;
1849:

Line 1854: (select person_id from per_all_assignments_f

1850: -- added cursor for Bug 11679239
1851: cursor csr_assignment_person is
1852: select person_id,Global_name from per_all_people_f
1853: where person_id in
1854: (select person_id from per_all_assignments_f
1855: where ASSIGNMENT_ID = p_assignment_id);
1856:
1857: cursor csr_assignment_future(p_appl_person_id in number,
1858: p_appl_effective_date in date) is

Line 1860: from per_all_assignments_f

1856:
1857: cursor csr_assignment_future(p_appl_person_id in number,
1858: p_appl_effective_date in date) is
1859: select assignment_id
1860: from per_all_assignments_f
1861: where person_id = p_appl_person_id
1862: and effective_start_date > p_appl_effective_date;
1863:
1864:

Line 1868: from per_all_assignments_f

1864:
1865: cursor csr_present_supervisor_id(p_appl_person_id in number,
1866: p_appl_effective_date in date) is
1867: select supervisor_id
1868: from per_all_assignments_f
1869: where person_id = p_appl_person_id
1870: and p_appl_effective_date between effective_start_date and effective_end_date;
1871: -- End of added cursor for Bug 11679239
1872:

Line 1875: from per_all_assignments_f

1871: -- End of added cursor for Bug 11679239
1872:
1873: cursor csr_assignment is
1874: select assignment_id
1875: from per_all_assignments_f
1876: where assignment_id = p_assignment_id;
1877:
1878: -- Bug Fix 3041328
1879: cursor csr_person is

Line 1899: l_applicant_assignment_id per_all_assignments_f.assignment_id%type;

1895: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
1896: l_current_employee_flag per_all_people_f.current_employee_flag%type;
1897: l_current_npw_flag per_all_people_f.current_npw_flag%type;
1898: l_applicant_person_id per_all_people_f.person_id%type;
1899: l_applicant_assignment_id per_all_assignments_f.assignment_id%type;
1900: l_applicant_effective_date per_all_people_f.effective_start_date%type;
1901:
1902: -- Bug Fix 3041328
1903: l_supervisor_id per_all_people_F.person_id%type;

Line 1904: -- l_supervisor_assign_id per_all_assignments_f.assignment_id%type;

1900: l_applicant_effective_date per_all_people_f.effective_start_date%type;
1901:
1902: -- Bug Fix 3041328
1903: l_supervisor_id per_all_people_F.person_id%type;
1904: -- l_supervisor_assign_id per_all_assignments_f.assignment_id%type;
1905: l_supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type;
1906:
1907: l_re_hire_flow varchar2(25) default null;
1908: l_error_message varchar2(500);

Line 1905: l_supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type;

1901:
1902: -- Bug Fix 3041328
1903: l_supervisor_id per_all_people_F.person_id%type;
1904: -- l_supervisor_assign_id per_all_assignments_f.assignment_id%type;
1905: l_supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type;
1906:
1907: l_re_hire_flow varchar2(25) default null;
1908: l_error_message varchar2(500);
1909: l_ex_emp varchar2(10) default null;