APPS.IES_PANEL_DATA_PVT SQL Statements

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

Line: 4

  PROCEDURE Insert_Panel_Data
  ( p_api_version       IN  NUMBER   := 1	    ,
    p_init_msg_list	IN  VARCHAR2 := 'DUMMY VAL' ,
    p_commit	    	IN  VARCHAR2 := 'DUMMY VAL' ,
    p_validation_level	IN  NUMBER   := 1           ,
    x_return_status	OUT NOCOPY VARCHAR2         ,
    x_msg_count		OUT NOCOPY NUMBER	    ,
    x_msg_data		OUT NOCOPY VARCHAR2         ,
    p_created_by        IN  NUMBER                  ,
    p_panel_id          IN  NUMBER                  ,
    p_transaction_id    IN  NUMBER                  ,
    p_elapsed_time      IN  NUMBER                  ,
    p_sequence_num      IN  NUMBER                  ,
    p_deleted_status    IN  NUMBER
  ) IS
  BEGIN
    -- Standard Start of API savepoint
    SAVEPOINT	Insert_Panel_Data_PVT;

Line: 22

    INSERT INTO ies_panel_data ( panel_data_id        ,
                                 created_by           ,
                                 creation_date        ,
                                 panel_id             ,
                                 transaction_id       ,
                                 elapsed_time         ,
                                 sequence_number      ,
                                 deleted_status       )
                     VALUES    ( ies_panel_data_s.nextval ,
                                 p_created_by             ,
                                 sysdate                  ,
                                 p_panel_id               ,
                                 p_transaction_id         ,
                                 p_elapsed_time           ,
                                 p_sequence_num           ,
                                 p_deleted_status         );

Line: 40

       ROLLBACK TO Insert_Panel_Data_PVT;

Line: 43

  END Insert_Panel_Data;