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.GL_JE_HEADERS_PKG dependencies on GL_JE_HEADERS

Line 1: PACKAGE BODY GL_JE_HEADERS_PKG as

1: PACKAGE BODY GL_JE_HEADERS_PKG as
2: /* $Header: glijhrvb.pls 120.23.12020000.2 2012/10/11 08:49:09 degoel ship $ */
3:
4: PROCEDURE check_unique(batch_id NUMBER, header_name VARCHAR2,
5: row_id VARCHAR2) IS

Line 8: FROM GL_JE_HEADERS jeh

4: PROCEDURE check_unique(batch_id NUMBER, header_name VARCHAR2,
5: row_id VARCHAR2) IS
6: CURSOR chk_duplicates is
7: SELECT 'Duplicate'
8: FROM GL_JE_HEADERS jeh
9: WHERE jeh.je_batch_id = batch_id
10: AND jeh.name = header_name
11: AND ( row_id is null
12: OR jeh.rowid <> row_id);

Line 31: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.check_unique');

27: WHEN app_exceptions.application_exception THEN
28: RAISE;
29: WHEN OTHERS THEN
30: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
31: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.check_unique');
32: RAISE;
33: END check_unique;
34:
35: FUNCTION get_unique_id RETURN NUMBER IS

Line 37: SELECT gl_je_headers_s.NEXTVAL

33: END check_unique;
34:
35: FUNCTION get_unique_id RETURN NUMBER IS
36: CURSOR get_new_id IS
37: SELECT gl_je_headers_s.NEXTVAL
38: FROM dual;
39: new_id number;
40: BEGIN
41: OPEN get_new_id;

Line 50: fnd_message.set_token('SEQUENCE', 'GL_JE_HEADERS_S');

46: return(new_id);
47: ELSE
48: CLOSE get_new_id;
49: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
50: fnd_message.set_token('SEQUENCE', 'GL_JE_HEADERS_S');
51: app_exception.raise_exception;
52: END IF;
53:
54: EXCEPTION

Line 59: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.get_unique_id');

55: WHEN app_exceptions.application_exception THEN
56: RAISE;
57: WHEN OTHERS THEN
58: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
59: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.get_unique_id');
60: RAISE;
61: END get_unique_id;
62:
63: PROCEDURE delete_headers(batch_id NUMBER) IS

Line 69: FROM gl_je_headers

65: BEGIN
66: -- Delete all of the lines in that batch
67: DELETE gl_je_lines
68: WHERE je_header_id IN (SELECT je_header_id
69: FROM gl_je_headers
70: WHERE je_batch_id = batch_id);
71:
72: -- Delete all of the segment value assignments in that
73: -- batch

Line 79: FROM gl_je_headers

75:
76: -- Delete all of the reconciliation lines
77: DELETE gl_je_lines_recon
78: WHERE je_header_id IN (SELECT je_header_id
79: FROM gl_je_headers
80: WHERE je_batch_id = batch_id);
81:
82: -- Mark all of the reversals as no longer reversals, since the
83: -- original journal has been deleted. This is necessary to fix

Line 85: UPDATE gl_je_headers

81:
82: -- Mark all of the reversals as no longer reversals, since the
83: -- original journal has been deleted. This is necessary to fix
84: -- bug #1001521
85: UPDATE gl_je_headers
86: SET reversed_je_header_id = null,
87: accrual_rev_je_header_id = decode(accrual_rev_status,
88: 'R', accrual_rev_je_header_id,
89: null)

Line 92: FROM gl_je_headers

88: 'R', accrual_rev_je_header_id,
89: null)
90: WHERE je_header_id IN
91: (SELECT accrual_rev_je_header_id
92: FROM gl_je_headers
93: WHERE je_batch_id = batch_id
94: AND accrual_rev_status = 'R');
95:
96: -- Bug fix 2749073 Mark the original journal as reversible

Line 98: UPDATE gl_je_headers

94: AND accrual_rev_status = 'R');
95:
96: -- Bug fix 2749073 Mark the original journal as reversible
97: -- incase if the reversed journal associated is deleted.
98: UPDATE gl_je_headers
99: SET accrual_rev_status = null,
100: accrual_rev_je_header_id = null,
101: accrual_rev_flag = 'Y'
102: WHERE je_header_id IN

