1 PACKAGE gl_interface_control_pkg AS
2 /* $Header: glijicts.pls 120.6 2005/06/17 23:20:36 djogg ship $ */
3 --
4 -- Package
5 -- gl_interface_control_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_interface_control
8 -- History
9 -- 10-12-93 D. J. Ogg Created
10
11 --
12 -- Procedure
13 -- get_unique_run_id
14 -- Purpose
15 -- Returns the next unique interface run id
16 -- History
17 -- 10-12-93 D. J. Ogg Created
18 -- Arguments
19 -- none
20 -- Example
21 -- id := get_unique_run_id
22 FUNCTION get_unique_run_id RETURN NUMBER;
23
24 --
25 -- Procedure
26 -- get_unique_id
27 -- Purpose
28 -- Returns the next unique group id
29 -- History
30 -- 10-12-93 D. J. Ogg Created
31 -- Arguments
32 -- none
33 -- Example
34 -- id := get_unique_id
35 FUNCTION get_unique_id RETURN NUMBER;
36
37 --
38 -- Procedure
39 -- check_unique
40 -- Purpose
41 -- Checks to make sure that the source/group_id/ledger id combo are unique
42 -- within this journal import run
43 -- History
44 -- 04-06-94 D. J. Ogg Created
45 -- Arguments
46 -- x_interface_run_id Indicates the rows in this run
47 -- x_user_je_source_name The translated source name
48 -- x_je_source_name The source to check
49 -- x_ledger_id The ledger to check
50 -- x_group_id The group id to check
51 -- row_id The current row ID
52 -- Example
53 -- gl_interface_control_pkg.check_unique;
54 PROCEDURE check_unique(x_interface_run_id NUMBER,
55 x_user_je_source_name VARCHAR2,
56 x_je_source_name VARCHAR2,
57 x_ledger_id NUMBER,
58 x_group_id NUMBER DEFAULT NULL,
59 row_id VARCHAR2);
60
61 --
62 -- Procedure
63 -- used_in_alternate_table
64 -- Purpose
65 -- Checks to see if this source has data in an interface
66 -- table other than gl_interface. If so, returns 'Y'.
67 -- Otherwise, returns 'N'.
68 -- History
69 -- 03-OCT-2000 D. J. Ogg Created
70 -- Arguments
71 -- x_int_je_source_name The interface table source name to check
72 -- Example
73 -- gl_interface_control_pkg.used_in_alternate_table(
74 -- 'Payables');
75 FUNCTION used_in_alternate_table(
76 x_int_je_source_name VARCHAR2) RETURN VARCHAR2;
77
78 --
79 -- Procedure
80 -- get_interface_table
81 -- Purpose
82 -- Gets the interface table that contains data for this
83 -- source and group id.
84 -- History
85 -- 03-OCT-2000 D. J. Ogg Created
86 -- Arguments
87 -- x_int_je_source_name The interface source name to find
88 -- x_group_id The group id to find
89 -- Example
90 -- gl_interface_control_pkg.get_interface_table(
91 -- 'Payables', 10101);
92 FUNCTION get_interface_table(
93 x_int_je_source_name VARCHAR2,
94 x_group_id NUMBER) RETURN VARCHAR2;
95
96 --
97 -- Procedure
98 -- insert_row
99 -- Purpose
100 -- Inserts a new row into the gl_interface table
101 -- History
102 -- 03-24-93 D. J. Ogg Created
103 -- Arguments
104 -- xinterface_run_id The interface run ID
105 -- xje_source_name The source name
106 -- xledger_id The ledger ID
107 -- xgroup_id The group ID
108 -- xpacket_id The packet ID
109 -- Example
110 -- insert_row(16434, 'Transfer', 55, null);
111 PROCEDURE insert_row(xinterface_run_id NUMBER,
112 xje_source_name VARCHAR2,
113 xledger_id NUMBER,
114 xgroup_id NUMBER,
115 xpacket_id NUMBER DEFAULT NULL);
116
117 END gl_interface_control_pkg;