APPS.CSC_PROF_COLOR_CODE_PUB SQL Statements

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

Line: 38

    x_pvt_prof_color_rec.LAST_UPDATE_DATE := P_prof_color_rec.LAST_UPDATE_DATE;

Line: 39

    x_pvt_prof_color_rec.LAST_UPDATED_BY := P_prof_color_rec.LAST_UPDATED_BY;

Line: 42

    x_pvt_prof_color_rec.LAST_UPDATE_LOGIN := P_prof_color_rec.LAST_UPDATE_LOGIN;

Line: 54

       p_LAST_UPDATE_DATE                DATE,
       p_LAST_UPDATED_BY                 NUMBER,
       p_CREATION_DATE                   DATE,
       p_CREATED_BY                      NUMBER,
       p_LAST_UPDATE_LOGIN               NUMBER,
       x_prof_color_rec     OUT NOCOPY    prof_color_Rec_Type
    )
  IS
BEGIN

    x_prof_color_rec.COLOR_CODE := p_COLOR_CODE;

Line: 68

    x_prof_color_rec.last_updated_by := p_last_updated_by;

Line: 69

    x_prof_color_rec.last_update_date := p_last_update_date;

Line: 70

    x_prof_color_rec.last_update_login := p_last_update_login;

Line: 80

    p_LAST_UPDATE_DATE                DATE,
    p_LAST_UPDATED_BY                 NUMBER,
    p_CREATION_DATE                   DATE,
    p_CREATED_BY                      NUMBER,
    p_LAST_UPDATE_LOGIN               NUMBER,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
l_prof_color_rec prof_color_Rec_Type;

Line: 95

    p_LAST_UPDATE_DATE =>p_LAST_UPDATE_DATE ,
    P_LAST_UPDATED_BY=>p_LAST_UPDATED_BY  ,
    p_CREATION_DATE=>p_CREATION_DATE    ,
    p_CREATED_BY=>p_CREATED_BY       ,
    p_LAST_UPDATE_LOGIN=>p_LAST_UPDATE_LOGIN ,
    x_prof_color_rec=>l_prof_color_rec );

Line: 228

PROCEDURE Update_prof_color_code(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_COLOR_CODE                      VARCHAR2,
    p_RATING_CODE                     VARCHAR2,
    p_LAST_UPDATE_DATE                DATE,
    p_LAST_UPDATED_BY                 NUMBER,
    p_CREATION_DATE                   DATE,
    p_CREATED_BY                      NUMBER,
    p_LAST_UPDATE_LOGIN               NUMBER,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

IS
 l_prof_color_rec prof_color_Rec_Type;

Line: 251

       p_LAST_UPDATE_DATE ,
       p_LAST_UPDATED_BY  ,
       p_CREATION_DATE    ,
       p_CREATED_BY       ,
       p_LAST_UPDATE_LOGIN ,
       l_prof_color_rec );

Line: 258

 Update_prof_color_code(
    P_Api_Version_Number    => P_Api_Version_Number,
    P_Init_Msg_List         => P_Init_Msg_List,
    P_Commit                => P_Commit,
    P_prof_color_rec   => l_prof_color_rec,
    X_Return_Status           => X_Return_Status,
    X_Msg_Count               => X_Msg_Count,
    X_Msg_Data                => X_Msg_Data   );

Line: 268

END Update_prof_color_code;

Line: 271

PROCEDURE Update_prof_color_code(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_prof_color_rec     IN    prof_color_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Update_prof_color_code';

Line: 287

      SAVEPOINT UPDATE_PROF_COLOR_CODE_PUB;

Line: 320

    CSC_prof_color_code_PVT.Update_prof_color_code(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
    P_prof_color_rec  =>  l_pvt_prof_color_rec ,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 359

		 ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;

Line: 365

		 ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;

Line: 371

		 ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;

Line: 382

End Update_prof_color_code;