eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_CUST_PLANS_PUB SQL Statements

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

Line: 74


    x_pvt_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE := P_CSC_CUST_PLANS_Rec.PROGRAM_UPDATE_DATE;

Line: 75


    x_pvt_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE := P_CSC_CUST_PLANS_Rec.LAST_UPDATE_DATE;

Line: 77


    x_pvt_CSC_CUST_PLANS_rec.LAST_UPDATED_BY := P_CSC_CUST_PLANS_Rec.LAST_UPDATED_BY;

Line: 79


    x_pvt_CSC_CUST_PLANS_rec.LAST_UPDATE_LOGIN := P_CSC_CUST_PLANS_Rec.LAST_UPDATE_LOGIN;

Line: 129


       P_PROGRAM_UPDATE_DATE      IN     DATE,
       P_CREATION_DATE            IN     DATE,
       P_LAST_UPDATE_DATE         IN     DATE,
       P_CREATED_BY               IN     NUMBER,
       P_LAST_UPDATED_BY          IN     NUMBER,
       P_USER_NAME                IN     VARCHAR2,
       P_LAST_UPDATE_LOGIN        IN     NUMBER,
       P_ATTRIBUTE1               IN     VARCHAR2,
       P_ATTRIBUTE2               IN     VARCHAR2,
       P_ATTRIBUTE3               IN     VARCHAR2,
       P_ATTRIBUTE4               IN     VARCHAR2,
       P_ATTRIBUTE5               IN     VARCHAR2,
       P_ATTRIBUTE6               IN     VARCHAR2,
       P_ATTRIBUTE7               IN     VARCHAR2,
       P_ATTRIBUTE8               IN     VARCHAR2,
       P_ATTRIBUTE9               IN     VARCHAR2,
       P_ATTRIBUTE10              IN     VARCHAR2,
       P_ATTRIBUTE11              IN     VARCHAR2,
       P_ATTRIBUTE12              IN     VARCHAR2,
       P_ATTRIBUTE13              IN     VARCHAR2,
       P_ATTRIBUTE14              IN     VARCHAR2,
       P_ATTRIBUTE15              IN     VARCHAR2,
       P_ATTRIBUTE_CATEGORY       IN     VARCHAR2,
       P_OBJECT_VERSION_NUMBER    IN     NUMBER,
       X_CSC_CUST_PLANS_REC_TYPE  OUT    NOCOPY CSC_CUST_PLANS_REC_TYPE )
IS
BEGIN
       x_csc_cust_plans_rec_type.ROW_ID := P_ROW_ID ;

Line: 180


       x_csc_cust_plans_rec_type.PROGRAM_UPDATE_DATE := P_PROGRAM_UPDATE_DATE ;

Line: 182


       x_csc_cust_plans_rec_type.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;

Line: 184


       x_csc_cust_plans_rec_type.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;

Line: 186


       x_csc_cust_plans_rec_type.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;

Line: 238


    P_PROGRAM_UPDATE_DATE        IN   DATE,
    P_CREATION_DATE              IN   DATE,
    P_LAST_UPDATE_DATE           IN   DATE,
    P_CREATED_BY                 IN   NUMBER,
    P_LAST_UPDATED_BY            IN   NUMBER,
    P_USER_NAME                  IN   VARCHAR2,
    P_LAST_UPDATE_LOGIN          IN   NUMBER,
    P_ATTRIBUTE1                 IN   VARCHAR2,
    P_ATTRIBUTE2                 IN   VARCHAR2,
    P_ATTRIBUTE3                 IN   VARCHAR2,
    P_ATTRIBUTE4                 IN   VARCHAR2,
    P_ATTRIBUTE5                 IN   VARCHAR2,
    P_ATTRIBUTE6                 IN   VARCHAR2,
    P_ATTRIBUTE7                 IN   VARCHAR2,
    P_ATTRIBUTE8                 IN   VARCHAR2,
    P_ATTRIBUTE9                 IN   VARCHAR2,
    P_ATTRIBUTE10                IN   VARCHAR2,
    P_ATTRIBUTE11                IN   VARCHAR2,
    P_ATTRIBUTE12                IN   VARCHAR2,
    P_ATTRIBUTE13                IN   VARCHAR2,
    P_ATTRIBUTE14                IN   VARCHAR2,
    P_ATTRIBUTE15                IN   VARCHAR2,
    P_ATTRIBUTE_CATEGORY         IN   VARCHAR2,
    P_OBJECT_VERSION_NUMBER      IN   NUMBER,
    X_CUST_PLAN_ID               OUT  NOCOPY NUMBER,
    X_OBJECT_VERSION_NUMBER      OUT  NOCOPY NUMBER,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2
)
IS
    l_csc_cust_plans_rec     CSC_CUST_PLANS_REC_TYPE;

