APPS.IGS_RE_GEN_002 dependencies on IGS_PR_MILESTONE

Line 70: FROM IGS_PR_MILESTONE mil

66: rsup.start_dt <= p_effective_dt AND
67: NVL(rsup.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) >= p_effective_dt;
68: CURSOR c_mil IS
69: SELECT 'X'
70: FROM IGS_PR_MILESTONE mil
71: WHERE mil.person_id = p_person_id AND
72: mil.ca_sequence_number = p_ca_sequence_number;
73: CURSOR c_sch IS
74: SELECT 'X'

Line 1004: FROM IGS_PR_MILESTONE mil

1000: tex.ca_sequence_number = p_ca_sequence_number AND
1001: tex.the_sequence_number = p_the_sequence_number;
1002: CURSOR c_mil IS
1003: SELECT 'x'
1004: FROM IGS_PR_MILESTONE mil
1005: WHERE mil.person_id = p_person_id AND
1006: mil.ca_sequence_number = p_ca_sequence_number;
1007: BEGIN
1008: -- Initialise output parameters.

Line 1022: -- Check IGS_PR_MILESTONE

1018: ELSE
1019: CLOSE c_the;
1020: END IF;
1021: END IF;
1022: -- Check IGS_PR_MILESTONE
1023: IF p_check_milestone THEN
1024: OPEN c_mil;
1025: FETCH c_mil INTO v_mil_found;
1026: IF c_mil%FOUND THEN

Line 1405: v_mil_sequence_number IGS_PR_MILESTONE.sequence_number%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:
1409: CURSOR c_mil_exists (

Line 1410: cp_milestone_type IGS_PR_MILESTONE.milestone_type%TYPE,

1406: v_commencement_dt DATE;
1407: v_records_inserted NUMBER;
1408:
1409: CURSOR c_mil_exists (
1410: cp_milestone_type IGS_PR_MILESTONE.milestone_type%TYPE,
1411: cp_due_dt IGS_PR_MILESTONE.due_dt%TYPE) IS
1412: SELECT 'x'
1413: FROM IGS_PR_MILESTONE mil
1414: WHERE mil.person_id = p_person_id AND

Line 1411: cp_due_dt IGS_PR_MILESTONE.due_dt%TYPE) IS

1407: v_records_inserted NUMBER;
1408:
1409: CURSOR c_mil_exists (
1410: cp_milestone_type IGS_PR_MILESTONE.milestone_type%TYPE,
1411: cp_due_dt IGS_PR_MILESTONE.due_dt%TYPE) IS
1412: SELECT 'x'
1413: FROM IGS_PR_MILESTONE mil
1414: WHERE mil.person_id = p_person_id AND
1415: mil.ca_sequence_number = p_ca_sequence_number AND

Line 1413: FROM IGS_PR_MILESTONE mil

1409: CURSOR c_mil_exists (
1410: cp_milestone_type IGS_PR_MILESTONE.milestone_type%TYPE,
1411: cp_due_dt IGS_PR_MILESTONE.due_dt%TYPE) IS
1412: SELECT 'x'
1413: FROM IGS_PR_MILESTONE mil
1414: WHERE mil.person_id = p_person_id AND
1415: mil.ca_sequence_number = p_ca_sequence_number AND
1416: mil.milestone_type = cp_milestone_type AND
1417: mil.due_dt = cp_due_dt;

Line 1458: IGS_PR_MILESTONE_TYP mst

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
1462: mst.milestone_type = dms.milestone_type AND

Line 1466: SELECT IGS_PR_MILESTONE_SEQ_NUM_S.NEXTVAL

1462: mst.milestone_type = dms.milestone_type AND
1463: mst.closed_ind = 'N'
1464: ORDER BY offset_days;
1465: CURSOR c_mil_seq_num IS
1466: SELECT IGS_PR_MILESTONE_SEQ_NUM_S.NEXTVAL
1467: FROM DUAL;
1468: BEGIN
1469: -- Set default value
1470: p_message_name := null;

Line 1515: -- 5. Select the planned IGS_PR_MILESTONE status (pick the first)

1511: CLOSE c_acai;
1512: ELSE
1513: v_crv_version_number := 0;
1514: END IF;
1515: -- 5. Select the planned IGS_PR_MILESTONE status (pick the first)
1516: OPEN c_mst_planned;
1517: FETCH c_mst_planned INTO v_milestone_status;
1518: IF c_mst_planned%NOTFOUND THEN
1519: p_message_name := 'IGS_RE_CANT_LOCATE_MILST_STAT';

Line 1542: IGS_PR_MILESTONE_PKG.INSERT_ROW(

1538: OPEN c_mil_seq_num;
1539: FETCH c_mil_seq_num INTO v_mil_sequence_number;
1540: CLOSE c_mil_seq_num;
1541: -- if condition removed for Enh#3577974 for milestone validation build EN303
1542: IGS_PR_MILESTONE_PKG.INSERT_ROW(
1543: X_ROWID => LV_ROWID,
1544: X_PERSON_ID => p_person_id,
1545: X_ca_sequence_number => p_ca_sequence_number,
1546: X_sequence_number => v_mil_sequence_number,