1 PACKAGE qa_performance_pub AS
2 /* $Header: qapinds.pls 120.0 2005/05/24 17:54:25 appldev noship $ */
3
4
5 -- Start of Comments
6 --
7 -- API name : get_predicate
8 -- Type : Public
9 -- Pre-reqs : None
10 -- Function : API to fetch the predicate for a Function based index on a
11 -- Softcoded Collection Element in Oracle Quality.
12 --
13 -- Parameters :
14 -- IN : p_api_version NUMBER
15 -- Should be 1.0
16 --
17 -- p_init_msg_list VARCHAR2
18 -- Standard api parameter. Indicates whether to
19 -- re-initialize the message list.
20 -- Default is fnd_api.g_false.
21 --
22 -- p_char_id NUMBER
23 -- qa_char.char_id of the element for which the predicate
24 -- neds to be fetched.
25 -- Default is NULL.
26 --
27 -- p_alias DATE
28 -- If p_alias is not NULL, then each CHARACTERxx in text
29 -- should be prefixed by <p_alias>.CHARACTERxx.
30 -- Default is NULL.
31 --
32 -- OUT : x_predicate VARCHAR2
33 -- The Predicate to be returned
34 --
35 -- x_msg_count NUMBER
36 -- Standard api parameter. Indicates no. of messages
37 -- put into the message stack. Currently, there are no
38 -- supported messages. The framework is provided similar
39 -- to any Public API.
40 --
41 -- x_msg_data VARCHAR2
42 -- Standard api parameter. Messages returned.
43 -- Currently, there are no supported messages. The
44 -- framework is provided similar to any Public API.
45 --
46 -- x_return_status VARCHAR2
47 -- Standard api return status parameter.
48 -- Values: fnd_api.g_ret_sts_success,
49 -- fnd_api.g_ret_sts_error,
50 -- fnd_api.g_ret_sts_unexp_error.
51 --
52 --
53 -- Version : 1.0
54 --
55 -- Initial Version : 1.0
56 --
57 -- End of Comments.
58 --
59
60 PROCEDURE get_predicate(
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2,
63 p_char_id IN NUMBER,
64 p_alias IN VARCHAR2,
65 x_predicate OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 x_return_status OUT NOCOPY VARCHAR2);
69
70
71
72 END qa_performance_pub;