1 PACKAGE GL_JE_SEGMENT_VALUES_PKG as
2 /* $Header: glijesvs.pls 120.7 2005/05/05 01:10:30 kvora ship $ */
3
4 --
5 -- Package
6 -- GL_JE_SEGMENT_VALUES_PKG
7 -- Purpose
8 -- Table handler for gl_je_segment_values table.
9 -- History
10 -- 11-APR-02 D J Ogg Created
11 --
12
13 -- Procedure
14 -- insert_segment_values
15 -- Purpose
16 -- Insert all the distinct balancing and management segment
17 -- values for the selected header into the GL_JE_SEGMENT_VALUES table.
18 -- History
19 -- 06/21/01 O Monnier Created
20 -- Arguments
21 -- x_je_header_id The journal to be used
22 -- Example
23 -- gl_je_segment_values_pkg.insert_segment_values( 1234 );
24 -- Notes
25 --
26 FUNCTION insert_segment_values( x_je_header_id NUMBER )
27 RETURN NUMBER;
28
29
30 -- Procedure
31 -- insert_segment_values
32 -- Purpose
33 -- Insert the distinct balancing and management segment
34 -- values if needed for the selected header and line into
35 -- the GL_JE_SEGMENT_VALUES table.
36 -- History
37 -- 06/21/01 O Monnier Created
38 -- Arguments
39 -- x_je_header_id The journal to be used
40 -- x_je_line_num The line to be used
41 -- Example
42 -- gl_je_segment_values_pkg.insert_segment_values( 1234, 10);
43 -- Notes
44 --
45 FUNCTION insert_segment_values( x_je_header_id NUMBER,
46 x_je_line_num NUMBER,
47 x_user_id NUMBER,
48 x_login_id NUMBER)
49 RETURN NUMBER;
50
51
52 -- Procedure
53 -- insert_batch_segment_values
54 -- Purpose
55 -- Insert the distinct balancing and management segment
56 -- values for the selected batch into
57 -- the GL_JE_SEGMENT_VALUES table.
58 -- History
59 -- 06/21/01 O Monnier Created
60 -- Arguments
61 -- x_je_batch_id The batch to be used
62 -- Example
63 -- gl_je_segment_values_pkg.insert_batch_segment_values( 12345 );
64 -- Notes
65 --
66 FUNCTION insert_batch_segment_values( x_je_batch_id NUMBER )
67 RETURN NUMBER;
68
69
70 --
71 -- Procedure
72 -- insert_ccid_segment_values
73 -- Purpose
74 -- Adds the bsv and msv row if they don't already exist for a new
75 -- ccid.
76 -- History
77 -- 11-APR-02 D. J. Ogg Created
78 -- Arguments
79 -- header_id Journal header id
80 -- ccid Code combination id
81 PROCEDURE insert_ccid_segment_values(
82 header_id NUMBER,
83 ccid NUMBER,
84 user_id NUMBER,
85 login_id NUMBER);
86
87
88 -- Procedure
89 -- delete_segment_values
90 -- Purpose
91 -- Delete all the distinct balancing and management segment
92 -- values for the selected header in the GL_JE_SEGMENT_VALUES table.
93 -- History
94 -- 06/21/01 O Monnier Created
95 -- Arguments
96 -- x_je_header_id The journal to be used
97 -- Example
98 -- gl_je_segment_values_pkg.delete_segment_values( 1234 );
99 -- Notes
100 --
101 FUNCTION delete_segment_values( x_je_header_id NUMBER )
102 RETURN NUMBER;
103
104 -- Procedure
105 -- delete_batch_segment_values
106 -- Purpose
107 -- Delete the distinct balancing and management segment
108 -- values for the selected batch in
109 -- the GL_JE_SEGMENT_VALUES table.
110 -- History
111 -- 06/21/01 O Monnier Created
112 -- Arguments
113 -- x_je_batch_id The batch to be used
114 -- Example
115 -- gl_je_segment_values_pkg.delete_batch_segment_values( 12345 );
116 -- Notes
117 --
118 FUNCTION delete_batch_segment_values( x_je_batch_id NUMBER )
119 RETURN NUMBER;
120
121 -- Procedure
122 -- cleanup_segment_values
123 -- Purpose
124 -- Removes any bsv or msv rows that are no longer necessary for this
125 -- journal.
126 -- History
127 -- 11-APR-02 D. J. Ogg Created
128 -- Arguments
129 -- header_id Journal header id
130 PROCEDURE cleanup_segment_values(
131 header_id NUMBER);
132
133 -- Procedure
134 -- insert_alc_segment_values
135 -- Purpose
136 -- Insert the distinct balancing and management segment
137 -- values for the ALC journals in the selected posting run into
138 -- the GL_JE_SEGMENT_VALUES table.
139 -- This routine is designed to be only called by Posting.
140 -- History
141 -- 06/23/03 K Vora Created
142 -- Arguments
143 -- x_prun_id The posting run id to be used
144 -- Example
145 -- gl_je_segment_values_pkg.insert_alc_segment_values( 12345 );
146 -- Notes
147 --
148 FUNCTION insert_alc_segment_values( x_prun_id NUMBER,
149 x_last_updated_by NUMBER,
150 x_last_update_login NUMBER )
151 RETURN NUMBER;
152
153 -- Procedure
154 -- insert_gen_line_segment_values
155 -- Purpose
156 -- Insert the distinct balancing and management segment
157 -- values for the generated lines in a primary journal being posted.
158 -- This routine is designed to be only called by Posting.
159 -- History
160 -- 06/23/03 K Vora Created
161 -- Arguments
162 -- x_je_header_id The header to be used
163 -- x_from_je_line_num The line number from which to process
164 -- Example
165 -- gl_je_segment_values_pkg.insert_gen_line_segment_values( 12345 );
166 -- Notes
167 --
168 FUNCTION insert_gen_line_segment_values( x_je_header_id NUMBER,
169 x_from_je_line_num NUMBER,
170 x_last_updated_by NUMBER,
171 x_last_update_login NUMBER )
172 RETURN NUMBER;
173
174 -- Procedure
175 -- insert_sl_segment_values
176 -- Purpose
177 -- Insert the distinct balancing and management segment
178 -- values for the SL journals in the selected posting run into
179 -- the GL_JE_SEGMENT_VALUES table.
180 -- This routine is designed to be only called by Posting.
181 -- History
182 -- 06/23/03 K Vora Created
183 -- Arguments
184 -- x_prun_id The posting run id to be used
185 -- Example
186 -- gl_je_segment_values_pkg.insert_sl_segment_values( 12345 );
187 -- Notes
188 --
189 FUNCTION insert_sl_segment_values( x_prun_id NUMBER,
190 x_last_updated_by NUMBER,
191 x_last_update_login NUMBER )
192 RETURN NUMBER;
193
194 END GL_JE_SEGMENT_VALUES_PKG;