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_BATCHES_PKG dependencies on GL_JE_HEADERS

Line 80: FROM gl_je_headers jeh, gl_je_lines jel

76: CURSOR chk_batch IS
77: SELECT 'Has Lines'
78: FROM dual
79: WHERE EXISTS (SELECT 'Found Line'
80: FROM gl_je_headers jeh, gl_je_lines jel
81: WHERE jeh.je_batch_id = batch_id
82: AND jel.je_header_id = jeh.je_header_id);
83: dummy VARCHAR2(100);
84: BEGIN

Line 111: FROM gl_je_headers jeh, gl_ledgers lgr,

107: CURSOR needs_apprvl IS
108: SELECT 'Needs Approval'
109: FROM dual
110: WHERE EXISTS (SELECT 'Needs Approval'
111: FROM gl_je_headers jeh, gl_ledgers lgr,
112: gl_je_sources src
113: WHERE jeh.je_batch_id = batch_id
114: AND lgr.ledger_id = jeh.ledger_id
115: AND lgr.enable_je_approval_flag = 'Y'

Line 145: FROM gl_je_headers jeh, gl_ledgers lgr

141: CURSOR needstx IS
142: SELECT 'Needs Tax'
143: FROM dual
144: WHERE EXISTS (SELECT 'Needs Tax'
145: FROM gl_je_headers jeh, gl_ledgers lgr
146: WHERE jeh.je_batch_id = batch_id
147: AND jeh.tax_status_code = 'R'
148: AND lgr.ledger_id = jeh.ledger_id
149: AND lgr.enable_automatic_tax_flag = 'Y');

Line 180: GL_JE_HEADERS JH

176: decode(count(*),
177: sum(decode(JH.currency_code, 'STAT', 1, 0)), 'All STAT',
178: 'Not all STAT')
179: FROM
180: GL_JE_HEADERS JH
181: WHERE
182: JH.je_batch_id = X_je_batch_id
183: AND (JH.display_alc_journal_flag is null or JH.display_alc_journal_flag = 'Y');
184: dummy VARCHAR2(100);

Line 203: GL_JE_HEADERS JH, GL_LEDGERS LGR

199: CURSOR get_ledger_id IS
200: SELECT
201: DISTINCT JH.ledger_id
202: FROM
203: GL_JE_HEADERS JH, GL_LEDGERS LGR
204: WHERE
205: JH.je_batch_id = X_je_batch_id
206: AND (JH.display_alc_journal_flag is null
207: or JH.display_alc_journal_flag = 'Y')

Line 247: FROM gl_je_headers

243: BEGIN
244: SELECT max(ledger_id), nvl(max(je_source), 'Manual'),
245: nvl(max(decode(reversed_je_header_id, NULL, NULL, 'Y')),'N')
246: INTO one_of_ledgers_in_batch, x_je_source_name, reversal_flag
247: FROM gl_je_headers
248: WHERE je_batch_id = x_je_batch_id
249: AND rownum = 1;
250:
251: SELECT override_edits_flag

Line 303: FROM gl_je_headers

299: IF (X_Je_Batch_Id IS NOT NULL) THEN
300: BEGIN
301: SELECT 'Y'
302: INTO has_je
303: FROM gl_je_headers
304: WHERE je_batch_id = X_Je_Batch_Id
305: AND rownum = 1;
306:
307: EXCEPTION

Line 573: FROM gl_je_headers

569: IF (X_Je_Batch_Id IS NOT NULL) THEN
570: BEGIN
571: SELECT 'Y'
572: INTO has_je
573: FROM gl_je_headers
574: WHERE je_batch_id = X_Je_Batch_Id
575: AND rownum = 1;
576: EXCEPTION
577: WHEN NO_DATA_FOUND THEN

Line 590: GL_JE_HEADERS_PKG.change_effective_date(X_Je_Batch_Id,

586:
587: -- If the user changes the average journal flag to 'Y', then
588: -- we need to reinitialize all of the journals effective dates.
589: IF (Update_Effective_Date_Flag = 'Y') THEN
590: GL_JE_HEADERS_PKG.change_effective_date(X_Je_Batch_Id,
591: X_Default_Effective_Date);
592: END IF;
593:
594: -- If the user starts the approval process, then we need to

Line 621: gl_je_headers_pkg.calculate_totals(

617: END IF;
618: END IF;
619:
620: -- Recalculate the running totals
621: gl_je_headers_pkg.calculate_totals(
622: X_Je_Batch_Id,
623: X_Running_Total_Dr,
624: X_Running_Total_Cr,
625: X_Running_Total_Accounted_Dr,

Line 753: FROM gl_je_headers

749: BEGIN
750:
751: SELECT 'Y'
752: INTO has_je
753: FROM gl_je_headers
754: WHERE je_batch_id = X_Je_Batch_Id
755: AND rownum = 1;
756: EXCEPTION
757: WHEN NO_DATA_FOUND THEN

Line 1301: FROM gl_je_headers

1297: BEGIN
1298:
1299: SELECT 'Y'
1300: INTO has_je
1301: FROM gl_je_headers
1302: WHERE je_batch_id = X_Je_Batch_Id
1303: AND rownum = 1;
1304: EXCEPTION
1305: WHEN NO_DATA_FOUND THEN

Line 1318: GL_JE_HEADERS_PKG.change_effective_date(X_Je_Batch_Id,

1314:
1315: -- If the user changes the average journal flag to 'Y', then
1316: -- we need to reinitialize all of the journals effective dates.
1317: IF (Update_Effective_Date_Flag = 'Y') THEN
1318: GL_JE_HEADERS_PKG.change_effective_date(X_Je_Batch_Id,
1319: X_Default_Effective_Date);
1320: END IF;
1321:
1322: -- If the user starts the approval process, then we need to

Line 1432: FROM gl_je_headers gh, gl_je_batches gb

1428: dev_request_phase VARCHAR2(30);
1429:
1430: CURSOR get_child IS
1431: SELECT gb.rowid,gb.je_batch_id
1432: FROM gl_je_headers gh, gl_je_batches gb
1433: WHERE gb.je_batch_id = gh.je_batch_id
1434: AND gh.parent_je_header_id IN
1435: (select je_header_id
1436: from gl_je_headers

Line 1436: from gl_je_headers

1432: FROM gl_je_headers gh, gl_je_batches gb
1433: WHERE gb.je_batch_id = gh.je_batch_id
1434: AND gh.parent_je_header_id IN
1435: (select je_header_id
1436: from gl_je_headers
1437: where je_batch_id = X_Je_Batch_Id)
1438: AND gh.reversed_je_header_id IS NOT NULL
1439: AND gb.status <> 'P'
1440: AND gb.je_batch_id <> X_Je_Batch_Id;

Line 1522: gl_je_headers_pkg.delete_headers(X_Je_Batch_Id);

1518: END LOOP;
1519: CLOSE get_child;
1520:
1521: -- Delete the journals
1522: gl_je_headers_pkg.delete_headers(X_Je_Batch_Id);
1523:
1524: -- Delete the batches
1525: DELETE FROM GL_JE_BATCHES
1526: WHERE rowid = X_Rowid;