The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE updatePOHeaderId
( p_api_version IN NUMBER ,
p_commit IN VARCHAR2 := FND_API.G_FALSE ,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
x_return_status OUT NOCOPY VARCHAR2 ,
p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'updatePOHeaderId';
SAVEPOINT updatePOHeaderId_sp;
ICX_CAT_R12_UPGRADE_PVT.updatePOHeaderId(p_interface_header_id);
ROLLBACK TO updatePOHeaderId_sp;
END updatePOHeaderId;
PROCEDURE updatePOLineId
( p_api_version IN NUMBER ,
p_commit IN VARCHAR2 := FND_API.G_FALSE ,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
x_return_status OUT NOCOPY VARCHAR2 ,
p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'updatePOLineId';
SAVEPOINT updatePOLineId_sp;
ICX_CAT_R12_UPGRADE_PVT.updatePOLineId(p_interface_line_id);
ROLLBACK TO updatePOLineId_sp;
END updatePOLineId;
PROCEDURE updateR12UpgradeJob
( p_api_version IN NUMBER ,
p_commit IN VARCHAR2 := FND_API.G_FALSE ,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
x_return_status OUT NOCOPY VARCHAR2 ,
p_job_status IN VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'updateR12UpgradeJob';
SAVEPOINT updateR12UpgradeJob_sp;
ICX_CAT_R12_UPGRADE_PVT.updateR12UpgradeJob(p_job_status);
ROLLBACK TO updateR12UpgradeJob_sp;
END updateR12UpgradeJob;