1 package FND_IMUTL as
2 /* $Header: AFIMUTLS.pls 120.2 2005/09/24 12:00:16 skghosh ship $ */
3
4 -----------------------------------------------------------------------------
5 /* Parse_Search
6 ** Format search string to support more browser-like functionality
7 */
8 procedure Parse_Search(
9 search_string in varchar2,
10 select_clause in out nocopy varchar2,
11 and_clause in out nocopy varchar2,
12 index_col in varchar2);
13 -----------------------------------------------------------------------------
14 /* process_imt_reserve_char
15 ** Appends a mask for all IMT reserve characters
16 */
17 FUNCTION process_imt_reserve_char(p_search_token IN VARCHAR2) RETURN VARCHAR2;
18 -----------------------------------------------------------------------------
19 /* process_imt_reserve_word
20 ** Encloses all IMT reserve words in a set of curly braces.
21 */
22 FUNCTION process_imt_reserve_word(p_search_token IN VARCHAR2) RETURN VARCHAR2;
23 -----------------------------------------------------------------------------
24 /* help_cleanup
25 ** Remove all expired or orphaned rows
26 ** Commits in an autonomous transaction
27 */
28 PROCEDURE help_cleanup;
29 -----------------------------------------------------------------------------
30 /* maintain_index
31 ** Maintain an iM index
32 **
33 ** Arguments -
34 ** p_index_name - the name of the index to maintain
35 ** p_callback - (optional) name of the package.procedure to
36 ** execute before maintain the index. Procedure may not
37 ** have any mandatory arguments.
38 ** (i.e.: fnd_imutl.help_cleanup)
39 ** p_app_short_name - the short name of the application that owns the
40 ** index (i.e. FND, SQLGL, INV)
41 ** p_mode - Valid Modes are FAST - fast optimization
42 ** FULL - full optimization
43 ** <anything else> synchronizes index
44 ** Synchronize is what you usually want. It updates
45 ** the index to include your recent DML changes.
46 ** FAST or FULL optimization should probably run during
47 ** off-peak hours to defragment your index and reclaim
48 ** memory from deleted records and close gaps.
49 */
50 PROCEDURE maintain_index(p_index_name in varchar2,
51 p_callback in varchar2 default null,
52 p_app_short_name in varchar2 default 'FND',
53 p_mode in varchar2 default 'sync');
54 -----------------------------------------------------------------------------
55
56 end FND_IMUTL;