APPS.IGS_PS_VAL_AW dependencies on IGS_PS_AWD

Line 4: -- Validate update to IGS_PS_AWD type.

1: PACKAGE BODY IGS_PS_VAL_AW AS
2: /* $Header: IGSPS12B.pls 115.5 2003/06/09 04:41:10 smvk ship $ */
3:
4: -- Validate update to IGS_PS_AWD type.
5: FUNCTION crsp_val_aw_upd(
6: p_award_cd IGS_PS_AWD.award_cd%TYPE ,
7: p_new_award_type IGS_PS_AWD.s_award_type%TYPE ,
8: p_old_award_type IGS_PS_AWD.s_award_type%TYPE ,

Line 6: p_award_cd IGS_PS_AWD.award_cd%TYPE ,

2: /* $Header: IGSPS12B.pls 115.5 2003/06/09 04:41:10 smvk ship $ */
3:
4: -- Validate update to IGS_PS_AWD type.
5: FUNCTION crsp_val_aw_upd(
6: p_award_cd IGS_PS_AWD.award_cd%TYPE ,
7: p_new_award_type IGS_PS_AWD.s_award_type%TYPE ,
8: p_old_award_type IGS_PS_AWD.s_award_type%TYPE ,
9: p_message_name OUT NOCOPY VARCHAR2)
10: RETURN BOOLEAN AS

Line 7: p_new_award_type IGS_PS_AWD.s_award_type%TYPE ,

3:
4: -- Validate update to IGS_PS_AWD type.
5: FUNCTION crsp_val_aw_upd(
6: p_award_cd IGS_PS_AWD.award_cd%TYPE ,
7: p_new_award_type IGS_PS_AWD.s_award_type%TYPE ,
8: p_old_award_type IGS_PS_AWD.s_award_type%TYPE ,
9: p_message_name OUT NOCOPY VARCHAR2)
10: RETURN BOOLEAN AS
11: BEGIN -- crsp_val_aw_upd

Line 8: p_old_award_type IGS_PS_AWD.s_award_type%TYPE ,

4: -- Validate update to IGS_PS_AWD type.
5: FUNCTION crsp_val_aw_upd(
6: p_award_cd IGS_PS_AWD.award_cd%TYPE ,
7: p_new_award_type IGS_PS_AWD.s_award_type%TYPE ,
8: p_old_award_type IGS_PS_AWD.s_award_type%TYPE ,
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;

Line 12: -- This routine validates changes to IGS_PS_AWD records. It checks;

8: p_old_award_type IGS_PS_AWD.s_award_type%TYPE ,
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 :

Line 13: -- change of system IGS_PS_AWD type does not invalidate IGS_GR_GRADUAND,

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 :

Line 14: -- IGS_PS_COURSE IGS_PS_AWD or special IGS_PS_AWD details

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 :
18: Purpose :

Line 72: ELSE --special IGS_PS_AWDs

68: p_message_name := 'IGS_GR_GRAD_REC_IN_USE_UPD_NA';
69: RETURN FALSE;
70: END IF;
71: CLOSE c_gr;
72: ELSE --special IGS_PS_AWDs
73: OPEN c_spa;
74: FETCH c_spa INTO v_c_exists;
75: IF c_spa%FOUND THEN
76: CLOSE c_spa;