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_RE_THE_LGCY_PUB dependencies on IGS_RE_THESIS_ALL

Line 466: l_the_seq_num igs_re_thesis_all.sequence_number%TYPE;

462:
463: CURSOR c_the_seq_num IS
464: SELECT IGS_RE_THESIS_SEQ_NUM_S.NEXTVAL
465: FROM DUAL;
466: l_the_seq_num igs_re_thesis_all.sequence_number%TYPE;
467:
468: l_api_name CONSTANT VARCHAR2(30) := 'Thesis Details';
469: l_api_version CONSTANT NUMBER := 1.0;
470: l_the_exam_status VARCHAR2(15) := 'VALID';

Line 474: l_last_update_date igs_re_thesis_all.creation_date%TYPE;

470: l_the_exam_status VARCHAR2(15) := 'VALID';
471: l_person_id igs_re_thesis.person_id%TYPE := NULL;
472: l_ca_sequence_number igs_re_candidature_all.sequence_number%TYPE;
473: l_creation_dt igs_re_thesis_exam.creation_dt%TYPE := SYSDATE;
474: l_last_update_date igs_re_thesis_all.creation_date%TYPE;
475: l_last_updated_by igs_re_thesis_all.last_updated_by%TYPE;
476: l_last_update_login igs_re_thesis_all.last_update_login%TYPE;
477:
478: BEGIN

Line 475: l_last_updated_by igs_re_thesis_all.last_updated_by%TYPE;

471: l_person_id igs_re_thesis.person_id%TYPE := NULL;
472: l_ca_sequence_number igs_re_candidature_all.sequence_number%TYPE;
473: l_creation_dt igs_re_thesis_exam.creation_dt%TYPE := SYSDATE;
474: l_last_update_date igs_re_thesis_all.creation_date%TYPE;
475: l_last_updated_by igs_re_thesis_all.last_updated_by%TYPE;
476: l_last_update_login igs_re_thesis_all.last_update_login%TYPE;
477:
478: BEGIN
479: -- Standard Start of API savepoint

Line 476: l_last_update_login igs_re_thesis_all.last_update_login%TYPE;

472: l_ca_sequence_number igs_re_candidature_all.sequence_number%TYPE;
473: l_creation_dt igs_re_thesis_exam.creation_dt%TYPE := SYSDATE;
474: l_last_update_date igs_re_thesis_all.creation_date%TYPE;
475: l_last_updated_by igs_re_thesis_all.last_updated_by%TYPE;
476: l_last_update_login igs_re_thesis_all.last_update_login%TYPE;
477:
478: BEGIN
479: -- Standard Start of API savepoint
480: SAVEPOINT THEDET_PUB;

Line 564: INSERT INTO igs_re_thesis_all (

560: CLOSE c_the_seq_num;
561:
562: BEGIN
563: --insert data into Thesis Details table
564: INSERT INTO igs_re_thesis_all (
565: PERSON_ID,
566: CA_SEQUENCE_NUMBER,
567: SEQUENCE_NUMBER,
568: TITLE,