130: l_initiator_role VARCHAR2(100);
131:
132: -- For audit record
133: -- This is obsolete. rmanabat 11/21/02
134: --l_change_flags_rec CS_ServiceRequest_PVT.audit_flags_rec_type;
135:
136: l_service_request_rec CS_ServiceRequest_PVT.service_request_rec_type;
137: l_notes CS_SERVICEREQUEST_PVT.notes_table;
138: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
132: -- For audit record
133: -- This is obsolete. rmanabat 11/21/02
134: --l_change_flags_rec CS_ServiceRequest_PVT.audit_flags_rec_type;
135:
136: l_service_request_rec CS_ServiceRequest_PVT.service_request_rec_type;
137: l_notes CS_SERVICEREQUEST_PVT.notes_table;
138: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
139: l_object_version_number number;
140: l_interaction_id number;
133: -- This is obsolete. rmanabat 11/21/02
134: --l_change_flags_rec CS_ServiceRequest_PVT.audit_flags_rec_type;
135:
136: l_service_request_rec CS_ServiceRequest_PVT.service_request_rec_type;
137: l_notes CS_SERVICEREQUEST_PVT.notes_table;
138: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
139: l_object_version_number number;
140: l_interaction_id number;
141:
134: --l_change_flags_rec CS_ServiceRequest_PVT.audit_flags_rec_type;
135:
136: l_service_request_rec CS_ServiceRequest_PVT.service_request_rec_type;
137: l_notes CS_SERVICEREQUEST_PVT.notes_table;
138: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
139: l_object_version_number number;
140: l_interaction_id number;
141:
142:
445:
446: -- Insert audit record
447: l_change_flags_rec.new_workflow := FND_API.G_TRUE;
448:
449: CS_ServiceRequest_PVT.Create_Audit_Record (
450: p_api_version => 2.0,
451: p_init_msg_list => FND_API.G_FALSE,
452: p_commit => FND_API.G_FALSE,
453: x_return_status => l_return_status,
473: /**** the service request's workflow process id. This therefore ****/
474: /**** will not create an audit record for this update. Also, ****/
475: /**** the update API does not handle the p_called_by_workflow ****/
476: /**** anymore. rmanabat 032403 ****/
477: -- CS_ServiceRequest_PVT.initialize_rec(l_service_request_rec);
478:
479: -- NOtes :
480: -- We do not pass p-commit to true to the update SR, since
481: -- we are explicitly doing a commit here
501: /**** the update API does not handle the p_called_by_workflow ****/
502: /**** anymore. rmanabat 032403 ****/
503:
504: /******************
505: CS_ServiceRequest_PVT.Update_ServiceRequest
506: ( p_api_version => 3.0, -- Changed from 2.0 for 11.5.9
507: p_init_msg_list => fnd_api.g_false,
508: p_commit => fnd_api.g_false,
509: p_validation_level => fnd_api.g_valid_level_full,