1 PACKAGE CLN_NP_UTILS_PKG AUTHID CURRENT_USER AS
2 /* $Header: CLNNPUTLS.pls 115.0 2003/10/31 07:20:48 vumapath noship $ */
3 -- Package
4 -- CLN_NP_UTILS_PKG
5 --
6 -- Purpose
7 -- Specification of package specification: CLN_NP_UTILS_PKG.
8 -- This package bundles all the utility functions of
9 -- notification Processing module for processing inbound messages
10 --
11 -- History
12 -- Oct-16-2003 Viswanthan Umapathy Created
13
14
15
16 -- Name
17 -- UPDATE_COLLABORATION
18 -- Purpose
19 -- This procedure raises collaboration update event to update a collaboration.
20 -- passing all the procedure parameters as event parameters
21 -- Arguments
22 --
23 -- Notes
24 -- No specific notes.
25
26 PROCEDURE UPDATE_COLLABORATION(
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_ref_id IN VARCHAR2,
30 p_doc_no IN VARCHAR2,
31 p_part_doc_no IN VARCHAR2,
32 p_msg_text IN VARCHAR2,
33 p_status_code IN NUMBER,
34 p_int_ctl_num IN NUMBER,
35 p_tp_header_id IN NUMBER);
36
37
38
39 -- Name
40 -- ADD_COLLABORATION_MESSAGE
41 -- Purpose
42 -- This procedure raise event to add messages into collaboration history
43 -- passing all the procedure parameters as event parameters
44 -- Arguments
45 -- Internal Control Number
46 -- Reference 1 to 5
47 -- Message Text
48 -- Notes
49 -- No specific notes.
50
51 PROCEDURE ADD_COLLABORATION_MESSAGE(
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_ictrl_no IN NUMBER,
55 p_ref1 IN VARCHAR2,
56 p_ref2 IN VARCHAR2,
57 p_ref3 IN VARCHAR2,
58 p_ref4 IN VARCHAR2,
59 p_ref5 IN VARCHAR2,
60 p_dtl_msg IN VARCHAR2);
61
62
63
64 -- Name
65 -- GET_FND_MESSSAGE
66 -- Purpose
67 -- Gets the FND message for the given message name
68 -- substituting the token values
69 -- Arguments
70 -- FND message name
71 -- Token Name
72 -- Token Value
73 -- Notes
74 -- No specific notes
75
76 PROCEDURE GET_FND_MESSSAGE(
77 p_fnd_message_name IN VARCHAR2,
78 p_token_name1 IN VARCHAR2,
79 p_token_value1 IN VARCHAR2,
80 p_token_name2 IN VARCHAR2,
81 p_token_value2 IN VARCHAR2,
82 p_message OUT NOCOPY VARCHAR2);
83
84
85
86 -- Name
87 -- CALL_TAKE_ACTIONS
88 -- Purpose
89 -- Invokes Notification Processor TAKE_ACTIONS according to the parameter.
90 -- Arguments
91 -- Notes
92 -- No specific notes.
93
94 PROCEDURE CALL_TAKE_ACTIONS(
95 p_itemtype IN VARCHAR2,
96 p_itemkey IN VARCHAR2,
97 p_actid IN NUMBER,
98 p_funcmode IN VARCHAR2,
99 x_resultout IN OUT NOCOPY VARCHAR2);
100
101
102 END CLN_NP_UTILS_PKG;