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.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_AE_LINES

Line 1056: UPDATE xla_ae_lines

1052: SET event_date = p_gl_date
1053: WHERE application_id = p_application_id
1054: AND event_id = l_info.event_id;
1055:
1056: UPDATE xla_ae_lines
1057: SET accounting_date = p_gl_date
1058: WHERE application_id = p_application_id
1059: AND ae_header_id = p_ae_header_id;
1060: END IF;

Line 1364: DELETE FROM xla_ae_lines

1360: DELETE FROM xla_ae_header_acs
1361: WHERE ae_header_id = l_ae_header_ids(k);
1362:
1363: FORALL k in 1..j
1364: DELETE FROM xla_ae_lines
1365: WHERE application_id = p_application_id
1366: AND ae_header_id = l_ae_header_ids(k);
1367:
1368: FORALL k in 1..j

Line 1477: FROM xla_ae_lines

1473: l_unrounded_accted_dr NUMBER;
1474: l_unrounded_accted_cr NUMBER;
1475:
1476: CURSOR c IS SELECT max(ae_line_num)+1
1477: FROM xla_ae_lines
1478: WHERE application_id = p_application_id
1479: AND ae_header_id = p_ae_header_id;
1480:
1481: l_rounding_rule_code VARCHAR2(30);

Line 1608: INSERT INTO xla_ae_lines

1604:
1605: --
1606: -- Create journal entry line
1607: --
1608: INSERT INTO xla_ae_lines
1609: (ae_header_id
1610: ,displayed_line_number
1611: ,ae_line_num
1612: ,code_combination_id

Line 1853: FROM xla_ae_lines

1849: l_encumbrance_type_id INTEGER;
1850:
1851: CURSOR c_line IS
1852: SELECT code_combination_id
1853: FROM xla_ae_lines
1854: WHERE application_id = p_application_id
1855: AND ae_header_id = p_ae_header_id
1856: AND ae_line_num = p_ae_line_num;
1857:

Line 1996: UPDATE xla_ae_lines

1992:
1993: --
1994: -- Update journal entry line with modified information
1995: --
1996: UPDATE xla_ae_lines
1997: SET code_combination_id = p_code_combination_id
1998: ,displayed_line_number = p_displayed_line_number
1999: ,gl_transfer_mode_code = l_gl_transfer_mode
2000: ,party_id = p_party_id

Line 2178: DELETE xla_ae_lines

2174: ,p_ae_header_id => p_ae_header_id
2175: ,p_ref_ae_header_id => p_ae_header_id
2176: ,p_temp_line_num => p_ae_line_num);
2177:
2178: DELETE xla_ae_lines
2179: WHERE ae_header_id = p_ae_header_id
2180: AND ae_line_num = p_ae_line_num
2181: AND application_id = p_application_id;
2182:

Line 2350: DELETE FROM xla_ae_lines

2346: l_ledger_ids(1) := l_info.ledger_id;
2347: l_ae_header_ids(1) := p_ae_header_id;
2348:
2349: IF (l_orig_status_code = C_AE_STATUS_INVALID) THEN
2350: DELETE FROM xla_ae_lines
2351: WHERE application_id = p_application_id
2352: AND ae_header_id = p_ae_header_id
2353: AND accounting_class_code IN ('ROUNDING', 'BALANCE', 'INTRA', 'INTER');
2354:

Line 2615: UPDATE xla_ae_lines

2611:
2612:
2613:
2614: FORALL i IN 1 .. l_ae_header_ids.COUNT
2615: UPDATE xla_ae_lines
2616: SET gl_sl_link_id = XLA_GL_SL_LINK_ID_S.nextval
2617: ,last_update_date = p_last_update_date
2618: ,last_updated_by = p_last_updated_by
2619: ,last_update_login = p_last_update_login

Line 2650: UPDATE xla_ae_lines l