Line 104: FROM gl_je_headers

100: accrual_rev_je_header_id = null,
101: accrual_rev_flag = 'Y'
102: WHERE je_header_id IN
103: (SELECT reversed_je_header_id
104: FROM gl_je_headers
105: WHERE je_batch_id = batch_id
106: AND reversed_je_header_id IS NOT NULL );
107:
108: --Delete the respective rows from GL_IMPORT_REFERENCES

Line 114: DELETE gl_je_headers

110: GL_IMPORT_REFERENCES_PKG.delete_batch ( batch_id);
111:
112:
113: -- Delete all of the headers in that batch
114: DELETE gl_je_headers
115: WHERE je_batch_id = batch_id;
116:
117:
118: EXCEPTION

Line 125: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.delete_headers');

121: WHEN NO_DATA_FOUND THEN
122: null;
123: WHEN OTHERS THEN
124: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
125: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.delete_headers');
126: RAISE;
127: END delete_headers;
128:
129: PROCEDURE change_effective_date(batch_id NUMBER,

Line 136: FROM gl_je_headers

132: -- Update all of the lines in the header
133: UPDATE gl_je_lines
134: SET effective_date = new_effective_date
135: WHERE je_header_id IN (SELECT je_header_id
136: FROM gl_je_headers
137: WHERE je_batch_id = batch_id);
138:
139: -- Update all of the headers in that batch
140: UPDATE gl_je_headers jeh

Line 140: UPDATE gl_je_headers jeh

136: FROM gl_je_headers
137: WHERE je_batch_id = batch_id);
138:
139: -- Update all of the headers in that batch
140: UPDATE gl_je_headers jeh
141: SET default_effective_date = new_effective_date,
142: currency_conversion_date =
143: (select decode(jeh.currency_code,
144: 'STAT', new_effective_date,

Line 165: 'gl_je_headers_pkg.change_effective_date');

161: RAISE;
162: WHEN OTHERS THEN
163: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
164: fnd_message.set_token('PROCEDURE',
165: 'gl_je_headers_pkg.change_effective_date');
166: RAISE;
167: END change_effective_date;
168:
169: PROCEDURE calculate_totals( batch_id NUMBER,

Line 180: FROM GL_JE_HEADERS jeh

176: SELECT sum(nvl(jeh.running_total_dr, 0)),
177: sum(nvl(jeh.running_total_cr, 0)),
178: sum(nvl(jeh.running_total_accounted_dr, 0)),
179: sum(nvl(jeh.running_total_accounted_cr, 0))
180: FROM GL_JE_HEADERS jeh
181: WHERE jeh.je_batch_id = batch_id
182: AND (jeh.display_alc_journal_flag is null or jeh.display_alc_journal_flag = 'Y');
183: BEGIN
184: OPEN calc_totals;

Line 199: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.calculate_totals');

195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
199: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.calculate_totals');
200: RAISE;
201: END calculate_totals;
202:
203:

Line 219: FROM gl_je_headers jeh, gl_ledgers lgr

215: CURSOR convert_headers IS
216: SELECT jeh.je_header_id, jeh.currency_code, jeh.actual_flag,
217: jeh.currency_conversion_type, jeh.je_category,
218: jeh.ledger_id, lgr.currency_code, jeh.reversed_je_header_id
219: FROM gl_je_headers jeh, gl_ledgers lgr
220: WHERE jeh.je_batch_id = batch_id
221: AND lgr.ledger_id = jeh.ledger_id
222: ORDER BY jeh.name || to_char(jeh.ledger_id)
223: FOR UPDATE OF jeh.default_effective_date, jeh.period_name,

Line 233: FROM gl_je_headers jeh, gl_ledgers lgr

229: CURSOR convert_header_range IS
230: SELECT jeh.je_header_id, jeh.currency_code, jeh.actual_flag,
231: jeh.currency_conversion_type, jeh.je_category,
232: jeh.ledger_id, lgr.currency_code, jeh.reversed_je_header_id
233: FROM gl_je_headers jeh, gl_ledgers lgr
234: WHERE jeh.je_batch_id = batch_id
235: AND lgr.ledger_id = jeh.ledger_id
236: AND jeh.name > (SELECT name || to_char(ledger_id)
237: FROM gl_je_headers

Line 237: FROM gl_je_headers

233: FROM gl_je_headers jeh, gl_ledgers lgr
234: WHERE jeh.je_batch_id = batch_id
235: AND lgr.ledger_id = jeh.ledger_id
236: AND jeh.name > (SELECT name || to_char(ledger_id)
237: FROM gl_je_headers
238: WHERE je_header_id = header_id)
239: ORDER BY jeh.name || to_char(jeh.ledger_id)
240: FOR UPDATE OF jeh.default_effective_date, jeh.period_name,
241: jeh.last_update_date, jeh.last_updated_by,

Line 247: cheader_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;

243: jeh.running_total_accounted_cr,
244: jeh.currency_conversion_rate;
245:
246: -- Various information selected from the header
247: cheader_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
248: ccurrency_code GL_JE_HEADERS.CURRENCY_CODE%TYPE;
249: cje_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
250: cje_actual_flag GL_JE_HEADERS.ACTUAL_FLAG%TYPE;
251: cconversion_date GL_JE_HEADERS.CURRENCY_CONVERSION_DATE%TYPE;

Line 248: ccurrency_code GL_JE_HEADERS.CURRENCY_CODE%TYPE;

244: jeh.currency_conversion_rate;
245:
246: -- Various information selected from the header
247: cheader_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
248: ccurrency_code GL_JE_HEADERS.CURRENCY_CODE%TYPE;
249: cje_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
250: cje_actual_flag GL_JE_HEADERS.ACTUAL_FLAG%TYPE;
251: cconversion_date GL_JE_HEADERS.CURRENCY_CONVERSION_DATE%TYPE;
252: cconversion_type GL_JE_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE;

Line 249: cje_category GL_JE_HEADERS.JE_CATEGORY%TYPE;

245:
246: -- Various information selected from the header
247: cheader_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
248: ccurrency_code GL_JE_HEADERS.CURRENCY_CODE%TYPE;
249: cje_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
250: cje_actual_flag GL_JE_HEADERS.ACTUAL_FLAG%TYPE;
251: cconversion_date GL_JE_HEADERS.CURRENCY_CONVERSION_DATE%TYPE;
252: cconversion_type GL_JE_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE;
253: cconversion_rate GL_JE_HEADERS.CURRENCY_CONVERSION_RATE%TYPE;

Line 250: cje_actual_flag GL_JE_HEADERS.ACTUAL_FLAG%TYPE;

246: -- Various information selected from the header
247: cheader_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
248: ccurrency_code GL_JE_HEADERS.CURRENCY_CODE%TYPE;
249: cje_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
250: cje_actual_flag GL_JE_HEADERS.ACTUAL_FLAG%TYPE;
251: cconversion_date GL_JE_HEADERS.CURRENCY_CONVERSION_DATE%TYPE;
252: cconversion_type GL_JE_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE;
253: cconversion_rate GL_JE_HEADERS.CURRENCY_CONVERSION_RATE%TYPE;
254: crev_jeh_id GL_JE_HEADERS.REVERSED_JE_HEADER_ID%TYPE;

Line 251: cconversion_date GL_JE_HEADERS.CURRENCY_CONVERSION_DATE%TYPE;

247: cheader_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
248: ccurrency_code GL_JE_HEADERS.CURRENCY_CODE%TYPE;
249: cje_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
250: cje_actual_flag GL_JE_HEADERS.ACTUAL_FLAG%TYPE;
251: cconversion_date GL_JE_HEADERS.CURRENCY_CONVERSION_DATE%TYPE;
252: cconversion_type GL_JE_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE;
253: cconversion_rate GL_JE_HEADERS.CURRENCY_CONVERSION_RATE%TYPE;
254: crev_jeh_id GL_JE_HEADERS.REVERSED_JE_HEADER_ID%TYPE;
255: cledger_id NUMBER;

Line 252: cconversion_type GL_JE_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE;

248: ccurrency_code GL_JE_HEADERS.CURRENCY_CODE%TYPE;
249: cje_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
250: cje_actual_flag GL_JE_HEADERS.ACTUAL_FLAG%TYPE;
251: cconversion_date GL_JE_HEADERS.CURRENCY_CONVERSION_DATE%TYPE;
252: cconversion_type GL_JE_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE;
253: cconversion_rate GL_JE_HEADERS.CURRENCY_CONVERSION_RATE%TYPE;
254: crev_jeh_id GL_JE_HEADERS.REVERSED_JE_HEADER_ID%TYPE;
255: cledger_id NUMBER;
256: cfunct_curr VARCHAR2(15);

Line 253: cconversion_rate GL_JE_HEADERS.CURRENCY_CONVERSION_RATE%TYPE;

249: cje_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
250: cje_actual_flag GL_JE_HEADERS.ACTUAL_FLAG%TYPE;
251: cconversion_date GL_JE_HEADERS.CURRENCY_CONVERSION_DATE%TYPE;
252: cconversion_type GL_JE_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE;
253: cconversion_rate GL_JE_HEADERS.CURRENCY_CONVERSION_RATE%TYPE;
254: crev_jeh_id GL_JE_HEADERS.REVERSED_JE_HEADER_ID%TYPE;
255: cledger_id NUMBER;
256: cfunct_curr VARCHAR2(15);
257:

Line 254: crev_jeh_id GL_JE_HEADERS.REVERSED_JE_HEADER_ID%TYPE;

250: cje_actual_flag GL_JE_HEADERS.ACTUAL_FLAG%TYPE;
251: cconversion_date GL_JE_HEADERS.CURRENCY_CONVERSION_DATE%TYPE;
252: cconversion_type GL_JE_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE;
253: cconversion_rate GL_JE_HEADERS.CURRENCY_CONVERSION_RATE%TYPE;
254: crev_jeh_id GL_JE_HEADERS.REVERSED_JE_HEADER_ID%TYPE;
255: cledger_id NUMBER;
256: cfunct_curr VARCHAR2(15);
257:
258: -- Reversal information

Line 286: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');

282: -- Check the parameters
283: IF (header_id IS NOT NULL) THEN
284: IF (currency_code IS NULL) THEN
285: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');
286: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');
287: fnd_message.set_token('ARGUMENT', 'currency_code');
288: fnd_message.set_token('VALUE', currency_code);
289: ELSIF (conversion_date IS NULL) THEN
290: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');

Line 291: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');

287: fnd_message.set_token('ARGUMENT', 'currency_code');
288: fnd_message.set_token('VALUE', currency_code);
289: ELSIF (conversion_date IS NULL) THEN
290: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');
291: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');
292: fnd_message.set_token('ARGUMENT', 'conversion_date');
293: fnd_message.set_token('VALUE', conversion_date);
294: ELSIF (conversion_type IS NULL) THEN
295: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');

Line 296: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');

292: fnd_message.set_token('ARGUMENT', 'conversion_date');
293: fnd_message.set_token('VALUE', conversion_date);
294: ELSIF (conversion_type IS NULL) THEN
295: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');
296: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');
297: fnd_message.set_token('ARGUMENT', 'conversion_type');
298: fnd_message.set_token('VALUE', conversion_type);
299: ELSIF (conversion_rate IS NULL) THEN
300: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');

Line 301: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');

297: fnd_message.set_token('ARGUMENT', 'conversion_type');
298: fnd_message.set_token('VALUE', conversion_type);
299: ELSIF (conversion_rate IS NULL) THEN
300: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');
301: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');
302: fnd_message.set_token('ARGUMENT', 'conversion_rate');
303: fnd_message.set_token('VALUE', conversion_rate);
304: END IF;
305: END IF;

Line 311: FROM gl_je_headers

307: -- Delete all the corrupted ALC journal lines and headers in this batch.
308: DELETE FROM GL_JE_LINES
309: WHERE je_header_id in
310: (SELECT je_header_id
311: FROM gl_je_headers
312: WHERE je_batch_id = batch_id
313: AND display_alc_journal_flag = 'N');
314:
315: DELETE FROM GL_JE_HEADERS

Line 315: DELETE FROM GL_JE_HEADERS

311: FROM gl_je_headers
312: WHERE je_batch_id = batch_id
313: AND display_alc_journal_flag = 'N');
314:
315: DELETE FROM GL_JE_HEADERS
316: WHERE je_batch_id = batch_id
317: AND display_alc_journal_flag = 'N';
318:
319: -- If data for an erroneous header has been passed, then process

Line 333: FROM gl_je_headers jeh, gl_ledgers lgr

329: SELECT jeh.je_category, jeh.actual_flag, jeh.ledger_id,
330: lgr.currency_code, jeh.reversed_je_header_id
331: INTO cje_category, cje_actual_flag, cledger_id,
332: cfunct_curr, crev_jeh_id
333: FROM gl_je_headers jeh, gl_ledgers lgr
334: WHERE jeh.je_header_id = header_id
335: AND lgr.ledger_id = jeh.ledger_id;
336:
337: -- If the user has just changed the currency to stat, then

Line 450: UPDATE gl_je_headers jeh

446: login_id);
447:
448: -- Update the period, effective date, and conversion date for the
449: -- header.
450: UPDATE gl_je_headers jeh
451: SET period_name = change_period.period_name,
452: default_effective_date = effective_date,
453: currency_conversion_date = cconversion_date,
454: accrual_rev_period_name = decode(accrual_rev_status,

Line 575: UPDATE gl_je_headers jeh

571: END IF;
572:
573: -- Update the period, effective date, conversion date, and
574: -- accounted running totals for the header.
575: UPDATE gl_je_headers jeh
576: SET (running_total_dr, running_total_cr,
577: running_total_accounted_dr, running_total_accounted_cr,
578: period_name, default_effective_date,
579: currency_code, currency_conversion_date,

Line 628: FROM gl_je_headers jeh

624:
625: FUNCTION max_effective_date(batch_id NUMBER) RETURN DATE IS
626: CURSOR get_date IS
627: SELECT max(default_effective_date)
628: FROM gl_je_headers jeh
629: WHERE jeh.je_batch_id = batch_id
630: AND (jeh.display_alc_journal_flag is null or jeh.display_alc_journal_flag = 'Y')
631: AND jeh.accrual_rev_status IS NULL;
632: max_effective_date DATE;

Line 652: FROM gl_je_headers jeh

648:
649: FUNCTION needs_tax(batch_id NUMBER) RETURN BOOLEAN IS
650: CURSOR check_tax IS
651: SELECT max(decode(jeh.tax_status_code, 'R', 1, 0))
652: FROM gl_je_headers jeh
653: WHERE jeh.je_batch_id = batch_id;
654: dummy NUMBER;
655: BEGIN
656:

Line 679: FROM gl_je_headers jeh

675: SELECT 1
676: FROM dual
677: WHERE EXISTS (
678: SELECT 'has seqnum'
679: FROM gl_je_headers jeh
680: WHERE jeh.je_batch_id = batch_id
681: AND jeh.doc_sequence_value IS NOT NULL);
682: dummy NUMBER;
683: BEGIN

Line 986: CURSOR C IS SELECT rowid FROM GL_JE_HEADERS

982: X_Jgzz_Recon_Context VARCHAR2,
983: X_Jgzz_Recon_Ref VARCHAR2,
984: X_Reference_Date DATE
985: ) IS
986: CURSOR C IS SELECT rowid FROM GL_JE_HEADERS
987:
988: WHERE je_header_id = X_Je_Header_Id;
989: has_line VARCHAR2(1);
990: BEGIN

Line 1016: INSERT INTO GL_JE_HEADERS(

1012: IF (X_Je_Batch_Id IS NULL) THEN
1013: X_Je_Batch_Id := gl_je_batches_pkg.get_unique_id;
1014: END IF;
1015:
1016: INSERT INTO GL_JE_HEADERS(
1017: je_header_id,
1018: last_update_date,
1019: last_updated_by,
1020: ledger_id,

Line 1286: FROM GL_JE_HEADERS

1282: X_Doc_Sequence_Value NUMBER
1283: ) IS
1284: CURSOR C IS
1285: SELECT *
1286: FROM GL_JE_HEADERS
1287: WHERE rowid = X_Rowid
1288: FOR UPDATE of Je_Header_Id NOWAIT;
1289: Recinfo C%ROWTYPE;
1290: BEGIN

Line 1567: FROM GL_JE_HEADERS

1563: X_Reference_Date DATE
1564: ) IS
1565: CURSOR C IS
1566: SELECT *
1567: FROM GL_JE_HEADERS
1568: WHERE rowid = X_Rowid
1569: FOR UPDATE of Je_Header_Id NOWAIT;
1570: Recinfo C%ROWTYPE;
1571: BEGIN

Line 1918: UPDATE GL_JE_HEADERS

1914: fnd_message.set_name('SQLGL', 'GL_JE_JOURNAL_W_NO_LINES');
1915: app_exception.raise_exception;
1916: END IF;
1917:
1918: UPDATE GL_JE_HEADERS
1919: SET
1920:
1921: je_header_id = X_Je_Header_Id,
1922: last_update_date = X_Last_Update_Date,

Line 2123: UPDATE GL_JE_HEADERS

2119: X_Last_Updated_By,
2120: X_Last_Update_Login);
2121: END IF;
2122:
2123: UPDATE GL_JE_HEADERS
2124: SET
2125:
2126: je_header_id = X_Je_Header_Id,
2127: last_update_date = X_Last_Update_Date,

Line 2276: FROM gl_je_headers

2272: X_Last_Update_Login NUMBER
2273: ) IS
2274: CURSOR count_headers IS
2275: SELECT count(*)
2276: FROM gl_je_headers
2277: WHERE je_batch_id = X_Je_Batch_Id;
2278:
2279: CURSOR get_child IS
2280: SELECT gh.je_header_id,gh.je_batch_id,gl.ledger_category_code,gh.rowid,gl.ledger_id

