APPS.IGS_AD_PG_DATA_LOAD dependencies on IGS_GE_NUMBER

Line 85: p_acad_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_acad_perd, 112, 6)));

81: igs_ge_gen_003.set_org_id(p_org_id);
82:
83: -- extract academic calendar
84: p_acad_cal_type := RTRIM(SUBSTR(p_acad_perd, 101, 10));
85: p_acad_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_acad_perd, 112, 6)));
86:
87: -- extract admission calendar
88: p_adm_cal_type := RTRIM(SUBSTR(p_adm_perd, 101, 10));
89: p_adm_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_adm_perd, 112, 6)));

Line 89: p_adm_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_adm_perd, 112, 6)));

85: p_acad_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_acad_perd, 112, 6)));
86:
87: -- extract admission calendar
88: p_adm_cal_type := RTRIM(SUBSTR(p_adm_perd, 101, 10));
89: p_adm_seq_num := IGS_GE_NUMBER.TO_NUM(RTRIM(SUBSTR(p_adm_perd, 112, 6)));
90:
91:
92:
93: IF (IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

Line 694: start_yr := IGS_GE_NUMBER.TO_NUM(vtac_tert_year_commence);

690:
691: vtac_tert_year_commence := RTRIM(SUBSTR(po_sec_str(k),1,4));
692: vtac_tert_year_finish := RTRIM(SUBSTR(po_sec_str(k),5,4));
693:
694: start_yr := IGS_GE_NUMBER.TO_NUM(vtac_tert_year_commence);
695: end_yr := IGS_GE_NUMBER.TO_NUM(vtac_tert_year_finish);
696:
697:
698: vtac_tert_student_idnum := RTRIM(SUBSTR(po_sec_str(k),34,9));

Line 695: end_yr := IGS_GE_NUMBER.TO_NUM(vtac_tert_year_finish);

691: vtac_tert_year_commence := RTRIM(SUBSTR(po_sec_str(k),1,4));
692: vtac_tert_year_finish := RTRIM(SUBSTR(po_sec_str(k),5,4));
693:
694: start_yr := IGS_GE_NUMBER.TO_NUM(vtac_tert_year_commence);
695: end_yr := IGS_GE_NUMBER.TO_NUM(vtac_tert_year_finish);
696:
697:
698: vtac_tert_student_idnum := RTRIM(SUBSTR(po_sec_str(k),34,9));
699: vtac_tert_inst_code := RTRIM(SUBSTR(po_sec_str(k),43,4));