PACKAGE: APPS.IBE_WF_MSG_MAPPING_PVT

Source

1 package IBE_WF_MSG_MAPPING_PVT AUTHID CURRENT_USER as
2 /* $Header: IBEVWMMS.pls 120.0 2005/05/30 02:52:09 appldev noship $ */
3 
4     TYPE t_genref IS REF CURSOR;
5 
6     G_PKG_NAME      CONSTANT VARCHAR2(30) := 'IBE_WF_MSG_MAPPING_PVT';
7 
8     TYPE WFMSG_REC_TYPE IS RECORD(
9 	notif_msg_map_ID 	NUMBER := FND_API.G_MISS_NUM,
10 	notif_setup_id		NUMBER := FND_API.G_MISS_NUM,
11 	message_name		VARCHAR2(30) := FND_API.G_MISS_CHAR,
12 	enabled_flag		VARCHAR2(1),
13 	msite_id		NUMBER,
14 	org_id			NUMBER,
15 	user_type		VARCHAR2(30),
16 	all_msite_flag		VARCHAR2(1),
17 	all_org_flag		VARCHAR2(1),
18 	all_user_type_flag	VARCHAR2(1)
19     );
20 
21     Type WFMSG_TBL_TYPE IS TABLE of WFMSG_REC_TYPE INDEX BY BINARY_INTEGER;
22 
23 -- Start of comments
24 --    API name   : Retrieve_Msg_Mapping
25 --    Type       : Private.
26 --    Function   : Get the message mapping for the specified parameters
27 --    Pre-reqs   : None.
28 --    Parameters :
29 --    IN         : p_org_id                            IN NUMBER
30 --                 p_msite_id                          IN Number
31 --		   p_user_type		               IN VARCHAR2
32 --		   p_enabled_flag		       IN VARCHAR2
33 --		   p_notif_setup_id		       IN NUMBER
34 --
35 --    OUT        : x_msg_map_name           	       OUT VARCHAR2
36 --               : x_msg_data           	       OUT VARCHAR2
37 --               : x_msg_count           	       OUT VARCHAR2
38 --               : x_return_status           	       OUT VARCHAR2
39 
40 --
41 --    Version    : Current version      1.0
42 --                 previous version     None
43 --                 Initial version      1.0
44 --    Notes      : Note text
45 --
46 -- End of comments
47     procedure Retrieve_Msg_Mapping
48     (
49 	p_org_id		IN  NUMBER,
50 	p_msite_id		IN  NUMBER,
51 	p_user_type		IN  VARCHAR2,
52 	x_enabled_flag  	OUT NOCOPY VARCHAR2,
53 	p_notif_name		IN  VARCHAR2,
54 	x_wf_message_name	OUT NOCOPY VARCHAR2,
55 	x_return_status		OUT NOCOPY VARCHAR2,
56 	x_msg_data		OUT NOCOPY VARCHAR2,
57 	x_msg_count		OUT NOCOPY NUMBER
58     );
59 
60 
61         procedure Get_Notif_Metadata
62         (
63 	    x_msg_count		OUT NOCOPY NUMBER,
64 	    x_msg_data		OUT NOCOPY VARCHAR2,
65 	    x_return_status	OUT NOCOPY VARCHAR2,
66             x_notif_setup_id	OUT NOCOPY NUMBER,
67             p_notification_name IN  VARCHAR2,
68             x_org_id_flag       OUT NOCOPY VARCHAR2,
69             x_msite_id_flag     OUT NOCOPY VARCHAR2,
70             x_user_type_flag    OUT NOCOPY VARCHAR2,
71             x_enabled_flag      OUT NOCOPY VARCHAR2
72         );
73 
74 end IBE_WF_MSG_MAPPING_PVT;