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

Line 1116: from Per_All_Assignments_f Asgt

1112:
1113: Cursor Person_Info Is
1114: Select Asgt.Business_Group_id,
1115: Asgt.effective_start_date
1116: from Per_All_Assignments_f Asgt
1117: Where person_id = p_person_id
1118: and primary_flag = 'Y'
1119: and assignment_type = 'E'
1120: and P_Effective_Date Between Asgt.Effective_Start_Date and Asgt.Effective_End_Date;

Line 1159: l_bg_id Per_All_Assignments_F.Business_Group_id%TYPE;

1155: object_version_number
1156: from ben_enrt_rt
1157: where elig_per_elctbl_chc_id = cl_elig_per_elctbl_chc_id;
1158:
1159: l_bg_id Per_All_Assignments_F.Business_Group_id%TYPE;
1160: l_New_Enrlmt_Dt Date;
1161: l_start_date Date;
1162: l_end_date Date;
1163:

Line 1554: from per_all_assignments_f a

1550: ,p_old_start_date date
1551: ,p_new_start_date date) is
1552: cursor csr_apl_asg is
1553: select assignment_id
1554: from per_all_assignments_f a
1555: where a.effective_end_date = p_old_start_date - 1
1556: and a.assignment_type = 'A'
1557: and a.person_id = p_person_id;
1558: --

Line 1559: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1555: where a.effective_end_date = p_old_start_date - 1
1556: and a.assignment_type = 'A'
1557: and a.person_id = p_person_id;
1558: --
1559: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1560: --
1561: begin
1562: open csr_apl_asg;
1563: loop

Line 1576: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');

1572: and a2.assignment_type = 'A')
1573: and a.assignment_id = l_assignment_id;
1574: if sql%rowcount <1 then
1575: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1576: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1577: hr_utility.raise_error;
1578: end if;
1579:
1580: if per_otherbg_apl_api.isMultiRegVac(l_assignment_id) then

Line 1835: from per_all_assignments_f paf

1831: where person_id = p_person_id;
1832: --
1833: cursor ass_cur is
1834: select assignment_id
1835: from per_all_assignments_f paf
1836: where paf.person_id = p_person_id
1837: and paf.assignment_type = p_type
1838: and p_new_start_date between
1839: paf.effective_start_date and paf.effective_end_date;

Line 1956: l_assignment_id per_all_assignments_f.assignment_id%type;

1952: --
1953: -- local variables.
1954: --
1955: l_proc varchar2(30):='update_probation_end';
1956: l_assignment_id per_all_assignments_f.assignment_id%type;
1957: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1958: l_probation_period1 per_all_assignments_f.probation_period%type;
1959: l_probation_period per_all_assignments_f.probation_period%type;
1960: l_probation_unit1 per_all_assignments_f.probation_unit%type;

Line 1957: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;

1953: -- local variables.
1954: --
1955: l_proc varchar2(30):='update_probation_end';
1956: l_assignment_id per_all_assignments_f.assignment_id%type;
1957: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1958: l_probation_period1 per_all_assignments_f.probation_period%type;
1959: l_probation_period per_all_assignments_f.probation_period%type;
1960: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1961: l_probation_unit per_all_assignments_f.probation_unit%type;

Line 1958: l_probation_period1 per_all_assignments_f.probation_period%type;

1954: --
1955: l_proc varchar2(30):='update_probation_end';
1956: l_assignment_id per_all_assignments_f.assignment_id%type;
1957: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1958: l_probation_period1 per_all_assignments_f.probation_period%type;
1959: l_probation_period per_all_assignments_f.probation_period%type;
1960: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1961: l_probation_unit per_all_assignments_f.probation_unit%type;
1962: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;

Line 1959: l_probation_period per_all_assignments_f.probation_period%type;

1955: l_proc varchar2(30):='update_probation_end';
1956: l_assignment_id per_all_assignments_f.assignment_id%type;
1957: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1958: l_probation_period1 per_all_assignments_f.probation_period%type;
1959: l_probation_period per_all_assignments_f.probation_period%type;
1960: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1961: l_probation_unit per_all_assignments_f.probation_unit%type;
1962: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;
1963: l_date_probation_end per_all_assignments_f.date_probation_end%type;

Line 1960: l_probation_unit1 per_all_assignments_f.probation_unit%type;

1956: l_assignment_id per_all_assignments_f.assignment_id%type;
1957: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1958: l_probation_period1 per_all_assignments_f.probation_period%type;
1959: l_probation_period per_all_assignments_f.probation_period%type;
1960: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1961: l_probation_unit per_all_assignments_f.probation_unit%type;
1962: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;
1963: l_date_probation_end per_all_assignments_f.date_probation_end%type;
1964: l_new_effective_date date;

Line 1961: l_probation_unit per_all_assignments_f.probation_unit%type;

1957: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1958: l_probation_period1 per_all_assignments_f.probation_period%type;
1959: l_probation_period per_all_assignments_f.probation_period%type;
1960: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1961: l_probation_unit per_all_assignments_f.probation_unit%type;
1962: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;
1963: l_date_probation_end per_all_assignments_f.date_probation_end%type;
1964: l_new_effective_date date;
1965: l_new_start_date date;

Line 1962: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;

1958: l_probation_period1 per_all_assignments_f.probation_period%type;
1959: l_probation_period per_all_assignments_f.probation_period%type;
1960: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1961: l_probation_unit per_all_assignments_f.probation_unit%type;
1962: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;
1963: l_date_probation_end per_all_assignments_f.date_probation_end%type;
1964: l_new_effective_date date;
1965: l_new_start_date date;
1966: l_effective_start_date date;

Line 1963: l_date_probation_end per_all_assignments_f.date_probation_end%type;

1959: l_probation_period per_all_assignments_f.probation_period%type;
1960: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1961: l_probation_unit per_all_assignments_f.probation_unit%type;
1962: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;
1963: l_date_probation_end per_all_assignments_f.date_probation_end%type;
1964: l_new_effective_date date;
1965: l_new_start_date date;
1966: l_effective_start_date date;
1967: --

Line 2106: FROM per_all_assignments_f

2102: l_proc varchar2(72):='hr_change_start_date_api.check_grade_ladder';
2103: --
2104: CURSOR csr_asg_records IS
2105: SELECT GRADE_LADDER_PGM_ID
2106: FROM per_all_assignments_f
2107: WHERE person_id = p_person_id
2108: AND GRADE_LADDER_PGM_ID is not null
2109: AND effective_start_date = p_old_start_date;
2110: --

Line 2167: from per_all_assignments_f

2163: cursor get_asg(p_per in number,
2164: p_new_st_date in date)
2165: is
2166: select assignment_id, business_group_id
2167: from per_all_assignments_f
2168: where person_id = p_per
2169: and effective_start_date = p_new_st_date;
2170: --
2171: dt_mode varchar2(30);

Line 2927: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');

2923: and a.assignment_type = p_update_type
2924: and a.person_id = p_person_id;
2925: if sql%rowcount <1 then
2926: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2927: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2928: hr_utility.raise_error;
2929: end if;
2930: end if;
2931: --

Line 2939: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');

2935: and a.assignment_type = p_update_type
2936: and a.person_id = p_person_id;
2937: if sql%rowcount <1 then
2938: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2939: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2940: hr_utility.raise_error;
2941: end if;
2942: --
2943: -- 115.32 115.34 (START)