APPS.PA_TIME_CHART_PKG SQL Statements

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

Line: 5

PROCEDURE insert_row  (p_time_chart_tab    IN   PA_TIMELINE_GLOB.TimeChartTabTyp,
                       x_return_status              OUT  VARCHAR2,
                       x_msg_count                  OUT  NUMBER,
                       x_msg_data                   OUT  VARCHAR2 )
IS
        l_time_chart_record_type     PA_PLSQL_DATATYPES.Char30TabTyp;

Line: 41

 INSERT INTO PA_TIME_CHART_TEMP
      (
        time_chart_record_type     ,
        assignment_id              ,
        resource_id                ,
        start_date                 ,
        end_date                   ,
        scale_type                 ,
        help_text                  ,
        color_pattern              ,
        creation_date              ,
        created_by                 ,
        last_update_date           ,
        last_updated_by            ,
        last_update_login          )
 VALUES
     (
        l_time_chart_record_type(J),
        l_assignment_id(J)         ,
        l_resource_id(J)           ,
        trunc(l_start_date(J))     ,
        trunc(l_end_date(J))       ,
        l_scale_type(J)            ,
        l_help_text(J)             ,
        l_color_pattern(J)         ,
        sysdate                    ,
        fnd_global.user_id         ,
        sysdate                    ,
        fnd_global.user_id         ,
        fnd_global.login_id        );

Line: 76

END insert_row;

Line: 79

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_time_chart_temp;

Line: 92

END delete_row;