[Home] [Help]
PACKAGE: APPS.AHL_DI_DOC_REVISION_PUB
Source
1 PACKAGE AHL_DI_DOC_REVISION_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPDORS.pls 120.1.12020000.2 2012/12/07 00:03:41 sareepar ship $ */
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 --pekambar Enigma Phase II changes -- start
34 ENIGMA_DOC_ID VARCHAR2(80),
35 ENIGMA_MODEL_CODE VARCHAR2(30),
36 ENIGMA_MODEL_MEANING VARCHAR2(80),
37 --pekambar Enigma Phase II changes -- end
38 VOLUME VARCHAR2(150) ,
39 ISSUE VARCHAR2(30) ,
40 ISSUE_NUMBER NUMBER ,
41 LANGUAGE VARCHAR2(4) ,
42 SOURCE_LANG VARCHAR2(4) ,
43 COMMENTS VARCHAR2(2000),
44 OBJECT_VERSION_NUMBER NUMBER ,
45 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
46 ATTRIBUTE1 VARCHAR2(150) ,
47 ATTRIBUTE2 VARCHAR2(150) ,
48 ATTRIBUTE3 VARCHAR2(150) ,
49 ATTRIBUTE4 VARCHAR2(150) ,
50 ATTRIBUTE5 VARCHAR2(150) ,
51 ATTRIBUTE6 VARCHAR2(150) ,
52 ATTRIBUTE7 VARCHAR2(150) ,
53 ATTRIBUTE8 VARCHAR2(150) ,
54 ATTRIBUTE9 VARCHAR2(150) ,
55 ATTRIBUTE10 VARCHAR2(150) ,
56 ATTRIBUTE11 VARCHAR2(150) ,
57 ATTRIBUTE12 VARCHAR2(150) ,
58 ATTRIBUTE13 VARCHAR2(150) ,
59 ATTRIBUTE14 VARCHAR2(150) ,
60 ATTRIBUTE15 VARCHAR2(150) ,
61 DELETE_FLAG VARCHAR2(1) := 'N'
62 );
63
64
65
66 -- Declare the table type
67 TYPE revision_tbl IS TABLE OF revision_rec INDEX BY BINARY_INTEGER;
68
69 /*#
70 * It allows creation of document revisions.
71 * @param p_api_version Api Version Number
72 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
73 * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
74 * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
75 * @param p_validate_only To decide whether to validate, default value FND_API.G_TRUE
76 * @param p_module_type To indicate whether called 'API' or 'JSP', default value NULL
77 * @param x_return_status Return status
78 * @param x_msg_count Return message count
79 * @param x_msg_data Return message data
80 * @param p_x_revision_tbl Document revisions table of type revision_tbl
81 * @rep:scope public
82 * @rep:lifecycle active
83 * @rep:displayname Create Document Revision
84 */
85 PROCEDURE CREATE_REVISION
86 (
87 p_api_version IN NUMBER := 1.0 ,
88 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
89 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
90 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
91 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92 p_x_revision_tbl IN OUT NOCOPY revision_tbl ,
93 p_module_type IN VARCHAR2 ,
94 x_return_status OUT NOCOPY VARCHAR2 ,
95 x_msg_count OUT NOCOPY NUMBER ,
96 x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99
100 /*#
101 * It allows modification and deletion of document revisions.
102 * @param p_api_version Api Version Number
103 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
104 * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
105 * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
106 * @param p_validate_only To decide whether to validate, default value FND_API.G_TRUE
107 * @param p_module_type To indicate whether called 'API' or 'JSP', default value NULL
108 * @param x_return_status Return status
109 * @param x_msg_count Return message count
110 * @param x_msg_data Return message data
111 * @param p_x_revision_tbl Document revisions table of type revision_tbl
112 * @rep:scope public
113 * @rep:lifecycle active
114 * @rep:displayname Modify Document Revision
115 */
116 PROCEDURE MODIFY_REVISION
117 (
118 p_api_version IN NUMBER := 1.0 ,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
120 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
121 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
122 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123 p_x_revision_tbl IN OUT NOCOPY revision_tbl ,
124 p_module_type IN VARCHAR2,
125 x_return_status OUT NOCOPY VARCHAR2 ,
126 x_msg_count OUT NOCOPY NUMBER ,
127 x_msg_data OUT NOCOPY VARCHAR2
128 );
129 -- Procedure to create revision copy for an associated revision
130 END AHL_DI_DOC_REVISION_PUB;