1 PACKAGE qa_chars_api AUTHID CURRENT_USER AS
2 /* $Header: qltcharb.pls 120.2 2010/10/11 10:05:52 skolluku noship $ */
3
4
5 FUNCTION exists_qa_chars(element_id IN NUMBER) RETURN BOOLEAN;
6
7
8 PROCEDURE fetch_qa_chars (element_id IN NUMBER);
9
10
11 -- Bug 3769260. shkalyan 29 July 2004.
12 -- Added this procedure to fetch all the elements of a plan
13 -- The reason for introducing this procedure is to reduce the number of
14 -- hits on the QA_CHARS.
15 -- Callers will use this procedure to pre-fetch all the Plan elements
16 -- to the cache if all the elements of a plan would be accessed.
17
18 PROCEDURE fetch_plan_chars (plan_id IN NUMBER);
19
20
21 FUNCTION hardcoded_column(element_id IN NUMBER)
22 RETURN VARCHAR2;
23
24
25 FUNCTION fk_meaning(element_id IN NUMBER)
26 RETURN VARCHAR2;
27
28
29 FUNCTION fk_lookup_type(element_id IN NUMBER)
30 RETURN NUMBER;
31
32
33 FUNCTION sql_validation_string(element_id IN NUMBER)
34 RETURN VARCHAR2;
35
36
37 FUNCTION datatype(element_id IN NUMBER)
38 RETURN NUMBER;
39
40
41 FUNCTION default_value(element_id IN NUMBER)
42 RETURN NUMBER;
43
44 FUNCTION display_length(element_id IN NUMBER)
45 RETURN NUMBER;
46
47
48 FUNCTION decimal_precision (element_id IN NUMBER)
49 RETURN NUMBER;
50
51
52 FUNCTION lower_reasonable_limit(element_id IN NUMBER)
53 RETURN VARCHAR2;
54
55
56 FUNCTION upper_reasonable_limit(element_id IN NUMBER)
57 RETURN VARCHAR2;
58
59
60 FUNCTION prompt(element_id IN NUMBER)
61 RETURN VARCHAR2;
62
63 -- SSQR project. 07/29/2003
64 FUNCTION data_entry_hint(element_id IN NUMBER)
65 RETURN VARCHAR2;
66
67
68 FUNCTION mandatory_flag(element_id IN NUMBER)
69 RETURN NUMBER;
70
71 -- Bug 9773026. skolluku.
72 FUNCTION remove_order_by_from_sql (x_string VARCHAR2)
73 RETURN VARCHAR2;
74
75 FUNCTION format_sql_for_validation (x_string VARCHAR2, x_org_id IN NUMBER,
76 x_created_by IN NUMBER)
77 RETURN VARCHAR2;
78
79
80 FUNCTION format_sql_for_lov (x_string IN VARCHAR2, x_org_id IN NUMBER,
81 x_created_by IN NUMBER)
82 RETURN VARCHAR2;
83
84
85 FUNCTION get_element_id (p_element_name IN VARCHAR2)
86 RETURN NUMBER;
87
88 --
89 -- Bug 3926150. Added this useful utility function for this bug.
90 -- Can be of general use also.
91 -- bso Sat Dec 4 15:01:44 PST 2004
92 --
93 FUNCTION get_element_name (p_element_id IN NUMBER)
94 RETURN VARCHAR2;
95
96
97 FUNCTION has_hardcoded_lov (p_element_id IN NUMBER)
98 RETURN BOOLEAN;
99
100
101 -- anagarwa Tue Jun 22 14:19:42 PDT 2004
102 -- bug 3692326 Support element spec in QWB
103 FUNCTION lower_spec_limit(element_id IN NUMBER)
104 RETURN VARCHAR2;
105
106
107 FUNCTION upper_spec_limit(element_id IN NUMBER)
108 RETURN VARCHAR2;
109
110 FUNCTION target_value(element_id IN NUMBER)
111 RETURN VARCHAR2;
112
113
114 -- Bug 3754667. Added the below function to fetch the developer_name of
115 -- a collection element. kabalakr.
116
117 FUNCTION developer_name(element_id IN NUMBER)
118 RETURN VARCHAR2;
119
120
121 END qa_chars_api;