APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_ANACRI_LINES_GT

Line 1340: FROM xla_bal_anacri_lines_gt xblt

1336:
1337: CURSOR c_lock_analytical_statuses
1338: IS
1339: SELECT 1
1340: FROM xla_bal_anacri_lines_gt xblt
1341: ,xla_balance_statuses xbs
1342: WHERE xbs.application_id = xblt.application_id
1343: AND xbs.ledger_id = xblt.ledger_id
1344: AND xbs.code_combination_id = xblt.code_combination_id

Line 1442: FROM xla_bal_anacri_lines_gt xbat

1438: , -1
1439: ,'TO BE DETERMINED'
1440: ,'TO BE DETERMINED'
1441: ,'?'
1442: FROM xla_bal_anacri_lines_gt xbat
1443: ,xla_balance_statuses xbs
1444: WHERE xbs.application_id (+)= xbat.application_id
1445: AND xbs.ledger_id (+)= xbat.ledger_id
1446: AND xbs.code_combination_id (+)= xbat.code_combination_id

Line 3993: INTO xla_bal_anacri_lines_gt

3989:
3990: WHEN analytical_balance_flag = ''' || p_balance_flag_pre_update || '''
3991: AND NVL( ''' || p_balance_source_code || ''', ''A'') = ''A''
3992: THEN
3993: INTO xla_bal_anacri_lines_gt
3994: ( line_rowid
3995: ,ae_header_id
3996: ,ae_line_num
3997: ,application_id

Line 4435: FROM xla_bal_anacri_lines_gt;

4431: DELETE
4432: FROM xla_bal_ctrl_lines_gt;
4433:
4434: DELETE
4435: FROM xla_bal_anacri_lines_gt;
4436:
4437: -- if it is called by bulk event API
4438: IF p_called_by_flag = 'E' THEN
4439: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

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 4493: INTO xla_bal_anacri_lines_gt

4489: ,accounted_cr
4490: )
4491: WHEN analytical_balance_flag = p_balance_flag_pre_update
4492: THEN
4493: INTO xla_bal_anacri_lines_gt
4494: ( line_rowid
4495: ,ae_header_id
4496: ,ae_line_num
4497: ,application_id

Line 4618: INTO xla_bal_anacri_lines_gt

4614: ,accounted_cr
4615: )
4616: WHEN analytical_balance_flag = p_balance_flag_pre_update
4617: THEN
4618: INTO xla_bal_anacri_lines_gt
4619: ( line_rowid
4620: ,ae_header_id
4621: ,ae_line_num
4622: ,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 4740: INTO xla_bal_anacri_lines_gt

4736: ,accounted_cr
4737: )
4738: WHEN analytical_balance_flag = p_balance_flag_pre_update
4739: THEN
4740: INTO xla_bal_anacri_lines_gt
4741: ( line_rowid
4742: ,ae_header_id
4743: ,ae_line_num
4744: ,application_id

Line 5062: FROM xla_bal_anacri_lines_gt xbct

5058: ,SUM(xbct.accounted_dr) contribution_dr
5059: ,SUM(xbct.accounted_cr) contribution_cr
5060: ,xbct.balance_status_eff_per_num
5061: ,xbct.account_type
5062: FROM xla_bal_anacri_lines_gt xbct
5063: ,xla_ae_line_acs xad
5064: WHERE xad.ae_header_id = xbct.ae_header_id
5065: AND xad.ae_line_num = xbct.ae_line_num
5066: GROUP BY xbct.application_id

Line 5148: FROM xla_bal_anacri_lines_gt xbct

5144: )
5145: ) contribution_cr
5146: ,xbct.balance_status_eff_per_num
5147: ,xbct.account_type
5148: FROM xla_bal_anacri_lines_gt xbct
5149: ,xla_ae_line_acs xad
5150: WHERE xad.ae_header_id = xbct.ae_header_id
5151: AND xad.ae_line_num = xbct.ae_line_num
5152: GROUP BY xbct.application_id

Line 5232: FROM xla_bal_anacri_lines_gt xbct

5228: )
5229: ) * -1 contribution_cr
5230: ,xbct.balance_status_eff_per_num
5231: ,xbct.account_type
5232: FROM xla_bal_anacri_lines_gt xbct
5233: ,xla_ae_line_acs xad
5234: WHERE xad.ae_header_id = xbct.ae_header_id
5235: AND xad.ae_line_num = xbct.ae_line_num
5236: GROUP BY xbct.application_id

Line 6472: FROM xla_bal_anacri_lines_gt xbat

6468: UNION
6469: SELECT DISTINCT
6470: xbat.application_id
6471: ,xbat.ledger_id
6472: FROM xla_bal_anacri_lines_gt xbat
6473: )
6474: LOOP
6475: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6476: trace

Line 6586: UPDATE xla_bal_anacri_lines_gt xbat

6582: ,p_level => C_LEVEL_STATEMENT
6583: );
6584: END IF;
6585:
6586: UPDATE xla_bal_anacri_lines_gt xbat
6587: SET (
6588: balance_status_code
6589: ,balance_status_eff_per_num
6590: ,account_type

Line 6610: ' updated in xla_bal_anacri_lines_gt'

6606: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6607: trace
6608: (p_module => l_log_module
6609: ,p_msg => l_row_count ||
6610: ' updated in xla_bal_anacri_lines_gt'
6611: ,p_level => C_LEVEL_STATEMENT
6612: );
6613: END IF;
6614:

Line 6641: FROM xla_bal_anacri_lines_gt xbat

6637: l_result := FALSE;
6638: END IF;
6639:
6640: DELETE
6641: FROM xla_bal_anacri_lines_gt xbat
6642: WHERE xbat.balance_status_code = 'M';
6643: l_row_count := SQL%ROWCOUNT;
6644:
6645: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 6649: ' lines deleted from xla_bal_anacri_lines_gt'

6645: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6646: trace
6647: (p_module => l_log_module
6648: ,p_msg => l_row_count ||
6649: ' lines deleted from xla_bal_anacri_lines_gt'
6650: ,p_level => C_LEVEL_STATEMENT
6651: );
6652: END IF;
6653:

Line 6853: FROM xla_bal_anacri_lines_gt bclt

6849: SELECT DISTINCT
6850: bclt.application_id
6851: ,bclt.ledger_id
6852: ,bclt.effective_period_num
6853: FROM xla_bal_anacri_lines_gt bclt
6854: )
6855: LOOP
6856:
6857: IF p_update_mode = 'M'

Line 6965: FROM xla_bal_anacri_lines_gt xbct

6961: IN
6962: ( SELECT xbct.application_id
6963: ,xbct.ae_header_id
6964: ,xbct.ae_line_num
6965: FROM xla_bal_anacri_lines_gt xbct
6966: )
6967: AND EXISTS (SELECT 1
6968: FROM xla_ae_headers aeh
6969: ,gl_period_statuses gps