1 PACKAGE GL_PROCURE_TO_PAY AS
2 /* $Header: gluprocs.pls 120.1 2002/11/12 00:03:09 djogg ship $ */
3 --
4 -- Package
5 -- GL_PROCURE_TO_PAY
6 -- Purpose
7 -- This package is used to export the data from GL_INTERFACE to a flat file.
8 -- This package was originally created for the Shooman Project
9 -- (building tight integration between Oracle Exchange and ERP applications)
10 -- History
11 -- 04-18-01 O Monnier Created
12 --
13
14 --
15 -- Procedure
16 -- export_from_gl_interface
17 -- Purpose
18 -- Export all data from GL_INTERFACE into a flat file and purge GL_INTERFACE.
19 -- Details
20 -- By default, all rows existing in GL_INTERFACE are exported to the file.
21 -- Before the export, all existing rows are inserted into the GL_INTERFACE_HISTORY
22 -- table. After the export, all exported rows are deleted from the GL_INTERFACE table.
23 -- The data in GL_INTERFACE should use a 5 segments Chart Of Accounts.
24 -- All foreign key data in GL_INTERFACE (such as set_of_books_id ...) must
25 -- point to existing data (for example, a row must exist for this set_of_books_id
26 -- in GL_SETS_OF_BOOKS) except code_combination_id (outer join).
27 -- Otherwise, the procedure will raise an exception.
28 -- The filename specified must be valid for the platform. If a file with this
29 -- name already exists in the system, the exported data will be appended to it.
30 -- Otherwise, a brand new file will be created.
31 -- The directory selected must be specified in the 'utl_file_dir' parameter of the init.ora file.
32 -- The database must have read/write access at the O/S level to the directory specified.
33 -- If no directory is specified, the file will be written to the first directory
34 -- specified as writable in the 'utl_file_dir' parameter of the init.ora file for the database.
35 -- If no directory is specified in this parameter, the procedure will raise an exception.
36 -- When choosing the TEXT output type, the values are comma delimited in the
37 -- output file. When choosing the XML output type, the values are exported in an XML format.
38 -- History
39 -- 04-18-01 O Monnier Created
40 -- Arguments
41 -- x_filename The file name
42 -- x_dir The directory
43 -- x_output_type The output type (TEXT or XML)
44 PROCEDURE export_from_gl_interface( x_filename VARCHAR2,
45 x_dir VARCHAR2,
46 x_output_type VARCHAR2 );
47
48 --
49 -- Procedure
50 -- export_from_gl_interface
51 -- Purpose
52 -- Concurrent job version of export_from_gl_interface.
53 -- History
54 -- 04-18-01 O Monnier Created
55 -- Arguments
56 -- errbuf Standard error buffer
57 -- retcode Standard return code
58 -- x_filename The file name
59 -- x_dir The directory
60 -- x_output_type The output type (TEXT or XML)
61 PROCEDURE export_from_gl_interface(errbuf OUT NOCOPY VARCHAR2,
62 retcode OUT NOCOPY VARCHAR2,
63 x_filename IN VARCHAR2,
64 x_dir IN VARCHAR2,
65 x_output_type IN VARCHAR2 );
66
67 END GL_PROCURE_TO_PAY;