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 99: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

95: l_ata_sequence_id NUMBER;
96: l_deferral_id NUMBER;
97: l_row_id VARCHAR2(2000);
98:
99: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
100: l_notes_table CS_ServiceRequest_PUB.notes_table;
101: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
102:
103: l_inventory_item_id NUMBER;

Line 100: l_notes_table CS_ServiceRequest_PUB.notes_table;

96: l_deferral_id NUMBER;
97: l_row_id VARCHAR2(2000);
98:
99: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
100: l_notes_table CS_ServiceRequest_PUB.notes_table;
101: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
102:
103: l_inventory_item_id NUMBER;
104: l_serial_number VARCHAR2(30);

Line 101: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

97: l_row_id VARCHAR2(2000);
98:
99: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
100: l_notes_table CS_ServiceRequest_PUB.notes_table;
101: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
102:
103: l_inventory_item_id NUMBER;
104: l_serial_number VARCHAR2(30);
105: l_inv_master_org_id NUMBER;

Line 162: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

158: RAISE FND_API.G_EXC_ERROR;
159: END IF;
160:
161: -- Initialize the SR record.
162: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
163:
164: -- Assign the SR rec values
165: l_service_request_rec.request_date := trunc(sysdate);
166: IF (p_x_nonroutine_rec.incident_date IS NULL OR p_x_nonroutine_rec.incident_date = FND_API.G_MISS_DATE)

Line 211: CS_SERVICEREQUEST_PUB.Create_ServiceRequest

