DBA Data[Home] [Help]

APPS.IGS_PS_VAL_GD dependencies on IGS_PS_DSCP

Line 4: -- Validate update of government IGS_PS_DSCP record

1: PACKAGE BODY IGS_PS_VAL_GD AS
2: /* $Header: IGSPS47B.pls 115.3 2002/11/29 03:05:03 nsidana ship $ */
3: --
4: -- Validate update of government IGS_PS_DSCP record
5: FUNCTION crsp_val_gd_upd(
6: p_govt_discipline_group_cd IN VARCHAR2 ,
7: p_closed_ind IN VARCHAR2 DEFAULT 'N',
8: p_message_name OUT NOCOPY VARCHAR2 )

Line 13: FROM IGS_PS_DSCP

9: RETURN boolean AS
10: v_check CHAR;
11: CURSOR c_check_disc_rec IS
12: SELECT 'x'
13: FROM IGS_PS_DSCP
14: WHERE govt_discipline_group_cd = p_govt_discipline_group_cd AND
15: closed_ind = 'N';
16: BEGIN
17: IF p_closed_ind = 'Y' THEN