1 package IGS_ST_GOVT_SEMESTER_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSVI06S.pls 115.4 2002/11/29 04:32:08 nsidana ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_SUBMISSION_YR in NUMBER,
6 X_SUBMISSION_NUMBER in NUMBER,
7 X_GOVT_SEMESTER in NUMBER,
8 X_MODE in VARCHAR2 default 'R'
9 );
10 procedure LOCK_ROW (
11 X_ROWID in VARCHAR2,
12 X_SUBMISSION_YR in NUMBER,
13 X_SUBMISSION_NUMBER in NUMBER,
14 X_GOVT_SEMESTER in NUMBER
15 );
16 procedure DELETE_ROW (
17 X_ROWID in VARCHAR2
18 );
19
20 FUNCTION Get_PK_For_Validation (
21 x_submission_yr IN NUMBER,
22 x_submission_number IN NUMBER,
23 x_govt_semester IN NUMBER
24 )
25 RETURN BOOLEAN;
26
27 PROCEDURE Check_constraints(
28 Column_Name IN VARCHAR2 DEFAULT NULL,
29 Column_Value IN VARCHAR2 DEFAULT NULL
30 );
31
32 PROCEDURE Before_DML (
33 p_action IN VARCHAR2,
34 x_rowid IN VARCHAR2 DEFAULT NULL,
35 x_submission_yr IN NUMBER DEFAULT NULL,
36 x_submission_number IN NUMBER DEFAULT NULL,
37 x_govt_semester IN NUMBER DEFAULT NULL,
38 x_creation_date IN DATE DEFAULT NULL,
39 x_created_by IN NUMBER DEFAULT NULL,
40 x_last_update_date IN DATE DEFAULT NULL,
41 x_last_updated_by IN NUMBER DEFAULT NULL,
42 x_last_update_login IN NUMBER DEFAULT NULL
43 );
44
45 PROCEDURE GET_FK_IGS_ST_GVT_SPSHT_CTL (
46 x_submission_yr IN NUMBER,
47 x_submission_number IN NUMBER
48 );
49 end IGS_ST_GOVT_SEMESTER_PKG;