PACKAGE: APPS.IGS_PS_UNT_PRV_GRADE_PKG

Source

1 PACKAGE igs_ps_unt_prv_grade_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI0BS.pls 115.6 2002/11/29 01:55:19 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_UNIT_PREV_GRADE_ID IN OUT NOCOPY NUMBER,
6        x_UNIT_CODE IN VARCHAR2,
7        x_UNIT_VERSION_NUMBER IN NUMBER,
8        x_GRADING_SCHEMA_CODE IN VARCHAR2,
9        x_GRADING_SCHEMA_VER_NUM IN NUMBER,
10        x_GRADING_SCHEMA_VALUE IN VARCHAR2,
11       X_MODE in VARCHAR2 default 'R'
12   );
13 
14  procedure LOCK_ROW (
15       X_ROWID in  VARCHAR2,
16        x_UNIT_PREV_GRADE_ID IN NUMBER,
17        x_UNIT_CODE IN VARCHAR2,
18        x_UNIT_VERSION_NUMBER IN NUMBER,
19        x_GRADING_SCHEMA_CODE IN VARCHAR2,
20        x_GRADING_SCHEMA_VER_NUM IN NUMBER,
21        x_GRADING_SCHEMA_VALUE IN VARCHAR2  );
22  procedure UPDATE_ROW (
23       X_ROWID in  VARCHAR2,
24        x_UNIT_PREV_GRADE_ID IN NUMBER,
25        x_UNIT_CODE IN VARCHAR2,
26        x_UNIT_VERSION_NUMBER IN NUMBER,
27        x_GRADING_SCHEMA_CODE IN VARCHAR2,
28        x_GRADING_SCHEMA_VER_NUM IN NUMBER,
29        x_GRADING_SCHEMA_VALUE IN VARCHAR2,
30       X_MODE in VARCHAR2 default 'R'
31   );
32 
33  procedure ADD_ROW (
34       X_ROWID in out NOCOPY VARCHAR2,
35        x_UNIT_PREV_GRADE_ID IN OUT NOCOPY NUMBER,
36        x_UNIT_CODE IN VARCHAR2,
37        x_UNIT_VERSION_NUMBER IN NUMBER,
38        x_GRADING_SCHEMA_CODE IN VARCHAR2,
39        x_GRADING_SCHEMA_VER_NUM IN NUMBER,
40        x_GRADING_SCHEMA_VALUE IN VARCHAR2,
41       X_MODE in VARCHAR2 default 'R'
42   ) ;
43 
44 procedure DELETE_ROW (
45   X_ROWID in VARCHAR2
46 ) ;
47   FUNCTION Get_PK_For_Validation (
48     x_unit_prev_grade_id IN NUMBER
49     ) RETURN BOOLEAN ;
50 
51   FUNCTION Get_UK_For_Validation (
52     x_unit_code IN VARCHAR2,
53     x_unit_version_number IN NUMBER,
54     x_grading_schema_code IN VARCHAR2,
55     x_grading_schema_value IN VARCHAR2,
56     x_grading_schema_ver_num IN NUMBER
57     ) RETURN BOOLEAN;
58 
59   PROCEDURE Get_FK_Igs_As_Grd_Sch_Grade (
60     x_grading_schema_cd IN VARCHAR2,
61     x_version_number IN NUMBER,
62     x_grade IN VARCHAR2
63     );
64 
65   PROCEDURE Get_FK_Igs_Ps_Unit_Ver (
66     x_unit_cd IN VARCHAR2,
67     x_version_number IN NUMBER
68     );
69 
70   PROCEDURE Check_Constraints (
71 		 Column_Name IN VARCHAR2  DEFAULT NULL,
72 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
73   PROCEDURE Before_DML (
74     p_action IN VARCHAR2,
75     x_rowid IN VARCHAR2 DEFAULT NULL,
76     x_unit_prev_grade_id IN NUMBER DEFAULT NULL,
77     x_unit_code IN VARCHAR2 DEFAULT NULL,
78     x_unit_version_number IN NUMBER DEFAULT NULL,
79     x_grading_schema_code IN VARCHAR2 DEFAULT NULL,
80     x_grading_schema_ver_num IN NUMBER DEFAULT NULL,
81     x_grading_schema_value IN VARCHAR2 DEFAULT NULL,
82     x_creation_date IN DATE DEFAULT NULL,
83     x_created_by IN NUMBER DEFAULT NULL,
84     x_last_update_date IN DATE DEFAULT NULL,
85     x_last_updated_by IN NUMBER DEFAULT NULL,
86     x_last_update_login IN NUMBER DEFAULT NULL
87  );
88 END igs_ps_unt_prv_grade_pkg;