277: END LOOP;
278:
279: l_progress := 500;
280:
281: -- delete from ZX_ITM_DISTRIBUTIONS_GT;
282: DELETE ZX_ITM_DISTRIBUTIONS_GT;
283:
284: l_progress := 600;
285:
278:
279: l_progress := 500;
280:
281: -- delete from ZX_ITM_DISTRIBUTIONS_GT;
282: DELETE ZX_ITM_DISTRIBUTIONS_GT;
283:
284: l_progress := 600;
285:
286: -- Logging Infra: Statement level
284: l_progress := 600;
285:
286: -- Logging Infra: Statement level
287: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
288: l_log_msg := 'Deleted ZX_ITM_DISTRIBUTIONS_GT';
289: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
290: END IF;
291:
292: -- insert into ZX Distributions global temp table
293: i := 1;
294: tbl_sz_dist := p_tax_dist_tbl.count();
295:
296: LOOP
297: INSERT INTO ZX_ITM_DISTRIBUTIONS_GT (application_id,
298: entity_code,
299: event_class_code,
300: trx_id,
301: trx_line_id,
342: p_tax_dist_tbl(i).recovery_rate_override);
343:
344: -- Logging Infra: Statement level
345: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
346: l_log_msg := 'Inserted record into ZX_ITM_DISTRIBUTIONS_GT. DistId=' || p_tax_dist_tbl(i).trx_line_dist_id;
347: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
348: END IF;
349:
350: i := i + 1;