[Home] [Help]
PACKAGE: APPS.AHL_DI_DOC_REVISION_PVT
Source
1 PACKAGE AHL_DI_DOC_REVISION_PVT AS
2 /* $Header: AHLVDORS.pls 120.0 2005/05/26 02:02:07 appldev noship $ */
3
4 -- Name : revision_rec
5 -- Type : type definition, group
6 -- Description : Record to hold the attributes of the revision
7 TYPE revision_rec IS RECORD
8 (
9 DOC_REVISION_ID NUMBER ,
10 DOCUMENT_ID NUMBER ,
11 REVISION_NO VARCHAR2(30) ,
12 REVISION_TYPE_CODE VARCHAR2(30) ,
13 REVISION_STATUS_CODE VARCHAR2(30) ,
14 REVISION_DATE DATE ,
15 APPROVED_BY_PARTY_ID NUMBER ,
16 APPROVED_DATE DATE ,
17 EFFECTIVE_DATE DATE ,
18 OBSOLETE_DATE DATE ,
19 ISSUE_DATE DATE ,
20 RECEIVED_DATE DATE ,
21 URL VARCHAR2(240) ,
22 MEDIA_TYPE_CODE VARCHAR2(30) ,
23 VOLUME VARCHAR2(150) ,
24 ISSUE VARCHAR2(30) ,
25 ISSUE_NUMBER NUMBER ,
26 LANGUAGE VARCHAR2(4) ,
27 SOURCE_LANG VARCHAR2(4) ,
28 COMMENTS VARCHAR2(2000),
29 OBJECT_VERSION_NUMBER NUMBER ,
30 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
31 ATTRIBUTE1 VARCHAR2(150) ,
32 ATTRIBUTE2 VARCHAR2(150) ,
33 ATTRIBUTE3 VARCHAR2(150) ,
34 ATTRIBUTE4 VARCHAR2(150) ,
35 ATTRIBUTE5 VARCHAR2(150) ,
36 ATTRIBUTE6 VARCHAR2(150) ,
37 ATTRIBUTE7 VARCHAR2(150) ,
38 ATTRIBUTE8 VARCHAR2(150) ,
39 ATTRIBUTE9 VARCHAR2(150) ,
40 ATTRIBUTE10 VARCHAR2(150) ,
41 ATTRIBUTE11 VARCHAR2(150) ,
42 ATTRIBUTE12 VARCHAR2(150) ,
43 ATTRIBUTE13 VARCHAR2(150) ,
44 ATTRIBUTE14 VARCHAR2(150) ,
45 ATTRIBUTE15 VARCHAR2(150) ,
46 DELETE_FLAG VARCHAR2(1) := 'N' );
47
48 -- Declare table type
49 TYPE revision_tbl IS TABLE OF revision_rec INDEX BY BINARY_INTEGER;
50
51 -- Procedure to create revision for an associated document
52 PROCEDURE CREATE_REVISION
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_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
58 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59 p_x_revision_tbl IN OUT NOCOPY revision_tbl ,
60 x_return_status OUT NOCOPY VARCHAR2 ,
61 x_msg_count OUT NOCOPY NUMBER ,
62 x_msg_data OUT NOCOPY VARCHAR2);
63
64 -- Procedure to modify revision for an associated document
65 PROCEDURE MODIFY_REVISION
66 (
67 p_api_version IN NUMBER := 1.0 ,
68 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
69 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
70 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
71 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72 p_x_revision_tbl IN revision_tbl ,
73 x_return_status OUT NOCOPY VARCHAR2 ,
74 x_msg_count OUT NOCOPY NUMBER ,
75 x_msg_data OUT NOCOPY VARCHAR2);
76
77 -- Procedure to delete revision for an associated document
78 PROCEDURE DELETE_REVISION
79 (
80 p_api_version IN NUMBER := 1.0 ,
81 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
82 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
83 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
84 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85 p_x_revision_tbl IN revision_tbl ,
86 x_return_status OUT NOCOPY VARCHAR2 ,
87 x_msg_count OUT NOCOPY NUMBER ,
88 x_msg_data OUT NOCOPY VARCHAR2);
89
90 END AHL_DI_DOC_REVISION_PVT;