1 PACKAGE jtf_rs_dbi_8i_conc_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrsdas.pls 115.2 2004/06/25 18:17:38 baianand noship $ */
3 /*#
4 * Sales Group Hierarchy API for non DBI products.
5 * This API contains Sales Group hierarchy related procedures and functions
6 * which is used exclusively by Oracle Sales Intelligence. They are Oracle 8i compatible.
7 * @rep:scope internal
8 * @rep:product JTF
9 * @rep:displayname Sales Group Hierarchy API for non DBI products
10 * @rep:category BUSINESS_ENTITY JTF_RS_SALES_GROUP_HIERARCHY
11 */
12
13
14 /*#
15 * Populate Sales Group Hierarchy concurrant program
16 * This procedure populates sales group hierarchy data through concurrant program.
17 * @param errbuf Output parameter for error buffer
18 * @param retcode Output parameter for return code
19 * @rep:scope internal
20 * @rep:lifecycle active
21 * @rep:displayname Populate Sales Group Hierarchy concurrant program
22 */
23
24 /****************************************************************************
25 This is 8i compatible concurrent program
26 This is a concurrent program to populate the data in JTF_RS_DBI_MGR_GROUPS
27 and JTF_RS_DBI_DENORM_RES_GROUPS
28 table so that it can be accessed via view JTF_RS_DBI_RES_GRP_VL for Sales
29 Group Hierarchy in DBI product. This program is exclusively built for DBI
30 product and is NOT included in mainline code of ATG Resource Manager.
31
32 This is 8i version of regular DBI program
33
34 Create By nsinghai 27-Oct-2003
35 ***************************************************************************/
36
37 PROCEDURE populate_res_grp
38 (ERRBUF OUT NOCOPY VARCHAR2,
39 RETCODE OUT NOCOPY VARCHAR2)
40 ;
41
42
43 /*#
44 * Get Sales Group Id
45 * Function to get sales group id. Based on user id, this function will return
46 * a group id in which logged in user is manager or administrator.
47 * @return Group Id
48 * @rep:scope internal
49 * @rep:displayname Get Sales Group Id
50 */
51
52 /****************************************************************************
53 This function is for providing a common method of fetching the group id
54 for first time login pages. Instead of passing '-1111' to Sales Group
55 Dimension LOV, product teams will call this function which will return
56 them a valid group id. This group id will be used by product teams to
57 query the data rather then querying data for dummy group '-1111'.
58 Internally this function will query for '-1111' and then return the first
59 record.
60
61 This is 8i version of regular DBI program
62
63 Created By nsinghai 03-Oct-2003
64 ***************************************************************************/
65
66 FUNCTION get_sg_id RETURN VARCHAR2;
67
68
69 END jtf_rs_dbi_8i_conc_pub;