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 HR_GENERAL

Line 72: actual_end_date, NVL(provisional_end_date,HR_GENERAL.end_of_time)

68: p_actual_end DATE,
69: p_person_id NUMBER) IS
70: SELECT emp_stat_situation_id, statutory_situation_id, object_version_number,
71: actual_start_date, provisional_start_date,
72: actual_end_date, NVL(provisional_end_date,HR_GENERAL.end_of_time)
73: FROM pqh_fr_emp_stat_situations
74: WHERE person_id = p_person_id
75: AND statutory_situation_id IN (SELECT statutory_situation_id
76: FROM pqh_fr_stat_situations_v sit

Line 80: AND sit.business_group_id = HR_GENERAL.get_business_group_id

76: FROM pqh_fr_stat_situations_v sit
77: ,per_shared_types_vl sh
78: WHERE sh.shared_type_id = type_of_ps
79: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
80: AND sit.business_group_id = HR_GENERAL.get_business_group_id
81: AND sit.default_flag = 'Y'
82: AND sit.situation_type = 'IA'
83: AND sit.sub_type = 'IA_N'
84: AND TRUNC(NVL(p_actual_start,p_provisional_start)) BETWEEN

Line 85: sit.date_from AND NVL(sit.date_to,HR_GENERAL.end_of_time))

81: AND sit.default_flag = 'Y'
82: AND sit.situation_type = 'IA'
83: AND sit.sub_type = 'IA_N'
84: AND TRUNC(NVL(p_actual_start,p_provisional_start)) BETWEEN
85: sit.date_from AND NVL(sit.date_to,HR_GENERAL.end_of_time))
86: AND(TRUNC(NVL(actual_start_date,provisional_start_date)) <= TRUNC(NVL(p_actual_start,p_provisional_start))
87: AND TRUNC(NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time)))
88: >= TRUNC(NVL(p_actual_end,p_provisional_end)));
89: --

Line 87: AND TRUNC(NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time)))

83: AND sit.sub_type = 'IA_N'
84: AND TRUNC(NVL(p_actual_start,p_provisional_start)) BETWEEN
85: sit.date_from AND NVL(sit.date_to,HR_GENERAL.end_of_time))
86: AND(TRUNC(NVL(actual_start_date,provisional_start_date)) <= TRUNC(NVL(p_actual_start,p_provisional_start))
87: AND TRUNC(NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time)))
88: >= TRUNC(NVL(p_actual_end,p_provisional_end)));
89: --
90: --Cursor for Overlapping non In Activity Normal Default Situations
91: CURSOR csr_overlaps(p_provisional_start DATE,

Line 107: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))

103: -- AND emp_stat_situation_id <> NVL(p_emp_stat_situation_id,-1)
104: AND statutory_situation_id <> p_iand_stat_sit_id
105: AND(NVL(p_actual_start,p_provisional_start)
106: BETWEEN NVL(actual_start_date,provisional_start_date)
107: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))
108: OR NVL(p_actual_end,p_provisional_end)
109: BETWEEN NVL(actual_start_date,provisional_start_date)
110: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))));
111: --

Line 110: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))));

106: BETWEEN NVL(actual_start_date,provisional_start_date)
107: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))
108: OR NVL(p_actual_end,p_provisional_end)
109: BETWEEN NVL(actual_start_date,provisional_start_date)
110: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))));
111: --
112: --Variable Declaration
113: l_iand_emp_stat_sit_id PQH_FR_EMP_STAT_SITUATIONS.emp_stat_situation_id%TYPE;
114: l_iand_stat_sit_id PQH_FR_EMP_STAT_SITUATIONS.statutory_situation_id%TYPE;

Line 273: ,p_provisional_end_date => NVL(l_iand_prv_end_dt,hr_general.end_of_time)

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
272: ,p_provisional_start_date => TRUNC(NVL(p_actual_end_date,p_provisional_end_date)+1)
273: ,p_provisional_end_date => NVL(l_iand_prv_end_dt,hr_general.end_of_time)
274: ,p_actual_start_date => TRUNC(NVL(p_actual_end_date,p_provisional_end_date)+1)
275: ,p_actual_end_date => NVL(l_iand_act_end_dt,hr_general.end_of_time)
276: ,p_approval_flag => 'Y'
277: ,p_comments => p_comments

