36: cal_end_dt IGS_PS_UNIT_OFR_OPT_V.cal_end_dt%TYPE,
37: location_cd IGS_PS_UNIT_OFR_OPT_V.location_cd%TYPE,
38: location_description IGS_PS_UNIT_OFR_OPT_V.location_description%TYPE,
39: unit_mode IGS_PS_UNIT_OFR_OPT_V.unit_mode%TYPE);
40: TYPE rec_StudentDetails IS RECORD ( person_id igs_pe_person.person_id%TYPE,
41: unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
42: person_number igs_pe_person.person_number%TYPE,
43: email_addr igs_pe_person.email_addr%TYPE,
44: full_name igs_pe_person.full_name%TYPE);
38: location_description IGS_PS_UNIT_OFR_OPT_V.location_description%TYPE,
39: unit_mode IGS_PS_UNIT_OFR_OPT_V.unit_mode%TYPE);
40: TYPE rec_StudentDetails IS RECORD ( person_id igs_pe_person.person_id%TYPE,
41: unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
42: person_number igs_pe_person.person_number%TYPE,
43: email_addr igs_pe_person.email_addr%TYPE,
44: full_name igs_pe_person.full_name%TYPE);
45: TYPE rec_InstructorDetails IS RECORD (person_number IGS_PE_PERSON.person_number%TYPE,
46: email_addr IGS_PE_PERSON.email_addr%TYPE,
39: unit_mode IGS_PS_UNIT_OFR_OPT_V.unit_mode%TYPE);
40: TYPE rec_StudentDetails IS RECORD ( person_id igs_pe_person.person_id%TYPE,
41: unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
42: person_number igs_pe_person.person_number%TYPE,
43: email_addr igs_pe_person.email_addr%TYPE,
44: full_name igs_pe_person.full_name%TYPE);
45: TYPE rec_InstructorDetails IS RECORD (person_number IGS_PE_PERSON.person_number%TYPE,
46: email_addr IGS_PE_PERSON.email_addr%TYPE,
47: full_name igs_pe_person.full_name%TYPE);
40: TYPE rec_StudentDetails IS RECORD ( person_id igs_pe_person.person_id%TYPE,
41: unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
42: person_number igs_pe_person.person_number%TYPE,
43: email_addr igs_pe_person.email_addr%TYPE,
44: full_name igs_pe_person.full_name%TYPE);
45: TYPE rec_InstructorDetails IS RECORD (person_number IGS_PE_PERSON.person_number%TYPE,
46: email_addr IGS_PE_PERSON.email_addr%TYPE,
47: full_name igs_pe_person.full_name%TYPE);
48: PROCEDURE wf_get_shadow_values (p_uoo_id IN NUMBER,
41: unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
42: person_number igs_pe_person.person_number%TYPE,
43: email_addr igs_pe_person.email_addr%TYPE,
44: full_name igs_pe_person.full_name%TYPE);
45: TYPE rec_InstructorDetails IS RECORD (person_number IGS_PE_PERSON.person_number%TYPE,
46: email_addr IGS_PE_PERSON.email_addr%TYPE,
47: full_name igs_pe_person.full_name%TYPE);
48: PROCEDURE wf_get_shadow_values (p_uoo_id IN NUMBER,
49: p_unit_section_occurrence_id IN NUMBER,
42: person_number igs_pe_person.person_number%TYPE,
43: email_addr igs_pe_person.email_addr%TYPE,
44: full_name igs_pe_person.full_name%TYPE);
45: TYPE rec_InstructorDetails IS RECORD (person_number IGS_PE_PERSON.person_number%TYPE,
46: email_addr IGS_PE_PERSON.email_addr%TYPE,
47: full_name igs_pe_person.full_name%TYPE);
48: PROCEDURE wf_get_shadow_values (p_uoo_id IN NUMBER,
49: p_unit_section_occurrence_id IN NUMBER,
50: p_type IN VARCHAR2,
43: email_addr igs_pe_person.email_addr%TYPE,
44: full_name igs_pe_person.full_name%TYPE);
45: TYPE rec_InstructorDetails IS RECORD (person_number IGS_PE_PERSON.person_number%TYPE,
46: email_addr IGS_PE_PERSON.email_addr%TYPE,
47: full_name igs_pe_person.full_name%TYPE);
48: PROCEDURE wf_get_shadow_values (p_uoo_id IN NUMBER,
49: p_unit_section_occurrence_id IN NUMBER,
50: p_type IN VARCHAR2,
51: p_old_values IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.OCCUROLD,