1 package IBE_WF_MSG_MAPPING_PVT 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;