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_LINES

Line 67: DELETE gl_je_lines

63: PROCEDURE delete_headers(batch_id NUMBER) IS
64: dummy NUMBER;
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:

Line 77: DELETE gl_je_lines_recon

73: -- batch
74: dummy := gl_je_segment_values_pkg.delete_batch_segment_values(batch_id);
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:

Line 131: UPDATE gl_je_lines

127: PROCEDURE change_effective_date(batch_id NUMBER,
128: new_effective_date DATE) IS
129: BEGIN
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);

Line 306: DELETE FROM GL_JE_LINES

302: END IF;
303: END IF;
304:
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

Line 433: gl_je_lines_pkg.update_lines(

429: IF ( (cconversion_type = 'User')
430: AND (NOT bad_journal)) THEN
431:
432: -- Update the period and effective date for the lines
433: gl_je_lines_pkg.update_lines(
434: cheader_id,
435: period_name,
436: effective_date,
437: -1,

Line 501: gl_je_lines_pkg.update_lines(

497: -- Update the period, effective date, and conversion rate for the lines
498: IF (ccurrency_code = 'STAT') THEN
499: -- For functional or STAT currency, ignore and clear the
500: -- ignore rate flag
501: gl_je_lines_pkg.update_lines(
502: cheader_id,
503: period_name,
504: effective_date,
505: 1,

Line 517: gl_je_lines_pkg.update_lines(

513: -- Update the period, effective date, and conversion rate for the lines
514: ELSIF (ccurrency_code = cfunct_curr) THEN
515: -- For functional or STAT currency, ignore and clear the
516: -- ignore rate flag
517: gl_je_lines_pkg.update_lines(
518: cheader_id,
519: period_name,
520: effective_date,
521: 1,

Line 542: gl_je_lines_pkg.update_lines(

538: x_denominator => denom_rate,
539: x_numerator => numer_rate,
540: x_rate => tmp_rate);
541:
542: gl_je_lines_pkg.update_lines(
543: cheader_id,
544: period_name,
545: effective_date,
546: denom_rate,

Line 557: gl_je_lines_pkg.update_lines(

553: login_id);
554: ELSE
555: -- For other currencies, do not update the amounts of lines
556: -- with the conversion rate flag set.
557: gl_je_lines_pkg.update_lines(
558: cheader_id,
559: period_name,
560: effective_date,
561: 1,

Line 588: FROM gl_je_lines jel

584: change_period.period_name, change_period.effective_date,
585: ccurrency_code, cconversion_date,
586: cconversion_type, cconversion_rate,
587: sysdate, user_id, login_id
588: FROM gl_je_lines jel
589: WHERE jel.je_header_id = jeh.je_header_id),
590: accrual_rev_period_name = decode(accrual_rev_status,
591: NULL, reversal_period,
592: accrual_rev_period_name),

Line 985: FROM gl_je_lines

981: IF (X_Je_Header_Id IS NOT NULL) THEN
982: BEGIN
983: SELECT 'Y'
984: INTO has_line
985: FROM gl_je_lines
986: WHERE je_header_id = X_Je_Header_Id
987: AND rownum = 1;
988: EXCEPTION
989: WHEN NO_DATA_FOUND THEN

Line 1825: FROM gl_je_lines

1821: IF (X_Je_Header_Id IS NOT NULL) THEN
1822: BEGIN
1823: SELECT 'Y'
1824: INTO has_line
1825: FROM gl_je_lines
1826: WHERE je_header_id = X_Je_Header_Id
1827: AND rownum = 1;
1828: EXCEPTION
1829: WHEN NO_DATA_FOUND THEN

Line 2003: FROM gl_je_lines

1999: IF (X_Je_Header_Id IS NOT NULL) THEN
2000: BEGIN
2001: SELECT 'Y'
2002: INTO has_line
2003: FROM gl_je_lines
2004: WHERE je_header_id = X_Je_Header_Id
2005: AND rownum = 1;
2006: EXCEPTION
2007: WHEN NO_DATA_FOUND THEN

Line 2019: gl_je_lines_pkg.update_lines(

2015: END IF;
2016:
2017: -- Update the lines effective date, if necessary
2018: IF (X_Effective_Date_Changed = 'Y') THEN
2019: gl_je_lines_pkg.update_lines(
2020: X_Je_Header_Id,
2021: X_Period_Name,
2022: X_Default_Effective_Date,
2023: -1,

Line 2188: gl_je_lines_pkg.delete_lines(X_Je_Header_Id);

2184: l_je_header_id NUMBER;
2185: dummy NUMBER;
2186: BEGIN
2187: -- Delete any lines
2188: gl_je_lines_pkg.delete_lines(X_Je_Header_Id);
2189:
2190: -- Delete the associated segment values
2191: dummy := gl_je_segment_values_pkg.delete_segment_values(X_Je_Header_Id);
2192:

Line 2194: DELETE gl_je_lines_recon

2190: -- Delete the associated segment values
2191: dummy := gl_je_segment_values_pkg.delete_segment_values(X_Je_Header_Id);
2192:
2193: -- Delete all of the reconciliation lines
2194: DELETE gl_je_lines_recon
2195: WHERE je_header_id = X_Je_Header_Id;
2196:
2197: OPEN get_child;
2198: LOOP

Line 2202: gl_je_lines_pkg.delete_lines(l_je_header_id);

2198: LOOP
2199: FETCH get_child INTO l_je_header_id;
2200: EXIT WHEN get_child%NOTFOUND;
2201:
2202: gl_je_lines_pkg.delete_lines(l_je_header_id);
2203: dummy := gl_je_segment_values_pkg.delete_segment_values(l_je_header_id);
2204:
2205: -- Delete all of the reconciliation lines
2206: DELETE gl_je_lines_recon

Line 2206: DELETE gl_je_lines_recon

2202: gl_je_lines_pkg.delete_lines(l_je_header_id);
2203: dummy := gl_je_segment_values_pkg.delete_segment_values(l_je_header_id);
2204:
2205: -- Delete all of the reconciliation lines
2206: DELETE gl_je_lines_recon
2207: WHERE je_header_id = l_je_header_id;
2208:
2209: END LOOP;
2210: CLOSE get_child;