eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_GEN_006 dependencies on IGS_PS_COURSE

Line 1008: p_course_cd IGS_PS_COURSE.COURSE_CD%TYPE;

1004: p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1005: p_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1006: p_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1007: p_teach_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1008: p_course_cd IGS_PS_COURSE.COURSE_CD%TYPE;
1009: p_unit_cd IGS_PS_UNIT.UNIT_CD%TYPE;
1010: p_location_cd IGS_AD_LOCATION.LOCATION_CD%TYPE;
1011: p_unit_class IGS_AS_UNIT_CLASS.UNIT_CLASS%TYPE;
1012: p_unit_mode IGS_AS_UNIT_MODE.UNIT_MODE%TYPE;

Line 1494: -- Reset the last IGS_PS_COURSE and IGS_PS_UNIT codes so that if it is a new IGS_PE_PERSON,

1490: v_ignore_rec := TRUE;
1491: ELSE
1492: CLOSE c_pa;
1493: v_last_person_id := v_enrolled_rec.person_id;
1494: -- Reset the last IGS_PS_COURSE and IGS_PS_UNIT codes so that if it is a new IGS_PE_PERSON,
1495: -- then the appropriate IGS_PS_COURSE and unit version is retrieved.
1496: v_last_course_cd := NULL;
1497: v_last_unit_cd := NULL;
1498:

Line 1495: -- then the appropriate IGS_PS_COURSE and unit version is retrieved.

1491: ELSE
1492: CLOSE c_pa;
1493: v_last_person_id := v_enrolled_rec.person_id;
1494: -- Reset the last IGS_PS_COURSE and IGS_PS_UNIT codes so that if it is a new IGS_PE_PERSON,
1495: -- then the appropriate IGS_PS_COURSE and unit version is retrieved.
1496: v_last_course_cd := NULL;
1497: v_last_unit_cd := NULL;
1498:
1499: END IF; -- End of if 5

Line 1525: -- Get the IGS_PS_COURSE version and description (Short IGS_PE_TITLE)

1521: v_pa_rec.postal_code || '|' ||
1522: v_pa_rec.correspondence_ind || '|';
1523:
1524:
1525: -- Get the IGS_PS_COURSE version and description (Short IGS_PE_TITLE)
1526: -- Only if different to the previous IGS_PS_COURSE cd processed.
1527:
1528: IF NVL(v_last_course_cd, 'NULL') <> v_enrolled_rec.course_cd THEN -- Start of if 8
1529: OPEN c_crv(

Line 1526: -- Only if different to the previous IGS_PS_COURSE cd processed.

1522: v_pa_rec.correspondence_ind || '|';
1523:
1524:
1525: -- Get the IGS_PS_COURSE version and description (Short IGS_PE_TITLE)
1526: -- Only if different to the previous IGS_PS_COURSE cd processed.
1527:
1528: IF NVL(v_last_course_cd, 'NULL') <> v_enrolled_rec.course_cd THEN -- Start of if 8
1529: OPEN c_crv(
1530: v_enrolled_rec.person_id,