DBA Data[Home] [Help]

APPS.IGS_RE_GEN_002 dependencies on IGS_RE_DFLT_MS_SET

Line 1403: v_milestone_type IGS_RE_DFLT_MS_SET.milestone_type%TYPE;

1399: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1400: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1401: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
1402: v_milestone_status IGS_PR_MS_STAT.milestone_status%TYPE;
1403: v_milestone_type IGS_RE_DFLT_MS_SET.milestone_type%TYPE;
1404: v_offset_days IGS_RE_DFLT_MS_SET.offset_days%TYPE;
1405: v_mil_sequence_number IGS_PR_MILESTONE.sequence_number%TYPE;
1406: v_commencement_dt DATE;
1407: v_records_inserted NUMBER;

Line 1404: v_offset_days IGS_RE_DFLT_MS_SET.offset_days%TYPE;

1400: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1401: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
1402: v_milestone_status IGS_PR_MS_STAT.milestone_status%TYPE;
1403: v_milestone_type IGS_RE_DFLT_MS_SET.milestone_type%TYPE;
1404: v_offset_days IGS_RE_DFLT_MS_SET.offset_days%TYPE;
1405: v_mil_sequence_number IGS_PR_MILESTONE.sequence_number%TYPE;
1406: v_commencement_dt DATE;
1407: v_records_inserted NUMBER;
1408:

Line 1452: cp_course_cd IGS_RE_DFLT_MS_SET.course_cd%TYPE,

1448: WHERE mst.s_milestone_status = cst_planned
1449: AND mst.closed_ind = 'N'
1450: ORDER BY mst.milestone_status;
1451: CURSOR c_dms (
1452: cp_course_cd IGS_RE_DFLT_MS_SET.course_cd%TYPE,
1453: cp_crv_version_number IGS_RE_DFLT_MS_SET.version_number%TYPE,
1454: cp_attendance_type IGS_RE_DFLT_MS_SET.attendance_type%TYPE) IS
1455: SELECT dms.milestone_type,
1456: dms.offset_days

Line 1453: cp_crv_version_number IGS_RE_DFLT_MS_SET.version_number%TYPE,

1449: AND mst.closed_ind = 'N'
1450: ORDER BY mst.milestone_status;
1451: CURSOR c_dms (
1452: cp_course_cd IGS_RE_DFLT_MS_SET.course_cd%TYPE,
1453: cp_crv_version_number IGS_RE_DFLT_MS_SET.version_number%TYPE,
1454: cp_attendance_type IGS_RE_DFLT_MS_SET.attendance_type%TYPE) IS
1455: SELECT dms.milestone_type,
1456: dms.offset_days
1457: FROM IGS_RE_DFLT_MS_SET dms,

Line 1454: cp_attendance_type IGS_RE_DFLT_MS_SET.attendance_type%TYPE) IS

1450: ORDER BY mst.milestone_status;
1451: CURSOR c_dms (
1452: cp_course_cd IGS_RE_DFLT_MS_SET.course_cd%TYPE,
1453: cp_crv_version_number IGS_RE_DFLT_MS_SET.version_number%TYPE,
1454: cp_attendance_type IGS_RE_DFLT_MS_SET.attendance_type%TYPE) IS
1455: SELECT dms.milestone_type,
1456: dms.offset_days
1457: FROM IGS_RE_DFLT_MS_SET dms,
1458: IGS_PR_MILESTONE_TYP mst

Line 1457: FROM IGS_RE_DFLT_MS_SET dms,

1453: cp_crv_version_number IGS_RE_DFLT_MS_SET.version_number%TYPE,
1454: cp_attendance_type IGS_RE_DFLT_MS_SET.attendance_type%TYPE) IS
1455: SELECT dms.milestone_type,
1456: dms.offset_days
1457: FROM IGS_RE_DFLT_MS_SET dms,
1458: IGS_PR_MILESTONE_TYP mst
1459: WHERE dms.course_cd = cp_course_cd AND
1460: dms.version_number = cp_crv_version_number AND
1461: dms.attendance_type = cp_attendance_type AND