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: /* Commented for bug 9114634
146: ----Added following folloeing for bug 6199871 ------------------------
147: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;

Line 209: FROM pa_projects_all

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

Line 780: l_project_name pa_projects_all.name%TYPE;

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

Line 781: l_project_number pa_projects_all.segment1%TYPE;

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

Line 1115: FROM pa_projects_all proj

1111: l_project_number,
1112: l_project_organization,
1113: l_project_manager,
1114: l_project_customer
1115: FROM pa_projects_all proj
1116: WHERE project_id = l_project_id;
1117:
1118: --store the project attributes in the name/value plsql tables.
1119: l_text_attr_name_tbl(l_text_attr_name_tbl.COUNT+1) := 'PROJECT_NAME';

Line 1297: l_project_name pa_projects_all.name%TYPE;

1293: l_work_type_id NUMBER;
1294: l_calendar_type pa_project_assignments.calendar_type%TYPE;
1295: l_calendar_id NUMBER;
1296: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;
1297: l_project_name pa_projects_all.name%TYPE;
1298: l_project_number pa_projects_all.segment1%TYPE;
1299: l_project_subteam_name pa_project_subteams.name%TYPE;
1300: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1301: l_staffing_priority_name pa_lookups.meaning%TYPE;

Line 1298: l_project_number pa_projects_all.segment1%TYPE;

1294: l_calendar_type pa_project_assignments.calendar_type%TYPE;
1295: l_calendar_id NUMBER;
1296: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;
1297: l_project_name pa_projects_all.name%TYPE;
1298: l_project_number pa_projects_all.segment1%TYPE;
1299: l_project_subteam_name pa_project_subteams.name%TYPE;
1300: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1301: l_staffing_priority_name pa_lookups.meaning%TYPE;
1302: l_project_role_name pa_project_role_types.meaning%TYPE;

Line 2536: from pa_projects_all

2532: IF l_mode = G_MASS_ASGMT AND (l_project_id IS NULL OR l_project_id = FND_API.G_MISS_NUM)
2533: AND l_project_number IS NOT NULL AND l_project_number <> FND_API.G_MISS_CHAR THEN
2534:
2535: select project_id into l_project_id
2536: from pa_projects_all
2537: where segment1 = l_project_number;
2538:
2539: x_project_id := l_project_id;
2540:

Line 2588: l_project_id pa_projects_all.project_id%TYPE;

2584: l_msg_count NUMBER;
2585: l_msg_data fnd_new_messages.message_text%TYPE;
2586: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2587: l_document VARCHAR2(32767);
2588: l_project_id pa_projects_all.project_id%TYPE;
2589: l_submitter_user_id NUMBER;
2590: l_num_success_assignments NUMBER;
2591:
2592:

Line 2915: l_project_id pa_projects_all.project_id%TYPE;

2911: l_submitter_user_id NUMBER;
2912: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2913: l_resource_id pa_resources_denorm.resource_id%TYPE;
2914: l_return_status VARCHAR2(1);
2915: l_project_id pa_projects_all.project_id%TYPE;
2916: TYPE object_id_tbl IS TABLE OF NUMBER
2917: INDEX BY BINARY_INTEGER;
2918: l_object_id1_tbl object_id_tbl;
2919: