1 package OKE_TERMS_PKG as
2 /* $Header: OKETERMS.pls 120.1 2005/06/02 12:01:02 appldev $ */
3
4 PROCEDURE INSERT_ROW
5 ( X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6 , X_TERM_CODE IN VARCHAR2
7 , X_TERM_TYPE_CODE IN VARCHAR2
8 , X_TERM_NAME IN VARCHAR2
9 , X_DESCRIPTION IN VARCHAR2
10 , X_USER_DEFINED_FLAG IN VARCHAR2
11 , X_VIEW_APPL_ID IN NUMBER
12 , X_LOOKUP_TYPE 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 );
19
20 PROCEDURE LOCK_ROW
21 ( X_TERM_CODE IN VARCHAR2
22 , X_TERM_TYPE_CODE IN VARCHAR2
23 , X_TERM_NAME IN VARCHAR2
24 , X_DESCRIPTION IN VARCHAR2
25 , X_USER_DEFINED_FLAG IN VARCHAR2
26 , X_VIEW_APPL_ID IN NUMBER
27 , X_LOOKUP_TYPE IN VARCHAR2
28 );
29
30 PROCEDURE UPDATE_ROW
31 ( X_TERM_CODE IN VARCHAR2
32 , X_TERM_TYPE_CODE IN VARCHAR2
33 , X_TERM_NAME IN VARCHAR2
34 , X_DESCRIPTION IN VARCHAR2
35 , X_USER_DEFINED_FLAG IN VARCHAR2
36 , X_VIEW_APPL_ID IN NUMBER
37 , X_LOOKUP_TYPE IN VARCHAR2
38 , X_LAST_UPDATE_DATE IN DATE
39 , X_LAST_UPDATED_BY IN NUMBER
40 , X_LAST_UPDATE_LOGIN IN NUMBER
41 );
42
43 PROCEDURE DELETE_ROW
44 ( X_TERM_CODE IN VARCHAR2
45 );
46
47 PROCEDURE ADD_LANGUAGE;
48
49 PROCEDURE LOAD_ROW
50 ( X_TERM_CODE IN VARCHAR2
51 , X_OWNER IN VARCHAR2
52 , X_LAST_UPDATE_DATE IN DATE
53 , X_CUSTOM_MODE IN VARCHAR2
54 , X_TERM_TYPE_CODE IN VARCHAR2
55 , X_TERM_NAME IN VARCHAR2
56 , X_DESCRIPTION IN VARCHAR2
57 , X_USER_DEFINED_FLAG IN VARCHAR2
58 , X_VIEW_APPL_ID IN NUMBER
59 , X_LOOKUP_TYPE IN VARCHAR2
60 );
61
62 PROCEDURE TRANSLATE_ROW
63 ( X_TERM_CODE IN VARCHAR2
64 , X_OWNER IN VARCHAR2
65 , X_LAST_UPDATE_DATE IN DATE
66 , X_TERM_NAME IN VARCHAR2
67 , X_DESCRIPTION IN VARCHAR2
68 );
69
70 end OKE_TERMS_PKG;
[Home] [Help]