DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_PKG dependencies on JTF_ASSIGN_PUB

Line 9: p_assign_resources_tbl IN JTF_ASSIGN_PUB.AssignResources_tbl_type,

5: -- This procedure filters the Usage as Support for
6: -- all the Groups returned from JTF AM API and returns
7: -- only the first Support usage Group.
8: PROCEDURE Get_Sup_Usage_Group(
9: p_assign_resources_tbl IN JTF_ASSIGN_PUB.AssignResources_tbl_type,
10: x_resource_id OUT NOCOPY NUMBER,
11: x_territory_id OUT NOCOPY NUMBER) IS
12:
13: CURSOR c_usage_check(p_group_id IN NUMBER) IS

Line 462: l_Assign_Groups_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;

458: -- Profiles variables
459: l_web_availability_check VARCHAR2(1);
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

Line 463: l_sr_am_rec JTF_ASSIGN_PUB.JTF_Serv_req_rec_type;

459: l_web_availability_check VARCHAR2(1);
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;

Line 689: JTF_ASSIGN_PUB.GET_Assign_Resources

685: ELSE
686: l_ib_resource_flag := 'N';
687: END IF;
688:
689: JTF_ASSIGN_PUB.GET_Assign_Resources
690: ( p_api_version => 1.0,
691: p_init_msg_list => FND_API.G_FALSE,
692: p_commit => 'F',
693: p_resource_id => NULL,

Line 776: l_Assign_Owner_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type ;

772: l_web_availability_check VARCHAR2(1);
773: l_category_set_id NUMBER;
774: l_platform_catg_set_id NUMBER;
775: -- Input and output data structures
776: l_Assign_Owner_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type ;
777: l_sr_am_rec JTF_ASSIGN_PUB.JTF_Serv_req_rec_type;
778: l_resource_load_tbl CS_ASSIGN_RESOURCE_PKG.LoadBalance_tbl_type;
779: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
780: l_index BINARY_INTEGER;

Line 777: l_sr_am_rec JTF_ASSIGN_PUB.JTF_Serv_req_rec_type;

773: l_category_set_id NUMBER;
774: l_platform_catg_set_id NUMBER;
775: -- Input and output data structures
776: l_Assign_Owner_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type ;
777: l_sr_am_rec JTF_ASSIGN_PUB.JTF_Serv_req_rec_type;
778: l_resource_load_tbl CS_ASSIGN_RESOURCE_PKG.LoadBalance_tbl_type;
779: l_sr_rec CS_ServiceRequest_pvt.service_request_rec_type DEFAULT p_service_request_rec;
780: l_index BINARY_INTEGER;
781: l_count NUMBER;

Line 1011: JTF_ASSIGN_PUB.Get_Assign_Resources

1007: -- to whether contract_service_id is not null.
1008: -- From 11.5.9+, the contract_id, inventory_item_id and inventory_org_id
1009: -- are always passed as Null and the Load Balancing will be done for all
1010: -- the resources with or without skills.
1011: JTF_ASSIGN_PUB.Get_Assign_Resources
1012: ( p_api_version => 1.0,
1013: p_init_msg_list => FND_API.G_FALSE,
1014: p_commit => 'F',
1015: p_resource_id => l_group_id,