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 3780: ,xla_ae_lines ael

3776:
3777: p_entry_locking_dyn_stmt :=
3778: ' SELECT 1
3779: FROM xla_ae_headers aeh
3780: ,xla_ae_lines ael
3781: WHERE ael.ae_header_id = aeh.ae_header_id
3782: AND ael.application_id = aeh.application_id
3783: AND aeh.accounting_entry_status_code IN (''D'', ''F'')
3784: ';

Line 4039: ,xla_ae_lines ael

4035: ,NVL(ael.party_site_id,-999) party_site_id
4036: ,ael.accounted_dr
4037: ,ael.accounted_cr
4038: FROM xla_ae_headers aeh
4039: ,xla_ae_lines ael
4040: ,gl_period_statuses gps
4041: WHERE ael.ae_header_id = aeh.ae_header_id
4042: AND ael.application_id = aeh.application_id
4043: AND gps.ledger_id = aeh.ledger_id

Line 4314: ,xla_ae_lines ael

4310: ,ael.accounted_cr
4311: FROM xla_events xev
4312: ,xla_events_gt xeg
4313: ,xla_ae_headers aeh
4314: ,xla_ae_lines ael
4315: ,gl_period_statuses gps
4316: WHERE xev.application_id = p_application_id
4317: AND xeg.event_id = xev.event_id
4318: AND xeg.application_id = xev.application_id

Line 4358: ,xla_ae_lines ael

4354: ,ael.accounted_dr
4355: ,ael.accounted_cr
4356: FROM xla_events xev
4357: ,xla_ae_headers aeh
4358: ,xla_ae_lines ael
4359: ,gl_period_statuses gps
4360: WHERE xev.request_id = p_request_id
4361: AND xev.application_id = p_application_id
4362: AND xev.process_status_code IN ('D', 'P')

Line 4400: ,xla_ae_lines ael

4396: ,ael.party_site_id
4397: ,ael.accounted_dr
4398: ,ael.accounted_cr
4399: FROM xla_ae_headers aeh
4400: ,xla_ae_lines ael
4401: ,gl_period_statuses gps
4402: WHERE aeh.application_id = p_application_id
4403: AND aeh.entity_id = p_entity_id
4404: AND ael.ae_header_id = aeh.ae_header_id

Line 4541: ,xla_ae_lines ael

4537: ,ael.accounted_cr
4538: FROM xla_events_gt xeg
4539: ,xla_events xe
4540: ,xla_ae_headers aeh
4541: ,xla_ae_lines ael
4542: ,gl_period_statuses gps
4543: WHERE xeg.application_id = p_application_id
4544: AND aeh.application_id = xeg.application_id
4545: AND aeh.event_id = xeg.event_id

Line 4666: ,xla_ae_lines ael

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

Line 4787: ,xla_ae_lines ael

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

Line 6796: UPDATE xla_ae_lines ael

6792: IF p_update_mode <> 'F'
6793: THEN
6794: g_date := SYSDATE;
6795:
6796: UPDATE xla_ae_lines ael
6797: SET ael.control_balance_flag = l_balance_flag_post_update
6798: ,ael.last_update_date = g_date
6799: ,ael.last_updated_by = g_user_id
6800: ,ael.last_update_login = g_login_id

Line 6948: UPDATE xla_ae_lines ael

6944: IF p_update_mode <> 'F'
6945: THEN
6946: g_date := SYSDATE;
6947:
6948: UPDATE xla_ae_lines ael
6949: SET ael.analytical_balance_flag = l_balance_flag_post_update
6950: ,ael.last_update_date = g_date
6951: ,ael.last_updated_by = g_user_id
6952: ,ael.last_update_login = g_login_id

Line 7986: --update xla_ae_lines

7982: END IF;
7983: END LOOP;
7984:
7985:
7986: --update xla_ae_lines
7987: LOOP
7988: l_num_of_records_updated := 0;
7989: UPDATE xla_ae_lines ael
7990: SET ael.control_balance_flag =

Line 7989: UPDATE xla_ae_lines ael

