DBA Data[Home] [Help]

APPS.IGS_EN_REINSTATE_PKG dependencies on IGS_CA_INST

Line 60: l_acad_cal_type igs_ca_inst.cal_type%type;

56: l_enr_ci_seq NUMBER(20);
57: l_enr_cat VARCHAR2(20);
58: l_enr_comm VARCHAR2(2000);
59: l_enr_categories VARCHAR2(255);
60: l_acad_cal_type igs_ca_inst.cal_type%type;
61: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
62: l_acad_start_dt igs_ca_inst.start_dt%type;
63: l_acad_end_dt igs_ca_inst.end_dt%type;
64: l_alternate_code igs_ca_inst.alternate_code%type;

Line 61: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;

57: l_enr_cat VARCHAR2(20);
58: l_enr_comm VARCHAR2(2000);
59: l_enr_categories VARCHAR2(255);
60: l_acad_cal_type igs_ca_inst.cal_type%type;
61: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
62: l_acad_start_dt igs_ca_inst.start_dt%type;
63: l_acad_end_dt igs_ca_inst.end_dt%type;
64: l_alternate_code igs_ca_inst.alternate_code%type;
65: l_acad_message varchar2(100);

Line 62: l_acad_start_dt igs_ca_inst.start_dt%type;

58: l_enr_comm VARCHAR2(2000);
59: l_enr_categories VARCHAR2(255);
60: l_acad_cal_type igs_ca_inst.cal_type%type;
61: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
62: l_acad_start_dt igs_ca_inst.start_dt%type;
63: l_acad_end_dt igs_ca_inst.end_dt%type;
64: l_alternate_code igs_ca_inst.alternate_code%type;
65: l_acad_message varchar2(100);
66: l_message VARCHAR2(1200);

Line 63: l_acad_end_dt igs_ca_inst.end_dt%type;

59: l_enr_categories VARCHAR2(255);
60: l_acad_cal_type igs_ca_inst.cal_type%type;
61: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
62: l_acad_start_dt igs_ca_inst.start_dt%type;
63: l_acad_end_dt igs_ca_inst.end_dt%type;
64: l_alternate_code igs_ca_inst.alternate_code%type;
65: l_acad_message varchar2(100);
66: l_message VARCHAR2(1200);
67: l_return_status VARCHAR2(10);

Line 64: l_alternate_code igs_ca_inst.alternate_code%type;

60: l_acad_cal_type igs_ca_inst.cal_type%type;
61: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
62: l_acad_start_dt igs_ca_inst.start_dt%type;
63: l_acad_end_dt igs_ca_inst.end_dt%type;
64: l_alternate_code igs_ca_inst.alternate_code%type;
65: l_acad_message varchar2(100);
66: l_message VARCHAR2(1200);
67: l_return_status VARCHAR2(10);
68: l_sua_Status igs_En_Su_Attempt.unit_Attempt_Status%TYPE;