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 97: p_last_standard_process_date IN OUT NOCOPY DATE) is

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

Line 113: , p_last_standard_process_date

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

Line 144: ,p_last_standard_process_date DATE

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

Line 200: ,last_standard_process_date

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

Line 241: ,p_last_standard_process_date

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

Line 309: ,p_last_standard_process_date DATE

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

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

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

Line 471: or (pps_rec.last_standard_process_date is null

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

Line 472: and (p_last_standard_process_date is null)))

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

Line 677: ,p_last_standard_process_date DATE

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

Line 760: ,p_last_standard_process_date

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

Line 844: ,p_last_standard_process_date DATE

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

Line 1062: if (p_last_standard_process_date IS null

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

Line 1067: if p_actual_termination_date > p_last_standard_process_date then

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

Line 1086: ,p_last_standard_process_date

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

Line 1171: ,p_last_standard_process_date => p_last_standard_process_date

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

Line 1277: ,p_last_standard_process_date

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

Line 1490: ,p_last_standard_process_date DATE

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

Line 1625: ,pps.last_standard_process_date = p_last_standard_process_date

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