[Home] [Help]
PACKAGE: APPS.AHL_DI_DOC_REVISION_PVT
Source
1 PACKAGE AHL_DI_DOC_REVISION_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVDORS.pls 120.3.12020000.2 2012/12/14 08:01:29 shnatu ship $ */
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 --pekambar Enigma Phase II changes -- start
24 ENIGMA_DOC_ID VARCHAR2(80),
25 ENIGMA_MODEL_CODE VARCHAR2(30),
26 ENIGMA_MODEL_MEANING VARCHAR2(80),
27 --pekambar Enigma Phase II changes -- end
28 VOLUME VARCHAR2(150) ,
29 ISSUE VARCHAR2(30) ,
30 ISSUE_NUMBER NUMBER ,
31 LANGUAGE VARCHAR2(4) ,
32 SOURCE_LANG VARCHAR2(4) ,
33 COMMENTS VARCHAR2(2000),
34 OBJECT_VERSION_NUMBER NUMBER ,
35 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
36 ATTRIBUTE1 VARCHAR2(150) ,
37 ATTRIBUTE2 VARCHAR2(150) ,
38 ATTRIBUTE3 VARCHAR2(150) ,
39 ATTRIBUTE4 VARCHAR2(150) ,
40 ATTRIBUTE5 VARCHAR2(150) ,
41 ATTRIBUTE6 VARCHAR2(150) ,
42 ATTRIBUTE7 VARCHAR2(150) ,
43 ATTRIBUTE8 VARCHAR2(150) ,
44 ATTRIBUTE9 VARCHAR2(150) ,
45 ATTRIBUTE10 VARCHAR2(150) ,
46 ATTRIBUTE11 VARCHAR2(150) ,
47 ATTRIBUTE12 VARCHAR2(150) ,
48 ATTRIBUTE13 VARCHAR2(150) ,
49 ATTRIBUTE14 VARCHAR2(150) ,
50 ATTRIBUTE15 VARCHAR2(150) ,
51 DELETE_FLAG VARCHAR2(1) := 'N' );
52
53 -- Declare table type
54 TYPE revision_tbl IS TABLE OF revision_rec INDEX BY BINARY_INTEGER;
55
56 -- Procedure to create revision for an associated document
57 PROCEDURE CREATE_REVISION
58 (
59 p_api_version IN NUMBER := 1.0 ,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
61 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
62 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
63 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 p_x_revision_tbl IN OUT NOCOPY revision_tbl ,
65 x_return_status OUT NOCOPY VARCHAR2 ,
66 x_msg_count OUT NOCOPY NUMBER ,
67 x_msg_data OUT NOCOPY VARCHAR2);
68
69 -- Procedure to modify revision for an associated document
70 PROCEDURE MODIFY_REVISION
71 (
72 p_api_version IN NUMBER := 1.0 ,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
74 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
75 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
76 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77 --pekambar changed in Enigma Phase -2
78 --p_x_revision_tbl IN revision_tbl ,
79 p_x_revision_tbl IN OUT NOCOPY revision_tbl ,
80 x_return_status OUT NOCOPY VARCHAR2 ,
81 x_msg_count OUT NOCOPY NUMBER ,
82 x_msg_data OUT NOCOPY VARCHAR2);
83
84 -- Procedure to delete revision for an associated document
85 PROCEDURE DELETE_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 revision_tbl ,
93 x_return_status OUT NOCOPY VARCHAR2 ,
94 x_msg_count OUT NOCOPY NUMBER ,
95 x_msg_data OUT NOCOPY VARCHAR2);
96
97 -- FP #8410484
98 PROCEDURE UPDATE_ASSOCIATIONS_CONCURRENT
99 (
100 errbuf OUT NOCOPY VARCHAR2,
101 retcode OUT NOCOPY NUMBER,
102 p_api_version IN NUMBER :=1.0
103 );
104
105 END AHL_DI_DOC_REVISION_PVT;