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_BALANCES_PKG dependencies on XLA_AE_LINES

Line 96: | 03-Mar-06 V. Kumar Populating GL_SL_LINK_IN in xla_ae_lines |

92: | 10-APR-05 W. Shen Fixed bug 4277500 - removed the table |
93: | 30-NOV-05 V. Kumar Bug 4769611 Modify SQLs in balance calcul- |
94: | ation routine |
95: | 19-Jan-05 V. Kumar Removed the code for AC balances |
96: | 03-Mar-06 V. Kumar Populating GL_SL_LINK_IN in xla_ae_lines |
97: | 05-Dec-08 karamakr 7608545- Reset l_begin_bal_dr, |
98: | l_begin_bal_cr to null |
99: +======================================================================*/
100:

Line 3788: ,xla_ae_lines ael

3784: THEN
3785: p_entry_locking_dyn_stmt :=
3786: ' SELECT /*+ PARALLEL (AEL) leading(aeh) use_nl(ael) */ 1
3787: FROM xla_ae_headers aeh
3788: ,xla_ae_lines ael
3789: WHERE ael.ae_header_id = aeh.ae_header_id
3790: AND ael.application_id = aeh.application_id
3791: AND aeh.accounting_entry_status_code = ''F''
3792: ';

Line 3797: ,xla_ae_lines ael

3793: ELSE
3794: p_entry_locking_dyn_stmt :=
3795: ' SELECT 1
3796: FROM xla_ae_headers aeh
3797: ,xla_ae_lines ael
3798: WHERE ael.ae_header_id = aeh.ae_header_id
3799: AND ael.application_id = aeh.application_id
3800: AND aeh.accounting_entry_status_code = ''F''
3801: ';

Line 4046: ,xla_ae_lines ael

4042: ,NVL(ael.party_site_id,-999) party_site_id
4043: ,ael.accounted_dr
4044: ,ael.accounted_cr
4045: FROM xla_ae_headers aeh
4046: ,xla_ae_lines ael
4047: ,gl_period_statuses gps
4048: WHERE ael.ae_header_id = aeh.ae_header_id
4049: AND ael.application_id = aeh.application_id
4050: AND gps.ledger_id = aeh.ledger_id

Line 4310: ,xla_ae_lines ael

4306: ,ael.accounted_cr
4307: FROM xla_events xev
4308: ,xla_events_gt xeg
4309: ,xla_ae_headers aeh
4310: ,xla_ae_lines ael
4311: ,gl_period_statuses gps
4312: WHERE xev.application_id = p_application_id
4313: AND xeg.event_id = xev.event_id
4314: AND xeg.application_id = xev.application_id

Line 4354: ,xla_ae_lines ael

4350: ,ael.accounted_dr
4351: ,ael.accounted_cr
4352: FROM xla_events xev
4353: ,xla_ae_headers aeh
4354: ,xla_ae_lines ael
4355: ,gl_period_statuses gps
4356: WHERE xev.request_id = p_request_id
4357: AND xev.application_id = p_application_id
4358: AND xev.process_status_code = 'P'

Line 4396: ,xla_ae_lines ael

4392: ,ael.party_site_id
4393: ,ael.accounted_dr
4394: ,ael.accounted_cr
4395: FROM xla_ae_headers aeh
4396: ,xla_ae_lines ael
4397: ,gl_period_statuses gps
4398: WHERE aeh.application_id = p_application_id
4399: AND aeh.entity_id = p_entity_id
4400: AND ael.ae_header_id = aeh.ae_header_id

Line 4537: ,xla_ae_lines ael

4533: ,ael.accounted_cr
4534: FROM xla_events_gt xeg
4535: ,xla_events xe
4536: ,xla_ae_headers aeh
4537: ,xla_ae_lines ael
4538: ,gl_period_statuses gps
4539: WHERE xeg.application_id = p_application_id
4540: AND aeh.application_id = xeg.application_id
4541: AND aeh.event_id = xeg.event_id

Line 4665: ,xla_ae_lines ael

