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 --
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'
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 --
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 --
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 --
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'
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 --
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 --
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 --
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'
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 --
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 --
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 --
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'
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 --
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 --
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 --
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'
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 --
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 --
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 --
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'
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 --
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 --
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 --
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'
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 --
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 --
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 --
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'
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 --
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 --
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 --
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'
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 --
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 --
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 --
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'
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 --
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 --