APPS.IGS_EN_GEN_014 dependencies on IGS_CA_INST

Line 22: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,

18: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
19: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
20: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
21: p_uoo_id IN NUMBER ,
22: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
23: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
24: p_override_enrolled_cp IN NUMBER ,
25: p_override_eftsu IN NUMBER ,
26: p_truncate_ind IN VARCHAR2 ,

Line 23: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,

19: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
20: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
21: p_uoo_id IN NUMBER ,
22: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
23: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
24: p_override_enrolled_cp IN NUMBER ,
25: p_override_eftsu IN NUMBER ,
26: p_truncate_ind IN VARCHAR2 ,
27: p_sca_cp_total IN NUMBER ,

Line 42: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,

38: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
39: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
40: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
41: p_uoo_id IN NUMBER ,
42: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
43: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
44: p_override_enrolled_cp IN NUMBER ,
45: p_override_eftsu IN NUMBER ,
46: p_truncate_ind IN VARCHAR2 ,

Line 43: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,

39: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
40: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
41: p_uoo_id IN NUMBER ,
42: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
43: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
44: p_override_enrolled_cp IN NUMBER ,
45: p_override_eftsu IN NUMBER ,
46: p_truncate_ind IN VARCHAR2 ,
47: p_sca_cp_total IN NUMBER ,

Line 113: p_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

109: RETURN VARCHAR2;
110: PRAGMA RESTRICT_REFERENCES(Enrs_Get_Within_Ci, WNDS, WNPS);
111:
112: TYPE load_cal_rec_type IS RECORD (
113: p_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
114: p_load_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
115: p_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE,
116: p_load_ci_start_dt IGS_CA_INST.START_DT%TYPE,
117: p_load_ci_end_dt IGS_CA_INST.END_DT%TYPE,

Line 114: p_load_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE,

110: PRAGMA RESTRICT_REFERENCES(Enrs_Get_Within_Ci, WNDS, WNPS);
111:
112: TYPE load_cal_rec_type IS RECORD (
113: p_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
114: p_load_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
115: p_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE,
116: p_load_ci_start_dt IGS_CA_INST.START_DT%TYPE,
117: p_load_ci_end_dt IGS_CA_INST.END_DT%TYPE,
118: p_load_cal_desc IGS_CA_INST.DESCRIPTION%TYPE

Line 115: p_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE,

111:
112: TYPE load_cal_rec_type IS RECORD (
113: p_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
114: p_load_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
115: p_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE,
116: p_load_ci_start_dt IGS_CA_INST.START_DT%TYPE,
117: p_load_ci_end_dt IGS_CA_INST.END_DT%TYPE,
118: p_load_cal_desc IGS_CA_INST.DESCRIPTION%TYPE
119: );

Line 116: p_load_ci_start_dt IGS_CA_INST.START_DT%TYPE,

112: TYPE load_cal_rec_type IS RECORD (
113: p_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
114: p_load_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
115: p_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE,
116: p_load_ci_start_dt IGS_CA_INST.START_DT%TYPE,
117: p_load_ci_end_dt IGS_CA_INST.END_DT%TYPE,
118: p_load_cal_desc IGS_CA_INST.DESCRIPTION%TYPE
119: );
120:

Line 117: p_load_ci_end_dt IGS_CA_INST.END_DT%TYPE,

113: p_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
114: p_load_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
115: p_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE,
116: p_load_ci_start_dt IGS_CA_INST.START_DT%TYPE,
117: p_load_ci_end_dt IGS_CA_INST.END_DT%TYPE,
118: p_load_cal_desc IGS_CA_INST.DESCRIPTION%TYPE
119: );
120:
121: TYPE load_cal_table_type IS TABLE OF load_cal_rec_type

Line 118: p_load_cal_desc IGS_CA_INST.DESCRIPTION%TYPE

114: p_load_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
115: p_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE,
116: p_load_ci_start_dt IGS_CA_INST.START_DT%TYPE,
117: p_load_ci_end_dt IGS_CA_INST.END_DT%TYPE,
118: p_load_cal_desc IGS_CA_INST.DESCRIPTION%TYPE
119: );
120:
121: TYPE load_cal_table_type IS TABLE OF load_cal_rec_type
122: INDEX BY BINARY_INTEGER;