[Home] [Help]
9: p_message_name OUT NOCOPY VARCHAR2)
10: RETURN BOOLEAN AS
11: BEGIN -- crsp_val_aw_upd
12: -- This routine validates changes to IGS_PS_AWD records. It checks;
13: -- change of system IGS_PS_AWD type does not invalidate IGS_GR_GRADUAND,
14: -- IGS_PS_COURSE IGS_PS_AWD or special IGS_PS_AWD details
15: /***************************************************************
16: Created By :
17: Date Created By :
29: WHERE caw.award_cd = p_award_cd
30: AND caw.closed_ind = 'N';
31: CURSOR c_gr IS
32: SELECT 'x'
33: FROM IGS_GR_GRADUAND gr
34: WHERE gr.award_cd = p_award_cd;
35: CURSOR c_spa IS
36: SELECT 'x'
37: FROM IGS_GR_SPECIAL_AWARD spa