The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_pvt_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE := P_CSC_CUST_PLANS_Rec.PROGRAM_UPDATE_DATE;
x_pvt_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE := P_CSC_CUST_PLANS_Rec.LAST_UPDATE_DATE;
x_pvt_CSC_CUST_PLANS_rec.LAST_UPDATED_BY := P_CSC_CUST_PLANS_Rec.LAST_UPDATED_BY;
x_pvt_CSC_CUST_PLANS_rec.LAST_UPDATE_LOGIN := P_CSC_CUST_PLANS_Rec.LAST_UPDATE_LOGIN;
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 ;
x_csc_cust_plans_rec_type.PROGRAM_UPDATE_DATE := P_PROGRAM_UPDATE_DATE ;
x_csc_cust_plans_rec_type.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
x_csc_cust_plans_rec_type.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
x_csc_cust_plans_rec_type.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
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;
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 );
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;
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 );
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);
END UPDATE_CUST_PLANS; -- end of overloaded procedure;
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';
SAVEPOINT UPDATE_CUST_PLANS_PUB;
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);
End Update_cust_plans;
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 );
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 );
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';
SAVEPOINT DELETE_CUST_PLANS_PUB;
CSC_CUST_PLANS_PKG.Delete_Row(
P_CUST_PLAN_ID => P_CUST_PLAN_ID);
End Delete_cust_plans;