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_RELATIONSHIP_PLANS_PUB SQL Statements

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

Line: 64


      SELECT lookup_code
      FROM   fnd_lookup_values
      WHERE  lookup_type        = X_Lookup_Type
      AND    nls_upper(meaning) = nls_upper(X_Meaning);

Line: 96


   x_pvt_CSC_PLAN_HEADERS_B_REC.LAST_UPDATE_DATE     := P_CSC_PLAN_HEADERS_B_REC.LAST_UPDATE_DATE;

Line: 98


   x_pvt_CSC_PLAN_HEADERS_B_REC.LAST_UPDATED_BY      := P_CSC_PLAN_HEADERS_B_REC.LAST_UPDATED_BY;

Line: 99


   x_pvt_CSC_PLAN_HEADERS_B_REC.LAST_UPDATE_LOGIN    := P_CSC_PLAN_HEADERS_B_REC.LAST_UPDATE_LOGIN;

Line: 139


    P_LAST_UPDATE_DATE           IN   DATE,
    P_CREATED_BY                 IN   NUMBER,
    P_LAST_UPDATED_BY            IN   NUMBER,
    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_PUB_CSC_PLAN_HEADERS_B_REC OUT NOCOPY  CSC_PLAN_HEADERS_B_REC_TYPE )
IS

BEGIN
   x_pub_csc_plan_headers_b_rec.ROW_ID               := p_row_id;

Line: 178


   x_pub_csc_plan_headers_b_rec.LAST_UPDATE_DATE     := p_last_update_date;

Line: 180


   x_pub_csc_plan_headers_b_rec.LAST_UPDATED_BY      := p_last_updated_by;

Line: 181


   x_pub_csc_plan_headers_b_rec.LAST_UPDATE_LOGIN    := p_last_update_login;

Line: 224


    P_LAST_UPDATE_DATE           IN   DATE,
    P_CREATED_BY                 IN   NUMBER,
    P_LAST_UPDATED_BY            IN   NUMBER,
    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 ,
    P_DESCRIPTION                IN   VARCHAR2,
    P_NAME                       IN   VARCHAR2,
    P_PARTY_ID_TBL               IN   CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
    X_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_pub_csc_plan_headers_b_rec   CSC_PLAN_HEADERS_B_REC_TYPE;

Line: 273


      P_LAST_UPDATE_DATE           => p_last_update_date,
      P_CREATED_BY                 => p_created_by,
      P_LAST_UPDATED_BY            => p_last_updated_by,
      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_PUB_CSC_PLAN_HEADERS_B_REC => l_pub_csc_plan_headers_b_rec );

Line: 444


PROCEDURE update_plan_header(
    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_ORIGINAL_PLAN_ID           IN   NUMBER,
    P_PLAN_GROUP_CODE            IN   VARCHAR2,
    P_START_DATE_ACTIVE          IN   DATE,
    P_END_DATE_ACTIVE            IN   DATE,
    P_USE_FOR_CUST_ACCOUNT       IN   VARCHAR2,
    P_END_USER_TYPE              IN   VARCHAR2,
    P_CUSTOMIZED_PLAN            IN   VARCHAR2,
    P_PROFILE_CHECK_ID           IN   NUMBER,
    P_RELATIONAL_OPERATOR        IN   VARCHAR2,
    P_CRITERIA_VALUE_HIGH        IN   VARCHAR2,
    P_CRITERIA_VALUE_LOW         IN   VARCHAR2,
    P_CREATION_DATE              IN   DATE,
    P_LAST_UPDATE_DATE           IN   DATE,
    P_CREATED_BY                 IN   NUMBER,
    P_LAST_UPDATED_BY            IN   NUMBER,
    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 ,
    P_DESCRIPTION                IN   VARCHAR2,
    P_NAME                       IN   VARCHAR2,
    P_PARTY_ID_TBL               IN   CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_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_pub_csc_plan_headers_b_rec   CSC_PLAN_HEADERS_B_REC_TYPE;

Line: 511


      P_LAST_UPDATE_DATE           => p_last_update_date,
      P_CREATED_BY                 => p_created_by,
      P_LAST_UPDATED_BY            => p_last_updated_by,
      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_PUB_CSC_PLAN_HEADERS_B_REC => l_pub_csc_plan_headers_b_rec );

Line: 535


   update_plan_header(
      P_Api_Version_Number         => p_api_version_number,
      P_Init_Msg_List              => p_init_msg_list,
      P_Commit                     => p_commit,
      P_CSC_PLAN_HEADERS_B_REC     => l_pub_csc_plan_headers_b_rec,
      P_DESCRIPTION                => p_description,
      P_NAME                       => p_name,
      P_PARTY_ID_TBL               => p_party_id_tbl,
      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: 548


END update_plan_header;

Line: 551


PROCEDURE update_plan_header(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_CSC_PLAN_HEADERS_B_REC     IN   CSC_PLAN_HEADERS_B_REC_TYPE,
    P_DESCRIPTION                IN   VARCHAR2,
    P_NAME                       IN   VARCHAR2,
    P_PARTY_ID_TBL               IN   CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_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_plan_header';

Line: 574


   SAVEPOINT update_plan_header_pub;

Line: 603


   CSC_relationship_plans_pvt.update_plan_header(
      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_PLAN_HEADERS_B_REC     => l_pvt_CSC_PLAN_HEADERS_B_REC ,
      P_DESCRIPTION                => p_description,
      P_NAME                       => p_name,
	 P_PARTY_ID_TBL                => l_pvt_CSC_PARTY_ID_TBL,
      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: 670


End update_plan_header;