DBA Data[Home] [Help]

APPS.IGS_RE_GEN_002 dependencies on IGS_RE_GEN_001

Line 704: v_commencement_dt := IGS_RE_GEN_001.resp_get_ca_comm(

700: END IF;
701: CLOSE c_ca;
702: --3. Get the commencement date - this routine handles both enrolled students
703: -- and students still in the admission stage.
704: v_commencement_dt := IGS_RE_GEN_001.resp_get_ca_comm(
705: p_person_id,
706: v_sca_course_cd,
707: v_acai_admission_appl_number,
708: v_acai_nominated_course_cd,

Line 729: v_attendance_percentage := IGS_RE_GEN_001.resp_get_ca_att(

725: RETURN 0;
726: END IF;
727: p_cal_type_eftd := v_tp_days;
728: -- 6. Calculate the students attendance percentage as at the effective date
729: v_attendance_percentage := IGS_RE_GEN_001.resp_get_ca_att(
730: p_person_id,
731: p_course_cd,
732: p_effective_dt,
733: v_ca_sequence_number,

Line 828: v_diff_percentage := IGS_RE_GEN_001.resp_get_ca_att(

824: ELSE
825: v_last_hist_end_dt := v_cah2_hist_end_dt; -- (if last record processed)
826: END IF;
827: IF v_last_hist_end_dt < v_intermit_end_dt THEN
828: v_diff_percentage := IGS_RE_GEN_001.resp_get_ca_att(
829: p_person_id,
830: p_course_cd,
831: v_last_hist_end_dt,
832: v_ca_sequence_number,

Line 1172: v_attendance_percentage := IGS_RE_GEN_001.resp_get_ca_att(

1168: --IGS_RE_CANDIDATURE attendance history is not retained yet
1169: RETURN TRUE;
1170: END IF;
1171: -- Determine attendance percentage
1172: v_attendance_percentage := IGS_RE_GEN_001.resp_get_ca_att(
1173: p_person_id,
1174: p_sca_course_cd,
1175: TRUNC(SYSDATE),
1176: p_ca_sequence_number,

Line 1485: v_commencement_dt := IGS_RE_GEN_001.resp_get_ca_comm(

1481: RETURN FALSE;
1482: END IF;
1483: CLOSE c_ca_detail;
1484: -- 3. Get the commencement date of the research student.
1485: v_commencement_dt := IGS_RE_GEN_001.resp_get_ca_comm(
1486: p_person_id,
1487: v_sca_course_cd,
1488: v_acai_admission_appl_number,
1489: v_acai_nominated_course_cd,