1 PACKAGE CSM_NOTIFICATION_EVENT_PKG AS
2 /* $Header: csmentfs.pls 120.2 2006/06/28 07:19:53 saradhak noship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- Ravi Eanjan 27/06/02 1. For sender name will be taken from
10 -- jtf_rs_resource_extns.source_name istead of fnd_user.user_name
11 -- 2. Notification_id is Item Key in Processes
12 -- NOTIFICATION_INS_USERLOOP and NOTIFICATION_DEL_USERLOOP
13 -- --------- ------ ------------------------------------------
14 -- Enter package declarations as shown below
15
16 PROCEDURE INSERT_NOTIFICATIONS_ACC (p_notification_id wf_notifications.notification_id%TYPE,
17 p_user_id fnd_user.user_id%TYPE);
18
19 PROCEDURE NOTIFICATIONS_ACC_PROCESSOR(p_user_id IN NUMBER);
20
21 FUNCTION NOTIFICATION_ATTR_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
22 RETURN VARCHAR2;
23
24 FUNCTION NOTIFICATION_DEL_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
25 RETURN VARCHAR2;
26
27 PROCEDURE PURGE_NOTIFICATION_CONC(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2);
28
29 --Bug 5337816
30 PROCEDURE DOWNLOAD_NOTIFICATION(p_notification_id IN NUMBER ,x_return_status OUT NOCOPY VARCHAR2);
31
32 END CSM_NOTIFICATION_EVENT_PKG; -- Package spec
33
34