DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 3117: l_log_msg := 'Deleting xla_distribution_links';

3113: '.begin', l_log_msg);
3114: END IF;
3115:
3116: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3117: l_log_msg := 'Deleting xla_distribution_links';
3118: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
3119: END IF;
3120:
3121: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3129: DELETE FROM xla_distribution_links

3125: ' P_Accounting_Event_ID : '||P_Accounting_Event_ID;
3126: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
3127: END IF;
3128:
3129: DELETE FROM xla_distribution_links
3130: WHERE application_id = 200
3131: AND ae_header_id IN
3132: (SELECT ae_header_id
3133: FROM xla_ae_headers aeh,

Line 3147: l_log_msg := ' Number of XLA distribution LInks Deleted :'||l_rowcount||

3143:
3144: l_rowcount := SQL%ROWCOUNT;
3145:
3146: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3147: l_log_msg := ' Number of XLA distribution LInks Deleted :'||l_rowcount||
3148: ' Now Inserting xla_distribution_links for event '||
3149: p_accounting_event_id;
3150: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
3151: END IF;

Line 3148: ' Now Inserting xla_distribution_links for event '||

3144: l_rowcount := SQL%ROWCOUNT;
3145:
3146: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3147: l_log_msg := ' Number of XLA distribution LInks Deleted :'||l_rowcount||
3148: ' Now Inserting xla_distribution_links for event '||
3149: p_accounting_event_id;
3150: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
3151: END IF;
3152:

Line 3154: INSERT INTO XLA_Distribution_Links t1

3150: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
3151: END IF;
3152:
3153:
3154: INSERT INTO XLA_Distribution_Links t1
3155: (APPLICATION_ID,
3156: EVENT_ID,
3157: AE_HEADER_ID,
3158: AE_LINE_NUM,