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