DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on PA_PROJECTS

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

1239: -- Project
1240: IF l_material_rec.project IS NULL AND l_material_rec.project_id IS NOT NULL THEN
1241: BEGIN
1242: SELECT name INTO l_material_rec.project
1243: FROM pa_projects WHERE project_id = l_material_rec.project_id;
1244: EXCEPTION
1245: WHEN no_data_found THEN
1246: IF l_debug = 1 THEN
1247: trace(' can not find project name for project_id '|| l_material_rec.project_id);

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

2242: l_material_rec.project := p_project;
2243: ELSIF l_material_rec.project_id IS NOT NULL THEN
2244: BEGIN
2245: SELECT name INTO l_material_rec.project
2246: FROM pa_projects WHERE project_id = l_material_rec.project_id;
2247: EXCEPTION
2248: WHEN NO_DATA_FOUND THEN
2249: IF l_debug = 1 THEN
2250: trace(' can not find project name for project_id '|| l_material_rec.project_id);