1 PACKAGE HZ_EMPLOYMENT_HISTORY_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHEHITS.pls 115.7 2003/04/11 15:48:33 pchinnan ship $ */
3
4
5 PROCEDURE Insert_Row(
6 x_EMPLOYMENT_HISTORY_ID IN OUT NOCOPY NUMBER,
7 x_BEGIN_DATE IN DATE,
8 x_PARTY_ID IN NUMBER,
9 x_EMPLOYED_AS_TITLE IN VARCHAR2,
10 x_EMPLOYED_BY_DIVISION_NAME IN VARCHAR2,
11 x_EMPLOYED_BY_NAME_COMPANY IN VARCHAR2,
12 x_END_DATE IN DATE,
13 x_SUPERVISOR_NAME IN VARCHAR2,
14 x_BRANCH IN VARCHAR2,
15 x_MILITARY_RANK IN VARCHAR2,
16 x_SERVED IN VARCHAR2,
17 x_STATION IN VARCHAR2,
18 x_RESPONSIBILITY IN VARCHAR2,
19 x_STATUS IN VARCHAR2,
20 x_OBJECT_VERSION_NUMBER IN NUMBER,
21 x_CREATED_BY_MODULE IN VARCHAR2,
22 x_APPLICATION_ID IN NUMBER,
23 x_EMPLOYED_BY_PARTY_ID IN NUMBER,
24 x_REASON_FOR_LEAVING IN VARCHAR2,
25 x_FACULTY_POSITION_FLAG IN VARCHAR2,
26 x_TENURE_CODE IN VARCHAR2,
27 x_FRACTION_OF_TENURE IN NUMBER,
28 x_EMPLOYMENT_TYPE_CODE IN VARCHAR2,
29 x_EMPLOYED_AS_TITLE_CODE IN VARCHAR2,
30 x_WEEKLY_WORK_HOURS IN NUMBER,
31 x_COMMENTS IN VARCHAR2
32 );
33
34 PROCEDURE Lock_Row(
35 x_Rowid IN VARCHAR2,
36 x_EMPLOYMENT_HISTORY_ID IN NUMBER,
37 x_BEGIN_DATE IN DATE,
38 x_PARTY_ID IN NUMBER,
39 x_EMPLOYED_AS_TITLE IN VARCHAR2,
40 x_EMPLOYED_BY_DIVISION_NAME IN VARCHAR2,
41 x_EMPLOYED_BY_NAME_COMPANY IN VARCHAR2,
42 x_END_DATE IN DATE,
43 x_SUPERVISOR_NAME IN VARCHAR2,
44 x_BRANCH IN VARCHAR2,
45 x_MILITARY_RANK IN VARCHAR2,
46 x_CREATED_BY IN NUMBER,
47 x_CREATION_DATE IN DATE,
48 x_SERVED IN VARCHAR2,
49 x_LAST_UPDATE_LOGIN IN NUMBER,
50 x_STATION IN VARCHAR2,
51 x_LAST_UPDATE_DATE IN DATE,
52 x_LAST_UPDATED_BY IN NUMBER,
53 x_REQUEST_ID IN NUMBER,
54 x_PROGRAM_APPLICATION_ID IN NUMBER,
55 x_PROGRAM_ID IN NUMBER,
56 x_PROGRAM_UPDATE_DATE IN DATE,
57 x_WH_UPDATE_DATE IN DATE,
58 x_RESPONSIBILITY IN VARCHAR2,
59 x_STATUS IN VARCHAR2,
60 x_EMPLOYED_BY_PARTY_ID IN NUMBER,
61 x_REASON_FOR_LEAVING IN VARCHAR2,
62 x_FACULTY_POSITION_FLAG IN VARCHAR2,
63 x_TENURE_CODE IN VARCHAR2,
64 x_FRACTION_OF_TENURE IN NUMBER,
65 x_EMPLOYMENT_TYPE_CODE IN VARCHAR2,
66 x_EMPLOYED_AS_TITLE_CODE IN VARCHAR2,
67 x_WEEKLY_WORK_HOURS IN NUMBER,
68 x_COMMENTS IN VARCHAR2,
69 x_APPLICATION_ID IN NUMBER
70
71 );
72
73 PROCEDURE Update_Row(
74 x_Rowid IN OUT NOCOPY VARCHAR2,
75 x_EMPLOYMENT_HISTORY_ID IN OUT NOCOPY NUMBER,
76 x_BEGIN_DATE IN DATE,
77 x_PARTY_ID IN NUMBER,
78 x_EMPLOYED_AS_TITLE IN VARCHAR2,
79 x_EMPLOYED_BY_DIVISION_NAME IN VARCHAR2,
80 x_EMPLOYED_BY_NAME_COMPANY IN VARCHAR2,
81 x_END_DATE IN DATE,
82 x_SUPERVISOR_NAME IN VARCHAR2,
83 x_BRANCH IN VARCHAR2,
84 x_MILITARY_RANK IN VARCHAR2,
85 x_SERVED IN VARCHAR2,
86 x_STATION IN VARCHAR2,
87 x_RESPONSIBILITY IN VARCHAR2,
88 x_STATUS IN VARCHAR2,
89 x_OBJECT_VERSION_NUMBER IN NUMBER,
90 x_CREATED_BY_MODULE IN VARCHAR2,
91 x_APPLICATION_ID IN NUMBER,
92 x_EMPLOYED_BY_PARTY_ID IN NUMBER,
93 x_REASON_FOR_LEAVING IN VARCHAR2,
94 x_FACULTY_POSITION_FLAG IN VARCHAR2,
95 x_TENURE_CODE IN VARCHAR2,
96 x_FRACTION_OF_TENURE IN NUMBER,
97 x_EMPLOYMENT_TYPE_CODE IN VARCHAR2,
98 x_EMPLOYED_AS_TITLE_CODE IN VARCHAR2,
99 x_WEEKLY_WORK_HOURS IN NUMBER,
100 x_COMMENTS IN VARCHAR2
101
102 );
103
104 PROCEDURE Select_Row (
105 x_employment_history_id IN OUT NOCOPY NUMBER,
106 x_begin_date OUT NOCOPY DATE,
107 x_party_id OUT NOCOPY NUMBER,
108 x_employed_as_title OUT NOCOPY VARCHAR2,
109 x_employed_by_division_name OUT NOCOPY VARCHAR2,
110 x_employed_by_name_company OUT NOCOPY VARCHAR2,
111 x_end_date OUT NOCOPY DATE,
112 x_supervisor_name OUT NOCOPY VARCHAR2,
113 x_branch OUT NOCOPY VARCHAR2,
114 x_military_rank OUT NOCOPY VARCHAR2,
115 x_served OUT NOCOPY VARCHAR2,
116 x_station OUT NOCOPY VARCHAR2,
117 x_responsibility OUT NOCOPY VARCHAR2,
118 x_status OUT NOCOPY VARCHAR2,
119 x_application_id OUT NOCOPY NUMBER,
120 x_created_by_module OUT NOCOPY VARCHAR2,
121 x_reason_for_leaving OUT NOCOPY VARCHAR2,
122 x_faculty_position_flag OUT NOCOPY VARCHAR2,
123 x_tenure_code OUT NOCOPY VARCHAR2,
124 x_fraction_of_tenure OUT NOCOPY NUMBER,
125 x_employment_type_code OUT NOCOPY VARCHAR2,
126 x_employed_as_title_code OUT NOCOPY VARCHAR2,
127 x_weekly_work_hours OUT NOCOPY NUMBER,
128 x_comments OUT NOCOPY VARCHAR2
129 );
130
131
132 PROCEDURE Delete_Row( x_EMPLOYMENT_HISTORY_ID NUMBER);
133
134 END HZ_EMPLOYMENT_HISTORY_PKG;