APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on CS_SERVICEREQUEST_PUB

Line 466: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

462: -- End Of Fix Bug#5007335
463:
464: l_status_name cs_incident_statuses_tl.name%type;
465: l_interaction_id NUMBER;
466: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
467: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
468: l_notes_table CS_ServiceRequest_PUB.notes_table;
469:
470: i NUMBER:=0;

Line 467: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

463:
464: l_status_name cs_incident_statuses_tl.name%type;
465: l_interaction_id NUMBER;
466: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
467: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
468: l_notes_table CS_ServiceRequest_PUB.notes_table;
469:
470: i NUMBER:=0;
471: k NUMBER:=0;

Line 468: l_notes_table CS_ServiceRequest_PUB.notes_table;

464: l_status_name cs_incident_statuses_tl.name%type;
465: l_interaction_id NUMBER;
466: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
467: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
468: l_notes_table CS_ServiceRequest_PUB.notes_table;
469:
470: i NUMBER:=0;
471: k NUMBER:=0;
472: x NUMBER:=0;

Line 906: --CS_SERVICEREQUEST_PUB.Update_ServiceRequest

902: END IF;
903: END IF; -- Child UE Check
904:
905: -- Call Service Request package to update the status.
906: --CS_SERVICEREQUEST_PUB.Update_ServiceRequest
907: OPEN c_service_details(l_service_req_id);
908: FETCH c_service_details into l_incident_id,l_incident_number,l_object_version_number;
909: CLOSE c_service_details;
910:

Line 915: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

911: OPEN c_service_status;
912: FETCH c_service_status into l_incident_status_id,l_status_name;
913: CLOSE c_service_status;
914:
915: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
916:
917: -- Assign the SR rec values
918: l_service_request_rec.status_id := l_incident_status_id;
919: --l_service_request_rec.status_name := l_status_name;

Line 921: CS_SERVICEREQUEST_PUB.Update_ServiceRequest(

917: -- Assign the SR rec values
918: l_service_request_rec.status_id := l_incident_status_id;
919: --l_service_request_rec.status_name := l_status_name;
920: /*
921: CS_SERVICEREQUEST_PUB.Update_ServiceRequest(
922: p_api_version => 3.0,
923: p_init_msg_list => FND_API.G_TRUE,
924: p_commit => FND_API.G_FALSE,
925: x_return_status => x_return_status,

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

951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953:
954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
955: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before CS_ServiceRequest_PUB.Update_Status ');
956: END IF;
957: -- anraj changed the api
958: CS_ServiceRequest_PUB.Update_Status
959: (

Line 958: CS_ServiceRequest_PUB.Update_Status

954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
955: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before CS_ServiceRequest_PUB.Update_Status ');
956: END IF;
957: -- anraj changed the api
958: CS_ServiceRequest_PUB.Update_Status
959: (
960: p_api_version => 2.0,
961: p_init_msg_list => FND_API.G_TRUE,
962: p_commit => FND_API.G_FALSE,

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

983: x_interaction_id => l_interaction_id
984: );
985:
986: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
987: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After CS_ServiceRequest_PUB.Update_Status - Return Status - '||x_return_status );
988: END IF;
989:
990: IF NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
991: RAISE Fnd_Api.G_EXC_ERROR;