1 PACKAGE AME_APPROVAL_GROUPS_LOAD_API AS
2 /* $Header: ameagapi.pkh 120.0 2005/07/26 05:52:58 mbocutt noship $ */
3
4 procedure INSERT_ROW (X_NAME in VARCHAR2
5 ,X_QUERY_STRING in VARCHAR2
6 ,X_IS_STATIC in VARCHAR2
7 ,X_DESCRIPTION in VARCHAR2
8 ,X_CREATED_BY in NUMBER
9 ,X_CREATION_DATE in DATE
10 ,X_LAST_UPDATED_BY in NUMBER
11 ,X_LAST_UPDATE_DATE in DATE
12 ,X_LAST_UPDATE_LOGIN in NUMBER
13 ,X_START_DATE in DATE
14 ,X_OBJECT_VERSION_NUMBER in NUMBER
15 ,X_APPROVAL_GROUP_ID in out nocopy NUMBER
16 );
17
18 procedure UPDATE_ROW (X_APPROVAL_GROUP_ROWID in VARCHAR2
19 ,X_END_DATE in DATE
20 ,X_APPROVAL_GROUP_ID in NUMBER
21 ,X_NAME in VARCHAR2
22 ,X_QUERY_STRING in VARCHAR2
23 ,X_IS_STATIC in VARCHAR2
24 ,X_CREATED_BY in NUMBER
25 ,X_CREATION_DATE in DATE
26 ,X_LAST_UPDATED_BY in NUMBER
27 ,X_LAST_UPDATE_DATE in DATE
28 ,X_LAST_UPDATE_LOGIN in NUMBER
29 ,X_START_DATE in DATE
30 ,X_DESCRIPTION in VARCHAR2
31 ,X_OBJECT_VERSION_NUMBER in NUMBER
32 );
33
34 procedure DELETE_ROW (X_APPROVAL_GROUP_ID in NUMBER
35 );
36
37 procedure LOAD_ROW(X_APPROVAL_GROUP_NAME in VARCHAR2
38 ,X_USER_APPROVAL_GROUP_NAME in VARCHAR2
39 ,X_DESCRIPTION in VARCHAR2
40 ,X_QUERY_STRING in VARCHAR2
41 ,X_IS_STATIC in VARCHAR2
42 ,X_OWNER in VARCHAR2
43 ,X_LAST_UPDATE_DATE in VARCHAR2
44 ,X_CUSTOM_MODE in VARCHAR2
45 );
46
47 procedure TRANSLATE_ROW
48 (X_APPROVAL_GROUP_NAME in VARCHAR2
49 ,X_USER_APPROVAL_GROUP_NAME in VARCHAR2
50 ,X_DESCRIPTION in VARCHAR2
51 ,X_OWNER in varchar2
52 ,X_LAST_UPDATE_DATE in varchar2
53 ,X_CUSTOM_MODE in varchar2
54 );
55
56 END AME_APPROVAL_GROUPS_LOAD_API;