APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on XLA_EVENTS_INT_GT

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

3746: G_MODULE_NAME || l_procedure_name,
3747: l_log_msg);
3748: END IF;
3749:
3750: -- Bug 5512197. Changed the reference of XL_EVENTS_GT to XLA_EVENTS_INT_GT
3751: SELECT COUNT(*)
3752: INTO l_record_count
3753: FROM XLA_EVENTS_INT_GT XEG
3754: WHERE XEG.application_id = 200

Line 3753: FROM XLA_EVENTS_INT_GT XEG

3749:
3750: -- Bug 5512197. Changed the reference of XL_EVENTS_GT to XLA_EVENTS_INT_GT
3751: SELECT COUNT(*)
3752: INTO l_record_count
3753: FROM XLA_EVENTS_INT_GT XEG
3754: WHERE XEG.application_id = 200
3755: AND XEG.entity_code = PAYMENTS_ENTITY
3756: AND XEG.event_type_code = PAYMENT_CREATED_TYPE;
3757:

Line 3767: UPDATE XLA_EVENTS_INT_GT XEG

3763: G_MODULE_NAME || l_procedure_name,
3764: l_log_msg);
3765: END IF;
3766:
3767: UPDATE XLA_EVENTS_INT_GT XEG
3768: SET event_status_code = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION
3769: WHERE XEG.application_id = 200
3770: AND XEG.source_id_int_1 IN
3771: ( SELECT AC.check_id

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

3791: END IF;
3792:
3793: ELSE
3794:
3795: l_log_msg := 'XLA_EVENTS_INT_GT TABLE Has no records';
3796: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3797: FND_LOG.STRING(G_LEVEL_STATEMENT,
3798: G_MODULE_NAME || l_procedure_name,
3799: l_log_msg);

Line 3909: DELETE XLA_EVENTS_INT_GT XEG

3905: G_MODULE_NAME || l_procedure_name,
3906: l_log_msg);
3907: END IF;
3908:
3909: DELETE XLA_EVENTS_INT_GT XEG
3910: WHERE application_id = 200;
3911:
3912: l_log_msg := 'After clean up the xla_event_gt_table';
3913: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 3930: INSERT INTO XLA_EVENTS_INT_GT (

3926: G_MODULE_NAME || l_procedure_name,
3927: l_log_msg);
3928: END IF;
3929:
3930: INSERT INTO XLA_EVENTS_INT_GT (
3931: application_id,
3932: ledger_id,
3933: legal_entity_id,
3934: entity_code,

Line 3974: FROM XLA_EVENTS_INT_GT;

3970: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3971:
3972: SELECT COUNT(*)
3973: INTO l_count
3974: FROM XLA_EVENTS_INT_GT;
3975:
3976: l_log_msg := 'event gt table has record number = '|| l_count;
3977: FND_LOG.STRING(G_LEVEL_STATEMENT,
3978: G_MODULE_NAME || l_procedure_name,

Line 4101: xla_events_int_gt xeg

4097: NULL, -- request_id
4098: ac.org_id, -- org_id
4099: XEG.event_id -- related_event_id
4100: from ap_checks_all ac,
4101: xla_events_int_gt xeg
4102: where ac.completed_pmts_group_id = p_completed_pmts_group_id
4103: and ac.org_id = p_org_id
4104: and xeg.source_id_int_1 = ac.check_id);
4105: