APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_ANACRI_LINES_GT

Line 1329: FROM xla_bal_anacri_lines_gt xblt

1325:
1326: CURSOR c_lock_analytical_statuses
1327: IS
1328: SELECT /*+ full(xblt) */ 1
1329: FROM xla_bal_anacri_lines_gt xblt
1330: ,xla_balance_statuses xbs
1331: WHERE xbs.application_id = xblt.application_id
1332: AND xbs.ledger_id = xblt.ledger_id
1333: AND xbs.code_combination_id = xblt.code_combination_id

Line 1431: FROM xla_bal_anacri_lines_gt xbat

1427: , -1
1428: ,'TO BE DETERMINED'
1429: ,'TO BE DETERMINED'
1430: ,'?'
1431: FROM xla_bal_anacri_lines_gt xbat
1432: ,xla_balance_statuses xbs
1433: WHERE xbs.application_id (+)= xbat.application_id
1434: AND xbs.ledger_id (+)= xbat.ledger_id
1435: AND xbs.code_combination_id (+)= xbat.code_combination_id

Line 3999: INTO xla_bal_anacri_lines_gt

3995:
3996: WHEN analytical_balance_flag = ''' || p_balance_flag_pre_update || '''
3997: AND NVL( ''' || p_balance_source_code || ''', ''A'') = ''A''
3998: THEN
3999: INTO xla_bal_anacri_lines_gt
4000: ( line_rowid
4001: ,ae_header_id
4002: ,ae_line_num
4003: ,application_id

Line 4431: FROM xla_bal_anacri_lines_gt;

4427: DELETE
4428: FROM xla_bal_ctrl_lines_gt;
4429:
4430: DELETE
4431: FROM xla_bal_anacri_lines_gt;
4432:
4433: -- if it is called by bulk event API
4434: IF p_called_by_flag = 'E' THEN
4435: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

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

4485: ,accounted_cr
4486: )
4487: WHEN analytical_balance_flag = p_balance_flag_pre_update
4488: THEN
4489: INTO xla_bal_anacri_lines_gt
4490: ( line_rowid
4491: ,ae_header_id
4492: ,ae_line_num
4493: ,application_id

Line 4617: INTO xla_bal_anacri_lines_gt

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

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

Line 5077: FROM xla_bal_anacri_lines_gt xbct

5073: ,SUM(xbct.accounted_dr) contribution_dr
5074: ,SUM(xbct.accounted_cr) contribution_cr
5075: ,xbct.balance_status_eff_per_num
5076: ,xbct.account_type
5077: FROM xla_bal_anacri_lines_gt xbct
5078: ,xla_ae_line_acs xad
5079: WHERE xad.ae_header_id = xbct.ae_header_id
5080: AND xad.ae_line_num = xbct.ae_line_num
5081: GROUP BY xbct.application_id

Line 5165: FROM xla_bal_anacri_lines_gt xbct

5161: )
5162: ) contribution_cr
5163: ,xbct.balance_status_eff_per_num
5164: ,xbct.account_type
5165: FROM xla_bal_anacri_lines_gt xbct
5166: ,xla_ae_line_acs xad
5167: WHERE xad.ae_header_id = xbct.ae_header_id
5168: AND xad.ae_line_num = xbct.ae_line_num
5169: GROUP BY xbct.application_id

Line 5251: FROM xla_bal_anacri_lines_gt xbct

5247: )
5248: ) * -1 contribution_cr
5249: ,xbct.balance_status_eff_per_num
5250: ,xbct.account_type
5251: FROM xla_bal_anacri_lines_gt xbct
5252: ,xla_ae_line_acs xad
5253: WHERE xad.ae_header_id = xbct.ae_header_id
5254: AND xad.ae_line_num = xbct.ae_line_num
5255: GROUP BY xbct.application_id

Line 6496: FROM xla_bal_anacri_lines_gt xbat

6492: UNION
6493: SELECT DISTINCT
6494: xbat.application_id
6495: ,xbat.ledger_id
6496: FROM xla_bal_anacri_lines_gt xbat
6497: )
6498: LOOP
6499: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6500: trace

Line 6610: UPDATE /*+ PARALLEL (xbat) */ xla_bal_anacri_lines_gt xbat

6606: ,p_level => C_LEVEL_STATEMENT
6607: );
6608: END IF;
6609:
6610: UPDATE /*+ PARALLEL (xbat) */ xla_bal_anacri_lines_gt xbat
6611: SET (
6612: balance_status_code
6613: ,balance_status_eff_per_num
6614: ,account_type

Line 6634: ' updated in xla_bal_anacri_lines_gt'

6630: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6631: trace
6632: (p_module => l_log_module
6633: ,p_msg => l_row_count ||
6634: ' updated in xla_bal_anacri_lines_gt'
6635: ,p_level => C_LEVEL_STATEMENT
6636: );
6637: END IF;
6638:

Line 6665: FROM xla_bal_anacri_lines_gt xbat

6661: l_result := FALSE;
6662: END IF;
6663:
6664: DELETE
6665: FROM xla_bal_anacri_lines_gt xbat
6666: WHERE xbat.balance_status_code = 'M';
6667: l_row_count := SQL%ROWCOUNT;
6668:
6669: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 6673: ' lines deleted from xla_bal_anacri_lines_gt'

6669: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6670: trace
6671: (p_module => l_log_module
6672: ,p_msg => l_row_count ||
6673: ' lines deleted from xla_bal_anacri_lines_gt'
6674: ,p_level => C_LEVEL_STATEMENT
6675: );
6676: END IF;
6677:

Line 6873: FROM xla_bal_anacri_lines_gt bclt

6869: SELECT DISTINCT
6870: bclt.application_id
6871: ,bclt.ledger_id
6872: ,bclt.effective_period_num
6873: FROM xla_bal_anacri_lines_gt bclt
6874: )
6875: LOOP
6876:
6877: IF p_update_mode = 'M'

Line 6982: FROM xla_bal_anacri_lines_gt xbct)

6978: ,ael.program_id = g_prog_id
6979: ,ael.request_id = g_req_id
6980: WHERE (ael.ROWID) IN
6981: (SELECT /*+ leading(XBCT) */ xbct.line_rowid
6982: FROM xla_bal_anacri_lines_gt xbct)
6983: and ael.application_id=p_application_id;--Bug 7493686
6984:
6985:
6986: l_row_count := SQL%ROWCOUNT;