APPS.ARP_MAINTAIN_PS dependencies on XLA_EVENTS

Line 1067: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1063: ) IS
1064: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1065:
1066: l_event_id NUMBER;
1067: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1068: l_security xla_events_pub_pkg.t_security;
1069: l_source_id_int_1 NUMBER;
1070:
1071: CURSOR get_adj_event_id(pc_customer_trx_id IN NUMBER,pc_subsequent_trx_id IN NUMBER) IS

Line 1068: l_security xla_events_pub_pkg.t_security;

1064: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1065:
1066: l_event_id NUMBER;
1067: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1068: l_security xla_events_pub_pkg.t_security;
1069: l_source_id_int_1 NUMBER;
1070:
1071: CURSOR get_adj_event_id(pc_customer_trx_id IN NUMBER,pc_subsequent_trx_id IN NUMBER) IS
1072: SELECT

Line 1081: (Select 'a' from xla_events

1077: adj.customer_trx_id = pc_customer_trx_id
1078: and (adj.subsequent_trx_id = p_subsequent_trx_id OR -1=Nvl(p_subsequent_trx_id,-1) )
1079: and adj.receivables_trx_id = -1
1080: AND exists
1081: (Select 'a' from xla_events
1082: where entity_id in (
1083: Select entity_id from xla_transaction_entities
1084: where entity_code = 'ADJUSTMENTS'
1085: and nvl(source_id_int_1 , -99) = adj.ADJUSTMENT_ID

Line 1129: xla_events_pub_pkg.delete_event

1125: END IF;
1126: l_event_source_info.source_id_int_1 := l_source_id_int_1;
1127: /* first delete xla record and then delete from adjustment*/
1128: if( l_event_id IS NOT null) then
1129: xla_events_pub_pkg.delete_event
1130: ( p_event_source_info => l_event_source_info,
1131: p_event_id => l_event_id,
1132: p_valuation_method => NULL,
1133: p_security_context => l_security