Line: 297


       P_PROGRAM_UPDATE_DATE       => P_PROGRAM_UPDATE_DATE ,
       P_CREATION_DATE             => P_CREATION_DATE ,
       P_LAST_UPDATE_DATE          => P_LAST_UPDATE_DATE ,
       P_CREATED_BY                => P_CREATED_BY ,
       P_LAST_UPDATED_BY           => P_LAST_UPDATED_BY ,
       P_USER_NAME                 => P_USER_NAME ,
       P_LAST_UPDATE_LOGIN         => P_LAST_UPDATE_LOGIN ,
       P_ATTRIBUTE1                => P_ATTRIBUTE1 ,
       P_ATTRIBUTE2                => P_ATTRIBUTE2 ,
       P_ATTRIBUTE3                => P_ATTRIBUTE3 ,
       P_ATTRIBUTE4                => P_ATTRIBUTE4 ,
       P_ATTRIBUTE5                => P_ATTRIBUTE5 ,
       P_ATTRIBUTE6                => P_ATTRIBUTE6 ,
       P_ATTRIBUTE7                => P_ATTRIBUTE7 ,
       P_ATTRIBUTE8                => P_ATTRIBUTE8 ,
       P_ATTRIBUTE9                => P_ATTRIBUTE9 ,
       P_ATTRIBUTE10               => P_ATTRIBUTE10 ,
       P_ATTRIBUTE11               => P_ATTRIBUTE11 ,
       P_ATTRIBUTE12               => P_ATTRIBUTE12 ,
       P_ATTRIBUTE13               => P_ATTRIBUTE13 ,
       P_ATTRIBUTE14               => P_ATTRIBUTE14 ,
       P_ATTRIBUTE15               => P_ATTRIBUTE15 ,
       P_ATTRIBUTE_CATEGORY        => P_ATTRIBUTE_CATEGORY ,
       P_OBJECT_VERSION_NUMBER     => P_OBJECT_VERSION_NUMBER ,
       X_CSC_CUST_PLANS_REC_TYPE   => l_csc_cust_plans_rec );

Line: 455


PROCEDURE Update_cust_plans(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_ROW_ID                     IN   ROWID,
    P_PLAN_ID                    IN   NUMBER,
    P_CUST_PLAN_ID               IN   NUMBER,
    P_PARTY_ID                   IN   NUMBER,
    P_CUST_ACCOUNT_ID            IN   NUMBER,
    P_PLAN_NAME                  IN   VARCHAR2,
    P_GROUP_NAME                 IN   VARCHAR2,
    P_PARTY_NUMBER               IN   VARCHAR2,
    P_PARTY_NAME                 IN   VARCHAR2,
    P_PARTY_TYPE                 IN   VARCHAR2,
    P_ACCOUNT_NUMBER             IN   VARCHAR2,
    P_ACCOUNT_NAME               IN   VARCHAR2,
    P_START_DATE_ACTIVE          IN   DATE,
    P_END_DATE_ACTIVE            IN   DATE,
    P_CUSTOMIZED_PLAN            IN   VARCHAR2,
    P_USE_FOR_CUST_ACCOUNT       IN   VARCHAR2,
    P_PLAN_STATUS_CODE           IN   VARCHAR2,
    P_PLAN_STATUS_MEANING        IN   VARCHAR2,
    P_MANUAL_FLAG                IN   VARCHAR2,
    P_REQUEST_ID                 IN   NUMBER,
    P_PROGRAM_APPLICATION_ID     IN   NUMBER,
    P_PROGRAM_ID                 IN   NUMBER,
    P_PROGRAM_UPDATE_DATE        IN   DATE,
    P_CREATION_DATE              IN   DATE,
    P_LAST_UPDATE_DATE           IN   DATE,
    P_CREATED_BY                 IN   NUMBER,
    P_LAST_UPDATED_BY            IN   NUMBER,
    P_USER_NAME                  IN   VARCHAR2,
    P_LAST_UPDATE_LOGIN          IN   NUMBER,
    P_ATTRIBUTE1                 IN   VARCHAR2,
    P_ATTRIBUTE2                 IN   VARCHAR2,
    P_ATTRIBUTE3                 IN   VARCHAR2,
    P_ATTRIBUTE4                 IN   VARCHAR2,
    P_ATTRIBUTE5                 IN   VARCHAR2,
    P_ATTRIBUTE6                 IN   VARCHAR2,
    P_ATTRIBUTE7                 IN   VARCHAR2,
    P_ATTRIBUTE8                 IN   VARCHAR2,
    P_ATTRIBUTE9                 IN   VARCHAR2,
    P_ATTRIBUTE10                IN   VARCHAR2,
    P_ATTRIBUTE11                IN   VARCHAR2,
    P_ATTRIBUTE12                IN   VARCHAR2,
    P_ATTRIBUTE13                IN   VARCHAR2,
    P_ATTRIBUTE14                IN   VARCHAR2,
    P_ATTRIBUTE15                IN   VARCHAR2,
    P_ATTRIBUTE_CATEGORY         IN   VARCHAR2,
    P_OBJECT_VERSION_NUMBER      IN   NUMBER,
    X_OBJECT_VERSION_NUMBER      OUT  NOCOPY NUMBER,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2
)
IS
   l_csc_cust_plans_rec      CSC_CUST_PLANS_REC_TYPE;

