[Home] [Help]
PACKAGE: APPS.AMS_ACT_MESSAGES_PVT
Source
1 PACKAGE AMS_Act_Messages_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvacms.pls 115.3 2002/11/15 21:01:49 abhola ship $ */
3
4
5 /****************************************************************************/
6 -- Procedure
7 -- create_act_messages
8 -- Purpose
9 -- create a row in AMS_ACT_messages
10 -- Parameters
11 -- IN:
12 -- p_api_version IN NUMBER
13 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
14 -- p_commit IN VARCHAR2 := FND_API.g_false
15 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
16 --
17 -- p_message_id IN NUMBER,
18 -- p_message_used_by IN NUMBER,
19 -- p_msg_used_by_id IN NUMBER,
20 --
21 -- OUT:
22 -- x_return_status OUT VARCHAR2
23 -- x_msg_count OUT NUMBER
24 -- x_msg_data OUT VARCHAR2
25 --
26 -- x_act_msg_id OUT NUMBER
27 ------------------------------------------------------------------------------
28 PROCEDURE create_act_messages
29 (
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
32 p_commit IN VARCHAR2 := FND_API.g_false,
33 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
34
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38
39 p_message_id IN NUMBER,
40 p_message_used_by IN VARCHAR2,
41 p_msg_used_by_id IN NUMBER,
42 x_act_msg_id OUT NOCOPY NUMBER
43 );
44
45 /****************************************************************************/
46 -- Procedure
47 -- update_act_messages
48 -- Purpose
49 -- update a row in AMS_ACT_MessageS
50 -- Parameters
51 -- IN:
52 -- p_api_version IN NUMBER
53 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
54 -- p_commit IN VARCHAR2 := FND_API.g_false
55 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
56 --
57 -- p_message_id IN NUMBER,
58 -- p_message_used_by IN NUMBER,
59 -- p_msg_used_by_id IN NUMBER,
60 --
61 -- OUT:
62 -- x_return_status OUT VARCHAR2
63 -- x_msg_count OUT NUMBER
64 -- x_msg_data OUT VARCHAR2
65 ------------------------------------------------------------------------------
66 PROCEDURE update_act_messages
67 (
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
70 p_commit IN VARCHAR2 := FND_API.g_false,
71 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
72
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76
77 p_act_msg_id IN NUMBER,
78 p_message_id IN NUMBER,
79 p_msg_used_by IN VARCHAR2,
80 p_msg_used_by_id IN NUMBER,
81 p_object_version IN NUMBER
82 );
83
84 /****************************************************************************/
85 -- Procedure
86 -- delete_act_messages
87 -- Purpose
88 -- delete a row from AMS_ACT_MessageS
89 -- Parameters
90 -- IN:
91 -- p_api_version IN NUMBER
92 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
93 -- p_commit IN VARCHAR2 := FND_API.g_false
94 --
95 -- p_act_msg_id IN NUMBER
96 -- p_object_version IN NUMBER
97 --
98 -- OUT:
99 -- x_return_status OUT VARCHAR2
100 -- x_msg_count OUT NUMBER
101 -- x_msg_data OUT VARCHAR2
102 ------------------------------------------------------------------------------
103 PROCEDURE delete_act_messages
104 (
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
107 p_commit IN VARCHAR2 := FND_API.g_false,
108
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112
113 p_act_msg_id IN NUMBER,
114 p_object_version IN NUMBER
115 );
116
117 /****************************************************************************/
118 -- Procedure
119 -- lock_act_messages
120 -- Purpose
121 -- lock a row form AMS_ACT_MessageS
122 -- Parameters
123 -- IN:
124 -- p_api_version IN NUMBER
125 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
126 --
127 -- p_act_msg_id IN NUMBER
128 -- p_object_version IN NUMBER
129 --
130 -- OUT:
131 -- x_return_status OUT VARCHAR2
132 -- x_msg_count OUT NUMBER
133 -- x_msg_data OUT VARCHAR2
134 ------------------------------------------------------------------------------
135 PROCEDURE lock_act_messages
136 (
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
139
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143
144 p_act_msg_id IN NUMBER,
145 p_object_version IN NUMBER
146 );
147
148 END AMS_Act_Messages_PVT;