1 PACKAGE jtf_rs_integration_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrspxs.pls 120.0 2005/05/11 08:21:30 appldev noship $ */
3 /*#
4 * Resource Integration API
5 * This API contains common procedures and functions that can be called from other oracle products.
6 * @rep:scope internal
7 * @rep:product JTF
8 * @rep:displayname Resource Integration API
9 * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE
10 */
11
12 /*****************************************************************************************
13 ******************************************************************************************/
14
15 /*#
16 * Get primary group for salesperson
17 * Function to fetch primary group for salesperson.
18 * @param p_salesrep_id Salesrep Id
19 * @param p_org_id Organization Id for Salesperson
20 * @param p_date Date for which primary group is to be fetched
21 * @return Group Id
22 * @rep:scope internal
23 * @rep:displayname Get Primary Group For Salesperson
24 */
25
26 FUNCTION get_default_sales_group
27 (p_salesrep_id IN NUMBER,
28 p_org_id IN NUMBER,
29 p_date IN DATE DEFAULT SYSDATE)
30 RETURN NUMBER;
31
32 TYPE Resource_Rec_type IS RECORD
33 (RESOURCE_ID JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE);
34
35 TYPE Resource_table_type IS TABLE OF Resource_Rec_type INDEX BY BINARY_INTEGER;
36
37 /* Procedure to get resources based on Skill (Platform,Product,Component,ProblemCode,Level combination) */
38
39 /*#
40 * Get get resources based on Skill (Platform,Product,Component,ProblemCode,Level combination)
41 * Procedure to get resources based on Skill
42 * @param p_category_id Category Id
43 * @param p_subcategory Sub Category
44 * @param p_product_id Product Id
45 * @param p_product_org_id Organization Id for Product
46 * @param p_component_id Component Id
47 * @param p_subcomponent_id Sub Component Id
48 * @param p_platform_id Platform Id
49 * @param p_platform_org_id Organization Id for Platform
50 * @param p_problem_code Problem Code
51 * @param p_skill_level_id Skill Level Id
52 * @param x_get_resources_tbl Output table which contains the list of resources based on the input parameters
53 * @param x_return_status Output parameter for return status
54 * @rep:scope internal
55 * @rep:displayname Get resources based on skill
56 */
57
58 PROCEDURE get_resources_by_skill
59 (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,
60 p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
61 p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
62 p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
63 p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
64 p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
65 p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
66 p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
67 p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,
68 p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,
69 x_get_resources_tbl OUT NOCOPY jtf_rs_integration_pub.Resource_table_type,
70 x_return_status OUT NOCOPY VARCHAR2
71 );
72
73 END jtf_rs_integration_pub;