1 Package JTF_RS_GRP_SUM_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfrssgs.pls 120.0 2006/02/09 15:00:02 baianand noship $ */
3 /*#
4 * This package contains procedures to get group records
5 * for JTT Group Advanced Search
6 * @rep:scope private
7 * @rep:product JTF
8 * @rep:displayname Get Groups Package
9 * @rep:category BUSINESS_ENTITY JTF_RS_GROUP
10 */
11
12
13 ---------------------------------------------------------
14 -- Start of Comments
15 -- ---------------------------------------------------
16 -- PACKAGE NAME: JTF_RS_GRP_SUM_PUB
17 -- ---------------------------------------------------
18 -- PURPOSE
19 -- Get group details for Group Summary Screen (jsp)
20 -- NOTES
21 -- This package is publicly available for use
22 --
23 -- HISTORY
24 -- 04/30/2001 NSINGHAI Created
25 -- End of Comments
26 --
27
28 -- GROUP RECORDS
29 TYPE grp_sum_rec_type IS record
30 (group_id number,
31 group_name varchar2(60),
32 group_desc varchar2(240),
33 group_number varchar2(30),
34 start_date_active date,
35 end_date_active date,
36 parent_group varchar2(60),
37 parent_group_id number,
38 child_group varchar2(60),
39 child_group_id number
40 );
41
42 TYPE grp_sum_tbl_type IS table OF grp_sum_rec_type
43 INDEX BY binary_integer;
44
45 -- ***************************************************
46 -- start of comments
47 -- ***************************************************
48 -- api name : Get Group Summary
49 -- type : public.
50 -- function : Get the Groups summary information
51 -- pre-reqs : depends on jtf_rs_groups_vl
52 -- parameters :
53 -- end of comments
54
55 /*#
56 * This procedure gets group records based on the search criteria
57 * mentioned in the other input parameters
58 * @param p_range_low Lower range for record set
59 * @param p_range_high Higher range for record set
60 * @param p_called_from Indicator if its called from quick find or advanced search
61 * @param p_user_id User id to filter groups by the membership of the user
62 * @param p_group_name Group Name filter
63 * @param p_group_number Group Number filter
64 * @param p_group_desc Group Description filter
65 * @param p_group_email Email filter
66 * @param p_from_date To find groups active on or after the given date
67 * @param p_to_date To find groups active on or before the given date
68 * @param p_date_format date format for the dates specified
69 * @param p_group_id Group's internal unique id to get a specific group
70 * @param p_group_usage Groups based on group usage
71 * @param x_total_rows Output parameter containing total number of rows returned
72 * @param x_result_tbl Output parameter containing rows returned
73 * @rep:scope private
74 * @rep:displayname Get Groups
75 */
76 PROCEDURE Get_Group
77 ( p_range_low IN NUMBER,
78 p_range_high IN NUMBER,
79 p_called_from IN VARCHAR2 default 'DEFAULT',
80 p_user_id IN NUMBER default null,
81 p_group_name IN VARCHAR2 default null,
82 p_group_number IN VARCHAR2 default null,
83 p_group_desc IN VARCHAR2 default null,
84 p_group_email IN VARCHAR2 default null,
85 p_from_date IN VARCHAR2 default null,
86 p_to_date IN VARCHAR2 default null,
87 p_date_format IN VARCHAR2 default 'DD-MM-RRRR' ,
88 p_group_id IN NUMBER default null,
89 p_group_usage IN VARCHAR2 default null,
90 x_total_rows OUT NOCOPY NUMBER,
91 x_result_tbl OUT NOCOPY grp_sum_tbl_type);
92
93 END JTF_RS_GRP_SUM_PUB;
94