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 1206: from per_all_assignments_f a

1202: ,p_old_start_date date
1203: ,p_new_start_date date) is
1204: cursor csr_apl_asg is
1205: select assignment_id
1206: from per_all_assignments_f a
1207: where a.effective_end_date = p_old_start_date - 1
1208: and a.assignment_type = 'A'
1209: and a.person_id = p_person_id;
1210: --

Line 1211: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1207: where a.effective_end_date = p_old_start_date - 1
1208: and a.assignment_type = 'A'
1209: and a.person_id = p_person_id;
1210: --
1211: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1212: --
1213: begin
1214: open csr_apl_asg;
1215: loop

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

1224: and a2.assignment_type = 'A')
1225: and a.assignment_id = l_assignment_id;
1226: if sql%rowcount <1 then
1227: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1228: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1229: hr_utility.raise_error;
1230: end if;
1231: end loop;
1232: close csr_apl_asg;

Line 1397: from per_all_assignments_f paf

1393: where person_id = p_person_id;
1394: --
1395: cursor ass_cur is
1396: select assignment_id
1397: from per_all_assignments_f paf
1398: where paf.person_id = p_person_id
1399: and paf.assignment_type = p_type
1400: and p_new_start_date between
1401: paf.effective_start_date and paf.effective_end_date;

Line 1518: l_assignment_id per_all_assignments_f.assignment_id%type;

1514: --
1515: -- local variables.
1516: --
1517: l_proc varchar2(30):='update_probation_end';
1518: l_assignment_id per_all_assignments_f.assignment_id%type;
1519: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1520: l_probation_period1 per_all_assignments_f.probation_period%type;
1521: l_probation_period per_all_assignments_f.probation_period%type;
1522: l_probation_unit1 per_all_assignments_f.probation_unit%type;

Line 1519: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;

1515: -- local variables.
1516: --
1517: l_proc varchar2(30):='update_probation_end';
1518: l_assignment_id per_all_assignments_f.assignment_id%type;
1519: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1520: l_probation_period1 per_all_assignments_f.probation_period%type;
1521: l_probation_period per_all_assignments_f.probation_period%type;
1522: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1523: l_probation_unit per_all_assignments_f.probation_unit%type;

Line 1520: l_probation_period1 per_all_assignments_f.probation_period%type;

1516: --
1517: l_proc varchar2(30):='update_probation_end';
1518: l_assignment_id per_all_assignments_f.assignment_id%type;
1519: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1520: l_probation_period1 per_all_assignments_f.probation_period%type;
1521: l_probation_period per_all_assignments_f.probation_period%type;
1522: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1523: l_probation_unit per_all_assignments_f.probation_unit%type;
1524: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;

Line 1521: l_probation_period per_all_assignments_f.probation_period%type;

1517: l_proc varchar2(30):='update_probation_end';
1518: l_assignment_id per_all_assignments_f.assignment_id%type;
1519: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1520: l_probation_period1 per_all_assignments_f.probation_period%type;
1521: l_probation_period per_all_assignments_f.probation_period%type;
1522: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1523: l_probation_unit per_all_assignments_f.probation_unit%type;
1524: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;
1525: l_date_probation_end per_all_assignments_f.date_probation_end%type;

Line 1522: l_probation_unit1 per_all_assignments_f.probation_unit%type;

1518: l_assignment_id per_all_assignments_f.assignment_id%type;
1519: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1520: l_probation_period1 per_all_assignments_f.probation_period%type;
1521: l_probation_period per_all_assignments_f.probation_period%type;
1522: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1523: l_probation_unit per_all_assignments_f.probation_unit%type;
1524: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;
1525: l_date_probation_end per_all_assignments_f.date_probation_end%type;
1526: l_new_effective_date date;

Line 1523: l_probation_unit per_all_assignments_f.probation_unit%type;

1519: l_date_probation_end1 per_all_assignments_f.date_probation_end%type;
1520: l_probation_period1 per_all_assignments_f.probation_period%type;
1521: l_probation_period per_all_assignments_f.probation_period%type;
1522: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1523: l_probation_unit per_all_assignments_f.probation_unit%type;
1524: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;
1525: l_date_probation_end per_all_assignments_f.date_probation_end%type;
1526: l_new_effective_date date;
1527: l_new_start_date date;

Line 1524: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;

1520: l_probation_period1 per_all_assignments_f.probation_period%type;
1521: l_probation_period per_all_assignments_f.probation_period%type;
1522: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1523: l_probation_unit per_all_assignments_f.probation_unit%type;
1524: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;
1525: l_date_probation_end per_all_assignments_f.date_probation_end%type;
1526: l_new_effective_date date;
1527: l_new_start_date date;
1528: l_effective_start_date date;

Line 1525: l_date_probation_end per_all_assignments_f.date_probation_end%type;

1521: l_probation_period per_all_assignments_f.probation_period%type;
1522: l_probation_unit1 per_all_assignments_f.probation_unit%type;
1523: l_probation_unit per_all_assignments_f.probation_unit%type;
1524: l_new_date_probation_end per_all_assignments_f.date_probation_end%type;
1525: l_date_probation_end per_all_assignments_f.date_probation_end%type;
1526: l_new_effective_date date;
1527: l_new_start_date date;
1528: l_effective_start_date date;
1529: --

Line 1668: FROM per_all_assignments_f

1664: l_proc varchar2(72):='hr_change_start_date_api.check_grade_ladder';
1665: --
1666: CURSOR csr_asg_records IS
1667: SELECT GRADE_LADDER_PGM_ID
1668: FROM per_all_assignments_f
1669: WHERE person_id = p_person_id
1670: AND GRADE_LADDER_PGM_ID is not null
1671: AND effective_start_date = p_old_start_date;
1672: --

Line 1729: from per_all_assignments_f

1725: cursor get_asg(p_per in number,
1726: p_new_st_date in date)
1727: is
1728: select assignment_id, business_group_id
1729: from per_all_assignments_f
1730: where person_id = p_per
1731: and effective_start_date = p_new_st_date;
1732: --
1733: dt_mode varchar2(30);

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

2441: and a.assignment_type = p_update_type
2442: and a.person_id = p_person_id;
2443: if sql%rowcount <1 then
2444: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2445: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2446: hr_utility.raise_error;
2447: end if;
2448: end if;
2449: --

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

2453: and a.assignment_type = p_update_type
2454: and a.person_id = p_person_id;
2455: if sql%rowcount <1 then
2456: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2457: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2458: hr_utility.raise_error;
2459: end if;
2460: --
2461: -- 115.32 115.34 (START)