APPS.IGS_AD_GEN_002 dependencies on IGS_GE_NUMBER

Line 1255: LTRIM(TO_CHAR(IGS_GE_NUMBER.TO_NUM(p_govt_field_of_study), '000000')) ||

1251: -- Write out NOCOPY the details of the course attempt record
1252: v_output_course := cst_course_rec_type ||
1253: RPAD(p_course_cd, 10) ||
1254: RPAD(p_course_title, 72) ||
1255: LTRIM(TO_CHAR(IGS_GE_NUMBER.TO_NUM(p_govt_field_of_study), '000000')) ||
1256: LTRIM(TO_CHAR(p_govt_course_type, '00')) ||
1257: NVL(p_honours_flag, '0') ||
1258: RPAD(NVL(p_exclusion_flag, ' '), 1) ||
1259: RPAD(NVL(p_all_subjects_inc_flag, ' '), 1) ||

Line 1509: RPAD(IGS_GE_NUMBER.TO_CANN(p_matched_id), 10) ||

1505: END IF;
1506: END IF;
1507: v_output_student := cst_student_rec_type ||
1508: RPAD(NVL(p_basis_of_match, ' '), 3) ||
1509: RPAD(IGS_GE_NUMBER.TO_CANN(p_matched_id), 10) ||
1510: RPAD(NVL(v_surname, ' '), 20) ||
1511: RPAD(NVL(v_first_name, ' '), 15) ||
1512: RPAD(NVL(v_second_name, ' '), 15) ||
1513: RPAD(NVL(v_birth_dt_str, ' '), 6) ||

Line 1633: v_semester_enrolled := IGS_GE_NUMBER.TO_NUM(SUBSTR(v_arts_teaching_cal_type_cd, 1, 1));

1629: FETCH c_cat INTO v_arts_teaching_cal_type_cd;
1630: CLOSE c_cat;
1631: IF (SUBSTR(v_arts_teaching_cal_type_cd, 1, 1) IN
1632: ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')) THEN
1633: v_semester_enrolled := IGS_GE_NUMBER.TO_NUM(SUBSTR(v_arts_teaching_cal_type_cd, 1, 1));
1634: ELSE
1635: v_semester_enrolled := NULL;
1636: END IF;
1637: -- Work out NOCOPY course record fields as we loop through all the units

Line 1744: v_subject_discipline_group := IGS_GE_NUMBER.TO_NUM(v_govt_discipline_group_cd);

1740: END IF;
1741: END LOOP;
1742: IF (v_number_ind = TRUE) THEN
1743: -- v_govt_discipline_group_cd is a number
1744: v_subject_discipline_group := IGS_GE_NUMBER.TO_NUM(v_govt_discipline_group_cd);
1745: ELSE
1746: -- v_govt_discipline_group_cd is not a number
1747: v_subject_discipline_group := NULL;
1748: END IF;

Line 1758: IGS_GE_NUMBER.TO_CANN(v_subject_completion_code) ||

1754: ' ' || -- unused space
1755: LTRIM(TO_CHAR(v_semester_enrolled, '0')) || -- should not be null
1756: LTRIM(TO_CHAR(v_sua_eftsu, '000V000')) ||
1757: RPAD(NVL(v_grade, ' '), 6) ||
1758: IGS_GE_NUMBER.TO_CANN(v_subject_completion_code) ||
1759: LTRIM(TO_CHAR(NVL(v_subject_discipline_group, 0), '0000')) ||
1760: fnd_global.newline;
1761: v_subject_cnt := v_subject_cnt + 1;
1762: t_subject(v_subject_cnt) := v_output_subject;

Line 2278: p_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_acad_perd, 112, 6)));

2274: DECLARE
2275: invalid_parameter EXCEPTION;
2276: BEGIN
2277: p_acad_cal_type := RTRIM(SUBSTR(p_acad_perd, 101, 10));
2278: p_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_acad_perd, 112, 6)));
2279: END;
2280: --End of Block for Parameter Validation/Splitting of Parameters
2281: --This module will read the VTAC enrolment return file, retrieve enrolment
2282: --information for the student by calling IGS_AD_GEN_010.ADMP_GET_TAC_RETURN and then write

Line 2490: other_reference = IGS_GE_NUMBER.TO_CANN(cp_spl_sequence_number);

2486: FROM IGS_CO_OU_CO_REF
2487: WHERE person_id = p_person_id AND
2488: correspondence_type = p_correspondence_type AND
2489: s_other_reference_type = cst_spl_seqnum AND
2490: other_reference = IGS_GE_NUMBER.TO_CANN(cp_spl_sequence_number);
2491: BEGIN
2492: OPEN c_aal;
2493: FETCH c_aal INTO v_spl_sequence_number;
2494: IF (c_aal%FOUND) THEN