APPS.IGS_RE_VAL_RSUP dependencies on IGS_RE_SPRVSR_TYPE

Line 32: -- IGS_RE_SPRVSR_TYPE checked as a principal

28: -- This module validates that a principal supervisor exists
29: -- on the commencement date of the research IGS_RE_CANDIDATURE.
30: -- Validatios are:
31: -- * At least one IGS_RE_SPRVSR with
32: -- IGS_RE_SPRVSR_TYPE checked as a principal
33: -- must exist fir an offer where research details
34: -- are mandatory or where the IGS_PS_COURSE is defined as
35: -- a research supervisor.
36: DECLARE

Line 488: IGS_RE_SPRVSR_TYPE rst

484: CURSOR c_rsup_rst (
485: cp_start_dt IGS_RE_SPRVSR.start_dt%TYPE) IS
486: SELECT 'X'
487: FROM IGS_RE_SPRVSR rsup,
488: IGS_RE_SPRVSR_TYPE rst
489: WHERE rsup.ca_person_id = p_ca_person_id AND
490: rsup.ca_sequence_number = p_ca_sequence_number AND
491: rsup.start_dt <= cp_start_dt AND
492: (rsup.end_dt IS NULL OR

Line 981: -- Validate if IGS_RE_SPRVSR_TYPE.IGS_RE_SPRVSR_TYPE is closed.

977: p_research_supervisor_type IN VARCHAR2 ,
978: p_message_name OUT NOCOPY VARCHAR2 )
979: RETURN BOOLEAN AS
980: BEGIN -- resp_val_rst_closed
981: -- Validate if IGS_RE_SPRVSR_TYPE.IGS_RE_SPRVSR_TYPE is closed.
982: DECLARE
983: CURSOR c_rst IS
984: SELECT 'x'
985: FROM IGS_RE_SPRVSR_TYPE rst

Line 985: FROM IGS_RE_SPRVSR_TYPE rst

981: -- Validate if IGS_RE_SPRVSR_TYPE.IGS_RE_SPRVSR_TYPE is closed.
982: DECLARE
983: CURSOR c_rst IS
984: SELECT 'x'
985: FROM IGS_RE_SPRVSR_TYPE rst
986: WHERE rst.research_supervisor_type = p_research_supervisor_type AND
987: rst.closed_ind = 'Y';
988: v_rst_exists VARCHAR2(1);
989: BEGIN