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.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_PROFILE_PKG

Line 83: (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)

79: asg_user au
80: WHERE au.user_id=b_user_id
81: AND au.user_name IN (FROM_ROLE,RECIPIENT_ROLE)
82: AND (nvl(wfn.begin_date, sysdate) between
83: (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)
84: AND NOT EXISTS(SELECT 1
85: FROM CSM_NOTIFICATIONS_ACC ACC
86: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
87: AND ACC.USER_ID = AU.USER_ID);

Line 99: (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)

95: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'
96: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))
97: AND au.enabled='Y'
98: AND (nvl(wfn.begin_date, sysdate) between
99: (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)
100: AND NOT EXISTS(SELECT 1
101: FROM CSM_NOTIFICATIONS_ACC ACC
102: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
103: AND ACC.USER_ID = AU.USER_ID);

Line 145: (sysdate - csm_profile_pkg.get_task_history_days(au.user_id))and sysdate)

141: WHERE wfn.NOTIFICATION_ID=b_nid
142: AND au.user_name IN (WFN.FROM_ROLE,WFN.RECIPIENT_ROLE)
143: AND au.enabled='Y'
144: AND (nvl(wfn.begin_date, sysdate) between
145: (sysdate - csm_profile_pkg.get_task_history_days(au.user_id))and sysdate)
146: AND NOT EXISTS(SELECT 1
147: FROM CSM_NOTIFICATIONS_ACC ACC
148: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
149: AND ACC.USER_ID = AU.USER_ID);

Line 161: (sysdate - csm_profile_pkg.get_task_history_days(au.user_id))and sysdate)

157: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'
158: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))
159: AND au.enabled='Y'
160: AND (nvl(wfn.begin_date, sysdate) between
161: (sysdate - csm_profile_pkg.get_task_history_days(au.user_id))and sysdate)
162: AND NOT EXISTS(SELECT 1
163: FROM CSM_NOTIFICATIONS_ACC ACC
164: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
165: AND ACC.USER_ID = AU.USER_ID);

Line 312: < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)));

308: FROM csm_notifications_acc acc,
309: wf_notifications wfn
310: WHERE acc.notification_id = wfn.notification_id
311: AND (NVL(wfn.begin_date, SYSDATE)
312: < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)));
313:
314: TYPE l_purge_notf_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
315: l_purge_notf_tbl l_purge_notf_tbl_type;
316: TYPE l_purge_userid_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;