APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_TRIAL_BALANCES

Line 4099: UPDATE XLA_TRIAL_BALANCES tb

4095: END IF;
4096:
4097:
4098: FORALL i IN 1..p_array_ledger_id.count
4099: UPDATE XLA_TRIAL_BALANCES tb
4100: SET PARTY_ID = p_new_party_id,
4101: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4102: LAST_UPDATE_DATE = sysdate,
4103: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

Line 4142: trace( p_msg => '# of rows in xla_trial_balances table updated:'||to_char(v_row_count)

4138: AND pmt.ENTITY_ID = aeh.ENTITY_ID);
4139:
4140: v_row_count :=SQL%ROWCOUNT;
4141: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
4142: trace( p_msg => '# of rows in xla_trial_balances table updated:'||to_char(v_row_count)
4143: , p_level => C_LEVEL_STATEMENT
4144: , p_module => v_module);
4145: END IF;
4146:

Line 4202: UPDATE XLA_TRIAL_BALANCES tb

4198: , p_module => v_module);
4199: END IF;
4200:
4201: FORALL i IN 1..p_array_ledger_id.count
4202: UPDATE XLA_TRIAL_BALANCES tb
4203: SET PARTY_ID = p_new_party_id,
4204: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4205: LAST_UPDATE_DATE = sysdate,
4206: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

Line 4240: trace( p_msg => '# of rows in xla_trial_balances table updated:'||to_char(v_row_count)

4236: );
4237:
4238: v_row_count :=SQL%ROWCOUNT;
4239: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
4240: trace( p_msg => '# of rows in xla_trial_balances table updated:'||to_char(v_row_count)
4241: , p_level => C_LEVEL_STATEMENT
4242: , p_module => v_module);
4243: END IF;
4244: