1 PACKAGE BODY ADI_Web_Reports AS
2 /* $Header: frmkoskb.pls 120.0 2006/12/14 02:05:03 dvayro noship $ */
3 ----------------------------------------------------------------------------------------
4 -- PACKAGE: ADI_Web_Reports --
5 -- --
6 -- DESCRIPTION: Creates the menu structure for the Web Reporting Kiosk. --
7 -- --
8 -- Modifications --
9 -- Date Username Description --
10 -- 26-JUN-99 cclyde Initial creation --
11 -- 07-AUG-99 cclyde Changed the background colour for the login screen. Now set--
12 -- to FFFFB7, which is the same as the Icon frame. --
13 -- 09-AUG-00 cclyde Changed the icons to constant variables and changed their --
14 -- names. --
15 -- Added new icon for login page ADISPLASH.gif and moved the --
16 -- the location (centered more). --
17 -- Added focus functionality so that the cursor is positioned --
18 -- in the 'username' field when the signon screen is loaded. --
19 -- Removed the Session Id and Language from the root label. --
20 -- 09-AUG-99 CCLYDE Removed the splash image from the table (upsetting field --
21 -- and button line ups. (Login) --
22 -- 10-AUG-99 CCLYDE Changed displayed icon to the construction worker. --
23 -- (Startover) --
24 -- 23-AUG-99 CCLYDE Added the check against the responsibility table where the --
25 -- Responsibility Name = ADI_KIOSK_PUBLIC_RESPONSIBILITY. --
26 -- This removes possible duplicates from the secured menu. --
27 -- (Task: 3293) (ShowSecuredRoot) --
28 -- 23-AUG-99 CCLYDE Changed the condition to '< 11.5' when building the menu --
29 -- entry. Release 11.0 does not use all the security infor- --
30 -- mation now built into Release 11.5. (Task: 3294) --
31 -- (BuildSecuredEntries) --
32 -- 23-AUG-99 CCLYDE Changed the condition around the SQL statement to '< 11.5' --
33 -- because 'FND_USER_RESP_GROUPS' is a new table in Release 11,--
34 -- not Release 11.5 as originally thought. (Task: 3294) --
35 -- (ShowSecuredMenu) --
36 -- 23-AUG-99 CCLYDE Changed setfocus to setfocuslogin so that it's more --
37 -- specific. Added the second function, setfocuspword so that --
38 -- tabbing from the username field will take the user into the --
39 -- password field. (Task: 3289) (Login) --
40 -- 25-AUG-99 CCLYDE Modified the spacer images and the splash logo to fit into --
41 -- an 800x600 window. (Task: 3325) (Login) --
42 -- 28-AUG-99 CCLYDE Added Exception clauses to all procedures which contained a --
43 -- SQL statement. (Task: 3275) --
44 -- 31-AUG-99 CCLYDE Changed ADI_REPORT_LINK to FRM_REPORT_LINK. (Task: 3400) --
45 -- 01-SEP-99 CCLYDE Removed the hard-coded URL from the Profile insert --
46 -- statement. (Update_Web_Option) --
47 -- 07-SEP-99 CCLYDE Added the UNION statement so that the code also retrieved --
48 -- the Self Service functions. 10.7 uses a different schema --
49 -- model to 11.0. (Task: 3324) (Show_Menu) --
50 -- 08-SEP-99 CCLYDE Added 'PUBLIC' to pageBanner parameter list. This --
51 -- determines which icon to display and the action reqiured --
52 -- when the user clicks on the icon. (Task: 3381) (Login) --
53 -- 27-OCT-99 CCLYDE Added a check to the SQL statement so that the Responsib- --
54 -- ilities are only retrieved if the User still has access to --
55 -- to them. Originally, the code only checked that the Resps --
56 -- were valid. --
57 -- 17-NOV-99 CCLYDE Changed the check on the current release for 11.5, not 11.0.--
58 -- GetProtocol calls a routine called FND_WEB_CONFIG.PROTOCOL --
59 -- which does not exist until Release 11.5. (Task: 3755) --
60 -- (Build_Public_Entries) --
61 -- 04-FEB-00 cclyde Added double quotes around l_profile_value within the --
62 -- Insert statement. Causing a missing ',' error, when the --
63 -- report link profile does not exist. (UpdateWebProfile) --
64 -- 16-FEB-00 cclyde Added Package_Revision procedure to see if we can capture --
65 -- the revision number of the package during runtime. --
66 -- (Task: 3858) --
67 -- 24-FEB-00 cclyde Changed USR to GRP in second half of the UNION statement. --
68 -- USR was not valid as a table identifier. --
69 -- ShowSecuredRoot Task: 3883. --
70 -- 16-MAY-00 GSANAP Moved the $Header comment from the top to under --
71 -- the CREATE OR REPLACE PACKAGE stmt. --
72 -- 29-JUN-00 GSANAP Modified the Debugs stmts. to include package names --
73 -- Task 4425 --
74 -- 28-AUG-02 tobermei commented out references to ADI_ui_jstree package for --
75 -- bug 2530939 resolution, these aren't used anymore with the --
76 -- java report manager code, much more in this package can --
77 -- most likely go, if you look at the Public_Home procedure, --
78 -- you will see that it redirects to BneApplicationService --
79 -- which is now oracle.apps.bne.webui.BneApplicationService --
80 -- 12-SEP-02 tobermei one more reference to ADI_ui_jstree had to be commented out --
81 -- for bug 2530939 resolution. --
82 -- 14-NOV-02 GHOOKER Stub out procedures not used by RM8 --
83 ----------------------------------------------------------------------------------------
84 END ADI_Web_Reports;