1 PACKAGE AME_ATTRIBUTE_USAGES_API AUTHID CURRENT_USER AS
2 /* $Header: ameauapi.pkh 120.0 2005/07/26 05:54:01 mbocutt noship $ */
3
4 procedure INSERT_ROW (
5 X_ATTRIBUTE_ID in NUMBER,
6 X_APPLICATION_ID in NUMBER,
7 X_QUERY_STRING in VARCHAR2,
8 X_USE_COUNT in NUMBER,
9 X_IS_STATIC in VARCHAR2,
10 X_CREATED_BY in NUMBER,
11 X_CREATION_DATE in DATE,
12 X_LAST_UPDATED_BY in NUMBER,
13 X_LAST_UPDATE_DATE in DATE,
14 X_LAST_UPDATE_LOGIN in NUMBER,
15 X_START_DATE in DATE,
16 X_USER_EDITABLE in VARCHAR2,
17 X_VALUE_SET_ID in NUMBER,
18 X_OBJECT_VERSION_NUMBER in NUMBER);
19
20 procedure UPDATE_ROW (
21 X_USAGES_ROWID in VARCHAR2,
22 X_END_DATE in DATE);
23
24 procedure DELETE_ROW (
25 X_ATTRIBUTE_ID in NUMBER,
26 X_APPLICATION_ID in NUMBER);
27
28 procedure LOAD_ROW (
29 X_ATTRIBUTE_NAME in VARCHAR2,
30 X_APPLICATION_NAME in VARCHAR2,
31 X_QUERY_STRING in VARCHAR2,
32 X_USER_EDITABLE in VARCHAR2,
33 X_IS_STATIC in VARCHAR2,
34 X_USE_COUNT in VARCHAR2,
35 X_VALUE_SET_NAME in VARCHAR2,
36 X_OWNER in VARCHAR2,
37 X_LAST_UPDATE_DATE in VARCHAR2,
38 X_CUSTOM_MODE in VARCHAR2);
39
40 procedure LOAD_SEED_ROW
41 (X_ATTRIBUTE_NAME in varchar2
42 ,X_APPLICATION_NAME in varchar2
43 ,X_QUERY_STRING in varchar2
44 ,X_USER_EDITABLE in varchar2
45 ,X_IS_STATIC in varchar2
46 ,X_USE_COUNT in varchar2
47 ,X_VALUE_SET_NAME in varchar2
48 ,X_OWNER in varchar2
49 ,X_LAST_UPDATE_DATE in varchar2
50 ,X_UPLOAD_MODE in varchar2
51 ,X_CUSTOM_MODE in varchar2
52 );
53 END AME_ATTRIBUTE_USAGES_API;