DBA Data[Home] [Help]

APPS.AP_ACCTG_PAY_DIST_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 4167: -- xla distribution links table and XLA depends on these amounts for

4163:
4164:
4165: -- Bug 6839052. Payment Cancellation cannot account for upgraded payments
4166: -- since the amounts are not populated in the pay dists table or in the
4167: -- xla distribution links table and XLA depends on these amounts for
4168: -- creating reversal accounting.
4169: IF p_xla_event_rec.event_type_code IN
4170: ('PAYMENT CANCELLED','REFUND CANCELLED',
4171: 'PAYMENT MATURITY REVERSED', 'PAYMENT UNCLEARED',

Line 4423: l_log_msg := 'Deleting xla_distribution_links';

4419: '.begin', l_log_msg);
4420: END IF;
4421:
4422: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4423: l_log_msg := 'Deleting xla_distribution_links';
4424: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
4425: END IF;
4426:
4427: DELETE FROM xla_distribution_links

Line 4427: DELETE FROM xla_distribution_links

4423: l_log_msg := 'Deleting xla_distribution_links';
4424: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
4425: END IF;
4426:
4427: DELETE FROM xla_distribution_links
4428: WHERE application_id = 200
4429: AND ae_header_id IN
4430: (SELECT ae_header_id
4431: FROM xla_ae_headers aeh,

Line 4442: l_log_msg := 'Inserting xla_distribution_links for event '||

4438: AND upg_batch_id IS NOT NULL;
4439:
4440:
4441: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4442: l_log_msg := 'Inserting xla_distribution_links for event '||
4443: p_accounting_event_id;
4444: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
4445: END IF;
4446:

Line 4448: INSERT INTO XLA_Distribution_Links t1

4444: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
4445: END IF;
4446:
4447:
4448: INSERT INTO XLA_Distribution_Links t1
4449: (APPLICATION_ID,
4450: EVENT_ID,
4451: AE_HEADER_ID,
4452: AE_LINE_NUM,

Line 4776: l_log_msg := 'Done inserting into xla_distribution_links';

4772: WHERE FC.Currency_Code = ADL.Base_Currency_Code);
4773:
4774:
4775: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4776: l_log_msg := 'Done inserting into xla_distribution_links';
4777: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,
4778: l_log_msg);
4779: END IF;
4780: