1 package IGS_GR_SPECIAL_AWARD_PKG as
2 /* $Header: IGSGI16S.pls 120.1 2005/07/06 23:22:10 appldev ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_PERSON_ID in NUMBER,
6 X_COURSE_CD in VARCHAR2,
7 X_AWARD_CD in VARCHAR2,
8 X_AWARD_DT in DATE,
9 X_CEREMONY_ANNOUNCED_IND in VARCHAR2,
10 X_COMMENTS 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_PERSON_ID in NUMBER,
17 X_COURSE_CD in VARCHAR2,
18 X_AWARD_CD in VARCHAR2,
19 X_AWARD_DT in DATE,
20 X_CEREMONY_ANNOUNCED_IND in VARCHAR2,
21 X_COMMENTS in VARCHAR2
22
23 );
24 procedure UPDATE_ROW (
25 X_ROWID in VARCHAR2,
26 X_PERSON_ID in NUMBER,
27 X_COURSE_CD in VARCHAR2,
28 X_AWARD_CD in VARCHAR2,
29 X_AWARD_DT in DATE,
30 X_CEREMONY_ANNOUNCED_IND in VARCHAR2,
31 X_COMMENTS in VARCHAR2,
32 X_MODE in VARCHAR2 default 'R'
33
34 );
35 procedure ADD_ROW (
36 X_ROWID in out NOCOPY VARCHAR2,
37 X_PERSON_ID in NUMBER,
38 X_COURSE_CD in VARCHAR2,
39 X_AWARD_CD in VARCHAR2,
40 X_AWARD_DT in DATE,
41 X_CEREMONY_ANNOUNCED_IND in VARCHAR2,
42 X_COMMENTS in VARCHAR2,
43 X_MODE in VARCHAR2 default 'R',
44 X_ORG_ID in NUMBER
45 );
46 procedure DELETE_ROW (
47 X_ROWID in VARCHAR2,
48 x_mode IN VARCHAR2 DEFAULT 'R'
49 );
50
51 FUNCTION Get_PK_For_Validation (
52 x_person_id IN NUMBER,
53 x_course_cd IN VARCHAR2,
54 x_award_cd IN VARCHAR2,
55 x_award_dt IN DATE
56 ) RETURN BOOLEAN;
57
58
59 PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
60 x_person_id IN NUMBER,
61 x_course_cd IN VARCHAR2
62 );
63
64 PROCEDURE Check_Constraints(
65 Column_Name IN VARCHAR2 DEFAULT NULL,
66 Column_Value IN VARCHAR2 DEFAULT NULL
67 );
68
69 PROCEDURE Before_DML (
70 p_action IN VARCHAR2,
71 x_rowid IN VARCHAR2 DEFAULT NULL,
72 x_person_id IN NUMBER DEFAULT NULL,
73 x_course_cd IN VARCHAR2 DEFAULT NULL,
74 x_award_cd IN VARCHAR2 DEFAULT NULL,
75 x_award_dt IN DATE DEFAULT NULL,
76 x_ceremony_announced_ind IN VARCHAR2 DEFAULT NULL,
77 x_comments IN VARCHAR2 DEFAULT NULL,
78 x_creation_date IN DATE DEFAULT NULL,
79 x_created_by IN NUMBER DEFAULT NULL,
80 x_last_update_date IN DATE DEFAULT NULL,
81 x_last_updated_by IN NUMBER DEFAULT NULL,
82 x_last_update_login IN NUMBER DEFAULT NULL,
83 X_ORG_ID in NUMBER DEFAULT NULL
84 );
85
86 end IGS_GR_SPECIAL_AWARD_PKG;