Line 2281: FROM gl_je_headers gh,gl_ledgers gl

2277: WHERE je_batch_id = X_Je_Batch_Id;
2278:
2279: CURSOR get_child IS
2280: SELECT gh.je_header_id,gh.je_batch_id,gl.ledger_category_code,gh.rowid,gl.ledger_id
2281: FROM gl_je_headers gh,gl_ledgers gl
2282: WHERE gh.parent_je_header_id = X_Je_Header_Id
2283: AND gh.ledger_id = gl.ledger_id
2284: AND gl.ledger_category_code in ('ALC','SECONDARY')
2285: AND gh.status = decode(gl.ledger_category_code, 'SECONDARY','U','ALC',gh.status);

Line 2395: gl_je_headers_pkg.Delete_Row(l_rowid,

2391: N_Last_Update_Login
2392: FROM gl_je_batches
2393: WHERE je_batch_id = l_je_batch_id;
2394:
2395: gl_je_headers_pkg.Delete_Row(l_rowid,
2396: l_je_header_id,
2397: X_Header_Mode,
2398: N_Rowid,
2399: l_je_batch_id,

Line 2433: UPDATE gl_je_headers

2429:
2430: -- Mark the reversals as no longer reversals, since the
2431: -- original journal has been deleted. This is necessary to fix
2432: -- bug #1001521
2433: UPDATE gl_je_headers
2434: SET reversed_je_header_id = null,
2435: accrual_rev_je_header_id = decode(accrual_rev_status,
2436: 'R', accrual_rev_je_header_id,
2437: null)

Line 2440: FROM gl_je_headers

2436: 'R', accrual_rev_je_header_id,
2437: null)
2438: WHERE je_header_id =
2439: (SELECT accrual_rev_je_header_id
2440: FROM gl_je_headers
2441: WHERE rowid = X_Rowid
2442: AND accrual_rev_status = 'R');
2443:
2444: -- Bug fix 2749073 Mark the original journal as reversible

Line 2446: UPDATE gl_je_headers

2442: AND accrual_rev_status = 'R');
2443:
2444: -- Bug fix 2749073 Mark the original journal as reversible
2445: -- incase if the reversed journal associated is deleted.
2446: UPDATE gl_je_headers
2447: SET accrual_rev_status = null,
2448: accrual_rev_je_header_id =null,
2449: accrual_rev_flag = 'Y'
2450: WHERE je_header_id =

