APPS.IGS_RE_VAL_THE dependencies on IGS_RE_CANDIDATURE

Line 94: v_max_sub_dt IGS_RE_CANDIDATURE.max_submission_dt%TYPE := NULL;

90: -- * Cannot be backdated.
91: -- * Cannot be prior to the derived/override minimum submission date
92: -- * Cannot be beyond the derived/override maximum submission date
93: DECLARE
94: v_max_sub_dt IGS_RE_CANDIDATURE.max_submission_dt%TYPE := NULL;
95: v_min_sub_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE := NULL;
96: CURSOR c_ca IS
97: SELECT ca.max_submission_dt,
98: ca.min_submission_dt

Line 95: v_min_sub_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE := NULL;

91: -- * Cannot be prior to the derived/override minimum submission date
92: -- * Cannot be beyond the derived/override maximum submission date
93: DECLARE
94: v_max_sub_dt IGS_RE_CANDIDATURE.max_submission_dt%TYPE := NULL;
95: v_min_sub_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE := NULL;
96: CURSOR c_ca IS
97: SELECT ca.max_submission_dt,
98: ca.min_submission_dt
99: FROM IGS_RE_CANDIDATURE ca

Line 99: FROM IGS_RE_CANDIDATURE ca

95: v_min_sub_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE := NULL;
96: CURSOR c_ca IS
97: SELECT ca.max_submission_dt,
98: ca.min_submission_dt
99: FROM IGS_RE_CANDIDATURE ca
100: WHERE ca.person_id = p_person_id AND
101: ca.sequence_number = p_ca_sequence_number;
102: BEGIN
103: p_message_name := NULL;

Line 631: || igs_re_candidature_all for the corresponding person_id and course_cd combination

627: /*
628: || Created By : nbehera
629: || Created On : 14-NOV-2002
630: || Purpose : The function will check for a mapping ca_sequence_number in the table
631: || igs_re_candidature_all for the corresponding person_id and course_cd combination
632: || Known limitations, enhancements or remarks :
633: || Change History :
634: || Who When What
635: || (reverse chronological order - newest change first)

Line 640: FROM igs_re_candidature_all

636: */
637:
638: CURSOR c_ca_seq_number IS
639: SELECT sequence_number
640: FROM igs_re_candidature_all
641: WHERE sca_course_cd IS NOT NULL
642: AND sca_course_cd = p_course_cd
643: AND person_id = p_person_id;
644:

Line 677: igs_re_candidature re

673: */
674: CURSOR c_title IS
675: SELECT title
676: FROM igs_re_thesis_all the,
677: igs_re_candidature re
678: WHERE the.person_id = p_person_id
679: AND the.title = p_title
680: AND re.sequence_number = p_ca_sequence_number
681: AND re.person_id = the.person_id;

Line 715: FROM igs_re_candidature

711: */
712:
713: CURSOR c_min_subm_dt IS
714: SELECT min_submission_dt
715: FROM igs_re_candidature
716: WHERE sequence_number = p_ca_sequence_number
717: AND person_id = p_person_id;
718: l_min_sub_date igs_re_candidature.min_submission_dt%TYPE;
719:

Line 718: l_min_sub_date igs_re_candidature.min_submission_dt%TYPE;

714: SELECT min_submission_dt
715: FROM igs_re_candidature
716: WHERE sequence_number = p_ca_sequence_number
717: AND person_id = p_person_id;
718: l_min_sub_date igs_re_candidature.min_submission_dt%TYPE;
719:
720: BEGIN
721:
722: OPEN c_min_subm_dt;