[Home] [Help]
PACKAGE: APPS.AHL_DI_DOC_INDEX_PVT
Source
1 PACKAGE AHL_DI_DOC_INDEX_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVDIXS.pls 115.16 2003/07/28 07:31:19 pbarman noship $ */
3 -- Name : doc_rec
4 -- Type : type definition, group
5 -- Description : Record to hold the attributes of the document
6 TYPE doc_rec IS RECORD
7 (
8 DOCUMENT_ID NUMBER ,
9 SOURCE_PARTY_ID NUMBER ,
10 DOC_TYPE_CODE VARCHAR2(30) ,
11 DOC_SUB_TYPE_CODE VARCHAR2(30) ,
12 DOCUMENT_NO VARCHAR2(30) ,
13 OPERATOR_CODE VARCHAR2(30) ,
14 PRODUCT_TYPE_CODE VARCHAR2(30) ,
15 SUBSCRIBE_AVAIL_FLAG VARCHAR2(1) ,
16 SUBSCRIBE_TO_FLAG VARCHAR2(1) ,
17 DOCUMENT_TITLE VARCHAR2(80) ,
18 LANGUAGE VARCHAR2(4) ,
19 SOURCE_LANG VARCHAR2(4) ,
20 OBJECT_VERSION_NUMBER NUMBER ,
21 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
22 ATTRIBUTE1 VARCHAR2(150) ,
23 ATTRIBUTE2 VARCHAR2(150) ,
24 ATTRIBUTE3 VARCHAR2(150) ,
25 ATTRIBUTE4 VARCHAR2(150) ,
26 ATTRIBUTE5 VARCHAR2(150) ,
27 ATTRIBUTE6 VARCHAR2(150) ,
28 ATTRIBUTE7 VARCHAR2(150) ,
29 ATTRIBUTE8 VARCHAR2(150) ,
30 ATTRIBUTE9 VARCHAR2(150) ,
31 ATTRIBUTE10 VARCHAR2(150) ,
32 ATTRIBUTE11 VARCHAR2(150) ,
33 ATTRIBUTE12 VARCHAR2(150) ,
34 ATTRIBUTE13 VARCHAR2(150) ,
35 ATTRIBUTE14 VARCHAR2(150) ,
36 ATTRIBUTE15 VARCHAR2(150) ,
37 DELETE_FLAG VARCHAR2(1) := 'N'
38 );
39 -- Name : supplier_rec
40 -- Type : type definition, group
41 -- Description : Record to hold the attributes of the suppliers
42 TYPE supplier_rec IS RECORD
43 (
44 SUPPLIER_DOCUMENT_ID NUMBER ,
45 SUPPLIER_ID NUMBER ,
46 DOCUMENT_ID NUMBER ,
47 PREFERENCE_CODE VARCHAR2(30) ,
48 OBJECT_VERSION_NUMBER NUMBER ,
49 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
50 ATTRIBUTE1 VARCHAR2(150) ,
51 ATTRIBUTE2 VARCHAR2(150) ,
52 ATTRIBUTE3 VARCHAR2(150) ,
53 ATTRIBUTE4 VARCHAR2(150) ,
54 ATTRIBUTE5 VARCHAR2(150) ,
55 ATTRIBUTE6 VARCHAR2(150) ,
56 ATTRIBUTE7 VARCHAR2(150) ,
57 ATTRIBUTE8 VARCHAR2(150) ,
58 ATTRIBUTE9 VARCHAR2(150) ,
59 ATTRIBUTE10 VARCHAR2(150) ,
60 ATTRIBUTE11 VARCHAR2(150) ,
61 ATTRIBUTE12 VARCHAR2(150) ,
62 ATTRIBUTE13 VARCHAR2(150) ,
63 ATTRIBUTE14 VARCHAR2(150) ,
64 ATTRIBUTE15 VARCHAR2(150) ,
65 SOURCE VARCHAR2(5) ,
66 DELETE_FLAG VARCHAR2(1) := 'N'
67 );
68 -- Name : recipient_rec
69 -- Type : type definition, group
70 -- Description : Record to hold the attributes of the recipients
71 TYPE recipient_rec IS RECORD
72 (
73 RECIPIENT_DOCUMENT_ID NUMBER ,
74 RECIPIENT_PARTY_ID NUMBER ,
75 RECIPIENT_PARTY_NUMBER VARCHAR2(80) ,
76 DOCUMENT_ID NUMBER ,
77 OBJECT_VERSION_NUMBER NUMBER ,
78 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
79 ATTRIBUTE1 VARCHAR2(150) ,
80 ATTRIBUTE2 VARCHAR2(150) ,
81 ATTRIBUTE3 VARCHAR2(150) ,
82 ATTRIBUTE4 VARCHAR2(150) ,
83 ATTRIBUTE5 VARCHAR2(150) ,
84 ATTRIBUTE6 VARCHAR2(150) ,
85 ATTRIBUTE7 VARCHAR2(150) ,
86 ATTRIBUTE8 VARCHAR2(150) ,
87 ATTRIBUTE9 VARCHAR2(150) ,
88 ATTRIBUTE10 VARCHAR2(150) ,
89 ATTRIBUTE11 VARCHAR2(150) ,
90 ATTRIBUTE12 VARCHAR2(150) ,
91 ATTRIBUTE13 VARCHAR2(150) ,
92 ATTRIBUTE14 VARCHAR2(150) ,
93 ATTRIBUTE15 VARCHAR2(150) ,
94 DELETE_FLAG VARCHAR2(1) := 'N'
95 );
96
97 -- Defiene the Table Type for Document Indexes and its associated
98 -- Suppliers and Recipients
99 TYPE document_tbl IS TABLE OF doc_rec INDEX BY BINARY_INTEGER;
100 TYPE supplier_tbl IS TABLE OF supplier_rec INDEX BY BINARY_INTEGER;
101 TYPE recipient_tbl IS TABLE OF recipient_rec INDEX BY BINARY_INTEGER;
102 FUNCTION get_product_install_status (x_product_name IN VARCHAR2)
103 RETURN VARCHAR2 ;
104
105 --Procedure to create document record and its associated suppliers,
106 --recipients,subscriptions, revisions ,revision copies
107
108 PROCEDURE CREATE_DOCUMENT
109 (
110 p_api_version IN NUMBER := 1.0 ,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
112 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
113 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
114 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115 p_x_document_tbl IN OUT NOCOPY Document_Tbl ,
116 p_x_supplier_tbl IN OUT NOCOPY Supplier_Tbl ,
117 p_x_recipient_tbl IN OUT NOCOPY Recipient_Tbl ,
118 x_return_status OUT NOCOPY VARCHAR2 ,
119 x_msg_count OUT NOCOPY NUMBER ,
120 x_msg_data OUT NOCOPY VARCHAR2
121 );
122 --Procedure to update document record and its associated suppliers,
123 --recipients,subscriptions, revisions ,revision copies
124
125 PROCEDURE MODIFY_DOCUMENT
126 (
127 p_api_version IN NUMBER := 1.0 ,
128 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
129 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
130 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
131 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132 p_x_document_tbl IN OUT NOCOPY document_tbl ,
133 p_x_supplier_tbl IN OUT NOCOPY Supplier_Tbl ,
134 p_x_recipient_tbl IN OUT NOCOPY Recipient_Tbl ,
135 x_return_status OUT NOCOPY VARCHAR2 ,
136 x_msg_count OUT NOCOPY NUMBER ,
137 x_msg_data OUT NOCOPY VARCHAR2
138 );
139
140 --Procedure to Create Supplier Record for an associated document
141 PROCEDURE CREATE_SUPPLIER
142 (
143 p_api_version IN NUMBER := 1.0 ,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
146 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
147 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148 p_x_supplier_tbl IN OUT NOCOPY supplier_tbl ,
149 x_return_status OUT NOCOPY VARCHAR2 ,
150 x_msg_count OUT NOCOPY NUMBER ,
151 x_msg_data OUT NOCOPY VARCHAR2);
152
153 --Procedure to Update Supplier Record for an associated document
154 PROCEDURE MODIFY_SUPPLIER
155 (
156 p_api_version IN NUMBER := 1.0 ,
157 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
158 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
159 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
160 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161 p_supplier_tbl IN supplier_tbl ,
162 x_return_status OUT NOCOPY VARCHAR2 ,
163 x_msg_count OUT NOCOPY NUMBER ,
164 x_msg_data OUT NOCOPY VARCHAR2);
165
166 --Procedure to Remove Supplier Record for an associated document
167 PROCEDURE DELETE_SUPPLIER
168 (
169 p_api_version IN NUMBER := 1.0 ,
170 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
171 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
172 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
173 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174 p_supplier_rec IN supplier_rec ,
175 x_return_status OUT NOCOPY VARCHAR2 ,
176 x_msg_count OUT NOCOPY NUMBER ,
177 x_msg_data OUT NOCOPY VARCHAR2);
178
179 --Procedure to Create Recipient Record for an associated document
180 PROCEDURE CREATE_RECIPIENT
181 (
182 p_api_version IN NUMBER := 1.0 ,
183 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
184 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
185 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187 p_x_recipient_tbl IN OUT NOCOPY recipient_tbl ,
188 x_return_status OUT NOCOPY VARCHAR2 ,
189 x_msg_count OUT NOCOPY NUMBER ,
190 x_msg_data OUT NOCOPY VARCHAR2);
191
192 --Procedure to Update Recipient Record for an associated document
193 PROCEDURE MODIFY_RECIPIENT
194 (
195 p_api_version IN NUMBER := 1.0 ,
196 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
197 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
198 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
199 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200 p_recipient_tbl IN OUT NOCOPY recipient_tbl ,
201 x_return_status OUT NOCOPY VARCHAR2 ,
202 x_msg_count OUT NOCOPY NUMBER ,
203 x_msg_data OUT NOCOPY VARCHAR2);
204
205 --Procedure to Remove Recipient Record for an associated document
206 PROCEDURE DELETE_RECIPIENT
207 (
208 p_api_version IN NUMBER := 1.0 ,
209 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
210 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
211 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
212 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213 p_recipient_rec IN recipient_rec ,
214 x_return_status OUT NOCOPY VARCHAR2 ,
215 x_msg_count OUT NOCOPY NUMBER ,
216 x_msg_data OUT NOCOPY VARCHAR2);
217
218 END AHL_DI_DOC_INDEX_PVT;