1 PACKAGE qa_chars_api AS
2 /* $Header: qltcharb.pls 120.0 2005/05/24 17:50:57 appldev 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
72 FUNCTION format_sql_for_validation (x_string VARCHAR2, x_org_id IN NUMBER,
73 x_created_by IN NUMBER)
74 RETURN VARCHAR2;
75
76
77 FUNCTION format_sql_for_lov (x_string IN VARCHAR2, x_org_id IN NUMBER,
78 x_created_by IN NUMBER)
79 RETURN VARCHAR2;
80
81
82 FUNCTION get_element_id (p_element_name IN VARCHAR2)
83 RETURN NUMBER;
84
85 --
86 -- Bug 3926150. Added this useful utility function for this bug.
87 -- Can be of general use also.
88 -- bso Sat Dec 4 15:01:44 PST 2004
89 --
90 FUNCTION get_element_name (p_element_id IN NUMBER)
91 RETURN VARCHAR2;
92
93
94 FUNCTION has_hardcoded_lov (p_element_id IN NUMBER)
95 RETURN BOOLEAN;
96
97
98 -- anagarwa Tue Jun 22 14:19:42 PDT 2004
99 -- bug 3692326 Support element spec in QWB
100 FUNCTION lower_spec_limit(element_id IN NUMBER)
101 RETURN VARCHAR2;
102
103
104 FUNCTION upper_spec_limit(element_id IN NUMBER)
105 RETURN VARCHAR2;
106
107 FUNCTION target_value(element_id IN NUMBER)
108 RETURN VARCHAR2;
109
110
111 -- Bug 3754667. Added the below function to fetch the developer_name of
112 -- a collection element. kabalakr.
113
114 FUNCTION developer_name(element_id IN NUMBER)
115 RETURN VARCHAR2;
116
117
118 END qa_chars_api;