[Home] [Help]
PACKAGE: APPS.AHL_DI_DOC_REVISION_PUB
Source
1 PACKAGE AHL_DI_DOC_REVISION_PUB AS
2 /* $Header: AHLPDORS.pls 120.0 2005/05/25 23:40:50 appldev noship $ */
3 /*#
4 * This is the public interface to create, modify and delete document revisions.
5 * @rep:scope public
6 * @rep:product AHL
7 * @rep:displayname Document Revision
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY AHL_DOCUMENT
10 */
11
12 TYPE revision_rec IS RECORD
13 (
14 DOC_REVISION_ID NUMBER ,
15 DOCUMENT_ID NUMBER ,
16 REVISION_NO VARCHAR2(30) ,
17 REVISION_TYPE_CODE VARCHAR2(30) ,
18 REVISION_TYPE_DESC VARCHAR2(80) ,
19 REVISION_STATUS_CODE VARCHAR2(30) ,
20 REVISION_STATUS_DESC VARCHAR2(80) ,
21 REVISION_DATE DATE ,
22 APPROVED_BY_PARTY_ID NUMBER ,
23 APPROVED_BY_PTY_NUMBER VARCHAR2(80) ,
24 APPROVED_BY_PTY_NAME VARCHAR2(301) ,
25 APPROVED_DATE DATE ,
26 EFFECTIVE_DATE DATE ,
27 OBSOLETE_DATE DATE ,
28 ISSUE_DATE DATE ,
29 RECEIVED_DATE DATE ,
30 URL VARCHAR2(240) ,
31 MEDIA_TYPE_CODE VARCHAR2(30) ,
32 MEDIA_TYPE_DESC VARCHAR2(80) ,
33 VOLUME VARCHAR2(150) ,
34 ISSUE VARCHAR2(30) ,
35 ISSUE_NUMBER NUMBER ,
36 LANGUAGE VARCHAR2(4) ,
37 SOURCE_LANG VARCHAR2(4) ,
38 COMMENTS VARCHAR2(2000),
39 OBJECT_VERSION_NUMBER NUMBER ,
40 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
41 ATTRIBUTE1 VARCHAR2(150) ,
42 ATTRIBUTE2 VARCHAR2(150) ,
43 ATTRIBUTE3 VARCHAR2(150) ,
44 ATTRIBUTE4 VARCHAR2(150) ,
45 ATTRIBUTE5 VARCHAR2(150) ,
46 ATTRIBUTE6 VARCHAR2(150) ,
47 ATTRIBUTE7 VARCHAR2(150) ,
48 ATTRIBUTE8 VARCHAR2(150) ,
49 ATTRIBUTE9 VARCHAR2(150) ,
50 ATTRIBUTE10 VARCHAR2(150) ,
51 ATTRIBUTE11 VARCHAR2(150) ,
52 ATTRIBUTE12 VARCHAR2(150) ,
53 ATTRIBUTE13 VARCHAR2(150) ,
54 ATTRIBUTE14 VARCHAR2(150) ,
55 ATTRIBUTE15 VARCHAR2(150) ,
56 DELETE_FLAG VARCHAR2(1) := 'N'
57 );
58
59
60
61 -- Declare the table type
62 TYPE revision_tbl IS TABLE OF revision_rec INDEX BY BINARY_INTEGER;
63
64 /*#
65 * It allows creation of document revisions.
66 * @param p_api_version Api Version Number
67 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
68 * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
69 * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
70 * @param p_validate_only To decide whether to validate, default value FND_API.G_TRUE
71 * @param p_module_type To indicate whether called 'API' or 'JSP', default value NULL
72 * @param x_return_status Return status
73 * @param x_msg_count Return message count
74 * @param x_msg_data Return message data
75 * @param p_x_revision_tbl Document revisions table of type revision_tbl
76 * @rep:scope public
77 * @rep:lifecycle active
78 * @rep:displayname Create Document Revision
79 */
80 PROCEDURE CREATE_REVISION
81 (
82 p_api_version IN NUMBER := 1.0 ,
83 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
84 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
85 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
86 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87 p_x_revision_tbl IN OUT NOCOPY revision_tbl ,
88 p_module_type IN VARCHAR2 ,
89 x_return_status OUT NOCOPY VARCHAR2 ,
90 x_msg_count OUT NOCOPY NUMBER ,
91 x_msg_data OUT NOCOPY VARCHAR2
92 );
93
94
95 /*#
96 * It allows modification and deletion of document revisions.
97 * @param p_api_version Api Version Number
98 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
99 * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
100 * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
101 * @param p_validate_only To decide whether to validate, default value FND_API.G_TRUE
102 * @param p_module_type To indicate whether called 'API' or 'JSP', default value NULL
103 * @param x_return_status Return status
104 * @param x_msg_count Return message count
105 * @param x_msg_data Return message data
106 * @param p_x_revision_tbl Document revisions table of type revision_tbl
107 * @rep:scope public
108 * @rep:lifecycle active
109 * @rep:displayname Modify Document Revision
110 */
111 PROCEDURE MODIFY_REVISION
112 (
113 p_api_version IN NUMBER := 1.0 ,
114 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
115 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
116 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
117 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118 p_x_revision_tbl IN OUT NOCOPY revision_tbl ,
119 p_module_type IN VARCHAR2,
120 x_return_status OUT NOCOPY VARCHAR2 ,
121 x_msg_count OUT NOCOPY NUMBER ,
122 x_msg_data OUT NOCOPY VARCHAR2
123 );
124 -- Procedure to create revision copy for an associated revision
125 END AHL_DI_DOC_REVISION_PUB;