1 PACKAGE jtf_rs_default_groups_conc_pub AS
2 /* $Header: jtfrsbcs.pls 120.0 2005/05/11 08:19:15 appldev noship $ */
3
4 /****************************************************************************
5 This is a concurrent program to populate the data in JTF_RS_DEFAULT_GROUPS_INT
6 and JTF_RS_DEFAULT_GROUPS. This program will create primary groups for resources
7 based on usage and rules (specified by product teams) for date date range from
8 01/01/1900 to 12/31/4712. For a specific date there will be only one primary
9 group for a resource.
10
11 Currently, it is being used for only Field Service Application.
12
13 CREATED BY nsinghai 07/20/2004
14 MODIFIED BY
15 ***************************************************************************/
16
17 /*****************************************************************************
18 This procedure will populate default groups for Field Service District (usage:
19 'FLD_SRV_DISTRICT') through concurrent program "Update Primary Districts for
20 Field Service Engineers".
21
22 Created By nsinghai 07/21/2004
23 Modified By
24 *****************************************************************************/
25
26 PROCEDURE populate_fs_district
27 (ERRBUF OUT NOCOPY VARCHAR2,
28 RETCODE OUT NOCOPY VARCHAR2)
29 ;
30
31 /****************************************************************************
32 This Function is used to fetch default group for specific usage given a
33 resource_id, date and usage as input parameter. This function will fetch data
34 only if data is populated in jtf_rs_default_groups table for that usage.
35
36 Created By nsinghai 07/21/2004
37 Modified By
38
39 *****************************************************************************/
40
41 FUNCTION get_default_group
42 (p_resource_id IN NUMBER,
43 p_usage IN VARCHAR2,
44 p_date IN DATE DEFAULT SYSDATE
45 )
46 RETURN NUMBER;
47
48 END jtf_rs_default_groups_conc_pub;