APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_SYNCHRONIZE_GT

Line 9329: INTO xla_bal_synchronize_gt

9325: LOOP
9326: EXECUTE IMMEDIATE
9327: '
9328: INSERT
9329: INTO xla_bal_synchronize_gt
9330: ( chart_of_accounts_id
9331: ,code_combination_id
9332: ,reference3
9333: )

Line 9338: ,xla_bal_synchronize_gt xbt

9334: SELECT gcc.chart_of_accounts_id
9335: ,gcc.code_combination_id
9336: ,gcc.reference3
9337: FROM gl_code_combinations gcc
9338: ,xla_bal_synchronize_gt xbt
9339: WHERE gcc.chart_of_accounts_id = :1
9340: AND gcc.' || l_account_segment_column || ' = :2
9341: AND xbt.chart_of_accounts_id (+)= :3
9342: AND xbt.code_combination_id (+)= gcc.code_combination_id

Line 9357: || ' records inserted in xla_bal_synchronize_gt'

9353: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9354: trace
9355: (p_module => l_log_module
9356: ,p_msg => l_row_count
9357: || ' records inserted in xla_bal_synchronize_gt'
9358: ,p_level => C_LEVEL_STATEMENT
9359: );
9360: END IF;
9361:

Line 9375: FROM xla_bal_synchronize_gt xbt

9371: SELECT MIN(reference3)
9372: ,MAX(reference3)
9373: INTO l_min_reference3
9374: ,l_max_reference3
9375: FROM xla_bal_synchronize_gt xbt
9376: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id;
9377:
9378: IF NVL(l_min_reference3,'N') = NVL(l_max_reference3, 'N')
9379: THEN

Line 9438: FROM xla_bal_synchronize_gt xbt

9434: )
9435: AND xbs.code_combination_id IN
9436: (
9437: SELECT xbt.code_combination_id
9438: FROM xla_bal_synchronize_gt xbt
9439: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9440: )
9441: AND xbs.balance_source_code = 'C'
9442: AND xbs.balance_status_code IN ('A', 'S')

Line 9457: FROM xla_bal_synchronize_gt xbt

9453: )
9454: AND xbs.code_combination_id IN
9455: (
9456: SELECT xbt.code_combination_id
9457: FROM xla_bal_synchronize_gt xbt
9458: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9459: )
9460: AND xbs.balance_source_code = 'C'
9461: AND xbs.balance_status_code IN ('A', 'S')

Line 9504: FROM xla_bal_synchronize_gt xbt

9500: AND xbs.balance_source_code = ''C''
9501: AND xbs.code_combination_id IN
9502: (
9503: SELECT xbt.code_combination_id
9504: FROM xla_bal_synchronize_gt xbt
9505: WHERE xbt.chart_of_accounts_id = :1
9506: )
9507: FOR UPDATE OF xbs.ledger_id
9508: '

Line 9553: FROM xla_bal_synchronize_gt xbt

9549: SET xal.control_balance_flag = NULL
9550: WHERE xal.code_combination_id IN
9551: (
9552: SELECT xbt.code_combination_id
9553: FROM xla_bal_synchronize_gt xbt
9554: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9555: )
9556: AND xal.control_balance_flag IS NOT NULL
9557: AND ROWNUM <= C_BATCH_COMMIT_SIZE;

Line 9585: FROM xla_bal_synchronize_gt xbt

9581: FROM xla_control_balances xcb
9582: WHERE xcb.code_combination_id IN
9583: (
9584: SELECT xbt.code_combination_id
9585: FROM xla_bal_synchronize_gt xbt
9586: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9587: )
9588: AND ROWNUM <= C_BATCH_COMMIT_SIZE;
9589:

Line 9615: FROM xla_bal_synchronize_gt xbt

9611: FROM xla_balance_statuses xbs
9612: WHERE xbs.code_combination_id IN
9613: (
9614: SELECT xbt.code_combination_id
9615: FROM xla_bal_synchronize_gt xbt
9616: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9617: )
9618: AND xbs.balance_status_code = 'S'
9619: AND ROWNUM <= C_BATCH_COMMIT_SIZE;

Line 9646: FROM xla_bal_synchronize_gt xbt

9642: WHERE xbs.balance_source_code = 'C'
9643: AND xbs.code_combination_id IN
9644: (
9645: SELECT xbt.code_combination_id
9646: FROM xla_bal_synchronize_gt xbt
9647: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9648: );
9649:
9650: IF l_count_unavailable > 0

Line 9682: FROM xla_bal_synchronize_gt xbt

9678: UPDATE xla_ae_lines xal
9679: SET xal.control_balance_flag = 'P'
9680: WHERE xal.ROWID IN
9681: ( SELECT xal.ROWID
9682: FROM xla_bal_synchronize_gt xbt
9683: ,xla_ae_lines xal
9684: ,xla_ae_headers xah
9685: ,xla_subledgers xsl
9686: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id

Line 9742: FROM xla_bal_synchronize_gt xbt

9738: END IF;
9739:
9740: LOOP
9741: DELETE
9742: FROM xla_bal_synchronize_gt xbt
9743: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9744: AND ROWNUM <= C_BATCH_COMMIT_SIZE;
9745:
9746: l_row_count := SQL%ROWCOUNT;

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

9747:
9748: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9749: trace
9750: (p_module => l_log_module
9751: ,p_msg => l_row_count || ' xla_bal_synchronize_gt deleted'
9752: ,p_level => C_LEVEL_STATEMENT
9753: );
9754: END IF;
9755: