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: G_update_assignment_bulk_call varchar2(1) := 'N'; -- Bug 8223045

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1231: PROCEDURE Update_Assignment
1232: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1233: ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1234: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*bug2386679*/
1235: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1236: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1237: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1238: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1239: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

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

1233: ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1234: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR/*bug2386679*/
1235: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1236: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1237: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1238: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
1239: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1240: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1241: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM

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

1772: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
1773: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1774: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1775: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
1776: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1777: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1778: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1779: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1780: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

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

1774: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1775: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
1776: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1777: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1778: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1779: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
1780: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
1781: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
1782: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR