eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_GEN_010 dependencies on IGS_RE_CANDIDATURE

Line 815: -- Update IGS_RE_CANDIDATURE Key Detail

811: RETURN BOOLEAN
812: AS
813:
814: BEGIN -- enrpl_upd_candidature
815: -- Update IGS_RE_CANDIDATURE Key Detail
816: DECLARE
817: CURSOR c_ca IS
818: SELECT ca.sequence_number
819: FROM IGS_RE_CANDIDATURE ca

Line 819: FROM IGS_RE_CANDIDATURE ca

815: -- Update IGS_RE_CANDIDATURE Key Detail
816: DECLARE
817: CURSOR c_ca IS
818: SELECT ca.sequence_number
819: FROM IGS_RE_CANDIDATURE ca
820: WHERE ca.person_id = p_person_id AND
821: ca.sca_course_cd = p_course_cd;
822: CURSOR c_ca2 IS
823: SELECT ca.sequence_number

Line 824: FROM IGS_RE_CANDIDATURE ca

820: WHERE ca.person_id = p_person_id AND
821: ca.sca_course_cd = p_course_cd;
822: CURSOR c_ca2 IS
823: SELECT ca.sequence_number
824: FROM IGS_RE_CANDIDATURE ca
825: WHERE ca.person_id = p_person_id AND
826: ca.acai_admission_appl_number = v_acaiv_rec.admission_appl_number AND
827: ca.acai_nominated_course_cd = v_acaiv_rec.nominated_course_cd AND
828: ca.acai_sequence_number = v_acaiv_rec.sequence_number;

Line 830: cp_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE) IS

826: ca.acai_admission_appl_number = v_acaiv_rec.admission_appl_number AND
827: ca.acai_nominated_course_cd = v_acaiv_rec.nominated_course_cd AND
828: ca.acai_sequence_number = v_acaiv_rec.sequence_number;
829: CURSOR c_ca_upd (
830: cp_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE) IS
831: SELECT ROWID,
832: IGS_RE_CANDIDATURE.*
833: FROM IGS_RE_CANDIDATURE
834: WHERE person_id = p_person_id AND

Line 832: IGS_RE_CANDIDATURE.*

828: ca.acai_sequence_number = v_acaiv_rec.sequence_number;
829: CURSOR c_ca_upd (
830: cp_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE) IS
831: SELECT ROWID,
832: IGS_RE_CANDIDATURE.*
833: FROM IGS_RE_CANDIDATURE
834: WHERE person_id = p_person_id AND
835: sequence_number = cp_sequence_number
836: FOR UPDATE OF

Line 833: FROM IGS_RE_CANDIDATURE

829: CURSOR c_ca_upd (
830: cp_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE) IS
831: SELECT ROWID,
832: IGS_RE_CANDIDATURE.*
833: FROM IGS_RE_CANDIDATURE
834: WHERE person_id = p_person_id AND
835: sequence_number = cp_sequence_number
836: FOR UPDATE OF
837: acai_admission_appl_number,

Line 844: v_sca_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

840:
841: v_c_ca_upd_rec c_ca_upd%ROWTYPE;
842:
843: v_ca_upd_exists VARCHAR2(1);
844: v_sca_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
845: v_acai_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
846:
847: BEGIN
848: p_warn_level := NULL;

Line 845: v_acai_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

841: v_c_ca_upd_rec c_ca_upd%ROWTYPE;
842:
843: v_ca_upd_exists VARCHAR2(1);
844: v_sca_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
845: v_acai_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
846:
847: BEGIN
848: p_warn_level := NULL;
849: p_message_name := null;

Line 850: -- Check if IGS_PE_PERSON has a IGS_RE_CANDIDATURE record linked

846:
847: BEGIN
848: p_warn_level := NULL;
849: p_message_name := null;
850: -- Check if IGS_PE_PERSON has a IGS_RE_CANDIDATURE record linked
851: -- to the student IGS_PS_COURSE attempt.
852: OPEN c_ca;
853: FETCH c_ca INTO v_sca_ca_sequence_number;
854: CLOSE c_ca;

Line 855: -- Check if IGS_PE_PERSON has a IGS_RE_CANDIDATURE record linked to

851: -- to the student IGS_PS_COURSE attempt.
852: OPEN c_ca;
853: FETCH c_ca INTO v_sca_ca_sequence_number;
854: CLOSE c_ca;
855: -- Check if IGS_PE_PERSON has a IGS_RE_CANDIDATURE record linked to
856: -- the admission IGS_PS_COURSE application instance.
857: OPEN c_ca2;
858: FETCH c_ca2 INTO v_acai_ca_sequence_number;
859: CLOSE c_ca2;

Line 862: -- instance to be linked to a IGS_RE_CANDIDATURE and the student

858: FETCH c_ca2 INTO v_acai_ca_sequence_number;
859: CLOSE c_ca2;
860: IF v_sca_ca_sequence_number <> v_acai_ca_sequence_number THEN
861: -- It is not valid for the admission IGS_PS_COURSE application
862: -- instance to be linked to a IGS_RE_CANDIDATURE and the student
863: -- IGS_PS_COURSE attempt to be linked to a different IGS_RE_CANDIDATURE.
864: -- Cannot determine which IGS_RE_CANDIDATURE should be used.
865: -- Rollback to start of routine
866: ROLLBACK TO sp_pre_enrol_student;

Line 863: -- IGS_PS_COURSE attempt to be linked to a different IGS_RE_CANDIDATURE.

