APPS.IGS_AD_INS_ADMPERD dependencies on IGS_GE_S_LOG

Line 50: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;

46: cst_admission CONSTANT VARCHAR2(9) := 'ADMISSION';
47: cst_error CONSTANT VARCHAR2(1) := 'E';
48: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
49: v_message_name VARCHAR2(30);
50: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
51: v_return_type VARCHAR2(1);
52: v_s_log_type VARCHAR2(8);
53: CURSOR c_ci (
54: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,

Line 268: v_key IGS_GE_S_LOG.key%TYPE;

264: p_message_name VARCHAR2)
265: IS
266: BEGIN -- admpl_ins_insert_log
267: DECLARE
268: v_key IGS_GE_S_LOG.key%TYPE;
269: v_adm_calendar VARCHAR2(35);
270: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
271: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
272:

Line 270: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;

266: BEGIN -- admpl_ins_insert_log
267: DECLARE
268: v_key IGS_GE_S_LOG.key%TYPE;
269: v_adm_calendar VARCHAR2(35);
270: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
271: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
272:
273: CURSOR c_start_end_dt IS
274: SELECT start_dt,

Line 271: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;

267: DECLARE
268: v_key IGS_GE_S_LOG.key%TYPE;
269: v_adm_calendar VARCHAR2(35);
270: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
271: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
272:
273: CURSOR c_start_end_dt IS
274: SELECT start_dt,
275: end_dt

Line 529: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;

525: cst_error CONSTANT VARCHAR2(1) := 'E';
526: cst_warn CONSTANT VARCHAR2(1) := 'W';
527: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;
528: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
529: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
530: v_message_name VARCHAR2(30);
531: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
532: v_adm_calendar VARCHAR2(50);
533: v_apac1_rec_exists BOOLEAN;

Line 531: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;

527: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;
528: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
529: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
530: v_message_name VARCHAR2(30);
531: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
532: v_adm_calendar VARCHAR2(50);
533: v_apac1_rec_exists BOOLEAN;
534: v_acat_not_ins BOOLEAN;
535: v_acat_det_not_ins BOOLEAN;