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_SUBTEAMS

Line 22: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

18: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
19: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
20: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
21: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
22: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
23: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
24: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
25: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
26: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM

Line 54: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

50: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
51: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
52: ,p_resource_name IN pa_resources.name%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

Line 861: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

857: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
858: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
859: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
860: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
861: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
862: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
863: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
864: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
865: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 862: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

858: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
859: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
860: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
861: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
862: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
863: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
864: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
865: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
866: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 917: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;

913: l_msg_data VARCHAR2(2000);
914: l_valid_flag VARCHAR2(1);
915: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
916: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;
917: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
918: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
919: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;
920: l_object_type pa_project_subteams.object_type%TYPE;
921: l_object_id pa_project_subteams.object_id%TYPE;

Line 920: l_object_type pa_project_subteams.object_type%TYPE;

916: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;
917: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
918: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
919: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;
920: l_object_type pa_project_subteams.object_type%TYPE;
921: l_object_id pa_project_subteams.object_id%TYPE;
922: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
923: l_role_list_id pa_role_lists.role_list_id%TYPE;
924: l_project_id pa_project_assignments.project_id%TYPE;

Line 921: l_object_id pa_project_subteams.object_id%TYPE;

917: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
918: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
919: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;
920: l_object_type pa_project_subteams.object_type%TYPE;
921: l_object_id pa_project_subteams.object_id%TYPE;
922: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
923: l_role_list_id pa_role_lists.role_list_id%TYPE;
924: l_project_id pa_project_assignments.project_id%TYPE;
925: l_adv_action_set_id NUMBER;

Line 3117: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

3113: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
3114: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
3115: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
3116: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
3117: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
3118: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
3119: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
3120: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
3121: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

Line 3146: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

3142: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
3143: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
3144: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
3145: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
3146: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
3147: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
3148: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3149: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3150: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 3431: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

3427: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
3428: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
3429: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
3430: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
3431: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
3432: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
3433: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
3434: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
3435: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 3433: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

3429: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
3430: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
3431: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
3432: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
3433: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
3434: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
3435: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3436: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
3437: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 3477: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;

3473: l_error_message_code fnd_new_messages.message_name%TYPE;
3474: l_msg_index_out NUMBER;
3475: l_valid_flag VARCHAR2(1);
3476: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
3477: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
3478: l_object_type pa_project_subteams.object_type%TYPE;
3479: l_object_id pa_project_subteams.object_id%TYPE;
3480: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
3481: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 3478: l_object_type pa_project_subteams.object_type%TYPE;

3474: l_msg_index_out NUMBER;
3475: l_valid_flag VARCHAR2(1);
3476: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
3477: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
3478: l_object_type pa_project_subteams.object_type%TYPE;
3479: l_object_id pa_project_subteams.object_id%TYPE;
3480: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
3481: l_project_status_name pa_project_statuses.project_status_name%TYPE;
3482: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;

Line 3479: l_object_id pa_project_subteams.object_id%TYPE;

3475: l_valid_flag VARCHAR2(1);
3476: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
3477: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
3478: l_object_type pa_project_subteams.object_type%TYPE;
3479: l_object_id pa_project_subteams.object_id%TYPE;
3480: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
3481: l_project_status_name pa_project_statuses.project_status_name%TYPE;
3482: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
3483: l_record_version_check VARCHAR2(1) := 'Y';

Line 5417: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

5413: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
5414: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
5415: ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
5416: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
5417: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
5418: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
5419: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
5420: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
5421: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM

Line 5447: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

5443: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
5444: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
5445: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
5446: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
5447: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
5448: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
5449: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
5450: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
5451: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 5711: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

5707: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
5708: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
5709: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
5710: ,p_resource_id_tbl IN system.pa_num_tbl_type
5711: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
5712: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
5713: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
5714: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
5715: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM

Line 5741: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

5737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
5738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
5739: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
5740: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
5741: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
5742: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
5743: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
5744: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
5745: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 5945: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

5941: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
5942: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
5943: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
5944: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
5945: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
5946: ,p_append_description_flag IN VARCHAR2 := 'N'
5947: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
5948: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
5949: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 5965: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

5961: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
5962: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
5963: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
5964: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
5965: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
5966: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
5967: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
5968: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
5969: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 6189: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

6185: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
6186: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
6187: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
6188: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
6189: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
6190: ,p_append_description_flag IN VARCHAR2 := 'N'
6191: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
6192: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
6193: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 6209: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

6205: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
6206: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
6207: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
6208: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
6209: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6210: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6211: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6212: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
6213: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 6574: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

6570: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
6571: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
6572: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
6573: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
6574: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
6575: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
6576: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
6577: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
6578: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

Line 6603: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

6599: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
6600: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
6601: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
6602: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
6603: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
6604: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
6605: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
6606: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
6607: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR