1 package AMS_ATTB_LOV_VALUES_PKG as
2 /* $Header: amstatvs.pls 120.1 2005/06/27 05:39:40 appldev ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in OUT NOCOPY VARCHAR2,
5 X_ATTB_LOV_VALUE_ID in NUMBER,
6 X_OBJECT_VERSION_NUMBER in NUMBER,
7 X_REQUEST_ID in NUMBER,
8 X_VIEW_APPLICATION_ID in NUMBER,
9 X_ATTB_LOV_ID in NUMBER,
10 X_VALUE_CODE in VARCHAR2,
11 X_SECURITY_GROUP_ID in NUMBER,
12 X_VALUE_MEANING in VARCHAR2,
13 X_CREATION_DATE in DATE,
14 X_CREATED_BY in NUMBER,
15 X_LAST_UPDATE_DATE in DATE,
16 X_LAST_UPDATED_BY in NUMBER,
17 X_LAST_UPDATE_LOGIN in NUMBER,
18 X_PROGRAM_ID in NUMBER,
19 X_PROGRAM_APPLICATION_ID in NUMBER,
20 X_PROGRAM_UPDATE_DATE in DATE
21 );
22 procedure LOCK_ROW (
23 X_ATTB_LOV_VALUE_ID in NUMBER,
24 X_OBJECT_VERSION_NUMBER in NUMBER,
25 X_REQUEST_ID in NUMBER,
26 X_VIEW_APPLICATION_ID in NUMBER,
27 X_ATTB_LOV_ID in NUMBER,
28 X_VALUE_CODE in VARCHAR2,
29 X_SECURITY_GROUP_ID in NUMBER,
30 X_VALUE_MEANING in VARCHAR2,
31 X_PROGRAM_ID in NUMBER,
32 X_PROGRAM_APPLICATION_ID in NUMBER,
33 X_PROGRAM_UPDATE_DATE in DATE
34 );
35 procedure UPDATE_ROW (
36 X_ATTB_LOV_VALUE_ID in NUMBER,
37 X_OBJECT_VERSION_NUMBER in NUMBER,
38 X_REQUEST_ID in NUMBER,
39 X_VIEW_APPLICATION_ID in NUMBER,
40 X_ATTB_LOV_ID in NUMBER,
41 X_VALUE_CODE in VARCHAR2,
42 X_SECURITY_GROUP_ID in NUMBER,
43 X_VALUE_MEANING in VARCHAR2,
44 X_LAST_UPDATE_DATE in DATE,
45 X_LAST_UPDATED_BY in NUMBER,
46 X_LAST_UPDATE_LOGIN in NUMBER,
47 X_PROGRAM_ID in NUMBER,
48 X_PROGRAM_APPLICATION_ID in NUMBER,
49 X_PROGRAM_UPDATE_DATE in DATE
50 );
51 procedure DELETE_ROW (
52 X_ATTB_LOV_VALUE_ID in NUMBER
53 );
54 procedure ADD_LANGUAGE;
55 procedure TRANSLATE_ROW(
56 X_ATTB_LOV_VALUE_ID in NUMBER,
57 X_VALUE_MEANING in VARCHAR2,
58 x_owner in VARCHAR2,
59 x_custom_mode in VARCHAR2
60 ) ;
61
62 procedure LOAD_ROW (
63 X_ATTB_LOV_VALUE_ID in NUMBER,
64 X_VIEW_APPLICATION_ID in NUMBER,
65 X_ATTB_LOV_ID in NUMBER,
66 X_VALUE_CODE in VARCHAR2,
67 X_VALUE_MEANING in VARCHAR2,
68 X_OWNER in VARCHAR2,
69 x_custom_mode in VARCHAR2
70 );
71
72
73 end AMS_ATTB_LOV_VALUES_PKG;