APPS.ARP_ACCT_EVENT_PKG dependencies on AR_DETECT_GT

Line 356: INSERT INTO ar_detect_gt(gl_date ,

352: -- by this statement if REVREC has not run.
353: -- If gl_date is null the transaction is non postable
354: -- there is no need to verify the xla upgrade
355: --
356: INSERT INTO ar_detect_gt(gl_date ,
357: source_int_id ,
358: entity_code ,
359: event_id ,
360: from_application)

Line 393: INSERT INTO ar_detect_gt(gl_date ,

389:
390:
391: ELSIF p_entity_code = 'RECEIPTS' THEN
392:
393: INSERT INTO ar_detect_gt(gl_date ,
394: source_int_id ,
395: entity_code ,
396: event_id ,
397: from_application)

Line 420: INSERT INTO ar_detect_gt(gl_date ,

416:
417:
418: ELSIF p_entity_code = 'ADJUSTMENTS' THEN
419:
420: INSERT INTO ar_detect_gt(gl_date ,
421: source_int_id ,
422: entity_code ,
423: event_id ,
424: from_application)

Line 435: INSERT INTO ar_detect_gt(gl_date ,

431: WHERE adjustment_id = p_source_int_id;
432:
433: ELSIF p_entity_code = 'BILLS_RECEIVABLE' THEN
434:
435: INSERT INTO ar_detect_gt(gl_date ,
436: source_int_id ,
437: entity_code ,
438: event_id ,
439: from_application)

Line 465: INSERT INTO ar_detect_gt(gl_date ,

461: arp_standard.debug('get_xla_event_info +');
462: arp_standard.debug(' p_entity_code :'||p_entity_code);
463: arp_standard.debug(' p_source_int_id :'||p_source_int_id);
464:
465: INSERT INTO ar_detect_gt(gl_date ,
466: source_int_id ,
467: entity_code ,
468: event_id ,
469: from_application)

Line 495: FROM ar_detect_gt

491: x_result OUT NOCOPY VARCHAR2)
492: IS
493: CURSOR c IS
494: SELECT gl_date
495: FROM ar_detect_gt
496: WHERE source_int_id = p_source_int_id
497: AND entity_code = p_entity_code
498: AND from_application = 'AR'
499: AND event_id IS NULL;

Line 527: FROM ar_detect_gt a1

523: x_result OUT NOCOPY VARCHAR2)
524: IS
525: CURSOR c IS
526: SELECT a1.gl_date
527: FROM ar_detect_gt a1
528: WHERE a1.source_int_id = p_source_int_id
529: AND a1.entity_code = p_entity_code
530: AND a1.from_application = 'AR'
531: AND NOT EXISTS

Line 533: FROM ar_detect_gt a2

529: AND a1.entity_code = p_entity_code
530: AND a1.from_application = 'AR'
531: AND NOT EXISTS
532: (SELECT a2.gl_date
533: FROM ar_detect_gt a2
534: WHERE a2.source_int_id = a1.source_int_id
535: AND a2.entity_code = a1.entity_code
536: AND a2.from_application = 'XLA'
537: AND a2.gl_date = a1.gl_date);

Line 592: DELETE FROM ar_detect_gt

588: x_return_status := FND_API.G_RET_STS_ERROR;
589: RAISE fnd_api.G_EXC_ERROR;
590: END IF;
591:
592: DELETE FROM ar_detect_gt
593: WHERE entity_code = p_entity_code
594: AND source_int_id = p_source_int_id;
595:
596: -- 1 Get AR info