APPS.CSP_RS_CUST_RELATION_PUB SQL Statements

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

Line: 96

    x_pvt_RCR_rec.LAST_UPDATED_BY := P_RCR_Rec.LAST_UPDATED_BY;

Line: 97

    x_pvt_RCR_rec.LAST_UPDATE_DATE := P_RCR_Rec.LAST_UPDATE_DATE;

Line: 98

    x_pvt_RCR_rec.LAST_UPDATE_LOGIN := P_RCR_Rec.LAST_UPDATE_LOGIN;

Line: 266

PROCEDURE Update_rs_cust_relation(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    P_Identity_Salesforce_Id     IN   NUMBER       := NULL,
    P_RCR_Rec     IN    RCR_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_rs_cust_relation';

Line: 283

      SAVEPOINT UPDATE_RS_CUST_RELATION_PUB;

Line: 324

    CSP_rs_cust_relation_PVT.Update_rs_cust_relation(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
    P_Identity_Salesforce_Id     => p_identity_salesforce_id,
    P_RCR_Rec  =>  l_pvt_RCR_Rec ,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 398

End Update_rs_cust_relation;

Line: 403

PROCEDURE Delete_rs_cust_relation(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    P_identity_salesforce_id     IN   NUMBER       := NULL,
    P_RCR_Rec     IN RCR_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) := 'Delete_rs_cust_relation';

Line: 420

      SAVEPOINT DELETE_RS_CUST_RELATION_PUB;

Line: 461

    CSP_rs_cust_relation_PVT.Delete_rs_cust_relation(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
    P_Identity_Salesforce_Id      => p_identity_salesforce_id,
    P_RCR_Rec  => l_pvt_RCR_Rec,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 535

End Delete_rs_cust_relation;