1 Package ecx_Conditions AUTHID CURRENT_USER as
2 -- $Header: ECXCONDS.pls 120.4 2005/10/30 23:24:48 susaha ship $
3 /** Check for following conditions =,!=,>,<,>=,<=,null,not null
4 condition type will be passed as condition and the condition variable on which the condition needs to be evaluated
5 **/
6 function check_type_condition
7 (
8 type in varchar2,
9 variable in varchar2,
10 vartype in pls_integer,
11 value in varchar2,
12 valtype in pls_integer
13 ) return boolean;
14
15 function check_condition
16 (
17 type in varchar2, -- AND,OR
18 type1 in varchar2, --- =,!=,>,<,>=,<=,null,not null
19 variable1 in varchar2,
20 vartype1 in pls_integer,
21 value1 in varchar2,
22 valtype1 in pls_integer,
23 type2 in varchar2,
24 variable2 in varchar2,
25 vartype2 in pls_integer,
26 value2 in varchar2,
27 valtype2 in pls_integer
28 ) return boolean;
29
30 function math_functions
31 (
32 type in varchar2,
33 x in number,
34 y in number
35 )
36 return number;
37 procedure getLengthForString
38 (
39 i_string in varchar2,
40 i_length OUT NOCOPY pls_integer
41 );
42 procedure getPositionInString
43 (
44 i_string in varchar2,
45 i_search_string in varchar2,
46 i_start_position in pls_integer default null,
47 i_occurrence in pls_integer default null,
48 i_position OUT NOCOPY pls_integer
49 );
50 procedure getSubString
51 (
52 i_string in varchar2,
53 i_start_position in pls_integer default 0,
54 i_length in pls_integer default 0,
55 i_substr OUT NOCOPY varchar2
56 );
57
58 procedure test;
59
60 end ecx_conditions;