The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_pvt_chk_rules_rec.LAST_UPDATED_BY := P_chk_rules_rec.LAST_UPDATED_BY;
x_pvt_chk_rules_rec.LAST_UPDATE_DATE := P_chk_rules_rec.LAST_UPDATE_DATE;
x_pvt_chk_rules_rec.LAST_UPDATE_LOGIN := P_chk_rules_rec.LAST_UPDATE_LOGIN;
P_LAST_UPDATED_BY IN NUMBER,
P_LAST_UPDATE_DATE IN DATE,
P_LAST_UPDATE_LOGIN IN NUMBER,
P_LOGICAL_OPERATOR IN VARCHAR2,
P_LEFT_PAREN IN VARCHAR2,
P_COMPARISON_OPERATOR IN VARCHAR2,
P_EXPRESSION IN VARCHAR2,
P_EXPR_TO_BLOCK_ID IN NUMBER,
P_RIGHT_PAREN IN VARCHAR2,
P_SEEDED_FLAG IN VARCHAR2,
X_CHK_RULES_Rec OUT NOCOPY CHK_RULES_Rec_Type
)
IS
BEGIN
X_CHK_RULES_rec.CHECK_ID := P_CHECK_ID;
X_CHK_RULES_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY;
X_CHK_RULES_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE;
X_CHK_RULES_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN;
P_LAST_UPDATED_BY IN NUMBER,
P_LAST_UPDATE_DATE IN DATE,
P_LAST_UPDATE_LOGIN IN NUMBER,
P_LOGICAL_OPERATOR IN VARCHAR2,
P_LEFT_PAREN IN VARCHAR2,
P_COMPARISON_OPERATOR IN VARCHAR2,
P_EXPRESSION IN VARCHAR2,
P_EXPR_TO_BLOCK_ID IN NUMBER,
P_RIGHT_PAREN IN VARCHAR2,
P_SEEDED_FLAG IN VARCHAR2,
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_CHK_RULES_Rec CHK_RULES_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,
P_LOGICAL_OPERATOR => P_LOGICAL_OPERATOR,
P_LEFT_PAREN => P_LEFT_PAREN,
P_COMPARISON_OPERATOR => P_COMPARISON_OPERATOR,
P_EXPRESSION => P_EXPRESSION,
P_EXPR_TO_BLOCK_ID => P_EXPR_TO_BLOCK_ID,
P_RIGHT_PAREN => P_RIGHT_PAREN,
P_SEEDED_FLAG => P_SEEDED_FLAG,
X_CHK_RULES_Rec => l_CHK_RULES_Rec
);
PROCEDURE Update_profile_check_rules(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
P_CHECK_ID IN NUMBER,
P_BLOCK_ID IN NUMBER,
P_SEQUENCE IN NUMBER,
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,
P_LOGICAL_OPERATOR IN VARCHAR2,
P_LEFT_PAREN IN VARCHAR2,
P_COMPARISON_OPERATOR IN VARCHAR2,
P_EXPRESSION IN VARCHAR2,
P_EXPR_TO_BLOCK_ID IN NUMBER,
P_RIGHT_PAREN IN VARCHAR2,
P_SEEDED_FLAG IN VARCHAR2,
PX_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_CHK_RULES_Rec CHK_RULES_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,
P_LOGICAL_OPERATOR => P_LOGICAL_OPERATOR,
P_LEFT_PAREN => P_LEFT_PAREN,
P_COMPARISON_OPERATOR => P_COMPARISON_OPERATOR,
P_EXPRESSION => P_EXPRESSION,
P_EXPR_TO_BLOCK_ID => P_EXPR_TO_BLOCK_ID,
P_RIGHT_PAREN => P_RIGHT_PAREN,
P_SEEDED_FLAG => P_SEEDED_FLAG,
X_CHK_RULES_Rec => l_CHK_RULES_Rec
);
Update_profile_check_rules(
P_Api_Version_Number => P_Api_Version_Number ,
P_Init_Msg_List => P_Init_Msg_List,
P_Commit => P_Commit,
P_CHK_RULES_Rec => l_CHK_RULES_Rec,
PX_Object_Version_Number => PX_OBJECT_VERSION_NUMBER,
X_Return_Status => X_Return_Status,
X_Msg_Count => X_Msg_Count,
X_Msg_Data => X_Msg_Data
);
END Update_profile_check_rules;
PROCEDURE Update_profile_check_rules(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
P_CHK_RULES_Rec IN CHK_RULES_Rec_Type,
px_OBJECT_VERSION_NUMBER IN 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_profile_check_rules';
SAVEPOINT UPDATE_PROFILE_CHECK_RULES_PUB;
CSC_profile_check_rules_PVT.Update_profile_check_rules(
P_Api_Version_Number => P_Api_Version_Number ,
P_Init_Msg_List => P_Init_Msg_List,
P_Commit => P_Commit,
p_validation_level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
P_CHK_RULES_Rec => l_PVT_CHK_RULES_Rec,
PX_Object_Version_Number => PX_OBJECT_VERSION_NUMBER,
X_Return_Status => X_Return_Status,
X_Msg_Count => X_Msg_Count,
X_Msg_Data => X_Msg_Data
);
ROLLBACK TO Update_profile_check_rules_PUB;
ROLLBACK TO Update_profile_check_rules_PUB;
ROLLBACK TO Update_profile_check_rules_PUB;
End Update_profile_check_rules;
PROCEDURE Delete_profile_check_rules(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
P_CHECK_ID IN NUMBER,
p_SEQUENCE IN NUMBER,
p_OBJECT_VERSION_NUMBER 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_profile_check_rules';
SAVEPOINT DELETE_PROFILE_CHECK_RULES_PUB;
CSC_profile_check_rules_PVT.Delete_profile_check_rules(
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_CHECK_ID => P_CHECK_ID,
p_SEQUENCE => P_SEQUENCE,
p_OBJECT_VERSION_NUMBER => p_OBJECT_VERSION_NUMBER,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
ROLLBACK TO Delete_profile_check_rules_PUB;
ROLLBACK TO Delete_profile_check_rules_PUB;
ROLLBACK TO Delete_profile_check_rules_PUB;
End Delete_profile_check_rules;