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_ABA_T2 dependencies on SSP_SMP_PKG

Line 30: ssp_smp_pkg.absence_control (nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));

26: elsif nvl (:new.maternity_id, :old.maternity_id) is not null then
27: if UPDATING then /* begin bug 5105039 */
28: l_temp := sysdate;
29: if (nvl(:new.date_start,l_temp) <> nvl(:old.date_start,l_temp)) then
30: ssp_smp_pkg.absence_control (nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));
31: elsif nvl(:old.date_end,l_temp) <> nvl(:new.date_end,l_temp) then
32: l_max_period := ssp_smp_pkg.get_max_SMP_date(nvl(:new.maternity_id, :old.maternity_id));
33: if (:old.date_end is null and :new.date_end is not null) or
34: (:old.date_end is not null and :new.date_end is not null) then

Line 32: l_max_period := ssp_smp_pkg.get_max_SMP_date(nvl(:new.maternity_id, :old.maternity_id));

28: l_temp := sysdate;
29: if (nvl(:new.date_start,l_temp) <> nvl(:old.date_start,l_temp)) then
30: ssp_smp_pkg.absence_control (nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));
31: elsif nvl(:old.date_end,l_temp) <> nvl(:new.date_end,l_temp) then
32: l_max_period := ssp_smp_pkg.get_max_SMP_date(nvl(:new.maternity_id, :old.maternity_id));
33: if (:old.date_end is null and :new.date_end is not null) or
34: (:old.date_end is not null and :new.date_end is not null) then
35: if :new.date_end <= l_max_period then
36: ssp_smp_pkg.absence_control(nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));

Line 36: ssp_smp_pkg.absence_control(nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));

32: l_max_period := ssp_smp_pkg.get_max_SMP_date(nvl(:new.maternity_id, :old.maternity_id));
33: if (:old.date_end is null and :new.date_end is not null) or
34: (:old.date_end is not null and :new.date_end is not null) then
35: if :new.date_end <= l_max_period then
36: ssp_smp_pkg.absence_control(nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));
37: end if;
38: elsif :old.date_end is not null and :new.date_end is null then
39: if :old.date_end <= l_max_period then
40: ssp_smp_pkg.absence_control(nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));

Line 40: ssp_smp_pkg.absence_control(nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));

36: ssp_smp_pkg.absence_control(nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));
37: end if;
38: elsif :old.date_end is not null and :new.date_end is null then
39: if :old.date_end <= l_max_period then
40: ssp_smp_pkg.absence_control(nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));
41: end if;
42: end if;
43: end if;
44: else /* end bug 5105039 */

Line 45: ssp_smp_pkg.absence_control(nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));

41: end if;
42: end if;
43: end if;
44: else /* end bug 5105039 */
45: ssp_smp_pkg.absence_control(nvl(:new.maternity_id, :old.maternity_id),p_deleting => (deleting));
46: end if;
47: end if;
48: end if;
49: end if;