1 package AMS_ATTB_LOV_PKG as
2 /* $Header: amstatbs.pls 120.1 2005/06/27 05:39:31 appldev ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in OUT NOCOPY VARCHAR2,
5 X_ATTB_LOV_ID in NUMBER,
6 X_DATA_TYPE in VARCHAR2,
7 X_OBJECT_VERSION_NUMBER in NUMBER,
8 X_REQUEST_ID in NUMBER,
9 X_VIEW_APPLICATION_ID in NUMBER,
10 X_CREATION_TYPE in VARCHAR2,
11 X_STATUS_CODE in VARCHAR2,
12 X_LOV_SEEDED_FOR in VARCHAR2,
13 X_SEEDED_FLAG in VARCHAR2,
14 X_SECURITY_GROUP_ID in NUMBER,
15 X_ATTB_LOV_NAME in VARCHAR2,
16 X_DESCRIPTION in VARCHAR2,
17 X_CREATION_DATE in DATE,
18 X_CREATED_BY in NUMBER,
19 X_LAST_UPDATE_DATE in DATE,
20 X_LAST_UPDATED_BY in NUMBER,
21 X_LAST_UPDATE_LOGIN in NUMBER,
22 X_PROGRAM_ID in NUMBER,
23 X_PROGRAM_APPLICATION_ID in NUMBER,
24 X_PROGRAM_UPDATE_DATE in DATE
25 );
26 procedure LOCK_ROW (
27 X_ATTB_LOV_ID in NUMBER,
28 X_DATA_TYPE in VARCHAR2,
29 X_OBJECT_VERSION_NUMBER in NUMBER,
30 X_REQUEST_ID in NUMBER,
31 X_VIEW_APPLICATION_ID in NUMBER,
32 X_CREATION_TYPE in VARCHAR2,
33 X_STATUS_CODE in VARCHAR2,
34 X_LOV_SEEDED_FOR in VARCHAR2,
35 X_SEEDED_FLAG in VARCHAR2,
36 X_SECURITY_GROUP_ID in NUMBER,
37 X_ATTB_LOV_NAME in VARCHAR2,
38 X_DESCRIPTION in VARCHAR2,
39 X_PROGRAM_ID in NUMBER,
40 X_PROGRAM_APPLICATION_ID in NUMBER,
41 X_PROGRAM_UPDATE_DATE in DATE
42 );
43 procedure UPDATE_ROW (
44 X_ATTB_LOV_ID in NUMBER,
45 X_DATA_TYPE in VARCHAR2,
46 X_OBJECT_VERSION_NUMBER in NUMBER,
47 X_REQUEST_ID in NUMBER,
48 X_VIEW_APPLICATION_ID in NUMBER,
49 X_CREATION_TYPE in VARCHAR2,
50 X_STATUS_CODE in VARCHAR2,
51 X_LOV_SEEDED_FOR in VARCHAR2,
52 X_SEEDED_FLAG in VARCHAR2,
53 X_SECURITY_GROUP_ID in NUMBER,
54 X_ATTB_LOV_NAME in VARCHAR2,
55 X_DESCRIPTION in VARCHAR2,
56 X_LAST_UPDATE_DATE in DATE,
57 X_LAST_UPDATED_BY in NUMBER,
58 X_LAST_UPDATE_LOGIN in NUMBER,
59 X_PROGRAM_ID in NUMBER,
60 X_PROGRAM_APPLICATION_ID in NUMBER,
61 X_PROGRAM_UPDATE_DATE in DATE
62
63 );
64 procedure DELETE_ROW (
65 X_ATTB_LOV_ID in NUMBER
66 );
67
68 PROCEDURE load_row (
69 X_ATTB_LOV_ID in NUMBER,
70 X_DATA_TYPE in VARCHAR2,
71 X_VIEW_APPLICATION_ID in NUMBER,
72 X_CREATION_TYPE in VARCHAR2,
73 X_STATUS_CODE in VARCHAR2,
74 X_LOV_SEEDED_FOR in VARCHAR2,
75 X_SEEDED_FLAG in VARCHAR2,
76 X_ATTB_LOV_NAME in VARCHAR2,
77 X_DESCRIPTION in VARCHAR2,
78 x_owner IN VARCHAR2,
79 x_custom_mode IN VARCHAR2
80 );
81
82 procedure ADD_LANGUAGE;
83 procedure TRANSLATE_ROW(
84 X_ATTB_LOV_ID in NUMBER,
85 X_ATTB_LOV_NAME in VARCHAR2,
86 X_DESCRIPTION in VARCHAR2,
87 x_owner in VARCHAR2,
88 x_custom_mode IN VARCHAR2
89
90 ) ;
91
92 end AMS_ATTB_LOV_PKG;