1 PACKAGE FND_OAM_KBF_SUBS AUTHID CURRENT_USER AS
2 /* $Header: AFOAMSBS.pls 115.12 2002/12/04 20:15:23 rmohan noship $ */
3
4 ---Common Constants
5 COMP_TYPE_UNKNOWN CONSTANT VARCHAR2(7) := 'UNKNOWN';
6
7 /*
8 ** CreateSubList
9 ** Description:
10 ** It is used to retrive WF_ROLES.USER_ID of all the people wants
11 ** to be notified about the exception message.
12 ** It Looks the FND_KBF_SUBSCRIPTION table for matching the USER_ID
13 ** and filter criteria is bnased on
14 ** APPLICATION_ID+COMPONENT_TYPE/BIZ_FLOW_ID, SEVERITY, CATEGORY of
15 ** the message.
16 ** The retrieved list is used to create adHoc WF_ROLE using
17 ** WF_DIRECTORY.CreateAdHocRole api
18 **
19 ** Arguments:
20 ** pItemtype - WF Item Type
21 ** pItemkey - WF Item Key
22 ** pActid - WF Activity ID
23 **
24 ** Returns:
25 ** pResultout - List of subscriber, if there is no user,
26 ** pResultout is set to 'NULL'
27 **
28 **
29 */
30 procedure CreateSubList(itemtype in varchar2,
31 itemkey in varchar2,
32 actid in number,
33 funcmode in varchar2,
34 resultout out NOCOPY varchar2);
35
36
37
38 /*
39 ** createSubject
40 ** Description:
41 ** It retrives Subject for the given document_id(Log sequence)
42 **
43 ** Arguments:
44 ** document_id -
45 ** display_type - text
46 **
47 **
48 ** Returns:
49 ** document - Subject
50 ** document_type - text
51 **
52 */
53 procedure createSubject(document_id in varchar2,
54 display_type in varchar2,
55 document in out NOCOPY varchar2,
56 document_type in out NOCOPY varchar2);
57
58
59
60 /*
61 ** createBusExcepDoc
62 ** Description:
63 ** It retrives the message using FND_LOG.message API for a given message_id
64 **
65 ** Arguments:
66 ** document_id -
67 ** display_type - text
68 **
69 **
70 ** Returns:
71 ** document - Actual Message for the message_id
72 ** document_type - text
73 **
74 */
75 procedure createBusExcepDoc(document_id in varchar2,
76 display_type in varchar2,
77 document in out NOCOPY varchar2,
78 document_type in out NOCOPY varchar2);
79
80
81
82
83 /*
84 ** createBusExcepDoc
85 ** Description:
86 ** It retrives the context information about exception
87 **
88 ** Arguments:
89 ** document_id -
90 ** display_type - text
91 **
92 **
93 ** Returns:
94 ** document - Context information.
95 ** document_type - text
96 **
97 */
98 procedure createBusExcepDocPart1(document_id in varchar2,
99 display_type in varchar2,
100 document in out NOCOPY varchar2,
101 document_type in out NOCOPY varchar2);
102
103
104 --This is for test purpose only
105 --- FUNCTION raise_oamEvent
106 --- (v_comm IN VARCHAR2)
107 --- RETURN VARCHAR2;
108
109 -- FUNCTION SHALL_ADD_SUBS_SEVERITY
110 -- (pItemSub IN VARCHAR2, pItemException IN VARCHAR2)
111 -- RETURN BOOLEAN;
112
113 -- FUNCTION SHALL_ADD_SUBS
114 -- (pItemSub IN VARCHAR2, pItemException IN VARCHAR2)
115 -- RETURN BOOLEAN;
116
117 END FND_OAM_KBF_SUBS;