eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_CREATE_JOURNALS_PKG dependencies on JG_CREATE_JOURNALS_PKG

Line 1: PACKAGE BODY JG_CREATE_JOURNALS_PKG AS

1: PACKAGE BODY JG_CREATE_JOURNALS_PKG AS
2: /* $Header: jgzztalb.pls 120.2 2004/02/19 14:49:51 fholst ship $ */
3:
4: /* ---------------------------------------------------------------------
5: | PRIVATE PROCEDURE |

Line 16: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.Zero_Fill_Segments');

12: | create_journal_allocations |
13: --------------------------------------------------------------------- */
14: PROCEDURE zero_fill_segments(p_key_segment IN OUT NOCOPY KEY_SEGMENTS_TABLE) IS
15: BEGIN
16: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.Zero_Fill_Segments');
17: FOR j IN 1..JG_JOURNAL_ALLOCATIONS_PKG.G_num_of_segments LOOP
18: JG_UTILITY_PKG.debug( 'segmt posn = '||to_char(j));
19: JG_UTILITY_PKG.debug( 'ZF: segmt col name = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name);
20: JG_UTILITY_PKG.debug( 'ZF: segmt zero string = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).zero_string);

Line 26: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.Zero_Fill_Segments');

22: p_key_segment(TO_NUMBER(SUBSTR(JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name, 8)))
23: := JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).zero_string;
24: END IF;
25: END LOOP;
26: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.Zero_Fill_Segments');
27: END zero_fill_segments;
28:
29: /* ---------------------------------------------------------------------
30: | PRIVATE FUNCTION |

Line 46: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.insert_gl_interface');

42: lp_accounted_dr IN NUMBER,
43: lp_accounted_cr IN NUMBER,
44: lp_offset_group_bool IN BOOLEAN) RETURN BOOLEAN IS
45: BEGIN
46: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.insert_gl_interface');
47:
48: IF NOT lp_offset_group_bool THEN
49:
50: INSERT INTO gl_interface ( STATUS,

Line 177: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ),

173: DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'E',
174: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
175: DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'B',
176: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
177: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ),
178: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ),
179: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ),
180: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ),
181: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),

Line 178: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ),

174: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
175: DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'B',
176: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
177: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ),
178: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ),
179: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ),
180: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ),
181: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),
182: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),

Line 179: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ),

175: DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'B',
176: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
177: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ),
178: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ),
179: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ),
180: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ),
181: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),
182: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),
183: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),

Line 180: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ),

176: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
177: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ),
178: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ),
179: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ),
180: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ),
181: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),
182: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),
183: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),
184: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),

Line 181: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),

177: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ),
178: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ),
179: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ),
180: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ),
181: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),
182: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),
183: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),
184: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),
185: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),

Line 182: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),

178: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ),
179: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ),
180: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ),
181: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),
182: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),
183: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),
184: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),
185: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),
186: JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),

Line 183: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),

179: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ),
180: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ),
181: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),
182: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),
183: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),
184: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),
185: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),
186: JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),
187: JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),

Line 184: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),

180: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ),
181: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),
182: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),
183: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),
184: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),
185: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),
186: JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),
187: JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),
188: JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),

Line 185: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),

181: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),
182: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),
183: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),
184: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),
185: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),
186: JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),
187: JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),
188: JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),
189: JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),

Line 186: JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),

182: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),
183: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),
184: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),
185: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),
186: JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),
187: JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),
188: JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),
189: JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),
190: JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),

Line 187: JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),

183: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),
184: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),
185: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),
186: JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),
187: JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),
188: JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),
189: JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),
190: JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),
191: JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),

Line 188: JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),

184: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),
185: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),
186: JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),
187: JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),
188: JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),
189: JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),
190: JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),
191: JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),
192: JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),

Line 189: JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),

185: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),
186: JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),
187: JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),
188: JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),
189: JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),
190: JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),
191: JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),
192: JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),
193: JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),

Line 190: JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),

186: JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),
187: JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),
188: JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),
189: JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),
190: JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),
191: JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),
192: JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),
193: JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),
194: JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),

Line 191: JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),

187: JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),
188: JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),
189: JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),
190: JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),
191: JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),
192: JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),
193: JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),
194: JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),
195: JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),

Line 192: JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),

188: JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),
189: JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),
190: JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),
191: JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),
192: JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),
193: JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),
194: JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),
195: JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),
196: JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),

Line 193: JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),

189: JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),
190: JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),
191: JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),
192: JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),
193: JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),
194: JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),
195: JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),
196: JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),
197: JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),

Line 194: JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),

190: JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),
191: JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),
192: JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),
193: JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),
194: JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),
195: JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),
196: JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),
197: JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),
198: JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),

Line 195: JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),

191: JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),
192: JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),
193: JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),
194: JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),
195: JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),
196: JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),
197: JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),
198: JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),
199: JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),

Line 196: JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),

192: JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),
193: JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),
194: JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),
195: JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),
196: JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),
197: JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),
198: JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),
199: JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),
200: JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),

Line 197: JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),

193: JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),
194: JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),
195: JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),
196: JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),
197: JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),
198: JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),
199: JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),
200: JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),
201: JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),

Line 198: JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),

194: JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),
195: JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),
196: JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),
197: JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),
198: JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),
199: JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),
200: JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),
201: JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),
202: JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),

Line 199: JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),

195: JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),
196: JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),
197: JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),
198: JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),
199: JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),
200: JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),
201: JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),
202: JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),
203: JG_CREATE_JOURNALS_PKG.G_key_segment( 27 ),

Line 200: JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),

196: JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),
197: JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),
198: JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),
199: JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),
200: JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),
201: JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),
202: JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),
203: JG_CREATE_JOURNALS_PKG.G_key_segment( 27 ),
204: JG_CREATE_JOURNALS_PKG.G_key_segment( 28 ),

Line 201: JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),

197: JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),
198: JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),
199: JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),
200: JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),
201: JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),
202: JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),
203: JG_CREATE_JOURNALS_PKG.G_key_segment( 27 ),
204: JG_CREATE_JOURNALS_PKG.G_key_segment( 28 ),
205: JG_CREATE_JOURNALS_PKG.G_key_segment( 29 ),

Line 202: JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),

198: JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),
199: JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),
200: JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),
201: JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),
202: JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),
203: JG_CREATE_JOURNALS_PKG.G_key_segment( 27 ),
204: JG_CREATE_JOURNALS_PKG.G_key_segment( 28 ),
205: JG_CREATE_JOURNALS_PKG.G_key_segment( 29 ),
206: JG_CREATE_JOURNALS_PKG.G_key_segment( 30 ),

Line 203: JG_CREATE_JOURNALS_PKG.G_key_segment( 27 ),

199: JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),
200: JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),
201: JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),
202: JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),
203: JG_CREATE_JOURNALS_PKG.G_key_segment( 27 ),
204: JG_CREATE_JOURNALS_PKG.G_key_segment( 28 ),
205: JG_CREATE_JOURNALS_PKG.G_key_segment( 29 ),
206: JG_CREATE_JOURNALS_PKG.G_key_segment( 30 ),
207: lp_entered_dr,

Line 204: JG_CREATE_JOURNALS_PKG.G_key_segment( 28 ),

200: JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),
201: JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),
202: JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),
203: JG_CREATE_JOURNALS_PKG.G_key_segment( 27 ),
204: JG_CREATE_JOURNALS_PKG.G_key_segment( 28 ),
205: JG_CREATE_JOURNALS_PKG.G_key_segment( 29 ),
206: JG_CREATE_JOURNALS_PKG.G_key_segment( 30 ),
207: lp_entered_dr,
208: lp_entered_cr,

Line 205: JG_CREATE_JOURNALS_PKG.G_key_segment( 29 ),

201: JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),
202: JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),
203: JG_CREATE_JOURNALS_PKG.G_key_segment( 27 ),
204: JG_CREATE_JOURNALS_PKG.G_key_segment( 28 ),
205: JG_CREATE_JOURNALS_PKG.G_key_segment( 29 ),
206: JG_CREATE_JOURNALS_PKG.G_key_segment( 30 ),
207: lp_entered_dr,
208: lp_entered_cr,
209: lp_accounted_dr,

Line 206: JG_CREATE_JOURNALS_PKG.G_key_segment( 30 ),

202: JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),
203: JG_CREATE_JOURNALS_PKG.G_key_segment( 27 ),
204: JG_CREATE_JOURNALS_PKG.G_key_segment( 28 ),
205: JG_CREATE_JOURNALS_PKG.G_key_segment( 29 ),
206: JG_CREATE_JOURNALS_PKG.G_key_segment( 30 ),
207: lp_entered_dr,
208: lp_entered_cr,
209: lp_accounted_dr,
210: lp_accounted_cr,

Line 211: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1

207: lp_entered_dr,
208: lp_entered_cr,
209: lp_accounted_dr,
210: lp_accounted_cr,
211: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
212: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
213: JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
214: JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
215: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.external_reference,-- Reference6

Line 212: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2

208: lp_entered_cr,
209: lp_accounted_dr,
210: lp_accounted_cr,
211: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
212: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
213: JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
214: JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
215: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.external_reference,-- Reference6
216: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name ||

Line 213: JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4

209: lp_accounted_dr,
210: lp_accounted_cr,
211: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
212: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
213: JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
214: JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
215: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.external_reference,-- Reference6
216: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name ||
217: DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type, 'A',

Line 214: JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5

210: lp_accounted_cr,
211: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
212: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
213: JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
214: JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
215: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.external_reference,-- Reference6
216: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name ||
217: DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type, 'A',
218: '/' ||JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_doc_sequence_name || '/' ||

Line 388: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 1 ),

384: DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'E',
385: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
386: DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'B',
387: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
388: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 1 ),
389: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 2 ),
390: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 3 ),
391: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 4 ),
392: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),

Line 389: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 2 ),

385: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
386: DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'B',
387: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
388: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 1 ),
389: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 2 ),
390: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 3 ),
391: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 4 ),
392: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),
393: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),

Line 390: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 3 ),

386: DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'B',
387: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
388: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 1 ),
389: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 2 ),
390: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 3 ),
391: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 4 ),
392: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),
393: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),
394: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),

Line 391: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 4 ),

387: JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
388: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 1 ),
389: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 2 ),
390: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 3 ),
391: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 4 ),
392: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),
393: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),
394: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),
395: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),

Line 392: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),

388: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 1 ),
389: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 2 ),
390: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 3 ),
391: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 4 ),
392: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),
393: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),
394: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),
395: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),
396: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),

Line 393: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),

389: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 2 ),
390: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 3 ),
391: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 4 ),
392: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),
393: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),
394: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),
395: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),
396: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),
397: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),

Line 394: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),

390: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 3 ),
391: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 4 ),
392: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),
393: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),
394: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),
395: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),
396: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),
397: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),
398: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),

Line 395: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),

391: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 4 ),
392: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),
393: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),
394: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),
395: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),
396: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),
397: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),
398: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),
399: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),

Line 396: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),

392: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),
393: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),
394: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),
395: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),
396: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),
397: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),
398: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),
399: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),
400: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),

Line 397: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),

393: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),
394: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),
395: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),
396: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),
397: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),
398: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),
399: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),
400: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),
401: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),

Line 398: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),

394: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),
395: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),
396: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),
397: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),
398: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),
399: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),
400: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),
401: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),
402: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),

Line 399: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),

395: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),
396: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),
397: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),
398: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),
399: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),
400: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),
401: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),
402: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),
403: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),

Line 400: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),

396: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),
397: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),
398: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),
399: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),
400: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),
401: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),
402: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),
403: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),
404: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),

Line 401: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),

397: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),
398: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),
399: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),
400: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),
401: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),
402: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),
403: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),
404: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),
405: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),

Line 402: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),

398: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),
399: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),
400: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),
401: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),
402: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),
403: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),
404: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),
405: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),
406: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),

Line 403: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),

399: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),
400: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),
401: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),
402: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),
403: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),
404: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),
405: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),
406: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),
407: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),

Line 404: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),

400: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),
401: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),
402: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),
403: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),
404: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),
405: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),
406: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),
407: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),
408: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),

Line 405: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),

401: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),
402: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),
403: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),
404: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),
405: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),
406: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),
407: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),
408: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),
409: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),

Line 406: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),

402: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),
403: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),
404: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),
405: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),
406: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),
407: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),
408: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),
409: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),
410: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),

Line 407: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),

403: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),
404: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),
405: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),
406: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),
407: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),
408: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),
409: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),
410: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),
411: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),

Line 408: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),

404: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),
405: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),
406: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),
407: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),
408: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),
409: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),
410: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),
411: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),
412: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),

Line 409: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),

405: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),
406: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),
407: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),
408: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),
409: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),
410: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),
411: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),
412: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),
413: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),

Line 410: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),

406: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),
407: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),
408: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),
409: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),
410: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),
411: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),
412: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),
413: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),
414: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 27 ),

Line 411: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),

407: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),
408: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),
409: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),
410: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),
411: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),
412: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),
413: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),
414: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 27 ),
415: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 28 ),

Line 412: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),

408: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),
409: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),
410: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),
411: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),
412: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),
413: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),
414: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 27 ),
415: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 28 ),
416: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 29 ),

Line 413: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),

409: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),
410: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),
411: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),
412: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),
413: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),
414: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 27 ),
415: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 28 ),
416: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 29 ),
417: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 30 ),

Line 414: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 27 ),

410: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),
411: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),
412: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),
413: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),
414: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 27 ),
415: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 28 ),
416: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 29 ),
417: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 30 ),
418: lp_entered_dr,

Line 415: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 28 ),

411: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),
412: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),
413: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),
414: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 27 ),
415: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 28 ),
416: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 29 ),
417: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 30 ),
418: lp_entered_dr,
419: lp_entered_cr,

Line 416: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 29 ),

412: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),
413: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),
414: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 27 ),
415: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 28 ),
416: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 29 ),
417: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 30 ),
418: lp_entered_dr,
419: lp_entered_cr,
420: lp_accounted_dr,

Line 417: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 30 ),

413: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),
414: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 27 ),
415: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 28 ),
416: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 29 ),
417: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 30 ),
418: lp_entered_dr,
419: lp_entered_cr,
420: lp_accounted_dr,
421: lp_accounted_cr,

Line 422: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1

418: lp_entered_dr,
419: lp_entered_cr,
420: lp_accounted_dr,
421: lp_accounted_cr,
422: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
423: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
424: JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
425: JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
426: NULL,-- Reference6

Line 423: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2

419: lp_entered_cr,
420: lp_accounted_dr,
421: lp_accounted_cr,
422: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
423: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
424: JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
425: JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
426: NULL,-- Reference6
427: NULL, -- Reference 10

Line 424: JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4

420: lp_accounted_dr,
421: lp_accounted_cr,
422: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
423: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
424: JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
425: JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
426: NULL,-- Reference6
427: NULL, -- Reference 10
428: NULL,

Line 425: JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5

421: lp_accounted_cr,
422: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
423: JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
424: JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
425: JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
426: NULL,-- Reference6
427: NULL, -- Reference 10
428: NULL,
429: NULL,

Line 467: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');

463: JG_JOURNAL_ALLOCATIONS_PKG.G_destn_period_name, NULL));
464:
465: END IF;
466:
467: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');
468: RETURN TRUE;
469: EXCEPTION
470: WHEN OTHERS THEN
471: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');

Line 471: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');

467: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');
468: RETURN TRUE;
469: EXCEPTION
470: WHEN OTHERS THEN
471: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');
472: JG_UTILITY_PKG.log(sqlerrm);
473: RETURN FALSE;
474: END insert_gl_interface;
475:

Line 494: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');

490: l_net_dr_entered_offset_total NUMBER := 0;
491: l_net_cr_entered_offset_total NUMBER := 0;
492: l_range_offset_remark VARCHAR2(240) := NULL;
493: BEGIN
494: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');
495: --
496: -- Need to zero-fill segments for offset group insert other than the balancing segment and natural account
497: -- Use separate array to store zeros as Zero-Fill method may not have been chosen for journal allocation.
498: --

Line 499: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment := JG_CREATE_JOURNALS_PKG.G_key_segment;

495: --
496: -- Need to zero-fill segments for offset group insert other than the balancing segment and natural account
497: -- Use separate array to store zeros as Zero-Fill method may not have been chosen for journal allocation.
498: --
499: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment := JG_CREATE_JOURNALS_PKG.G_key_segment;
500: JG_CREATE_JOURNALS_PKG.zero_fill_segments(JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment);
501: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment(JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element) :=
502: JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account;
503: --

Line 500: JG_CREATE_JOURNALS_PKG.zero_fill_segments(JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment);

496: -- Need to zero-fill segments for offset group insert other than the balancing segment and natural account
497: -- Use separate array to store zeros as Zero-Fill method may not have been chosen for journal allocation.
498: --
499: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment := JG_CREATE_JOURNALS_PKG.G_key_segment;
500: JG_CREATE_JOURNALS_PKG.zero_fill_segments(JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment);
501: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment(JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element) :=
502: JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account;
503: --
504: -- Calculate net totals

Line 501: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment(JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element) :=

497: -- Use separate array to store zeros as Zero-Fill method may not have been chosen for journal allocation.
498: --
499: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment := JG_CREATE_JOURNALS_PKG.G_key_segment;
500: JG_CREATE_JOURNALS_PKG.zero_fill_segments(JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment);
501: JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment(JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element) :=
502: JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account;
503: --
504: -- Calculate net totals
505: --

Line 506: l_net_total_accted_offset_amt := NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt, 0) -

502: JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account;
503: --
504: -- Calculate net totals
505: --
506: l_net_total_accted_offset_amt := NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt, 0) -
507: NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt, 0);
508: l_net_total_entered_offset_amt := NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt, 0) -
509: NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt, 0);
510:

Line 507: NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt, 0);

503: --
504: -- Calculate net totals
505: --
506: l_net_total_accted_offset_amt := NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt, 0) -
507: NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt, 0);
508: l_net_total_entered_offset_amt := NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt, 0) -
509: NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt, 0);
510:
511: -- Don't create offset line if net total is zero

Line 508: l_net_total_entered_offset_amt := NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt, 0) -

504: -- Calculate net totals
505: --
506: l_net_total_accted_offset_amt := NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt, 0) -
507: NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt, 0);
508: l_net_total_entered_offset_amt := NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt, 0) -
509: NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt, 0);
510:
511: -- Don't create offset line if net total is zero
512: IF l_net_total_accted_offset_amt <> 0 THEN

Line 509: NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt, 0);

505: --
506: l_net_total_accted_offset_amt := NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt, 0) -
507: NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt, 0);
508: l_net_total_entered_offset_amt := NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt, 0) -
509: NVL(JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt, 0);
510:
511: -- Don't create offset line if net total is zero
512: IF l_net_total_accted_offset_amt <> 0 THEN
513:

Line 543: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface(l_net_dr_entered_offset_total,

539: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N') THEN
540: --
541: -- Insert for offset account (one line that is the net of the credits and debits)
542: --
543: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface(l_net_dr_entered_offset_total,
544: l_net_cr_entered_offset_total,
545: l_net_dr_accted_offset_total,
546: l_net_cr_accted_offset_total,
547: TRUE) THEN

Line 549: JG_CREATE_JOURNALS_PKG.write_error_to_output;

545: l_net_dr_accted_offset_total,
546: l_net_cr_accted_offset_total,
547: TRUE) THEN
548: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');
549: JG_CREATE_JOURNALS_PKG.write_error_to_output;
550: RAISE APP_EXCEPTION.application_exception;
551: END IF;
552: END IF;
553: --

Line 558: JG_CREATE_JOURNALS_PKG.i := JG_CREATE_JOURNALS_PKG.i + 1;

554: -- populate array for reporting allocated lines at end of program
555: -- for offset account: one line for the net credits/debits total
556: --
557: -- increment array counter
558: JG_CREATE_JOURNALS_PKG.i := JG_CREATE_JOURNALS_PKG.i + 1;
559:
560: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name := 'OFFSET FOR ACCOUNT RANGE';
561: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name := NULL;
562: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num := NULL;

Line 560: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name := 'OFFSET FOR ACCOUNT RANGE';

556: --
557: -- increment array counter
558: JG_CREATE_JOURNALS_PKG.i := JG_CREATE_JOURNALS_PKG.i + 1;
559:
560: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name := 'OFFSET FOR ACCOUNT RANGE';
561: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name := NULL;
562: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num := NULL;
563: --
564: -- Use the code combination id of the last row to build the output accounting flexfield of the offset line

Line 561: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name := NULL;

557: -- increment array counter
558: JG_CREATE_JOURNALS_PKG.i := JG_CREATE_JOURNALS_PKG.i + 1;
559:
560: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name := 'OFFSET FOR ACCOUNT RANGE';
561: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name := NULL;
562: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num := NULL;
563: --
564: -- Use the code combination id of the last row to build the output accounting flexfield of the offset line
565: --

Line 562: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num := NULL;

558: JG_CREATE_JOURNALS_PKG.i := JG_CREATE_JOURNALS_PKG.i + 1;
559:
560: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name := 'OFFSET FOR ACCOUNT RANGE';
561: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name := NULL;
562: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num := NULL;
563: --
564: -- Use the code combination id of the last row to build the output accounting flexfield of the offset line
565: --
566: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id

Line 566: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id

562: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num := NULL;
563: --
564: -- Use the code combination id of the last row to build the output accounting flexfield of the offset line
565: --
566: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id
567: := JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.code_combination_id;
568: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id
569: := JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.cc_range_id;
570: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_RANGE_OFFSET');

Line 568: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id

564: -- Use the code combination id of the last row to build the output accounting flexfield of the offset line
565: --
566: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id
567: := JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.code_combination_id;
568: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id
569: := JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.cc_range_id;
570: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_RANGE_OFFSET');
571: l_range_offset_remark := substr(FND_MESSAGE.GET,1,240);
572: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).remarks := l_range_offset_remark;

Line 572: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).remarks := l_range_offset_remark;

568: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id
569: := JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.cc_range_id;
570: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_RANGE_OFFSET');
571: l_range_offset_remark := substr(FND_MESSAGE.GET,1,240);
572: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).remarks := l_range_offset_remark;
573: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr := NULL;
574: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr := NULL;
575: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number :=
576: JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account;

Line 573: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr := NULL;

569: := JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.cc_range_id;
570: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_RANGE_OFFSET');
571: l_range_offset_remark := substr(FND_MESSAGE.GET,1,240);
572: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).remarks := l_range_offset_remark;
573: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr := NULL;
574: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr := NULL;
575: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number :=
576: JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account;
577: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_net_cr_accted_offset_total;

Line 574: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr := NULL;

570: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_RANGE_OFFSET');
571: l_range_offset_remark := substr(FND_MESSAGE.GET,1,240);
572: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).remarks := l_range_offset_remark;
573: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr := NULL;
574: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr := NULL;
575: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number :=
576: JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account;
577: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_net_cr_accted_offset_total;
578: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_net_dr_accted_offset_total;

Line 575: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number :=

571: l_range_offset_remark := substr(FND_MESSAGE.GET,1,240);
572: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).remarks := l_range_offset_remark;
573: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr := NULL;
574: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr := NULL;
575: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number :=
576: JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account;
577: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_net_cr_accted_offset_total;
578: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_net_dr_accted_offset_total;
579: --

Line 577: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_net_cr_accted_offset_total;

573: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr := NULL;
574: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr := NULL;
575: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number :=
576: JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account;
577: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_net_cr_accted_offset_total;
578: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_net_dr_accted_offset_total;
579: --
580: -- Cumulative totals for report output (allocated accts)
581: --

Line 578: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_net_dr_accted_offset_total;

574: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr := NULL;
575: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number :=
576: JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account;
577: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_net_cr_accted_offset_total;
578: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_net_dr_accted_offset_total;
579: --
580: -- Cumulative totals for report output (allocated accts)
581: --
582: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt

Line 582: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt

578: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_net_dr_accted_offset_total;
579: --
580: -- Cumulative totals for report output (allocated accts)
581: --
582: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt
583: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(l_net_cr_accted_offset_total, 0);
584: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
585: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(l_net_dr_accted_offset_total, 0);
586:

Line 583: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(l_net_cr_accted_offset_total, 0);

579: --
580: -- Cumulative totals for report output (allocated accts)
581: --
582: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt
583: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(l_net_cr_accted_offset_total, 0);
584: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
585: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(l_net_dr_accted_offset_total, 0);
586:
587: END IF; -- End of net 0 check

Line 584: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt

580: -- Cumulative totals for report output (allocated accts)
581: --
582: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt
583: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(l_net_cr_accted_offset_total, 0);
584: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
585: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(l_net_dr_accted_offset_total, 0);
586:
587: END IF; -- End of net 0 check
588:

Line 585: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(l_net_dr_accted_offset_total, 0);

581: --
582: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt
583: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(l_net_cr_accted_offset_total, 0);
584: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
585: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(l_net_dr_accted_offset_total, 0);
586:
587: END IF; -- End of net 0 check
588:
589: --

Line 592: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := 0;

588:
589: --
590: -- Reinitialize offset totals
591: --
592: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := 0;
593: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := 0;
594: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := 0;
595: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := 0;
596: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');

Line 593: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := 0;

589: --
590: -- Reinitialize offset totals
591: --
592: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := 0;
593: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := 0;
594: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := 0;
595: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := 0;
596: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');
597: END create_offset_for_acct_range;

Line 594: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := 0;

590: -- Reinitialize offset totals
591: --
592: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := 0;
593: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := 0;
594: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := 0;
595: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := 0;
596: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');
597: END create_offset_for_acct_range;
598:

Line 595: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := 0;

591: --
592: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := 0;
593: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := 0;
594: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := 0;
595: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := 0;
596: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');
597: END create_offset_for_acct_range;
598:
599: /* ---------------------------------------------------------------------

Line 596: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');

592: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := 0;
593: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := 0;
594: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := 0;
595: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := 0;
596: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');
597: END create_offset_for_acct_range;
598:
599: /* ---------------------------------------------------------------------
600: | PUBLIC PROCEDURE |

Line 612: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.write_error_to_output');

608: PROCEDURE write_error_to_output IS
609: l_acct_segments VARCHAR2(2000);
610: l_error_message VARCHAR2(2000) := NULL;
611: BEGIN
612: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.write_error_to_output');
613: --
614: -- Construct accounting flexfield segments string
615: --
616: l_acct_segments := fnd_flex_ext.get_segs(JG_JOURNAL_ALLOCATIONS_PKG.G_GL_appln_short_name,

Line 649: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.write_error_to_output');

645: JG_ALLOCATE_JOURNALS_PKG.G_currency_format_mask), ' ') ,1,15), 15)||' '||
646: LPAD(SUBSTR(NVL(TO_CHAR(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_cr,
647: JG_ALLOCATE_JOURNALS_PKG.G_currency_format_mask), ' ') ,1,15),15));
648: END IF;
649: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.write_error_to_output');
650: END write_error_to_output;
651:
652: /* ------------------------------------------------------------------------------
653: | PUBLIC PROCEDURE |

Line 708: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.create_journal');

704: l_rounded_accted_dr_sum NUMBER := 0;
705: l_rounded_entered_cr_sum NUMBER := 0;
706: l_rounded_entered_dr_sum NUMBER := 0;
707: BEGIN
708: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.create_journal');
709: --
710: -- Only create offset row if latest fiscal journal line falls into a different account range than the last line.
711: -- We are inserting an offset line for all lines under the same account range up to the last journal record.
712: -- Separate offset range also created if the currency has changed, journal import implicitly creates a separate

Line 724: JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range;

720: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id) OR
721: ((JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_code <>
722: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_code) AND JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type = 'E')) THEN
723: JG_UTILITY_PKG.debug( ' creating offset line for acct range ');
724: JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range;
725: END IF;
726:
727:
728: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_Destn_Cost_Center_Grouping = 'Y') THEN

Line 733: JG_CREATE_JOURNALS_PKG.G_Journal_Name := NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_description,

729: --
730: -- Set the Journal Header Name to include Cost Center Range Description; supply the cc range id if the description is null
731: --
732: l_cc_range_code := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_low||' - '||JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_high;
733: JG_CREATE_JOURNALS_PKG.G_Journal_Name := NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_description,
734: TO_CHAR(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id));
735: JG_CREATE_JOURNALS_PKG.G_Journal_Description := NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_description||' '||l_cc_range_code,
736: l_cc_range_code);
737: JG_UTILITY_PKG.debug('Journal Header = ' || JG_CREATE_JOURNALS_PKG.G_Journal_Name);

Line 735: JG_CREATE_JOURNALS_PKG.G_Journal_Description := NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_description||' '||l_cc_range_code,

731: --
732: l_cc_range_code := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_low||' - '||JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_high;
733: JG_CREATE_JOURNALS_PKG.G_Journal_Name := NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_description,
734: TO_CHAR(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id));
735: JG_CREATE_JOURNALS_PKG.G_Journal_Description := NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_description||' '||l_cc_range_code,
736: l_cc_range_code);
737: JG_UTILITY_PKG.debug('Journal Header = ' || JG_CREATE_JOURNALS_PKG.G_Journal_Name);
738: END IF;
739:

Line 737: JG_UTILITY_PKG.debug('Journal Header = ' || JG_CREATE_JOURNALS_PKG.G_Journal_Name);

733: JG_CREATE_JOURNALS_PKG.G_Journal_Name := NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_description,
734: TO_CHAR(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id));
735: JG_CREATE_JOURNALS_PKG.G_Journal_Description := NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_description||' '||l_cc_range_code,
736: l_cc_range_code);
737: JG_UTILITY_PKG.debug('Journal Header = ' || JG_CREATE_JOURNALS_PKG.G_Journal_Name);
738: END IF;
739:
740:
741: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N') THEN

Line 745: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment1;

741: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N') THEN
742: --
743: -- Build destination account
744: --
745: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment1;
746: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment2;
747: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment3;
748: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment4;
749: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment5;

Line 746: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment2;

742: --
743: -- Build destination account
744: --
745: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment1;
746: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment2;
747: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment3;
748: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment4;
749: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment5;
750: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment6;

Line 747: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment3;

743: -- Build destination account
744: --
745: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment1;
746: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment2;
747: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment3;
748: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment4;
749: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment5;
750: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment6;
751: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment7;

Line 748: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment4;

744: --
745: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment1;
746: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment2;
747: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment3;
748: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment4;
749: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment5;
750: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment6;
751: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment7;
752: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment8;

Line 749: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment5;

745: JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment1;
746: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment2;
747: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment3;
748: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment4;
749: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment5;
750: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment6;
751: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment7;
752: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment8;
753: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment9;

Line 750: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment6;

746: JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment2;
747: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment3;
748: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment4;
749: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment5;
750: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment6;
751: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment7;
752: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment8;
753: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment9;
754: JG_CREATE_JOURNALS_PKG.G_key_segment(10 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment10;

Line 751: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment7;

747: JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment3;
748: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment4;
749: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment5;
750: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment6;
751: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment7;
752: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment8;
753: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment9;
754: JG_CREATE_JOURNALS_PKG.G_key_segment(10 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment10;
755: JG_CREATE_JOURNALS_PKG.G_key_segment(11 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment11;

Line 752: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment8;

748: JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment4;
749: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment5;
750: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment6;
751: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment7;
752: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment8;
753: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment9;
754: JG_CREATE_JOURNALS_PKG.G_key_segment(10 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment10;
755: JG_CREATE_JOURNALS_PKG.G_key_segment(11 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment11;
756: JG_CREATE_JOURNALS_PKG.G_key_segment(12 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment12;

Line 753: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment9;

749: JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment5;
750: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment6;
751: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment7;
752: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment8;
753: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment9;
754: JG_CREATE_JOURNALS_PKG.G_key_segment(10 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment10;
755: JG_CREATE_JOURNALS_PKG.G_key_segment(11 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment11;
756: JG_CREATE_JOURNALS_PKG.G_key_segment(12 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment12;
757: JG_CREATE_JOURNALS_PKG.G_key_segment(13 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment13;

Line 754: JG_CREATE_JOURNALS_PKG.G_key_segment(10 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment10;

750: JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment6;
751: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment7;
752: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment8;
753: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment9;
754: JG_CREATE_JOURNALS_PKG.G_key_segment(10 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment10;
755: JG_CREATE_JOURNALS_PKG.G_key_segment(11 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment11;
756: JG_CREATE_JOURNALS_PKG.G_key_segment(12 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment12;
757: JG_CREATE_JOURNALS_PKG.G_key_segment(13 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment13;
758: JG_CREATE_JOURNALS_PKG.G_key_segment(14 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment14;

Line 755: JG_CREATE_JOURNALS_PKG.G_key_segment(11 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment11;

751: JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment7;
752: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment8;
753: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment9;
754: JG_CREATE_JOURNALS_PKG.G_key_segment(10 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment10;
755: JG_CREATE_JOURNALS_PKG.G_key_segment(11 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment11;
756: JG_CREATE_JOURNALS_PKG.G_key_segment(12 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment12;
757: JG_CREATE_JOURNALS_PKG.G_key_segment(13 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment13;
758: JG_CREATE_JOURNALS_PKG.G_key_segment(14 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment14;
759: JG_CREATE_JOURNALS_PKG.G_key_segment(15 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment15;

Line 756: JG_CREATE_JOURNALS_PKG.G_key_segment(12 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment12;

752: JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment8;
753: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment9;
754: JG_CREATE_JOURNALS_PKG.G_key_segment(10 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment10;
755: JG_CREATE_JOURNALS_PKG.G_key_segment(11 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment11;
756: JG_CREATE_JOURNALS_PKG.G_key_segment(12 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment12;
757: JG_CREATE_JOURNALS_PKG.G_key_segment(13 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment13;
758: JG_CREATE_JOURNALS_PKG.G_key_segment(14 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment14;
759: JG_CREATE_JOURNALS_PKG.G_key_segment(15 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment15;
760: JG_CREATE_JOURNALS_PKG.G_key_segment(16 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment16;

Line 757: JG_CREATE_JOURNALS_PKG.G_key_segment(13 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment13;

753: JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment9;
754: JG_CREATE_JOURNALS_PKG.G_key_segment(10 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment10;
755: JG_CREATE_JOURNALS_PKG.G_key_segment(11 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment11;
756: JG_CREATE_JOURNALS_PKG.G_key_segment(12 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment12;
757: JG_CREATE_JOURNALS_PKG.G_key_segment(13 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment13;
758: JG_CREATE_JOURNALS_PKG.G_key_segment(14 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment14;
759: JG_CREATE_JOURNALS_PKG.G_key_segment(15 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment15;
760: JG_CREATE_JOURNALS_PKG.G_key_segment(16 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment16;
761: JG_CREATE_JOURNALS_PKG.G_key_segment(17 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment17;

Line 758: JG_CREATE_JOURNALS_PKG.G_key_segment(14 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment14;

754: JG_CREATE_JOURNALS_PKG.G_key_segment(10 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment10;
755: JG_CREATE_JOURNALS_PKG.G_key_segment(11 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment11;
756: JG_CREATE_JOURNALS_PKG.G_key_segment(12 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment12;
757: JG_CREATE_JOURNALS_PKG.G_key_segment(13 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment13;
758: JG_CREATE_JOURNALS_PKG.G_key_segment(14 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment14;
759: JG_CREATE_JOURNALS_PKG.G_key_segment(15 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment15;
760: JG_CREATE_JOURNALS_PKG.G_key_segment(16 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment16;
761: JG_CREATE_JOURNALS_PKG.G_key_segment(17 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment17;
762: JG_CREATE_JOURNALS_PKG.G_key_segment(18 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment18;

Line 759: JG_CREATE_JOURNALS_PKG.G_key_segment(15 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment15;

755: JG_CREATE_JOURNALS_PKG.G_key_segment(11 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment11;
756: JG_CREATE_JOURNALS_PKG.G_key_segment(12 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment12;
757: JG_CREATE_JOURNALS_PKG.G_key_segment(13 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment13;
758: JG_CREATE_JOURNALS_PKG.G_key_segment(14 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment14;
759: JG_CREATE_JOURNALS_PKG.G_key_segment(15 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment15;
760: JG_CREATE_JOURNALS_PKG.G_key_segment(16 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment16;
761: JG_CREATE_JOURNALS_PKG.G_key_segment(17 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment17;
762: JG_CREATE_JOURNALS_PKG.G_key_segment(18 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment18;
763: JG_CREATE_JOURNALS_PKG.G_key_segment(19 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment19;

Line 760: JG_CREATE_JOURNALS_PKG.G_key_segment(16 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment16;

756: JG_CREATE_JOURNALS_PKG.G_key_segment(12 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment12;
757: JG_CREATE_JOURNALS_PKG.G_key_segment(13 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment13;
758: JG_CREATE_JOURNALS_PKG.G_key_segment(14 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment14;
759: JG_CREATE_JOURNALS_PKG.G_key_segment(15 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment15;
760: JG_CREATE_JOURNALS_PKG.G_key_segment(16 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment16;
761: JG_CREATE_JOURNALS_PKG.G_key_segment(17 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment17;
762: JG_CREATE_JOURNALS_PKG.G_key_segment(18 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment18;
763: JG_CREATE_JOURNALS_PKG.G_key_segment(19 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment19;
764: JG_CREATE_JOURNALS_PKG.G_key_segment(20 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment20;

Line 761: JG_CREATE_JOURNALS_PKG.G_key_segment(17 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment17;

757: JG_CREATE_JOURNALS_PKG.G_key_segment(13 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment13;
758: JG_CREATE_JOURNALS_PKG.G_key_segment(14 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment14;
759: JG_CREATE_JOURNALS_PKG.G_key_segment(15 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment15;
760: JG_CREATE_JOURNALS_PKG.G_key_segment(16 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment16;
761: JG_CREATE_JOURNALS_PKG.G_key_segment(17 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment17;
762: JG_CREATE_JOURNALS_PKG.G_key_segment(18 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment18;
763: JG_CREATE_JOURNALS_PKG.G_key_segment(19 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment19;
764: JG_CREATE_JOURNALS_PKG.G_key_segment(20 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment20;
765: JG_CREATE_JOURNALS_PKG.G_key_segment(21 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment21;

Line 762: JG_CREATE_JOURNALS_PKG.G_key_segment(18 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment18;

758: JG_CREATE_JOURNALS_PKG.G_key_segment(14 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment14;
759: JG_CREATE_JOURNALS_PKG.G_key_segment(15 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment15;
760: JG_CREATE_JOURNALS_PKG.G_key_segment(16 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment16;
761: JG_CREATE_JOURNALS_PKG.G_key_segment(17 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment17;
762: JG_CREATE_JOURNALS_PKG.G_key_segment(18 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment18;
763: JG_CREATE_JOURNALS_PKG.G_key_segment(19 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment19;
764: JG_CREATE_JOURNALS_PKG.G_key_segment(20 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment20;
765: JG_CREATE_JOURNALS_PKG.G_key_segment(21 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment21;
766: JG_CREATE_JOURNALS_PKG.G_key_segment(22 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment22;

Line 763: JG_CREATE_JOURNALS_PKG.G_key_segment(19 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment19;

759: JG_CREATE_JOURNALS_PKG.G_key_segment(15 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment15;
760: JG_CREATE_JOURNALS_PKG.G_key_segment(16 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment16;
761: JG_CREATE_JOURNALS_PKG.G_key_segment(17 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment17;
762: JG_CREATE_JOURNALS_PKG.G_key_segment(18 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment18;
763: JG_CREATE_JOURNALS_PKG.G_key_segment(19 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment19;
764: JG_CREATE_JOURNALS_PKG.G_key_segment(20 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment20;
765: JG_CREATE_JOURNALS_PKG.G_key_segment(21 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment21;
766: JG_CREATE_JOURNALS_PKG.G_key_segment(22 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment22;
767: JG_CREATE_JOURNALS_PKG.G_key_segment(23 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment23;

Line 764: JG_CREATE_JOURNALS_PKG.G_key_segment(20 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment20;

760: JG_CREATE_JOURNALS_PKG.G_key_segment(16 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment16;
761: JG_CREATE_JOURNALS_PKG.G_key_segment(17 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment17;
762: JG_CREATE_JOURNALS_PKG.G_key_segment(18 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment18;
763: JG_CREATE_JOURNALS_PKG.G_key_segment(19 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment19;
764: JG_CREATE_JOURNALS_PKG.G_key_segment(20 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment20;
765: JG_CREATE_JOURNALS_PKG.G_key_segment(21 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment21;
766: JG_CREATE_JOURNALS_PKG.G_key_segment(22 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment22;
767: JG_CREATE_JOURNALS_PKG.G_key_segment(23 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment23;
768: JG_CREATE_JOURNALS_PKG.G_key_segment(24 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment24;

Line 765: JG_CREATE_JOURNALS_PKG.G_key_segment(21 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment21;

761: JG_CREATE_JOURNALS_PKG.G_key_segment(17 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment17;
762: JG_CREATE_JOURNALS_PKG.G_key_segment(18 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment18;
763: JG_CREATE_JOURNALS_PKG.G_key_segment(19 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment19;
764: JG_CREATE_JOURNALS_PKG.G_key_segment(20 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment20;
765: JG_CREATE_JOURNALS_PKG.G_key_segment(21 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment21;
766: JG_CREATE_JOURNALS_PKG.G_key_segment(22 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment22;
767: JG_CREATE_JOURNALS_PKG.G_key_segment(23 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment23;
768: JG_CREATE_JOURNALS_PKG.G_key_segment(24 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment24;
769: JG_CREATE_JOURNALS_PKG.G_key_segment(25 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment25;

Line 766: JG_CREATE_JOURNALS_PKG.G_key_segment(22 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment22;

762: JG_CREATE_JOURNALS_PKG.G_key_segment(18 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment18;
763: JG_CREATE_JOURNALS_PKG.G_key_segment(19 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment19;
764: JG_CREATE_JOURNALS_PKG.G_key_segment(20 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment20;
765: JG_CREATE_JOURNALS_PKG.G_key_segment(21 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment21;
766: JG_CREATE_JOURNALS_PKG.G_key_segment(22 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment22;
767: JG_CREATE_JOURNALS_PKG.G_key_segment(23 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment23;
768: JG_CREATE_JOURNALS_PKG.G_key_segment(24 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment24;
769: JG_CREATE_JOURNALS_PKG.G_key_segment(25 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment25;
770: JG_CREATE_JOURNALS_PKG.G_key_segment(26 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment26;

Line 767: JG_CREATE_JOURNALS_PKG.G_key_segment(23 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment23;

763: JG_CREATE_JOURNALS_PKG.G_key_segment(19 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment19;
764: JG_CREATE_JOURNALS_PKG.G_key_segment(20 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment20;
765: JG_CREATE_JOURNALS_PKG.G_key_segment(21 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment21;
766: JG_CREATE_JOURNALS_PKG.G_key_segment(22 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment22;
767: JG_CREATE_JOURNALS_PKG.G_key_segment(23 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment23;
768: JG_CREATE_JOURNALS_PKG.G_key_segment(24 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment24;
769: JG_CREATE_JOURNALS_PKG.G_key_segment(25 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment25;
770: JG_CREATE_JOURNALS_PKG.G_key_segment(26 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment26;
771: JG_CREATE_JOURNALS_PKG.G_key_segment(27 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment27;

Line 768: JG_CREATE_JOURNALS_PKG.G_key_segment(24 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment24;

764: JG_CREATE_JOURNALS_PKG.G_key_segment(20 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment20;
765: JG_CREATE_JOURNALS_PKG.G_key_segment(21 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment21;
766: JG_CREATE_JOURNALS_PKG.G_key_segment(22 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment22;
767: JG_CREATE_JOURNALS_PKG.G_key_segment(23 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment23;
768: JG_CREATE_JOURNALS_PKG.G_key_segment(24 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment24;
769: JG_CREATE_JOURNALS_PKG.G_key_segment(25 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment25;
770: JG_CREATE_JOURNALS_PKG.G_key_segment(26 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment26;
771: JG_CREATE_JOURNALS_PKG.G_key_segment(27 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment27;
772: JG_CREATE_JOURNALS_PKG.G_key_segment(28 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;

Line 769: JG_CREATE_JOURNALS_PKG.G_key_segment(25 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment25;

765: JG_CREATE_JOURNALS_PKG.G_key_segment(21 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment21;
766: JG_CREATE_JOURNALS_PKG.G_key_segment(22 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment22;
767: JG_CREATE_JOURNALS_PKG.G_key_segment(23 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment23;
768: JG_CREATE_JOURNALS_PKG.G_key_segment(24 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment24;
769: JG_CREATE_JOURNALS_PKG.G_key_segment(25 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment25;
770: JG_CREATE_JOURNALS_PKG.G_key_segment(26 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment26;
771: JG_CREATE_JOURNALS_PKG.G_key_segment(27 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment27;
772: JG_CREATE_JOURNALS_PKG.G_key_segment(28 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;
773: JG_CREATE_JOURNALS_PKG.G_key_segment(29 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;

Line 770: JG_CREATE_JOURNALS_PKG.G_key_segment(26 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment26;

766: JG_CREATE_JOURNALS_PKG.G_key_segment(22 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment22;
767: JG_CREATE_JOURNALS_PKG.G_key_segment(23 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment23;
768: JG_CREATE_JOURNALS_PKG.G_key_segment(24 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment24;
769: JG_CREATE_JOURNALS_PKG.G_key_segment(25 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment25;
770: JG_CREATE_JOURNALS_PKG.G_key_segment(26 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment26;
771: JG_CREATE_JOURNALS_PKG.G_key_segment(27 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment27;
772: JG_CREATE_JOURNALS_PKG.G_key_segment(28 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;
773: JG_CREATE_JOURNALS_PKG.G_key_segment(29 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;
774: JG_CREATE_JOURNALS_PKG.G_key_segment(30 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment30;

Line 771: JG_CREATE_JOURNALS_PKG.G_key_segment(27 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment27;

767: JG_CREATE_JOURNALS_PKG.G_key_segment(23 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment23;
768: JG_CREATE_JOURNALS_PKG.G_key_segment(24 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment24;
769: JG_CREATE_JOURNALS_PKG.G_key_segment(25 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment25;
770: JG_CREATE_JOURNALS_PKG.G_key_segment(26 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment26;
771: JG_CREATE_JOURNALS_PKG.G_key_segment(27 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment27;
772: JG_CREATE_JOURNALS_PKG.G_key_segment(28 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;
773: JG_CREATE_JOURNALS_PKG.G_key_segment(29 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;
774: JG_CREATE_JOURNALS_PKG.G_key_segment(30 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment30;
775:

Line 772: JG_CREATE_JOURNALS_PKG.G_key_segment(28 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;

768: JG_CREATE_JOURNALS_PKG.G_key_segment(24 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment24;
769: JG_CREATE_JOURNALS_PKG.G_key_segment(25 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment25;
770: JG_CREATE_JOURNALS_PKG.G_key_segment(26 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment26;
771: JG_CREATE_JOURNALS_PKG.G_key_segment(27 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment27;
772: JG_CREATE_JOURNALS_PKG.G_key_segment(28 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;
773: JG_CREATE_JOURNALS_PKG.G_key_segment(29 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;
774: JG_CREATE_JOURNALS_PKG.G_key_segment(30 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment30;
775:
776: --

Line 773: JG_CREATE_JOURNALS_PKG.G_key_segment(29 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;

769: JG_CREATE_JOURNALS_PKG.G_key_segment(25 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment25;
770: JG_CREATE_JOURNALS_PKG.G_key_segment(26 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment26;
771: JG_CREATE_JOURNALS_PKG.G_key_segment(27 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment27;
772: JG_CREATE_JOURNALS_PKG.G_key_segment(28 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;
773: JG_CREATE_JOURNALS_PKG.G_key_segment(29 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;
774: JG_CREATE_JOURNALS_PKG.G_key_segment(30 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment30;
775:
776: --
777: -- Zero-Fill some of the segments if Zero-Fill method was chosen

Line 774: JG_CREATE_JOURNALS_PKG.G_key_segment(30 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment30;

770: JG_CREATE_JOURNALS_PKG.G_key_segment(26 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment26;
771: JG_CREATE_JOURNALS_PKG.G_key_segment(27 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment27;
772: JG_CREATE_JOURNALS_PKG.G_key_segment(28 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;
773: JG_CREATE_JOURNALS_PKG.G_key_segment(29 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment28;
774: JG_CREATE_JOURNALS_PKG.G_key_segment(30 ) := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.segment30;
775:
776: --
777: -- Zero-Fill some of the segments if Zero-Fill method was chosen
778: --

Line 780: zero_fill_segments(JG_CREATE_JOURNALS_PKG.G_key_segment);

776: --
777: -- Zero-Fill some of the segments if Zero-Fill method was chosen
778: --
779: IF JG_JOURNAL_ALLOCATIONS_PKG.G_destn_segment_method = 'ZF' THEN
780: zero_fill_segments(JG_CREATE_JOURNALS_PKG.G_key_segment);
781: END IF;
782: END IF; -- Validate_Only check
783: --
784: -- Store a pointer to the first entry in the allocation lines array for this journal line

Line 786: l_first_alloc_for_jrnal := JG_CREATE_JOURNALS_PKG.i + 1;

782: END IF; -- Validate_Only check
783: --
784: -- Store a pointer to the first entry in the allocation lines array for this journal line
785: --
786: l_first_alloc_for_jrnal := JG_CREATE_JOURNALS_PKG.i + 1;
787: --
788: -- loop for each destination account number and allocation
789: --
790: JG_UTILITY_PKG.debug(TO_CHAR(SYSDATE, 'HH24:MI:SS'));

Line 821: JG_CREATE_JOURNALS_PKG.i := JG_CREATE_JOURNALS_PKG.i + 1;

817: l_rounded_accted_cr_sum := l_rounded_accted_cr_sum + NVL(l_accted_credit_amount, 0);
818: l_rounded_accted_dr_sum := l_rounded_accted_dr_sum + NVL(l_accted_debit_amount, 0);
819: l_rounded_entered_cr_sum := l_rounded_entered_cr_sum + NVL(l_entered_credit_amount, 0);
820: l_rounded_entered_dr_sum := l_rounded_entered_dr_sum + NVL(l_entered_debit_amount, 0);
821: JG_CREATE_JOURNALS_PKG.i := JG_CREATE_JOURNALS_PKG.i + 1;
822: --
823: -- Check if current allocation percentage is greater than any of previous percentages
824: -- for journal line. Any rounding error is applied to the line with the greatest allocation percentage.
825: --

Line 830: l_max_prc_alloc_line_for_jrnal := JG_CREATE_JOURNALS_PKG.i;

826: IF NVL(l_max_prc_alloc_for_jrnal, 0) < c_rule_line_rec.allocation_percent AND
827: JG_ALLOCATE_JOURNALS_PKG.G_jrnl_total_allocn_percent = 100 THEN
828: l_is_max_prc_alloc_line := TRUE;
829: l_max_prc_alloc_for_jrnal := c_rule_line_rec.allocation_percent;
830: l_max_prc_alloc_line_for_jrnal := JG_CREATE_JOURNALS_PKG.i;
831: END IF;
832: --
833: -- Populate allocated lines table for reporting and later gl_interface insertion
834: --

Line 835: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name

831: END IF;
832: --
833: -- Populate allocated lines table for reporting and later gl_interface insertion
834: --
835: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name
836: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name;
837: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name
838: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name;
839: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num

Line 837: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name

833: -- Populate allocated lines table for reporting and later gl_interface insertion
834: --
835: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name
836: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name;
837: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name
838: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name;
839: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num
840: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num;
841: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id

Line 839: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num

835: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name
836: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name;
837: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name
838: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name;
839: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num
840: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num;
841: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id
842: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.code_combination_id;
843: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id

Line 841: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id

837: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name
838: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name;
839: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num
840: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num;
841: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id
842: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.code_combination_id;
843: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id
844: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id;
845: IF JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id <> NVL(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.cc_range_id, -99)

Line 843: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id

839: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num
840: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num;
841: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id
842: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.code_combination_id;
843: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id
844: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id;
845: IF JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id <> NVL(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.cc_range_id, -99)
846: AND l_first_alloc_for_jrnal = JG_CREATE_JOURNALS_PKG.i THEN
847: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).remarks :=

Line 846: AND l_first_alloc_for_jrnal = JG_CREATE_JOURNALS_PKG.i THEN

842: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.code_combination_id;
843: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id
844: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id;
845: IF JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id <> NVL(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.cc_range_id, -99)
846: AND l_first_alloc_for_jrnal = JG_CREATE_JOURNALS_PKG.i THEN
847: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).remarks :=
848: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_low||' - '||JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_high;
849: END IF;
850: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr

Line 847: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).remarks :=

843: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id
844: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id;
845: IF JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id <> NVL(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.cc_range_id, -99)
846: AND l_first_alloc_for_jrnal = JG_CREATE_JOURNALS_PKG.i THEN
847: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).remarks :=
848: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_low||' - '||JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_high;
849: END IF;
850: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr
851: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr;

Line 850: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr

846: AND l_first_alloc_for_jrnal = JG_CREATE_JOURNALS_PKG.i THEN
847: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).remarks :=
848: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_low||' - '||JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_high;
849: END IF;
850: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr
851: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr;
852: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr
853: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr;
854: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number

Line 852: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr

848: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_low||' - '||JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_high;
849: END IF;
850: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr
851: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr;
852: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr
853: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr;
854: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number
855: := c_rule_line_rec.natural_account;
856: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_credit_amount;

Line 854: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number

850: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr
851: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr;
852: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr
853: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr;
854: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number
855: := c_rule_line_rec.natural_account;
856: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_credit_amount;
857: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_debit_amount;
858: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_credit_amount;

Line 856: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_credit_amount;

852: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr
853: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr;
854: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number
855: := c_rule_line_rec.natural_account;
856: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_credit_amount;
857: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_debit_amount;
858: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_credit_amount;
859: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_debit_amount;
860: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));

Line 857: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_debit_amount;

853: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr;
854: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number
855: := c_rule_line_rec.natural_account;
856: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_credit_amount;
857: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_debit_amount;
858: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_credit_amount;
859: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_debit_amount;
860: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));
861:

Line 858: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_credit_amount;

854: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number
855: := c_rule_line_rec.natural_account;
856: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_credit_amount;
857: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_debit_amount;
858: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_credit_amount;
859: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_debit_amount;
860: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));
861:
862: JG_UTILITY_PKG.debug( 'batch_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name);

Line 859: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_debit_amount;

855: := c_rule_line_rec.natural_account;
856: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_credit_amount;
857: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_debit_amount;
858: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_credit_amount;
859: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_debit_amount;
860: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));
861:
862: JG_UTILITY_PKG.debug( 'batch_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name);
863: JG_UTILITY_PKG.debug('header_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name);

Line 860: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));

856: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_credit_amount;
857: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_debit_amount;
858: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_credit_amount;
859: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_debit_amount;
860: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));
861:
862: JG_UTILITY_PKG.debug( 'batch_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name);
863: JG_UTILITY_PKG.debug('header_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name);
864: JG_UTILITY_PKG.debug('accounted_cr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr));

Line 873: JG_CREATE_JOURNALS_PKG.i := JG_CREATE_JOURNALS_PKG.i + 1;

869: IF JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.offset_account IS NULL THEN
870: --
871: -- increment array counter
872: --
873: JG_CREATE_JOURNALS_PKG.i := JG_CREATE_JOURNALS_PKG.i + 1;
874: --
875: -- populate array for reporting allocated lines at end of program
876: -- for offset account: switch credits and debits for destination amounts
877: --

Line 878: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name

874: --
875: -- populate array for reporting allocated lines at end of program
876: -- for offset account: switch credits and debits for destination amounts
877: --
878: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name
879: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name;
880: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name
881: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name;
882: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num

Line 880: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name

876: -- for offset account: switch credits and debits for destination amounts
877: --
878: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name
879: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name;
880: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name
881: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name;
882: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num
883: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num;
884: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id

Line 882: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num

878: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name
879: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name;
880: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name
881: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name;
882: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num
883: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num;
884: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id
885: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.code_combination_id;
886: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id

Line 884: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id

880: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name
881: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name;
882: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num
883: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num;
884: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id
885: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.code_combination_id;
886: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id
887: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id;
888: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr

Line 886: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id

882: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num
883: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num;
884: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id
885: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.code_combination_id;
886: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id
887: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id;
888: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr
889: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr;
890: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr

Line 888: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr

884: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id
885: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.code_combination_id;
886: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id
887: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id;
888: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr
889: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr;
890: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr
891: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr;
892: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number

Line 890: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr

886: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).cc_range_id
887: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id;
888: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr
889: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr;
890: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr
891: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr;
892: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number
893: := c_rule_line_rec.offset_account;
894: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_debit_amount;

Line 892: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number

888: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_cr
889: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr;
890: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr
891: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr;
892: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number
893: := c_rule_line_rec.offset_account;
894: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_debit_amount;
895: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_credit_amount;
896: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_debit_amount;

Line 894: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_debit_amount;

890: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).accounted_dr
891: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr;
892: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number
893: := c_rule_line_rec.offset_account;
894: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_debit_amount;
895: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_credit_amount;
896: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_debit_amount;
897: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_credit_amount;
898: --

Line 895: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_credit_amount;

891: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr;
892: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number
893: := c_rule_line_rec.offset_account;
894: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_debit_amount;
895: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_credit_amount;
896: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_debit_amount;
897: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_credit_amount;
898: --
899: -- If have max percentage allocation line so far, then set the offset line array number aswell

Line 896: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_debit_amount;

892: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_account_number
893: := c_rule_line_rec.offset_account;
894: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_debit_amount;
895: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_credit_amount;
896: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_debit_amount;
897: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_credit_amount;
898: --
899: -- If have max percentage allocation line so far, then set the offset line array number aswell
900: --

Line 897: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_credit_amount;

893: := c_rule_line_rec.offset_account;
894: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_debit_amount;
895: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_credit_amount;
896: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_debit_amount;
897: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_credit_amount;
898: --
899: -- If have max percentage allocation line so far, then set the offset line array number aswell
900: --
901: IF l_is_max_prc_alloc_line THEN

Line 902: l_max_prc_offst_line_for_jrnal := JG_CREATE_JOURNALS_PKG.i;

898: --
899: -- If have max percentage allocation line so far, then set the offset line array number aswell
900: --
901: IF l_is_max_prc_alloc_line THEN
902: l_max_prc_offst_line_for_jrnal := JG_CREATE_JOURNALS_PKG.i;
903: END IF;
904: END IF; -- Is the account range level offset null?
905: l_is_max_prc_alloc_line := FALSE;
906: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));

Line 906: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));

902: l_max_prc_offst_line_for_jrnal := JG_CREATE_JOURNALS_PKG.i;
903: END IF;
904: END IF; -- Is the account range level offset null?
905: l_is_max_prc_alloc_line := FALSE;
906: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));
907: END LOOP;
908: JG_UTILITY_PKG.debug(TO_CHAR(SYSDATE, 'HH24:MI:SS'));
909: --
910: -- Update entered and accounted amounts of max perc line with any rounding error total

Line 912: IF JG_CREATE_JOURNALS_PKG.i >= l_first_alloc_for_jrnal THEN

908: JG_UTILITY_PKG.debug(TO_CHAR(SYSDATE, 'HH24:MI:SS'));
909: --
910: -- Update entered and accounted amounts of max perc line with any rounding error total
911: --
912: IF JG_CREATE_JOURNALS_PKG.i >= l_first_alloc_for_jrnal THEN
913: --
914: -- Adjust calculated amounts with any rounding error difference if the line
915: -- is the maximum percentage line chosen and it is a full allocation of 100 percent
916: --

Line 921: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr :=

917: JG_UTILITY_PKG.debug( 'Perform rounding errors calculations');
918: IF NVL(l_rounded_accted_cr_sum, 0) <>
919: NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr, 0) THEN
920: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
921: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr :=
922: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr +
923: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr, 0) - NVL(l_rounded_accted_cr_sum, 0));
924: END IF;
925: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN

Line 922: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr +

918: IF NVL(l_rounded_accted_cr_sum, 0) <>
919: NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr, 0) THEN
920: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
921: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr :=
922: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr +
923: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr, 0) - NVL(l_rounded_accted_cr_sum, 0));
924: END IF;
925: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
926: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr :=

Line 926: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr :=

922: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr +
923: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr, 0) - NVL(l_rounded_accted_cr_sum, 0));
924: END IF;
925: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
926: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr :=
927: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr +
928: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr, 0) - NVL(l_rounded_accted_cr_sum, 0));
929: END IF;
930: END IF;

Line 927: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr +

923: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr, 0) - NVL(l_rounded_accted_cr_sum, 0));
924: END IF;
925: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
926: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr :=
927: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr +
928: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr, 0) - NVL(l_rounded_accted_cr_sum, 0));
929: END IF;
930: END IF;
931: IF NVL(l_rounded_accted_dr_sum, 0) <>

Line 934: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr :=

930: END IF;
931: IF NVL(l_rounded_accted_dr_sum, 0) <>
932: NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr, 0) THEN
933: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
934: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr :=
935: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr +
936: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr, 0) - NVL(l_rounded_accted_dr_sum, 0));
937: END IF;
938: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN

Line 935: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr +

931: IF NVL(l_rounded_accted_dr_sum, 0) <>
932: NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr, 0) THEN
933: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
934: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr :=
935: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr +
936: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr, 0) - NVL(l_rounded_accted_dr_sum, 0));
937: END IF;
938: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
939: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr :=

Line 939: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr :=

935: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr +
936: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr, 0) - NVL(l_rounded_accted_dr_sum, 0));
937: END IF;
938: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
939: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr :=
940: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr +
941: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr, 0) - NVL(l_rounded_accted_dr_sum, 0));
942: END IF;
943: END IF;

Line 940: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr +

936: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr, 0) - NVL(l_rounded_accted_dr_sum, 0));
937: END IF;
938: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
939: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr :=
940: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr +
941: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr, 0) - NVL(l_rounded_accted_dr_sum, 0));
942: END IF;
943: END IF;
944: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type = 'E') THEN

Line 948: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr :=

944: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type = 'E') THEN
945: IF NVL(l_rounded_entered_cr_sum, 0) <>
946: NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_cr, 0) THEN
947: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
948: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr :=
949: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr +
950: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_cr, 0) - NVL(l_rounded_entered_cr_sum, 0));
951: END IF;
952: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN

Line 949: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr +

945: IF NVL(l_rounded_entered_cr_sum, 0) <>
946: NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_cr, 0) THEN
947: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
948: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr :=
949: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr +
950: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_cr, 0) - NVL(l_rounded_entered_cr_sum, 0));
951: END IF;
952: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
953: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr :=

Line 953: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr :=

949: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr +
950: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_cr, 0) - NVL(l_rounded_entered_cr_sum, 0));
951: END IF;
952: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
953: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr :=
954: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr +
955: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_cr, 0) - NVL(l_rounded_entered_cr_sum, 0));
956: END IF;
957: END IF;

Line 954: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr +

950: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_cr, 0) - NVL(l_rounded_entered_cr_sum, 0));
951: END IF;
952: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
953: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr :=
954: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr +
955: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_cr, 0) - NVL(l_rounded_entered_cr_sum, 0));
956: END IF;
957: END IF;
958: IF NVL(l_rounded_entered_dr_sum, 0) <>

Line 961: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr :=

957: END IF;
958: IF NVL(l_rounded_entered_dr_sum, 0) <>
959: NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_dr, 0) THEN
960: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
961: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr :=
962: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr +
963: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_dr, 0) - NVL(l_rounded_entered_dr_sum, 0));
964: END IF;
965: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN

Line 962: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr +

958: IF NVL(l_rounded_entered_dr_sum, 0) <>
959: NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_dr, 0) THEN
960: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
961: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr :=
962: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr +
963: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_dr, 0) - NVL(l_rounded_entered_dr_sum, 0));
964: END IF;
965: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
966: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr :=

Line 966: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr :=

962: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr +
963: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_dr, 0) - NVL(l_rounded_entered_dr_sum, 0));
964: END IF;
965: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
966: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr :=
967: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr +
968: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_dr, 0) - NVL(l_rounded_entered_dr_sum, 0));
969: END IF;
970: END IF;

Line 967: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr +

963: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_dr, 0) - NVL(l_rounded_entered_dr_sum, 0));
964: END IF;
965: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
966: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr :=
967: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr +
968: (NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_dr, 0) - NVL(l_rounded_entered_dr_sum, 0));
969: END IF;
970: END IF;
971: ELSE

Line 973: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr :=

969: END IF;
970: END IF;
971: ELSE
972: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
973: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr :=
974: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr;
975: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr :=
976: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr;
977: END IF;

Line 974: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr;

970: END IF;
971: ELSE
972: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
973: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr :=
974: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr;
975: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr :=
976: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr;
977: END IF;
978: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN

Line 975: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr :=

971: ELSE
972: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
973: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr :=
974: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr;
975: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr :=
976: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr;
977: END IF;
978: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
979: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr :=

Line 976: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr;

972: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
973: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_cr :=
974: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr;
975: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr :=
976: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr;
977: END IF;
978: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
979: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr :=
980: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr;

Line 979: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr :=

975: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_entered_dr :=
976: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr;
977: END IF;
978: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
979: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr :=
980: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr;
981: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr :=
982: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr;
983: END IF;

Line 980: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr;

976: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_dr;
977: END IF;
978: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
979: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr :=
980: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr;
981: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr :=
982: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr;
983: END IF;
984: END IF; -- Amount_Type Check

Line 981: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr :=

977: END IF;
978: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
979: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr :=
980: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr;
981: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr :=
982: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr;
983: END IF;
984: END IF; -- Amount_Type Check
985: --

Line 982: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr;

978: IF l_max_prc_offst_line_for_jrnal IS NOT NULL THEN
979: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_cr :=
980: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_cr;
981: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_entered_dr :=
982: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr;
983: END IF;
984: END IF; -- Amount_Type Check
985: --
986: -- Loop for all allocation lines to insert into GL Interface

Line 989: FOR j IN l_first_alloc_for_jrnal .. JG_CREATE_JOURNALS_PKG.i LOOP

985: --
986: -- Loop for all allocation lines to insert into GL Interface
987: -- Only if at least one allocation line has been found
988: --
989: FOR j IN l_first_alloc_for_jrnal .. JG_CREATE_JOURNALS_PKG.i LOOP
990: --
991: -- Cumulative totals for report output (allocated accts)
992: --
993: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt

Line 993: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt

989: FOR j IN l_first_alloc_for_jrnal .. JG_CREATE_JOURNALS_PKG.i LOOP
990: --
991: -- Cumulative totals for report output (allocated accts)
992: --
993: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt
994: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
995: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
996: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));

Line 994: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);

990: --
991: -- Cumulative totals for report output (allocated accts)
992: --
993: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt
994: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
995: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
996: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));
998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));

Line 995: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt

991: -- Cumulative totals for report output (allocated accts)
992: --
993: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt
994: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
995: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
996: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));
998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));
999: IF JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N' THEN

Line 996: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);

992: --
993: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt
994: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
995: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
996: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));
998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));
999: IF JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N' THEN
1000: JG_UTILITY_PKG.debug( 'Inserting Allocated Journal Line number '||to_char(j));

Line 997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));

993: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt
994: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
995: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
996: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));
998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));
999: IF JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N' THEN
1000: JG_UTILITY_PKG.debug( 'Inserting Allocated Journal Line number '||to_char(j));
1001: JG_CREATE_JOURNALS_PKG.G_key_segment( JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element ) :=

Line 998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));

994: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
995: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
996: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));
998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));
999: IF JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N' THEN
1000: JG_UTILITY_PKG.debug( 'Inserting Allocated Journal Line number '||to_char(j));
1001: JG_CREATE_JOURNALS_PKG.G_key_segment( JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element ) :=
1002: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_account_number;

Line 1001: JG_CREATE_JOURNALS_PKG.G_key_segment( JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element ) :=

997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));
998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));
999: IF JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N' THEN
1000: JG_UTILITY_PKG.debug( 'Inserting Allocated Journal Line number '||to_char(j));
1001: JG_CREATE_JOURNALS_PKG.G_key_segment( JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element ) :=
1002: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_account_number;
1003: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface
1004: (JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr,
1005: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,

Line 1002: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_account_number;

998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));
999: IF JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N' THEN
1000: JG_UTILITY_PKG.debug( 'Inserting Allocated Journal Line number '||to_char(j));
1001: JG_CREATE_JOURNALS_PKG.G_key_segment( JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element ) :=
1002: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_account_number;
1003: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface
1004: (JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr,
1005: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,
1006: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,

Line 1003: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface

999: IF JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N' THEN
1000: JG_UTILITY_PKG.debug( 'Inserting Allocated Journal Line number '||to_char(j));
1001: JG_CREATE_JOURNALS_PKG.G_key_segment( JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element ) :=
1002: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_account_number;
1003: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface
1004: (JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr,
1005: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,
1006: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,
1007: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr,

Line 1004: (JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr,

1000: JG_UTILITY_PKG.debug( 'Inserting Allocated Journal Line number '||to_char(j));
1001: JG_CREATE_JOURNALS_PKG.G_key_segment( JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element ) :=
1002: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_account_number;
1003: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface
1004: (JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr,
1005: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,
1006: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,
1007: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr,
1008: FALSE) THEN

Line 1005: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,

1001: JG_CREATE_JOURNALS_PKG.G_key_segment( JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element ) :=
1002: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_account_number;
1003: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface
1004: (JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr,
1005: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,
1006: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,
1007: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr,
1008: FALSE) THEN
1009: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');

Line 1006: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,

1002: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_account_number;
1003: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface
1004: (JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr,
1005: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,
1006: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,
1007: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr,
1008: FALSE) THEN
1009: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');
1010: JG_CREATE_JOURNALS_PKG.write_error_to_output;

Line 1007: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr,

1003: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface
1004: (JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr,
1005: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,
1006: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,
1007: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr,
1008: FALSE) THEN
1009: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');
1010: JG_CREATE_JOURNALS_PKG.write_error_to_output;
1011: RAISE APP_EXCEPTION.application_exception;

Line 1010: JG_CREATE_JOURNALS_PKG.write_error_to_output;

1006: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,
1007: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr,
1008: FALSE) THEN
1009: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');
1010: JG_CREATE_JOURNALS_PKG.write_error_to_output;
1011: RAISE APP_EXCEPTION.application_exception;
1012: END IF;
1013: END IF; -- Validate_Only?
1014:

Line 1023: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt +

1019: -- will only contained allocated lines, no offsets. Hence, the below running totals will be correctly summed
1020: -- (inclusive of any rounding corrections).
1021: --
1022: IF (JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.offset_account IS NOT NULL) THEN
1023: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt +
1024: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
1025: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt +
1026: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
1027: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt +

Line 1024: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);

1020: -- (inclusive of any rounding corrections).
1021: --
1022: IF (JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.offset_account IS NOT NULL) THEN
1023: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt +
1024: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
1025: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt +
1026: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
1027: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt +
1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);

Line 1025: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt +

1021: --
1022: IF (JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.offset_account IS NOT NULL) THEN
1023: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt +
1024: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
1025: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt +
1026: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
1027: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt +
1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);
1029: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt +

Line 1026: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);

1022: IF (JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.offset_account IS NOT NULL) THEN
1023: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt +
1024: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
1025: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt +
1026: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
1027: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt +
1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);
1029: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt +
1030: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr, 0);

Line 1027: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt +

1023: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt +
1024: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
1025: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt +
1026: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
1027: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt +
1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);
1029: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt +
1030: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr, 0);
1031: JG_UTILITY_PKG.debug( 'cumulative offset accted dr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt));

Line 1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);

1024: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
1025: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt +
1026: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
1027: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt +
1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);
1029: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt +
1030: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr, 0);
1031: JG_UTILITY_PKG.debug( 'cumulative offset accted dr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt));
1032: JG_UTILITY_PKG.debug( 'cumulative offset accted cr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt));

Line 1029: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt +

1025: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt +
1026: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
1027: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt +
1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);
1029: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt +
1030: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr, 0);
1031: JG_UTILITY_PKG.debug( 'cumulative offset accted dr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt));
1032: JG_UTILITY_PKG.debug( 'cumulative offset accted cr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt));
1033: END IF;

Line 1030: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr, 0);

1026: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
1027: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt +
1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);
1029: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt +
1030: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr, 0);
1031: JG_UTILITY_PKG.debug( 'cumulative offset accted dr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt));
1032: JG_UTILITY_PKG.debug( 'cumulative offset accted cr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt));
1033: END IF;
1034: END LOOP;

Line 1031: JG_UTILITY_PKG.debug( 'cumulative offset accted dr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt));

1027: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt +
1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);
1029: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt +
1030: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr, 0);
1031: JG_UTILITY_PKG.debug( 'cumulative offset accted dr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt));
1032: JG_UTILITY_PKG.debug( 'cumulative offset accted cr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt));
1033: END IF;
1034: END LOOP;
1035: END IF; -- Have lines to allocate?

Line 1032: JG_UTILITY_PKG.debug( 'cumulative offset accted cr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt));

1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);
1029: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt +
1030: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr, 0);
1031: JG_UTILITY_PKG.debug( 'cumulative offset accted dr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt));
1032: JG_UTILITY_PKG.debug( 'cumulative offset accted cr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt));
1033: END IF;
1034: END LOOP;
1035: END IF; -- Have lines to allocate?
1036: JG_UTILITY_PKG.debug('code_comb_id = '|| to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id));

Line 1036: JG_UTILITY_PKG.debug('code_comb_id = '|| to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id));

1032: JG_UTILITY_PKG.debug( 'cumulative offset accted cr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt));
1033: END IF;
1034: END LOOP;
1035: END IF; -- Have lines to allocate?
1036: JG_UTILITY_PKG.debug('code_comb_id = '|| to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id));
1037: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_journal');
1038: END create_journal;
1039:
1040: END JG_CREATE_JOURNALS_PKG;

Line 1037: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_journal');

1033: END IF;
1034: END LOOP;
1035: END IF; -- Have lines to allocate?
1036: JG_UTILITY_PKG.debug('code_comb_id = '|| to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id));
1037: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_journal');
1038: END create_journal;
1039:
1040: END JG_CREATE_JOURNALS_PKG;

Line 1040: END JG_CREATE_JOURNALS_PKG;

1036: JG_UTILITY_PKG.debug('code_comb_id = '|| to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id));
1037: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_journal');
1038: END create_journal;
1039:
1040: END JG_CREATE_JOURNALS_PKG;