DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on CS_SERVICEREQUEST_PVT

Line 27: l_sr_rec CS_ServiceRequest_PVT.service_request_rec_type ;

23: p_incident_severity5_id IN NUMBER
24: ) IS
25:
26: -- Define Local Variables
27: l_sr_rec CS_ServiceRequest_PVT.service_request_rec_type ;
28: l_temp_owner_group_id NUMBER ;
29: l_temp_owner_id NUMBER ;
30: l_temp_owner_type VARCHAR2(30);
31: l_return_status VARCHAR2(1) := NULL ;

Line 241: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

237: p_commit IN VARCHAR2,
238: p_incident_id IN NUMBER,
239: p_object_version_number IN NUMBER,
240: p_last_updated_by IN VARCHAR2,
241: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,
242: x_owner_group_id OUT NOCOPY NUMBER,
243: x_owner_id OUT NOCOPY NUMBER,
244: x_owner_type OUT NOCOPY VARCHAR2,
245: x_return_status OUT NOCOPY VARCHAR2,

Line 256: l_sr_rec CS_ServiceRequest_PVT.service_request_rec_type DEFAULT p_service_request_rec;

252: l_api_version CONSTANT NUMBER := 1.0;
253: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
254: l_return_status VARCHAR2(1) := null;
255:
256: l_sr_rec CS_ServiceRequest_PVT.service_request_rec_type DEFAULT p_service_request_rec;
257:
258: BEGIN
259: -- Initialize API return status to success
260: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 299: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

295: p_commit IN VARCHAR2,
296: p_incident_id IN NUMBER,
297: p_object_version_number IN NUMBER,
298: p_last_updated_by IN VARCHAR2,
299: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,
300: x_owner_group_id OUT NOCOPY NUMBER,
301: x_owner_type OUT NOCOPY VARCHAR2,
302: x_owner_id OUT NOCOPY NUMBER,
303: x_return_status OUT NOCOPY VARCHAR2,

Line 337: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;

333: l_update_own_flag VARCHAR2(1) := 'N';
334: l_interaction_id NUMBER;
335: l_workflow_process_id NUMBER;
336:
337: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
338: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
339: l_notes_table CS_ServiceRequest_pvt.notes_table;
340: l_contacts_table CS_ServiceRequest_pvt.contacts_table;
341: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;

Line 338: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;

334: l_interaction_id NUMBER;
335: l_workflow_process_id NUMBER;
336:
337: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
338: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
339: l_notes_table CS_ServiceRequest_pvt.notes_table;
340: l_contacts_table CS_ServiceRequest_pvt.contacts_table;
341: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;
342: l_object_version_number NUMBER := p_object_version_number;

Line 339: l_notes_table CS_ServiceRequest_pvt.notes_table;

335: l_workflow_process_id NUMBER;
336:
337: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
338: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
339: l_notes_table CS_ServiceRequest_pvt.notes_table;
340: l_contacts_table CS_ServiceRequest_pvt.contacts_table;
341: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;
342: l_object_version_number NUMBER := p_object_version_number;
343:

Line 340: l_contacts_table CS_ServiceRequest_pvt.contacts_table;

336:
337: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
338: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
339: l_notes_table CS_ServiceRequest_pvt.notes_table;
340: l_contacts_table CS_ServiceRequest_pvt.contacts_table;
341: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;
342: l_object_version_number NUMBER := p_object_version_number;
343:
344: -- List of Cursors used

Line 341: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;

337: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
338: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
339: l_notes_table CS_ServiceRequest_pvt.notes_table;
340: l_contacts_table CS_ServiceRequest_pvt.contacts_table;
341: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;
342: l_object_version_number NUMBER := p_object_version_number;
343:
344: -- List of Cursors used
345: CURSOR c_inv_comp_id(p_component_id NUMBER) IS

Line 562: CS_ServiceRequest_pvt.initialize_rec(l_service_request_rec);

558: -- and resource_type. If a group_id is not returned by AM API then
559: -- do not do any updates
560: -- initialise
561:
562: CS_ServiceRequest_pvt.initialize_rec(l_service_request_rec);
563:
564: l_service_request_rec.group_type := l_default_group_type;
565: IF (l_sr_rec.owner_group_id IS NULL) THEN
566: l_service_request_rec.owner_group_id := l_group_id;

Line 581: CS_ServiceRequest_pvt.Update_ServiceRequest(

577: --SRAMCONC is the lookup code for auto-assignment conc. pgm.
578: l_service_request_rec.last_update_program_code := 'SRAMCONC';
579: l_service_request_rec.territory_id := l_territory_id;
580:
581: CS_ServiceRequest_pvt.Update_ServiceRequest(
582: p_api_version => 4.0,
583: p_init_msg_list => 'T',
584: p_commit => 'T',
585: p_validation_level => fnd_api.g_valid_level_none,

Line 629: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

625: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
626: p_commit IN VARCHAR2 := fnd_api.g_false,
627: p_incident_id IN NUMBER,
628: p_group_type IN VARCHAR2,
629: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,
630: x_return_status OUT NOCOPY VARCHAR2,
631: x_resource_id OUT NOCOPY NUMBER,
632: x_territory_id OUT NOCOPY NUMBER,
633: x_msg_count OUT NOCOPY NUMBER,

Line 646: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;

642:
643: -- input and output data structures
644: l_Assign_Groups_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
645: l_sr_am_rec JTF_ASSIGN_PUB.JTF_Serv_req_rec_type := NULL;
646: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
647:
648: --qualifier values
649: l_business_process_id NUMBER;
650: l_incident_id NUMBER := p_incident_id;

Line 979: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

975: p_commit IN VARCHAR2 := fnd_api.g_false,
976: p_incident_id IN NUMBER,
977: p_param_resource_type IN VARCHAR2,
978: p_group_id IN NUMBER,
979: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,
980: x_return_status OUT NOCOPY VARCHAR2,
981: x_resource_id OUT NOCOPY NUMBER,
982: x_resource_type OUT NOCOPY VARCHAR2,
983: x_territory_id OUT NOCOPY NUMBER,

Line 1004: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;

1000: l_count NUMBER;
1001: p NUMBER;
1002: l NUMBER;
1003: l_cal_load_return_sts VARCHAR2(1) := null;
1004: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
1005: --qualifier values
1006: l_incident_id NUMBER := p_incident_id;
1007: l_contract_service_id NUMBER := p_service_request_rec.contract_service_id;
1008: l_inv_item_id NUMBER := NULL;