1 PACKAGE CZ_BATCH_VALIDATE AUTHID CURRENT_USER AS
2 /* $Header: czbvalds.pls 120.0.12010000.2 2009/07/16 00:53:59 vsingava 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 INVALID_ALTBATCHVALIDATE_URL constant NUMBER :=9;
26 ------------------------------------------------------------------------------------------
27 PROCEDURE VALIDATE (
28 -- single-call validation function uses tables to exchange multi-valued data
29 config_input_list IN CFG_INPUT_LIST, -- input selections
30 init_message IN VARCHAR2, -- additional XML
31 config_messages IN OUT NOCOPY CFG_OUTPUT_PIECES, -- table of output XML messages
32 validation_status IN OUT NOCOPY NUMBER, -- status return
33 URL IN VARCHAR2 DEFAULT FND_PROFILE.Value('CZ_UIMGR_URL'));
34 ------------------------------------------------------------------------------------------
35 END CZ_BATCH_VALIDATE;