DBA Data[Home] [Help]

APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_TRIAL_BALANCES

Line 4054: UPDATE XLA_TRIAL_BALANCES tb

4050: END IF;
4051:
4052:
4053: FORALL i IN 1..p_array_ledger_id.count
4054: UPDATE XLA_TRIAL_BALANCES tb
4055: SET PARTY_ID = p_new_party_id,
4056: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4057: LAST_UPDATE_DATE = sysdate,
4058: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

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

4093: AND pmt.ENTITY_ID = aeh.ENTITY_ID);
4094:
4095: v_row_count :=SQL%ROWCOUNT;
4096: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
4097: trace( p_msg => '# of rows in xla_trial_balances table updated:'||to_char(v_row_count)
4098: , p_level => C_LEVEL_STATEMENT
4099: , p_module => v_module);
4100: END IF;
4101:

Line 4157: UPDATE XLA_TRIAL_BALANCES tb

4153: , p_module => v_module);
4154: END IF;
4155:
4156: FORALL i IN 1..p_array_ledger_id.count
4157: UPDATE XLA_TRIAL_BALANCES tb
4158: SET PARTY_ID = p_new_party_id,
4159: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4160: LAST_UPDATE_DATE = sysdate,
4161: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

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

4191: );
4192:
4193: v_row_count :=SQL%ROWCOUNT;
4194: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
4195: trace( p_msg => '# of rows in xla_trial_balances table updated:'||to_char(v_row_count)
4196: , p_level => C_LEVEL_STATEMENT
4197: , p_module => v_module);
4198: END IF;
4199: