APPS.IGS_EN_INS_CA_TRNSFR dependencies on IGS_RE_THESIS_EXAM

Line 666: FROM IGS_RE_THESIS_EXAM tex

662: tex.thesis_exam_type,
663: tex.thesis_panel_type,
664: tex.tracking_id,
665: tex.thesis_result_cd
666: FROM IGS_RE_THESIS_EXAM tex
667: WHERE tex.person_id = p_person_id AND
668: tex.ca_sequence_number = p_transfer_ca_sequence_number AND
669: tex.the_sequence_number = cp_the_sequence_number
670: ORDER BY tex.creation_dt ASC;

Line 672: cp_tex_the_sequence_number IGS_RE_THESIS_EXAM.the_sequence_number%TYPE,

668: tex.ca_sequence_number = p_transfer_ca_sequence_number AND
669: tex.the_sequence_number = cp_the_sequence_number
670: ORDER BY tex.creation_dt ASC;
671: CURSOR c_teh (
672: cp_tex_the_sequence_number IGS_RE_THESIS_EXAM.the_sequence_number%TYPE,
673: cp_tex_creation_dt IGS_RE_THESIS_EXAM.creation_dt%TYPE) IS
674: SELECT teh.hist_start_dt,
675: teh.hist_end_dt,
676: teh.thesis_result_cd

Line 673: cp_tex_creation_dt IGS_RE_THESIS_EXAM.creation_dt%TYPE) IS

669: tex.the_sequence_number = cp_the_sequence_number
670: ORDER BY tex.creation_dt ASC;
671: CURSOR c_teh (
672: cp_tex_the_sequence_number IGS_RE_THESIS_EXAM.the_sequence_number%TYPE,
673: cp_tex_creation_dt IGS_RE_THESIS_EXAM.creation_dt%TYPE) IS
674: SELECT teh.hist_start_dt,
675: teh.hist_end_dt,
676: teh.thesis_result_cd
677: FROM IGS_RE_THS_EXAM_HIST teh

Line 685: cp_tex_the_sequence_number IGS_RE_THESIS_EXAM.the_sequence_number%TYPE,

681: teh.creation_dt = cp_tex_creation_dt AND
682: teh.thesis_result_cd IS NOT NULL
683: ORDER BY teh.hist_end_dt DESC;
684: CURSOR c_tpm(
685: cp_tex_the_sequence_number IGS_RE_THESIS_EXAM.the_sequence_number%TYPE,
686: cp_tex_creation_dt IGS_RE_THESIS_EXAM.creation_dt%TYPE) IS
687: SELECT tpm.the_sequence_number,
688: tpm.creation_dt,
689: tpm.person_id,

Line 686: cp_tex_creation_dt IGS_RE_THESIS_EXAM.creation_dt%TYPE) IS

682: teh.thesis_result_cd IS NOT NULL
683: ORDER BY teh.hist_end_dt DESC;
684: CURSOR c_tpm(
685: cp_tex_the_sequence_number IGS_RE_THESIS_EXAM.the_sequence_number%TYPE,
686: cp_tex_creation_dt IGS_RE_THESIS_EXAM.creation_dt%TYPE) IS
687: SELECT tpm.the_sequence_number,
688: tpm.creation_dt,
689: tpm.person_id,
690: tpm.panel_member_type,

Line 774: --Insert IGS_RE_THESIS exam(s)

770: x_comments => v_the1_rec.comments,
771: x_logical_delete_dt => null);
772: END;
773:
774: --Insert IGS_RE_THESIS exam(s)
775: FOR v_tex1_rec IN c_tex(
776: v_the1_rec.sequence_number) LOOP
777:
778:

Line 784: IGS_RE_THESIS_EXAM_PKG.INSERT_ROW(

780: DECLARE
781: l_rowid VARCHAR2(25);
782: BEGIN
783:
784: IGS_RE_THESIS_EXAM_PKG.INSERT_ROW(
785: x_rowid => l_rowid,
786: x_person_id => p_person_id,
787: x_ca_sequence_number => p_ca_sequence_number,
788: x_the_sequence_number => v_the_sequence_number,

Line 797: --Insert result code IGS_RE_THESIS exam history if required

793: x_tracking_id => v_tex1_rec.tracking_id,
794: x_thesis_result_cd => v_tex1_rec.thesis_result_cd);
795:
796: END;
797: --Insert result code IGS_RE_THESIS exam history if required
798: --Note: IGS_RE_THESIS result code date(see RESF3700) is derived from audit details
799: --And must be retained with the transfer.
800: IF v_tex1_rec.thesis_result_cd IS NOT NULL THEN
801: OPEN c_teh(

Line 905: END LOOP; --(IGS_RE_THESIS_EXAM)

901:
902: END IF; -- c_tpmh%NOTFOUND
903: END IF; -- if IGS_RE_THESIS result_cd IS NOT NULL
904: END LOOP; --(IGS_RE_THS_PNL_MBR)
905: END LOOP; --(IGS_RE_THESIS_EXAM)
906: EXCEPTION
907: WHEN OTHERS THEN
908: ROLLBACK TO sp_thesis;
909: p_message_name := 'IGS_RE_CANT_INSERT_THESIS_DET';