APPS.ARP_ACCT_EVENT_PKG dependencies on AR_DETECT_GT

Line 357: INSERT INTO ar_detect_gt(gl_date ,

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

Line 394: INSERT INTO ar_detect_gt(gl_date ,

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

Line 422: INSERT INTO ar_detect_gt(gl_date ,

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

Line 437: INSERT INTO ar_detect_gt(gl_date ,

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

Line 467: INSERT INTO ar_detect_gt(gl_date ,

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

Line 497: FROM ar_detect_gt

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

Line 529: FROM ar_detect_gt a1

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

Line 535: FROM ar_detect_gt a2

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

Line 594: DELETE FROM ar_detect_gt

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