7985:
7986: --update xla_ae_lines
7987: LOOP
7988: l_num_of_records_updated := 0;
7989: UPDATE xla_ae_lines ael
7990: SET ael.control_balance_flag =
7991: DECODE( ael.control_balance_flag
7992: ,'Y'
7993: ,'P'

Line 8000: ,xla_ae_lines xal

7996: WHERE ael.ROWID IN
7997: (SELECT xal.ROWID
7998: FROM xla_balance_statuses xbs
7999: ,xla_ae_headers xah
8000: ,xla_ae_lines xal
8001: ,gl_period_statuses gps
8002: WHERE xbs.balance_status_code = 'R'
8003: AND xbs.balance_source_code = 'C'
8004: AND xbs.request_id = NVL(l_req_id, -1)

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

8039:
8040: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8041: trace
8042: ( p_module => l_log_module
8043: ,p_msg => l_num_of_records_updated || ' xla_ae_lines (ctrl bal) updated to P'
8044: ,p_level => C_LEVEL_STATEMENT
8045: );
8046: END IF;
8047:

Line 8048: UPDATE xla_ae_lines ael

8044: ,p_level => C_LEVEL_STATEMENT
8045: );
8046: END IF;
8047:
8048: UPDATE xla_ae_lines ael
8049: SET ael.analytical_balance_flag =
8050: DECODE( ael.analytical_balance_flag
8051: ,'Y'
8052: ,'P'

Line 8059: ,xla_ae_lines xal

8055: WHERE ael.ROWID IN
8056: (SELECT xal.ROWID
8057: FROM xla_balance_statuses xbs
8058: ,xla_ae_headers xah
8059: ,xla_ae_lines xal
8060: ,gl_period_statuses gps
8061: WHERE xbs.balance_status_code = 'R'
8062: AND xbs.balance_source_code = 'A'
8063: AND xbs.request_id = NVL(l_req_id, -1)

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

8078:
8079: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8080: trace
8081: ( p_module => l_log_module
8082: ,p_msg => l_num_of_records_updated || ' xla_ae_lines (ac bal) updated to P'
8083: ,p_level => C_LEVEL_STATEMENT
8084: );
8085: END IF;
8086:

Line 8545: ,xla_ae_lines xal

8541: THEN
8542: l_party_clause :=
8543: 'AND EXISTS (SELECT 1
8544: FROM xla_ae_headers xah
8545: ,xla_ae_lines xal
8546: WHERE xah.application_id = xbs.application_id
8547: AND xah.ledger_id = xbs.ledger_id
8548: AND xal.code_combination_id = xbs.code_combination_id
8549: AND xal.ae_header_id = xah.ae_header_id

Line 9548: UPDATE xla_ae_lines xal

9544: END IF;
9545:
9546: --must ensure accounting lines have control_balance_flag NULL
9547: LOOP
9548: UPDATE xla_ae_lines xal
9549: SET xal.control_balance_flag = NULL
9550: WHERE xal.code_combination_id IN
9551: (
9552: SELECT xbt.code_combination_id

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

9560:
9561: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9562: trace
9563: (p_module => l_log_module
9564: ,p_msg => l_row_count || ' xla_ae_lines updated to N'
9565: ,p_level => C_LEVEL_STATEMENT
9566: );
9567: END IF;
9568:

Line 9678: UPDATE xla_ae_lines xal

9674: );
9675: END IF;
9676:
9677: LOOP
9678: UPDATE xla_ae_lines xal
9679: SET xal.control_balance_flag = 'P'
9680: WHERE xal.ROWID IN
9681: ( SELECT xal.ROWID
9682: FROM xla_bal_synchronize_gt xbt

Line 9683: ,xla_ae_lines xal

9679: SET xal.control_balance_flag = 'P'
9680: WHERE xal.ROWID IN
9681: ( SELECT xal.ROWID
9682: FROM xla_bal_synchronize_gt xbt
9683: ,xla_ae_lines xal
9684: ,xla_ae_headers xah
9685: ,xla_subledgers xsl
9686: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9687: AND xal.code_combination_id = xbt.code_combination_id

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

9699:
9700: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9701: trace
9702: (p_module => l_log_module
9703: ,p_msg => l_row_count || ' xla_ae_lines updated to P'
9704: ,p_level => C_LEVEL_STATEMENT
9705: );
9706: END IF;
9707:

Line 10040: INSERT INTO xla_ae_lines

10036: ,p_balance_type_code
10037: ,p_period_name
10038: );
10039:
10040: INSERT INTO xla_ae_lines
10041: (
10042: AE_HEADER_ID
10043: ,AE_LINE_NUM
10044: ,CODE_COMBINATION_ID

Line 10093: FROM xla_ae_lines xal

10089:
10090: ELSIF p_mode = 'D'
10091: THEN
10092: DELETE
10093: FROM xla_ae_lines xal
10094: WHERE xal.ae_header_id = p_ae_header_id;
10095:
10096: DELETE
10097: FROM xla_ae_headers xah

Line 10295: ,xla_ae_lines xal

10291: SELECT MIN(gps.effective_period_num)
10292: INTO l_first_entry_eff_period_num
10293: FROM gl_period_statuses gps
10294: ,xla_ae_headers xah
10295: ,xla_ae_lines xal
10296: WHERE gps.ledger_id = p_ledger_id
10297: AND gps.application_id = 101
10298: AND gps.period_name = xah.period_name
10299: AND xah.ledger_id = p_ledger_id