PACKAGE: APPS.AHL_DI_FILEUPLOAD_PVT

Source

1 PACKAGE AHL_DI_FILEUPLOAD_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVFUPS.pls 115.2 2004/01/21 09:07:22 adharia noship $ */
3 
4 -- Declare records and table types
5 
6 TYPE ahl_fileupload_rec IS RECORD
7   (
8    p_association_id    NUMBER,
9    p_file_id           NUMBER,
10    p_file_name               VARCHAR2(256),
11    p_file_description        VARCHAR2(2000),
12    p_revision_id       NUMBER,
13    p_datatype_code VARCHAR2(30),
14 			p_attribute_category VARCHAR2(30),
15 			p_attribute1 VARCHAR2(150),
16 			p_attribute2 VARCHAR2(150),
17 			p_attribute3 VARCHAR2(150),
18 			p_attribute4 VARCHAR2(150),
19 			p_attribute5 VARCHAR2(150),
20 			p_attribute6 VARCHAR2(150),
21 			p_attribute7 VARCHAR2(150),
22 			p_attribute8 VARCHAR2(150),
23 			p_attribute9 VARCHAR2(150),
24 			p_attribute10 VARCHAR2(150),
25 			p_attribute11 VARCHAR2(150),
26 			p_attribute12 VARCHAR2(150),
27 			p_attribute13 VARCHAR2(150),
28 			p_attribute14 VARCHAR2(150),
29 			p_attribute15 VARCHAR2(150),
30    p_x_object_version_number  NUMBER
31 
32   );
33 
34 
35 -- Procedure to insert/update file for an associated document
36  PROCEDURE UPLOAD_ITEM
37  (
38   p_api_version                  IN NUMBER    DEFAULT 1.0,
39   p_init_msg_list                IN VARCHAR2  DEFAULT FND_API.G_TRUE,
40   p_commit                       IN VARCHAR2  DEFAULT FND_API.G_FALSE ,
41   p_validation_level             IN NUMBER    DEFAULT FND_API.G_VALID_LEVEL_FULL,
42   x_return_status                OUT NOCOPY VARCHAR2 ,
43   x_msg_count                    OUT NOCOPY NUMBER ,
44   x_msg_data                     OUT NOCOPY VARCHAR2,
45   p_x_ahl_fileupload_rec            IN OUT NOCOPY ahl_fileupload_rec
46  );
47 
48 
49 
50 
51 -- Procedure to delete association for the file for an associated document
52  PROCEDURE DELETE_ITEM
53   (
54    p_api_version                  IN  NUMBER    := 1.0               ,
55    p_init_msg_list                IN  VARCHAR2  := FND_API.G_TRUE      ,
56    p_commit                       IN  VARCHAR2  := FND_API.G_FALSE     ,
57    p_validation_level             IN  NUMBER    := FND_API.G_VALID_LEVEL_FULL,
58    x_return_status                OUT NOCOPY VARCHAR2,
59    x_msg_count                    OUT NOCOPY NUMBER,
60    x_msg_data                     OUT NOCOPY VARCHAR2,
61    p_x_ahl_fileupload_rec          IN ahl_fileupload_rec
62  );
63 
64 -- Procedure to process (insert/delete) items for the file for an associated document
65 
66 PROCEDURE PROCESS_ITEM
67  (p_api_version                  IN NUMBER    DEFAULT 1.0,
68   p_init_msg_list                IN VARCHAR2  DEFAULT FND_API.G_TRUE,
69   p_commit                       IN VARCHAR2  DEFAULT FND_API.G_FALSE ,
70   p_validation_level             IN NUMBER    DEFAULT FND_API.G_VALID_LEVEL_FULL,
71   x_return_status                OUT NOCOPY VARCHAR2 ,
72   x_msg_count                    OUT NOCOPY NUMBER ,
73   x_msg_data                     OUT NOCOPY VARCHAR2,
74   p_x_ahl_fileupload_rec            IN OUT NOCOPY ahl_fileupload_rec,
75   p_delete_flag                  IN VARCHAR2
76  );
77 
78 END AHL_DI_FILEUPLOAD_PVT;
79 
80 
81