APPS.IGS_RE_VAL_CSC dependencies on IGS_RE_CAND_SEO_CLS

Line 20: -- This module validates IGS_RE_CAND_SEO_CLS.percentage. Validations are:

16: p_ca_sequence_number IN NUMBER ,
17: p_message_name OUT NOCOPY VARCHAR2 )
18: RETURN BOOLEAN AS
19: BEGIN -- resp_val_csc_perc
20: -- This module validates IGS_RE_CAND_SEO_CLS.percentage. Validations are:
21: -- Total percentage for research IGS_RE_CANDIDATURE must be 100.
22: DECLARE
23: v_total_percentage IGS_RE_CAND_SEO_CLS.percentage%TYPE;
24: CURSOR c_csc IS

Line 23: v_total_percentage IGS_RE_CAND_SEO_CLS.percentage%TYPE;

19: BEGIN -- resp_val_csc_perc
20: -- This module validates IGS_RE_CAND_SEO_CLS.percentage. Validations are:
21: -- Total percentage for research IGS_RE_CANDIDATURE must be 100.
22: DECLARE
23: v_total_percentage IGS_RE_CAND_SEO_CLS.percentage%TYPE;
24: CURSOR c_csc IS
25: SELECT NVL(sum(csc.percentage),0)
26: FROM IGS_RE_CAND_SEO_CLS csc
27: WHERE csc.person_id = p_person_id AND

Line 26: FROM IGS_RE_CAND_SEO_CLS csc

22: DECLARE
23: v_total_percentage IGS_RE_CAND_SEO_CLS.percentage%TYPE;
24: CURSOR c_csc IS
25: SELECT NVL(sum(csc.percentage),0)
26: FROM IGS_RE_CAND_SEO_CLS csc
27: WHERE csc.person_id = p_person_id AND
28: csc.ca_sequence_number = p_ca_sequence_number;
29: BEGIN
30: p_message_name := null;

Line 68: -- IGS_RE_CAND_SEO_CLS for a research IGS_RE_CANDIDATURE.

64: -- Description: This module validate cand_seo_class.seo_class_cd.
65: -- Validations are:
66: -- *IGS_RE_SEO_CLASS_CD is not closed.
67: -- *IGS_RE_GV_SEO_CLS_CD.res_fcd_class_ind is the same for all
68: -- IGS_RE_CAND_SEO_CLS for a research IGS_RE_CANDIDATURE.
69: DECLARE
70: CURSOR c_seocc_gscc IS
71: SELECT gscc.res_fcd_class_ind
72: FROM IGS_RE_SEO_CLASS_CD seocc,

Line 80: FROM IGS_RE_CAND_SEO_CLS csc,

76: v_res_fcd_class_ind IGS_RE_GV_SEO_CLS_CD.res_fcd_class_ind%TYPE;
77: CURSOR c_csc_seocc_gscc(
78: cp_res_fcd_class_ind IGS_RE_GV_SEO_CLS_CD.res_fcd_class_ind%TYPE)IS
79: SELECT 'X'
80: FROM IGS_RE_CAND_SEO_CLS csc,
81: IGS_RE_SEO_CLASS_CD seocc,
82: IGS_RE_GV_SEO_CLS_CD gscc
83: WHERE csc.person_id = p_person_id AND
84: csc.ca_sequence_number = p_ca_sequence_number AND