APPS.IGS_AD_GEN_004 dependencies on IGS_GE_NUMBER

Line 381: RPAD(NVL(IGS_GE_NUMBER.TO_CANN(v_cv_acaiv_rec.preference_number),'-'),2) || ' ' ||

377: RPAD(NVL(v_cv_acaiv_rec.attendance_type, '-'),2) || ' ' ||
378: NVL(v_cv_acaiv_rec.commencement_period, '-');
379: ELSE
380: v_out_string :=
381: RPAD(NVL(IGS_GE_NUMBER.TO_CANN(v_cv_acaiv_rec.preference_number),'-'),2) || ' ' ||
382: RPAD(NVL(v_cv_acaiv_rec.course_cd, '-'),10) || ' ' ||
383: RPAD(NVL(v_cv_acaiv_rec.short_title, '-'),40) || ' ' ||
384: RPAD(NVL(v_cv_acaiv_rec.location_cd, '-'),10) || ' ' ||
385: RPAD(NVL(v_cv_acaiv_rec.attendance_mode, '-'),2) || ' ' ||

Line 894: p_expected_completion_yr := IGS_GE_NUMBER.TO_NUM(v_dai2_alias_val_yyyy);

890: v_dai2_alias_val_dd_mon := SUBSTR(IGS_GE_DATE.IGSCHAR(v_dai2_alias_val),5,10); --IGSCHAR returns date in 'YYYY/MM/DD' format
891:
892: v_dai2_alias_val_yyyy := SUBSTR(IGS_GE_DATE.IGSCHAR(v_dai2_alias_val),1,4); --IGSCHAR returns date in 'YYYY/MM/DD' format
893:
894: p_expected_completion_yr := IGS_GE_NUMBER.TO_NUM(v_dai2_alias_val_yyyy);
895:
896: p_completion_dt := IGS_GE_DATE.IGSDATE(IGS_GE_NUMBER.TO_CANN(p_expected_completion_yr)||v_dai2_alias_val_dd_mon);
897:
898: --Return the Completion Period associated with the calculated Completion date alias instance.

Line 896: p_completion_dt := IGS_GE_DATE.IGSDATE(IGS_GE_NUMBER.TO_CANN(p_expected_completion_yr)||v_dai2_alias_val_dd_mon);

892: v_dai2_alias_val_yyyy := SUBSTR(IGS_GE_DATE.IGSCHAR(v_dai2_alias_val),1,4); --IGSCHAR returns date in 'YYYY/MM/DD' format
893:
894: p_expected_completion_yr := IGS_GE_NUMBER.TO_NUM(v_dai2_alias_val_yyyy);
895:
896: p_completion_dt := IGS_GE_DATE.IGSDATE(IGS_GE_NUMBER.TO_CANN(p_expected_completion_yr)||v_dai2_alias_val_dd_mon);
897:
898: --Return the Completion Period associated with the calculated Completion date alias instance.
899: IF (v_dai2_dt_alias = NVL(v_adm_e_perd_dt_alias, 'NONE')) THEN
900: p_expected_completion_perd := 'E';