Line 2452: FROM gl_je_headers

2448: accrual_rev_je_header_id =null,
2449: accrual_rev_flag = 'Y'
2450: WHERE je_header_id =
2451: ( SELECT reversed_je_header_id
2452: FROM gl_je_headers
2453: WHERE je_header_id = X_Je_Header_Id
2454: AND reversed_je_header_id IS NOT NULL);
2455:
2456: -- Mark the ALC reversals as no longer reversals, since the

Line 2458: UPDATE gl_je_headers

2454: AND reversed_je_header_id IS NOT NULL);
2455:
2456: -- Mark the ALC reversals as no longer reversals, since the
2457: -- original journal has been deleted.
2458: UPDATE gl_je_headers
2459: SET reversed_je_header_id = null,
2460: accrual_rev_je_header_id = decode(accrual_rev_status,
2461: 'R', accrual_rev_je_header_id,
2462: null)

Line 2465: FROM gl_je_headers gh,gl_ledgers gl

2461: 'R', accrual_rev_je_header_id,
2462: null)
2463: WHERE je_header_id =
2464: (SELECT gh.accrual_rev_je_header_id
2465: FROM gl_je_headers gh,gl_ledgers gl
2466: WHERE gh.parent_je_header_id = X_Je_Header_Id
2467: AND gh.accrual_rev_status = 'R'
2468: AND gh.ledger_id = gl.ledger_id
2469: AND gl.ledger_category_code = 'ALC');

