1 PACKAGE HZ_PERSON_LANGUAGE_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHPLATS.pls 115.5 2003/02/10 09:49:04 ssmohan ship $ */
3
4 PROCEDURE Insert_Row (
5 X_LANGUAGE_USE_REFERENCE_ID IN OUT NOCOPY NUMBER,
6 X_LANGUAGE_NAME IN VARCHAR2,
7 X_PARTY_ID IN NUMBER,
8 X_NATIVE_LANGUAGE IN VARCHAR2,
9 X_PRIMARY_LANGUAGE_INDICATOR IN VARCHAR2,
10 X_READS_LEVEL IN VARCHAR2,
11 X_SPEAKS_LEVEL IN VARCHAR2,
12 X_WRITES_LEVEL IN VARCHAR2,
13 X_SPOKEN_COMPREHENSION_LEVEL IN VARCHAR2,
14 X_STATUS IN VARCHAR2,
15 X_OBJECT_VERSION_NUMBER IN NUMBER,
16 X_CREATED_BY_MODULE IN VARCHAR2,
17 X_APPLICATION_ID IN NUMBER
18 );
19
20
21 PROCEDURE Update_Row (
22 X_Rowid IN OUT NOCOPY VARCHAR2,
23 X_LANGUAGE_USE_REFERENCE_ID IN NUMBER,
24 X_LANGUAGE_NAME IN VARCHAR2,
25 X_PARTY_ID IN NUMBER,
26 X_NATIVE_LANGUAGE IN VARCHAR2,
27 X_PRIMARY_LANGUAGE_INDICATOR IN VARCHAR2,
28 X_READS_LEVEL IN VARCHAR2,
29 X_SPEAKS_LEVEL IN VARCHAR2,
30 X_WRITES_LEVEL IN VARCHAR2,
31 X_SPOKEN_COMPREHENSION_LEVEL IN VARCHAR2,
32 X_STATUS IN VARCHAR2,
33 X_OBJECT_VERSION_NUMBER IN NUMBER,
34 X_CREATED_BY_MODULE IN VARCHAR2,
35 X_APPLICATION_ID IN NUMBER
36 );
37
38
39 PROCEDURE Lock_Row (
40 X_Rowid IN OUT NOCOPY VARCHAR2,
41 X_LANGUAGE_USE_REFERENCE_ID IN NUMBER,
42 X_LANGUAGE_NAME IN VARCHAR2,
43 X_PARTY_ID IN NUMBER,
44 X_NATIVE_LANGUAGE IN VARCHAR2,
45 X_PRIMARY_LANGUAGE_INDICATOR IN VARCHAR2,
46 X_READS_LEVEL IN VARCHAR2,
47 X_SPEAKS_LEVEL IN VARCHAR2,
48 X_WRITES_LEVEL IN VARCHAR2,
49 X_SPOKEN_COMPREHENSION_LEVEL IN VARCHAR2,
50 X_LAST_UPDATE_DATE IN DATE,
51 X_LAST_UPDATED_BY IN NUMBER,
52 X_CREATED_BY IN NUMBER,
53 X_CREATION_DATE IN DATE,
54 X_LAST_UPDATE_LOGIN IN NUMBER,
55 X_REQUEST_ID IN NUMBER,
56 X_PROGRAM_APPLICATION_ID IN NUMBER,
57 X_PROGRAM_ID IN NUMBER,
58 X_PROGRAM_UPDATE_DATE IN DATE,
59 X_STATUS IN VARCHAR2,
60 X_OBJECT_VERSION_NUMBER IN NUMBER,
61 X_CREATED_BY_MODULE IN VARCHAR2,
62 X_APPLICATION_ID IN NUMBER
63 );
64
65
66 PROCEDURE Select_Row (
67 X_LANGUAGE_USE_REFERENCE_ID IN OUT NOCOPY NUMBER,
68 X_LANGUAGE_NAME OUT NOCOPY VARCHAR2,
69 X_PARTY_ID OUT NOCOPY NUMBER,
70 X_NATIVE_LANGUAGE OUT NOCOPY VARCHAR2,
71 X_PRIMARY_LANGUAGE_INDICATOR OUT NOCOPY VARCHAR2,
72 X_READS_LEVEL OUT NOCOPY VARCHAR2,
73 X_SPEAKS_LEVEL OUT NOCOPY VARCHAR2,
74 X_WRITES_LEVEL OUT NOCOPY VARCHAR2,
75 X_SPOKEN_COMPREHENSION_LEVEL OUT NOCOPY VARCHAR2,
76 X_STATUS OUT NOCOPY VARCHAR2,
77 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
78 X_APPLICATION_ID OUT NOCOPY NUMBER
79 );
80
81
82 PROCEDURE Delete_Row (
83 X_LANGUAGE_USE_REFERENCE_ID IN NUMBER
84 );
85
86
87 END HZ_PERSON_LANGUAGE_PKG;
[Home] [Help]