DBA Data[Home] [Help]

APPS.CSI_BUSINESS_EVENT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 57

PROCEDURE update_instance_event
   (p_api_version               IN     NUMBER
    ,p_commit                   IN     VARCHAR2
    ,p_init_msg_list            IN     VARCHAR2
    ,p_validation_level         IN     NUMBER
    ,p_instance_id              IN     NUMBER
    ,p_subject_instance_id      IN     NUMBER
    ,x_return_status            OUT    NOCOPY VARCHAR2
    ,x_msg_count                OUT    NOCOPY NUMBER
    ,x_msg_data                 OUT    NOCOPY VARCHAR2
    ) IS

  l_key          VARCHAR2(240);
Line: 70

  l_event_name   VARCHAR2(240) := 'oracle.apps.csi.instance.update';
Line: 73

  SAVEPOINT update_item_instance_event;
Line: 75

  csi_gen_utility_pvt.put_line('Inside API CSI_BUSINESS_EVENT_PVT.update_instance_event');
Line: 95

        ,p_correlation_value   => 'oracle.apps.csi.instance.update');
Line: 99

      ROLLBACK TO update_item_instance_event;
Line: 101

      FND_MESSAGE.SET_NAME('CSI','CSI_UPDATE_EVENT_ERROR');
Line: 108

END update_instance_event;