4661: ,ael.accounted_dr
4662: ,ael.accounted_cr
4663: FROM xla_events xev
4664: ,xla_ae_headers aeh
4665: ,xla_ae_lines ael
4666: ,gl_period_statuses gps
4667: WHERE xev.request_id = p_request_id
4668: AND xev.application_id = p_application_id
4669: AND xev.process_status_code = 'P'

Line 4789: ,xla_ae_lines ael

4785: ,NVL(ael.party_site_id,-999) party_site_id
4786: ,ael.accounted_dr
4787: ,ael.accounted_cr
4788: FROM xla_ae_headers aeh
4789: ,xla_ae_lines ael
4790: ,gl_period_statuses gps
4791: WHERE aeh.application_id = p_application_id
4792: AND aeh.entity_id = p_entity_id
4793: AND ael.ae_header_id = aeh.ae_header_id

Line 6820: UPDATE xla_ae_lines ael

6816: IF p_update_mode <> 'F'
6817: THEN
6818: g_date := SYSDATE;
6819:
6820: UPDATE xla_ae_lines ael
6821: SET ael.control_balance_flag = l_balance_flag_post_update
6822: ,ael.last_update_date = g_date
6823: ,ael.last_updated_by = g_user_id
6824: ,ael.last_update_login = g_login_id

Line 6971: UPDATE /+ PARALLEL (AEL) / xla_ae_lines ael

6967:
6968: -- parallel and remove xla_ae_headers join
6969: -- perf changes.
6970:
6971: UPDATE /*+ PARALLEL (AEL) */ xla_ae_lines ael
6972: SET ael.analytical_balance_flag = l_balance_flag_post_update
6973: ,ael.last_update_date = g_date
6974: ,ael.last_updated_by = g_user_id
6975: ,ael.last_update_login = g_login_id

Line 8164: --update xla_ae_lines

8160: END IF;
8161: END LOOP;
8162:
8163:
8164: --update xla_ae_lines
8165: LOOP
8166: l_num_of_records_updated := 0;
8167: UPDATE xla_ae_lines ael
8168: SET ael.control_balance_flag =

Line 8167: UPDATE xla_ae_lines ael

8163:
8164: --update xla_ae_lines
8165: LOOP
8166: l_num_of_records_updated := 0;
8167: UPDATE xla_ae_lines ael
8168: SET ael.control_balance_flag =
8169: DECODE( ael.control_balance_flag
8170: ,'Y'
8171: ,'P'

Line 8178: ,xla_ae_lines xal

8174: WHERE ael.ROWID IN
8175: (SELECT xal.ROWID
8176: FROM xla_balance_statuses xbs
8177: ,xla_ae_headers xah
8178: ,xla_ae_lines xal
8179: ,gl_period_statuses gps
8180: WHERE xbs.balance_status_code = 'R'
8181: AND xbs.balance_source_code = 'C'
8182: AND xbs.request_id = NVL(l_req_id, -1)

Line 8221: ,p_msg => l_num_of_records_updated || ' xla_ae_lines (ctrl bal) updated to P'

8217:
8218: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8219: trace
8220: ( p_module => l_log_module
8221: ,p_msg => l_num_of_records_updated || ' xla_ae_lines (ctrl bal) updated to P'
8222: ,p_level => C_LEVEL_STATEMENT
8223: );
8224: END IF;
8225:

Line 8226: UPDATE xla_ae_lines ael

8222: ,p_level => C_LEVEL_STATEMENT
8223: );
8224: END IF;
8225:
8226: UPDATE xla_ae_lines ael
8227: SET ael.analytical_balance_flag =
8228: DECODE( ael.analytical_balance_flag
8229: ,'Y'
8230: ,'P'

Line 8237: ,xla_ae_lines xal

8233: WHERE ael.ROWID IN
8234: (SELECT xal.ROWID
8235: FROM xla_balance_statuses xbs
8236: ,xla_ae_headers xah
8237: ,xla_ae_lines xal
8238: ,gl_period_statuses gps
8239: WHERE xbs.balance_status_code = 'R'
8240: AND xbs.balance_source_code = 'A'
8241: AND xbs.request_id = NVL(l_req_id, -1)

Line 8260: ,p_msg => l_num_of_records_updated || ' xla_ae_lines (ac bal) updated to P'

8256:
8257: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8258: trace
8259: ( p_module => l_log_module
8260: ,p_msg => l_num_of_records_updated || ' xla_ae_lines (ac bal) updated to P'
8261: ,p_level => C_LEVEL_STATEMENT
8262: );
8263: END IF;
8264:

Line 8724: ,xla_ae_lines xal

8720: THEN
8721: l_party_clause :=
8722: 'AND EXISTS (SELECT 1
8723: FROM xla_ae_headers xah
8724: ,xla_ae_lines xal
8725: WHERE xah.application_id = xbs.application_id
8726: AND xah.ledger_id = xbs.ledger_id
8727: AND xal.code_combination_id = xbs.code_combination_id
8728: AND xal.ae_header_id = xah.ae_header_id

Line 9730: UPDATE xla_ae_lines xal

9726: END IF;
9727:
9728: --must ensure accounting lines have control_balance_flag NULL
9729: LOOP
9730: UPDATE xla_ae_lines xal
9731: SET xal.control_balance_flag = NULL
9732: WHERE xal.code_combination_id IN
9733: (
9734: SELECT xbt.code_combination_id

Line 9746: ,p_msg => l_row_count || ' xla_ae_lines updated to N'

9742:
9743: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9744: trace
9745: (p_module => l_log_module
9746: ,p_msg => l_row_count || ' xla_ae_lines updated to N'
9747: ,p_level => C_LEVEL_STATEMENT
9748: );
9749: END IF;
9750:

Line 9860: UPDATE xla_ae_lines xal

9856: );
9857: END IF;
9858:
9859: LOOP
9860: UPDATE xla_ae_lines xal
9861: SET xal.control_balance_flag = 'P'
9862: WHERE xal.ROWID IN
9863: ( SELECT xal.ROWID
9864: FROM xla_bal_synchronize_gt xbt

Line 9865: ,xla_ae_lines xal

9861: SET xal.control_balance_flag = 'P'
9862: WHERE xal.ROWID IN
9863: ( SELECT xal.ROWID
9864: FROM xla_bal_synchronize_gt xbt
9865: ,xla_ae_lines xal
9866: ,xla_ae_headers xah
9867: ,xla_subledgers xsl
9868: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9869: AND xal.code_combination_id = xbt.code_combination_id

Line 9885: ,p_msg => l_row_count || ' xla_ae_lines updated to P'

9881:
9882: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9883: trace
9884: (p_module => l_log_module
9885: ,p_msg => l_row_count || ' xla_ae_lines updated to P'
9886: ,p_level => C_LEVEL_STATEMENT
9887: );
9888: END IF;
9889:

Line 10229: INSERT INTO xla_ae_lines

10225: ,p_balance_type_code
10226: ,p_period_name
10227: );
10228:
10229: INSERT INTO xla_ae_lines
10230: (
10231: AE_HEADER_ID
10232: ,AE_LINE_NUM
10233: ,CODE_COMBINATION_ID

Line 10282: FROM xla_ae_lines xal

10278:
10279: ELSIF p_mode = 'D'
10280: THEN
10281: DELETE
10282: FROM xla_ae_lines xal
10283: WHERE xal.ae_header_id = p_ae_header_id;
10284:
10285: DELETE
10286: FROM xla_ae_headers xah

Line 10484: ,xla_ae_lines xal

10480: SELECT MIN(gps.effective_period_num)
10481: INTO l_first_entry_eff_period_num
10482: FROM gl_period_statuses gps
10483: ,xla_ae_headers xah
10484: ,xla_ae_lines xal
10485: WHERE gps.ledger_id = p_ledger_id
10486: AND gps.application_id = 101
10487: AND gps.period_name = xah.period_name
10488: AND xah.ledger_id = p_ledger_id