Line 275: ,p_actual_end_date => NVL(l_iand_act_end_dt,hr_general.end_of_time)

271: ,p_person_id => p_person_id
272: ,p_provisional_start_date => TRUNC(NVL(p_actual_end_date,p_provisional_end_date)+1)
273: ,p_provisional_end_date => NVL(l_iand_prv_end_dt,hr_general.end_of_time)
274: ,p_actual_start_date => TRUNC(NVL(p_actual_end_date,p_provisional_end_date)+1)
275: ,p_actual_end_date => NVL(l_iand_act_end_dt,hr_general.end_of_time)
276: ,p_approval_flag => 'Y'
277: ,p_comments => p_comments
278: ,p_object_version_number => l_new_sit_ovn);
279: IF HR_MULTI_MESSAGE.get_return_status = 'E' THEN

Line 415: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))

411: WHERE person_id = p_person_id
412: AND emp_stat_situation_id <> NVL(p_emp_stat_situation_id,-1)
413: AND statutory_situation_id <> p_iand_stat_sit_id
414: AND(p_provisional_start BETWEEN NVL(actual_start_date,provisional_start_date)
415: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))
416: OR p_provisional_end BETWEEN NVL(actual_start_date,provisional_start_date)
417: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))));
418: --
419: --Variable Declaration

Line 417: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))));

413: AND statutory_situation_id <> p_iand_stat_sit_id
414: AND(p_provisional_start BETWEEN NVL(actual_start_date,provisional_start_date)
415: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))
416: OR p_provisional_end BETWEEN NVL(actual_start_date,provisional_start_date)
417: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time))));
418: --
419: --Variable Declaration
420: l_proc VARCHAR2(72) := g_package||'update_emp_stat_situation';
421: l_validate BOOLEAN;

Line 504: (p_business_group_id => HR_GENERAL.get_business_group_id

500: CLOSE csr_get_next_sit_dtls;
501: --
502: --Get In Activity Normal Default Situation Id
503: l_iand_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation
504: (p_business_group_id => HR_GENERAL.get_business_group_id
505: ,p_effective_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))
506: ,p_situation_type => 'IA'
507: ,p_sub_type => 'IA_N');
508: IF l_iand_sit_id = -1 THEN

Line 603: IF TRUNC(p_provisional_end_date) <> TRUNC(NVL(l_act_end_dt,NVL(l_prov_end_dt,HR_GENERAL.end_of_time))) THEN

599: IF HR_MULTI_MESSAGE.get_return_status = 'E' THEN
600: RAISE HR_MULTI_MESSAGE.error_message_exist;
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

Line 640: IF TRUNC(p_provisional_end_date) < TRUNC(NVL(l_act_end_dt,NVL(l_prov_end_dt,HR_GENERAL.end_of_time))) THEN

636: RAISE HR_MULTI_MESSAGE.error_message_exist;
637: END IF;
638: END IF;
639: --
640: IF TRUNC(p_provisional_end_date) < TRUNC(NVL(l_act_end_dt,NVL(l_prov_end_dt,HR_GENERAL.end_of_time))) THEN
641: --Update Assignment to from updated end date till original end date.
642: updt_assign(l_person_id
643: ,l_iand_sit_id
644: ,l_iand_sit_id

Line 646: ,TRUNC(NVL(l_act_end_dt,NVL(l_prov_end_dt,HR_GENERAL.end_of_time))));

642: updt_assign(l_person_id
643: ,l_iand_sit_id
644: ,l_iand_sit_id
645: ,TRUNC(p_provisional_end_date+1)
646: ,TRUNC(NVL(l_act_end_dt,NVL(l_prov_end_dt,HR_GENERAL.end_of_time))));
647: IF HR_MULTI_MESSAGE.get_return_status = 'E' THEN
648: RAISE HR_MULTI_MESSAGE.error_message_exist;
649: END IF;
650: END IF;

Line 736: (p_business_group_id => HR_GENERAL.get_business_group_id

732: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);
733: --
734: --Get In Activity Normal Default Situation Id
735: l_reinstate_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation
736: (p_business_group_id => HR_GENERAL.get_business_group_id
737: ,p_effective_date => p_reinstate_date
738: ,p_situation_type => 'IA'
739: ,p_sub_type => 'IA_N');
740: IF l_reinstate_sit_id = -1 THEN

