[Home] [Help]
11: ---------------------------------------------------------------------------------------------*/
12:
13: TYPE en_spi_rcond_rec_type IS RECORD
14: (
15: person_number IGS_EN_SPI_RCOND_INTS.person_number%TYPE,
16: program_cd IGS_EN_SPI_RCOND_INTS.program_cd%TYPE,
17: start_dt IGS_EN_SPI_RCOND_INTS.start_dt%TYPE,
18: return_condition IGS_EN_SPI_RCOND_INTS.return_condition%TYPE,
19: status_code IGS_EN_SPI_RCOND_INTS.status_code%TYPE,
12:
13: TYPE en_spi_rcond_rec_type IS RECORD
14: (
15: person_number IGS_EN_SPI_RCOND_INTS.person_number%TYPE,
16: program_cd IGS_EN_SPI_RCOND_INTS.program_cd%TYPE,
17: start_dt IGS_EN_SPI_RCOND_INTS.start_dt%TYPE,
18: return_condition IGS_EN_SPI_RCOND_INTS.return_condition%TYPE,
19: status_code IGS_EN_SPI_RCOND_INTS.status_code%TYPE,
20: approved_dt IGS_EN_SPI_RCOND_INTS.approved_dt%TYPE,
13: TYPE en_spi_rcond_rec_type IS RECORD
14: (
15: person_number IGS_EN_SPI_RCOND_INTS.person_number%TYPE,
16: program_cd IGS_EN_SPI_RCOND_INTS.program_cd%TYPE,
17: start_dt IGS_EN_SPI_RCOND_INTS.start_dt%TYPE,
18: return_condition IGS_EN_SPI_RCOND_INTS.return_condition%TYPE,
19: status_code IGS_EN_SPI_RCOND_INTS.status_code%TYPE,
20: approved_dt IGS_EN_SPI_RCOND_INTS.approved_dt%TYPE,
21: approver_number IGS_EN_SPI_RCOND_INTS.approver_number%TYPE
14: (
15: person_number IGS_EN_SPI_RCOND_INTS.person_number%TYPE,
16: program_cd IGS_EN_SPI_RCOND_INTS.program_cd%TYPE,
17: start_dt IGS_EN_SPI_RCOND_INTS.start_dt%TYPE,
18: return_condition IGS_EN_SPI_RCOND_INTS.return_condition%TYPE,
19: status_code IGS_EN_SPI_RCOND_INTS.status_code%TYPE,
20: approved_dt IGS_EN_SPI_RCOND_INTS.approved_dt%TYPE,
21: approver_number IGS_EN_SPI_RCOND_INTS.approver_number%TYPE
22: );
15: person_number IGS_EN_SPI_RCOND_INTS.person_number%TYPE,
16: program_cd IGS_EN_SPI_RCOND_INTS.program_cd%TYPE,
17: start_dt IGS_EN_SPI_RCOND_INTS.start_dt%TYPE,
18: return_condition IGS_EN_SPI_RCOND_INTS.return_condition%TYPE,
19: status_code IGS_EN_SPI_RCOND_INTS.status_code%TYPE,
20: approved_dt IGS_EN_SPI_RCOND_INTS.approved_dt%TYPE,
21: approver_number IGS_EN_SPI_RCOND_INTS.approver_number%TYPE
22: );
23:
16: program_cd IGS_EN_SPI_RCOND_INTS.program_cd%TYPE,
17: start_dt IGS_EN_SPI_RCOND_INTS.start_dt%TYPE,
18: return_condition IGS_EN_SPI_RCOND_INTS.return_condition%TYPE,
19: status_code IGS_EN_SPI_RCOND_INTS.status_code%TYPE,
20: approved_dt IGS_EN_SPI_RCOND_INTS.approved_dt%TYPE,
21: approver_number IGS_EN_SPI_RCOND_INTS.approver_number%TYPE
22: );
23:
24: PROCEDURE create_student_intm_rcond
17: start_dt IGS_EN_SPI_RCOND_INTS.start_dt%TYPE,
18: return_condition IGS_EN_SPI_RCOND_INTS.return_condition%TYPE,
19: status_code IGS_EN_SPI_RCOND_INTS.status_code%TYPE,
20: approved_dt IGS_EN_SPI_RCOND_INTS.approved_dt%TYPE,
21: approver_number IGS_EN_SPI_RCOND_INTS.approver_number%TYPE
22: );
23:
24: PROCEDURE create_student_intm_rcond
25: ( p_api_version IN NUMBER,