1 package IGS_PS_AWD_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSPI01S.pls 115.6 2003/02/25 08:10:05 sarakshi ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_AWARD_CD in VARCHAR2,
7 X_AWARD_TITLE in VARCHAR2,
8 X_S_AWARD_TYPE in VARCHAR2,
9 X_TESTAMUR_TYPE in VARCHAR2,
10 X_CLOSED_IND in VARCHAR2,
11 X_NOTES in VARCHAR2,
12 X_MODE in VARCHAR2 default 'R' ,
13 X_GRADING_SCHEMA_CD in VARCHAR2,
14 X_GS_VERSION_NUMBER in NUMBER
15 );
16 procedure LOCK_ROW (
17 X_ROWID in VARCHAR2,
18 X_AWARD_CD in VARCHAR2,
19 X_AWARD_TITLE in VARCHAR2,
20 X_S_AWARD_TYPE in VARCHAR2,
21 X_TESTAMUR_TYPE in VARCHAR2,
22 X_CLOSED_IND in VARCHAR2,
23 X_NOTES in VARCHAR2 ,
24 X_GRADING_SCHEMA_CD in VARCHAR2,
25 X_GS_VERSION_NUMBER in NUMBER
26 );
27 procedure UPDATE_ROW (
28 X_ROWID in VARCHAR2,
29 X_AWARD_CD in VARCHAR2,
30 X_AWARD_TITLE in VARCHAR2,
31 X_S_AWARD_TYPE in VARCHAR2,
32 X_TESTAMUR_TYPE in VARCHAR2,
33 X_CLOSED_IND in VARCHAR2,
34 X_NOTES in VARCHAR2,
35 X_MODE in VARCHAR2 default 'R' ,
36 X_GRADING_SCHEMA_CD in VARCHAR2,
37 X_GS_VERSION_NUMBER in NUMBER
38 );
39 procedure ADD_ROW (
40 X_ROWID in out NOCOPY VARCHAR2,
41 X_AWARD_CD in VARCHAR2,
42 X_AWARD_TITLE in VARCHAR2,
43 X_S_AWARD_TYPE in VARCHAR2,
44 X_TESTAMUR_TYPE in VARCHAR2,
45 X_CLOSED_IND in VARCHAR2,
46 X_NOTES in VARCHAR2,
47 X_MODE in VARCHAR2 default 'R' ,
48 X_GRADING_SCHEMA_CD in VARCHAR2,
49 X_GS_VERSION_NUMBER in NUMBER
50 );
51
52 FUNCTION Get_PK_For_Validation (
53 x_award_cd IN VARCHAR2 )
54 RETURN BOOLEAN ;
55
56 PROCEDURE GET_FK_IGS_GR_TESTAMUR_TYPE (
57 x_testamur_type IN VARCHAR2
58 );
59
60 -- Added by aiyer for the build of PSCR015 Tertiary And Secondary Bug No #2216952
61 PROCEDURE GET_FK_IGS_AS_GRD_SCHEMA (
62 x_grading_schema_cd IN VARCHAR2 ,
63 x_gs_version_number IN NUMBER
64 );
65
66 PROCEDURE Check_Constraints (
67 Column_Name IN VARCHAR2 DEFAULT NULL,
68 Column_Value IN VARCHAR2 DEFAULT NULL
69 );
70
71 PROCEDURE Before_DML (
72 p_action IN VARCHAR2,
73 x_rowid IN VARCHAR2 DEFAULT NULL,
74 x_award_cd IN VARCHAR2 DEFAULT NULL,
75 x_award_title IN VARCHAR2 DEFAULT NULL,
76 x_s_award_type IN VARCHAR2 DEFAULT NULL,
77 x_testamur_type IN VARCHAR2 DEFAULT NULL,
78 x_closed_ind IN VARCHAR2 DEFAULT NULL,
79 x_notes IN VARCHAR2 DEFAULT NULL,
80 x_creation_date IN DATE DEFAULT NULL,
81 x_created_by IN NUMBER DEFAULT NULL,
82 x_last_update_date IN DATE DEFAULT NULL,
83 x_last_updated_by IN NUMBER DEFAULT NULL,
84 x_last_update_login IN NUMBER DEFAULT NULL ,
85 x_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
86 x_gs_version_number IN NUMBER DEFAULT NULL
87 ) ;
88
89 end IGS_PS_AWD_PKG;