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.EAM_SRAPPROVAL_PVT dependencies on CS_INCIDENTS_ALL_B

Line 15: l_incident_number cs_incidents_all_b.incident_number%type;

11: itemtype varchar2(30);
12: itemkey varchar2(30) ;
13: l_application_id NUMBER;
14: l_application_code varchar2(32);
15: l_incident_number cs_incidents_all_b.incident_number%type;
16: l_incident_id cs_incidents_all_b.incident_id%type;
17:
18: l_owning_department_id cs_incidents_all_b.owning_department_id%type;
19: l_owning_department_code bom_departments.department_code%type;

Line 16: l_incident_id cs_incidents_all_b.incident_id%type;

12: itemkey varchar2(30) ;
13: l_application_id NUMBER;
14: l_application_code varchar2(32);
15: l_incident_number cs_incidents_all_b.incident_number%type;
16: l_incident_id cs_incidents_all_b.incident_id%type;
17:
18: l_owning_department_id cs_incidents_all_b.owning_department_id%type;
19: l_owning_department_code bom_departments.department_code%type;
20: l_owning_department_role varchar2(80);

Line 18: l_owning_department_id cs_incidents_all_b.owning_department_id%type;

14: l_application_code varchar2(32);
15: l_incident_number cs_incidents_all_b.incident_number%type;
16: l_incident_id cs_incidents_all_b.incident_id%type;
17:
18: l_owning_department_id cs_incidents_all_b.owning_department_id%type;
19: l_owning_department_code bom_departments.department_code%type;
20: l_owning_department_role varchar2(80);
21: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;
22: l_maintenance_flag varchar2(1);

Line 21: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;

17:
18: l_owning_department_id cs_incidents_all_b.owning_department_id%type;
19: l_owning_department_code bom_departments.department_code%type;
20: l_owning_department_role varchar2(80);
21: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;
22: l_maintenance_flag varchar2(1);
23: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%type;
24: l_conc_segments_description mtl_system_items.description%type;
25:

Line 37: l_incident_status_id cs_incidents_all_b.incident_status_id%type;

33: l_incident_date date;
34: l_expected_resolution_date date;
35: l_default_department_id wip_eam_parameters.default_department_id%type;
36: l_return_status varchar2(240);
37: l_incident_status_id cs_incidents_all_b.incident_status_id%type;
38: l_incident_severity_id cs_incidents_all_b.incident_severity_id%type;
39: l_customer_id cs_incidents_all_b.customer_id%type;
40: l_service_rec cs_servicerequest_pub.service_request_rec_type;
41: l_sr_user_id number;

Line 38: l_incident_severity_id cs_incidents_all_b.incident_severity_id%type;

34: l_expected_resolution_date date;
35: l_default_department_id wip_eam_parameters.default_department_id%type;
36: l_return_status varchar2(240);
37: l_incident_status_id cs_incidents_all_b.incident_status_id%type;
38: l_incident_severity_id cs_incidents_all_b.incident_severity_id%type;
39: l_customer_id cs_incidents_all_b.customer_id%type;
40: l_service_rec cs_servicerequest_pub.service_request_rec_type;
41: l_sr_user_id number;
42: l_sr_resp_id number;

Line 39: l_customer_id cs_incidents_all_b.customer_id%type;

35: l_default_department_id wip_eam_parameters.default_department_id%type;
36: l_return_status varchar2(240);
37: l_incident_status_id cs_incidents_all_b.incident_status_id%type;
38: l_incident_severity_id cs_incidents_all_b.incident_severity_id%type;
39: l_customer_id cs_incidents_all_b.customer_id%type;
40: l_service_rec cs_servicerequest_pub.service_request_rec_type;
41: l_sr_user_id number;
42: l_sr_resp_id number;
43: l_sr_resp_appl_id number;

Line 57: l_maint_organization_id cs_incidents_all_b.maint_organization_id%type;

53: l_workflow_process varchar2(30);
54: l_instance_id number;
55: l_instance_number varchar2(30);
56: l_instance_description csi_item_instances.instance_description%type;
57: l_maint_organization_id cs_incidents_all_b.maint_organization_id%type;
58: begin
59:
60: itemtype := 'EAMSRAPR';
61: l_sr_api_version := 3.0;

Line 288: l_incident_number cs_incidents_all_b.incident_number%type;

