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.SSP_MAT_T1 dependencies on SSP_SMP_PKG

Line 20: l_max_period := ssp_smp_pkg.get_max_SMP_date(:old.maternity_id,:new.due_date,:new.mpp_start_date);

16: BEGIN
17: if ssp_ssp_pkg.ssp_is_installed then
18: l_temp := sysdate;
19: if (nvl(:new.stated_return_date,l_temp) <> nvl(:old.stated_return_date,l_temp)) then
20: l_max_period := ssp_smp_pkg.get_max_SMP_date(:old.maternity_id,:new.due_date,:new.mpp_start_date);
21: if (:old.stated_return_date is null and :new.stated_return_date is not null) OR
22: (:old.stated_return_date is not null and :new.stated_return_date is not null) then
23: if :new.stated_return_date <= l_max_period then
24: ssp_smp_pkg.maternity_control (:old.maternity_id);

Line 24: ssp_smp_pkg.maternity_control (:old.maternity_id);

20: l_max_period := ssp_smp_pkg.get_max_SMP_date(:old.maternity_id,:new.due_date,:new.mpp_start_date);
21: if (:old.stated_return_date is null and :new.stated_return_date is not null) OR
22: (:old.stated_return_date is not null and :new.stated_return_date is not null) then
23: if :new.stated_return_date <= l_max_period then
24: ssp_smp_pkg.maternity_control (:old.maternity_id);
25: end if;
26: end if;
27: end if;
28: if (:old.due_date <> :new.due_date OR

Line 43: ssp_smp_pkg.maternity_control (:old.maternity_id);

39: nvl(:old.LEAVE_TYPE,' ') <> nvl(:new.LEAVE_TYPE,' ') OR
40: nvl(:old.MATCHING_DATE,l_temp) <> nvl(:new.MATCHING_DATE,l_temp) OR
41: nvl(:old.PLACEMENT_DATE,l_temp) <> nvl(:new.PLACEMENT_DATE,l_temp) OR
42: nvl(:old.DISRUPTED_PLACEMENT_DATE,l_temp) <> nvl(:new.DISRUPTED_PLACEMENT_DATE,l_temp)) then
43: ssp_smp_pkg.maternity_control (:old.maternity_id);
44: end if;
45: end if;
46: END;