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_BAL_CTRL_LINES_GT

Line 1318: FROM xla_bal_ctrl_lines_gt xbct

1314:
1315: CURSOR c_lock_control_statuses
1316: IS
1317: SELECT 1
1318: FROM xla_bal_ctrl_lines_gt xbct
1319: ,xla_balance_statuses xbs
1320: WHERE xbs.application_id = xbct.application_id
1321: AND xbs.ledger_id = xbct.ledger_id
1322: AND xbs.code_combination_id = xbct.code_combination_id

Line 1411: FROM xla_bal_ctrl_lines_gt xbct

1407: , -1
1408: ,'TO BE DETERMINED'
1409: ,'TO BE DETERMINED'
1410: ,'?'
1411: FROM xla_bal_ctrl_lines_gt xbct
1412: ,xla_balance_statuses xbs
1413: WHERE xbs.application_id (+)= xbct.application_id
1414: AND xbs.ledger_id (+)= xbct.ledger_id
1415: AND xbs.code_combination_id (+)= xbct.code_combination_id

Line 3961: INTO xla_bal_ctrl_lines_gt

3957: INSERT ALL
3958: WHEN control_balance_flag = ''' || p_balance_flag_pre_update || '''
3959: AND NVL( ''' || p_balance_source_code || ''', ''C'') = ''C''
3960: THEN
3961: INTO xla_bal_ctrl_lines_gt
3962: ( line_rowid
3963: ,ae_header_id
3964: ,ae_line_num
3965: ,application_id

Line 4428: FROM xla_bal_ctrl_lines_gt;

4424: END IF;
4425:
4426: --if temp tabs are empty this will not take long
4427: DELETE
4428: FROM xla_bal_ctrl_lines_gt;
4429:
4430: DELETE
4431: FROM xla_bal_anacri_lines_gt;
4432:

Line 4449: --insert into xla_bal_ctrl_lines_gt and xla_bal_anacri_lines_gt

4445: );
4446: --close the cursor
4447: CLOSE lc_lock_entries_for_event_API;
4448:
4449: --insert into xla_bal_ctrl_lines_gt and xla_bal_anacri_lines_gt
4450: INSERT ALL
4451: WHEN control_balance_flag = p_balance_flag_pre_update
4452: THEN
4453: INTO xla_bal_ctrl_lines_gt

Line 4453: INTO xla_bal_ctrl_lines_gt

4449: --insert into xla_bal_ctrl_lines_gt and xla_bal_anacri_lines_gt
4450: INSERT ALL
4451: WHEN control_balance_flag = p_balance_flag_pre_update
4452: THEN
4453: INTO xla_bal_ctrl_lines_gt
4454: ( line_rowid
4455: ,ae_header_id
4456: ,ae_line_num
4457: ,application_id

Line 4577: --insert into xla_bal_ctrl_lines_gt

4573: );
4574: --close the cursor
4575: CLOSE lc_lock_entries_for_request_id;
4576:
4577: --insert into xla_bal_ctrl_lines_gt
4578: INSERT ALL
4579: WHEN control_balance_flag = p_balance_flag_pre_update
4580: THEN
4581: INTO xla_bal_ctrl_lines_gt

Line 4581: INTO xla_bal_ctrl_lines_gt

4577: --insert into xla_bal_ctrl_lines_gt
4578: INSERT ALL
4579: WHEN control_balance_flag = p_balance_flag_pre_update
4580: THEN
4581: INTO xla_bal_ctrl_lines_gt
4582: ( line_rowid
4583: ,ae_header_id
4584: ,ae_line_num
4585: ,application_id

Line 4702: --insert into xla_bal_ctrl_lines_gt and xla_bal_anacri_lines_gt

4698: );
4699: --close the cursor
4700: CLOSE lc_lock_entries_for_entity_id;
4701:
4702: --insert into xla_bal_ctrl_lines_gt and xla_bal_anacri_lines_gt
4703: INSERT ALL
4704: WHEN control_balance_flag = p_balance_flag_pre_update
4705: THEN
4706: INTO xla_bal_ctrl_lines_gt

Line 4706: INTO xla_bal_ctrl_lines_gt

4702: --insert into xla_bal_ctrl_lines_gt and xla_bal_anacri_lines_gt
4703: INSERT ALL
4704: WHEN control_balance_flag = p_balance_flag_pre_update
4705: THEN
4706: INTO xla_bal_ctrl_lines_gt
4707: ( line_rowid
4708: ,ae_header_id
4709: ,ae_line_num
4710: ,application_id

Line 5394: FROM xla_bal_ctrl_lines_gt xbct

5390: ,SUM(xbct.accounted_cr) contribution_cr
5391: ,SUM(xbct.accounted_dr) * -1 contribution_draft_dr
5392: ,SUM(xbct.accounted_cr) * -1 contribution_draft_cr
5393: ,xbct.balance_status_eff_per_num
5394: FROM xla_bal_ctrl_lines_gt xbct
5395: GROUP BY xbct.application_id
5396: ,xbct.ledger_id
5397: ,xbct.effective_period_num
5398: ,xbct.period_name

Line 5463: FROM xla_bal_ctrl_lines_gt xbct

5459: ,NULL
5460: )
5461: ) contribution_draft_cr
5462: ,xbct.balance_status_eff_per_num
5463: FROM xla_bal_ctrl_lines_gt xbct
5464: GROUP BY xbct.application_id
5465: ,xbct.ledger_id
5466: ,xbct.effective_period_num
5467: ,xbct.period_name

Line 5532: FROM xla_bal_ctrl_lines_gt xbct

5528: ,NULL
5529: )
5530: ) * -1 contribution_draft_cr
5531: ,xbct.balance_status_eff_per_num
5532: FROM xla_bal_ctrl_lines_gt xbct
5533: GROUP BY xbct.application_id
5534: ,xbct.ledger_id
5535: ,xbct.effective_period_num
5536: ,xbct.period_name

Line 6491: FROM xla_bal_ctrl_lines_gt xbct

6487: (
6488: SELECT DISTINCT
6489: xbct.application_id
6490: ,xbct.ledger_id
6491: FROM xla_bal_ctrl_lines_gt xbct
6492: UNION
6493: SELECT DISTINCT
6494: xbat.application_id
6495: ,xbat.ledger_id

Line 6584: UPDATE xla_bal_ctrl_lines_gt xbct

6580: ,p_level => C_LEVEL_STATEMENT
6581: );
6582: END IF;
6583:
6584: UPDATE xla_bal_ctrl_lines_gt xbct
6585: SET (
6586: balance_status_code
6587: ,balance_status_eff_per_num
6588: )

Line 6605: ' updated in xla_bal_ctrl_lines_gt'

6601: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6602: trace
6603: (p_module => l_log_module
6604: ,p_msg => l_row_count ||
6605: ' updated in xla_bal_ctrl_lines_gt'
6606: ,p_level => C_LEVEL_STATEMENT
6607: );
6608: END IF;
6609:

Line 6645: FROM xla_bal_ctrl_lines_gt xbct

6641: IF p_update_mode <> 'M'
6642: THEN
6643: --Remove the lines for which the balance status is in maintenance mode.
6644: DELETE
6645: FROM xla_bal_ctrl_lines_gt xbct
6646: WHERE xbct.balance_status_code = 'M';
6647:
6648: l_row_count := SQL%ROWCOUNT;
6649:

Line 6654: ' lines deleted from xla_bal_ctrl_lines_gt'

6650: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6651: trace
6652: ( p_module => l_log_module
6653: ,p_msg => l_row_count ||
6654: ' lines deleted from xla_bal_ctrl_lines_gt'
6655: ,p_level => C_LEVEL_STATEMENT
6656: );
6657: END IF;
6658:

Line 6728: FROM xla_bal_ctrl_lines_gt bclt

6724: SELECT DISTINCT
6725: bclt.application_id
6726: ,bclt.ledger_id
6727: ,bclt.effective_period_num
6728: FROM xla_bal_ctrl_lines_gt bclt
6729: ORDER BY bclt.application_id
6730: ,bclt.ledger_id
6731: ,bclt.effective_period_num
6732:

Line 6831: FROM xla_bal_ctrl_lines_gt xbct

6827: ,ael.program_id = g_prog_id
6828: ,ael.request_id = g_req_id
6829: WHERE ael.ROWID IN
6830: (SELECT /*+ leading(XBCT) */ xbct.line_rowid
6831: FROM xla_bal_ctrl_lines_gt xbct
6832: WHERE EXISTS
6833: (SELECT /*+ no_unnest */ 1
6834: FROM gl_period_statuses gps
6835: WHERE gps.application_id = 101