The following lines contain the word 'select', 'insert', 'update' or 'delete':
P_LAST_UPDATED_BY IN NUMBER,
P_LAST_UPDATE_DATE IN DATE,
P_LAST_UPDATE_LOGIN IN NUMBER,
X_GROUP_CHK_Rec OUT NOCOPY GROUP_CHK_Rec_Type
)
IS
BEGIN
X_GROUP_CHK_Rec.GROUP_ID := P_GROUP_ID;
X_GROUP_CHK_Rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY;
X_GROUP_CHK_Rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE;
X_GROUP_CHK_Rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN;
X_PVT_GROUP_CHK_Rec.LAST_UPDATED_BY := P_GROUP_CHK_Rec.LAST_UPDATED_BY;
X_PVT_GROUP_CHK_Rec.LAST_UPDATE_DATE := P_GROUP_CHK_Rec.LAST_UPDATE_DATE;
X_PVT_GROUP_CHK_Rec.LAST_UPDATE_LOGIN := P_GROUP_CHK_Rec.LAST_UPDATE_LOGIN;
P_LAST_UPDATED_BY IN NUMBER,
P_LAST_UPDATE_DATE IN DATE,
P_LAST_UPDATE_LOGIN IN NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_group_Chk_Rec Group_chk_Rec_Type;
P_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
X_GROUP_CHK_Rec => l_GROUP_CHK_Rec
);
PROCEDURE Update_group_checks(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
p_validation_level IN NUMBER,
P_GROUP_ID IN NUMBER,
P_CHECK_ID IN NUMBER,
P_CHECK_SEQUENCE IN NUMBER,
P_END_DATE_ACTIVE IN DATE,
P_START_DATE_ACTIVE IN DATE,
P_CATEGORY_CODE IN VARCHAR2,
P_CATEGORY_SEQUENCE IN NUMBER,
P_THRESHOLD_FLAG IN VARCHAR2,
P_SEEDED_FLAG IN VARCHAR2,
P_CREATED_BY IN NUMBER,
P_CREATION_DATE IN DATE,
P_LAST_UPDATED_BY IN NUMBER,
P_LAST_UPDATE_DATE IN DATE,
P_LAST_UPDATE_LOGIN IN NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_GROUP_CHK_rec GROUP_CHK_Rec_Type;
P_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
X_GROUP_CHK_Rec => l_GROUP_CHK_Rec
);
Update_group_checks(
P_Api_Version_Number => P_Api_Version_Number,
P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
P_GROUP_CHK_Rec => l_Group_Chk_Rec,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
END Update_group_checks;
PROCEDURE Update_group_checks(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
P_GROUP_CHK_Rec IN GROUP_CHK_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_group_checks';
SAVEPOINT UPDATE_GROUP_CHECKS_PUB;
CSC_group_checks_PVT.Update_group_checks(
P_Api_Version_Number => 1.0,
P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
P_Commit => p_commit,
P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
P_GROUP_CHK_Rec => l_pvt_GROUP_CHK_Rec ,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
ROLLBACK TO Update_group_checks_PUB;
ROLLBACK TO Update_group_checks_PUB;
ROLLBACK TO Update_group_checks_PUB;
End Update_group_checks;
PROCEDURE Delete_group_checks(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
P_GROUP_ID IN NUMBER,
P_CHECK_ID IN NUMBER,
P_CHECK_SEQUENCE 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_group_checks';
SAVEPOINT DELETE_GROUP_CHECKS_PUB;
CSC_group_checks_PVT.Delete_group_checks(
P_Api_Version_Number => 1.0,
P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
P_Commit => p_commit,
P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
P_GROUP_ID => P_GROUP_ID,
P_CHECK_ID => P_CHECK_ID,
P_CHECK_SEQUENCE => P_CHECK_SEQUENCE,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
ROLLBACK TO Delete_group_checks_PUB;
ROLLBACK TO Delete_group_checks_PUB;
ROLLBACK TO Delete_group_checks_PUB;
End Delete_group_checks;