1 package ar_notification_standard as
2 /*$Header: ARNOTSTS.pls 120.2 2005/07/22 12:53:52 naneja noship $ */
3
4 /*Bug 44509019 Removed GSCC warning file.sql.39 used NOCOPY hint for OUT and IN OUT parameter type*/
5 function createUrl(p_function in varchar2) return varchar2;
6
7 procedure build_error_message(document_id in varchar2,
8 display_type in varchar2,
9 document in out NOCOPY varchar2,
10 document_type in out NOCOPY varchar2);
11 /*
12 procedure build_error_message_clob(document_id in varchar2,
13 display_type in varchar2,
14 document in out CLOB,
15 document_type in out varchar2);
16 */
17
18 procedure notify(p_subject in varchar2,
19 p_sqlerrm in varchar2,
20 p_role_name in varchar2,
21 p_url in varchar2 default null);
22
23 procedure notifyToSysadmin(p_subject in varchar2,
24 p_sqlerrm in varchar2,
25 p_url in varchar2 default null);
26
27 procedure parseDocumentId(p_document_id in varchar2,
28 p_item_type out NOCOPY varchar2,
29 p_item_key out NOCOPY varchar2);
30
31 procedure isURLEmpty(ITEMTYPE IN VARCHAR2,
32 ITEMKEY IN VARCHAR2,
33 ACTID IN NUMBER,
34 FUNCMODE IN VARCHAR2,
35 RESULTOUT IN OUT NOCOPY VARCHAR2);
36
37 procedure isMessageEmpty(ITEMTYPE IN VARCHAR2,
38 ITEMKEY IN VARCHAR2,
39 ACTID IN NUMBER,
40 FUNCMODE IN VARCHAR2,
41 RESULTOUT IN OUT NOCOPY VARCHAR2);
42
43 procedure compileMessage(ITEMTYPE IN VARCHAR2,
44 ITEMKEY IN VARCHAR2,
45 ACTID IN NUMBER,
46 FUNCMODE IN VARCHAR2,
47 RESULTOUT IN OUT NOCOPY VARCHAR2);
48
49 procedure raiseNotificationEvent(p_event_name in VARCHAR2,
50 p_subject in VARCHAR2,
51 p_doc_pkg in VARCHAR2,
52 p_doc_proc in VARCHAR2,
53 p_role_name in VARCHAR2,
54 p_url in VARCHAR2 default NULL,
55 p_user_area1 in VARCHAR2 default NULL,
56 p_user_area2 in VARCHAR2 default NULL,
57 p_user_area3 in VARCHAR2 default NULL,
58 p_user_area4 in VARCHAR2 default NULL,
59 p_user_area5 in VARCHAR2 default NULL);
60 end;