1 PACKAGE pysgbupl AUTHID CURRENT_USER AS
2 -- /* $Header: pysgbupl.pkh 115.3 2002/12/11 06:04:27 apunekar ship $ */
3 --
4 -- +======================================================================+
5 -- | Copyright (c) 1997 Oracle Corporation UK Ltd |
6 -- | Reading, Berkshire, England |
7 -- | All rights reserved. |
8 -- +======================================================================+
9 -- SQL Script File Name : pysgbupl.pkh
10 -- Description : This script delivers Initial Balance Structure Creation.
11 -- package for the Singapore localization (SG).
12 -- This package can be activated from the SG Initial Balance
13 -- Structure Creation SRS available through Forms. The user
14 -- needs to supply the batch name to run this process.
15 --
16 -- Given the limit of the input values per element type and the
17 -- batch id in that order, create_bal_upl_struct will first call
18 -- validate_batch_data to validate the batch data, then it will
19 -- create the element types, element links, input values, balance
20 -- feeds and link input values.
21 --
22 --
23 -- Change List:
24 -- ------------
25 --
26 -- ======================================================================
27 -- Version Date Author Bug No. Description of Change
28 -- ------- ----------- -------- ------- -----------------------------
29 -- 115.0 30-JUN-2000 JBailie Initial Version
30 -- 115.1 21-JUL-2000 JBailie Set ship state
31 -- 115.2 29-NOV-2001 Ragovind 2129823 GSCC Compliance Check
32 -- 115.3 10-DEC-2002 Apunekar 2689242 Added nocopy to out and in out parameters
33 -- ======================================================================
34 --
35 --
36 --
37 PROCEDURE create_bal_upl_struct (errbuf OUT NOCOPY varchar2,
38 retcode OUT NOCOPY number,
39 p_input_value_limit number,
40 p_batch_id number);
41 --
42 END pysgbupl;