[Home] [Help]
PACKAGE: APPS.QA_CHAR_INDEXES_PKG
Source
1 PACKAGE qa_char_indexes_pkg AUTHID CURRENT_USER AS
2 /* $Header: qaindexs.pls 120.2 2011/06/13 07:49:27 ntungare noship $ */
3
4 err_element_not_in_use CONSTANT INTEGER := -1;
5 err_string_overflow CONSTANT INTEGER := -2;
6 err_create_index CONSTANT INTEGER := -3;
7 err_drop_index CONSTANT INTEGER := -4;
8 err_unsupported_element_type CONSTANT INTEGER := -5;
9 err_insert_row CONSTANT INTEGER := -6;
10 err_delete_row CONSTANT INTEGER := -7;
11 err_disable_index CONSTANT INTEGER := -8;
12 err_index_name CONSTANT INTEGER := -9;
13
14 PROCEDURE wrapper(
15 errbuf OUT NOCOPY VARCHAR2,
16 retcode OUT NOCOPY NUMBER,
17 argument1 VARCHAR2,
18 argument2 VARCHAR2,
19 argument3 VARCHAR2,
20 argument4 VARCHAR2);
21
22 PROCEDURE get_predicate(
23 p_char_id NUMBER,
24 p_alias VARCHAR2,
25 x_predicate OUT NOCOPY VARCHAR2);
26
27 FUNCTION index_exists(p_char_id NUMBER) RETURN INTEGER;
28
29 FUNCTION index_exists_and_enabled(p_char_id NUMBER) RETURN INTEGER;
30
31 FUNCTION get_default_result_column(p_char_id NUMBER) RETURN VARCHAR2;
32
33 FUNCTION disable_index(p_char_id NUMBER) RETURN INTEGER;
34
35 FUNCTION drop_index(p_char_id NUMBER) RETURN INTEGER;
36
37 FUNCTION create_or_regenerate_index(
38 p_char_id NUMBER,
39 p_index_name VARCHAR2,
40 p_additional_parameters VARCHAR2)
41 RETURN INTEGER;
42
43 PROCEDURE insert_row(
44 x_rowid OUT NOCOPY VARCHAR2,
45 p_created_by NUMBER,
46 p_creation_date DATE,
47 p_last_updated_by NUMBER,
48 p_last_update_date DATE,
49 p_last_update_login NUMBER,
50 p_request_id NUMBER,
51 p_program_application_id NUMBER,
52 p_program_id NUMBER,
53 p_program_update_date DATE,
54 p_char_id NUMBER,
55 p_enabled_flag NUMBER,
56 p_index_name VARCHAR2,
57 p_default_result_column VARCHAR2,
58 p_text VARCHAR2,
59 p_additional_parameters VARCHAR2);
60
61 PROCEDURE delete_row(p_char_id NUMBER);
62
63 FUNCTION get_index_predicate(
64 p_char_id NUMBER,
65 p_alias VARCHAR2)
66 RETURN VARCHAR2;
67
68 --
69 -- Bug 3930666. This bug does not impact this
70 -- current package. But it is most efficient to
71 -- fix it by exposing a new function to the public.
72 -- To be used in qlthrb.plb.
73 --
74 -- bso Tue Apr 5 17:24:07 PDT 2005
75 --
76 -- It was found out later that this function is not
77 -- needed by qlthrb; rather construct_decode_function
78 -- (existing) should be exposed instead. Keeping this
79 -- here as it is generally useful.
80 --
81 FUNCTION get_decode_function(
82 p_char_id NUMBER,
83 p_alias VARCHAR2 DEFAULT NULL
84 ) RETURN VARCHAR2;
85
86 --
87 -- bug 12596623
88 -- Added a new parameter p_process_num_decode to ensure that
89 -- while building the predicate for numbers, the DECODE()
90 -- function is not Stripped off
91 --
92 FUNCTION construct_decode_function(
93 p_char_id NUMBER,
94 p_alias VARCHAR2,
95 x_most_common OUT NOCOPY VARCHAR2,
96 x_function OUT NOCOPY dbms_sql.varchar2s,
97 p_process_num_decode IN BOOLEAN DEFAULT FALSE)
98 RETURN INTEGER;
99
100 --
101 -- bug 12596623
102 -- New function to return the Case predicate for indices
103 -- on numbers.
104 --
105 FUNCTION get_case_function(p_char_id IN VARCHAR2,
106 p_alias in VARCHAR2,
107 x_case_func OUT NOCOPY VARCHAR2)
108 RETURN INTEGER;
109
110 END qa_char_indexes_pkg;