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