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.PQH_FR_EMP_STAT_SIT_UTILITY dependencies on PQH_FR_EMP_STAT_SITUATION_API

Line 189: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

185: END IF;
186:
187: --
188: --End date IAND situation (IAND = In Activity Normal Default)
189: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
190: (p_effective_date => p_effective_date
191: ,p_emp_stat_situation_id => l_iand_emp_stat_sit_id --Update this IAND rec
192: ,p_statutory_situation_id => l_iand_stat_sit_id
193: ,p_provisional_end_date => TRUNC(NVL(p_actual_start_date,p_provisional_start_date)-1)

Line 212: pqh_fr_emp_stat_situation_api.create_emp_stat_situation

208: END IF;
209: END IF;
210: --
211: --Create the new Situation
212: pqh_fr_emp_stat_situation_api.create_emp_stat_situation
213: (p_validate => l_validate
214: ,p_effective_date => p_effective_date
215: ,p_statutory_situation_id => p_statutory_situation_id
216: ,p_person_id => p_person_id

Line 267: pqh_fr_emp_stat_situation_api.create_emp_stat_situation

263: RAISE HR_MULTI_MESSAGE.error_message_exist;
264: END IF;
265: --
266: --Create IAND with start date as (end date+1) of new Situation and end date as current IAND end date
267: pqh_fr_emp_stat_situation_api.create_emp_stat_situation
268: (p_effective_date => p_effective_date
269: ,p_emp_stat_situation_id => l_new_iand_emp_stat_sit_id
270: ,p_statutory_situation_id => l_iand_stat_sit_id
271: ,p_person_id => p_person_id

Line 537: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

533: END IF;
534: --
535: IF TRUNC(p_provisional_start_date) <> TRUNC(NVL(l_act_st_dt,l_prov_st_dt)) THEN
536: --Call API to update Prior IAND Situations End Date to current situations updated Start Date - 1.
537: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
538: (p_effective_date => TRUNC(NVL(l_prior_act_st_date,l_prior_prov_st_date))
539: ,p_emp_stat_situation_id => l_prior_emp_stat_sit_id --Update this IAND rec
540: ,p_statutory_situation_id => l_prior_sit_id
541: ,p_provisional_end_date => TRUNC(p_provisional_start_date-1)

Line 551: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

547: END IF;
548: END IF;
549: --
550: --Call API to update current Situation
551: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
552: (p_validate => l_validate
553: ,p_effective_date => p_effective_date
554: ,p_emp_stat_situation_id => p_emp_stat_situation_id
555: ,p_statutory_situation_id => p_statutory_situation_id

Line 605: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

601: END IF;
602: --
603: IF TRUNC(p_provisional_end_date) <> TRUNC(NVL(l_act_end_dt,NVL(l_prov_end_dt,HR_GENERAL.end_of_time))) THEN
604: --Call API to update next IAND Situations Start Date to current situations updated End Date + 1.
605: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
606: (p_effective_date => TRUNC(NVL(l_next_act_st_date,l_next_prov_st_date))
607: ,p_emp_stat_situation_id => l_next_emp_stat_sit_id --Update this IAND rec
608: ,p_statutory_situation_id => l_next_sit_id
609: ,p_provisional_start_date => TRUNC(p_provisional_end_date+1)

Line 780: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

776: --Assign the current Situation OVN number. Required for update.
777: l_upd_sit_ovn := lr_currec.object_version_number;
778: --
779: --Update current Situation to end on (Reinstate Date - 1)
780: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
781: (p_emp_stat_situation_id => p_emp_stat_situation_id
782: ,p_effective_date => TRUNC(p_reinstate_date-1)
783: ,p_object_version_number => l_upd_sit_ovn
784: ,p_actual_end_date => TRUNC(p_reinstate_date-1));

Line 790: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

786: RAISE HR_MULTI_MESSAGE.error_message_exist;
787: END IF;
788: --
789: --Update Start Date of IAND situation (IAND = In Activity Normal Default)
790: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
791: (p_effective_date => TRUNC(p_reinstate_date)
792: ,p_emp_stat_situation_id => l_iand_emp_stat_sit_id --Update this IAND rec
793: ,p_statutory_situation_id => l_reinstate_sit_id
794: ,p_provisional_start_date => TRUNC(p_reinstate_date)

Line 1007: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

1003: RAISE HR_MULTI_MESSAGE.error_message_exist;
1004: END IF;
1005: --
1006: --Update Actual End Date of current/most recent renewal situation.
1007: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
1008: (p_effective_date => l_renew_start_date
1009: ,p_emp_stat_situation_id => l_rn_emp_stat_sit_id
1010: ,p_actual_end_date => TRUNC(l_renew_start_date)
1011: ,p_object_version_number => l_rn_ovn);

Line 1017: pqh_fr_emp_stat_situation_api.create_emp_stat_situation

1013: RAISE HR_MULTI_MESSAGE.error_message_exist;
1014: END IF;
1015: --
1016: --Create a new Renewal Situation record for the Renew duration.
1017: pqh_fr_emp_stat_situation_api.create_emp_stat_situation
1018: (p_effective_date => TRUNC(l_renew_start_date+1)
1019: ,p_emp_stat_situation_id => l_new_emp_sit_id
1020: ,p_statutory_situation_id => l_rn_stat_sit_id
1021: ,p_person_id => l_rn_person_id

Line 1034: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

1030: RAISE HR_MULTI_MESSAGE.error_message_exist;
1031: END IF;
1032: --
1033: --Update Start Date of IAND situation (IAND = In Activity Normal Default)
1034: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
1035: (p_effective_date => TRUNC(l_renew_end_date+1)
1036: ,p_emp_stat_situation_id => l_iand_emp_stat_sit_id --Update this IAND rec
1037: ,p_statutory_situation_id => l_iand_stat_sit_id
1038: ,p_provisional_start_date => TRUNC(l_renew_end_date+1)

Line 1059: pqh_fr_emp_stat_situation_api.update_assignments

1055: END IF;
1056: --
1057: /*
1058: --Update_assignment to reflect the Renewal.
1059: pqh_fr_emp_stat_situation_api.update_assignments
1060: (p_person_id => l_rn_person_id
1061: ,p_statutory_situation_id => l_iand_stat_sit_id
1062: ,p_start_date => TRUNC(l_renew_end_date+1)
1063: ,p_end_date => TRUNC(NVL(l_iand_act_end_date,NVL(l_iand_prov_end_date,HR_GENERAL.end_of_time))));

Line 1219: pqh_fr_emp_stat_situation_api.delete_emp_stat_situation

1215: RAISE HR_MULTI_MESSAGE.error_message_exist;
1216: END IF;
1217: --
1218: --Call API to delete the current Situation
1219: pqh_fr_emp_stat_situation_api.delete_emp_stat_situation
1220: (p_validate => l_validate
1221: ,p_emp_stat_situation_id => p_emp_stat_situation_id
1222: ,p_object_version_number => p_object_version_number);
1223: IF HR_MULTI_MESSAGE.get_return_status = 'E' THEN

Line 1241: pqh_fr_emp_stat_situation_api.delete_emp_stat_situation

1237: --If previous Situation is a IAND situation and future Situation is a IAND situation.
1238: IF l_prior_sit_id = l_iand_sit_id AND l_next_sit_id = l_iand_sit_id THEN
1239: --
1240: --Call API to delete the next IAND situation.
1241: pqh_fr_emp_stat_situation_api.delete_emp_stat_situation
1242: (p_validate => l_validate
1243: ,p_emp_stat_situation_id => l_next_emp_stat_sit_id
1244: ,p_object_version_number => l_next_ovn);
1245: IF HR_MULTI_MESSAGE.get_return_status = 'E' THEN

Line 1250: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

1246: RAISE HR_MULTI_MESSAGE.error_message_exist;
1247: END IF;
1248: --
1249: --Update prior situations end date to next IAND's end date.
1250: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
1251: (p_effective_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))
1252: ,p_emp_stat_situation_id => l_prior_emp_stat_sit_id --Update this IAND rec
1253: ,p_statutory_situation_id => l_prior_sit_id
1254: ,p_provisional_end_date => TRUNC(l_next_prov_end_date)

Line 1267: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

1263: ELSIF l_prior_sit_id <> l_iand_sit_id AND l_next_sit_id = l_iand_sit_id THEN
1264: --
1265: --Update prior sits actual end date to end of time, if deleted sits actual end date is end of time.
1266: IF TRUNC(NVL(l_act_end_dt,HR_GENERAL.end_of_time)) = TRUNC(HR_GENERAL.end_of_time) THEN
1267: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
1268: (p_effective_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))
1269: ,p_emp_stat_situation_id => l_prior_emp_stat_sit_id --Update this IAND rec
1270: ,p_statutory_situation_id => l_prior_sit_id
1271: ,p_actual_end_date => TRUNC(l_act_end_dt)

Line 1280: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

1276: END IF;
1277: END IF;
1278: --
1279: --Update the Next IAND Situation's start date to deleted Situations start date
1280: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
1281: (p_effective_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))
1282: ,p_emp_stat_situation_id => l_next_emp_stat_sit_id --Update this IAND rec
1283: ,p_statutory_situation_id => l_next_sit_id
1284: ,p_provisional_start_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))

Line 1296: pqh_fr_emp_stat_situation_api.create_emp_stat_situation

1292: --Else if prior Situation is not a IAND Situation and future Situation is not a IAND Situation.
1293: ELSIF l_prior_sit_id <> l_iand_sit_id AND l_next_sit_id <> l_iand_sit_id THEN
1294: --
1295: --Create a IAND Situation for the duration of Delete Siutation.
1296: pqh_fr_emp_stat_situation_api.create_emp_stat_situation
1297: (p_effective_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))
1298: ,p_emp_stat_situation_id => l_new_iand_emp_stat_sit_id
1299: ,p_statutory_situation_id => l_iand_sit_id
1300: ,p_person_id => l_person_id

Line 1315: pqh_fr_emp_stat_situation_api.update_emp_stat_situation

1311: --Else if prior Situation is a IAND Situation and future Situation is not a IAND Situation.
1312: ELSIF l_prior_sit_id = l_iand_sit_id AND l_next_sit_id <> l_iand_sit_id THEN
1313: --
1314: --Update the prior IAND Situation's end date to deleted Situations end date
1315: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
1316: (p_effective_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))
1317: ,p_emp_stat_situation_id => l_prior_emp_stat_sit_id --Update this IAND rec
1318: ,p_statutory_situation_id => l_prior_sit_id
1319: ,p_provisional_end_date => TRUNC(NVL(l_act_end_dt,l_prov_end_dt))

Line 1396: pqh_fr_emp_stat_situation_api.update_assignments

1392: --Check whether Assignment starts before the Situation.
1393: IF lr_asg.per_system_status <> 'ACTIVE_ASSIGN' AND TRUNC(p_start_date) > TRUNC(l_start_date) THEN
1394: --
1395: --Set prior Assignment to Active on its effective date date.
1396: pqh_fr_emp_stat_situation_api.update_assignments
1397: (p_person_id => p_person_id
1398: ,p_statutory_situation_id => p_iand_stat_sit_id
1399: ,p_start_date => TRUNC(l_start_date)
1400: ,p_end_date => TRUNC(l_end_date));

Line 1411: pqh_fr_emp_stat_situation_api.update_assignments

1407: l_start_date := p_start_date;
1408: END IF;
1409: --
1410: --Update all Assignments withing the Situation Duration to reflect Situation Status.
1411: pqh_fr_emp_stat_situation_api.update_assignments
1412: (p_person_id => p_person_id
1413: ,p_statutory_situation_id => p_statutory_situation_id
1414: ,p_start_date => TRUNC(l_start_date)
1415: ,p_end_date => TRUNC(l_end_date));

Line 1419: pqh_fr_emp_stat_situation_api.update_assignments

1415: ,p_end_date => TRUNC(l_end_date));
1416: --
1417: IF TRUNC(p_end_date) < TRUNC(l_end_date) THEN
1418: --
1419: pqh_fr_emp_stat_situation_api.update_assignments
1420: (p_person_id => p_person_id
1421: ,p_statutory_situation_id => p_iand_stat_sit_id
1422: ,p_start_date => TRUNC(p_end_date+1)
1423: ,p_end_date => TRUNC(l_end_date));

Line 1431: pqh_fr_emp_stat_situation_api.update_assignments

1427: END LOOP;
1428: --
1429: --If no Assignment are within Situation duration then Update Assignment just once for Situation.
1430: IF l_count = 0 THEN
1431: pqh_fr_emp_stat_situation_api.update_assignments
1432: (p_person_id => p_person_id
1433: ,p_statutory_situation_id => p_statutory_situation_id
1434: ,p_start_date => TRUNC(p_start_date)
1435: ,p_end_date => TRUNC(p_end_date));

Line 1437: pqh_fr_emp_stat_situation_api.update_assignments

1433: ,p_statutory_situation_id => p_statutory_situation_id
1434: ,p_start_date => TRUNC(p_start_date)
1435: ,p_end_date => TRUNC(p_end_date));
1436: --
1437: pqh_fr_emp_stat_situation_api.update_assignments
1438: (p_person_id => p_person_id
1439: ,p_statutory_situation_id => p_iand_stat_sit_id
1440: ,p_start_date => TRUNC(p_end_date+1));
1441: END IF;