1 package ame_multi_tenancy_pkg as
2 /* $Header: amemultncy.pkh 120.0.12010000.2 2008/11/28 05:36:11 prasashe noship $ */
3 --+
4 type ref_cursor is REF CURSOR;
5 Type calling_apps is TABLE OF ame_calling_apps%rowtype index by binary_integer;
6 g_seed_call_apps calling_apps;
7 Type item_class_usg is TABLE OF ame_item_class_usages%rowtype index by binary_integer;
8 g_seed_ic_usg item_class_usg;
9 Type ame_config_vars_type is TABLE OF ame_config_vars%rowtype index by binary_integer;
10 g_seed_config_usg ame_config_vars_type;
11 Type attr_usages is TABLE OF ame_attribute_usages%rowtype index by binary_integer;
12 g_seed_mand_attr_usg attr_usages;
13 g_seed_attr_usg attr_usages;
14 Type ame_act_config is TABLE OF ame_action_type_config%rowtype index by binary_integer;
15 g_seed_act_config ame_act_config;
16 Type ame_act_usage is TABLE OF ame_action_usages%rowtype index by binary_integer;
17 g_seed_act_usage ame_act_usage;
18 Type ame_cond_usage is TABLE OF ame_condition_usages%rowtype index by binary_integer;
19 g_seed_cond_usage ame_cond_usage;
20 type group_details is record(
21 voting_regime varchar2(2)
22 ,order_number number
23 ,name varchar2(100)
24 ,approval_group_id number
25 ,query_string varchar2(4000)
26 ,is_static varchar2(2)
27 ,description varchar2(200)
28 ,group_last_updated_by number
29 ,config_last_updated_by number
30 ,group_creation_date date
31 ,config_creation_date date
32 );
33 Type ame_group_dets is table of group_details index by binary_integer;
34 g_seed_group_data ame_group_dets;
35 type rule_details is record(
36 rule_id integer,
37 description varchar2(100),
38 rule_type integer,
39 start_date date,
40 end_date date,
41 usage_start_date date,
42 usage_end_date date,
43 approver_category varchar2(2),
44 priority integer,
45 item_class_id number
46 );
47 Type ame_rule_dets is table of rule_details index by binary_integer;
48 g_seed_ame_rule ame_rule_dets;
49 --+
50 function isSeedUser(userId in number) return varchar2;
51 function isEntDataModified(p_creationDateIn in date, p_lastUpdateDateIn in date) return varchar2;
52 function getSeedUser return number;
53 function is_multi_tenant_system return varchar2;
54 function disableConditionUpd(conditionIdIn in number) return varchar2;
55 function isConfigUpdatable return varchar2;
56 --+
57 procedure logMessage(methodNameIn in varchar2, errMsgIn in varchar2);
58 procedure fetchSeedDataFromTables;
59 procedure copyTxnType(errbuf out nocopy varchar2,
60 retcode out nocopy number,
61 applicationIdIn in number,
62 enterpriseIdIn in varchar2);
63 --+
64 end ame_multi_tenancy_pkg;