APPS.CS_SR_CHILD_AUDIT_PKG dependencies on CS_SERVICEREQUEST_PVT

Line 126: l_notes CS_SERVICEREQUEST_PVT.notes_table;

122:
123: e_auditing_child_updates EXCEPTION ;
124:
125: l_object_version_number cs_incidents_all_b.object_version_number%TYPE;
126: l_notes CS_SERVICEREQUEST_PVT.notes_table;
127: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
128: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
129: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;
130: l_incident_number VARCHAR2(64); -- Bug 7040105

Line 127: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;

123: e_auditing_child_updates EXCEPTION ;
124:
125: l_object_version_number cs_incidents_all_b.object_version_number%TYPE;
126: l_notes CS_SERVICEREQUEST_PVT.notes_table;
127: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
128: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
129: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;
130: l_incident_number VARCHAR2(64); -- Bug 7040105
131: l_incident_type_id NUMBER;

Line 128: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;

124:
125: l_object_version_number cs_incidents_all_b.object_version_number%TYPE;
126: l_notes CS_SERVICEREQUEST_PVT.notes_table;
127: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
128: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
129: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;
130: l_incident_number VARCHAR2(64); -- Bug 7040105
131: l_incident_type_id NUMBER;
132: l_incident_status_id NUMBER;

Line 129: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;

125: l_object_version_number cs_incidents_all_b.object_version_number%TYPE;
126: l_notes CS_SERVICEREQUEST_PVT.notes_table;
127: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
128: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
129: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;
130: l_incident_number VARCHAR2(64); -- Bug 7040105
131: l_incident_type_id NUMBER;
132: l_incident_status_id NUMBER;
133: l_incident_severity_id NUMBER;

Line 509: CS_ServiceRequest_pvt.initialize_rec(l_service_request_rec);

505:
506: --Bug fix 6158138.Added by bkanimoz on 06-Aug-2007
507: --start
508:
509: CS_ServiceRequest_pvt.initialize_rec(l_service_request_rec);
510: /*
511: select object_version_number
512: into l_object_version_number
513: from cs_incidents_all_b

Line 517: CS_ServiceRequest_pvt.Update_ServiceRequest(

513: from cs_incidents_all_b
514: where incident_id =l_incident_id;
515:
516:
517: CS_ServiceRequest_pvt.Update_ServiceRequest(
518: p_api_version => 4.0,
519: p_init_msg_list => 'T',
520: p_commit => 'T',
521: p_validation_level => fnd_api.g_valid_level_none,

Line 671: l_audit_vals_rec CS_ServiceRequest_PVT.sr_audit_rec_type ;

667: x_msg_count OUT NOCOPY NUMBER,
668: x_msg_data OUT NOCOPY VARCHAR2
669: ) IS
670:
671: l_audit_vals_rec CS_ServiceRequest_PVT.sr_audit_rec_type ;
672: l_incident_last_modified_date DATE ;
673: l_service_request_rec CS_INCIDENTS_ALL_B%ROWTYPE;
674: --l_return_status VARCHAR2(30) ;
675:

Line 732: CS_ServiceRequest_PVT.Initialize_audit_rec( p_sr_audit_record => l_audit_vals_rec) ;

728: -- Populate Audit Record structure
729:
730: -- Initialize Audit record
731:
732: CS_ServiceRequest_PVT.Initialize_audit_rec( p_sr_audit_record => l_audit_vals_rec) ;
733:
734:
735: -- Added for owner update --anmukher --10/16/03
736: IF p_owner_status_upd_flag = 'OWNER' THEN

Line 1252: -- Call CS_ServiceRequest_PVT.Create_Audit_Record API to create SR Audit record.

1248: -- audit component R12 project
1249: l_audit_vals_rec.OLD_MAINT_ORGANIZATION_ID := l_service_request_rec.MAINT_ORGANIZATION_ID ;
1250: l_audit_vals_rec.MAINT_ORGANIZATION_ID := l_service_request_rec.MAINT_ORGANIZATION_ID ;
1251:
1252: -- Call CS_ServiceRequest_PVT.Create_Audit_Record API to create SR Audit record.
1253:
1254: CS_ServiceRequest_PVT.Create_Audit_Record (
1255: p_api_version => 2.0,
1256: p_init_msg_list => FND_API.G_FALSE ,

Line 1254: CS_ServiceRequest_PVT.Create_Audit_Record (

1250: l_audit_vals_rec.MAINT_ORGANIZATION_ID := l_service_request_rec.MAINT_ORGANIZATION_ID ;
1251:
1252: -- Call CS_ServiceRequest_PVT.Create_Audit_Record API to create SR Audit record.
1253:
1254: CS_ServiceRequest_PVT.Create_Audit_Record (
1255: p_api_version => 2.0,
1256: p_init_msg_list => FND_API.G_FALSE ,
1257: p_commit => FND_API.G_FALSE ,
1258: p_request_id => p_incident_id ,