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 1300: l_project_status_name pa_project_statuses.project_status_name%TYPE;

1296: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;
1297: l_project_name pa_projects_all.name%TYPE;
1298: l_project_number pa_projects_all.segment1%TYPE;
1299: l_project_subteam_name pa_project_subteams.name%TYPE;
1300: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1301: l_staffing_priority_name pa_lookups.meaning%TYPE;
1302: l_project_role_name pa_project_role_types.meaning%TYPE;
1303: l_location_city pa_locations.city%TYPE;
1304: l_location_region pa_locations.region%TYPE;

Line 1984: FROM pa_project_statuses

1980:
1981: IF l_change_rqmt_status_code <> FND_API.G_MISS_CHAR THEN
1982:
1983: SELECT project_status_name INTO l_project_status_name
1984: FROM pa_project_statuses
1985: WHERE project_status_code = l_change_rqmt_status_code
1986: AND status_type='OPEN_ASGMT' ;
1987:
1988: x_document := x_document||get_translated_attr_name('STATUS_NAME')||' - '||l_project_status_name||'
';

Line 2001: FROM pa_project_statuses

1997: --append to x_document to display the Updated Information region in the wf notification
1998: --get the name as we will only have the code as the field is a poplist on the page
1999: IF l_change_asgmt_status_code <> FND_API.G_MISS_CHAR THEN
2000: SELECT project_status_name INTO l_project_status_name
2001: FROM pa_project_statuses
2002: WHERE project_status_code = l_change_asgmt_status_code
2003: AND status_type='STAFFED_ASGMT' ;
2004: x_document := x_document||get_translated_attr_name('STATUS_NAME')||' - '||l_project_status_name||'
';
2005: END IF;