1 package ENG_ATTACHMENT_IMPLEMENTATION as
2 /*$Header: ENGUATTS.pls 120.7 2006/02/14 12:55:54 sbag noship $ */
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 Delete_Attachments_And_Changes (
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.Delete_Attachments_And_Changes.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_revision_id IN VARCHAR2
129 );
130
131 Procedure Delete_Attachments_For_Curr_CO (
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_For_Curr_CO.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 );
145
146 Procedure Delete_Attachments (
147 p_api_version IN NUMBER --
148 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
149 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
150 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
151 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
152 ,p_output_dir IN VARCHAR2 := NULL --
153 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Delete_Attachments.log'
154 ,x_return_status OUT NOCOPY VARCHAR2 --
155 ,x_msg_count OUT NOCOPY NUMBER --
156 ,x_msg_data OUT NOCOPY VARCHAR2
157 ,p_org_id IN VARCHAR2
158 ,p_inv_item_id IN VARCHAR2
159 ,p_revision_id IN VARCHAR2
160 );
161
162 Procedure Delete_Attachment (
163 p_api_version IN NUMBER --
164 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
165 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
166 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
167 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
168 ,p_output_dir IN VARCHAR2 := NULL --
169 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Delete_Attachment.log'
170 ,x_return_status OUT NOCOPY VARCHAR2 --
171 ,x_msg_count OUT NOCOPY NUMBER --
172 ,x_msg_data OUT NOCOPY VARCHAR2
173 ,p_attachment_id IN NUMBER
174 );
175
176 Procedure Delete_Changes (
177 p_api_version IN NUMBER --
178 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
179 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
180 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
181 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
182 ,p_output_dir IN VARCHAR2 := NULL --
183 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Delete_Changes.log'
184 ,x_return_status OUT NOCOPY VARCHAR2 --
185 ,x_msg_count OUT NOCOPY NUMBER --
186 ,x_msg_data OUT NOCOPY VARCHAR2
187 ,p_change_id IN NUMBER -- header's change_id
188 ,p_rev_item_seq_id IN NUMBER -- revised item sequence id
189 );
190
191 Procedure Get_Attachment_Status (
192 p_change_id IN NUMBER
193 ,p_header_status IN NUMBER
194 ,x_attachment_status OUT NOCOPY VARCHAR2
195 );
196
197 Procedure Complete_Attachment_Approval (
198 p_api_version IN NUMBER --
199 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
200 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
201 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
202 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
203 ,p_output_dir IN VARCHAR2 := NULL --
204 ,p_debug_filename IN VARCHAR2 := 'ENGUATTB.Complete_Attachment_Approval.log'
205 ,x_return_status OUT NOCOPY VARCHAR2 --
206 ,x_msg_count OUT NOCOPY NUMBER --
207 ,x_msg_data OUT NOCOPY VARCHAR2 --
208 ,p_change_id IN NUMBER -- header's change_id
209 ,p_approval_status IN VARCHAR2 -- approval status
210 );
211
212
213 Procedure Project_deliverable_tracking(
214 p_change_id IN NUMBER
215 ,p_attachment_id IN NUMBER
216 ,p_document_id IN NUMBER
217 ,p_attach_status IN VARCHAR2
218 ,p_category_id IN NUMBER
219 ,p_repository_id IN NUMBER
220 ,p_dm_document_id IN NUMBER
221 ,p_source_media_id IN NUMBER
222 ,p_file_name IN VARCHAR2
223 ,p_created_by IN NUMBER
224 ,x_return_status OUT NOCOPY VARCHAR2
225 ,x_msg_count OUT NOCOPY NUMBER
226 ,x_msg_data OUT NOCOPY VARCHAR2
227 );
228
229 Procedure Validate_floating_version (
230 p_api_version IN NUMBER --
231 ,x_return_status OUT NOCOPY VARCHAR2 --
232 ,x_msg_count OUT NOCOPY NUMBER --
233 ,x_msg_data OUT NOCOPY VARCHAR2
234 ,p_change_id IN NUMBER
235 ,p_rev_item_seq_id IN NUMBER := NULL
238 END ENG_ATTACHMENT_IMPLEMENTATION;
236 );
237