APPS.IGS_EN_INS_CA_TRNSFR dependencies on DUAL

Line 631: FROM dual;

627: v_the_sequence_number IGS_RE_THESIS.sequence_number%TYPE;
628: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(20) := 'ENRP_INS_CA_TRNSFR';
629: CURSOR c_next_val IS
630: SELECT IGS_RE_THESIS_SEQ_NUM_S.nextval
631: FROM dual;
632: CURSOR c_the IS
633: SELECT 'x'
634: FROM IGS_RE_THESIS thes
635: WHERE thes.person_id = p_person_id AND

Line 993: CURSOR c_dual IS

989: (ca_to.acai_admission_appl_number = p_acai_admission_appl_number AND
990: ca_to.acai_nominated_course_cd = p_acai_nominated_course_cd AND
991: ca_to.acai_sequence_number = p_acai_sequence_number AND
992: p_parent = cst_ca_to_acai);
993: CURSOR c_dual IS
994: SELECT IGS_RE_CANDIDATURE_SEQ_NUM_S.nextval
995: FROM dual;
996: BEGIN
997: -- Set the default message number

Line 995: FROM dual;

991: ca_to.acai_sequence_number = p_acai_sequence_number AND
992: p_parent = cst_ca_to_acai);
993: CURSOR c_dual IS
994: SELECT IGS_RE_CANDIDATURE_SEQ_NUM_S.nextval
995: FROM dual;
996: BEGIN
997: -- Set the default message number
998: p_message_name := null;
999: --Validate that Candidature details exist against the transferring 'from'

Line 1043: OPEN c_dual;

1039: );
1040: END;
1041:
1042: --Get next sequence number
1043: OPEN c_dual;
1044: FETCH c_dual INTO v_ca_sequence_number;
1045: --Insert Candidature
1046: BEGIN
1047: DECLARE

Line 1044: FETCH c_dual INTO v_ca_sequence_number;

1040: END;
1041:
1042: --Get next sequence number
1043: OPEN c_dual;
1044: FETCH c_dual INTO v_ca_sequence_number;
1045: --Insert Candidature
1046: BEGIN
1047: DECLARE
1048: l_rowid VARCHAR2(25);

Line 1157: IF c_dual%ISOPEN THEN

1153: END IF;
1154: IF c_ca_to%ISOPEN THEN
1155: CLOSE c_ca_to;
1156: END IF;
1157: IF c_dual%ISOPEN THEN
1158: CLOSE c_dual;
1159: END IF;
1160: RAISE;
1161: END;

Line 1158: CLOSE c_dual;

1154: IF c_ca_to%ISOPEN THEN
1155: CLOSE c_ca_to;
1156: END IF;
1157: IF c_dual%ISOPEN THEN
1158: CLOSE c_dual;
1159: END IF;
1160: RAISE;
1161: END;
1162: EXCEPTION