DBA Data[Home] [Help]

APPS.IGS_EN_SPI_RCOND_LGCY_PUB dependencies on IGS_EN_SPI_RCOND_INTS

Line 15: person_number IGS_EN_SPI_RCOND_INTS.person_number%TYPE,

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,

Line 16: program_cd IGS_EN_SPI_RCOND_INTS.program_cd%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,

Line 17: start_dt IGS_EN_SPI_RCOND_INTS.start_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

Line 18: return_condition IGS_EN_SPI_RCOND_INTS.return_condition%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: );

Line 19: status_code IGS_EN_SPI_RCOND_INTS.status_code%TYPE,

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:

Line 20: approved_dt IGS_EN_SPI_RCOND_INTS.approved_dt%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:
24: PROCEDURE create_student_intm_rcond

Line 21: approver_number IGS_EN_SPI_RCOND_INTS.approver_number%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
25: ( p_api_version IN NUMBER,