DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_PKG dependencies on CS_SERVICEREQUEST_PVT

Line 56: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

52: p_commit IN VARCHAR2,
53: p_incident_id IN NUMBER,
54: p_object_version_number IN NUMBER,
55: p_last_updated_by IN VARCHAR2,
56: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,
57: x_owner_group_id OUT NOCOPY NUMBER,
58: x_owner_id OUT NOCOPY NUMBER,
59: x_owner_type OUT NOCOPY VARCHAR2,
60: x_territory_id OUT NOCOPY NUMBER,

Line 70: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;

66: -- Define Local Variables
67: l_api_name CONSTANT VARCHAR2(30) := 'Assign_ServiceRequest_Main';
68: l_api_version CONSTANT NUMBER := 1.0;
69: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
70: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
71: l_return_status VARCHAR2(1) := null;
72:
73: BEGIN
74: -- Initialize API return status to success

Line 139: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

135: p_commit IN VARCHAR2,
136: p_incident_id IN NUMBER,
137: p_object_version_number IN NUMBER,
138: p_last_updated_by IN VARCHAR2,
139: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,
140: x_owner_group_id OUT NOCOPY NUMBER,
141: x_owner_type OUT NOCOPY VARCHAR2,
142: x_owner_id OUT NOCOPY NUMBER,
143: x_territory_id OUT NOCOPY NUMBER,

Line 153: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;

149: -- Define Local Variables
150: l_api_name CONSTANT VARCHAR2(30) := 'Assign_ServiceRequest_Main';
151: l_api_version CONSTANT NUMBER := 1.0;
152: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
153: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
154: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
155: l_notes_table CS_ServiceRequest_pvt.notes_table;
156: l_contacts_table CS_ServiceRequest_pvt.contacts_table;
157: -- Return Status from Group, Owner and Resources Proc

Line 154: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;

150: l_api_name CONSTANT VARCHAR2(30) := 'Assign_ServiceRequest_Main';
151: l_api_version CONSTANT NUMBER := 1.0;
152: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
153: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
154: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
155: l_notes_table CS_ServiceRequest_pvt.notes_table;
156: l_contacts_table CS_ServiceRequest_pvt.contacts_table;
157: -- Return Status from Group, Owner and Resources Proc
158: l_grp_return_status VARCHAR2(1) := NULL;

Line 155: l_notes_table CS_ServiceRequest_pvt.notes_table;

151: l_api_version CONSTANT NUMBER := 1.0;
152: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
153: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
154: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
155: l_notes_table CS_ServiceRequest_pvt.notes_table;
156: l_contacts_table CS_ServiceRequest_pvt.contacts_table;
157: -- Return Status from Group, Owner and Resources Proc
158: l_grp_return_status VARCHAR2(1) := NULL;
159: l_own_return_status VARCHAR2(1) := NULL;

Line 156: l_contacts_table CS_ServiceRequest_pvt.contacts_table;

152: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
153: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
154: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
155: l_notes_table CS_ServiceRequest_pvt.notes_table;
156: l_contacts_table CS_ServiceRequest_pvt.contacts_table;
157: -- Return Status from Group, Owner and Resources Proc
158: l_grp_return_status VARCHAR2(1) := NULL;
159: l_own_return_status VARCHAR2(1) := NULL;
160: l_main_return_status VARCHAR2(1) ;

Line 447: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

443: ( p_init_msg_list IN varchar2 := fnd_api.g_false,
444: p_commit IN varchar2 := fnd_api.g_false,
445: p_incident_id IN number,
446: p_group_type IN varchar2,
447: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,
448: x_return_status OUT NOCOPY VARCHAR2,
449: x_resource_id OUT NOCOPY NUMBER,
450: x_territory_id OUT NOCOPY NUMBER,
451: x_msg_count OUT NOCOPY NUMBER,

Line 464: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;

460: n NUMBER;
461: -- Input and output data structures
462: l_Assign_Groups_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
463: l_sr_am_rec JTF_ASSIGN_PUB.JTF_Serv_req_rec_type;
464: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
465:
466: -- Qualifier values
467: l_incident_id NUMBER := p_incident_id;
468: l_contract_service_id NUMBER := p_service_request_rec.contract_service_id;

Line 833: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

829: p_commit IN VARCHAR2 := FND_API.G_FALSE,
830: p_incident_id IN NUMBER,
831: p_param_resource_type IN VARCHAR2,
832: p_group_id IN NUMBER,
833: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_resource_id OUT NOCOPY NUMBER,
836: x_resource_type OUT NOCOPY VARCHAR2,
837: x_territory_id OUT NOCOPY NUMBER,

Line 850: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;

846: -- Input and output data structures
847: l_Assign_Owner_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type ;
848: l_sr_am_rec JTF_ASSIGN_PUB.JTF_Serv_req_rec_type;
849: l_resource_load_tbl CS_ASSIGN_RESOURCE_PKG.LoadBalance_tbl_type;
850: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
851: l_index BINARY_INTEGER;
852: l_count NUMBER;
853: p NUMBER;
854: l NUMBER;