1 PACKAGE JTF_RS_GROUP_REPORT_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfrsbgs.pls 120.0 2005/05/11 08:19:19 appldev ship $ */
3
4 /************************************************************
5
6 This is a sql to get the history of movement of members in and out of groups
7
8 15-JUN-2004 nsinghai added dummy parameters for selective enabling
9 disbaling of fields.
10
11 *****************************************************************************/
12
13 PROCEDURE query_group(ERRBUF OUT NOCOPY VARCHAR2,
14 RETCODE OUT NOCOPY VARCHAR2,
15 P_REP_TYPE IN VARCHAR2 ,
16 P_DUMMY_1 IN VARCHAR2 DEFAULT NULL,
17 P_DUMMY_2 IN VARCHAR2 DEFAULT NULL,
18 P_DUMMY_3 IN VARCHAR2 DEFAULT NULL,
19 P_GROUP_ID IN NUMBER DEFAULT NULL,
20 P_RES_ID IN NUMBER DEFAULT NULL,
21 P_USAGE IN VARCHAR2 DEFAULT NULL,
22 P_USR_NAME IN VARCHAR2 DEFAULT NULL,
23 P_DATE_OPT IN VARCHAR2 DEFAULT 'RANGE',
24 P_START_DATE IN varchar2 default null,
25 P_END_DATE IN varchar2 default null,
26 P_NO_OF_DAYS IN number default null) ;
27
28 /*
29 * Procedure overloaded to give user choice to display DFF fields in the report.
30 * While submitting the concurrent request, The user may choose to display DFF fields in the report.
31 * Ref: ER# 2549463
32 */
33
34 PROCEDURE query_group(ERRBUF OUT NOCOPY VARCHAR2,
35 RETCODE OUT NOCOPY VARCHAR2,
36 P_REP_TYPE IN VARCHAR2 ,
37 P_DUMMY_1 IN VARCHAR2 DEFAULT NULL,
38 P_DUMMY_2 IN VARCHAR2 DEFAULT NULL,
39 P_DUMMY_3 IN VARCHAR2 DEFAULT NULL,
40 P_GROUP_ID IN NUMBER DEFAULT NULL,
41 P_RES_ID IN NUMBER DEFAULT NULL,
42 P_USAGE IN VARCHAR2 DEFAULT NULL,
43 P_USR_NAME IN VARCHAR2 DEFAULT NULL,
44 P_DATE_OPT IN VARCHAR2 DEFAULT 'RANGE',
45 P_START_DATE IN varchar2 default null,
46 P_END_DATE IN varchar2 default null,
47 P_NO_OF_DAYS IN number default null,
48 P_DISP_DFF_FIELDS IN VARCHAR2 DEFAULT 'N');
49
50
51 /*
52 * Added P_DISP_ROLE parameter vide Bug# 1745032
53 */
54
55 PROCEDURE query_group_hierarchy(ERRBUF OUT NOCOPY VARCHAR2,
56 RETCODE OUT NOCOPY VARCHAR2,
57 P_GROUP_NAME IN VARCHAR2 DEFAULT NULL,
58 P_DISP_ROLE IN VARCHAR2 DEFAULT 'N');
59
60
61 /*
62 * Procedure overloaded to give user choice to display DFF fields in the report.
63 * While submitting the concurrent request, The user may choose to display DFF fields in the report.
64 * Ref: ER# 2549463
65 */
66
67 PROCEDURE query_group_hierarchy(ERRBUF OUT NOCOPY VARCHAR2,
68 RETCODE OUT NOCOPY VARCHAR2,
69 P_GROUP_NAME IN VARCHAR2 DEFAULT NULL,
70 P_DISP_ROLE IN VARCHAR2 DEFAULT 'N',
71 P_DISP_DFF_FIELDS IN VARCHAR2 DEFAULT 'N');
72 end;