PACKAGE: APPS.BIS_GRAPH_REGION_HTML_FORMS

Source

1 PACKAGE  BIS_GRAPH_REGION_HTML_FORMS AUTHID CURRENT_USER AS
2 /* $Header: BISCHRFS.pls 120.1 2006/02/02 02:05:33 nbarik noship $ */
3 ---  Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
4 ---  All rights reserved.
5 ---
6 ---==========================================================================
7 ---  FILENAME
8 ---
9 ---     BISCHRFS.pls
10 ---
11 ---  DESCRIPTION
12 ---     Package Specification File for displaying the three
13 ---     html forms in which to
14 ---     enter parameters to be stored for a PHP Chart
15 ---
16 ---  NOTES
17 ---
18 ---  HISTORY
19 ---
20 ---  20-Jun-2000 Walid.Nasrallah Created
21 ---  05-Oct-2000 Walid.Nasrallah moved "WHO" column defintion to database
22 ---  11-Oct-2000 Walid.Nasrallah added security_group_id argument to
23 ---                              specify_parameter_render procedure
24 ---  06-Feb-2001 mdamle          Wrapper routine to return Resp & lists to java
25 ---  11-May-2001 mdamle		 Created a new get_accessible_functions routine
26 ---  29-May-2001 mdamle		 Added hasFunctionAccess function
27 ---  03-Jul-2001 mdamle   	 Added flag to get_accessible_functions and hasFunctionAccess
28 ---  28-Dec-2001 mdamle 	 Added flag to get_accessible_functions
29 ---===========================================================================
30 g_graph_title         varchar2(200);
31 
32 --- *********************************************
33 --- Type declarations
34 --- *****************************************
35 
36 TYPE t_resp_rec IS RECORD(
37 			  responsibility_name
38 			  fnd_responsibility_vl.responsibility_name%TYPE
39 			  , responsibility_id
40 			   fnd_responsibility.responsibility_id%TYPE
41 			  , application_id
42 			  fnd_responsibility.application_id%TYPE
43 			  , security_group_id
44 			  fnd_user_resp_groups.security_group_id%TYPE
45 			  );
46 
47 TYPE t_resp_tbl_type IS TABLE OF t_resp_rec;
48 
49 
50 TYPE t_func_rec IS RECORD(menu_name
51 			   fnd_menu_entries_vl.prompt%TYPE
52 			   ,web_html_call
53 			  fnd_form_functions.web_html_call%TYPE
54 			  ,web_args
55 			  fnd_form_functions.web_html_call%TYPE
56 			  ,parameters
57 			  fnd_form_functions.parameters%TYPE
58 			  ,function_id
59 			  fnd_form_functions.function_id%TYPE
60 			  ,function_name
61 			  fnd_form_functions.function_name%TYPE
62 			  -- mdamle 03/21/2001
63 			  ,menu_id
64 			  fnd_menu_entries.menu_id%TYPE
65 			  );
66 
67 
68 TYPE t_func_tbl_type IS TABLE OF t_func_rec;
69 
70 TYPE t_menu_tbl_type IS TABLE OF fnd_responsibility.menu_id%TYPE;
71 
72 PROCEDURE Review_Chart_Render
73   (   p_user_id             in  PLS_INTEGER
74     , p_parameter_string    in  VARCHAR2
75      );
76 
77 FUNCTION get_graph_title return varchar2;
78 
79 -- mdamle 05/29/2001 - Added function to check if user has access to this function
80 -- mdamle 07/03/2001 - Added pCheckPMVSpecific flag
81 function hasFunctionAccess(pUserId 		in varchar2
82 			 , pFunctionName	in varchar2
83 			 , pCheckPMVSpecific    in varchar2 default 'Y') return boolean;
84 
85 END BIS_GRAPH_REGION_HTML_FORMS;