eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_INS_CA_TRNSFR dependencies on IGS_RE_THESIS

Line 627: v_the_sequence_number IGS_RE_THESIS.sequence_number%TYPE;

623: --are to be copied to the new Candidature (p_person_id/p_ca_sequence_number).
624: DECLARE
625: v_return_val BOOLEAN;
626: v_the_exists VARCHAR2(1);
627: v_the_sequence_number IGS_RE_THESIS.sequence_number%TYPE;
628: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(20) := 'ENRP_INS_CA_TRNSFR';
629: CURSOR c_next_val IS
630: SELECT IGS_RE_THESIS_SEQ_NUM_S.nextval
631: FROM dual;

Line 630: SELECT IGS_RE_THESIS_SEQ_NUM_S.nextval

626: v_the_exists VARCHAR2(1);
627: v_the_sequence_number IGS_RE_THESIS.sequence_number%TYPE;
628: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(20) := 'ENRP_INS_CA_TRNSFR';
629: CURSOR c_next_val IS
630: SELECT IGS_RE_THESIS_SEQ_NUM_S.nextval
631: FROM dual;
632: CURSOR c_the IS
633: SELECT 'x'
634: FROM IGS_RE_THESIS thes

Line 634: FROM IGS_RE_THESIS thes

630: SELECT IGS_RE_THESIS_SEQ_NUM_S.nextval
631: FROM dual;
632: CURSOR c_the IS
633: SELECT 'x'
634: FROM IGS_RE_THESIS thes
635: WHERE thes.person_id = p_person_id AND
636: thes.ca_sequence_number = p_ca_sequence_number;
637: CURSOR c_the2 IS
638: SELECT thes.sequence_number,

Line 653: FROM IGS_RE_THESIS thes

649: thes.embargo_details,
650: thes.thesis_topic,
651: thes.citation,
652: thes.comments
653: FROM IGS_RE_THESIS thes
654: WHERE thes.person_id = p_person_id AND
655: thes.ca_sequence_number = p_transfer_ca_sequence_number AND
656: thes.logical_delete_dt IS NULL;
657: CURSOR c_tex(

Line 658: cp_the_sequence_number IGS_RE_THESIS.sequence_number%TYPE) IS

654: WHERE thes.person_id = p_person_id AND
655: thes.ca_sequence_number = p_transfer_ca_sequence_number AND
656: thes.logical_delete_dt IS NULL;
657: CURSOR c_tex(
658: cp_the_sequence_number IGS_RE_THESIS.sequence_number%TYPE) IS
659: SELECT tex.the_sequence_number,
660: tex.creation_dt,
661: tex.submission_dt,
662: tex.thesis_exam_type,

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 736: p_message_name := 'IGS_RE_THESIS_ALREADY_EXISTS';

732: FETCH c_the INTO v_the_exists;
733: IF c_the%FOUND THEN
734: CLOSE c_the;
735: --THESIS details already exist, cannot transfer
736: p_message_name := 'IGS_RE_THESIS_ALREADY_EXISTS';
737: RETURN FALSE;
738: END IF;
739: CLOSE c_the;
740: SAVEPOINT sp_thesis;

Line 741: --Insert IGS_RE_THESIS

737: RETURN FALSE;
738: END IF;
739: CLOSE c_the;
740: SAVEPOINT sp_thesis;
741: --Insert IGS_RE_THESIS
742: FOR v_the1_rec IN c_the2 LOOP
743: BEGIN
744: OPEN c_next_val;
745: FETCH c_next_val INTO v_the_sequence_number;

Line 751: IGS_RE_THESIS_PKG.INSERT_ROW(

747: DECLARE
748: l_rowid VARCHAR2(25);
749: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
750: BEGIN
751: IGS_RE_THESIS_PKG.INSERT_ROW(
752: x_rowid => l_rowid,
753: X_org_id => l_org_id,
754: x_person_id =>p_person_id,
755: x_ca_sequence_number => p_ca_sequence_number,

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 798: --Note: IGS_RE_THESIS result code date(see RESF3700) is derived from audit details

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(
802: v_tex1_rec.the_sequence_number,

Line 836: --Insert IGS_RE_THESIS panel member(s)

832:
833:
834: END IF; -- c_teh1%NOTFOUND
835: END IF; -- if result_cd is not null
836: --Insert IGS_RE_THESIS panel member(s)
837: FOR v_tpm1_rec IN c_tpm(
838: v_tex1_rec.the_sequence_number,
839: v_tex1_rec.creation_dt) LOOP
840: DECLARE

Line 862: --Insert result code IGS_RE_THESIS panel member history if required

858: x_recommendation_summary => v_tpm1_rec.recommendation_summary);
859: END;
860:
861:
862: --Insert result code IGS_RE_THESIS panel member history if required
863: --Note: IGS_RE_THESIS result code date ( see RESF3700) is derived from audit details
864: --And must be retained with the transfer.
865: IF v_tpm1_rec.thesis_result_cd IS NOT NULL THEN
866: OPEN c_tpmh(

Line 863: --Note: IGS_RE_THESIS result code date ( see RESF3700) is derived from audit details

859: END;
860:
861:
862: --Insert result code IGS_RE_THESIS panel member history if required
863: --Note: IGS_RE_THESIS result code date ( see RESF3700) is derived from audit details
864: --And must be retained with the transfer.
865: IF v_tpm1_rec.thesis_result_cd IS NOT NULL THEN
866: OPEN c_tpmh(
867: v_tpm1_rec.the_sequence_number,

Line 903: END IF; -- if IGS_RE_THESIS result_cd IS NOT NULL

899: x_recommendation_summary => NULL);
900: END;
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

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';

Line 913: END LOOP; --(IGS_RE_THESIS)

909: p_message_name := 'IGS_RE_CANT_INSERT_THESIS_DET';
910: v_return_val := FALSE;
911: EXIT;
912: END;
913: END LOOP; --(IGS_RE_THESIS)
914: RETURN v_return_val;
915: EXCEPTION
916: WHEN OTHERS THEN
917: IF c_the%ISOPEN THEN