APPS.ARP_APP_PKG dependencies on XLA_EVENTS

Line 873: l_event_id xla_events.event_id%TYPE;

869: +===========================================================================*/
870: PROCEDURE lock_p(
871: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
872: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
873: l_event_id xla_events.event_id%TYPE;
874: BEGIN
875: IF PG_DEBUG in ('Y', 'C') THEN
876: arp_standard.debug( 'arp_app_pkg.lock_p()+');
877: END IF;

Line 884: FROM xla_events ev

880:
881: BEGIN
882:
883: SELECT ev.event_id INTO l_event_id
884: FROM xla_events ev
885: WHERE ev.event_id IN (
886: SELECT ra.event_id FROM ar_receivable_applications ra
887: WHERE ra.receivable_application_id = p_ra_id)
888: FOR UPDATE OF ev.event_id NOWAIT;

Line 940: l_event_id xla_events.event_id%TYPE;

936: +===========================================================================*/
937: PROCEDURE nowaitlock_p(
938: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
939: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
940: l_event_id xla_events.event_id%TYPE;
941: BEGIN
942: IF PG_DEBUG in ('Y', 'C') THEN
943: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()+');
944: END IF;

Line 951: FROM xla_events ev

947:
948: BEGIN
949:
950: SELECT ev.event_id INTO l_event_id
951: FROM xla_events ev
952: WHERE ev.event_id IN (
953: SELECT ra.event_id FROM ar_receivable_applications ra
954: WHERE ra.receivable_application_id = p_ra_id)
955: FOR UPDATE OF ev.event_id NOWAIT;