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.22 2005/05/05 01:10:40 kvora 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 123: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.delete_headers');

119: WHEN app_exceptions.application_exception THEN
120: RAISE;
121: WHEN OTHERS THEN
122: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
123: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.delete_headers');
124: RAISE;
125: END delete_headers;
126:
127: PROCEDURE change_effective_date(batch_id NUMBER,

Line 134: FROM gl_je_headers

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

Line 138: UPDATE gl_je_headers jeh

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

Line 163: 'gl_je_headers_pkg.change_effective_date');

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

Line 178: FROM GL_JE_HEADERS jeh

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

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

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

Line 217: FROM gl_je_headers jeh, gl_ledgers lgr

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

Line 231: FROM gl_je_headers jeh, gl_ledgers lgr

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

Line 235: FROM gl_je_headers

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

Line 245: cheader_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;

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

Line 246: ccurrency_code GL_JE_HEADERS.CURRENCY_CODE%TYPE;

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

Line 247: cje_category GL_JE_HEADERS.JE_CATEGORY%TYPE;

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

Line 248: cje_actual_flag GL_JE_HEADERS.ACTUAL_FLAG%TYPE;

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

Line 249: cconversion_date GL_JE_HEADERS.CURRENCY_CONVERSION_DATE%TYPE;

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

Line 250: cconversion_type GL_JE_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE;

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

Line 251: cconversion_rate GL_JE_HEADERS.CURRENCY_CONVERSION_RATE%TYPE;

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

Line 252: crev_jeh_id GL_JE_HEADERS.REVERSED_JE_HEADER_ID%TYPE;

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

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

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

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

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

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

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

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

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

Line 309: FROM gl_je_headers

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

Line 313: DELETE FROM GL_JE_HEADERS

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

Line 331: FROM gl_je_headers jeh, gl_ledgers lgr

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

Line 448: UPDATE gl_je_headers jeh

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

Line 573: UPDATE gl_je_headers jeh

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

Line 626: FROM gl_je_headers jeh

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

Line 650: FROM gl_je_headers jeh

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

Line 677: FROM gl_je_headers jeh

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

Line 973: CURSOR C IS SELECT rowid FROM GL_JE_HEADERS

969: X_Jgzz_Recon_Context VARCHAR2,
970: X_Jgzz_Recon_Ref VARCHAR2,
971: X_Reference_Date DATE
972: ) IS
973: CURSOR C IS SELECT rowid FROM GL_JE_HEADERS
974:
975: WHERE je_header_id = X_Je_Header_Id;
976: has_line VARCHAR2(1);
977: BEGIN

Line 1003: INSERT INTO GL_JE_HEADERS(

999: IF (X_Je_Batch_Id IS NULL) THEN
1000: X_Je_Batch_Id := gl_je_batches_pkg.get_unique_id;
1001: END IF;
1002:
1003: INSERT INTO GL_JE_HEADERS(
1004: je_header_id,
1005: last_update_date,
1006: last_updated_by,
1007: ledger_id,

Line 1251: FROM GL_JE_HEADERS

1247: X_Doc_Sequence_Value NUMBER
1248: ) IS
1249: CURSOR C IS
1250: SELECT *
1251: FROM GL_JE_HEADERS
1252: WHERE rowid = X_Rowid
1253: FOR UPDATE of Je_Header_Id NOWAIT;
1254: Recinfo C%ROWTYPE;
1255: BEGIN

Line 1521: FROM GL_JE_HEADERS

1517: X_Reference_Date DATE
1518: ) IS
1519: CURSOR C IS
1520: SELECT *
1521: FROM GL_JE_HEADERS
1522: WHERE rowid = X_Rowid
1523: FOR UPDATE of Je_Header_Id NOWAIT;
1524: Recinfo C%ROWTYPE;
1525: BEGIN

Line 1839: UPDATE GL_JE_HEADERS

1835: fnd_message.set_name('SQLGL', 'GL_JE_JOURNAL_W_NO_LINES');
1836: app_exception.raise_exception;
1837: END IF;
1838:
1839: UPDATE GL_JE_HEADERS
1840: SET
1841:
1842: je_header_id = X_Je_Header_Id,
1843: last_update_date = X_Last_Update_Date,

Line 2033: UPDATE GL_JE_HEADERS

2029: X_Last_Updated_By,
2030: X_Last_Update_Login);
2031: END IF;
2032:
2033: UPDATE GL_JE_HEADERS
2034: SET
2035:
2036: je_header_id = X_Je_Header_Id,
2037: last_update_date = X_Last_Update_Date,

Line 2175: FROM gl_je_headers

2171: X_Last_Update_Login NUMBER
2172: ) IS
2173: CURSOR count_headers IS
2174: SELECT count(*)
2175: FROM gl_je_headers
2176: WHERE je_batch_id = X_Je_Batch_Id;
2177:
2178: CURSOR get_child IS
2179: SELECT je_header_id

Line 2180: FROM gl_je_headers

