[Home] [Help]
206:
207: CURSOR c_funding IS
208: SELECT NVL(SUM(rsup.funding_percentage),0),count(*)
209: FROM IGS_RE_SPRVSR rsup,
210: igs_pe_person_types pt,
211: igs_pe_typ_instances pti
212: WHERE rsup.ca_person_id = p_ca_person_id
213: AND rsup.ca_sequence_number = p_ca_sequence_number
214: AND rsup.person_id = pti.person_id
406: RAISE;
407: END;
408: END resp_val_rsup_perc;
409: --
410: -- Validate research supervisor IGS_PE_PERSON.
411: FUNCTION resp_val_rsup_person(
412: p_ca_person_id IN NUMBER ,
413: p_person_id IN NUMBER ,
414: p_legacy IN VARCHAR2,
432: END IF;
433: END IF;
434:
435: IF p_legacy = 'N' THEN
436: -- Validate that IGS_PE_PERSON exists and warn if deceased.
437: v_deceased_ind := IGS_PE_GEN_004.get_deceased_indicator( p_person_id );
438: IF v_deceased_ind = 'Y' THEN
439: p_message_name := 'IGS_GE_WARN_PERSON_DECEASED';
440: END IF;
580: BEGIN
581: -- Set the default message number
582: p_message_name := null;
583: IF p_replaced_person_id IS NOT NULL THEN
584: -- Validate that the supervisor and replacement are not the same IGS_PE_PERSON.
585: IF p_replaced_person_id = p_person_id THEN
586: p_message_name := 'IGS_RE_SUPERV_REPL_INVALID';
587: IF p_legacy = 'Y' THEN
588: FND_MESSAGE.SET_NAME('IGS', p_message_name);
672: -- organisational IGS_PS_UNIT must exist and be valid.
673: -- If funding percentage exists, then
674: -- supervisor must be a staff member.
675: DECLARE
676: v_staff_member_ind IGS_PE_PERSON.staff_member_ind%TYPE;
677: v_message_name VARCHAR2(30);
678:
679: BEGIN
680: -- Set the default message number
776: AND org.start_dt = p_ou_start_dt;
777:
778: v_c_ooi_sos IGS_OR_STATUS.s_org_status%TYPE;
779: v_c_ooi_lii IGS_OR_INSTITUTION.local_institution_ind%TYPE;
780: v_staff_member_ind IGS_PE_PERSON.staff_member_ind%TYPE;
781: BEGIN
782: -- Set the default message number
783: p_message_name := NULL;
784: IF p_org_unit_cd IS NOT NULL AND p_ou_start_dt IS NOT NULL THEN