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.

[Home] [Help]

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 133: UPDATE gl_je_lines

129: PROCEDURE change_effective_date(batch_id NUMBER,
130: new_effective_date DATE) IS
131: BEGIN
132: -- Update all of the lines in the header
133: UPDATE gl_je_lines
134: SET effective_date = new_effective_date
135: WHERE je_header_id IN (SELECT je_header_id
136: FROM gl_je_headers
137: WHERE je_batch_id = batch_id);

Line 308: DELETE FROM GL_JE_LINES

304: END IF;
305: END IF;
306:
307: -- Delete all the corrupted ALC journal lines and headers in this batch.
308: DELETE FROM GL_JE_LINES
309: WHERE je_header_id in
310: (SELECT je_header_id
311: FROM gl_je_headers
312: WHERE je_batch_id = batch_id

Line 435: gl_je_lines_pkg.update_lines(

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

Line 503: gl_je_lines_pkg.update_lines(

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

Line 519: gl_je_lines_pkg.update_lines(

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

Line 544: gl_je_lines_pkg.update_lines(

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

Line 559: gl_je_lines_pkg.update_lines(

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

Line 590: FROM gl_je_lines jel

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

Line 998: FROM gl_je_lines

994: IF (X_Je_Header_Id IS NOT NULL) THEN
995: BEGIN
996: SELECT 'Y'
997: INTO has_line
998: FROM gl_je_lines
999: WHERE je_header_id = X_Je_Header_Id
1000: AND rownum = 1;
1001: EXCEPTION
1002: WHEN NO_DATA_FOUND THEN

Line 1904: FROM gl_je_lines

1900: IF (X_Je_Header_Id IS NOT NULL) THEN
1901: BEGIN
1902: SELECT 'Y'
1903: INTO has_line
1904: FROM gl_je_lines
1905: WHERE je_header_id = X_Je_Header_Id
1906: AND rownum = 1;
1907: EXCEPTION
1908: WHEN NO_DATA_FOUND THEN

Line 2093: FROM gl_je_lines

2089: IF (X_Je_Header_Id IS NOT NULL) THEN
2090: BEGIN
2091: SELECT 'Y'
2092: INTO has_line
2093: FROM gl_je_lines
2094: WHERE je_header_id = X_Je_Header_Id
2095: AND rownum = 1;
2096: EXCEPTION
2097: WHEN NO_DATA_FOUND THEN

Line 2109: gl_je_lines_pkg.update_lines(

2105: END IF;
2106:
2107: -- Update the lines effective date, if necessary
2108: IF (X_Effective_Date_Changed = 'Y') THEN
2109: gl_je_lines_pkg.update_lines(
2110: X_Je_Header_Id,
2111: X_Period_Name,
2112: X_Default_Effective_Date,
2113: -1,

Line 2320: gl_je_lines_pkg.delete_lines(X_Je_Header_Id);

2316: N_Last_Updated_By NUMBER;
2317: N_Last_Update_Login NUMBER;
2318: BEGIN
2319: -- Delete any lines
2320: gl_je_lines_pkg.delete_lines(X_Je_Header_Id);
2321:
2322: -- Delete the associated segment values
2323: dummy := gl_je_segment_values_pkg.delete_segment_values(X_Je_Header_Id);
2324:

Line 2326: DELETE gl_je_lines_recon

2322: -- Delete the associated segment values
2323: dummy := gl_je_segment_values_pkg.delete_segment_values(X_Je_Header_Id);
2324:
2325: -- Delete all of the reconciliation lines
2326: DELETE gl_je_lines_recon
2327: WHERE je_header_id = X_Je_Header_Id;
2328:
2329: OPEN get_child;
2330: LOOP

Line 2335: gl_je_lines_pkg.delete_lines(l_je_header_id);

2331: FETCH get_child INTO l_je_header_id,l_je_batch_id,l_ledger_category_code,l_rowid,l_ledger_id;
2332: EXIT WHEN get_child%NOTFOUND;
2333:
2334: IF (l_ledger_category_code = 'ALC') THEN
2335: gl_je_lines_pkg.delete_lines(l_je_header_id);
2336: dummy := gl_je_segment_values_pkg.delete_segment_values(l_je_header_id);
2337:
2338: -- Delete all of the reconciliation lines
2339: DELETE gl_je_lines_recon

Line 2339: DELETE gl_je_lines_recon

2335: gl_je_lines_pkg.delete_lines(l_je_header_id);
2336: dummy := gl_je_segment_values_pkg.delete_segment_values(l_je_header_id);
2337:
2338: -- Delete all of the reconciliation lines
2339: DELETE gl_je_lines_recon
2340: WHERE je_header_id = l_je_header_id;
2341:
2342: ELSE
2343: