APPS.IGS_EN_INS_CA_TRNSFR dependencies on IGS_RE_SPRVSR

Line 408: FROM IGS_RE_SPRVSR rsup

404: v_rsup_exists VARCHAR2(1);
405: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
406: CURSOR c_rsup IS
407: SELECT 'x'
408: FROM IGS_RE_SPRVSR rsup
409: WHERE rsup.ca_person_id = p_person_id AND
410: rsup.ca_sequence_number = p_ca_sequence_number;
411: CURSOR c_rsup1 IS
412: SELECT rsup.person_id,

Line 425: FROM IGS_RE_SPRVSR rsup

421: rsup.ou_start_dt,
422: rsup.replaced_person_id,
423: rsup.replaced_sequence_number,
424: rsup.comments
425: FROM IGS_RE_SPRVSR rsup
426: WHERE rsup.ca_person_id = p_person_id AND
427: rsup.ca_sequence_number = p_transfer_ca_sequence_number
428: ORDER BY rsup.start_dt;
429: BEGIN

Line 439: --Validate that IGS_RE_SPRVSR details have not already been transferred

435: --Not processing course transfer Candidature, finish processing
436: p_message_name := null;
437: RETURN TRUE;
438: END IF;
439: --Validate that IGS_RE_SPRVSR details have not already been transferred
440: OPEN c_rsup;
441: FETCH c_rsup INTO v_rsup_exists;
442: IF c_rsup%FOUND THEN
443: CLOSE c_rsup;

Line 444: --IGS_RE_SPRVSR details already exist, cannot transfer

440: OPEN c_rsup;
441: FETCH c_rsup INTO v_rsup_exists;
442: IF c_rsup%FOUND THEN
443: CLOSE c_rsup;
444: --IGS_RE_SPRVSR details already exist, cannot transfer
445: p_message_name := 'IGS_RE_SUPERVISORS_EXISTS';
446: RETURN FALSE;
447: END IF;
448: CLOSE c_rsup;

Line 450: --Insert IGS_RE_SPRVSR details

446: RETURN FALSE;
447: END IF;
448: CLOSE c_rsup;
449: SAVEPOINT sp_research_supervisor;
450: --Insert IGS_RE_SPRVSR details
451: FOR v_rsup1_rec IN c_rsup1 LOOP
452: BEGIN
453: DECLARE
454: l_rowid VARCHAR2(25);

Line 456: IGS_RE_SPRVSR_PKG.INSERT_ROW(

452: BEGIN
453: DECLARE
454: l_rowid VARCHAR2(25);
455: BEGIN
456: IGS_RE_SPRVSR_PKG.INSERT_ROW(
457: x_rowid => l_rowid,
458: x_ca_person_id => p_person_id,
459: x_ca_sequence_number =>p_ca_sequence_number ,
460: x_person_id => v_rsup1_rec.person_id,

Line 483: END LOOP; --(IGS_RE_SPRVSR)

479: ROLLBACK TO sp_research_supervisor;
480: p_message_name := 'IGS_RE_SUPERVISORS_CANT_INSER';
481: RETURN FALSE;
482: END;
483: END LOOP; --(IGS_RE_SPRVSR)
484: -- Return the default value
485: RETURN TRUE;
486: EXCEPTION
487: WHEN OTHERS THEN