859: CLOSE c_ca2;
860: IF v_sca_ca_sequence_number <> v_acai_ca_sequence_number THEN
861: -- It is not valid for the admission IGS_PS_COURSE application
862: -- instance to be linked to a IGS_RE_CANDIDATURE and the student
863: -- IGS_PS_COURSE attempt to be linked to a different IGS_RE_CANDIDATURE.
864: -- Cannot determine which IGS_RE_CANDIDATURE should be used.
865: -- Rollback to start of routine
866: ROLLBACK TO sp_pre_enrol_student;
867: IF p_log_creation_dt IS NOT NULL THEN

Line 864: -- Cannot determine which IGS_RE_CANDIDATURE should be used.

860: IF v_sca_ca_sequence_number <> v_acai_ca_sequence_number THEN
861: -- It is not valid for the admission IGS_PS_COURSE application
862: -- instance to be linked to a IGS_RE_CANDIDATURE and the student
863: -- IGS_PS_COURSE attempt to be linked to a different IGS_RE_CANDIDATURE.
864: -- Cannot determine which IGS_RE_CANDIDATURE should be used.
865: -- Rollback to start of routine
866: ROLLBACK TO sp_pre_enrol_student;
867: IF p_log_creation_dt IS NOT NULL THEN
868: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 883: -- to a IGS_RE_CANDIDATURE - need to link it to the IGS_RE_CANDIDATURE

879: RETURN FALSE;
880: ELSIF v_sca_ca_sequence_number IS NOT NULL AND
881: v_acai_ca_sequence_number IS NULL THEN
882: -- The admission IGS_PS_COURSE application instance is not linked
883: -- to a IGS_RE_CANDIDATURE - need to link it to the IGS_RE_CANDIDATURE
884: -- record of the student IGS_PS_COURSE attempt.
885: OPEN c_ca_upd(
886: v_sca_ca_sequence_number);
887: FETCH c_ca_upd INTO v_c_ca_upd_rec;

Line 890: IGS_RE_CANDIDATURE_PKG.UPDATE_ROW(

886: v_sca_ca_sequence_number);
887: FETCH c_ca_upd INTO v_c_ca_upd_rec;
888:
889: IF c_ca_upd%FOUND THEN
890: IGS_RE_CANDIDATURE_PKG.UPDATE_ROW(
891: X_ROWID => v_c_ca_upd_rec.rowid,
892: X_PERSON_ID => v_c_ca_upd_rec.PERSON_ID,
893: X_SEQUENCE_NUMBER => v_c_ca_upd_rec.SEQUENCE_NUMBER,
894: X_SCA_COURSE_CD => v_c_ca_upd_rec.SCA_COURSE_CD,

Line 911: -- The student IGS_PS_COURSE attempt is not linked to a IGS_RE_CANDIDATURE,

907: CLOSE c_ca_upd;
908:
909: ELSIF v_sca_ca_sequence_number IS NULL AND
910: v_acai_ca_sequence_number IS NOT NULL THEN
911: -- The student IGS_PS_COURSE attempt is not linked to a IGS_RE_CANDIDATURE,
912: -- need to link it to the IGS_RE_CANDIDATURE record of the admission
913: -- IGS_PS_COURSE application instance.
914: OPEN c_ca_upd(
915: v_acai_ca_sequence_number);

Line 912: -- need to link it to the IGS_RE_CANDIDATURE record of the admission

908:
909: ELSIF v_sca_ca_sequence_number IS NULL AND
910: v_acai_ca_sequence_number IS NOT NULL THEN
911: -- The student IGS_PS_COURSE attempt is not linked to a IGS_RE_CANDIDATURE,
912: -- need to link it to the IGS_RE_CANDIDATURE record of the admission
913: -- IGS_PS_COURSE application instance.
914: OPEN c_ca_upd(
915: v_acai_ca_sequence_number);
916: FETCH c_ca_upd INTO v_c_ca_upd_rec;

Line 920: IGS_RE_CANDIDATURE_PKG.UPDATE_ROW(

916: FETCH c_ca_upd INTO v_c_ca_upd_rec;
917:
918: IF c_ca_upd%FOUND THEN
919:
920: IGS_RE_CANDIDATURE_PKG.UPDATE_ROW(
921: X_ROWID => v_c_ca_upd_rec.rowid,
922: X_PERSON_ID => v_c_ca_upd_rec.PERSON_ID,
923: X_SEQUENCE_NUMBER => v_c_ca_upd_rec.SEQUENCE_NUMBER,
924: X_SCA_COURSE_CD => v_acaiv_rec.course_cd,

Line 1336: -- Perform

1332:
1333: END;
1334: l_confirmed_ind := v_confirmed_ind ;
1335: v_sca_commencement_dt := v_commencement_dt;
1336: -- Perform
1337: IF NOT enrpl_upd_candidature(
1338: p_warn_level,
1339: p_message_name) THEN
1340: RETURN;

Line 1504: -- Perform

1500:
1501: CLOSE c_sca_upd;
1502: l_confirmed_ind := v_confirmed_ind ;
1503: v_sca_commencement_dt := v_commencement_dt;
1504: -- Perform
1505: IF NOT enrpl_upd_candidature(
1506: p_warn_level,
1507: p_message_name) THEN
1508: RETURN;

Line 1650: -- Perform

1646: --bmerugu added for build 319
1647: v_rowid := v_sca_upd_rec.rowid;
1648:
1649: CLOSE c_sca_upd;
1650: -- Perform
1651: IF NOT enrpl_upd_candidature(
1652: p_warn_level,
1653: p_message_name) THEN
1654: RETURN;

Line 1803: -- Perform

1799: --bmerugu added for build 319
1800: v_rowid := v_sca_upd_rec.rowid;
1801:
1802: CLOSE c_sca_upd;
1803: -- Perform
1804: IF NOT enrpl_upd_candidature(
1805: p_warn_level,
1806: p_message_name) THEN
1807: RETURN;