1 package ame_utility_pkg AUTHID CURRENT_USER as
2 /* $Header: ameutility.pkh 120.4 2006/01/04 06:00 pvelugul noship $ */
3
4 endOfTime constant date := to_date('31-12-4712', 'DD-MM-YYYY');
5
6 defaultAmeAppId constant integer := 0;
7
8 -- IMPORTANT:
9 -- This procedure should only be called from middle tier using the
10 -- format: select ame_utility_pkg.validate_query() from dual
11 -- Otherwise in the process of validation of SQL if a DDL operation
12 -- is passed then it gets executed.
13 -- e.g. ame_utility_pkg.validate_query('create table a(b number(5))')
14 -- If no such situtation is expected then it can be called safely
15 function validate_query
16 (p_query_string varchar2
17 ,p_columns number default null
18 ,p_object varchar2 default null
19 ) return varchar2;
20
21 function get_action_description(p_action_id in number
22 ,p_effective_date in date default sysdate) return varchar2;
23
24 function is_approver_valid_in_action(p_action_type_id in number
25 ,p_action_id in number) return varchar2;
26
27 procedure purge_log
28 (p_transaction_type in varchar2 default null
29 ,p_transaction_id in varchar2 default null
30 ,p_success out nocopy varchar2
31 );
32
33 function get_condition_description(p_condition_id in varchar2
34 ,p_truncate in varchar2 default 'Y'
35 ,p_effective_date in date default sysdate) return varchar2;
36
37 function get_action_types(p_attribute_id number) return varchar2;
38
39 function get_attribute_category(p_attribute_id number) return varchar2;
40
41 procedure set_ame_savepoint;
42
43 procedure rollback_to_ame_savepoint;
44
45 procedure get_value_set_query
46 (p_value_set_id in number
47 ,p_select out nocopy varchar2);
48
49 function get_rule_last_update_date
50 (p_rule_id integer
51 ,p_application_id integer
52 ,p_usage_start_date date
53 ) return date;
54
55 function get_rule_last_updated_by
56 (p_rule_id integer
57 ,p_application_id integer
58 ,p_usage_start_date date
59 ) return integer;
60
61 function is_rule_updatable
62 (p_rule_id integer
63 ,p_application_id integer
64 ,p_usage_start_date date
65 ) return varchar2;
66
67 function get_rule_last_update_action
68 (p_rule_id integer
69 ,p_application_id integer
70 ,p_usage_start_date date
71 ,p_usage_end_date date
72 ) return varchar2;
73
74 function is_valid_attribute
75 (p_attribute_id in varchar2
76 ,p_application_id in varchar2
77 ,p_allow_all in varchar2
78 ) return varchar2;
79
80 function get_rule_end_date
81 (p_rule_id integer
82 ) return date;
83
84 function check_seeddb return varchar2;
85 function get_rule_id return number;
86 function get_condition_id return number;
87 function get_item_class_id return number;
88 function getNextApproverTypeId return integer;
89 function is_seed_user
90 (p_user_id integer
91 ) return number;
92
93 end ame_utility_pkg;