1 PACKAGE GMD_EXPRESSION_UTIL AUTHID CURRENT_USER AS
2 /* $Header: GMDPEXPS.pls 120.1.12000000.1 2007/01/16 18:18:43 appldev ship $ */
3
4 TYPE operator_table IS TABLE OF VARCHAR2(40);
5
6 TYPE line_tab IS TABLE OF NUMBER(15);
7
8 TYPE expression_tab IS TABLE OF GMD_PARSED_EXPRESSION%ROWTYPE
9 INDEX BY BINARY_INTEGER;
10
11 PROCEDURE parse_expression
12 ( p_orgn_id IN NUMBER ,
13 p_tech_parm_id IN NUMBER,
14 p_expression IN VARCHAR2 ,
15 x_return_status OUT NOCOPY VARCHAR2
16 );
17
18 PROCEDURE insert_expression_key
19 ( p_orgn_id IN NUMBER,
20 p_tech_parm_id IN NUMBER,
21 p_key IN VARCHAR2,
22 x_return_status OUT NOCOPY VARCHAR2
23 );
24
25 FUNCTION is_operator
26 ( p_operator IN VARCHAR2
27 ) RETURN BOOLEAN;
28
29
30 FUNCTION is_parameter
31 ( p_orgn_id IN NUMBER ,
32 p_parameter IN VARCHAR2 ,
33 x_parm_id OUT NOCOPY NUMBER ,
34 x_data_type OUT NOCOPY NUMBER
35 ) RETURN BOOLEAN;
36
37 FUNCTION is_number
38 ( p_token IN VARCHAR2
39 ) RETURN BOOLEAN;
40
41 PROCEDURE add_expression_row
42 ( p_tech_parm_id IN NUMBER,
43 p_key IN VARCHAR2,
44 p_type IN VARCHAR2,
45 p_data_type IN NUMBER DEFAULT NULL,
46 p_exp_parm_id IN NUMBER DEFAULT NULL,
47 x_return_status OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE evaluate_expression_value
51 ( p_line_id IN NUMBER,
52 P_expression_tab IN EXPRESSION_TAB,
53 x_value OUT NOCOPY VARCHAR2,
54 x_return_status OUT NOCOPY VARCHAR2
55 );
56
57
58 FUNCTION get_value
59 ( p_line_id IN NUMBER,
60 p_parameter IN VARCHAR2
61 ) RETURN VARCHAR2;
62
63 PROCEDURE evaluate_expression
64 ( p_entity_id IN NUMBER,
65 p_line_id IN NUMBER,
66 p_tech_parm_id IN NUMBER,
67 x_value OUT NOCOPY NUMBER,
68 x_expression OUT NOCOPY VARCHAR2,
69 x_return_status OUT NOCOPY VARCHAR2
70 );
71
72
73 END GMD_EXPRESSION_UTIL;