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

Line 385: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE DEFAULT NULL;

381: IGS_GE_GEN_003.set_org_id(p_org_id);
382:
383: DECLARE
384: v_ret_value BOOLEAN;
385: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE DEFAULT NULL;
386: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE DEFAULT NULL;
387: cst_approved CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_granting_status%TYPE := 'APPROVED';
388: cst_credit CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_recognition_type%TYPE := 'CREDIT';
389: v_message_name VARCHAR2(30) DEFAULT NULL ;

Line 386: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE DEFAULT NULL;

382:
383: DECLARE
384: v_ret_value BOOLEAN;
385: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE DEFAULT NULL;
386: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE DEFAULT NULL;
387: cst_approved CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_granting_status%TYPE := 'APPROVED';
388: cst_credit CONSTANT IGS_AV_STND_UNIT.s_adv_stnd_recognition_type%TYPE := 'CREDIT';
389: v_message_name VARCHAR2(30) DEFAULT NULL ;
390: -- Counters

Line 618: v_key IGS_GE_S_LOG.key%TYPE;

614: v_total_exmptn_granted NUMBER(5);
615: v_total_exmptn_perc_grntd NUMBER(5);
616: v_granted_dt DATE;
617: v_check CHAR;
618: v_key IGS_GE_S_LOG.key%TYPE;
619: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
620: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
621: v_skip_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
622: v_skip_course_cd1 IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';

Line 619: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;

615: v_total_exmptn_perc_grntd NUMBER(5);
616: v_granted_dt DATE;
617: v_check CHAR;
618: v_key IGS_GE_S_LOG.key%TYPE;
619: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
620: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
621: v_skip_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
622: v_skip_course_cd1 IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
623: v_skip_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;

Line 620: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;

616: v_granted_dt DATE;
617: v_check CHAR;
618: v_key IGS_GE_S_LOG.key%TYPE;
619: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
620: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
621: v_skip_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
622: v_skip_course_cd1 IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';
623: v_skip_version_number IGS_AV_STND_UNIT.as_version_number%TYPE DEFAULT 0;
624: v_last_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE DEFAULT 'ISNULL';

Line 631: cp_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,

627: v_message_key VARCHAR2(255);
628: v_update_flag BOOLEAN DEFAULT TRUE;
629:
630: CURSOR c_sl (
631: cp_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
632: cp_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) IS
633: SELECT 'x'
634: FROM IGS_GE_S_LOG
635: WHERE s_log_type = cp_s_log_type AND

Line 632: cp_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) IS

628: v_update_flag BOOLEAN DEFAULT TRUE;
629:
630: CURSOR c_sl (
631: cp_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
632: cp_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) IS
633: SELECT 'x'
634: FROM IGS_GE_S_LOG
635: WHERE s_log_type = cp_s_log_type AND
636: creation_dt = cp_creation_dt;

Line 634: FROM IGS_GE_S_LOG

630: CURSOR c_sl (
631: cp_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
632: cp_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) IS
633: SELECT 'x'
634: FROM IGS_GE_S_LOG
635: WHERE s_log_type = cp_s_log_type AND
636: creation_dt = cp_creation_dt;
637:
638: CURSOR c_asu (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS