APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_RE_CANDIDATURE

Line 992: p_adm_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,

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
996: BEGIN -- upd_re_candidature

Line 993: p_adm_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,

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
996: BEGIN -- upd_re_candidature
997: -- Process IGS_RE_CANDIDATURE

Line 994: p_adm_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)

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
996: BEGIN -- upd_re_candidature
997: -- Process IGS_RE_CANDIDATURE
998: DECLARE

Line 997: -- Process IGS_RE_CANDIDATURE

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
996: BEGIN -- upd_re_candidature
997: -- Process IGS_RE_CANDIDATURE
998: DECLARE
999: CURSOR c_ca IS
1000: SELECT rowid, ca.*
1001: FROM IGS_RE_CANDIDATURE ca

Line 1001: FROM IGS_RE_CANDIDATURE ca

997: -- Process IGS_RE_CANDIDATURE
998: DECLARE
999: CURSOR c_ca IS
1000: SELECT rowid, ca.*
1001: FROM IGS_RE_CANDIDATURE ca
1002: WHERE ca.person_id = p_person_id
1003: AND ca.sca_course_cd = p_course_cd
1004: FOR UPDATE OF ca.sca_course_cd NOWAIT;
1005:

Line 1013: IGS_RE_CANDIDATURE_PKG.DELETE_ROW(X_ROWID => V_CA_REC.ROWID);

1009: IF (V_CA_REC.ACAI_ADMISSION_APPL_NUMBER IS NULL AND
1010: V_CA_REC.ACAI_NOMINATED_COURSE_CD IS NULL AND
1011: V_CA_REC.ACAI_SEQUENCE_NUMBER IS NULL) THEN
1012:
1013: IGS_RE_CANDIDATURE_PKG.DELETE_ROW(X_ROWID => V_CA_REC.ROWID);
1014: ELSE
1015:
1016: IGS_RE_CANDIDATURE_PKG.UPDATE_ROW(
1017: X_ROWID => V_CA_REC.ROWID,

Line 1016: IGS_RE_CANDIDATURE_PKG.UPDATE_ROW(

1012:
1013: IGS_RE_CANDIDATURE_PKG.DELETE_ROW(X_ROWID => V_CA_REC.ROWID);
1014: ELSE
1015:
1016: IGS_RE_CANDIDATURE_PKG.UPDATE_ROW(
1017: X_ROWID => V_CA_REC.ROWID,
1018: X_PERSON_ID => V_CA_REC.PERSON_ID,
1019: X_SEQUENCE_NUMBER => V_CA_REC.SEQUENCE_NUMBER,
1020: X_SCA_COURSE_CD => NULL,