2646:
2647:
2648: IF (l_bal_update_mode IS NOT NULL) THEN
2649: --FORALL i IN 1 .. l_ae_header_ids.COUNT
2650: UPDATE xla_ae_lines l
2651: SET control_balance_flag =
2652: (SELECT DECODE(l.accounting_class_code,
2653: 'INTER', NULL,
2654: 'INTRA', NULL,

Line 3447: FROM xla_ae_lines

3443: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
3444: IS
3445: CURSOR c IS
3446: SELECT ae_line_num
3447: FROM xla_ae_lines
3448: WHERE ae_header_id = p_header_id
3449: AND ae_line_num = p_line_num
3450: AND application_id = p_application_id;
3451:

Line 3520: FROM xla_ae_lines

3516: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
3517: IS
3518: CURSOR c IS
3519: SELECT ae_line_num
3520: FROM xla_ae_lines
3521: WHERE ae_header_id = p_header_id
3522: AND ae_line_num <> nvl(p_line_num,-1)
3523: AND displayed_line_number = p_display_line_num
3524: AND application_id = p_application_id;

Line 3601: FROM xla_ae_lines

3597: RETURN INTEGER
3598: IS
3599: CURSOR c_line IS
3600: SELECT ae_line_num, accounting_class_code, gl_transfer_mode_code
3601: FROM xla_ae_lines
3602: WHERE ae_header_id = p_ae_header_id
3603: AND application_id = p_application_id;
3604:
3605: l_retcode INTEGER := 0;

Line 4180: INSERT INTO xla_ae_lines

4176:
4177: --
4178: -- Create journal entry lines for the reversal journal entry
4179: --
4180: INSERT INTO xla_ae_lines
4181: (application_id
4182: ,ae_header_id
4183: ,ae_line_num
4184: ,displayed_line_number

Line 4292: FROM xla_ae_lines

4288: ,l_mrc_header.ledger_id
4289: ,p_info.gl_date
4290: ,gain_or_loss_flag
4291: ,NVL(mpa_accrual_entry_flag,'N')
4292: FROM xla_ae_lines
4293: WHERE application_id = p_info.application_id
4294: AND ae_header_id = l_mrc_header.ae_header_id;
4295:
4296: create_reversal_distr_link

Line 4531: INSERT INTO xla_ae_lines

4527:
4528: --
4529: -- Create journal entry lines for the reversal journal entry
4530: --
4531: INSERT INTO xla_ae_lines
4532: (application_id
4533: ,ae_header_id
4534: ,ae_line_num
4535: ,displayed_line_number

Line 4646: FROM xla_ae_lines

4642: ,gain_or_loss_flag
4643: ,p_info.ledger_id
4644: ,p_gl_date
4645: ,NVL(mpa_accrual_entry_flag,'N') -- 4262811 mpa_accrual_entry_flag
4646: FROM xla_ae_lines
4647: WHERE application_id = p_info.application_id
4648: AND ae_header_id = p_info.header_id;
4649:
4650:

Line 4718: FROM xla_ae_lines

4714: ,p_ae_header_id IN INTEGER)
4715: IS
4716: CURSOR c_lines IS
4717: SELECT ae_line_num
4718: FROM xla_ae_lines
4719: WHERE application_id = p_application_id
4720: AND ae_header_id = p_ae_header_id
4721: ORDER BY ae_line_num;
4722:

Line 4765: UPDATE xla_ae_lines

4761: p_level => C_LEVEL_EVENT);
4762: END IF;
4763:
4764: FORALL j in 1..i
4765: UPDATE xla_ae_lines
4766: set displayed_line_number = l_displayed_nums(j)
4767: WHERE application_id = p_application_id
4768: AND ae_header_id = p_ae_header_id
4769: AND ae_line_num = l_ae_line_nums(j);

Line 5168: FROM xla_ae_lines xal

5164: trunc(fc1.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) to_type
5165: , decode( fc2.derive_type, 'EURO', 'EURO', 'EMU',
5166: decode( sign( trunc(nvl(xal.currency_conversion_date, xal.accounting_date)) -
5167: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
5168: FROM xla_ae_lines xal
5169: , fnd_currencies fc
5170: , fnd_currencies fc1
5171: , fnd_currencies fc2
5172: WHERE xal.ae_header_id = p_info.header_id

Line 5598: INSERT INTO xla_ae_lines

5594:
5595: --
5596: -- Create journal entry lines for the mrc entry
5597: --
5598: INSERT INTO xla_ae_lines
5599: (ae_header_id
5600: ,ae_line_num
5601: ,displayed_line_number
5602: ,application_id

Line 5922: DELETE FROM xla_ae_lines

5918: DELETE FROM xla_ae_segment_values
5919: WHERE ae_header_id = l_header_ids(j);
5920:
5921: FORALL j in 1..i
5922: DELETE FROM xla_ae_lines
5923: WHERE ae_header_id = l_header_ids(j)
5924: AND application_id = p_application_id;
5925:
5926: FORALL j in 1..i

Line 6329: FROM xla_ae_lines

6325: , nvl(sum(nvl(accounted_cr,0)),1)
6326: , nvl(sum(CASE WHEN accounted_dr IS NULL THEN 0 ELSE 1 end),0)
6327: , nvl(sum(CASE WHEN accounted_cr IS NULL THEN 0 ELSE 1 end),0)
6328: , nvl(sum(CASE WHEN currency_code = 'STAT' THEN 1 ELSE 0 end),0)
6329: FROM xla_ae_lines
6330: WHERE application_id = p_application_id
6331: AND ae_header_id = p_ae_header_id;
6332:
6333: l_total_acct_dr NUMBER := 0;

Line 7194: FROM xla_ae_lines

7190: ,accounted_cr
7191: ,currency_conversion_type conv_type
7192: ,currency_conversion_date conv_date
7193: ,currency_conversion_rate conv_rate
7194: FROM xla_ae_lines
7195: WHERE ae_header_id = p_ae_header_id
7196: AND application_id = p_application_id;
7197:
7198: l_result INTEGER := 0;

Line 7866: FROM xla_ae_lines

7862: -- check that lines exists
7863: -------------------------------------------
7864: SELECT count(*)
7865: INTO l_dummy
7866: FROM xla_ae_lines
7867: WHERE application_id = p_application_id
7868: AND ae_header_id = p_ae_header_id
7869: AND ae_line_num = p_ae_line_num;
7870:

Line 7951: Update XLA_AE_LINES

7947: p_module => l_log_module,
7948: p_level => C_LEVEL_STATEMENT);
7949: END IF;
7950: IF p_item_name NOT IN (C_ITEM_HEADER_DESCRIPTION, C_ITEM_REFERENCE_DATE) THEN
7951: Update XLA_AE_LINES
7952: SET CODE_COMBINATION_ID = DECODE(p_item_name, C_ITEM_ACCOUNT, p_value_number, CODE_COMBINATION_ID)
7953: ,ACCOUNTED_DR = DECODE(p_item_name, C_ITEM_ACCOUNTED_DR, p_value_number, ACCOUNTED_DR)
7954: ,ACCOUNTED_CR = DECODE(p_item_name, C_ITEM_ACCOUNTED_CR, p_value_number, ACCOUNTED_CR)
7955: ,CURRENCY_CODE = DECODE(p_item_name, C_ITEM_CURRENCY_CODE, p_value_varchar2, CURRENCY_CODE)

Line 7969: -- GL Date is stored in xla_ae_lines, need to audit all lines

7965: AND ae_header_id = p_ae_header_id
7966: AND ae_line_num = DECODE(p_item_name, C_ITEM_GL_DATE, ae_line_num, p_ae_line_num);
7967:
7968: --------------------------------------------------------------
7969: -- GL Date is stored in xla_ae_lines, need to audit all lines
7970: --------------------------------------------------------------
7971: IF p_item_name = 'GL_DATE' then
7972: xla_datafixes_pub.audit_datafix (p_application_id => p_application_id
7973: ,p_ae_header_id => p_ae_header_id);

Line 8163: ,xla_ae_lines xal

8159: ,xal.unrounded_entered_cr
8160: ,xal.unrounded_accounted_dr
8161: ,xal.unrounded_accounted_cr
8162: FROM xla_ae_headers xah
8163: ,xla_ae_lines xal
8164: WHERE xah.application_id = p_application_id
8165: AND xah.ae_header_id = p_ae_header_id
8166: AND xal.application_id = xah.application_id
8167: AND xal.ae_header_id = xah.ae_header_id

Line 8432: ,xla_ae_lines xal

8428: ,xal.unrounded_entered_cr
8429: ,xal.unrounded_accounted_dr
8430: ,xal.unrounded_accounted_cr
8431: FROM xla_ae_headers xah
8432: ,xla_ae_lines xal
8433: WHERE xah.application_id = p_application_id
8434: AND xah.ae_header_id = p_ae_header_id
8435: AND xal.application_id = xah.application_id
8436: AND xal.ae_header_id = xah.ae_header_id;