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 445: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_ledgers lgr,

441: jel.no1,--Added this as part of bug6521457
442: jel.ussgl_transaction_code,
443: jel.co_third_party,
444: sysdate, usr_id, sysdate, usr_id, log_id
445: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_ledgers lgr,
446: fnd_currencies curr, gl_je_lines jel
447: WHERE jeh1.je_batch_id = jeb_id
448: AND jeh2.je_batch_id = new_jeb_id
449: AND jeh2.name IN (jeh1.name,

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

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

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

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

Line 532: UPDATE gl_je_headers jeh

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

Line 549: FROM gl_je_headers jeh

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

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

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

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

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

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

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

Line 569: FROM gl_je_headers

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

Line 646: UPDATE gl_je_headers

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