APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_CTRL_LINES_GT

Line 1329: FROM xla_bal_ctrl_lines_gt xbct

1325:
1326: CURSOR c_lock_control_statuses
1327: IS
1328: SELECT 1
1329: FROM xla_bal_ctrl_lines_gt xbct
1330: ,xla_balance_statuses xbs
1331: WHERE xbs.application_id = xbct.application_id
1332: AND xbs.ledger_id = xbct.ledger_id
1333: AND xbs.code_combination_id = xbct.code_combination_id

Line 1422: FROM xla_bal_ctrl_lines_gt xbct

1418: , -1
1419: ,'TO BE DETERMINED'
1420: ,'TO BE DETERMINED'
1421: ,'?'
1422: FROM xla_bal_ctrl_lines_gt xbct
1423: ,xla_balance_statuses xbs
1424: WHERE xbs.application_id (+)= xbct.application_id
1425: AND xbs.ledger_id (+)= xbct.ledger_id
1426: AND xbs.code_combination_id (+)= xbct.code_combination_id

Line 3955: INTO xla_bal_ctrl_lines_gt

3951: INSERT ALL
3952: WHEN control_balance_flag = ''' || p_balance_flag_pre_update || '''
3953: AND NVL( ''' || p_balance_source_code || ''', ''C'') = ''C''
3954: THEN
3955: INTO xla_bal_ctrl_lines_gt
3956: ( line_rowid
3957: ,ae_header_id
3958: ,ae_line_num
3959: ,application_id

Line 4432: FROM xla_bal_ctrl_lines_gt;

4428: END IF;
4429:
4430: --if temp tabs are empty this will not take long
4431: DELETE
4432: FROM xla_bal_ctrl_lines_gt;
4433:
4434: DELETE
4435: FROM xla_bal_anacri_lines_gt;
4436:

Line 4453: --insert into xla_bal_ctrl_lines_gt and xla_bal_anacri_lines_gt

4449: );
4450: --close the cursor
4451: CLOSE lc_lock_entries_for_event_API;
4452:
4453: --insert into xla_bal_ctrl_lines_gt and xla_bal_anacri_lines_gt
4454: INSERT ALL
4455: WHEN control_balance_flag = p_balance_flag_pre_update
4456: THEN
4457: INTO xla_bal_ctrl_lines_gt

Line 4457: INTO xla_bal_ctrl_lines_gt

4453: --insert into xla_bal_ctrl_lines_gt and xla_bal_anacri_lines_gt
4454: INSERT ALL
4455: WHEN control_balance_flag = p_balance_flag_pre_update
4456: THEN
4457: INTO xla_bal_ctrl_lines_gt
4458: ( line_rowid
4459: ,ae_header_id
4460: ,ae_line_num
4461: ,application_id

Line 4578: --insert into xla_bal_ctrl_lines_gt

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

Line 4582: INTO xla_bal_ctrl_lines_gt

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

Line 4700: --insert into xla_bal_ctrl_lines_gt and xla_bal_anacri_lines_gt

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

Line 4704: INTO xla_bal_ctrl_lines_gt

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

Line 5375: FROM xla_bal_ctrl_lines_gt xbct

5371: ,SUM(xbct.accounted_cr) contribution_cr
5372: ,SUM(xbct.accounted_dr) * -1 contribution_draft_dr
5373: ,SUM(xbct.accounted_cr) * -1 contribution_draft_cr
5374: ,xbct.balance_status_eff_per_num
5375: FROM xla_bal_ctrl_lines_gt xbct
5376: GROUP BY xbct.application_id
5377: ,xbct.ledger_id
5378: ,xbct.effective_period_num
5379: ,xbct.period_name

Line 5444: FROM xla_bal_ctrl_lines_gt xbct

5440: ,NULL
5441: )
5442: ) contribution_draft_cr
5443: ,xbct.balance_status_eff_per_num
5444: FROM xla_bal_ctrl_lines_gt xbct
5445: GROUP BY xbct.application_id
5446: ,xbct.ledger_id
5447: ,xbct.effective_period_num
5448: ,xbct.period_name

Line 5513: FROM xla_bal_ctrl_lines_gt xbct

5509: ,NULL
5510: )
5511: ) * -1 contribution_draft_cr
5512: ,xbct.balance_status_eff_per_num
5513: FROM xla_bal_ctrl_lines_gt xbct
5514: GROUP BY xbct.application_id
5515: ,xbct.ledger_id
5516: ,xbct.effective_period_num
5517: ,xbct.period_name

Line 6467: FROM xla_bal_ctrl_lines_gt xbct

6463: (
6464: SELECT DISTINCT
6465: xbct.application_id
6466: ,xbct.ledger_id
6467: FROM xla_bal_ctrl_lines_gt xbct
6468: UNION
6469: SELECT DISTINCT
6470: xbat.application_id
6471: ,xbat.ledger_id

Line 6560: UPDATE xla_bal_ctrl_lines_gt xbct

6556: ,p_level => C_LEVEL_STATEMENT
6557: );
6558: END IF;
6559:
6560: UPDATE xla_bal_ctrl_lines_gt xbct
6561: SET (
6562: balance_status_code
6563: ,balance_status_eff_per_num
6564: )

Line 6581: ' updated in xla_bal_ctrl_lines_gt'

6577: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6578: trace
6579: (p_module => l_log_module
6580: ,p_msg => l_row_count ||
6581: ' updated in xla_bal_ctrl_lines_gt'
6582: ,p_level => C_LEVEL_STATEMENT
6583: );
6584: END IF;
6585:

Line 6621: FROM xla_bal_ctrl_lines_gt xbct

6617: IF p_update_mode <> 'M'
6618: THEN
6619: --Remove the lines for which the balance status is in maintenance mode.
6620: DELETE
6621: FROM xla_bal_ctrl_lines_gt xbct
6622: WHERE xbct.balance_status_code = 'M';
6623:
6624: l_row_count := SQL%ROWCOUNT;
6625:

Line 6630: ' lines deleted from xla_bal_ctrl_lines_gt'

6626: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6627: trace
6628: ( p_module => l_log_module
6629: ,p_msg => l_row_count ||
6630: ' lines deleted from xla_bal_ctrl_lines_gt'
6631: ,p_level => C_LEVEL_STATEMENT
6632: );
6633: END IF;
6634:

Line 6704: FROM xla_bal_ctrl_lines_gt bclt

6700: SELECT DISTINCT
6701: bclt.application_id
6702: ,bclt.ledger_id
6703: ,bclt.effective_period_num
6704: FROM xla_bal_ctrl_lines_gt bclt
6705: ORDER BY bclt.application_id
6706: ,bclt.ledger_id
6707: ,bclt.effective_period_num
6708:

Line 6810: FROM xla_bal_ctrl_lines_gt xbct

6806: ( ael.ROWID
6807: )
6808: IN
6809: ( SELECT xbct.line_rowid
6810: FROM xla_bal_ctrl_lines_gt xbct
6811: )
6812: AND EXISTS (SELECT 1
6813: FROM xla_ae_headers aeh
6814: ,gl_period_statuses gps