284: itemtype varchar2(30);
285: itemkey varchar2(30) ;
286: l_application_id NUMBER;
287: l_application_code varchar2(32);
288: l_incident_number cs_incidents_all_b.incident_number%type;
289: l_incident_id cs_incidents_all_b.incident_id%type;
290:
291: l_owning_department_id cs_incidents_all_b.owning_department_id%type;
292: l_owning_department_code bom_departments.department_code%type;

Line 289: l_incident_id cs_incidents_all_b.incident_id%type;

285: itemkey varchar2(30) ;
286: l_application_id NUMBER;
287: l_application_code varchar2(32);
288: l_incident_number cs_incidents_all_b.incident_number%type;
289: l_incident_id cs_incidents_all_b.incident_id%type;
290:
291: l_owning_department_id cs_incidents_all_b.owning_department_id%type;
292: l_owning_department_code bom_departments.department_code%type;
293: l_owning_department_role varchar2(80);

Line 291: l_owning_department_id cs_incidents_all_b.owning_department_id%type;

287: l_application_code varchar2(32);
288: l_incident_number cs_incidents_all_b.incident_number%type;
289: l_incident_id cs_incidents_all_b.incident_id%type;
290:
291: l_owning_department_id cs_incidents_all_b.owning_department_id%type;
292: l_owning_department_code bom_departments.department_code%type;
293: l_owning_department_role varchar2(80);
294: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;
295: l_maintenance_flag varchar2(1);

Line 294: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;

290:
291: l_owning_department_id cs_incidents_all_b.owning_department_id%type;
292: l_owning_department_code bom_departments.department_code%type;
293: l_owning_department_role varchar2(80);
294: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;
295: l_maintenance_flag varchar2(1);
296: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%type;
297: l_conc_segments_description mtl_system_items.description%type ;
298:

Line 310: l_incident_status_id cs_incidents_all_b.incident_status_id%type;

306: l_incident_date date;
307: l_expected_resolution_date date;
308: l_default_department_id wip_eam_parameters.default_department_id%type;
309: l_return_status varchar2(240);
310: l_incident_status_id cs_incidents_all_b.incident_status_id%type;
311: l_incident_severity_id cs_incidents_all_b.incident_severity_id%type;
312: l_customer_id cs_incidents_all_b.customer_id%type;
313: l_service_rec cs_servicerequest_pub.service_request_rec_type;
314: l_sr_user_id number;

Line 311: l_incident_severity_id cs_incidents_all_b.incident_severity_id%type;

307: l_expected_resolution_date date;
308: l_default_department_id wip_eam_parameters.default_department_id%type;
309: l_return_status varchar2(240);
310: l_incident_status_id cs_incidents_all_b.incident_status_id%type;
311: l_incident_severity_id cs_incidents_all_b.incident_severity_id%type;
312: l_customer_id cs_incidents_all_b.customer_id%type;
313: l_service_rec cs_servicerequest_pub.service_request_rec_type;
314: l_sr_user_id number;
315: l_sr_resp_id number;

Line 312: l_customer_id cs_incidents_all_b.customer_id%type;

308: l_default_department_id wip_eam_parameters.default_department_id%type;
309: l_return_status varchar2(240);
310: l_incident_status_id cs_incidents_all_b.incident_status_id%type;
311: l_incident_severity_id cs_incidents_all_b.incident_severity_id%type;
312: l_customer_id cs_incidents_all_b.customer_id%type;
313: l_service_rec cs_servicerequest_pub.service_request_rec_type;
314: l_sr_user_id number;
315: l_sr_resp_id number;
316: l_sr_resp_appl_id number;

Line 331: l_prev_summary cs_incidents_all_b.summary%type;

327: l_prev_severity_id number;
328: l_prev_type_id number;
329: l_prev_status_id number;
330: l_prev_urgency_id number;
331: l_prev_summary cs_incidents_all_b.summary%type;
332: l_request_status_old number;
333: l_prev_owner_id number;
334: End Commented for Bug 4488769*/
335: l_instance_id number;

Line 338: l_maint_organization_id cs_incidents_all_b.maint_organization_id%type;

334: End Commented for Bug 4488769*/
335: l_instance_id number;
336: l_instance_number varchar2(30);
337: l_instance_description csi_item_instances.instance_description%type;
338: l_maint_organization_id cs_incidents_all_b.maint_organization_id%type;
339:
340: begin
341: itemtype := 'EAMSRAPR';
342: l_sr_api_version := 3.0;