The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_process_rules(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
P_Identity_Resource_Id IN NUMBER,
P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_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_process_rules';
SAVEPOINT UPDATE_PROCESS_RULES_PUB;
PV_process_rule_PVT.Update_process_rule(
P_Api_Version_Number => 2.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => p_commit,
P_Validation_Level => P_Validation_Level,
P_Identity_Resource_Id => P_Identity_Resource_Id,
P_process_rule_rec => p_RULES_Rec ,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
End Update_process_rules;
PROCEDURE Delete_process_rules(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
P_Identity_Resource_Id IN NUMBER,
P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_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) := 'Delete_process_rules';
SAVEPOINT DELETE_PROCESS_RULES_PUB;
PV_process_rule_PVT.Delete_process_rule(
P_Api_Version_Number => 2.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => p_commit,
P_Validation_Level => p_Validation_Level,
P_Identity_Resource_Id => P_Identity_Resource_Id,
P_process_rule_rec => p_RULES_Rec,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
End Delete_process_rules;