APPS.IGS_RE_VAL_CAFOS dependencies on IGS_PS_FLD_OF_STUDY

Line 66: -- This module validate IGS_RE_CDT_FLD_OF_SY.IGS_PS_FLD_OF_STUDY. Validations are:

62: p_field_of_study IN VARCHAR2 ,
63: p_message_name OUT NOCOPY VARCHAR2 )
64: RETURN BOOLEAN AS
65: BEGIN -- resp_val_cafos_fos
66: -- This module validate IGS_RE_CDT_FLD_OF_SY.IGS_PS_FLD_OF_STUDY. Validations are:
67: -- . IGS_PS_FLD_OF_STUDY is not closed.
68: -- . IGS_RE_GV_FLD_OF_SDY.res_fcd_class_ind is the same for all
69: -- IGS_RE_CDT_FLD_OF_SY for a research IGS_RE_CANDIDATURE.
70: DECLARE

Line 67: -- . IGS_PS_FLD_OF_STUDY is not closed.

63: p_message_name OUT NOCOPY VARCHAR2 )
64: RETURN BOOLEAN AS
65: BEGIN -- resp_val_cafos_fos
66: -- This module validate IGS_RE_CDT_FLD_OF_SY.IGS_PS_FLD_OF_STUDY. Validations are:
67: -- . IGS_PS_FLD_OF_STUDY is not closed.
68: -- . IGS_RE_GV_FLD_OF_SDY.res_fcd_class_ind is the same for all
69: -- IGS_RE_CDT_FLD_OF_SY for a research IGS_RE_CANDIDATURE.
70: DECLARE
71: v_dummy VARCHAR2(1);

Line 76: FROM IGS_PS_FLD_OF_STUDY fos,

72: v_message_name VARCHAR2(30);
73: v_res_fcd_class_ind IGS_RE_GV_FLD_OF_SDY.res_fcd_class_ind%TYPE;
74: CURSOR c_get_rfci IS
75: SELECT gfos.res_fcd_class_ind
76: FROM IGS_PS_FLD_OF_STUDY fos,
77: IGS_RE_GV_FLD_OF_SDY gfos
78: WHERE fos.field_of_study = p_field_of_study AND
79: Fos.govt_field_of_study = gfos.govt_field_of_study;
80: CURSOR c_not_same(

Line 84: IGS_PS_FLD_OF_STUDY fos,

80: CURSOR c_not_same(
81: cp_res_fcd_class_ind IGS_RE_GV_FLD_OF_SDY.res_fcd_class_ind%TYPE) IS
82: SELECT 'x'
83: FROM IGS_RE_CDT_FLD_OF_SY cafos,
84: IGS_PS_FLD_OF_STUDY fos,
85: IGS_RE_GV_FLD_OF_SDY gfos
86: WHERE cafos.person_id = p_person_id AND
87: cafos.ca_sequence_number = p_ca_sequence_number AND
88: cafos.field_of_study <> p_field_of_study AND

Line 140: -- Validate if IGS_PS_FLD_OF_STUDY.field_of_study is closed.

136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END; -- resp_val_cafos_fos
139: --
140: -- Validate if IGS_PS_FLD_OF_STUDY.field_of_study is closed.
141: FUNCTION crsp_val_fos_closed(
142: p_field_of_study IN VARCHAR2 ,
143: p_message_name OUT NOCOPY VARCHAR2 )
144: RETURN BOOLEAN AS

Line 146: --validate if IGS_PS_FLD_OF_STUDY.field_of_study is closed

142: p_field_of_study IN VARCHAR2 ,
143: p_message_name OUT NOCOPY VARCHAR2 )
144: RETURN BOOLEAN AS
145: BEGIN --crsp_val_fos_closed
146: --validate if IGS_PS_FLD_OF_STUDY.field_of_study is closed
147: DECLARE
148: v_fos_exists VARCHAR2(1);
149: CURSOR c_fos IS
150: SELECT 'X'

Line 151: FROM IGS_PS_FLD_OF_STUDY fos

147: DECLARE
148: v_fos_exists VARCHAR2(1);
149: CURSOR c_fos IS
150: SELECT 'X'
151: FROM IGS_PS_FLD_OF_STUDY fos
152: WHERE fos.field_of_study = p_field_of_study AND
153: fos.closed_ind = 'Y';
154: BEGIN
155: --Set the default message number