1 package ENG_ATTACHMENT_IMPLEMENTATION AUTHID CURRENT_USER as
2 /*$Header: ENGUATTS.pls 120.7.12010000.2 2010/02/03 08:00:51 maychen ship $ */
3 /********************************************************************
4 * Debug APIs : Open_Debug_Session, Close_Debug_Session,
5 * Write_Debug
6 * Parameters IN :
7 * Parameters OUT:
8 * Purpose : These procedures are for test and debug
9 *********************************************************************/
10
11 -- Workflow related
12 G_ENG_WF_USER_ID CONSTANT NUMBER := -10000;
13 G_ENG_WF_LOGIN_ID CONSTANT NUMBER := '';
14 -- Concurrent Program, right now set it to be the same as workflow
15 G_ENG_CP_USER_ID CONSTANT NUMBER := -10000;
16 G_ENG_CP_LOGIN_ID CONSTANT NUMBER := '';
17
18 -- Open_Debug_Session
19 Procedure Open_Debug_Session (
20 p_output_dir IN VARCHAR2 := NULL
21 ,p_file_name IN VARCHAR2 := NULL
22 );
23
24 -- Close Debug_Session
25 Procedure Close_Debug_Session ;
26
27 -- Write Debug Message
28 Procedure Write_Debug (
29 p_debug_message IN VARCHAR2 ) ;
30
31 Procedure Cancel_Review_Approval(
32 p_api_version IN NUMBER
33 ,p_change_id IN NUMBER
34 ,x_return_status OUT NOCOPY VARCHAR2 --
35 ,x_msg_count OUT NOCOPY NUMBER --
36 ,x_msg_data OUT NOCOPY VARCHAR2 --
37 );
38
39 Procedure Update_Attachment_Status (
40 p_api_version IN NUMBER --
41 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
42 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
43 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
45 ,p_output_dir IN VARCHAR2 := NULL --
46 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Update_Attachment_Status.log'
47 ,x_return_status OUT NOCOPY VARCHAR2 --
48 ,x_msg_count OUT NOCOPY NUMBER --
49 ,x_msg_data OUT NOCOPY VARCHAR2 --
50 ,p_change_id IN NUMBER -- header's change_id
51 ,p_workflow_status IN VARCHAR2 -- workflow status
52 ,p_approval_status IN NUMBER -- approval status
53 ,p_api_caller IN VARCHAR2 DEFAULT 'UI'
54 );
55
56 Procedure Implement_Attachment_Change (
57 p_api_version IN NUMBER --
58 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
59 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
60 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
61 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
62 ,p_output_dir IN VARCHAR2 := NULL --
63 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Implement_Attachment_Change.log'
64 ,x_return_status OUT NOCOPY VARCHAR2 --
65 ,x_msg_count OUT NOCOPY NUMBER --
66 ,x_msg_data OUT NOCOPY VARCHAR2 --
67 ,p_change_id IN NUMBER -- header's change_id
68 ,p_rev_item_seq_id IN NUMBER -- revised item sequence id
69 ,p_approval_status IN NUMBER -- approval status
70 );
71
72 Procedure Copy_Attachment (
73 p_api_version IN NUMBER --
74 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
75 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
76 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
77 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
78 ,p_output_dir IN VARCHAR2 := NULL --
79 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Copy_Attachment.log'
80 ,x_return_status OUT NOCOPY VARCHAR2 --
81 ,x_msg_count OUT NOCOPY NUMBER --
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 ,x_new_attachment_id OUT NOCOPY NUMBER
84 ,p_source_attachment_id IN NUMBER -- source attached document id
85 ,p_source_status IN VARCHAR2 -- source attachment status
86 ,p_dest_entity_name IN VARCHAR2 -- destination entity name
87 ,p_dest_pk1_value IN VARCHAR2 -- destination pk1 value
88 ,p_dest_pk2_value IN VARCHAR2 -- destination pk2 value
89 ,p_dest_pk3_value IN VARCHAR2 -- destination pk3 value
90 ,p_dest_pk4_value IN VARCHAR2 -- destination pk4 value
91 ,p_dest_pk5_value IN VARCHAR2 -- destination pk5 value
92 );
93
94 Procedure Copy_Attachments_And_Changes (
95 p_api_version IN NUMBER --
96 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
97 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
98 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
99 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
100 ,p_output_dir IN VARCHAR2 := NULL --
101 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Copy_Attachments_And_Changes.log'
102 ,x_return_status OUT NOCOPY VARCHAR2 --
103 ,x_msg_count OUT NOCOPY NUMBER --
104 ,x_msg_data OUT NOCOPY VARCHAR2
105 ,p_change_id IN NUMBER -- header's change_id
106 ,p_rev_item_seq_id IN NUMBER -- revised item sequence id
107 ,p_org_id IN VARCHAR2
108 ,p_inv_item_id IN VARCHAR2
109 ,p_curr_rev_id IN VARCHAR2
110 ,p_new_rev_id IN VARCHAR2
111 );
112
113 Procedure Migrate_Attachment_And_Change (
114 p_api_version IN NUMBER --
115 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
116 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
117 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
118 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
119 ,p_output_dir IN VARCHAR2 := NULL --
120 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Migrate_Attachment_And_Change.log'
121 ,x_return_status OUT NOCOPY VARCHAR2 --
122 ,x_msg_count OUT NOCOPY NUMBER --
123 ,x_msg_data OUT NOCOPY VARCHAR2
124 ,p_change_id IN NUMBER -- header's change_id
125 ,p_rev_item_seq_id IN NUMBER -- revised item sequence id
126 ,p_org_id IN VARCHAR2
127 ,p_inv_item_id IN VARCHAR2
128 ,p_curr_rev_id IN VARCHAR2
129 ,p_new_rev_id IN VARCHAR2
130 );
131 Procedure Delete_Attachments_And_Changes (
132 p_api_version IN NUMBER --
133 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
134 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
135 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
136 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
137 ,p_output_dir IN VARCHAR2 := NULL --
138 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Delete_Attachments_And_Changes.log'
139 ,x_return_status OUT NOCOPY VARCHAR2 --
140 ,x_msg_count OUT NOCOPY NUMBER --
141 ,x_msg_data OUT NOCOPY VARCHAR2
142 ,p_change_id IN NUMBER -- header's change_id
143 ,p_rev_item_seq_id IN NUMBER -- revised item sequence id
144 ,p_org_id IN VARCHAR2
145 ,p_inv_item_id IN VARCHAR2
146 ,p_revision_id IN VARCHAR2
147 );
148
149 Procedure Delete_Attachments_For_Curr_CO (
150 p_api_version IN NUMBER --
151 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
152 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
153 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
154 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
155 ,p_output_dir IN VARCHAR2 := NULL --
156 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Delete_Attachments_For_Curr_CO.log'
157 ,x_return_status OUT NOCOPY VARCHAR2 --
158 ,x_msg_count OUT NOCOPY NUMBER --
159 ,x_msg_data OUT NOCOPY VARCHAR2
160 ,p_change_id IN NUMBER -- header's change_id
161 ,p_rev_item_seq_id IN NUMBER -- revised item sequence id
162 );
163
164 Procedure Delete_Attachments (
165 p_api_version IN NUMBER --
166 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
167 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
168 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
169 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
170 ,p_output_dir IN VARCHAR2 := NULL --
171 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Delete_Attachments.log'
172 ,x_return_status OUT NOCOPY VARCHAR2 --
173 ,x_msg_count OUT NOCOPY NUMBER --
174 ,x_msg_data OUT NOCOPY VARCHAR2
175 ,p_org_id IN VARCHAR2
176 ,p_inv_item_id IN VARCHAR2
177 ,p_revision_id IN VARCHAR2
178 );
179
180 Procedure Delete_Attachment (
181 p_api_version IN NUMBER --
182 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
183 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
184 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
185 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
186 ,p_output_dir IN VARCHAR2 := NULL --
187 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Delete_Attachment.log'
188 ,x_return_status OUT NOCOPY VARCHAR2 --
189 ,x_msg_count OUT NOCOPY NUMBER --
190 ,x_msg_data OUT NOCOPY VARCHAR2
191 ,p_attachment_id IN NUMBER
192 );
193
194 Procedure Delete_Changes (
195 p_api_version IN NUMBER --
196 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
197 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
198 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
199 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
200 ,p_output_dir IN VARCHAR2 := NULL --
201 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Delete_Changes.log'
202 ,x_return_status OUT NOCOPY VARCHAR2 --
203 ,x_msg_count OUT NOCOPY NUMBER --
204 ,x_msg_data OUT NOCOPY VARCHAR2
205 ,p_change_id IN NUMBER -- header's change_id
206 ,p_rev_item_seq_id IN NUMBER -- revised item sequence id
207 );
208
209 Procedure Get_Attachment_Status (
210 p_change_id IN NUMBER
211 ,p_header_status IN NUMBER
212 ,x_attachment_status OUT NOCOPY VARCHAR2
213 );
214
215 Procedure Complete_Attachment_Approval (
216 p_api_version IN NUMBER --
217 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
218 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
219 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
220 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
221 ,p_output_dir IN VARCHAR2 := NULL --
222 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Complete_Attachment_Approval.log'
223 ,x_return_status OUT NOCOPY VARCHAR2 --
224 ,x_msg_count OUT NOCOPY NUMBER --
225 ,x_msg_data OUT NOCOPY VARCHAR2 --
226 ,p_change_id IN NUMBER -- header's change_id
227 ,p_approval_status IN VARCHAR2 -- approval status
228 );
229
230
231 Procedure Project_deliverable_tracking(
232 p_change_id IN NUMBER
233 ,p_attachment_id IN NUMBER
234 ,p_document_id IN NUMBER
235 ,p_attach_status IN VARCHAR2
236 ,p_category_id IN NUMBER
237 ,p_repository_id IN NUMBER
238 ,p_dm_document_id IN NUMBER
239 ,p_source_media_id IN NUMBER
240 ,p_file_name IN VARCHAR2
241 ,p_created_by IN NUMBER
242 ,x_return_status OUT NOCOPY VARCHAR2
243 ,x_msg_count OUT NOCOPY NUMBER
244 ,x_msg_data OUT NOCOPY VARCHAR2
245 );
246
247 Procedure Validate_floating_version (
248 p_api_version IN NUMBER --
249 ,x_return_status OUT NOCOPY VARCHAR2 --
250 ,x_msg_count OUT NOCOPY NUMBER --
251 ,x_msg_data OUT NOCOPY VARCHAR2
252 ,p_change_id IN NUMBER
253 ,p_rev_item_seq_id IN NUMBER := NULL
254 );
255
256 END ENG_ATTACHMENT_IMPLEMENTATION;