PACKAGE: APPS.IGS_AS_TYPGOV_SCORMP_PKG

Source

1 package IGS_AS_TYPGOV_SCORMP_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSDI24S.pls 115.3 2002/11/28 23:17:05 nsidana ship $ */
3 
4 
5  /* $HEADER$ */
6 procedure INSERT_ROW (
7   X_ROWID in out NOCOPY VARCHAR2,
8   X_SCNDRY_EDU_ASS_TYPE in VARCHAR2,
9   X_RESULT_OBTAINED_YR in NUMBER,
10   X_INSTITUTION_SCORE in NUMBER,
11   X_GOVT_SCORE in NUMBER,
12   X_MODE in VARCHAR2 default 'R'
13   );
14 procedure LOCK_ROW (
15   X_ROWID in VARCHAR2,
16   X_SCNDRY_EDU_ASS_TYPE in VARCHAR2,
17   X_RESULT_OBTAINED_YR in NUMBER,
18   X_INSTITUTION_SCORE in NUMBER,
19   X_GOVT_SCORE in NUMBER
20 );
21 procedure UPDATE_ROW (
22   X_ROWID in VARCHAR2,
23   X_SCNDRY_EDU_ASS_TYPE in VARCHAR2,
24   X_RESULT_OBTAINED_YR in NUMBER,
25   X_INSTITUTION_SCORE in NUMBER,
26   X_GOVT_SCORE in NUMBER,
27   X_MODE in VARCHAR2 default 'R'
28   );
29 procedure ADD_ROW (
30   X_ROWID in out NOCOPY VARCHAR2,
31   X_SCNDRY_EDU_ASS_TYPE in VARCHAR2,
32   X_RESULT_OBTAINED_YR in NUMBER,
33   X_INSTITUTION_SCORE in NUMBER,
34   X_GOVT_SCORE in NUMBER,
35   X_MODE in VARCHAR2 default 'R'
36   );
37 procedure DELETE_ROW (
38   X_ROWID in VARCHAR2
39   );
40   FUNCTION Get_PK_For_Validation (
41     x_scndry_edu_ass_type IN VARCHAR2,
42     x_result_obtained_yr IN NUMBER,
43     x_institution_score IN NUMBER
44     )RETURN BOOLEAN;
45 
46   PROCEDURE GET_FK_IGS_AD_AUSE_ED_AS_TY (
47     x_aus_scndry_edu_ass_type IN VARCHAR2    );
48 
49 
50 
51 	PROCEDURE Check_Constraints (
52 	Column_Name	IN	VARCHAR2	DEFAULT NULL,
53 	Column_Value 	IN	VARCHAR2	DEFAULT NULL
54 	);
55 
56 PROCEDURE Before_DML (
57     p_action IN VARCHAR2,
58     x_rowid IN VARCHAR2 DEFAULT NULL,
59     x_scndry_edu_ass_type IN VARCHAR2 DEFAULT NULL,
60     x_result_obtained_yr IN NUMBER DEFAULT NULL,
61     x_institution_score IN NUMBER DEFAULT NULL,
62     x_govt_score IN NUMBER DEFAULT NULL,
63     x_creation_date IN DATE DEFAULT NULL,
64     x_created_by IN NUMBER DEFAULT NULL,
65     x_last_update_date IN DATE DEFAULT NULL,
66     x_last_updated_by IN NUMBER DEFAULT NULL,
67     x_last_update_login IN NUMBER DEFAULT NULL
68   ) ;
69 
70 
71 end IGS_AS_TYPGOV_SCORMP_PKG;