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.JL_CO_GL_NIT_MANAGEMENT dependencies on GL_JE_LINES

Line 74: gl_je_lines gljl

70: 'SEGMENT28',glcc.segment28, 'SEGMENT29',glcc.segment29,
71: 'SEGMENT30',glcc.segment30, NULL) account_code
72: FROM gl_je_headers gljh,
73: gl_code_combinations glcc,
74: gl_je_lines gljl
75: WHERE gljl.status = 'P'
76: AND gljl.period_name = x_period
77: AND gljl.ledger_id = x_sobid
78: AND gljh.je_batch_id = NVL(x_batchid,gljh.je_batch_id)

Line 542: UPDATE gl_je_lines gljl

538: DELETE FROM jl_co_gl_trx jlcgt
539: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
540: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
541: ELSE
542: UPDATE gl_je_lines gljl
543: SET co_processed_flag = 'Y'
544: WHERE gljl.je_header_id = p_journal_rec.je_header_id
545: AND gljl.je_line_num = p_journal_rec.je_line_num
546: AND EXISTS (SELECT 'Y'

Line 935: UPDATE gl_je_lines gljl

931: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
932: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
933:
934: ELSE
935: UPDATE gl_je_lines gljl
936: SET co_processed_flag = 'Y'
937: WHERE gljl.je_header_id = p_journal_rec.je_header_id
938: AND gljl.je_line_num = p_journal_rec.je_line_num
939: AND EXISTS (SELECT 'Y'

Line 965: UPDATE gl_je_lines gljl

961: NULL;
962: END;
963:
964: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
965: UPDATE gl_je_lines gljl
966: SET co_processed_flag = NULL
967: WHERE gljl.je_header_id = p_journal_rec.je_header_id
968: AND gljl.je_line_num = p_journal_rec.je_line_num
969: AND EXISTS (SELECT 'Y'

Line 1133: UPDATE gl_je_lines gljl

1129: DELETE FROM jl_co_gl_trx jlcgt
1130: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1131: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1132: ELSE
1133: UPDATE gl_je_lines gljl
1134: SET co_processed_flag = 'Y'
1135: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1136: AND gljl.je_line_num = p_journal_rec.je_line_num
1137: AND EXISTS (SELECT 'Y'

Line 1227: l_acc_dr gl_je_lines.accounted_dr%TYPE;

1223: FROM gl_import_references glir
1224: WHERE glir.je_header_id = p_journal_rec.je_header_id
1225: AND glir.je_line_num = p_journal_rec.je_line_num;
1226: */
1227: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1228: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1229: l_ent_dr gl_je_lines.entered_dr%TYPE;
1230: l_ent_cr gl_je_lines.entered_cr%TYPE;
1231: l_customer_num po_vendors.segment1%TYPE;

Line 1228: l_acc_cr gl_je_lines.accounted_cr%TYPE;

1224: WHERE glir.je_header_id = p_journal_rec.je_header_id
1225: AND glir.je_line_num = p_journal_rec.je_line_num;
1226: */
1227: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1228: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1229: l_ent_dr gl_je_lines.entered_dr%TYPE;
1230: l_ent_cr gl_je_lines.entered_cr%TYPE;
1231: l_customer_num po_vendors.segment1%TYPE;
1232: l_identifier_type VARCHAR2(30);

Line 1229: l_ent_dr gl_je_lines.entered_dr%TYPE;

1225: AND glir.je_line_num = p_journal_rec.je_line_num;
1226: */
1227: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1228: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1229: l_ent_dr gl_je_lines.entered_dr%TYPE;
1230: l_ent_cr gl_je_lines.entered_cr%TYPE;
1231: l_customer_num po_vendors.segment1%TYPE;
1232: l_identifier_type VARCHAR2(30);
1233: l_country_code varchar2(30);

Line 1230: l_ent_cr gl_je_lines.entered_cr%TYPE;

1226: */
1227: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1228: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1229: l_ent_dr gl_je_lines.entered_dr%TYPE;
1230: l_ent_cr gl_je_lines.entered_cr%TYPE;
1231: l_customer_num po_vendors.segment1%TYPE;
1232: l_identifier_type VARCHAR2(30);
1233: l_country_code varchar2(30);
1234: l_branch_country_code varchar2(60);

Line 1436: UPDATE gl_je_lines gljl

1432: DELETE FROM jl_co_gl_trx jlcgt
1433: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1434: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1435: ELSE
1436: UPDATE gl_je_lines gljl
1437: SET co_processed_flag = 'Y'
1438: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1439: AND gljl.je_line_num = p_journal_rec.je_line_num
1440: AND EXISTS (SELECT 'Y'

Line 1471: UPDATE gl_je_lines gljl

1467: NULL;
1468: END;
1469:
1470: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
1471: UPDATE gl_je_lines gljl
1472: SET co_processed_flag = NULL
1473: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1474: AND gljl.je_line_num = p_journal_rec.je_line_num
1475: AND EXISTS (SELECT 'Y'

Line 1634: UPDATE gl_je_lines gljl

1630: DELETE FROM jl_co_gl_trx jlcgt
1631: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1632: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1633: ELSE
1634: UPDATE gl_je_lines gljl
1635: SET co_processed_flag = 'Y'
1636: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1637: AND gljl.je_line_num = p_journal_rec.je_line_num
1638: AND EXISTS (SELECT 'Y'

Line 2081: UPDATE gl_je_lines gljl

2077: END LOOP; -- UPDATE balances
2078:
2079: -- delete transactions
2080:
2081: UPDATE gl_je_lines gljl
2082: SET co_processed_flag = 'N'
2083: WHERE co_processed_flag = 'Y'
2084: AND status = 'P'
2085: AND EXISTS (SELECT 1