DBA Data[Home] [Help]

APPS.FV_SLA_AR_PROCESSING_PKG dependencies on XLA_EVENTS_GT

Line 665: FROM xla_events_gt

661: END IF;
662:
663: l_index:=0;
664: FOR event_rec IN (SELECT *
665: FROM xla_events_gt
666: WHERE application_id = p_application_id) LOOP
667: fv_sla_utl_processing_pkg.get_ledger_info
668: (
669: p_ledger_id => event_rec.ledger_id,

Line 803: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');

799: -- Update process status code to E
800: IF (event_rec.event_id is not null) THEN
801:
802: BEGIN
803: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
804: update xla_events_gt
805: set PROCESS_STATUS_CODE='E'
806: where event_id=event_rec.event_id
807: and application_id=p_application_id;

Line 804: update xla_events_gt

800: IF (event_rec.event_id is not null) THEN
801:
802: BEGIN
803: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
804: update xla_events_gt
805: set PROCESS_STATUS_CODE='E'
806: where event_id=event_rec.event_id
807: and application_id=p_application_id;
808: EXCEPTION

Line 916: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');

912: -- Update process status code to E
913: IF (event_rec.event_id is not null) THEN
914:
915: BEGIN
916: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
917: update xla_events_gt
918: set PROCESS_STATUS_CODE='E'
919: where event_id=event_rec.event_id
920: and application_id=p_application_id;

Line 917: update xla_events_gt

913: IF (event_rec.event_id is not null) THEN
914:
915: BEGIN
916: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
917: update xla_events_gt
918: set PROCESS_STATUS_CODE='E'
919: where event_id=event_rec.event_id
920: and application_id=p_application_id;
921: EXCEPTION

Line 1023: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');

1019: -- Update process status code to E
1020: IF (event_rec.event_id is not null) THEN
1021:
1022: BEGIN
1023: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
1024: update xla_events_gt
1025: set PROCESS_STATUS_CODE='E'
1026: where event_id=event_rec.event_id
1027: and application_id=p_application_id;

Line 1024: update xla_events_gt

1020: IF (event_rec.event_id is not null) THEN
1021:
1022: BEGIN
1023: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
1024: update xla_events_gt
1025: set PROCESS_STATUS_CODE='E'
1026: where event_id=event_rec.event_id
1027: and application_id=p_application_id;
1028: EXCEPTION