eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_SEARCH_PUB dependencies on PA_PROJECT_ASSIGNMENTS

Line 7: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM

3: --
4:
5: PROCEDURE Run_Search(
6: p_search_mode IN VARCHAR2
7: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
8: , p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
9: , p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM

Line 8: , p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM

4:
5: PROCEDURE Run_Search(
6: p_search_mode IN VARCHAR2
7: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
8: , p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
9: , p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM
12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM
12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM
17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM

Line 15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM
12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM
17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM
19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 95: FROM pa_project_assignments asgn

91: asgn.search_min_availability,
92: asgn.search_country_code,
93: asgn.SEARCH_EXP_ORG_STRUCT_VER_ID,
94: asgn.SEARCH_EXP_START_ORG_ID
95: FROM pa_project_assignments asgn
96: WHERE asgn.assignment_id = p_assignment_id;
97:
98: -- cursor to the the rating level from the rating level id.
99: CURSOR get_step_value(l_rating_level_id NUMBER) IS