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.AHL_UMP_NONROUTINES_PVT dependencies on CS_SERVICEREQUEST_PUB

Line 106: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

102: l_ata_sequence_id NUMBER;
103: l_deferral_id NUMBER;
104: l_row_id VARCHAR2(2000);
105:
106: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
107: l_notes_table CS_ServiceRequest_PUB.notes_table;
108: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
109:
110: l_inventory_item_id NUMBER;

Line 107: l_notes_table CS_ServiceRequest_PUB.notes_table;

103: l_deferral_id NUMBER;
104: l_row_id VARCHAR2(2000);
105:
106: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
107: l_notes_table CS_ServiceRequest_PUB.notes_table;
108: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
109:
110: l_inventory_item_id NUMBER;
111: l_serial_number VARCHAR2(30);

Line 108: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

104: l_row_id VARCHAR2(2000);
105:
106: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
107: l_notes_table CS_ServiceRequest_PUB.notes_table;
108: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
109:
110: l_inventory_item_id NUMBER;
111: l_serial_number VARCHAR2(30);
112: l_inv_master_org_id NUMBER;

Line 170: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

166: RAISE FND_API.G_EXC_ERROR;
167: END IF;
168:
169: -- Initialize the SR record.
170: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
171:
172: -- Assign the SR rec values
173: l_service_request_rec.request_date := sysdate;
174: IF (p_x_nonroutine_rec.incident_date IS NULL OR p_x_nonroutine_rec.incident_date = FND_API.G_MISS_DATE)

Line 241: CS_SERVICEREQUEST_PUB.Create_ServiceRequest

