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

Line 144: FROM gl_je_headers jeh, gl_ledgers lgr

140: -- Determine the appropriate approval and budgetary control settings
141: SELECT nvl(max(decode(enable_budgetary_control_flag, 'Y', 'Y', null)),'N'),
142: nvl(max(decode(enable_je_approval_flag, 'Y', 'Y', null)), 'N')
143: INTO bc_flag, approval_flag
144: FROM gl_je_headers jeh, gl_ledgers lgr
145: WHERE jeh.je_batch_id = jeb_id
146: AND lgr.ledger_id = jeh.ledger_id;
147:
148: IF (SQL%ROWCOUNT <> 1) THEN

Line 226: FROM gl_je_headers jeh, gl_ledgers lgr

222: SELECT jeh.je_header_id, jeh.ledger_id, jeh.je_category,
223: jeh.currency_code, jeh.currency_conversion_type,
224: jeh.currency_conversion_date, jeh.currency_conversion_rate,
225: lgr.currency_code
226: FROM gl_je_headers jeh, gl_ledgers lgr
227: WHERE jeh.je_batch_id = jeb_id
228: AND lgr.ledger_id = jeh.ledger_id
229: --Commented this as part of bug 7581299.
230: --AND jeh.parent_je_header_id IS NULL; /* See comments above */--Uncommented this as part of bug 7373688.

Line 346: INSERT INTO gl_je_headers

342: v3 => to_char(conversion_date,
343: 'DD-MON-RR'));
344: END IF;
345:
346: INSERT INTO gl_je_headers
347: (je_batch_id, je_header_id, ledger_id,
348: je_category, je_source, default_effective_date, period_name,
349: name, currency_code, status, date_created,
350: multi_bal_seg_flag, actual_flag,

Line 364: new_jeb_id, gl_je_headers_s.nextval, ledger_id,

360: tax_status_code, reference_date, originating_bal_seg_value,
361: creation_date, created_by,
362: last_update_date, last_updated_by, last_update_login)
363: SELECT
364: new_jeb_id, gl_je_headers_s.nextval, ledger_id,
365: je_category, 'AutoCopy', New_eff_date, New_period_name,---Modified the source from Manual to Autocopy as part of bug7373688
366: decode(parent_je_header_id, NULL, name,
367: substrb(name, 1, (100 - (lengthb(to_char(je_header_id))+1)))
368: || ' ' || to_char(je_header_id)),

Line 382: FROM gl_je_headers

378: attribute6, attribute7, attribute8, attribute9, attribute10,context,
379: ussgl_transaction_code, jgzz_recon_context, jgzz_recon_ref,
380: 'N', reference_date, originating_bal_seg_value,
381: sysdate, usr_id, sysdate, usr_id, log_id
382: FROM gl_je_headers
383: WHERE je_header_id = jeh_id;
384:
385: IF (SQL%ROWCOUNT <> 1) THEN
386: Raise GLUJECPB_FATAL_ERR;

Line 399: v2 =>'GL_JE_HEADERS');

395: token_num => 2 ,
396: t1 =>'NUM',
397: v1 =>to_char(temp),
398: t2 =>'TABLE',
399: v2 =>'GL_JE_HEADERS');
400:
401: -- Insert the new journal lines
402: INSERT INTO gl_je_lines
403: (je_header_id, je_line_num, ledger_id,

Line 443: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_ledgers lgr,

439: jel.attribute19, jel.attribute20, jel.context2,
440: jel.ussgl_transaction_code,
441: jel.co_third_party,
442: sysdate, usr_id, sysdate, usr_id, log_id
443: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_ledgers lgr,
444: fnd_currencies curr, gl_je_lines jel
445: WHERE jeh1.je_batch_id = jeb_id
446: AND jeh2.je_batch_id = new_jeb_id
447: AND jeh2.name IN (jeh1.name,

Line 472: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_je_segment_values sv

468: last_update_date, last_updated_by, last_update_login)
469: SELECT
470: jeh2.je_header_id, sv.segment_type_code, sv.segment_value,
471: sysdate, usr_id, sysdate, usr_id, log_id
472: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_je_segment_values sv
473: WHERE jeh1.je_batch_id = jeb_id
474: AND jeh2.je_batch_id = new_jeb_id
475: AND jeh2.name IN (jeh1.name,
476: substrb(jeh1.name,

Line 499: FROM gl_je_batches jeb, gl_je_headers jeh1, gl_je_headers jeh2,

495: SELECT jeh2.je_header_id, jel.je_line_num, jel.ledger_id,
496: rec.jgzz_recon_ref,
497: sysdate, usr_id, sysdate,
498: usr_id, log_id
499: FROM gl_je_batches jeb, gl_je_headers jeh1, gl_je_headers jeh2,
500: gl_ledgers lgr, gl_je_lines jel,
501: gl_code_combinations cc, gl_je_lines_recon rec
502: WHERE jeb.je_batch_id = jeb_id
503: AND jeb.average_journal_flag = 'N'

Line 530: UPDATE gl_je_headers jeh

526: t2 =>'TABLE',
527: v2 =>'GL_JE_LINES_RECON');
528:
529: -- Fix the running totals for the journals
530: UPDATE gl_je_headers jeh
531: SET (running_total_dr, running_total_cr,
532: running_total_accounted_dr, running_total_accounted_cr)
533: = (SELECT sum(nvl(entered_dr,0)), sum(nvl(entered_cr,0)),
534: sum(nvl(accounted_dr,0)), sum(nvl(accounted_cr,0))

Line 547: FROM gl_je_headers jeh

543: = (SELECT sum(running_total_dr),
544: sum(running_total_cr),
545: sum(running_total_accounted_dr),
546: sum(running_total_accounted_cr)
547: FROM gl_je_headers jeh
548: WHERE jeh.je_batch_id = jeb.je_batch_id)
549: WHERE jeb.je_batch_id = new_jeb_id;
550:
551: -- If sequential numbering is on and this is an

Line 556: je_category gl_je_headers.je_category%TYPE; /Bug 6665535/

552: -- actual batch, than try to get sequential numbering
553: -- information
554: IF ( (seq_num <> 'N') AND (act_flag = 'A')) THEN
555: DECLARE
556: je_category gl_je_headers.je_category%TYPE; /*Bug 6665535*/
557: lgr_id gl_je_headers.ledger_id%TYPE; /*Bug 6665535*/
558: effdate DATE;
559: seq_id NUMBER;
560: seq_val NUMBER;

Line 557: lgr_id gl_je_headers.ledger_id%TYPE; /Bug 6665535/

553: -- information
554: IF ( (seq_num <> 'N') AND (act_flag = 'A')) THEN
555: DECLARE
556: je_category gl_je_headers.je_category%TYPE; /*Bug 6665535*/
557: lgr_id gl_je_headers.ledger_id%TYPE; /*Bug 6665535*/
558: effdate DATE;
559: seq_id NUMBER;
560: seq_val NUMBER;
561: row_id ROWID;

Line 563: je_name gl_je_headers.name%TYPE; /Bug 6665535/

559: seq_id NUMBER;
560: seq_val NUMBER;
561: row_id ROWID;
562: seq_result NUMBER;
563: je_name gl_je_headers.name%TYPE; /*Bug 6665535*/
564: CURSOR new_journals IS
565: SELECT rowid, ledger_id, je_category,
566: substrb(name, 25)
567: FROM gl_je_headers

Line 567: FROM gl_je_headers

563: je_name gl_je_headers.name%TYPE; /*Bug 6665535*/
564: CURSOR new_journals IS
565: SELECT rowid, ledger_id, je_category,
566: substrb(name, 25)
567: FROM gl_je_headers
568: WHERE je_batch_id = new_jeb_id;
569: BEGIN
570:
571: OPEN new_journals;

Line 644: UPDATE gl_je_headers

640: v3 => to_char(seq_id));
641: END IF;
642:
643: IF ((seq_result = 0) AND (seq_val IS NOT NULL)) THEN
644: UPDATE gl_je_headers
645: SET doc_sequence_id = seq_id,
646: doc_sequence_value = seq_val
647: WHERE rowid = row_id;
648: ELSIF (seq_num = 'A') THEN