Line 2473: UPDATE gl_je_headers

2469: AND gl.ledger_category_code = 'ALC');
2470:
2471: --Mark the original journal as reversible
2472: -- incase if the reversed journal associated is deleted.
2473: UPDATE gl_je_headers
2474: SET accrual_rev_status = null,
2475: accrual_rev_je_header_id =null,
2476: accrual_rev_flag = 'Y'
2477: WHERE je_header_id =

Line 2479: FROM gl_je_headers gh,gl_ledgers gl

2475: accrual_rev_je_header_id =null,
2476: accrual_rev_flag = 'Y'
2477: WHERE je_header_id =
2478: ( SELECT gh.reversed_je_header_id
2479: FROM gl_je_headers gh,gl_ledgers gl
2480: WHERE gh.parent_je_header_id = X_Je_Header_Id
2481: AND gh.reversed_je_header_id IS NOT NULL
2482: AND gh.ledger_id = gl.ledger_id
2483: AND gl.ledger_category_code = 'ALC');

Line 2486: --DELETE FROM gl_je_headers

2482: AND gh.ledger_id = gl.ledger_id
2483: AND gl.ledger_category_code = 'ALC');
2484:
2485: --Delete the the corresponding ALCs when a primary journals is deleted.
2486: --DELETE FROM gl_je_headers
2487: --WHERE parent_je_header_id = X_Je_Header_Id;
2488: Delete from gl_je_headers glh
2489: where parent_je_header_id =X_Je_Header_Id
2490: and ledger_id in (SELECT ledger_id

Line 2488: Delete from gl_je_headers glh

2484:
2485: --Delete the the corresponding ALCs when a primary journals is deleted.
2486: --DELETE FROM gl_je_headers
2487: --WHERE parent_je_header_id = X_Je_Header_Id;
2488: Delete from gl_je_headers glh
2489: where parent_je_header_id =X_Je_Header_Id
2490: and ledger_id in (SELECT ledger_id
2491: FROM gl_ledgers
2492: WHERE ledger_id = glh.ledger_id

Line 2497: DELETE FROM GL_JE_HEADERS

2493: AND ledger_category_code = 'ALC');
2494:
2495:
2496: -- Delete the journal
2497: DELETE FROM GL_JE_HEADERS
2498: WHERE rowid = X_Rowid;
2499:
2500: -- If we are deleting in the journal zone and we are in journal
2501: -- mode or if we are deleting from the folder zone, we need

Line 2555: END GL_JE_HEADERS_PKG;

2551: WHEN NO_DATA_FOUND THEN
2552: null;
2553: END Delete_Row;
2554:
2555: END GL_JE_HEADERS_PKG;