APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on CS_SERVICEREQUEST_PUB

Line 455: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

451: -- End Of Fix Bug#5007335
452:
453: l_status_name cs_incident_statuses_tl.name%type;
454: l_interaction_id NUMBER;
455: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
456: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
457: l_notes_table CS_ServiceRequest_PUB.notes_table;
458:
459: i NUMBER:=0;

Line 456: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

452:
453: l_status_name cs_incident_statuses_tl.name%type;
454: l_interaction_id NUMBER;
455: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
456: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
457: l_notes_table CS_ServiceRequest_PUB.notes_table;
458:
459: i NUMBER:=0;
460: k NUMBER:=0;

Line 457: l_notes_table CS_ServiceRequest_PUB.notes_table;

453: l_status_name cs_incident_statuses_tl.name%type;
454: l_interaction_id NUMBER;
455: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
456: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
457: l_notes_table CS_ServiceRequest_PUB.notes_table;
458:
459: i NUMBER:=0;
460: k NUMBER:=0;
461: x NUMBER:=0;

Line 839: --CS_SERVICEREQUEST_PUB.Update_ServiceRequest

835: END IF;
836: END IF; -- Child UE Check
837:
838: -- Call Service Request package to update the status.
839: --CS_SERVICEREQUEST_PUB.Update_ServiceRequest
840: OPEN c_service_details(l_service_req_id);
841: FETCH c_service_details into l_incident_id,l_incident_number,l_object_version_number;
842: CLOSE c_service_details;
843:

Line 848: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

844: OPEN c_service_status;
845: FETCH c_service_status into l_incident_status_id,l_status_name;
846: CLOSE c_service_status;
847:
848: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
849:
850: -- Assign the SR rec values
851: l_service_request_rec.status_id := l_incident_status_id;
852: --l_service_request_rec.status_name := l_status_name;

Line 854: CS_SERVICEREQUEST_PUB.Update_ServiceRequest(

850: -- Assign the SR rec values
851: l_service_request_rec.status_id := l_incident_status_id;
852: --l_service_request_rec.status_name := l_status_name;
853: /*
854: CS_SERVICEREQUEST_PUB.Update_ServiceRequest(
855: p_api_version => 3.0,
856: p_init_msg_list => FND_API.G_TRUE,
857: p_commit => FND_API.G_FALSE,
858: x_return_status => x_return_status,

Line 888: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before CS_ServiceRequest_PUB.Update_Status ');

884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886:
887: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
888: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before CS_ServiceRequest_PUB.Update_Status ');
889: END IF;
890: -- anraj changed the api
891: CS_ServiceRequest_PUB.Update_Status
892: (

Line 891: CS_ServiceRequest_PUB.Update_Status

887: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
888: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before CS_ServiceRequest_PUB.Update_Status ');
889: END IF;
890: -- anraj changed the api
891: CS_ServiceRequest_PUB.Update_Status
892: (
893: p_api_version => 2.0,
894: p_init_msg_list => FND_API.G_TRUE,
895: p_commit => FND_API.G_FALSE,

Line 920: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After CS_ServiceRequest_PUB.Update_Status - Return Status - '||x_return_status );

916: x_interaction_id => l_interaction_id
917: );
918:
919: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
920: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After CS_ServiceRequest_PUB.Update_Status - Return Status - '||x_return_status );
921: END IF;
922:
923: IF NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
924: RAISE Fnd_Api.G_EXC_ERROR;