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_ASSIGNMENTS_PUB dependencies on PA_PROJECT_ROLE_TYPES

Line 57: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

53: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
54: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
55: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
56: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
57: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
58: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
59: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
60: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 447: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

443:
444:
445: PROCEDURE Exec_Create_Assign_With_Def
446: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'
447: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
448: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
449: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := 'N'
450: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
451: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

Line 573: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

569:
570:
571: PROCEDURE Create_Assign_With_Def
572: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
573: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
574: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
575: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
576: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
577: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

Line 900: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

896: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
897: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
898: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
899: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
900: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
901: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
902: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
903: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
904: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 3230: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

3226: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
3227: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
3228: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
3229: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
3230: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3231: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3232: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
3233: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
3234: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 4362: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

4358: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
4359: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
4360: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
4361: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
4362: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
4363: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
4364: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
4365: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
4366: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 4392: l_project_role_id pa_project_role_types.project_role_id%TYPE;

4388: l_assignment_id pa_project_assignments.assignment_id%TYPE;
4389: l_project_id pa_projects.project_id%TYPE;
4390: l_resource_source_id pa_resources.resource_id%TYPE;
4391: l_status_code pa_project_statuses.project_status_code%TYPE;
4392: l_project_role_id pa_project_role_types.project_role_id%TYPE;
4393: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
4394: l_location_country_code fnd_territories.territory_code%TYPE;
4395: l_calendar_id jtf_calendars_b.calendar_id%TYPE;
4396: l_return_status VARCHAR2(1);

Line 6426: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

6422: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
6423: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6424: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
6425: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6426: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
6427: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6428: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6429: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6430: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 6720: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

6716: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
6717: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6718: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
6719: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6720: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
6721: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6722: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6723: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
6724: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 7581: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

7577: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
7578: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
7579: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
7580: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
7581: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
7582: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
7583: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
7584: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
7585: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 8073: pa_project_role_types_b role,

8069:
8070: Select 1 INTO x_return_status from dual
8071: where exists (
8072: Select role.project_role_id from
8073: pa_project_role_types_b role,
8074: pa_project_assignments asm where
8075: asm.project_role_id = role.project_role_id and
8076: trunc(SYSDATE) Between trunc(role.start_date_active) and trunc(NVL(role.end_date_active,SYSDATE+1))
8077: and asm.assignment_id = p_assignment_id);