APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_AV_ADV_STANDING

Line 990: p_person_id IGS_AV_ADV_STANDING.person_id%TYPE,

986:
987: END del_scan;
988:
989: PROCEDURE upd_del_re_candidature(
990: p_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
991: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
992: p_adm_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,
993: p_adm_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,
994: p_adm_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)

Line 991: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,

987: END del_scan;
988:
989: PROCEDURE upd_del_re_candidature(
990: p_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
991: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
992: p_adm_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,
993: p_adm_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,
994: p_adm_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)
995: IS

Line 1049: p_person_id IGS_AV_ADV_STANDING.person_id%TYPE,

1045:
1046: END upd_del_re_candidature;
1047:
1048: PROCEDURE del_av(
1049: p_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
1050: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
1051: p_version_num IGS_AV_ADV_STANDING.version_number%TYPE)
1052: IS
1053: BEGIN -- del_av

Line 1050: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,

1046: END upd_del_re_candidature;
1047:
1048: PROCEDURE del_av(
1049: p_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
1050: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
1051: p_version_num IGS_AV_ADV_STANDING.version_number%TYPE)
1052: IS
1053: BEGIN -- del_av
1054: -- Delete IGS_AV_ADV_STANDING records

Line 1051: p_version_num IGS_AV_ADV_STANDING.version_number%TYPE)

1047:
1048: PROCEDURE del_av(
1049: p_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
1050: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
1051: p_version_num IGS_AV_ADV_STANDING.version_number%TYPE)
1052: IS
1053: BEGIN -- del_av
1054: -- Delete IGS_AV_ADV_STANDING records
1055: DECLARE

Line 1054: -- Delete IGS_AV_ADV_STANDING records

1050: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
1051: p_version_num IGS_AV_ADV_STANDING.version_number%TYPE)
1052: IS
1053: BEGIN -- del_av
1054: -- Delete IGS_AV_ADV_STANDING records
1055: DECLARE
1056: CURSOR c_av IS
1057: SELECT ROWID
1058: FROM IGS_AV_ADV_STANDING av

Line 1058: FROM IGS_AV_ADV_STANDING av

1054: -- Delete IGS_AV_ADV_STANDING records
1055: DECLARE
1056: CURSOR c_av IS
1057: SELECT ROWID
1058: FROM IGS_AV_ADV_STANDING av
1059: WHERE av.person_id = p_person_id
1060: AND av.course_cd = p_course_cd
1061: AND av.version_number = p_version_num;
1062:

Line 1068: -- Delete IGS_AV_ADV_STANDING records

1064:
1065: BEGIN
1066:
1067: FOR c_av_rec IN c_av LOOP
1068: -- Delete IGS_AV_ADV_STANDING records
1069: IGS_AV_ADV_STANDING_PKG.DELETE_ROW( c_av_rec.ROWID);
1070:
1071: END LOOP;
1072: -- Return the default value

Line 1069: IGS_AV_ADV_STANDING_PKG.DELETE_ROW( c_av_rec.ROWID);

1065: BEGIN
1066:
1067: FOR c_av_rec IN c_av LOOP
1068: -- Delete IGS_AV_ADV_STANDING records
1069: IGS_AV_ADV_STANDING_PKG.DELETE_ROW( c_av_rec.ROWID);
1070:
1071: END LOOP;
1072: -- Return the default value
1073: