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 20: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM

16: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
17: ,p_assignment_template_id IN pa_project_assignments.assignment_template_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

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

48: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
49: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
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

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

118: ,x_new_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895
119: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
120: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
121: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
122: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
123: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
124: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
125: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
126: )

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

415: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
416: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
417: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
418: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
419: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
420: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
421: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
422: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
423: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

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

419: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
420: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
421: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
422: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
423: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
424: ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
425: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
426: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
427: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

538: ,p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
539: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
540: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
541: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
542: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
543: ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
544: ,p_api_version IN NUMBER := 1.0
545: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
546: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 569: l_resource_id pa_resources.resource_id%TYPE;

565: l_job_id NUMBER;
566: l_error_message_code fnd_new_messages.message_name%TYPE;
567: l_competencies_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;
568: l_location_country_code pa_locations.country_code%TYPE;
569: l_resource_id pa_resources.resource_id%TYPE;
570: l_msg_count NUMBER;
571: l_msg_data VARCHAR2(4000);
572: l_work_type_id NUMBER;
573: l_check_id_flag VARCHAR2(1);

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

855: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
856: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
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

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

884: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
885: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
886: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
887: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
888: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
889: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
890: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
891: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
892: )

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

1878: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1879: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1880: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1881: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1882: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1883: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
1884: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1885: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
1886: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

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

1883: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
1884: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1885: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
1886: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
1887: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1888: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1889: ,p_api_version IN NUMBER := 1.0
1890: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1891: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

1893: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1894: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
1895: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
1896: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
1897: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
1898: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1899: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1900: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1901: )

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

2018: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
2019: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2020: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2021: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2022: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
2023: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
2024: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2025: ,p_api_version IN NUMBER := 1.0
2026: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

2029: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2030: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
2031: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
2032: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
2033: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
2034: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2035: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2036: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2037: )

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

3139: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
3140: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
3141: ,p_expenditure_type IN pa_project_assignments.expenditure_type%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

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

3141: ,p_expenditure_type IN pa_project_assignments.expenditure_type%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

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

3422: PROCEDURE Update_Assignment
3423: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
3424: ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
3425: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
3426: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
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

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

3424: ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
3425: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
3426: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
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

Line 3462: l_resource_source_id pa_resources.resource_id%TYPE;

3458:
3459: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
3460: l_assignment_id pa_project_assignments.assignment_id%TYPE;
3461: l_project_id pa_projects.project_id%TYPE;
3462: l_resource_source_id pa_resources.resource_id%TYPE;
3463: l_status_code pa_project_statuses.project_status_code%TYPE;
3464: l_project_role_id pa_project_role_types.project_role_id%TYPE;
3465: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
3466: l_location_country_code fnd_territories.territory_code%TYPE;

Line 5135: l_resource_id pa_resources_denorm.resource_id%TYPE;

5131: l_msg_data VARCHAR2(2000);
5132: l_msg_count NUMBER;
5133: l_msg_index_out NUMBER;
5134: l_assignment_rec assignment_rec_type;
5135: l_resource_id pa_resources_denorm.resource_id%TYPE;
5136: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;
5137: l_adv_action_set_id pa_action_sets.action_set_id%TYPE;
5138:
5139: BEGIN

Line 5495: l_resource_id pa_resources_denorm.resource_id%TYPE;

5491: FROM pa_project_assignments -- 5078700 changed from pa_project_assignments_v to pa_project_assignments
5492: WHERE assignment_id = p_asg_id;
5493:
5494: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
5495: l_resource_id pa_resources_denorm.resource_id%TYPE;
5496: l_assignment_number pa_project_assignments.assignment_number%TYPE;
5497: l_assignment_row_id ROWID;
5498: l_status_code pa_project_assignments.status_code%TYPE ; --Bug 7309934
5499:

Line 5786: l_resource_id pa_resources_denorm.resource_id%TYPE;

5782: IS
5783:
5784: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
5785: l_new_assignment_id_tbl system.pa_num_tbl_type := p_resource_id_tbl;
5786: l_resource_id pa_resources_denorm.resource_id%TYPE;
5787: l_assignment_number pa_project_assignments.assignment_number%TYPE;
5788: l_assignment_row_id ROWID;
5789: l_new_assignment_tabl system.pa_num_tbl_type;
5790: l_return_status VARCHAR2(1);

Line 6287: l_resource_id pa_resources.resource_id%TYPE;

6283: l_exp_organization_name per_organization_units.name%TYPE;
6284: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
6285: l_req_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
6286: l_req_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
6287: l_resource_id pa_resources.resource_id%TYPE;
6288:
6289: CURSOR get_asgn_info(l_asmt_id NUMBER) IS
6290: SELECT ppsp.project_subteam_party_id, ppa.assignment_type, ppa.description, ppa.additional_information, ppa.start_date, ppa.end_date, ppa.min_resource_job_level, ppa.max_resource_job_level, ppa.resource_id
6291: FROM pa_project_assignments ppa,

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

6596: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
6597: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
6598: ,p_expenditure_type IN pa_project_assignments.expenditure_type%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

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

6598: ,p_expenditure_type IN pa_project_assignments.expenditure_type%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