1 PACKAGE HZ_WORK_CLASS_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHPWCTS.pls 115.5 2003/02/10 09:56:56 ssmohan ship $ */
3
4
5 PROCEDURE Insert_Row(
6 x_WORK_CLASS_ID IN OUT NOCOPY NUMBER,
7 x_LEVEL_OF_EXPERIENCE IN VARCHAR2,
8 x_WORK_CLASS_NAME IN VARCHAR2,
9 x_EMPLOYMENT_HISTORY_ID IN NUMBER,
10 x_STATUS IN VARCHAR2,
11 x_OBJECT_VERSION_NUMBER IN NUMBER,
12 x_CREATED_BY_MODULE IN VARCHAR2,
13 x_application_id IN NUMBER
14 );
15
16
17
18 PROCEDURE Lock_Row(
19 x_Rowid IN VARCHAR2,
20 x_WORK_CLASS_ID IN NUMBER,
21 x_LEVEL_OF_EXPERIENCE IN VARCHAR2,
22 x_WORK_CLASS_NAME IN VARCHAR2,
23 x_CREATED_BY IN NUMBER,
24 x_EMPLOYMENT_HISTORY_ID IN NUMBER,
25 x_CREATION_DATE IN DATE,
26 x_LAST_UPDATE_LOGIN IN NUMBER,
27 x_LAST_UPDATE_DATE IN DATE,
28 x_LAST_UPDATED_BY IN NUMBER,
29 x_REQUEST_ID IN NUMBER,
30 x_PROGRAM_APPLICATION_ID IN NUMBER,
31 x_PROGRAM_ID IN NUMBER,
32 x_PROGRAM_UPDATE_DATE IN DATE,
33 x_STATUS IN VARCHAR2);
34
35
36
37 PROCEDURE Update_Row(
38 x_Rowid IN OUT NOCOPY VARCHAR2,
39 x_WORK_CLASS_ID IN NUMBER,
40 x_LEVEL_OF_EXPERIENCE IN VARCHAR2,
41 x_WORK_CLASS_NAME IN VARCHAR2,
42 x_EMPLOYMENT_HISTORY_ID IN NUMBER,
43 x_STATUS IN VARCHAR2,
44 x_OBJECT_VERSION_NUMBER IN NUMBER,
45 x_CREATED_BY_MODULE IN VARCHAR2,
46 x_application_id IN NUMBER
47 );
48
49
50 PROCEDURE Select_Row (
51 x_work_class_id IN OUT NOCOPY NUMBER,
52 x_level_of_experience OUT NOCOPY VARCHAR2,
53 x_work_class_name OUT NOCOPY VARCHAR2,
54 x_employment_history_id OUT NOCOPY NUMBER,
55 x_status OUT NOCOPY VARCHAR2,
56 x_application_id OUT NOCOPY NUMBER,
57 x_created_by_module OUT NOCOPY VARCHAR2
58 );
59
60
61
62 PROCEDURE Delete_Row( x_WORK_CLASS_ID IN NUMBER);
63
64 END HZ_WORK_CLASS_PKG;