APPS.IGS_RE_VAL_CAFOS dependencies on IGS_RE_CDT_FLD_OF_SY

Line 20: -- Description: This module validates IGS_RE_CDT_FLD_OF_SY.percentage.

16: p_ca_sequence_number IN NUMBER ,
17: p_message_name OUT NOCOPY VARCHAR2 )
18: RETURN BOOLEAN AS
19: BEGIN -- resp_val_cafos_perc
20: -- Description: This module validates IGS_RE_CDT_FLD_OF_SY.percentage.
21: -- Validations are:
22: -- Total percentage for research IGS_RE_CANDIDATURE must be 100.
23: DECLARE
24:

Line 27: FROM igs_re_cdt_fld_of_sy_v cafos

23: DECLARE
24:
25: CURSOR c_cafos IS
26: SELECT NVL(Sum(cafos.percentage), 0) total, cafos.fos_type_code
27: FROM igs_re_cdt_fld_of_sy_v cafos
28: WHERE cafos.fos_type_code <> 'CIP'
29: AND cafos.person_id = p_person_id
30: AND cafos.ca_sequence_number = p_ca_sequence_number
31: GROUP BY cafos.fos_type_code

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 69: -- IGS_RE_CDT_FLD_OF_SY for a research IGS_RE_CANDIDATURE.

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);
72: v_message_name VARCHAR2(30);
73: v_res_fcd_class_ind IGS_RE_GV_FLD_OF_SDY.res_fcd_class_ind%TYPE;

Line 83: FROM IGS_RE_CDT_FLD_OF_SY cafos,

79: Fos.govt_field_of_study = gfos.govt_field_of_study;
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