1 PACKAGE AMS_DISCOVERER_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvdiss.pls 115.10 2004/04/07 20:27:40 choang ship $ */
3
4 TYPE t_SQLtable is TABLE OF varchar2(2000)
5 INDEX BY BINARY_INTEGER;
6
7 TYPE source_type_code_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
8
9 -----------------------------------------------------------------------------
10 -- Procedure
11 -- Create_Discoverer_Url
12
13 -- PURPOSE
14 -- Creates a URL which will launch Web Discoverer.
15 --
16 -- PARAMETERS
17
18 -- NOTES
19 -- created yxliu 14-Mar-2001
20 -----------------------------------------------------------------------------
21 Procedure Create_Discoverer_Url(p_text IN VARCHAR2,
22 p_application_id IN NUMBER,
23 p_responsibility_id IN NUMBER,
24 p_function_id IN NUMBER,
25 p_target IN VARCHAR2 default '_top',
26 p_session_id IN NUMBER,
27 x_discoverer_url OUT NOCOPY VARCHAR2
28 );
29
30 -----------------------------------------------------------------------------
31 -- Function
32 -- EUL_TRIGGER$POST_SAVE_DOCUMENT
33
34 -- PURPOSE
35 -- 1. This Function is used by Oracle Discoverer to save a WorkSheets SQL
36 -- to The AMS_DISCOVERER_SQL table.
37
38 -- 2. This Function must be Registered as a valid Function using Oracle
39 -- Discoverer's Administration Edition before any WorkBook SQL will be
40 -- saved.
41
42 -- NOTES
43
44 -- HISTORY
45 -- 04/13/2001 yxliu copied from AMS_DiscovererSQL_PVT
46 -- End of Comments
47 -----------------------------------------------------------------------------
48 Function EUL_TRIGGER$POST_SAVE_DOCUMENT
49 ( P_WorkBookOwner IN varchar2,
50 P_WorkBookName IN varchar2,
51 P_WorkSheetName IN varchar2,
52 P_Sequence IN number,
53 P_SQLSegment IN varchar2
54 )
55 return NUMBER;
56
57 -----------------------------------------------------------------------------
58 -- Procedure
59 -- Search_SQL_string
60
61 -- PURPOSE
62 -- 1. Will search for the p_search_string variable in the set of strings
63 -- which compose a workbook SQL statement and are stored in the
64 -- AMS_DISCOVERER_SQL table.
65
66 -- 2. p_found will return FND_API.G_TRUE if the string has been found.
67
68 -- 3. p_found_in_str returns the number of the sql string in which the search
69 -- string was found. each SQL string is 2000 characters in length.
70
71 -- 4. p_position returns the position in the string where the first character
72 -- in the search string was found.
73
74 -- 5. p_overflow wil return the number of characters which contain part of
75 -- the search string in the overflow string if the searched for string
76 -- spans two SQL strings.
77
78 -- 6. p_max_search_len restricts the number of characters to search on from
79 -- the set of sql strings.
80
81 -- NOTES
82
83 -- HISTORY
84 -- 04/13/2001 yxliu copied from AMS_DiscovererSQL_PVT
85 -- End of Comments
86 -----------------------------------------------------------------------------
87 Procedure Search_SQL_string(p_search_string in varchar2,
88 p_workbook_name in varchar2,
89 p_worksheet_name in varchar2,
90 p_max_search_len in number default NULL,
91 x_found OUT NOCOPY varchar2,
92 x_found_in_str OUT NOCOPY number,
93 x_position OUT NOCOPY number,
94 x_overflow OUT NOCOPY number);
95
96 -----------------------------------------------------------------------------
97 -- Function
98 -- Encrypt_Param
99
100 -- PURPOSE
101 -- 1. This Function is used by the middle tier java class to get encryption
102 -- of parameters that need to be passed to form function
103
104 -- NOTES
105
106 -- HISTORY
107 -- 05/03/2001 yxliu created
108 -- End of Comments
109 -----------------------------------------------------------------------------
110 Function Encrypt_Param
111 ( P_params IN varchar2,
112 P_session_id IN number)
113 RETURN varchar2;
114
115
116
117 --
118 -- Purpose
119 -- =========
120 -- Given a table of source_type_codes (from ams_list_src_types)
121 -- search a Discoverer workbook saved SQL to identify a match
122 -- of the code. Intended for denormalizing the source_type_code
123 -- of a workbook to a column in ams_discoverer_sql for faster
124 -- querying.
125 --
126 -- Usage
127 -- =========
128 -- Input Parameters:
129 -- p_workbook_name - the name of the Discoverer workbook
130 -- p_worksheet_name - the name of the Discoverer worksheet within the
131 -- given workbook.
132 -- p_source_type_code_tab - a PL/SQL table containing all the codes used
133 -- for matching with the workbooks.
134 -- Output Parameters:
135 -- x_found_index - index that identifies the source_type_code in the input
136 -- PL/SQL table.
137 --
138 -- History
139 -- =========
140 -- 21-Aug-2003 choang Created for bug 3000427.
141 --
142 PROCEDURE batch_search_sql (
143 p_workbook_name in varchar2,
144 p_worksheet_name in varchar2,
145 p_source_type_code_tab IN source_type_code_type,
146 x_found_index OUT NOCOPY VARCHAR2
147 );
148
149
150 END; -- Package spec