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.PER_PERIODS_OF_SERVICE_PKG dependencies on STANDARD

Line 98: p_last_standard_process_date IN OUT NOCOPY DATE) is

94: p_person_id NUMBER,
95: p_actual_termination_date DATE,
96: p_no_payrolls IN OUT NOCOPY NUMBER,
97: p_final_process_date IN OUT NOCOPY DATE,
98: p_last_standard_process_date IN OUT NOCOPY DATE) is
99: --
100: -- Get the number of payrolls person is assigned to
101: -- and the maximum last dates of the current time period
102: -- for the person's assignment.

Line 114: , p_last_standard_process_date

110: --
111: --
112: select max(end_date),max(end_date)
113: into p_final_process_date
114: , p_last_standard_process_date
115: from per_time_periods
116: where p_actual_termination_date between
117: start_date and end_date
118: and payroll_id in (select payroll_id

Line 145: ,p_last_standard_process_date DATE

141: ,p_accepted_termination_date DATE
142: ,p_actual_termination_date DATE
143: ,p_comments VARCHAR2
144: ,p_final_process_date DATE
145: ,p_last_standard_process_date DATE
146: ,p_leaving_reason VARCHAR2
147: ,p_notified_termination_date DATE
148: ,p_projected_termination_date DATE
149: ,p_request_id NUMBER

Line 201: ,last_standard_process_date

197: ,accepted_termination_date
198: ,actual_termination_date
199: ,comments
200: ,final_process_date
201: ,last_standard_process_date
202: ,leaving_reason
203: ,notified_termination_date
204: ,projected_termination_date
205: ,request_id

Line 242: ,p_last_standard_process_date

238: ,p_accepted_termination_date
239: ,p_actual_termination_date
240: ,p_comments
241: ,p_final_process_date
242: ,p_last_standard_process_date
243: ,p_leaving_reason
244: ,p_notified_termination_date
245: ,p_projected_termination_date
246: ,p_request_id

Line 310: ,p_last_standard_process_date DATE

306: ,p_accepted_termination_date DATE
307: ,p_actual_termination_date DATE
308: ,p_comments VARCHAR2
309: ,p_final_process_date DATE
310: ,p_last_standard_process_date DATE
311: ,p_leaving_reason VARCHAR2
312: ,p_notified_termination_date DATE
313: ,p_projected_termination_date DATE
314: ,p_request_id NUMBER

Line 471: and (( p_last_standard_process_date = pps_rec.last_standard_process_date)

467: and (p_comments is null)))
468: and (( p_final_process_date = pps_rec.final_process_date)
469: or (pps_rec.final_process_date is null
470: and (p_final_process_date is null)))
471: and (( p_last_standard_process_date = pps_rec.last_standard_process_date)
472: or (pps_rec.last_standard_process_date is null
473: and (p_last_standard_process_date is null)))
474: and (( p_leaving_reason = pps_rec.leaving_reason)
475: or (pps_rec.leaving_reason is null

Line 472: or (pps_rec.last_standard_process_date is null

468: and (( p_final_process_date = pps_rec.final_process_date)
469: or (pps_rec.final_process_date is null
470: and (p_final_process_date is null)))
471: and (( p_last_standard_process_date = pps_rec.last_standard_process_date)
472: or (pps_rec.last_standard_process_date is null
473: and (p_last_standard_process_date is null)))
474: and (( p_leaving_reason = pps_rec.leaving_reason)
475: or (pps_rec.leaving_reason is null
476: and (p_leaving_reason is null)))

Line 473: and (p_last_standard_process_date is null)))

469: or (pps_rec.final_process_date is null
470: and (p_final_process_date is null)))
471: and (( p_last_standard_process_date = pps_rec.last_standard_process_date)
472: or (pps_rec.last_standard_process_date is null
473: and (p_last_standard_process_date is null)))
474: and (( p_leaving_reason = pps_rec.leaving_reason)
475: or (pps_rec.leaving_reason is null
476: and (p_leaving_reason is null)))
477: and (( p_notified_termination_date = pps_rec.notified_termination_date)

Line 678: ,p_last_standard_process_date DATE

674: ,p_accepted_termination_date DATE
675: ,p_actual_termination_date DATE
676: ,p_comments VARCHAR2
677: ,p_final_process_date DATE
678: ,p_last_standard_process_date DATE
679: ,p_leaving_reason VARCHAR2
680: ,p_notified_termination_date DATE
681: ,p_projected_termination_date DATE
682: ,p_request_id NUMBER

Line 761: ,p_last_standard_process_date

757: ,p_accepted_termination_date
758: ,p_actual_termination_date
759: ,p_comments
760: ,p_final_process_date
761: ,p_last_standard_process_date
762: ,p_leaving_reason
763: ,p_notified_termination_date
764: ,p_projected_termination_date
765: ,p_request_id

Line 845: ,p_last_standard_process_date DATE

841: ,p_accepted_termination_date DATE
842: ,p_actual_termination_date DATE
843: ,p_comments VARCHAR2
844: ,p_final_process_date DATE
845: ,p_last_standard_process_date DATE
846: ,p_leaving_reason VARCHAR2
847: ,p_notified_termination_date DATE
848: ,p_projected_termination_date DATE
849: ,p_request_id NUMBER

Line 1063: if (p_last_standard_process_date IS null

1059: --
1060: IF p_initiate_cancellation <> 'Y' THEN
1061: --
1062: if p_actual_termination_date is not null THEN
1063: if (p_last_standard_process_date IS null
1064: and p_legislation_code <> 'US') THEN
1065: fnd_message.set_name('PAY','HR_7576_ALL_MAN_PRO_FIELD');
1066: app_exception.raise_exception;
1067: end if;

Line 1068: if p_actual_termination_date > p_last_standard_process_date then

1064: and p_legislation_code <> 'US') THEN
1065: fnd_message.set_name('PAY','HR_7576_ALL_MAN_PRO_FIELD');
1066: app_exception.raise_exception;
1067: end if;
1068: if p_actual_termination_date > p_last_standard_process_date then
1069: fnd_message.set_name('PAY','HR_6158_EMP_DATE_CHECK');
1070: app_exception.raise_exception;
1071: end if;
1072: if p_s_final_process_date is null then

Line 1087: ,p_last_standard_process_date

1083: ,p_business_group_id
1084: ,p_person_id
1085: ,p_c_assignment_status_type_id
1086: ,p_actual_termination_date
1087: ,p_last_standard_process_date
1088: ,p_final_process_date);
1089: elsif p_final_process_date is not null then
1090: hrempter.employee_shutdown('PRE_UPDATE'
1091: ,p_person_id

Line 1172: ,p_last_standard_process_date => p_last_standard_process_date

1168: ,p_accepted_termination_date => p_accepted_termination_date
1169: ,p_actual_termination_date => p_actual_termination_date
1170: ,p_comments => p_comments
1171: ,p_final_process_date => p_final_process_date
1172: ,p_last_standard_process_date => p_last_standard_process_date
1173: ,p_leaving_reason => p_leaving_reason
1174: ,p_notified_termination_date => p_notified_termination_date
1175: ,p_projected_termination_date => p_projected_termination_date
1176: ,p_request_id => p_request_id

Line 1278: ,p_last_standard_process_date

1274: ,p_business_group_id
1275: ,p_person_id
1276: ,p_c_assignment_status_type_id
1277: ,p_actual_termination_date
1278: ,p_last_standard_process_date
1279: ,p_final_process_date);
1280: p_requery_required := 'Y';
1281: --
1282: elsif p_final_process_date is not null then

Line 1491: ,p_last_standard_process_date DATE

1487: ,p_accepted_termination_date DATE
1488: ,p_actual_termination_date DATE
1489: ,p_comments VARCHAR2
1490: ,p_final_process_date DATE
1491: ,p_last_standard_process_date DATE
1492: ,p_leaving_reason VARCHAR2
1493: ,p_notified_termination_date DATE
1494: ,p_projected_termination_date DATE
1495: ,p_request_id NUMBER

Line 1626: ,pps.last_standard_process_date = p_last_standard_process_date

1622: ,pps.accepted_termination_date = p_accepted_termination_date
1623: ,pps.actual_termination_date = p_actual_termination_date
1624: ,pps.comments = p_comments
1625: ,pps.final_process_date = p_final_process_date
1626: ,pps.last_standard_process_date = p_last_standard_process_date
1627: ,pps.leaving_reason = p_leaving_reason
1628: ,pps.notified_termination_date = p_notified_termination_date
1629: ,pps.projected_termination_date = p_projected_termination_date
1630: ,pps.request_id = p_request_id