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_AD_GEN_011 dependencies on IGS_CO_S_PER_LT_PARM

Line 797: v_spl_sequence_number igs_co_s_per_lt_parm.spl_sequence_number%TYPE;

793: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
794: BEGIN
795: DECLARE
796: v_letter_reference_number igs_co_s_ltr.letter_reference_number%TYPE;
797: v_spl_sequence_number igs_co_s_per_lt_parm.spl_sequence_number%TYPE;
798: v_create_dt DATE;
799: v_issue_dt DATE;
800: v_comments VARCHAR2(2000);
801: v_message_name VARCHAR2(30);

Line 1602: -- and inserts a record into the IGS_CO_S_PER_LT_PARM table

1598: RETURN BOOLEAN IS
1599: gv_other_detail VARCHAR2(255);
1600: BEGIN -- admp_ins_phrase_splp
1601: -- This module calculates the value for an admissions phrase IGS_CO_LTR_PARAM
1602: -- and inserts a record into the IGS_CO_S_PER_LT_PARM table
1603: DECLARE
1604: v_stored BOOLEAN DEFAULT FALSE;
1605: v_value VARCHAR2(2000);
1606: v_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;

Line 1606: v_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;

1602: -- and inserts a record into the IGS_CO_S_PER_LT_PARM table
1603: DECLARE
1604: v_stored BOOLEAN DEFAULT FALSE;
1605: v_value VARCHAR2(2000);
1606: v_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;
1607:
1608: CURSOR c_aalp (
1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,
1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,

Line 1630: SELECT IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL

1626: SELECT ltp.phrase_text
1627: FROM IGS_CO_LTR_PHR ltp
1628: WHERE ltp.phrase_cd = cp_phrase_cd;
1629: CURSOR c_get_nxt_seq IS
1630: SELECT IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL
1631: FROM DUAL;
1632:
1633: lv_rowid VARCHAR2(25);
1634:

Line 1656: -- Get IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL

1652: END IF;
1653: CLOSE c_ltp;
1654: END IF;
1655: IF(v_value IS NOT NULL) THEN
1656: -- Get IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL
1657: OPEN c_get_nxt_seq;
1658: FETCH c_get_nxt_seq INTO v_sequence_number;
1659: CLOSE c_get_nxt_seq;
1660: IGS_CO_S_PER_LT_Parm_Pkg.Insert_Row (

Line 1660: IGS_CO_S_PER_LT_Parm_Pkg.Insert_Row (

1656: -- Get IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL
1657: OPEN c_get_nxt_seq;
1658: FETCH c_get_nxt_seq INTO v_sequence_number;
1659: CLOSE c_get_nxt_seq;
1660: IGS_CO_S_PER_LT_Parm_Pkg.Insert_Row (
1661: X_Mode => 'R',
1662: X_RowId => lv_rowid,
1663: X_Person_Id => p_person_id,
1664: X_Correspondence_Type => p_correspondence_type,