DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on PA_PROJECTS

Line 1306: FROM pa_projects WHERE project_id = l_material_rec.project_id;

1302: -- Project
1303: IF l_material_rec.project IS NULL AND l_material_rec.project_id IS NOT NULL THEN
1304: BEGIN
1305: SELECT name INTO l_material_rec.project
1306: FROM pa_projects WHERE project_id = l_material_rec.project_id;
1307: EXCEPTION
1308: WHEN no_data_found THEN
1309: IF l_debug = 1 THEN
1310: trace(' can not find project name for project_id '|| l_material_rec.project_id);

Line 2319: FROM pa_projects WHERE project_id = l_material_rec.project_id;

2315: l_material_rec.project := p_project;
2316: ELSIF l_material_rec.project_id IS NOT NULL THEN
2317: BEGIN
2318: SELECT name INTO l_material_rec.project
2319: FROM pa_projects WHERE project_id = l_material_rec.project_id;
2320: EXCEPTION
2321: WHEN NO_DATA_FOUND THEN
2322: IF l_debug = 1 THEN
2323: trace(' can not find project name for project_id '|| l_material_rec.project_id);