1 PACKAGE IEX_SCORE_COMP_TYPES_PKG AUTHID CURRENT_USER AS
2 /* $Header: iextscts.pls 120.2 2004/11/05 21:35:07 jypark ship $ */
3 PROCEDURE INSERT_ROW (
4 X_ROWID IN OUT NOCOPY VARCHAR2,
5 P_SCORE_COMP_TYPE_ID IN NUMBER,
6 P_OBJECT_VERSION_NUMBER IN NUMBER,
7 P_SCORE_COMP_VALUE IN VARCHAR2,
8 P_ACTIVE_FLAG IN VARCHAR2,
9 P_SCORE_COMP_NAME IN VARCHAR2,
10 P_DESCRIPTION IN VARCHAR2,
11 P_CREATION_DATE IN DATE,
12 P_CREATED_BY IN NUMBER,
13 P_LAST_UPDATE_DATE IN DATE,
14 P_LAST_UPDATED_BY IN NUMBER,
15 P_LAST_UPDATE_LOGIN IN NUMBER,
16 P_JTF_OBJECT_CODE IN VARCHAR2,
17 P_FUNCTION_FLAG IN VARCHAR2,
18 P_METRIC_FLAG IN VARCHAR2,
19 P_DISPLAY_ORDER IN NUMBER);
20
21 PROCEDURE LOCK_ROW (
22 P_SCORE_COMP_TYPE_ID IN NUMBER,
23 P_OBJECT_VERSION_NUMBER IN NUMBER,
24 P_SCORE_COMP_VALUE IN VARCHAR2,
25 P_ACTIVE_FLAG IN VARCHAR2,
26 P_SCORE_COMP_NAME IN VARCHAR2);
27
28 PROCEDURE UPDATE_ROW (
29 P_SCORE_COMP_TYPE_ID IN NUMBER,
30 P_OBJECT_VERSION_NUMBER IN NUMBER,
31 P_SCORE_COMP_VALUE IN VARCHAR2,
32 P_ACTIVE_FLAG IN VARCHAR2,
33 P_SCORE_COMP_NAME IN VARCHAR2,
34 P_LAST_UPDATE_DATE IN DATE,
35 P_LAST_UPDATED_BY IN NUMBER,
36 P_LAST_UPDATE_LOGIN IN NUMBER,
37 P_DESCRIPTION IN VARCHAR2,
38 P_JTF_OBJECT_CODE IN VARCHAR2,
39 P_FUNCTION_FLAG IN VARCHAR2,
40 P_METRIC_FLAG IN VARCHAR2,
41 P_DISPLAY_ORDER IN NUMBER);
42
43 PROCEDURE DELETE_ROW (P_SCORE_COMP_TYPE_ID IN NUMBER);
44
45 PROCEDURE ADD_LANGUAGE;
46
47 END IEX_SCORE_COMP_TYPES_PKG;