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_ST_GEN_004 dependencies on IGS_GE_S_LOG

Line 342: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;

338: v_unit_total_eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE;
339: v_unit_industrial_eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE;
340: v_logged_ind BOOLEAN;
341: v_s_log_type Varchar2(10);
342: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
343: v_upd_total_eftsu IGS_ST_GVT_STDNT_LBL.total_eftsu%TYPE;
344: v_upd_indus_eftsu IGS_ST_GVT_STDNT_LBL.industrial_eftsu%TYPE;
345: v_owner all_indexes.owner%TYPE;
346: v_command VARCHAR2(600);

Line 849: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE,

845: -- last course_cdretrieved
846: p_effective_dt DATE,
847: p_logged_ind IN OUT NOCOPY BOOLEAN,
848: p_s_log_type VARCHAR2,
849: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE,
850: p_birth_dt IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE,
851: p_sex IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.sex%TYPE,
852: p_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE,
853: p_govt_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE,

Line 3790: cst_s_log_type CONSTANT IGS_GE_S_LOG.s_log_type%TYPE := 'GOVT-SBMSN';

3786: -- can only call stored database procedures, not functions. If the called
3787: -- function returns false, this routine will log an entry in the system log
3788: -- and an error in the system error log.
3789: DECLARE
3790: cst_s_log_type CONSTANT IGS_GE_S_LOG.s_log_type%TYPE := 'GOVT-SBMSN';
3791: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
3792: v_log_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
3793: BEGIN
3794: v_creation_dt := SYSDATE;

Line 3791: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;

3787: -- function returns false, this routine will log an entry in the system log
3788: -- and an error in the system error log.
3789: DECLARE
3790: cst_s_log_type CONSTANT IGS_GE_S_LOG.s_log_type%TYPE := 'GOVT-SBMSN';
3791: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
3792: v_log_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
3793: BEGIN
3794: v_creation_dt := SYSDATE;
3795: IF (stap_ins_govt_snpsht(

Line 3792: v_log_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;

3788: -- and an error in the system error log.
3789: DECLARE
3790: cst_s_log_type CONSTANT IGS_GE_S_LOG.s_log_type%TYPE := 'GOVT-SBMSN';
3791: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
3792: v_log_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
3793: BEGIN
3794: v_creation_dt := SYSDATE;
3795: IF (stap_ins_govt_snpsht(
3796: p_submission_yr,