DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on CS_ASSIGN_RESOURCE_CON_PKG

Line 1: PACKAGE BODY CS_ASSIGN_RESOURCE_CON_PKG as

1: PACKAGE BODY CS_ASSIGN_RESOURCE_CON_PKG as
2: /* $Header: csvconab.pls 120.6.12000000.3 2007/09/07 05:30:07 amganapa ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ASSIGN_RESOURCE_CON_PKG';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ASSIGN_RESOURCE_CON_PKG';

1: PACKAGE BODY CS_ASSIGN_RESOURCE_CON_PKG as
2: /* $Header: csvconab.pls 120.6.12000000.3 2007/09/07 05:30:07 amganapa ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ASSIGN_RESOURCE_CON_PKG';
5:
6: PROCEDURE MAIN_PROCEDURE
7: (x_errbuf OUT NOCOPY VARCHAR2,
8: X_retcode OUT NOCOPY NUMBER,

Line 208: CS_Assign_Resource_CON_PKG.Assign_ServiceRequest_Main

204: l_sr_rec.load_balance := 'Y' ;
205:
206: fnd_file.put_line(fnd_file.log,'Service Request no : ' || l_sr_number);
207:
208: CS_Assign_Resource_CON_PKG.Assign_ServiceRequest_Main
209: ( p_api_name => 'Assign_ServiceRequest_Main',
210: p_api_version => 1.0 ,
211: p_init_msg_list => fnd_api.g_false,
212: p_commit => fnd_api.g_false,

Line 274: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Resources

270: FND_MSG_PUB.Initialize;
271: END IF;
272:
273: IF (p_incident_id IS NOT NULL) THEN
274: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Resources
275: ( p_init_msg_list => p_init_msg_list,
276: p_commit => p_commit,
277: p_incident_id => p_incident_id,
278: p_object_version_number => p_object_version_number,

Line 393: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Group

389: IF (l_sr_rec.owner_group_id IS NULL) THEN
390: l_group_id := NULL;
391: l_update_grp_flag := 'N';
392:
393: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Group
394: (p_init_msg_list => p_init_msg_list,
395: p_commit => p_commit,
396: p_incident_id => p_incident_id,
397: p_group_type => l_default_group_type,

Line 424: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Owner

420: -- Initialize API return status to success
421: x_return_status := FND_API.G_RET_STS_SUCCESS;
422: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
423:
424: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Owner
425: (p_init_msg_list => p_init_msg_list,
426: p_commit => p_commit,
427: p_incident_id => p_incident_id,
428: p_param_resource_type => l_param_resource_type,

Line 510: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Owner

506: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
507: x_owner_group_id := l_group_id;
508: RETURN;
509: ELSE
510: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Owner
511: (p_init_msg_list => p_init_msg_list,
512: p_commit => p_commit,
513: p_incident_id => p_incident_id,
514: p_param_resource_type => l_param_resource_type,

Line 951: l_resource_load_tbl CS_ASSIGN_RESOURCE_CON_PKG.LoadBalance_tbl_type;

947: l_msg VARCHAR2(2000) ;
948: -- input and output data structures
949: l_Assign_Owner_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type ;
950: l_sr_am_rec JTF_ASSIGN_PUB.JTF_Serv_req_rec_type;
951: l_resource_load_tbl CS_ASSIGN_RESOURCE_CON_PKG.LoadBalance_tbl_type;
952: l_index BINARY_INTEGER;
953: l_count NUMBER;
954: p NUMBER;
955: l NUMBER;

Line 1286: CS_ASSIGN_RESOURCE_CON_PKG.Calculate_Load

1282: l_index := l_index + 1;
1283: END LOOP;
1284:
1285: IF (l_resource_load_tbl.COUNT > 1) THEN
1286: CS_ASSIGN_RESOURCE_CON_PKG.Calculate_Load
1287: ( p_init_msg_list => p_init_msg_list,
1288: p_incident_id => p_incident_id,
1289: p_incident_type_id => p_service_request_rec.type_id,
1290: p_incident_severity_id => p_service_request_rec.severity_id,

Line 1349: p_res_load_table IN OUT NOCOPY CS_ASSIGN_RESOURCE_CON_PKG.LoadBalance_tbl_type,

1345: p_platform_org_id IN NUMBER,
1346: p_platform_id IN NUMBER,
1347: p_problem_code IN VARCHAR2,
1348: p_contact_timezone_id IN NUMBER,
1349: p_res_load_table IN OUT NOCOPY CS_ASSIGN_RESOURCE_CON_PKG.LoadBalance_tbl_type,
1350: x_return_status OUT NOCOPY VARCHAR2,
1351: x_resource_id OUT NOCOPY NUMBER,
1352: x_resource_type OUT NOCOPY VARCHAR2,
1353: x_msg_count OUT NOCOPY NUMBER,

Line 1777: END CS_ASSIGN_RESOURCE_CON_PKG;

1773: END IF;
1774:
1775: END Calculate_Load;
1776:
1777: END CS_ASSIGN_RESOURCE_CON_PKG;