DBA Data[Home] [Help]

APPS.PA_PROJ_TEMPLATE_SETUP_PUB dependencies on PA_PROJECTS_ALL

Line 371: FROM pa_projects_all

367: IF p_validate_only <> FND_API.G_TRUE
368: THEN
369: BEGIN
370: SELECT 'x' INTO l_dummy_char
371: FROM pa_projects_all
372: WHERE project_id = p_project_id
373: AND record_version_number = p_record_version_number
374: FOR UPDATE OF record_version_number NOWAIT;
375: EXCEPTION

Line 405: FROM pa_projects_all

401: END;
402: ELSE
403: BEGIN
404: SELECT 'x' INTO l_dummy_char
405: FROM pa_projects_all
406: WHERE project_id = p_project_id
407: AND record_version_number = p_record_version_number;
408: EXCEPTION
409: WHEN NO_DATA_FOUND THEN

Line 580: FROM pa_projects_all

576: IF p_validate_only <> FND_API.G_TRUE
577: THEN
578: BEGIN
579: SELECT 'x' INTO l_dummy_char
580: FROM pa_projects_all
581: WHERE project_id = p_project_id
582: AND record_version_number = p_record_version_number
583: FOR UPDATE OF record_version_number NOWAIT;
584: EXCEPTION

Line 614: FROM pa_projects_all

610: END;
611: ELSE
612: BEGIN
613: SELECT 'x' INTO l_dummy_char
614: FROM pa_projects_all
615: WHERE project_id = p_project_id
616: AND record_version_number = p_record_version_number;
617: EXCEPTION
618: WHEN NO_DATA_FOUND THEN