DBA Data[Home] [Help]

PACKAGE: APPS.AME_SEED_UTILITY

Source


1 package AME_SEED_UTILITY as
2 /* $Header: ameseedutility.pkh 120.4 2006/03/10 07:19 pvelugul noship $ */
3   AME_INSTALLATION_LEVEL varchar2(255) := null;
4 
5   END_OF_TIME constant date := to_date('31-12-4712 00:00:00','DD-MM-YYYY HH24:MI:SS');
6 
7   procedure INIT_AME_INSTALLATION_LEVEL;
8 
9   function OWNER_AS_STRING
10     (X_LAST_UPDATED_BY   in number
11     ) return varchar2;
12 
13   function DATE_AS_STRING
14     (X_LAST_UPDATE_DATE  in date
15     ) return varchar2;
16 
17   function OWNER_AS_INTEGER
18     (X_LAST_UPDATED_BY   in varchar2
19     ) return number;
20 
21   function DATE_AS_DATE
22     (X_LAST_UPDATE_DATE  in varchar2
23     ) return date;
24 
25   function IS_SEED_USER
26     (X_USER    in VARCHAR2
27     ) return boolean;
28 
29   function SEED_USER_ID return integer;
30 
31   function SEED_USER_NAME return varchar2;
32 
33   function MERGE_ROW_TEST
34     (X_CURRENT_OWNER              in number
35     ,X_CURRENT_LAST_UPDATE_DATE   in varchar2
36     ,X_OWNER                      in number
37     ,X_LAST_UPDATE_DATE           in varchar2
38     ,X_CUSTOM_MODE                in varchar2
39     ) return boolean;
40 
41   function TL_MERGE_ROW_TEST
42     (X_CURRENT_OWNER              in number
43     ,X_CURRENT_LAST_UPDATE_DATE   in varchar2
44     ,X_OWNER                      in number
45     ,X_LAST_UPDATE_DATE           in varchar2
46     ,X_CUSTOM_MODE                in varchar2
47     ) return boolean;
48 
49   function GET_DEFAULT_END_DATE return date;
50 
51   function MLS_ENABLED return boolean;
52 
53   function CALCULATE_USE_COUNT(X_ATTRIBUTE_ID ame_attribute_usages.attribute_id%type
54                               ,X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer;
55 
56   function USER_ID_OF_SEED_USER return integer;
57 
58   procedure create_parallel_config
59     (x_action_type_id in integer
60     ,x_action_type_name in varchar2
61     ,x_action_id in integer
62     ,x_approval_group_id in integer
63     );
64 
65   procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type
66                                        ,X_APPLICATION_ID ame_rule_usages.item_id%type);
67 
68 end AME_SEED_UTILITY;