1 PACKAGE HZ_TRANS_ATTRIBUTES_PKG AS
2 /*$Header: ARHDQTAS.pls 120.4 2005/10/30 04:19:26 appldev noship $: ARHDQTAS.pls */
3
4 procedure INSERT_ROW (
5 X_ATTRIBUTE_ID in out nocopy NUMBER,
6 X_ENTITY_NAME in VARCHAR2,
7 X_CUSTOM_ATTRIBUTE_PROCEDURE in VARCHAR2,
8 X_SOURCE_TABLE in VARCHAR2,
9 X_ATTRIBUTE_NAME in VARCHAR2,
10 X_USER_DEFINED_ATTRIBUTE_NAME in VARCHAR2,
11 X_DENORM_FLAG in VARCHAR2,
12 X_CREATION_DATE in DATE,
13 X_CREATED_BY in NUMBER,
14 X_LAST_UPDATE_DATE in DATE,
15 X_LAST_UPDATED_BY in NUMBER,
16 X_LAST_UPDATE_LOGIN in NUMBER,
17 X_OBJECT_VERSION_NUMBER NUMBER);
18
19 procedure LOCK_ROW (
20 X_ATTRIBUTE_ID in NUMBER,
21 X_OBJECT_VERSION_NUMBER NUMBER
22 );
23
24 procedure LOCK_ROW ( -- added due to bug 3621943
25 X_ATTRIBUTE_ID in NUMBER,
26 X_OBJECT_VERSION_NUMBER NUMBER,
27 X_USER_DEFINED_ATTRIBUTE_NAME in VARCHAR2
28 );
29
30 procedure UPDATE_ROW (
31 X_ATTRIBUTE_ID in NUMBER,
32 X_ENTITY_NAME in VARCHAR2,
33 X_CUSTOM_ATTRIBUTE_PROCEDURE in VARCHAR2,
34 X_SOURCE_TABLE in VARCHAR2,
35 X_ATTRIBUTE_NAME in VARCHAR2,
36 X_USER_DEFINED_ATTRIBUTE_NAME in VARCHAR2,
37 X_DENORM_FLAG in VARCHAR2,
38 X_LAST_UPDATE_DATE in DATE,
39 X_LAST_UPDATED_BY in NUMBER,
40 X_LAST_UPDATE_LOGIN in NUMBER,
41 X_OBJECT_VERSION_NUMBER in out nocopy NUMBER
42 );
43 procedure DELETE_ROW (
44 X_ATTRIBUTE_ID in NUMBER
45 );
46 procedure ADD_LANGUAGE;
47
48 procedure LOAD_ROW (
49 X_ATTRIBUTE_ID in NUMBER,
50 X_ENTITY_NAME in VARCHAR2,
51 X_CUSTOM_ATTRIBUTE_PROCEDURE in VARCHAR2,
52 X_SOURCE_TABLE in VARCHAR2,
53 X_ATTRIBUTE_NAME in VARCHAR2,
54 X_USER_DEFINED_ATTRIBUTE_NAME in VARCHAR2,
55 X_DENORM_FLAG 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_OBJECT_VERSION_NUMBER in NUMBER,
60 X_OWNER in VARCHAR2);
61
62 procedure TRANSLATE_ROW (
63 X_ATTRIBUTE_ID in NUMBER,
64 X_USER_DEFINED_ATTRIBUTE_NAME in VARCHAR2,
65 X_OWNER in VARCHAR2);
66
67 end HZ_TRANS_ATTRIBUTES_PKG;