APPS.PA_RES_AVL_PVT SQL Statements

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

Line: 5

PROCEDURE Insert_Row (
          P_RESOURCE_ID            IN     pa_res_availability.resource_id%type
         ,P_START_DATE             IN     pa_res_availability.start_date%type
         ,P_END_DATE               IN     pa_res_availability.end_date%type
         ,P_RECORD_TYPE            IN     pa_res_availability.record_type%type
         ,P_PERCENT                IN     pa_res_availability.percent%type
         ,P_HOURS                  IN     pa_res_availability.hours%type
         ,X_ROW_ID                 OUT    NOCOPY ROWID --File.Sql.39 bug 4440895
         ,X_RETURN_STATUS          OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
BEGIN

    PA_DEBUG.init_err_stack('PA_RES_AVL_PVT.Insert_Row');

Line: 23

    insert into PA_RES_AVAILABILITY (
                RESOURCE_ID
               ,START_DATE
               ,END_DATE
               ,RECORD_TYPE
               ,PERCENT
               ,HOURS
               ,LAST_UPDATE_DATE
               ,LAST_UPDATED_BY
               ,CREATION_DATE
               ,CREATED_BY
               ,LAST_UPDATE_LOGIN )
     values (
                P_RESOURCE_ID
               ,P_START_DATE
               ,P_END_DATE
               ,P_RECORD_TYPE
               ,P_PERCENT
               ,P_HOURS
               ,sysdate
               ,fnd_global.user_id
               ,sysdate
               ,fnd_global.user_id
               ,fnd_global.login_id
     )
     RETURNING rowid INTO X_ROW_ID;

Line: 59

END Insert_Row;

Line: 62

PROCEDURE Update_Row (
          P_RESOURCE_ID         IN     pa_res_availability.resource_id%type
         ,P_START_DATE          IN     pa_res_availability.start_date%type
         ,P_END_DATE            IN     pa_res_availability.end_date%type       := FND_API.G_MISS_DATE
         ,P_RECORD_TYPE         IN     pa_res_availability.record_type%type
         ,P_PERCENT             IN     pa_res_availability.percent%type        := FND_API.G_MISS_NUM
         ,P_HOURS               IN     pa_res_availability.hours%type          := FND_API.G_MISS_NUM
         ,X_RETURN_STATUS       OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
BEGIN

    PA_DEBUG.init_err_stack('PA_RES_AVL_PVT.Update_Row');

Line: 79

    update PA_RES_AVAILABILITY
    set END_DATE               = DECODE(p_end_date, FND_API.G_MISS_DATE, END_DATE, p_end_date)
       ,PERCENT                = DECODE(p_percent, FND_API.G_MISS_NUM, PERCENT, p_percent)
       ,HOURS                  = DECODE(p_hours, FND_API.G_MISS_NUM, HOURS, p_hours)
       ,LAST_UPDATE_DATE       = sysdate
       ,LAST_UPDATED_BY        = fnd_global.user_id
       ,LAST_UPDATE_LOGIN      = fnd_global.login_id
    where
         RESOURCE_ID = p_resource_id
     and START_DATE  = p_start_date
     and RECORD_TYPE = p_record_type;

Line: 100

END Update_Row;

Line: 102

PROCEDURE Delete_Row (
          P_RESOURCE_ID            IN     pa_res_availability.resource_id%type
         ,P_START_DATE             IN     pa_res_availability.start_date%type
         ,P_RECORD_TYPE            IN     pa_res_availability.record_type%type
         ,X_RETURN_STATUS          OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
BEGIN

    PA_DEBUG.init_err_stack('PA_RES_AVL_PVT.Delete_Row');

Line: 116

    delete from PA_RES_AVAILABILITY
    where
         RESOURCE_ID = p_resource_id
     and START_DATE  = p_start_date
     and RECORD_TYPE = p_record_type;

Line: 131

END Delete_Row;