DBA Data[Home] [Help]

APPS.IBU_REQ_PKG dependencies on CS_SERVICEREQUEST_PVT

Line 168: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;

164: l_msg_count NUMBER;
165: l_call_id NUMBER;
166: l_last_update_date DATE := SYSDATE;
167: l_object_version_number NUMBER;
168: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
169: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
170: x_interaction_id NUMBER;
171: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
172: l_org_id NUMBER;

Line 169: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;

165: l_call_id NUMBER;
166: l_last_update_date DATE := SYSDATE;
167: l_object_version_number NUMBER;
168: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
169: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
170: x_interaction_id NUMBER;
171: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
172: l_org_id NUMBER;
173: l_workflow_process_id NUMBER;

Line 171: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;

167: l_object_version_number NUMBER;
168: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
169: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
170: x_interaction_id NUMBER;
171: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
172: l_org_id NUMBER;
173: l_workflow_process_id NUMBER;
174: l_index BINARY_INTEGER;
175:

Line 188: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;

184: select party_type
185: from hz_parties
186: where party_id = p_party_id;
187:
188: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;
189: l_cs_auto_assignment VARCHAR2(1) := 'N';
190:
191: BEGIN
192: select OBJECT_VERSION_NUMBER

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

248: l_notes_table(1).note_detail := p_problem_detail;
249: l_notes_table(1).note_status := 'E';
250: END IF;
251:
252: CS_SERVICEREQUEST_PVT.INITIALIZE_REC(p_sr_record => l_sr_rec);
253: l_sr_rec.language := p_language;
254: if (p_status_id > 0) then
255: l_sr_rec.status_id := p_status_id;
256: end if;

Line 288: CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(

284: -- added in 11510 for auto-assignment.
285: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
286: Into l_cs_auto_assignment From dual;
287:
288: CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(
289: p_api_version => 4.0,
290: p_init_msg_list => fnd_api.g_true,
291: p_resp_id => l_responsibility_id,
292: p_commit => fnd_api.g_true,

Line 312: /* CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(

308: if (x_return_status <> 'S') then
309: decodeErrorMsg();
310: end if;
311:
312: /* CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(
313: p_api_version => 4.0,
314: p_init_msg_list => fnd_api.g_true,
315: p_resp_id => l_responsibility_id,
316: p_commit => fnd_api.g_true,

Line 523: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;

519: x_interaction_id NUMBER;
520: l_last_update_date DATE := SYSDATE;
521: l_object_version_number NUMBER := 1;
522: l_owner_id NUMBER;
523: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
524: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
525: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
526: x_workflow_process_id NUMBER;
527: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

Line 524: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;

520: l_last_update_date DATE := SYSDATE;
521: l_object_version_number NUMBER := 1;
522: l_owner_id NUMBER;
523: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
524: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
525: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
526: x_workflow_process_id NUMBER;
527: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
528: l_primary_contact_party_type VARCHAR2(30);

Line 525: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;

521: l_object_version_number NUMBER := 1;
522: l_owner_id NUMBER;
523: l_sr_rec CS_SERVICEREQUEST_PVT.service_request_rec_type;
524: l_notes_table CS_SERVICEREQUEST_PVT.notes_table;
525: l_contacts_table CS_SERVICEREQUEST_PVT.contacts_table;
526: x_workflow_process_id NUMBER;
527: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
528: l_primary_contact_party_type VARCHAR2(30);
529: l_secondary_contact_party_type VARCHAR2(30);

Line 553: l_sr_create_out_rec CS_ServiceRequest_PVT.sr_create_out_rec_type;

549: l_truncateCharNum Number := 0;
550: l_noteDetailNum number:= 0;
551: -- Made change for 11.5.10, some of the output parameters are saved
552: -- in the following recored.
553: l_sr_create_out_rec CS_ServiceRequest_PVT.sr_create_out_rec_type;
554:
555: -- added for link object enhancement
556: l_ref_object_code varchar2(30) := p_ref_object_code;
557: l_ref_object_id number := p_ref_object_id;

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

576: cat_org_id number;
577: category_id number;
578: BEGIN
579:
580: CS_SERVICEREQUEST_PVT.INITIALIZE_REC( p_sr_record => l_sr_rec);
581:
582: l_sr_rec.request_date := l_last_update_date;
583: l_sr_rec.incident_occurred_date := l_last_update_date;
584: l_sr_rec.type_id := p_type_id;

Line 1176: CS_ServiceRequest_PVT.Create_ServiceRequest(

1172: -- Fix 11815997
1173: l_sr_rec.publish_flag := 'Y';
1174:
1175:
1176: CS_ServiceRequest_PVT.Create_ServiceRequest(
1177: p_api_version => 4.0,
1178: p_init_msg_list => fnd_api.g_true,
1179: p_commit => fnd_api.g_true,
1180: p_resp_id => l_responsibility_id,