APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on XLA_EVENTS_INT_GT

Line 3230: -- Bug 5512197. Changed the reference of XL_EVENTS_GT to XLA_EVENTS_INT_GT

3226: G_MODULE_NAME || l_procedure_name,
3227: l_log_msg);
3228: END IF;
3229:
3230: -- Bug 5512197. Changed the reference of XL_EVENTS_GT to XLA_EVENTS_INT_GT
3231: SELECT COUNT(*)
3232: INTO l_record_count
3233: FROM XLA_EVENTS_INT_GT XEG
3234: WHERE XEG.application_id = 200

Line 3233: FROM XLA_EVENTS_INT_GT XEG

3229:
3230: -- Bug 5512197. Changed the reference of XL_EVENTS_GT to XLA_EVENTS_INT_GT
3231: SELECT COUNT(*)
3232: INTO l_record_count
3233: FROM XLA_EVENTS_INT_GT XEG
3234: WHERE XEG.application_id = 200
3235: AND XEG.entity_code = PAYMENTS_ENTITY
3236: AND XEG.event_type_code = PAYMENT_CREATED_TYPE;
3237:

Line 3247: UPDATE XLA_EVENTS_INT_GT XEG

3243: G_MODULE_NAME || l_procedure_name,
3244: l_log_msg);
3245: END IF;
3246:
3247: UPDATE XLA_EVENTS_INT_GT XEG
3248: SET event_status_code = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION
3249: WHERE XEG.application_id = 200
3250: AND XEG.source_id_int_1 IN
3251: ( SELECT AC.check_id

Line 3275: l_log_msg := 'XLA_EVENTS_INT_GT TABLE Has no records';

3271: END IF;
3272:
3273: ELSE
3274:
3275: l_log_msg := 'XLA_EVENTS_INT_GT TABLE Has no records';
3276: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3277: FND_LOG.STRING(G_LEVEL_STATEMENT,
3278: G_MODULE_NAME || l_procedure_name,
3279: l_log_msg);

Line 3384: DELETE XLA_EVENTS_INT_GT XEG

3380: G_MODULE_NAME || l_procedure_name,
3381: l_log_msg);
3382: END IF;
3383:
3384: DELETE XLA_EVENTS_INT_GT XEG
3385: WHERE application_id = 200;
3386:
3387: l_log_msg := 'After clean up the xla_event_gt_table';
3388: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 3405: INSERT INTO XLA_EVENTS_INT_GT (

3401: G_MODULE_NAME || l_procedure_name,
3402: l_log_msg);
3403: END IF;
3404:
3405: INSERT INTO XLA_EVENTS_INT_GT (
3406: application_id,
3407: ledger_id,
3408: legal_entity_id,
3409: entity_code,

Line 3439: FROM XLA_EVENTS_INT_GT;

3435: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3436:
3437: SELECT COUNT(*)
3438: INTO l_count
3439: FROM XLA_EVENTS_INT_GT;
3440:
3441: l_log_msg := 'event gt table has record number = '|| l_count;
3442: FND_LOG.STRING(G_LEVEL_STATEMENT,
3443: G_MODULE_NAME || l_procedure_name,

Line 3564: xla_events_int_gt xeg

3560: NULL, -- request_id
3561: ac.org_id, -- org_id
3562: XEG.event_id -- related_event_id
3563: from ap_checks_all ac,
3564: xla_events_int_gt xeg
3565: where ac.completed_pmts_group_id = p_completed_pmts_group_id
3566: and ac.org_id = p_org_id
3567: and xeg.source_id_int_1 = ac.check_id);
3568: