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 19: l_max_period := ssp_smp_pkg.get_max_SMP_date(:old.maternity_id,:new.due_date,:new.mpp_start_date);

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

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

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

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

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