[Home] [Help]
PACKAGE: APPS.BIS_JAVASCRIPTLOV_PVT
Source
1 PACKAGE BIS_JAVASCRIPTLOV_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVJLOS.pls 115.8 2004/02/18 00:27:28 ankgoel noship $ */
3 -- +==========================================================================+
4 -- | Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA |
5 -- | All rights reserved. |
6 -- +==========================================================================+
7 -- | FILENAME |
8 -- | BISVJLOB.pls |
9 -- | |
10 -- | DESCRIPTION |
11 -- | Package Specification File for Javascript LOV |
12 -- | NOTES |
13 -- | |
14 -- | HISTORY |
15 -- | |
16 -- |21-Mar-2001 mdamle Created |
17 -- | |
18 -- +==========================================================================+
19
20 G_PERF_MEAS_S_LOV CONSTANT varchar2(4) := 'PM_S';
21 G_PERF_MEAS_R_LOV CONSTANT varchar2(4) := 'PM_R';
22 G_TARGET_LEVEL_S_LOV CONSTANT varchar2(4) := 'TL_S'; /* No more used */
23 G_TARGET_LEVEL_R_LOV CONSTANT varchar2(4) := 'TL_R';
24 G_OWNERS_LOV CONSTANT varchar2(32000) := 'OWNER';
25 G_RESPS_LOV CONSTANT varchar2(5) := 'RESPS';
26
27 PROCEDURE showLOV (p_lov_type in varchar2
28 ,p_form_name in varchar2
29 ,p_param_field in varchar2
30 ,p_param_id_field in varchar2 default NULL
31 ,p_filter in varchar2 default ''
32 ,p_parameter1 in varchar2 default NULL
33 ,p_parameter2 in varchar2 default NULL
34 ,p_parameter3 in varchar2 default NULL
35 ,p_parameter4 in varchar2 default NULL
36 ,p_parameter5 in varchar2 default NULL
37 ,p_callback_function in varchar2 default NULL);
38
39
40 FUNCTION getLOVSQL (p_lov_type in varchar2
41 ,p_filter in varchar2 default ''
42 ,p_parameter1 in varchar2 default NULL
43 ,p_parameter2 in varchar2 default NULL
44 ,p_parameter3 in varchar2 default NULL
45 ,p_parameter4 in varchar2 default NULL
46 ,p_parameter5 in varchar2 default NULL) return varchar;
47
48
49 END BIS_JAVASCRIPTLOV_PVT;