1 PACKAGE BODY IEM_SAFETY_QUES_PVT as
2 /* $Header: iemvsfqb.pls 115.3 2004/04/08 21:20:02 chtang shipped $*/
3
4 G_PKG_NAME CONSTANT varchar2(30) :='IEM_SAFETY_QUES_PVT';
5
6
7 -- Start of Comments
8 -- API name : create_item
9 -- Type : Private
10 -- Function : This procedure create a record in the table IEM_SAFETY_QUEUES
11 -- Pre-reqs : None.
12 -- Parameters :
13 -- IN
14 -- p_api_version_number IN NUMBER Required
15 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
16 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
17 -- p_message_id IN number,
18 -- p_message_size IN number,
19 -- p_sender_name IN VARCHAR2,
20 -- p_user_name IN VARCHAR2,
21 -- p_domain_name IN VARCHAR2,
22 -- p_message_priority IN VARCHAR2,
23 -- p_msg_status IN VARCHAR2,
24 -- p_subject IN VARCHAR2,
25 -- p_classification IN VARCHAR2,
26 -- p_score IN number,
27 -- p_sent_date IN date,
28 -- p_customer_id IN NUMBER,
29 -- p_product_id IN NUMBER,
30 -- p_key1 IN VARCHAR2,
31 -- p_value1 IN VARCHAR2,
32 -- p_key2 IN VARCHAR2,
33 -- p_value2 IN VARCHAR2,
34 -- p_key3 IN VARCHAR2,
35 -- p_value3 IN VARCHAR2,
36 -- p_key4 IN VARCHAR2,
37 -- p_value4 IN VARCHAR2,
38 -- p_key5 IN VARCHAR2,
39 -- p_value5 IN VARCHAR2,
40 -- p_key6 IN VARCHAR2,
41 -- p_value6 IN VARCHAR2,
42 -- p_key7 IN VARCHAR2,
43 -- p_value7 IN VARCHAR2,
44 -- p_key8 IN VARCHAR2,
45 -- p_value8 IN VARCHAR2,
46 -- p_key9 IN VARCHAR2,
47 -- p_value9 IN VARCHAR2,
48 -- p_key10 IN VARCHAR2,
49 -- p_value10 IN VARCHAR2,
50 --
51 -- OUT
52 -- x_return_status OUT VARCHAR2
53 -- x_msg_count OUT NUMBER
54 -- x_msg_data OUT VARCHAR2
55 --
56 -- Version : 1.0
57 -- Notes :
58 --
59 -- End of comments
60 -- **********************************************************
61
62 PROCEDURE create_item (p_api_version_number IN NUMBER,
63 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
64 p_commit IN VARCHAR2:= FND_API.G_FALSE,
65 p_MESSAGE_ID IN NUMBER,
66 p_MESSAGE_SIZE IN NUMBER,
67 p_SENDER_NAME IN VARCHAR2,
68 p_USER_NAME IN VARCHAR2,
69 p_DOMAIN_NAME IN VARCHAR2,
70 p_MESSAGE_PRIORITY IN VARCHAR2,
71 p_MSG_STATUS IN VARCHAR2,
72 p_SUBJECT IN VARCHAR2,
73 p_CLASSIFICATION IN VARCHAR2,
74 p_SCORE IN NUMBER,
75 p_SENT_DATE IN DATE,
76 p_CUSTOMER_ID IN NUMBER,
77 p_PRODUCT_ID IN NUMBER,
78 p_key1 IN VARCHAR2,
79 p_value1 IN VARCHAR2,
80 p_key2 IN VARCHAR2,
81 p_value2 IN VARCHAR2,
82 p_key3 IN VARCHAR2,
83 p_value3 IN VARCHAR2,
84 p_key4 IN VARCHAR2,
85 p_value4 IN VARCHAR2,
86 p_key5 IN VARCHAR2,
87 p_value5 IN VARCHAR2,
88 p_key6 IN VARCHAR2,
89 p_value6 IN VARCHAR2,
90 p_key7 IN VARCHAR2,
91 p_value7 IN VARCHAR2,
92 p_key8 IN VARCHAR2,
93 p_value8 IN VARCHAR2,
94 p_key9 IN VARCHAR2,
95 p_value9 IN VARCHAR2,
96 p_key10 IN VARCHAR2,
97 p_value10 IN VARCHAR2,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2
101 )
102 is
103
104 BEGIN
105 null;
106 END;
107
108
109 -- Start of Comments
110 -- API name : delete_item
111 -- Type : Private
112 -- Function : This procedure delete a record in the table IEM_SAFETY_QUEUES
113 -- Pre-reqs : None.
114 -- Parameters :
115 -- IN
116 -- p_api_version_number IN NUMBER Required
117 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
118 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
119 -- p_message_id in number,
120 -- OUT
121 -- x_return_status OUT VARCHAR2
122 -- x_msg_count OUT NUMBER
123 -- x_msg_data OUT VARCHAR2
124 --
125 -- Version : 1.0
126 -- Notes :
127 --
128 -- End of comments
129 -- **********************************************************
130
131 PROCEDURE delete_item (p_api_version_number IN NUMBER,
132 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133 p_commit IN VARCHAR2 := FND_API.G_FALSE,
134 p_message_id IN NUMBER,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2
138 ) is
139
140 BEGIN
141 null;
142 END;
143
144
145 -- Start of Comments
146 -- API name : requeue_item
147 -- Type : Private
148 -- Function : This procedure requeues a record in the table IEM_SAFETY_QUEUES
149 -- into Processing AQ
150 -- Pre-reqs : None.
151 -- Parameters :
152 -- IN
153 -- p_api_version_number IN NUMBER Required
154 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
155 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156 -- p_message_id in number,
157 -- OUT
158 -- x_return_status OUT VARCHAR2
159 -- x_msg_count OUT NUMBER
160 -- x_msg_data OUT VARCHAR2
161 --
162 -- Version : 1.0
163 -- Notes :
164 --
165 -- End of comments
166 -- **********************************************************
167
168 PROCEDURE requeue_item (p_api_version_number IN NUMBER,
169 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170 p_commit IN VARCHAR2 := FND_API.G_FALSE,
171 p_message_id IN NUMBER,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2
175 ) is
176
177 BEGIN
178 null;
179 END;
180
181 END IEM_SAFETY_QUES_PVT;