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