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_RESOURCES

Line 116: TYPE res_name_tbl_type IS TABLE OF pa_resources_denorm.resource_name%TYPE

112:
113: TYPE num_tbl_type IS TABLE OF NUMBER
114: INDEX BY BINARY_INTEGER;
115:
116: TYPE res_name_tbl_type IS TABLE OF pa_resources_denorm.resource_name%TYPE
117: INDEX BY BINARY_INTEGER;
118:
119: g_assignment_id_tbl Assignment_Id_Tbl_Type;
120:

Line 258: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM

254: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
255: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
256: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
257: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
258: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
259: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
260: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
261: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
262: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

Line 290: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

286: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
287: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
288: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
289: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
290: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
291: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
292: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
293: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
294: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

Line 360: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895

356: ,x_new_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895
357: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
358: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
359: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
360: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
361: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
362: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
363: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
364: );

Line 438: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

434: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
435: -- ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
436: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
437: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
438: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
439: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
440: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
441: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
442: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

Line 467: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895

463: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
464: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
465: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
466: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
467: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
468: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
469: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
470: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
471: );

Line 550: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM

546: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
547: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
548: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
549: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
550: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
551: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
552: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
553: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
554: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

Line 554: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

550: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
551: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
552: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
553: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
554: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
555: ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
556: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
557: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
558: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 635: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

631: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
632: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
633: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
634: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
635: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
636: ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
637: ,p_api_version IN NUMBER := 1.0
638: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
639: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 733: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM

729: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
730: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
731: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
732: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
733: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
734: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
735: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
736: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
737: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

Line 738: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

734: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
735: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
736: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
737: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
738: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
739: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
740: ,p_api_version IN NUMBER := 1.0
741: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
742: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 748: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895

744: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
745: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
746: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
747: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
748: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
749: -- ,x_wf_type OUT VARCHAR2
750: -- ,x_wf_item_type OUT VARCHAR2
751: -- ,x_wf_process OUT VARCHAR2
752: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 824: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

820: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
821: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
822: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
823: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
824: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
825: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
826: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
827: ,p_api_version IN NUMBER := 1.0
828: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 836: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895

832: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
833: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
834: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
835: --,x_new_unfilled_assignment_id OUT pa_project_assignments.assignment_id%TYPE
836: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
837: -- ,x_wf_type OUT VARCHAR2
838: -- ,x_wf_item_type OUT VARCHAR2
839: -- ,x_wf_process OUT VARCHAR2
840: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1003: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

999: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1000: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1001: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1002: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*2386679*/
1003: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1004: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1005: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1006: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1007: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

Line 1005: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM

1001: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1002: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*2386679*/
1003: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1004: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1005: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1006: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1007: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1008: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1009: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 1137: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

1133: PROCEDURE Update_Assignment
1134: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1135: ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1136: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*bug2386679*/
1137: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1138: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1139: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1140: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1141: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

Line 1139: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM

1135: ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1136: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*bug2386679*/
1137: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1138: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1139: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1140: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1141: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1142: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1143: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM

Line 1677: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

1673: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1674: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1675: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1676: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
1677: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1678: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1679: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1680: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1681: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

Line 1679: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM

1675: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1676: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
1677: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1678: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1679: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1680: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1681: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1682: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1683: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR