APPS.PA_TIMELINE_TIME_SCALE_PKG SQL Statements

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

Line: 5

PROCEDURE insert_row ( p_timeline_time_scale_tab    IN   PA_TIMELINE_GLOB.TimeScaleTabTyp,
                       x_return_status              OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
                       x_msg_count                  OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
                       x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS
        l_start_date                  PA_PLSQL_DATATYPES.DateTabTyp;

Line: 40

 INSERT INTO PA_TIMELINE_TIME_SCALE
      (
        start_date                 ,
        end_date                   ,
        scale_type                 ,
        scale_row_type             ,
        scale_marker_code          ,
        scale_text                 ,
        creation_date              ,
        created_by                 ,
        last_update_date           ,
        last_updated_by            ,
        last_update_login)
 VALUES
     (
        l_start_date(J)            ,
        l_end_date(J)              ,
        l_scale_type(J)            ,
        l_scale_row_type(J)        ,
        l_scale_marker_code(J)     ,
        l_scale_text(J)            ,
        sysdate                    ,
        fnd_global.user_id         ,
        sysdate                    ,
        fnd_global.user_id         ,
        fnd_global.login_id);

Line: 72

END insert_row;

Line: 75

PROCEDURE delete_row (
                        x_return_status              OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
                        x_msg_count                  OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
                        x_msg_data                   OUT  NOCOPY VARCHAR2  --File.Sql.39 bug 4440895
                      )
IS

BEGIN

DELETE FROM pa_timeline_time_scale;

Line: 91

END delete_row;