1 package PO_DOCUMENT_TYPES_ALL_PKG as
2 /* $Header: POXSTDTS.pls 120.2 2006/03/09 16:35:28 dreddy noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_DOCUMENT_TYPE_CODE in VARCHAR2,
6 X_DOCUMENT_SUBTYPE in VARCHAR2,
7 X_WF_CREATEDOC_ITEMTYPE in VARCHAR2,
8 X_ARCHIVE_EXTERNAL_REVISION_CO in VARCHAR2,
9 X_CAN_PREPARER_APPROVE_FLAG in VARCHAR2,
10 X_FORWARDING_MODE_CODE in VARCHAR2,
11 X_CAN_CHANGE_FORWARD_FROM_FLAG in VARCHAR2,
12 X_CAN_APPROVER_MODIFY_DOC_FLAG in VARCHAR2,
13 X_CAN_CHANGE_APPROVAL_PATH_FLA in VARCHAR2,
14 X_CAN_CHANGE_FORWARD_TO_FLAG in VARCHAR2,
15 X_QUOTATION_CLASS_CODE in VARCHAR2,
16 X_DEFAULT_APPROVAL_PATH_ID in NUMBER,
17 X_ATTRIBUTE_CATEGORY in VARCHAR2,
18 X_ATTRIBUTE1 in VARCHAR2,
19 X_ATTRIBUTE2 in VARCHAR2,
20 X_ATTRIBUTE3 in VARCHAR2,
21 X_ATTRIBUTE4 in VARCHAR2,
22 X_ATTRIBUTE5 in VARCHAR2,
23 X_ATTRIBUTE6 in VARCHAR2,
24 X_ATTRIBUTE7 in VARCHAR2,
25 X_ATTRIBUTE8 in VARCHAR2,
26 X_ATTRIBUTE9 in VARCHAR2,
27 X_ATTRIBUTE10 in VARCHAR2,
28 X_ATTRIBUTE11 in VARCHAR2,
29 X_ATTRIBUTE12 in VARCHAR2,
30 X_ATTRIBUTE13 in VARCHAR2,
31 X_ATTRIBUTE14 in VARCHAR2,
32 X_ATTRIBUTE15 in VARCHAR2,
33 X_SECURITY_LEVEL_CODE in VARCHAR2,
34 X_ACCESS_LEVEL_CODE in VARCHAR2,
35 X_DISABLED_FLAG in VARCHAR2,
36 X_REQUEST_ID in NUMBER,
37 X_WF_APPROVAL_ITEMTYPE in VARCHAR2,
38 X_WF_APPROVAL_PROCESS in VARCHAR2,
39 X_WF_CREATEDOC_PROCESS in VARCHAR2,
40 p_ame_transaction_type IN VARCHAR2, -- Bug 3028744 New column
41 X_TYPE_NAME in VARCHAR2,
42 X_CREATION_DATE in DATE,
43 X_CREATED_BY in NUMBER,
44 X_LAST_UPDATE_DATE in DATE,
45 X_LAST_UPDATED_BY in NUMBER,
46 X_LAST_UPDATE_LOGIN in NUMBER,
47 P_DOCUMENT_TEMPLATE_CODE in VARCHAR2,-- POC FPJ
48 P_CONTRACT_TEMPLATE_CODE in VARCHAR2, -- POC FPJ
49 p_use_contract_for_sourcing IN VARCHAR2,-- <Contract AutoSourcing FPJ>
50 p_include_noncatalog_flag IN VARCHAR2, -- <Contract AutoSourcing FPJ>
51 p_org_id IN NUMBER);
52
53 procedure LOCK_ROW (
54 X_DOCUMENT_TYPE_CODE in VARCHAR2,
55 X_DOCUMENT_SUBTYPE in VARCHAR2,
56 X_WF_CREATEDOC_ITEMTYPE in VARCHAR2,
57 X_ARCHIVE_EXTERNAL_REVISION_CO in VARCHAR2,
58 X_CAN_PREPARER_APPROVE_FLAG in VARCHAR2,
59 X_FORWARDING_MODE_CODE in VARCHAR2,
60 X_CAN_CHANGE_FORWARD_FROM_FLAG in VARCHAR2,
61 X_CAN_APPROVER_MODIFY_DOC_FLAG in VARCHAR2,
62 X_CAN_CHANGE_APPROVAL_PATH_FLA in VARCHAR2,
63 X_CAN_CHANGE_FORWARD_TO_FLAG in VARCHAR2,
64 X_QUOTATION_CLASS_CODE in VARCHAR2,
65 X_DEFAULT_APPROVAL_PATH_ID in NUMBER,
66 X_ATTRIBUTE_CATEGORY in VARCHAR2,
67 X_ATTRIBUTE1 in VARCHAR2,
68 X_ATTRIBUTE2 in VARCHAR2,
69 X_ATTRIBUTE3 in VARCHAR2,
70 X_ATTRIBUTE4 in VARCHAR2,
71 X_ATTRIBUTE5 in VARCHAR2,
72 X_ATTRIBUTE6 in VARCHAR2,
73 X_ATTRIBUTE7 in VARCHAR2,
74 X_ATTRIBUTE8 in VARCHAR2,
75 X_ATTRIBUTE9 in VARCHAR2,
76 X_ATTRIBUTE10 in VARCHAR2,
77 X_ATTRIBUTE11 in VARCHAR2,
78 X_ATTRIBUTE12 in VARCHAR2,
79 X_ATTRIBUTE13 in VARCHAR2,
80 X_ATTRIBUTE14 in VARCHAR2,
81 X_ATTRIBUTE15 in VARCHAR2,
82 X_SECURITY_LEVEL_CODE in VARCHAR2,
83 X_ACCESS_LEVEL_CODE in VARCHAR2,
84 X_DISABLED_FLAG in VARCHAR2,
85 X_REQUEST_ID in NUMBER,
86 X_WF_APPROVAL_ITEMTYPE in VARCHAR2,
87 X_WF_APPROVAL_PROCESS in VARCHAR2,
88 X_WF_CREATEDOC_PROCESS in VARCHAR2,
89 p_ame_transaction_type IN VARCHAR2, -- Bug 3028744 New column
90 X_TYPE_NAME in VARCHAR2,
91 P_DOCUMENT_TEMPLATE_CODE in VARCHAR2, -- POC FPJ
92 P_CONTRACT_TEMPLATE_CODE in VARCHAR2, -- POC FPJ
93 p_use_contract_for_sourcing IN VARCHAR2,-- <Contract AutoSourcing FPJ>
94 p_include_noncatalog_flag IN VARCHAR2); -- <Contract AutoSourcing FPJ>
95
96 procedure UPDATE_ROW (
97 X_DOCUMENT_TYPE_CODE in VARCHAR2,
98 X_DOCUMENT_SUBTYPE in VARCHAR2,
99 X_WF_CREATEDOC_ITEMTYPE in VARCHAR2,
100 X_ARCHIVE_EXTERNAL_REVISION_CO in VARCHAR2,
101 X_CAN_PREPARER_APPROVE_FLAG in VARCHAR2,
102 X_FORWARDING_MODE_CODE in VARCHAR2,
103 X_CAN_CHANGE_FORWARD_FROM_FLAG in VARCHAR2,
104 X_CAN_APPROVER_MODIFY_DOC_FLAG in VARCHAR2,
105 X_CAN_CHANGE_APPROVAL_PATH_FLA in VARCHAR2,
106 X_CAN_CHANGE_FORWARD_TO_FLAG in VARCHAR2,
107 X_QUOTATION_CLASS_CODE in VARCHAR2,
108 X_DEFAULT_APPROVAL_PATH_ID in NUMBER,
109 X_ATTRIBUTE_CATEGORY in VARCHAR2,
110 X_ATTRIBUTE1 in VARCHAR2,
111 X_ATTRIBUTE2 in VARCHAR2,
112 X_ATTRIBUTE3 in VARCHAR2,
113 X_ATTRIBUTE4 in VARCHAR2,
114 X_ATTRIBUTE5 in VARCHAR2,
115 X_ATTRIBUTE6 in VARCHAR2,
116 X_ATTRIBUTE7 in VARCHAR2,
117 X_ATTRIBUTE8 in VARCHAR2,
118 X_ATTRIBUTE9 in VARCHAR2,
119 X_ATTRIBUTE10 in VARCHAR2,
120 X_ATTRIBUTE11 in VARCHAR2,
121 X_ATTRIBUTE12 in VARCHAR2,
122 X_ATTRIBUTE13 in VARCHAR2,
123 X_ATTRIBUTE14 in VARCHAR2,
124 X_ATTRIBUTE15 in VARCHAR2,
125 X_SECURITY_LEVEL_CODE in VARCHAR2,
126 X_ACCESS_LEVEL_CODE in VARCHAR2,
127 X_DISABLED_FLAG in VARCHAR2,
128 X_REQUEST_ID in NUMBER,
129 X_WF_APPROVAL_ITEMTYPE in VARCHAR2,
130 X_WF_APPROVAL_PROCESS in VARCHAR2,
131 X_WF_CREATEDOC_PROCESS in VARCHAR2,
132 p_ame_transaction_type IN VARCHAR2, -- Bug 3028744 New column
133 X_TYPE_NAME in VARCHAR2,
134 X_LAST_UPDATE_DATE in DATE,
135 X_LAST_UPDATED_BY in NUMBER,
136 X_LAST_UPDATE_LOGIN in NUMBER,
137 P_DOCUMENT_TEMPLATE_CODE in VARCHAR2, -- POC FPJ
138 P_CONTRACT_TEMPLATE_CODE in VARCHAR2, --POC FPJ
139 p_use_contract_for_sourcing IN VARCHAR2,-- <Contract AutoSourcing FPJ>
140 p_include_noncatalog_flag IN VARCHAR2, -- <Contract AutoSourcing FPJ>
141 p_org_id IN NUMBER);
142
143 procedure DELETE_ROW (
144 X_DOCUMENT_TYPE_CODE in VARCHAR2,
145 X_DOCUMENT_SUBTYPE in VARCHAR2
146 );
147 procedure ADD_LANGUAGE;
148
149 procedure TRANSLATE_ROW (
150 X_DOCUMENT_TYPE_CODE in VARCHAR2,
151 X_DOCUMENT_SUBTYPE in VARCHAR2,
152 X_TYPE_NAME in VARCHAR2,
153 X_ORG_ID in NUMBER,
154 X_OWNER in VARCHAR2,
155 X_LAST_UPDATE_DATE in VARCHAR2,
156 X_CUSTOM_MODE in VARCHAR2);
157
158 procedure LOAD_ROW (X_DOCUMENT_TYPE_CODE in VARCHAR2,
159 X_DOCUMENT_SUBTYPE in VARCHAR2,
160 X_ORG_ID in NUMBER,
161 X_WF_CREATEDOC_ITEMTYPE in VARCHAR2,
162 X_ARCHIVE_EXTERNAL_REVISION_CO in VARCHAR2,
163 X_CAN_PREPARER_APPROVE_FLAG in VARCHAR2,
164 X_FORWARDING_MODE_CODE in VARCHAR2,
165 X_CAN_CHANGE_FORWARD_FROM_FLAG in VARCHAR2,
166 X_CAN_APPROVER_MODIFY_DOC_FLAG in VARCHAR2,
167 X_CAN_CHANGE_APPROVAL_PATH_FLA in VARCHAR2,
168 X_CAN_CHANGE_FORWARD_TO_FLAG in VARCHAR2,
169 X_QUOTATION_CLASS_CODE in VARCHAR2,
170 X_DEFAULT_APPROVAL_PATH_ID in NUMBER,
171 X_ATTRIBUTE_CATEGORY in VARCHAR2,
172 X_ATTRIBUTE1 in VARCHAR2,
173 X_ATTRIBUTE2 in VARCHAR2,
174 X_ATTRIBUTE3 in VARCHAR2,
175 X_ATTRIBUTE4 in VARCHAR2,
176 X_ATTRIBUTE5 in VARCHAR2,
177 X_ATTRIBUTE6 in VARCHAR2,
178 X_ATTRIBUTE7 in VARCHAR2,
179 X_ATTRIBUTE8 in VARCHAR2,
180 X_ATTRIBUTE9 in VARCHAR2,
181 X_ATTRIBUTE10 in VARCHAR2,
182 X_ATTRIBUTE11 in VARCHAR2,
183 X_ATTRIBUTE12 in VARCHAR2,
184 X_ATTRIBUTE13 in VARCHAR2,
185 X_ATTRIBUTE14 in VARCHAR2,
186 X_ATTRIBUTE15 in VARCHAR2,
187 X_SECURITY_LEVEL_CODE in VARCHAR2,
188 X_ACCESS_LEVEL_CODE in VARCHAR2,
189 X_DISABLED_FLAG in VARCHAR2,
190 X_REQUEST_ID in NUMBER,
191 X_WF_APPROVAL_ITEMTYPE in VARCHAR2,
192 X_WF_APPROVAL_PROCESS in VARCHAR2,
193 X_WF_CREATEDOC_PROCESS in VARCHAR2,
194 p_ame_transaction_type IN VARCHAR2, -- Bug 3028744
195 X_TYPE_NAME in VARCHAR2,
196 X_OWNER in VARCHAR2,
197 X_LAST_UPDATE_DATE in VARCHAR2,
198 X_CUSTOM_MODE in VARCHAR2,
199 P_DOCUMENT_TEMPLATE_CODE in VARCHAR2, --POC FPJ
200 P_CONTRACT_TEMPLATE_CODE in VARCHAR2); --POC FPJ
201
202 -------------------------------------------------------------------------------
203 --Start of Comments
204 --Name: insert_lookup_row
205 --Pre-reqs:
206 -- None.
207 --Modifies:
208 -- FND_LOOKUP_VALUES
209 --Locks:
210 -- None.
211 --Function:
212 -- This procedure acts as a pl/sql wrapper over the existing fnd api
213 -- FND_LOOKUP_VALUES_PKG.INSERT_ROW. It is used to insert the user
214 -- defined document subtype into fnd_lookup_values.It defaults the
215 -- values and limits the input parameters to a minimum.
216 --Parameters:
217 --IN:
218 --p_lookup_type
219 -- The lookup type for the row to be inserted in fnd_lookup_values.
220 -- This value is derived from the document type as explained in comments below.
221 --p_lookup_code
222 -- The lookup code for the row to be inserted in fnd_lookup_values.
223 -- This is equal to the document subtype entered by the user. The same
224 -- value is stored as the meaning and description for the row in fnd lookups.
225 --p_creation_date
226 -- Standard who column.
227 --p_created_by
228 -- Standard who column.
229 --p_last_update_date
230 -- Standard who column.
231 --p_last_updated_by
232 -- Standard who column.
233 --p_last_update_login
234 -- Standard who column.
235 --Notes:
236 -- This wrapper has been added as a part of the R12 HTML Setup enhancement
237 -- for inserting the user defined document subtypes into fnd lookups. This
238 -- api is essentially called via a jdbc call from the Document Types Helper.
239 -- The lookup type is determined based on the document type. It equals 'RFQ
240 -- SUBTYPE' for RFQ Document Types and 'QUOTATION SUBTYPE' for QUOTATION
241 -- Document Types.
242 --Testing:
243 -- On creating a new Document Type from the setup page, check that a record
244 -- has been inserted in fnd_lookup_values table (or the po_lookup_codes
245 -- view based on it). The lookup type would depend on the Document Type as
246 -- explained above. The lookup code, description and meaning (or displayed
247 -- field) should be equal to the user entered document subtype value.
248 --End of Comments
249 -------------------------------------------------------------------------------
250 procedure INSERT_LOOKUP_ROW (P_LOOKUP_TYPE in VARCHAR2,
251 P_LOOKUP_CODE in VARCHAR2,
252 P_CREATION_DATE in DATE,
253 P_CREATED_BY in NUMBER,
254 P_LAST_UPDATE_DATE in DATE,
255 P_LAST_UPDATED_BY in NUMBER,
256 P_LAST_UPDATE_LOGIN in NUMBER);
257
258
259 -------------------------------------------------------------------------------
260 --Start of Comments
261 --Name: delete_lookup_row
262 --Pre-reqs:
263 -- None.
264 --Modifies:
265 -- FND_LOOKUP_VALUES
266 --Locks:
267 -- None.
268 --Function:
269 -- This procedure acts as a pl/sql wrapper over the existing fnd api
270 -- FND_LOOKUP_VALUES_PKG.DELETE_ROW. It is used to delete the user
271 -- defined document subtype from fnd_lookup_values.It defaults the
272 -- values and limits the input parameters to a minimum.
273 --Parameters:
274 --IN:
275 --p_lookup_type
276 -- The lookup type for the row to be deleted from fnd_lookup_values.
277 -- This value is derived from the document type as explained in comments below.
278 --p_lookup_code
279 -- The lookup code for the row to be deleted from fnd_lookup_values.
280 -- This is equal to the document subtype entered by the user.
281 --Notes:
282 -- This wrapper has been added as a part of the R12 HTML Setup enhancement
283 -- for deleting the user defined document subtypes from fnd lookups. This
284 -- api is essentially called via a jdbc call from the Document Types Helper.
285 -- The lookup type is determined based on the document type. It equals 'RFQ
286 -- SUBTYPE' for RFQ Document Types and 'QUOTATION SUBTYPE' for QUOTATION
287 -- Document Types.
288 --Testing:
289 -- On deleting the Document Type from the setup page, check that the
290 -- corresponding record has been deleted from fnd_lookup_values
291 -- (or po_lookup_codes).
292 --End of Comments
293 -------------------------------------------------------------------------------
294 procedure DELETE_LOOKUP_ROW (P_LOOKUP_TYPE in VARCHAR2,
295 P_LOOKUP_CODE in VARCHAR2);
296 end PO_DOCUMENT_TYPES_ALL_PKG;