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_MASS_ASGMT_TRX dependencies on PA_PROJECTS_ALL

Line 32: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

28: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
29: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
30: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
31: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
32: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
33: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
34: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

Line 33: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

29: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
30: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
31: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
32: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
33: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
34: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 143: l_project_id pa_projects_all.project_id%TYPE;

139: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
140: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
141: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
142: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
143: l_project_id pa_projects_all.project_id%TYPE;
144: l_fcst_tp_amount_type_name VARCHAR2(80);
145: ----Added following folloeing for bug 6199871 ------------------------
146: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;
147: l_change_id NUMBER;

Line 207: FROM pa_projects_all

203: --an admin assignment from the resource context) then get the project id
204: --from the project number. Project number is required.
205: IF p_project_id IS NULL OR p_project_id = FND_API.G_MISS_NUM THEN
206: SELECT project_id INTO l_project_id
207: FROM pa_projects_all
208: WHERE segment1 = p_project_number;
209: ELSE
210: l_project_id := p_project_id;
211: END IF;

Line 778: l_project_name pa_projects_all.name%TYPE;

774: l_asgmt_overcom_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
775: l_project_id pa_project_assignments.project_id%TYPE;
776: l_start_date pa_project_assignments.start_date%TYPE;
777: l_end_date pa_project_assignments.end_date%TYPE;
778: l_project_name pa_projects_all.name%TYPE;
779: l_project_number pa_projects_all.segment1%TYPE;
780: l_success_assignments NUMBER := 0;
781: l_failure_assignments NUMBER := 0;
782: l_text_attr_name_tbl Wf_Engine.NameTabTyp;

Line 779: l_project_number pa_projects_all.segment1%TYPE;

775: l_project_id pa_project_assignments.project_id%TYPE;
776: l_start_date pa_project_assignments.start_date%TYPE;
777: l_end_date pa_project_assignments.end_date%TYPE;
778: l_project_name pa_projects_all.name%TYPE;
779: l_project_number pa_projects_all.segment1%TYPE;
780: l_success_assignments NUMBER := 0;
781: l_failure_assignments NUMBER := 0;
782: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
783: l_text_attr_value_tbl Wf_Engine.TextTabTyp;

Line 1059: FROM pa_projects_all proj

1055: l_project_number,
1056: l_project_organization,
1057: l_project_manager,
1058: l_project_customer
1059: FROM pa_projects_all proj
1060: WHERE project_id = l_project_id;
1061:
1062: --store the project attributes in the name/value plsql tables.
1063: l_text_attr_name_tbl(l_text_attr_name_tbl.COUNT+1) := 'PROJECT_NAME';

Line 1240: l_project_name pa_projects_all.name%TYPE;

1236: l_work_type_id NUMBER;
1237: l_calendar_type pa_project_assignments.calendar_type%TYPE;
1238: l_calendar_id NUMBER;
1239: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;
1240: l_project_name pa_projects_all.name%TYPE;
1241: l_project_number pa_projects_all.segment1%TYPE;
1242: l_project_subteam_name pa_project_subteams.name%TYPE;
1243: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1244: l_staffing_priority_name pa_lookups.meaning%TYPE;

Line 1241: l_project_number pa_projects_all.segment1%TYPE;

1237: l_calendar_type pa_project_assignments.calendar_type%TYPE;
1238: l_calendar_id NUMBER;
1239: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;
1240: l_project_name pa_projects_all.name%TYPE;
1241: l_project_number pa_projects_all.segment1%TYPE;
1242: l_project_subteam_name pa_project_subteams.name%TYPE;
1243: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1244: l_staffing_priority_name pa_lookups.meaning%TYPE;
1245: l_project_role_name pa_project_role_types.meaning%TYPE;

Line 2479: from pa_projects_all

2475: IF l_mode = G_MASS_ASGMT AND (l_project_id IS NULL OR l_project_id = FND_API.G_MISS_NUM)
2476: AND l_project_number IS NOT NULL AND l_project_number <> FND_API.G_MISS_CHAR THEN
2477:
2478: select project_id into l_project_id
2479: from pa_projects_all
2480: where segment1 = l_project_number;
2481:
2482: x_project_id := l_project_id;
2483:

Line 2531: l_project_id pa_projects_all.project_id%TYPE;

2527: l_msg_count NUMBER;
2528: l_msg_data fnd_new_messages.message_text%TYPE;
2529: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2530: l_document VARCHAR2(32767);
2531: l_project_id pa_projects_all.project_id%TYPE;
2532: l_submitter_user_id NUMBER;
2533: l_num_success_assignments NUMBER;
2534:
2535:

Line 2856: l_project_id pa_projects_all.project_id%TYPE;

2852: l_submitter_user_id NUMBER;
2853: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2854: l_resource_id pa_resources_denorm.resource_id%TYPE;
2855: l_return_status VARCHAR2(1);
2856: l_project_id pa_projects_all.project_id%TYPE;
2857: TYPE object_id_tbl IS TABLE OF NUMBER
2858: INDEX BY BINARY_INTEGER;
2859: l_object_id1_tbl object_id_tbl;
2860: