1 PACKAGE igs_ad_emp_dtl_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAI33S.pls 115.14 2003/11/11 07:17:35 gmaheswa ship $ */
3 /* Changed History
4 Who When What
5 Bug : 2037512
6 avenkatr 08-OCT-2001 1. Added the column 'Contact' to Insert_row
7 and update_row procedures
8 gmaheswa 05-Nov-2003 Added three new columns object_version_number,employed_by_party_id,reason_for_leaving for
9 HZ.K Impact Changes.
10 */
11 procedure INSERT_ROW (
12 X_ROWID in out NOCOPY VARCHAR2,
13 x_employment_history_id OUT NOCOPY NUMBER,
14 x_PERSON_ID IN NUMBER,
15 x_START_DT IN DATE,
16 x_END_DT IN DATE,
17 x_TYPE_OF_EMPLOYMENT IN VARCHAR2,
18 x_FRACTION_OF_EMPLOYMENT IN NUMBER,
19 x_TENURE_OF_EMPLOYMENT IN VARCHAR2,
20 x_POSITION IN VARCHAR2,
21 x_OCCUPATIONAL_TITLE_CODE IN VARCHAR2,
22 x_OCCUPATIONAL_TITLE IN VARCHAR2,
23 x_WEEKLY_WORK_HOURS IN NUMBER,
24 x_COMMENTS IN VARCHAR2,
25 x_EMPLOYER IN VARCHAR2,
26 x_EMPLOYED_BY_DIVISION_NAME IN VARCHAR2,
27 x_BRANCH IN VARCHAR2,
28 x_MILITARY_RANK IN VARCHAR2,
29 x_SERVED IN VARCHAR2,
30 x_STATION IN VARCHAR2,
31 x_CONTACT IN VARCHAR2, -- Bug : 2037512
32 x_msg_data OUT NOCOPY VARCHAR2,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_object_version_number IN OUT NOCOPY NUMBER,
35 x_employed_by_party_id IN NUMBER,
36 x_reason_for_leaving IN VARCHAR2,
37 X_MODE in VARCHAR2 default 'R'
38 );
39
40 procedure UPDATE_ROW (
41 X_ROWID in VARCHAR2,
42 x_employment_history_id IN NUMBER,
43 x_PERSON_ID IN NUMBER,
44 x_START_DT IN DATE,
45 x_END_DT IN DATE,
46 x_TYPE_OF_EMPLOYMENT IN VARCHAR2,
47 x_FRACTION_OF_EMPLOYMENT IN NUMBER,
48 x_TENURE_OF_EMPLOYMENT IN VARCHAR2,
49 x_POSITION IN VARCHAR2,
50 x_OCCUPATIONAL_TITLE_CODE IN VARCHAR2,
51 x_OCCUPATIONAL_TITLE IN VARCHAR2,
52 x_WEEKLY_WORK_HOURS IN NUMBER,
53 x_COMMENTS IN VARCHAR2,
54 x_EMPLOYER IN VARCHAR2,
55 x_EMPLOYED_BY_DIVISION_NAME IN VARCHAR2,
56 x_BRANCH IN VARCHAR2,
57 x_MILITARY_RANK IN VARCHAR2,
58 x_SERVED IN VARCHAR2,
59 x_STATION IN VARCHAR2,
60 x_CONTACT IN VARCHAR2, -- Bug : 2037512
61 x_msg_data OUT NOCOPY VARCHAR2,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_object_version_number IN OUT NOCOPY NUMBER,
64 x_employed_by_party_id IN NUMBER,
65 x_reason_for_leaving IN VARCHAR2,
66 X_MODE in VARCHAR2 default 'R'
67 );
68
69 procedure DELETE_ROW (
70 X_ROWID in VARCHAR2
71 ) ;
72
73 END igs_ad_emp_dtl_pkg;