Line 889: AND sit.business_group_id = HR_GENERAL.get_business_group_id

885: FROM pqh_fr_stat_situations_v sit
886: ,per_shared_types_vl sh
887: WHERE sh.shared_type_id = type_of_ps
888: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
889: AND sit.business_group_id = HR_GENERAL.get_business_group_id
890: AND sit.default_flag = 'Y'
891: AND sit.situation_type = 'IA'
892: AND sit.sub_type = 'IA_N'
893: AND TRUNC(p_end_date+1) BETWEEN

Line 894: sit.date_from AND NVL(sit.date_to,HR_GENERAL.end_of_time))

890: AND sit.default_flag = 'Y'
891: AND sit.situation_type = 'IA'
892: AND sit.sub_type = 'IA_N'
893: AND TRUNC(p_end_date+1) BETWEEN
894: sit.date_from AND NVL(sit.date_to,HR_GENERAL.end_of_time))
895: AND TRUNC(NVL(actual_start_date,provisional_start_date)) = TRUNC(p_end_date+1);
896: --
897: --Variable Declaration
898: l_proc VARCHAR2(72) := g_package||'renew_emp_stat_situation';

Line 1000: IF l_renew_end_date > NVL(l_iand_act_end_date,NVL(l_iand_prov_end_date,HR_GENERAL.end_of_time)) THEN

996: END IF;
997: CLOSE csr_get_iand_dtls;
998: --
999: --Check whether IAND exists for entire duration of the Renewal.
1000: IF l_renew_end_date > NVL(l_iand_act_end_date,NVL(l_iand_prov_end_date,HR_GENERAL.end_of_time)) THEN
1001: FND_MESSAGE.set_name('PQH','FR_PQH_IAND_NOT_FND'); --Cannot Renew/Reinstate because this Situation has already been Renewed or Reinstated.
1002: HR_MULTI_MESSAGE.ADD;
1003: RAISE HR_MULTI_MESSAGE.error_message_exist;
1004: END IF;

Line 1063: ,p_end_date => TRUNC(NVL(l_iand_act_end_date,NVL(l_iand_prov_end_date,HR_GENERAL.end_of_time))));

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))));
1064: IF HR_MULTI_MESSAGE.get_return_status = 'E' THEN
1065: RAISE HR_MULTI_MESSAGE.error_message_exist;
1066: END IF;
1067: --

Line 1208: (p_business_group_id => HR_GENERAL.get_business_group_id

1204: CLOSE csr_get_next_sit_dtls;
1205: --
1206: --Get In Activity Normal Default Situation Id
1207: l_iand_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation
1208: (p_business_group_id => HR_GENERAL.get_business_group_id
1209: ,p_effective_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))
1210: ,p_situation_type => 'IA'
1211: ,p_sub_type => 'IA_N');
1212: IF l_iand_sit_id = -1 THEN

Line 1266: IF TRUNC(NVL(l_act_end_dt,HR_GENERAL.end_of_time)) = TRUNC(HR_GENERAL.end_of_time) THEN

1262: --Else if prior Situation is not a IAND Situation and future Situation is a IAND 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

Line 1460: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time));

1456: SELECT statutory_situation_id
1457: FROM pqh_fr_emp_stat_situations
1458: WHERE person_id = p_person_id
1459: AND p_effective_date BETWEEN NVL(actual_start_date,provisional_start_date)
1460: AND NVL(actual_end_date,NVL(provisional_end_date,HR_GENERAL.end_of_time));
1461: --
1462: --Varialbe Declarations.
1463: l_default_sit_id PQH_FR_EMP_STAT_SITUATIONS.statutory_situation_id%TYPE;
1464: l_sit_id PQH_FR_EMP_STAT_SITUATIONS.statutory_situation_id%TYPE;

Line 1483: (p_business_group_id => HR_GENERAL.get_business_group_id

1479: END IF;
1480: --
1481: --Get In Activity Normal Default Situation Id.
1482: l_default_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation
1483: (p_business_group_id => HR_GENERAL.get_business_group_id
1484: ,p_effective_date => p_effective_date
1485: ,p_situation_type => 'IA'
1486: ,p_sub_type => 'IA_N');
1487: --If Default Situation does not exist then return error.