APPS.IGS_PR_GEN_004 dependencies on IGS_GE_S_LOG

Line 313: v_key IGS_GE_s_log.KEY%TYPE;

309: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
310: v_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE;
311: v_application_type VARCHAR2(10);
312: v_log_creation_dt DATE DEFAULT NULL;
313: v_key IGS_GE_s_log.KEY%TYPE;
314: v_process_next_spo BOOLEAN;
315: v_other_encumbrance BOOLEAN;
316: v_exit_procedure BOOLEAN DEFAULT FALSE;
317: v_discont_reason_cd IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;

Line 795: p_log_creation_dt IGS_GE_s_log.creation_dt%TYPE,

791: suao.course_cd = cp_spo_course_cd AND
792: suao.uoo_id = cp_sua_uoo_id;
793:
794: PROCEDURE prgpl_ins_log_entry (
795: p_log_creation_dt IGS_GE_s_log.creation_dt%TYPE,
796: p_record_type VARCHAR2,
797: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
798: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
799: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,

Line 807: p_text IGS_GE_s_log_entry.text%TYPE

803: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,
804: p_duration IGS_PR_STDNT_PR_OU.duration%TYPE,
805: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
806: p_message_name VARCHAR2,
807: p_text IGS_GE_s_log_entry.text%TYPE
808: ) IS
809: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
810: --added as part of Prevent Dropping Core Units. Enh Bug# 3052432
811: BEGIN -- prgpl_ins_log_entry

Line 814: v_key IGS_GE_s_log.KEY%TYPE;

810: --added as part of Prevent Dropping Core Units. Enh Bug# 3052432
811: BEGIN -- prgpl_ins_log_entry
812: -- create a log entry
813: DECLARE
814: v_key IGS_GE_s_log.KEY%TYPE;
815: v_text IGS_GE_s_log_entry.text%TYPE DEFAULT NULL;
816: BEGIN
817: v_key :=
818: p_record_type || '|' ||

Line 815: v_text IGS_GE_s_log_entry.text%TYPE DEFAULT NULL;

811: BEGIN -- prgpl_ins_log_entry
812: -- create a log entry
813: DECLARE
814: v_key IGS_GE_s_log.KEY%TYPE;
815: v_text IGS_GE_s_log_entry.text%TYPE DEFAULT NULL;
816: BEGIN
817: v_key :=
818: p_record_type || '|' ||
819: TO_CHAR(p_person_id) || '|' ||

Line 2711: v_log_creation_dt IGS_GE_s_log.creation_dt%TYPE;

2707: v_approved_outcomes INTEGER DEFAULT 0;
2708: v_removed_outcomes INTEGER DEFAULT 0;
2709: v_last_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE := NULL;
2710: v_last_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE := NULL;
2711: v_log_creation_dt IGS_GE_s_log.creation_dt%TYPE;
2712: v_key IGS_GE_s_log.KEY%TYPE;
2713: v_message_name VARCHAR2(30);
2714: CURSOR c_ci IS
2715: SELECT ci.cal_type,

Line 2712: v_key IGS_GE_s_log.KEY%TYPE;

2708: v_removed_outcomes INTEGER DEFAULT 0;
2709: v_last_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE := NULL;
2710: v_last_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE := NULL;
2711: v_log_creation_dt IGS_GE_s_log.creation_dt%TYPE;
2712: v_key IGS_GE_s_log.KEY%TYPE;
2713: v_message_name VARCHAR2(30);
2714: CURSOR c_ci IS
2715: SELECT ci.cal_type,
2716: ci.sequence_number,

Line 3604: v_key IGS_GE_s_log_entry.KEY%TYPE;

3600: BEGIN -- prgpl_ins_log_entry
3601: -- create a log entry
3602: DECLARE
3603: cst_prg_appl CONSTANT VARCHAR2(10) := 'PRG-APPL';
3604: v_key IGS_GE_s_log_entry.KEY%TYPE;
3605: v_text IGS_GE_s_log_entry.text%TYPE DEFAULT NULL;
3606: BEGIN
3607: v_key :=
3608: p_record_type || '|' ||

Line 3605: v_text IGS_GE_s_log_entry.text%TYPE DEFAULT NULL;

3601: -- create a log entry
3602: DECLARE
3603: cst_prg_appl CONSTANT VARCHAR2(10) := 'PRG-APPL';
3604: v_key IGS_GE_s_log_entry.KEY%TYPE;
3605: v_text IGS_GE_s_log_entry.text%TYPE DEFAULT NULL;
3606: BEGIN
3607: v_key :=
3608: p_record_type || '|' ||
3609: TO_CHAR(p_person_id) || '|' ||