207: l_service_request_rec.exp_resolution_date := p_x_nonroutine_rec.expected_resolution_date;
208: l_service_request_rec.act_resolution_date := p_x_nonroutine_rec.actual_resolution_date;
209:
210: -- Call to Service Request API
211: CS_SERVICEREQUEST_PUB.Create_ServiceRequest
212: (
213: p_api_version => 3.0,
214: p_init_msg_list => FND_API.G_FALSE,
215: p_commit => FND_API.G_FALSE,

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

242: fnd_log.string
243: (
244: G_DEBUG_UEXP,
245: l_debug_module,
246: 'Call to CS_SERVICEREQUEST_PUB.Create_ServiceRequest failed...'
247: );
248: END IF;
249:
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 583: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

579: l_deferral_rec get_deferral_rec%rowtype;
580: l_deferral_id NUMBER;
581: l_row_id VARCHAR2(2000);
582:
583: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
584: l_notes_table CS_ServiceRequest_PUB.notes_table;
585: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
586:
587: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';

Line 584: l_notes_table CS_ServiceRequest_PUB.notes_table;

580: l_deferral_id NUMBER;
581: l_row_id VARCHAR2(2000);
582:
583: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
584: l_notes_table CS_ServiceRequest_PUB.notes_table;
585: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
586:
587: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
588:

Line 585: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

581: l_row_id VARCHAR2(2000);
582:
583: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
584: l_notes_table CS_ServiceRequest_PUB.notes_table;
585: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
586:
587: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
588:
589: l_workflow_process_id NUMBER ;

Line 608: -- to CS_SERVICEREQUEST_PUB.Update_ServiceRequest.

604:
605: l_contact_rec get_contact_details%rowtype;
606:
607: -- Balaji added for the bug that SR ovn is not correctly returned from the call
608: -- to CS_SERVICEREQUEST_PUB.Update_ServiceRequest.
609: -- Begin change
610: CURSOR c_get_sr_ovn(c_incident_id NUMBER)
611: IS
612: SELECT object_version_number

Line 661: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

657: RAISE FND_API.G_EXC_ERROR;
658: END IF;
659:
660: -- Initialize the SR record.
661: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
662:
663: l_service_request_rec.type_id := p_x_nonroutine_rec.type_id;
664: l_service_request_rec.status_id := p_x_nonroutine_rec.status_id;
665: -- l_service_request_rec.caller_type := p_x_nonroutine_rec.customer_type;

Line 711: CS_SERVICEREQUEST_PUB.Update_ServiceRequest

707: l_service_request_rec.exp_resolution_date := p_x_nonroutine_rec.expected_resolution_date;
708: l_service_request_rec.act_resolution_date := p_x_nonroutine_rec.actual_resolution_date;
709:
710: -- Call to Service Request API
711: CS_SERVICEREQUEST_PUB.Update_ServiceRequest
712: (
713: p_api_version => 3.0,
714: p_init_msg_list => FND_API.G_FALSE,
715: p_commit => FND_API.G_FALSE,

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

740: fnd_log.string
741: (
742: G_DEBUG_UEXP,
743: l_debug_module,
744: 'Call to CS_SERVICEREQUEST_PUB.Update_ServiceRequest failed...'
745: );
746: END IF;
747:
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1066: -- to CS_SERVICEREQUEST_PUB.Update_ServiceRequest.

1062: */
1063: END IF;
1064:
1065: -- Balaji added for the bug that SR ovn is not correctly returned from the call
1066: -- to CS_SERVICEREQUEST_PUB.Update_ServiceRequest.
1067: -- Begin change
1068: OPEN c_get_sr_ovn(p_x_nonroutine_rec.incident_id);
1069: FETCH c_get_sr_ovn INTO p_x_nonroutine_rec.incident_object_version_number;
1070: CLOSE c_get_sr_ovn;

Line 3298: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

3294: FROM ahl_unit_effectivities_b
3295: WHERE cs_incident_id = p_cs_incident_id
3296: AND status_code IS NULL;
3297:
3298: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
3299: l_notes_table CS_ServiceRequest_PUB.notes_table;
3300: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
3301: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
3302: l_auto_assign CONSTANT VARCHAR2(1) := 'N';

Line 3299: l_notes_table CS_ServiceRequest_PUB.notes_table;

3295: WHERE cs_incident_id = p_cs_incident_id
3296: AND status_code IS NULL;
3297:
3298: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
3299: l_notes_table CS_ServiceRequest_PUB.notes_table;
3300: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
3301: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
3302: l_auto_assign CONSTANT VARCHAR2(1) := 'N';
3303:

Line 3300: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

3296: AND status_code IS NULL;
3297:
3298: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
3299: l_notes_table CS_ServiceRequest_PUB.notes_table;
3300: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
3301: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
3302: l_auto_assign CONSTANT VARCHAR2(1) := 'N';
3303:
3304: l_return_status VARCHAR2(1);

Line 3378: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

3374: END IF;
3375: CLOSE get_urgency_details_csr;
3376:
3377: -- Update SR for the urgency and exp. resolution date.
3378: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
3379:
3380: --l_service_request_rec.incident_id := p_cs_incident_id;
3381: --l_service_request_rec.object_version_number := l_inc_rec.object_version_number;
3382: l_service_request_rec.urgency_id := l_sr_urgency_id;

Line 3388: CS_SERVICEREQUEST_PUB.Update_ServiceRequest

3384: l_service_request_rec.exp_resolution_date := l_inc_rec.incident_occurred_date + trunc(l_repair_time/24);
3385: END IF;
3386:
3387: -- Call SR API.
3388: CS_SERVICEREQUEST_PUB.Update_ServiceRequest
3389: (
3390: p_api_version => 3.0,
3391: p_init_msg_list => FND_API.G_FALSE,
3392: p_commit => FND_API.G_FALSE,

Line 3457: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

3453: END IF;
3454: CLOSE default_incident_type_csr;
3455:
3456: --Initialize the SR record.
3457: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
3458:
3459: -- Assign the SR rec values
3460: l_service_request_rec.type_id := l_incident_type_id;
3461: l_service_request_rec.request_date := sysdate;

Line 3494: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(

3490: END IF;
3491:
3492: -- Call to Service Request API
3493:
3494: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(
3495: p_api_version => 3.0,
3496: p_init_msg_list => FND_API.G_TRUE,
3497: p_commit => FND_API.G_FALSE,
3498: x_return_status => l_return_status,