Line: 539


       P_PROGRAM_UPDATE_DATE       => P_PROGRAM_UPDATE_DATE ,
       P_CREATION_DATE             => P_CREATION_DATE ,
       P_LAST_UPDATE_DATE          => P_LAST_UPDATE_DATE ,
       P_CREATED_BY                => P_CREATED_BY ,
       P_LAST_UPDATED_BY           => P_LAST_UPDATED_BY ,
       P_USER_NAME                 => P_USER_NAME ,
       P_LAST_UPDATE_LOGIN         => P_LAST_UPDATE_LOGIN ,
       P_ATTRIBUTE1                => P_ATTRIBUTE1 ,
       P_ATTRIBUTE2                => P_ATTRIBUTE2 ,
       P_ATTRIBUTE3                => P_ATTRIBUTE3 ,
       P_ATTRIBUTE4                => P_ATTRIBUTE4 ,
       P_ATTRIBUTE5                => P_ATTRIBUTE5 ,
       P_ATTRIBUTE6                => P_ATTRIBUTE6 ,
       P_ATTRIBUTE7                => P_ATTRIBUTE7 ,
       P_ATTRIBUTE8                => P_ATTRIBUTE8 ,
       P_ATTRIBUTE9                => P_ATTRIBUTE9 ,
       P_ATTRIBUTE10               => P_ATTRIBUTE10 ,
       P_ATTRIBUTE11               => P_ATTRIBUTE11 ,
       P_ATTRIBUTE12               => P_ATTRIBUTE12 ,
       P_ATTRIBUTE13               => P_ATTRIBUTE13 ,
       P_ATTRIBUTE14               => P_ATTRIBUTE14 ,
       P_ATTRIBUTE15               => P_ATTRIBUTE15 ,
       P_ATTRIBUTE_CATEGORY        => P_ATTRIBUTE_CATEGORY ,
       P_OBJECT_VERSION_NUMBER     => P_OBJECT_VERSION_NUMBER ,
       X_CSC_CUST_PLANS_REC_TYPE   => l_csc_cust_plans_rec );

Line: 566


   Update_cust_plans(
       P_Api_Version_Number         => p_api_version_number,
       P_Init_Msg_List              => p_init_msg_list,
       P_Commit                     => p_commit,
       P_CSC_CUST_PLANS_Rec         => l_csc_cust_plans_rec,
       X_OBJECT_VERSION_NUMBER      => x_object_version_number,
       X_Return_Status              => x_return_status,
       X_Msg_Count                  => x_msg_count,
       X_Msg_Data                   => x_msg_data);

Line: 576


END  UPDATE_CUST_PLANS;   -- end of overloaded procedure;

Line: 580


PROCEDURE Update_cust_plans(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_CSC_CUST_PLANS_Rec         IN   CSC_CUST_PLANS_Rec_Type,
    X_OBJECT_VERSION_NUMBER      OUT  NOCOPY NUMBER,
    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_cust_plans';

Line: 596


      SAVEPOINT UPDATE_CUST_PLANS_PUB;

Line: 622


    CSC_cust_plans_PVT.Update_cust_plans(
       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_CSC_CUST_PLANS_Rec         => l_pvt_CSC_CUST_PLANS_Rec ,
       X_OBJECT_VERSION_NUMBER      => x_object_version_number,
       X_Return_Status              => x_return_status,
       X_Msg_Count                  => x_msg_count,
       X_Msg_Data                   => x_msg_data);

Line: 685


End Update_cust_plans;

Line: 733


      csc_cust_plans_pvt.update_cust_plans(
         P_Api_Version_Number         =>  p_api_version_number,
         P_Init_Msg_List              =>  p_init_msg_list,
         P_Commit                     =>  p_commit,
	    p_validation_level           =>  FND_API.G_VALID_LEVEL_NONE,
         P_CSC_CUST_PLANS_Rec         =>  l_csc_cust_plans_rec,
         X_OBJECT_VERSION_NUMBER      =>  x_object_version_number,
         X_Return_Status              =>  x_return_status,
         X_Msg_Count                  =>  x_msg_count,
         X_Msg_Data                   =>  x_msg_data );

Line: 803


      csc_cust_plans_pvt.update_cust_plans(
         P_Api_Version_Number         =>  p_api_version_number,
         P_Init_Msg_List              =>  p_init_msg_list,
         P_Commit                     =>  p_commit,
	    p_validation_level           =>  FND_API.G_VALID_LEVEL_NONE,
         P_CSC_CUST_PLANS_Rec         =>  l_csc_cust_plans_rec,
         X_OBJECT_VERSION_NUMBER      =>  x_object_version_number,
         X_Return_Status              =>  x_return_status,
         X_Msg_Count                  =>  x_msg_count,
         X_Msg_Data                   =>  x_msg_data );

Line: 831


PROCEDURE Delete_cust_plans(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_CUST_PLAN_ID               IN   NUMBER,
    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_cust_plans';

Line: 846


      SAVEPOINT DELETE_CUST_PLANS_PUB;

Line: 866


      CSC_CUST_PLANS_PKG.Delete_Row(
                       P_CUST_PLAN_ID       => P_CUST_PLAN_ID);

Line: 914


End Delete_cust_plans;