2176: WHERE je_batch_id = X_Je_Batch_Id;
2177:
2178: CURSOR get_child IS
2179: SELECT je_header_id
2180: FROM gl_je_headers
2181: WHERE parent_je_header_id = X_Je_Header_Id;
2182:
2183: header_count NUMBER := 0;
2184: l_je_header_id NUMBER;

Line 2215: UPDATE gl_je_headers

2211:
2212: -- Mark the reversals as no longer reversals, since the
2213: -- original journal has been deleted. This is necessary to fix
2214: -- bug #1001521
2215: UPDATE gl_je_headers
2216: SET reversed_je_header_id = null,
2217: accrual_rev_je_header_id = decode(accrual_rev_status,
2218: 'R', accrual_rev_je_header_id,
2219: null)

Line 2222: FROM gl_je_headers

2218: 'R', accrual_rev_je_header_id,
2219: null)
2220: WHERE je_header_id =
2221: (SELECT accrual_rev_je_header_id
2222: FROM gl_je_headers
2223: WHERE rowid = X_Rowid
2224: AND accrual_rev_status = 'R');
2225:
2226: -- Bug fix 2749073 Mark the original journal as reversible

Line 2228: UPDATE gl_je_headers

2224: AND accrual_rev_status = 'R');
2225:
2226: -- Bug fix 2749073 Mark the original journal as reversible
2227: -- incase if the reversed journal associated is deleted.
2228: UPDATE gl_je_headers
2229: SET accrual_rev_status = null,
2230: accrual_rev_je_header_id =null,
2231: accrual_rev_flag = 'Y'
2232: WHERE je_header_id =

Line 2234: FROM gl_je_headers

2230: accrual_rev_je_header_id =null,
2231: accrual_rev_flag = 'Y'
2232: WHERE je_header_id =
2233: ( SELECT reversed_je_header_id
2234: FROM gl_je_headers
2235: WHERE je_header_id = X_Je_Header_Id
2236: AND reversed_je_header_id IS NOT NULL);
2237:
2238: -- Mark the ALC reversals as no longer reversals, since the

Line 2240: UPDATE gl_je_headers

2236: AND reversed_je_header_id IS NOT NULL);
2237:
2238: -- Mark the ALC reversals as no longer reversals, since the
2239: -- original journal has been deleted.
2240: UPDATE gl_je_headers
2241: SET reversed_je_header_id = null,
2242: accrual_rev_je_header_id = decode(accrual_rev_status,
2243: 'R', accrual_rev_je_header_id,
2244: null)

Line 2247: FROM gl_je_headers

2243: 'R', accrual_rev_je_header_id,
2244: null)
2245: WHERE je_header_id =
2246: (SELECT accrual_rev_je_header_id
2247: FROM gl_je_headers
2248: WHERE parent_je_header_id = X_Je_Header_Id
2249: AND accrual_rev_status = 'R');
2250:
2251: --Mark the original journal as reversible

Line 2253: UPDATE gl_je_headers

2249: AND accrual_rev_status = 'R');
2250:
2251: --Mark the original journal as reversible
2252: -- incase if the reversed journal associated is deleted.
2253: UPDATE gl_je_headers
2254: SET accrual_rev_status = null,
2255: accrual_rev_je_header_id =null,
2256: accrual_rev_flag = 'Y'
2257: WHERE je_header_id =

Line 2259: FROM gl_je_headers

2255: accrual_rev_je_header_id =null,
2256: accrual_rev_flag = 'Y'
2257: WHERE je_header_id =
2258: ( SELECT reversed_je_header_id
2259: FROM gl_je_headers
2260: WHERE parent_je_header_id = X_Je_Header_Id
2261: AND reversed_je_header_id IS NOT NULL);
2262:
2263: --Delete the the corresponding ALCs when a primary journals is deleted.

Line 2264: DELETE FROM gl_je_headers

2260: WHERE parent_je_header_id = X_Je_Header_Id
2261: AND reversed_je_header_id IS NOT NULL);
2262:
2263: --Delete the the corresponding ALCs when a primary journals is deleted.
2264: DELETE FROM gl_je_headers
2265: WHERE parent_je_header_id = X_Je_Header_Id;
2266:
2267: -- Delete the journal
2268: DELETE FROM GL_JE_HEADERS

Line 2268: DELETE FROM GL_JE_HEADERS

2264: DELETE FROM gl_je_headers
2265: WHERE parent_je_header_id = X_Je_Header_Id;
2266:
2267: -- Delete the journal
2268: DELETE FROM GL_JE_HEADERS
2269: WHERE rowid = X_Rowid;
2270:
2271: -- If we are deleting in the journal zone and we are in journal
2272: -- mode or if we are deleting from the folder zone, we need

Line 2326: END GL_JE_HEADERS_PKG;

2322: WHEN NO_DATA_FOUND THEN
2323: null;
2324: END Delete_Row;
2325:
2326: END GL_JE_HEADERS_PKG;