The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Planned_Materials (
p_api_version 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_module_type IN VARCHAR2 := 'JSP',
p_planned_Materials_tbl IN Planned_Materials_Tbl,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
--Standard local variables
l_api_name CONSTANT VARCHAR2(30) := 'Update_Planned_Materials';
'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update_Planned_Materials',
'At the start of PLSQL procedure'
);
SAVEPOINT Update_Planned_Materials;
'Request for Update Material Number of Records : '|| l_planned_materials_tbl.COUNT
);
'Before calling ahl ltp reqst matrl pvt.Update Planned Materials'
);
AHL_LTP_REQST_MATRL_PVT.Update_Planned_Materials (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => l_commit,
p_validation_level => p_validation_level,
p_planned_materials_tbl => p_planned_materials_tbl,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
'After calling ahl ltp reqst matrl pvt.Update Planned Materials, Return Status : '|| l_return_status
);
'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update Planned Materials.end',
'At the end of PLSQL procedure'
);
ROLLBACK TO Update_Planned_Materials;
ROLLBACK TO Update_Planned_Materials;
ROLLBACK TO Update_Planned_Materials;
p_procedure_name => 'Update_Planned_Materials',
p_error_text => SUBSTR(SQLERRM,1,500));
END Update_Planned_Materials;