1 PACKAGE AMS_DiscovererSQL_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvldcs.pls 115.5 2002/11/12 23:38:58 jieli ship $ */
3 --PL\SQL table to hold the strings that compose a valid SQL statement from
4 --a discoverer workbook
5
6 TYPE t_SQLtable is TABLE OF varchar2(2000)
7 INDEX BY BINARY_INTEGER;
8
9 -- Start of Comments
10 --
11 -- NAME
12 -- EUL_TRIGGER$POST_SAVE_DOCUMENT
13 --
14 -- PURPOSE
15 -- 1. This Function is used by Oracle Discoverer to save a WorkSheets SQL
16 -- to The AMS_DISCOVERER_SQL table.
17
18 -- 2. This Function must be Registered as a valid Function using Oracle
19 -- Discoverer's Administration Edition before any WorkBook SQL will be
20 -- saved.
21
22 -- NOTES
23
24 -- HISTORY
25 -- 06/21/1999 tdonohoe created
26 -- End of Comments
27
28 Function EUL_TRIGGER$POST_SAVE_DOCUMENT
29 ( P_WorkBookOwner IN varchar2,
30 P_WorkBookName IN varchar2,
31 P_WorkSheetName IN varchar2,
32 P_Sequence IN number,
33 P_SQLSegment IN varchar2) return NUMBER;
34
35
36 -- Start of Comments
37 --
38 -- NAME
39 -- Search SQL string
40 --
41 -- PURPOSE
42 -- 1. Will search for the p_search_string variable in the set of strings which compose a workbook
43 -- SQL statement and are stored in the AMS_DISCOVERER_SQL table.
44
45 -- 2. p_found will return FND_API.G_TRUE if the string has been found.
46
47 -- 3. p_found_in_str returns the number of the sql string in which the search string was found.
48 -- each SQL string is 2000 characters in length.
49
50 -- 4. p_position returns the position in the string where the first character in the search string
51 -- was found.
52
53 -- 5. p_overflow wil return the number of characters which contain part of the search string
54 -- in the overflow string if the searched for string spans two SQL strings.
55
56 -- 6. p_max_search_len restricts the number of characters to search on from the set of sql strings.
57
58 -- Called By.
59 -- 1. Validate SQL.
60 --
61 -- HISTORY
62 -- 06/28/1999 tdonohoe created
63 -- End of Comments
64 Procedure Search_SQL_string(p_search_string in varchar2,
65 p_workbook_name in varchar2,
66 p_worksheet_name in varchar2,
67 p_max_search_len in number default NULL,
68 x_found OUT NOCOPY varchar2 ,
69 x_found_in_str OUT NOCOPY number,
70 x_position OUT NOCOPY number,
71 x_overflow OUT NOCOPY number);
72
73
74
75 END AMS_DiscovererSQL_PVT; -- Package spec
76
77
78
[Home] [Help]