APPS.PA_MASS_ASGMT_TRX dependencies on PA_PROJECT_STATUSES

Line 35: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

31: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
32: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
33: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
34: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
39: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 1243: l_project_status_name pa_project_statuses.project_status_name%TYPE;

1239: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;
1240: l_project_name pa_projects_all.name%TYPE;
1241: l_project_number pa_projects_all.segment1%TYPE;
1242: l_project_subteam_name pa_project_subteams.name%TYPE;
1243: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1244: l_staffing_priority_name pa_lookups.meaning%TYPE;
1245: l_project_role_name pa_project_role_types.meaning%TYPE;
1246: l_location_city pa_locations.city%TYPE;
1247: l_location_region pa_locations.region%TYPE;

Line 1927: FROM pa_project_statuses

1923:
1924: IF l_change_rqmt_status_code <> FND_API.G_MISS_CHAR THEN
1925:
1926: SELECT project_status_name INTO l_project_status_name
1927: FROM pa_project_statuses
1928: WHERE project_status_code = l_change_rqmt_status_code
1929: AND status_type='OPEN_ASGMT' ;
1930:
1931: x_document := x_document||get_translated_attr_name('STATUS_NAME')||' - '||l_project_status_name||'
';

Line 1944: FROM pa_project_statuses

1940: --append to x_document to display the Updated Information region in the wf notification
1941: --get the name as we will only have the code as the field is a poplist on the page
1942: IF l_change_asgmt_status_code <> FND_API.G_MISS_CHAR THEN
1943: SELECT project_status_name INTO l_project_status_name
1944: FROM pa_project_statuses
1945: WHERE project_status_code = l_change_asgmt_status_code
1946: AND status_type='STAFFED_ASGMT' ;
1947: x_document := x_document||get_translated_attr_name('STATUS_NAME')||' - '||l_project_status_name||'
';
1948: END IF;