1 PACKAGE CZ_BATCH_VALIDATE AUTHID CURRENT_USER AS
2 /* $Header: czbvalds.pls 115.5 2003/11/03 20:50:08 rheramba ship $ */
3
4 type INPUT_SELECTION is record (
5 component_code varchar2(1200),
6 quantity number,
7 input_seq number,
8 config_item_id number default NULL);
9
10 type CFG_INPUT_LIST is table of INPUT_SELECTION index by binary_integer;
11 subtype CFG_OUTPUT_PIECES is UTL_HTTP.HTML_PIECES;
12
13 INIT_MESSAGE_LIMIT constant NUMBER :=2*1024;
14
15 --------------------------Validation status return codes----------------------------------
16 CONFIG_PROCESSED constant NUMBER :=0;
17 CONFIG_PROCESSED_NO_TERMINATE constant NUMBER :=1;
18 INIT_TOO_LONG constant NUMBER :=2;
19 INVALID_OPTION_REQUEST constant NUMBER :=3;
20 CONFIG_EXCEPTION constant NUMBER :=4;
21 DATABASE_ERROR constant NUMBER :=5;
22 UTL_HTTP_INIT_FAILED constant NUMBER :=6;
23 UTL_HTTP_REQUEST_FAILED constant NUMBER :=7;
24 CONFIG_ITEM_UNSUPPORTED_PRE_H constant NUMBER :=8;
25 ------------------------------------------------------------------------------------------
26 PROCEDURE VALIDATE (
27 -- single-call validation function uses tables to exchange multi-valued data
28 config_input_list IN CFG_INPUT_LIST, -- input selections
29 init_message IN VARCHAR2, -- additional XML
30 config_messages IN OUT NOCOPY CFG_OUTPUT_PIECES, -- table of output XML messages
31 validation_status IN OUT NOCOPY NUMBER, -- status return
32 URL IN VARCHAR2 DEFAULT FND_PROFILE.Value('CZ_UIMGR_URL'));
33 ------------------------------------------------------------------------------------------
34 END CZ_BATCH_VALIDATE;
[Home] [Help]