APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_SYNCHRONIZE_GT

Line 9508: INTO xla_bal_synchronize_gt

9504: LOOP
9505: EXECUTE IMMEDIATE
9506: '
9507: INSERT
9508: INTO xla_bal_synchronize_gt
9509: ( chart_of_accounts_id
9510: ,code_combination_id
9511: ,reference3
9512: )

Line 9517: ,xla_bal_synchronize_gt xbt

9513: SELECT gcc.chart_of_accounts_id
9514: ,gcc.code_combination_id
9515: ,gcc.reference3
9516: FROM gl_code_combinations gcc
9517: ,xla_bal_synchronize_gt xbt
9518: WHERE gcc.chart_of_accounts_id = :1
9519: AND gcc.' || l_account_segment_column || ' = :2
9520: AND xbt.chart_of_accounts_id (+)= :3
9521: AND xbt.code_combination_id (+)= gcc.code_combination_id

Line 9536: || ' records inserted in xla_bal_synchronize_gt'

9532: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9533: trace
9534: (p_module => l_log_module
9535: ,p_msg => l_row_count
9536: || ' records inserted in xla_bal_synchronize_gt'
9537: ,p_level => C_LEVEL_STATEMENT
9538: );
9539: END IF;
9540:

Line 9554: FROM xla_bal_synchronize_gt xbt

9550: SELECT MIN(reference3)
9551: ,MAX(reference3)
9552: INTO l_min_reference3
9553: ,l_max_reference3
9554: FROM xla_bal_synchronize_gt xbt
9555: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id;
9556:
9557: IF NVL(l_min_reference3,'N') = NVL(l_max_reference3, 'N') OR
9558: NVL(l_min_reference3,'R') = NVL(l_max_reference3, 'R') -- added condition for 8490178

Line 9620: FROM xla_bal_synchronize_gt xbt

9616: )
9617: AND xbs.code_combination_id IN
9618: (
9619: SELECT xbt.code_combination_id
9620: FROM xla_bal_synchronize_gt xbt
9621: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9622: )
9623: AND xbs.balance_source_code = 'C'
9624: AND xbs.balance_status_code IN ('A', 'S')

Line 9639: FROM xla_bal_synchronize_gt xbt

9635: )
9636: AND xbs.code_combination_id IN
9637: (
9638: SELECT xbt.code_combination_id
9639: FROM xla_bal_synchronize_gt xbt
9640: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9641: )
9642: AND xbs.balance_source_code = 'C'
9643: AND xbs.balance_status_code IN ('A', 'S')

Line 9686: FROM xla_bal_synchronize_gt xbt

9682: AND xbs.balance_source_code = ''C''
9683: AND xbs.code_combination_id IN
9684: (
9685: SELECT xbt.code_combination_id
9686: FROM xla_bal_synchronize_gt xbt
9687: WHERE xbt.chart_of_accounts_id = :1
9688: )
9689: FOR UPDATE OF xbs.ledger_id
9690: '

Line 9735: FROM xla_bal_synchronize_gt xbt

9731: SET xal.control_balance_flag = NULL
9732: WHERE xal.code_combination_id IN
9733: (
9734: SELECT xbt.code_combination_id
9735: FROM xla_bal_synchronize_gt xbt
9736: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9737: )
9738: AND xal.control_balance_flag IS NOT NULL
9739: AND ROWNUM <= C_BATCH_COMMIT_SIZE;

Line 9767: FROM xla_bal_synchronize_gt xbt

9763: FROM xla_control_balances xcb
9764: WHERE xcb.code_combination_id IN
9765: (
9766: SELECT xbt.code_combination_id
9767: FROM xla_bal_synchronize_gt xbt
9768: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9769: )
9770: AND ROWNUM <= C_BATCH_COMMIT_SIZE;
9771:

Line 9797: FROM xla_bal_synchronize_gt xbt

9793: FROM xla_balance_statuses xbs
9794: WHERE xbs.code_combination_id IN
9795: (
9796: SELECT xbt.code_combination_id
9797: FROM xla_bal_synchronize_gt xbt
9798: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9799: )
9800: AND xbs.balance_status_code = 'S'
9801: AND ROWNUM <= C_BATCH_COMMIT_SIZE;

Line 9828: FROM xla_bal_synchronize_gt xbt

9824: WHERE xbs.balance_source_code = 'C'
9825: AND xbs.code_combination_id IN
9826: (
9827: SELECT xbt.code_combination_id
9828: FROM xla_bal_synchronize_gt xbt
9829: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9830: );
9831:
9832: IF l_count_unavailable > 0

Line 9864: FROM xla_bal_synchronize_gt xbt

9860: UPDATE xla_ae_lines xal
9861: SET xal.control_balance_flag = 'P'
9862: WHERE xal.ROWID IN
9863: ( SELECT xal.ROWID
9864: FROM xla_bal_synchronize_gt xbt
9865: ,xla_ae_lines xal
9866: ,xla_ae_headers xah
9867: ,xla_subledgers xsl
9868: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id

Line 9924: FROM xla_bal_synchronize_gt xbt

9920: END IF;
9921:
9922: LOOP
9923: DELETE
9924: FROM xla_bal_synchronize_gt xbt
9925: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9926: AND ROWNUM <= C_BATCH_COMMIT_SIZE;
9927:
9928: l_row_count := SQL%ROWCOUNT;

Line 9933: ,p_msg => l_row_count || ' xla_bal_synchronize_gt deleted'

9929:
9930: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9931: trace
9932: (p_module => l_log_module
9933: ,p_msg => l_row_count || ' xla_bal_synchronize_gt deleted'
9934: ,p_level => C_LEVEL_STATEMENT
9935: );
9936: END IF;
9937: