APPS.CS_SR_MASS_UPDATE_PKG dependencies on CS_SERVICEREQUEST_PVT

Line 26: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;

22: x_msg_count NUMBER;
23: x_msg_data VARCHAR2(2000);
24: l_last_update_date DATE := SYSDATE;
25: l_object_version_number NUMBER;
26: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
27: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
28: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
29: l_validate_sr_closure VARCHAR2(1) := 'N';
30: l_auto_close_child_entities VARCHAR2(1) := 'N';

Line 27: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;

23: x_msg_data VARCHAR2(2000);
24: l_last_update_date DATE := SYSDATE;
25: l_object_version_number NUMBER;
26: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
27: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
28: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
29: l_validate_sr_closure VARCHAR2(1) := 'N';
30: l_auto_close_child_entities VARCHAR2(1) := 'N';
31: l_temp_close_value VARCHAR2(100);

Line 28: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;

24: l_last_update_date DATE := SYSDATE;
25: l_object_version_number NUMBER;
26: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
27: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
28: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
29: l_validate_sr_closure VARCHAR2(1) := 'N';
30: l_auto_close_child_entities VARCHAR2(1) := 'N';
31: l_temp_close_value VARCHAR2(100);
32: l_responsibility_id NUMBER;

Line 33: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;

29: l_validate_sr_closure VARCHAR2(1) := 'N';
30: l_auto_close_child_entities VARCHAR2(1) := 'N';
31: l_temp_close_value VARCHAR2(100);
32: l_responsibility_id NUMBER;
33: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;
34: l_cs_auto_assignment VARCHAR2(1) := 'N';
35: p_auto_assign VARCHAR2(1) := 'N';
36: l_data varchar2(2000);
37: l_msg_index number := 1;

Line 63: CS_SERVICEREQUEST_PVT.INITIALIZE_REC(p_sr_record => l_sr_rec);

59: x_param_incident_id := CS_KB_NUMBER_TBL_TYPE();
60: x_param_status := JTF_VARCHAR2_TABLE_4000();
61: x_param_msg_data := JTF_VARCHAR2_TABLE_4000();
62:
63: CS_SERVICEREQUEST_PVT.INITIALIZE_REC(p_sr_record => l_sr_rec);
64:
65: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_FORMS'), 'N')
66: Into l_cs_auto_assignment From dual;
67:

Line 137: CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(

133: into l_object_version_number
134: from CS_INCIDENTS_ALL_B
135: where INCIDENT_ID = p_incident_id_arr(i);
136:
137: CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(
138: p_api_version => 4.0,
139: p_init_msg_list => fnd_api.g_true,
140: p_resp_id => l_responsibility_id,
141: p_commit => fnd_api.g_true,