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 759: JTF_ASSIGN_PUB.GET_Assign_Resources

755: l_start_date := sysdate ;
756: l_end_date := sysdate ;
757: End If ;
758:
759: JTF_ASSIGN_PUB.GET_Assign_Resources
760: ( p_api_version => 1.0,
761: p_init_msg_list => FND_API.G_FALSE,
762: p_commit => 'F',
763: p_resource_id => NULL,

Line 847: l_Assign_Owner_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type ;

843: l_web_availability_check VARCHAR2(1);
844: l_category_set_id NUMBER;
845: l_platform_catg_set_id NUMBER;
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;

Line 848: l_sr_am_rec JTF_ASSIGN_PUB.JTF_Serv_req_rec_type;

844: l_category_set_id NUMBER;
845: l_platform_catg_set_id NUMBER;
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;

Line 1177: JTF_ASSIGN_PUB.Get_Assign_Resources

1173: -- to whether contract_service_id is not null.
1174: -- From 11.5.9+, the contract_id, inventory_item_id and inventory_org_id
1175: -- are always passed as Null and the Load Balancing will be done for all
1176: -- the resources with or without skills.
1177: JTF_ASSIGN_PUB.Get_Assign_Resources
1178: ( p_api_version => 1.0,
1179: p_init_msg_list => FND_API.G_FALSE,
1180: p_commit => 'F',
1181: p_resource_id => l_group_id,