1 package IGS_PS_FLD_STDY_HIST_PKG as
2 /* $Header: IGSPI55S.pls 120.1 2006/07/25 15:06:19 sommukhe noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_FIELD_OF_STUDY in VARCHAR2,
7 X_HIST_START_DT in DATE,
8 X_HIST_END_DT in DATE,
9 X_HIST_WHO in NUMBER,
10 X_DESCRIPTION in VARCHAR2,
11 X_GOVT_FIELD_OF_STUDY in VARCHAR2,
12 X_CLOSED_IND in VARCHAR2,
13 X_MODE in VARCHAR2 default 'R',
14 X_ORG_ID in NUMBER,
15 X_FOS_TYPE_CODE VARCHAR2
16 );
17 procedure LOCK_ROW (
18 X_ROWID in VARCHAR2,
19 X_FIELD_OF_STUDY in VARCHAR2,
20 X_HIST_START_DT in DATE,
21 X_HIST_END_DT in DATE,
22 X_HIST_WHO in NUMBER,
23 X_DESCRIPTION in VARCHAR2,
24 X_GOVT_FIELD_OF_STUDY in VARCHAR2,
25 X_CLOSED_IND in VARCHAR2,
26 X_FOS_TYPE_CODE VARCHAR2
27 );
28 procedure UPDATE_ROW (
29 X_ROWID in VARCHAR2,
30 X_FIELD_OF_STUDY in VARCHAR2,
31 X_HIST_START_DT in DATE,
32 X_HIST_END_DT in DATE,
33 X_HIST_WHO in NUMBER,
34 X_DESCRIPTION in VARCHAR2,
35 X_GOVT_FIELD_OF_STUDY in VARCHAR2,
36 X_CLOSED_IND in VARCHAR2,
37 X_FOS_TYPE_CODE VARCHAR2,
38 X_MODE in VARCHAR2 default 'R'
39 );
40 procedure ADD_ROW (
41 X_ROWID in out NOCOPY VARCHAR2,
42 X_FIELD_OF_STUDY in VARCHAR2,
43 X_HIST_START_DT in DATE,
44 X_HIST_END_DT in DATE,
45 X_HIST_WHO in NUMBER,
46 X_DESCRIPTION in VARCHAR2,
47 X_GOVT_FIELD_OF_STUDY in VARCHAR2,
48 X_CLOSED_IND in VARCHAR2,
49 X_MODE in VARCHAR2 default 'R',
50 X_ORG_ID in NUMBER,
51 X_FOS_TYPE_CODE VARCHAR2
52 );
53 procedure DELETE_ROW (
54 X_ROWID in VARCHAR2
55 );
56 FUNCTION Get_PK_For_Validation (
57 x_field_of_study IN VARCHAR2,
58 x_hist_start_dt IN DATE
59 ) RETURN BOOLEAN;
60 PROCEDURE Check_Constraints (
61 Column_Name IN VARCHAR2 DEFAULT NULL,
62 Column_Value IN VARCHAR2 DEFAULT NULL
63 );
64 PROCEDURE Before_DML (
65 p_action IN VARCHAR2,
66 x_rowid IN VARCHAR2 DEFAULT NULL,
67 x_hist_who IN NUMBER DEFAULT NULL,
68 x_description IN VARCHAR2 DEFAULT NULL,
69 x_govt_field_of_study IN VARCHAR2 DEFAULT NULL,
70 x_closed_ind IN VARCHAR2 DEFAULT NULL,
71 x_field_of_study IN VARCHAR2 DEFAULT NULL,
72 x_hist_start_dt IN DATE DEFAULT NULL,
73 x_hist_end_dt IN DATE DEFAULT NULL,
74 x_creation_date IN DATE DEFAULT NULL,
75 x_created_by IN NUMBER DEFAULT NULL,
76 x_last_update_date IN DATE DEFAULT NULL,
77 x_last_updated_by IN NUMBER DEFAULT NULL,
78 x_last_update_login IN NUMBER DEFAULT NULL,
79 x_org_id IN NUMBER DEFAULT NULL,
80 x_fos_type_code IN VARCHAR2 DEFAULT NULL
81 );
82 end IGS_PS_FLD_STDY_HIST_PKG;