237: l_service_request_rec.exp_resolution_date := p_x_nonroutine_rec.expected_resolution_date;
238: l_service_request_rec.act_resolution_date := p_x_nonroutine_rec.actual_resolution_date;
239:
240: -- Call to Service Request API
241: CS_SERVICEREQUEST_PUB.Create_ServiceRequest
242: (
243: p_api_version => 3.0,
244: p_init_msg_list => FND_API.G_FALSE,
245: p_commit => FND_API.G_FALSE,

Line 276: 'Call to CS_SERVICEREQUEST_PUB.Create_ServiceRequest failed...'

272: fnd_log.string
273: (
274: G_DEBUG_UEXP,
275: l_debug_module,
276: 'Call to CS_SERVICEREQUEST_PUB.Create_ServiceRequest failed...'
277: );
278: END IF;
279:
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 640: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

636: l_deferral_rec get_deferral_rec%rowtype;
637: l_deferral_id NUMBER;
638: l_row_id VARCHAR2(2000);
639:
640: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
641: l_notes_table CS_ServiceRequest_PUB.notes_table;
642: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
643:
644: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';

Line 641: l_notes_table CS_ServiceRequest_PUB.notes_table;

637: l_deferral_id NUMBER;
638: l_row_id VARCHAR2(2000);
639:
640: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
641: l_notes_table CS_ServiceRequest_PUB.notes_table;
642: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
643:
644: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
645:

Line 642: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

638: l_row_id VARCHAR2(2000);
639:
640: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
641: l_notes_table CS_ServiceRequest_PUB.notes_table;
642: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
643:
644: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
645:
646: l_workflow_process_id NUMBER ;

Line 665: -- to CS_SERVICEREQUEST_PUB.Update_ServiceRequest.

661:
662: l_contact_rec get_contact_details%rowtype;
663:
664: -- Balaji added for the bug that SR ovn is not correctly returned from the call
665: -- to CS_SERVICEREQUEST_PUB.Update_ServiceRequest.
666: -- Begin change
667: CURSOR c_get_sr_ovn(c_incident_id NUMBER)
668: IS
669: SELECT object_version_number

Line 718: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
717: -- Initialize the SR record.
718: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
719:
720: l_service_request_rec.type_id := p_x_nonroutine_rec.type_id;
721: l_service_request_rec.status_id := p_x_nonroutine_rec.status_id;
722: -- l_service_request_rec.caller_type := p_x_nonroutine_rec.customer_type;

Line 790: CS_SERVICEREQUEST_PUB.Update_ServiceRequest

786: l_service_request_rec.exp_resolution_date := p_x_nonroutine_rec.expected_resolution_date;
787: l_service_request_rec.act_resolution_date := p_x_nonroutine_rec.actual_resolution_date;
788:
789: -- Call to Service Request API
790: CS_SERVICEREQUEST_PUB.Update_ServiceRequest
791: (
792: p_api_version => 3.0,
793: p_init_msg_list => FND_API.G_FALSE,
794: p_commit => FND_API.G_FALSE,

Line 823: 'Call to CS_SERVICEREQUEST_PUB.Update_ServiceRequest failed...'

819: fnd_log.string
820: (
821: G_DEBUG_UEXP,
822: l_debug_module,
823: 'Call to CS_SERVICEREQUEST_PUB.Update_ServiceRequest failed...'
824: );
825: END IF;
826:
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1149: -- to CS_SERVICEREQUEST_PUB.Update_ServiceRequest.

1145: */
1146: END IF;
1147:
1148: -- Balaji added for the bug that SR ovn is not correctly returned from the call
1149: -- to CS_SERVICEREQUEST_PUB.Update_ServiceRequest.
1150: -- Begin change
1151: OPEN c_get_sr_ovn(p_x_nonroutine_rec.incident_id);
1152: FETCH c_get_sr_ovn INTO p_x_nonroutine_rec.incident_object_version_number;
1153: CLOSE c_get_sr_ovn;

Line 3472: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

3468: FROM ahl_unit_effectivities_b
3469: WHERE cs_incident_id = p_cs_incident_id
3470: AND status_code IS NULL;
3471:
3472: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
3473: l_notes_table CS_ServiceRequest_PUB.notes_table;
3474: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
3475: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
3476: l_auto_assign CONSTANT VARCHAR2(1) := 'N';

Line 3473: l_notes_table CS_ServiceRequest_PUB.notes_table;

3469: WHERE cs_incident_id = p_cs_incident_id
3470: AND status_code IS NULL;
3471:
3472: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
3473: l_notes_table CS_ServiceRequest_PUB.notes_table;
3474: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
3475: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
3476: l_auto_assign CONSTANT VARCHAR2(1) := 'N';
3477:

Line 3474: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

3470: AND status_code IS NULL;
3471:
3472: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
3473: l_notes_table CS_ServiceRequest_PUB.notes_table;
3474: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
3475: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
3476: l_auto_assign CONSTANT VARCHAR2(1) := 'N';
3477:
3478: l_return_status VARCHAR2(1);

Line 3558: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

3554: END IF;
3555: CLOSE get_urgency_details_csr;
3556:
3557: -- Update SR for the urgency and exp. resolution date.
3558: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
3559:
3560: --l_service_request_rec.incident_id := p_cs_incident_id;
3561: --l_service_request_rec.object_version_number := l_inc_rec.object_version_number;
3562: l_service_request_rec.urgency_id := l_sr_urgency_id;

Line 3568: CS_SERVICEREQUEST_PUB.Update_ServiceRequest

3564: l_service_request_rec.exp_resolution_date := l_inc_rec.incident_occurred_date + trunc(l_repair_time/24);
3565: END IF;
3566:
3567: -- Call SR API.
3568: CS_SERVICEREQUEST_PUB.Update_ServiceRequest
3569: (
3570: p_api_version => 3.0,
3571: p_init_msg_list => FND_API.G_FALSE,
3572: p_commit => FND_API.G_FALSE,

Line 3661: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

3657: END IF;
3658: CLOSE default_incident_type_csr;
3659:
3660: --Initialize the SR record.
3661: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
3662:
3663: -- Assign the SR rec values
3664: l_service_request_rec.type_id := l_incident_type_id;
3665: -- initialized later below based on incident_occurred_date to fix bug# 7697685

Line 3707: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(

3703: END IF;
3704:
3705: -- Call to Service Request API
3706:
3707: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(
3708: p_api_version => 3.0,
3709: p_init_msg_list => FND_API.G_TRUE,
3710: p_commit => FND_API.G_FALSE,
3711: x_return_status => l_return_status,