DBA Data[Home] [Help]

APPS.IBU_REQ_PKG dependencies on CS_SERVICEREQUEST_PVT

Line 156: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;

152: l_msg_count NUMBER;
153: l_call_id NUMBER;
154: l_last_update_date DATE := SYSDATE;
155: l_object_version_number NUMBER;
156: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
157: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
158: x_interaction_id NUMBER;
159: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
160: l_org_id NUMBER;

Line 157: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;

153: l_call_id NUMBER;
154: l_last_update_date DATE := SYSDATE;
155: l_object_version_number NUMBER;
156: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
157: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
158: x_interaction_id NUMBER;
159: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
160: l_org_id NUMBER;
161: l_workflow_process_id NUMBER;

Line 159: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;

155: l_object_version_number NUMBER;
156: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
157: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
158: x_interaction_id NUMBER;
159: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
160: l_org_id NUMBER;
161: l_workflow_process_id NUMBER;
162: l_index BINARY_INTEGER;
163:

Line 176: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;

172: select party_type
173: from hz_parties
174: where party_id = p_party_id;
175:
176: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;
177: l_cs_auto_assignment VARCHAR2(1) := 'N';
178:
179: BEGIN
180: select OBJECT_VERSION_NUMBER

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

231: l_notes_table(1).note_detail := p_problem_detail;
232: l_notes_table(1).note_status := 'E';
233: END IF;
234:
235: CS_SERVICEREQUEST_PVT.INITIALIZE_REC(p_sr_record => l_sr_rec);
236: l_sr_rec.language := p_language;
237: if (p_status_id > 0) then
238: l_sr_rec.status_id := p_status_id;
239: end if;

Line 271: CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(

267: -- added in 11510 for auto-assignment.
268: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
269: Into l_cs_auto_assignment From dual;
270:
271: CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(
272: p_api_version => 4.0,
273: p_init_msg_list => fnd_api.g_true,
274: p_resp_id => l_responsibility_id,
275: p_commit => fnd_api.g_true,

Line 295: /* CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(

291: if (x_return_status <> 'S') then
292: decodeErrorMsg();
293: end if;
294:
295: /* CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(
296: p_api_version => 4.0,
297: p_init_msg_list => fnd_api.g_true,
298: p_resp_id => l_responsibility_id,
299: p_commit => fnd_api.g_true,

Line 499: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;

495: x_interaction_id NUMBER;
496: l_last_update_date DATE := SYSDATE;
497: l_object_version_number NUMBER := 1;
498: l_owner_id NUMBER;
499: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
500: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
501: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
502: x_workflow_process_id NUMBER;
503: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

Line 500: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;

496: l_last_update_date DATE := SYSDATE;
497: l_object_version_number NUMBER := 1;
498: l_owner_id NUMBER;
499: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
500: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
501: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
502: x_workflow_process_id NUMBER;
503: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
504: l_primary_contact_party_type VARCHAR2(30);

Line 501: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;

497: l_object_version_number NUMBER := 1;
498: l_owner_id NUMBER;
499: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
500: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
501: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
502: x_workflow_process_id NUMBER;
503: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
504: l_primary_contact_party_type VARCHAR2(30);
505: l_secondary_contact_party_type VARCHAR2(30);

Line 529: l_sr_create_out_rec CS_ServiceRequest_PVT.sr_create_out_rec_type;

525: l_truncateCharNum Number := 0;
526: l_noteDetailNum number:= 0;
527: -- Made change for 11.5.10, some of the output parameters are saved
528: -- in the following recored.
529: l_sr_create_out_rec CS_ServiceRequest_PVT.sr_create_out_rec_type;
530:
531: -- added for link object enhancement
532: l_ref_object_code varchar2(30) := p_ref_object_code;
533: l_ref_object_id number := p_ref_object_id;

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

547: lx_link_id number;
548: l_dbg_msg varchar2(4000);
549: BEGIN
550:
551: CS_SERVICEREQUEST_PVT.INITIALIZE_REC( p_sr_record => l_sr_rec);
552:
553: l_sr_rec.request_date := l_last_update_date;
554: l_sr_rec.incident_occurred_date := l_last_update_date;
555: l_sr_rec.type_id := p_type_id;

Line 1093: CS_ServiceRequest_PVT.Create_ServiceRequest(

1089: from dual;
1090: -- added for 11.5.10
1091: l_default_coverage_temp_id := fnd_profile.value('CS_SR_DEFAULT_COVERAGE');
1092:
1093: CS_ServiceRequest_PVT.Create_ServiceRequest(
1094: p_api_version => 4.0,
1095: p_init_msg_list => fnd_api.g_true,
1096: p_commit => fnd_api.g_true,
1097: p_resp_id => l_responsibility_id,