1 PACKAGE CSM_NOTIFICATION_EVENT_PKG AUTHID CURRENT_USER AS
2 /* $Header: csmentfs.pls 120.9.12020000.3 2013/04/09 10:57:32 saradhak ship $ */
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 --Support for email triggered Sync
33 FUNCTION createMobileWFUser(b_user_name IN VARCHAR2) RETURN BOOLEAN;
34 FUNCTION send_email(b_user_name VARCHAR2, subject VARCHAR2, message_body VARCHAR2) return NUMBER;
35
36 PROCEDURE NOTIFY_USER(entity varchar2, pk_value varchar2,p_mode varchar2) ;
37
38 PROCEDURE NOTIFY_USER(p_wf_param wf_event_t) ;
39
40 --Bug 9435049
41 PROCEDURE NOTIFY_RESPONSE(item_type in varchar2, p_item_key in varchar2,
42 activity_id in number, command in varchar2, resultout in out NOCOPY varchar2);
43
44 FUNCTION NOTIFICATION_TIMER_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
45 RETURN VARCHAR2;
46
47 PROCEDURE notify_deferred(p_user_name IN VARCHAR2,
48 p_tranid IN NUMBER,
49 p_pubitem IN VARCHAR2,
50 p_sequence IN NUMBER,
51 p_dml_type IN VARCHAR2,
52 p_pk IN VARCHAR2,
53 p_error_msg IN VARCHAR2);
54
55 FUNCTION EMAIL_SYNC_ERROR_ADMIN_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
56 RETURN VARCHAR2;
57
58 FUNCTION invoke_WF_NotifyProcess (p_recipient_role IN VARCHAR2, p_wf_param IN wf_event_t) return NUMBER;
59
60 PROCEDURE PURGE_USER(p_user_id IN NUMBER);
61
62 PROCEDURE EMAIL_SYNC_ERRORS_CONC(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2);
63
64 PROCEDURE DOWNLOAD_MULTIPLAT_NFN(p_status OUT NOCOPY VARCHAR2,p_message OUT NOCOPY VARCHAR2);
65
66 END CSM_NOTIFICATION_EVENT_PKG; -- Package spec
67
68