APPS.IGS_AD_GEN_001 dependencies on IGS_RE_CANDIDATURE

Line 356: -- IGS_RE_CANDIDATURE (by breaking the SCA parent link

352: -- Student IGS_PS_COURSE HECS Option
353: -- Student IGS_PS_COURSE Attempt Enrolment
354: -- Student IGS_PS_COURSE Attempt Notes
355: -- Advanced Standing (and child tables
356: -- IGS_RE_CANDIDATURE (by breaking the SCA parent link
357: -- Fee Assessment (by reversing the fee assessment)
358: -- Contract Fee Assessment Rates
359: -- Records on all other student IGS_PS_COURSE child tables are to be
360: -- processed as IGS_GE_EXCEPTIONS

Line 1104: p_adm_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,

1100: --------------------------------------------------------------------------------
1101: FUNCTION admpl_upd_re_candidature(
1102: p_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
1103: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
1104: p_adm_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,
1105: p_adm_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,
1106: p_adm_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)
1107: RETURN BOOLEAN
1108: IS

Line 1105: p_adm_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,

1101: FUNCTION admpl_upd_re_candidature(
1102: p_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
1103: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
1104: p_adm_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,
1105: p_adm_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,
1106: p_adm_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)
1107: RETURN BOOLEAN
1108: IS
1109: BEGIN -- admpl_upd_re_candidature

Line 1106: p_adm_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)

1102: p_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
1103: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
1104: p_adm_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,
1105: p_adm_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,
1106: p_adm_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)
1107: RETURN BOOLEAN
1108: IS
1109: BEGIN -- admpl_upd_re_candidature
1110: -- Process IGS_RE_CANDIDATURE

Line 1110: -- Process IGS_RE_CANDIDATURE

1106: p_adm_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)
1107: RETURN BOOLEAN
1108: IS
1109: BEGIN -- admpl_upd_re_candidature
1110: -- Process IGS_RE_CANDIDATURE
1111: DECLARE
1112: CURSOR c_ca IS
1113: SELECT rowid, ca.*
1114: FROM IGS_RE_CANDIDATURE ca

Line 1114: FROM IGS_RE_CANDIDATURE ca

1110: -- Process IGS_RE_CANDIDATURE
1111: DECLARE
1112: CURSOR c_ca IS
1113: SELECT rowid, ca.*
1114: FROM IGS_RE_CANDIDATURE ca
1115: WHERE ca.person_id = p_person_id AND
1116: ca.sca_course_cd = p_course_cd AND
1117: ca.acai_admission_appl_number = p_adm_admission_appl_number AND
1118: ca.acai_nominated_course_cd = p_adm_nominated_course_cd AND

Line 1124: IGS_RE_CANDIDATURE_PKG.UPDATE_ROW(

1120: FOR UPDATE OF ca.sca_course_cd NOWAIT;
1121: BEGIN
1122: FOR v_ca_rec IN c_ca LOOP
1123:
1124: IGS_RE_CANDIDATURE_PKG.UPDATE_ROW(
1125: X_ROWID => V_CA_REC.ROWID,
1126: X_PERSON_ID => V_CA_REC.PERSON_ID,
1127: X_SEQUENCE_NUMBER => V_CA_REC.SEQUENCE_NUMBER,
1128: X_SCA_COURSE_CD => NULL,

Line 1146: l_entity_name := 'IGS_RE_CANDIDATURE_ALL';

1142: WHEN e_resource_busy THEN
1143: IF c_ca%ISOPEN THEN
1144: CLOSE c_ca;
1145: END IF;
1146: l_entity_name := 'IGS_RE_CANDIDATURE_ALL';
1147: RETURN FALSE;
1148: WHEN OTHERS THEN
1149: IF c_ca%ISOPEN THEN
1150: CLOSE c_ca;