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

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
452: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
453: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
454: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
455: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
456: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
457: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
458: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

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

454: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
455: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
456: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
457: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
458: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
459: ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
460: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
461: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
462: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

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
578: ,p_resource_source_id IN per_all_people_f.person_id%TYPE := FND_API.G_MISS_NUM
579: ,p_api_version IN NUMBER := 1.0
580: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
581: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 604: l_resource_id pa_resources.resource_id%TYPE;

600: l_job_id NUMBER;
601: l_error_message_code fnd_new_messages.message_name%TYPE;
602: l_competencies_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;
603: l_location_country_code pa_locations.country_code%TYPE;
604: l_resource_id pa_resources.resource_id%TYPE;
605: l_msg_count NUMBER;
606: l_msg_data VARCHAR2(4000);
607: l_work_type_id NUMBER;
608: l_check_id_flag VARCHAR2(1);

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

890: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
891: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
892: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
893: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
894: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
895: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
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

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

919: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
920: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
921: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
922: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
923: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
924: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
925: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
926: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
927: )

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

1941: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
1942: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
1943: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1944: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
1945: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
1946: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
1947: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1948: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
1949: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

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

1946: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
1947: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1948: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
1949: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
1950: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
1951: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
1952: ,p_api_version IN NUMBER := 1.0
1953: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1954: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

1956: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1957: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
1958: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
1959: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
1960: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
1961: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1962: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1963: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1964: )

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

2081: ,p_unfilled_assign_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
2082: ,p_unfilled_assign_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2083: ,p_remaining_candidate_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2084: ,p_change_reason_code IN pa_lookups.lookup_code%TYPE := FND_API.G_MISS_CHAR
2085: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
2086: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
2087: ,p_assignment_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2088: ,p_api_version IN NUMBER := 1.0
2089: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

2092: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2093: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
2094: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
2095: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
2096: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
2097: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2098: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2099: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2100: )

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

3221: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
3222: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
3223: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
3224: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
3225: ,p_resource_name IN pa_resources.name%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

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

3223: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
3224: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
3225: ,p_resource_name IN pa_resources.name%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

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

4349: PROCEDURE Update_Assignment
4350: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
4351: ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
4352: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
4353: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
4354: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
4355: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
4356: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
4357: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

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

4351: ,p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
4352: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
4353: ,p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
4354: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
4355: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
4356: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
4357: ,p_project_status_name IN pa_project_statuses.project_status_name%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

Line 4390: l_resource_source_id pa_resources.resource_id%TYPE;

4386:
4387: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_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;

Line 6111: l_resource_id pa_resources_denorm.resource_id%TYPE;

6107: l_msg_data VARCHAR2(2000);
6108: l_msg_count NUMBER;
6109: l_msg_index_out NUMBER;
6110: l_assignment_rec assignment_rec_type;
6111: l_resource_id pa_resources_denorm.resource_id%TYPE;
6112: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;
6113: l_adv_action_set_id pa_action_sets.action_set_id%TYPE;
6114:
6115: BEGIN

Line 6471: l_resource_id pa_resources_denorm.resource_id%TYPE;

6467: FROM pa_project_assignments -- 5078700 changed from pa_project_assignments_v to pa_project_assignments
6468: WHERE assignment_id = p_asg_id;
6469:
6470: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
6471: l_resource_id pa_resources_denorm.resource_id%TYPE;
6472: l_assignment_number pa_project_assignments.assignment_number%TYPE;
6473: l_assignment_row_id ROWID;
6474: l_status_code pa_project_assignments.status_code%TYPE ; --Bug 7309934
6475:

Line 6762: l_resource_id pa_resources_denorm.resource_id%TYPE;

6758: IS
6759:
6760: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
6761: l_new_assignment_id_tbl system.pa_num_tbl_type := p_resource_id_tbl;
6762: l_resource_id pa_resources_denorm.resource_id%TYPE;
6763: l_assignment_number pa_project_assignments.assignment_number%TYPE;
6764: l_assignment_row_id ROWID;
6765: l_new_assignment_tabl system.pa_num_tbl_type;
6766: l_return_status VARCHAR2(1);

Line 7263: l_resource_id pa_resources.resource_id%TYPE;

7259: l_exp_organization_name per_organization_units.name%TYPE;
7260: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
7261: l_req_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
7262: l_req_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
7263: l_resource_id pa_resources.resource_id%TYPE;
7264:
7265: CURSOR get_asgn_info(l_asmt_id NUMBER) IS
7266: 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
7267: FROM pa_project_assignments ppa,

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

7572: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
7573: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
7574: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
7575: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
7576: ,p_resource_name IN pa_resources.name%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

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

7574: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
7575: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR /* Bug 1851096 */
7576: ,p_resource_name IN pa_resources.name%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