110: RETURN VARCHAR2 ;
111: PRAGMA RESTRICT_REFERENCES(FINP_GET_FEE_TRIGGER,WNDS,WNPS);
112: --
113: FUNCTION finp_get_fps_end_dt(
114: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
115: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
116: p_s_relation_type IN VARCHAR2 ,
117: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
118: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
111: PRAGMA RESTRICT_REFERENCES(FINP_GET_FEE_TRIGGER,WNDS,WNPS);
112: --
113: FUNCTION finp_get_fps_end_dt(
114: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
115: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
116: p_s_relation_type IN VARCHAR2 ,
117: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
118: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
119: p_schedule_number IN NUMBER,
113: FUNCTION finp_get_fps_end_dt(
114: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
115: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
116: p_s_relation_type IN VARCHAR2 ,
117: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
118: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
119: p_schedule_number IN NUMBER,
120: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
121: p_dai_sequence_num IN NUMBER )
116: p_s_relation_type IN VARCHAR2 ,
117: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
118: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
119: p_schedule_number IN NUMBER,
120: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
121: p_dai_sequence_num IN NUMBER )
122: RETURN DATE;
123: PRAGMA RESTRICT_REFERENCES(finp_get_fps_end_dt,WNDS);
124: --
122: RETURN DATE;
123: PRAGMA RESTRICT_REFERENCES(finp_get_fps_end_dt,WNDS);
124: --
125: FUNCTION finp_get_fps_start_dt(
126: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
127: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
128: p_s_relation_type IN VARCHAR2 ,
129: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
130: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,
123: PRAGMA RESTRICT_REFERENCES(finp_get_fps_end_dt,WNDS);
124: --
125: FUNCTION finp_get_fps_start_dt(
126: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
127: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
128: p_s_relation_type IN VARCHAR2 ,
129: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
130: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,
131: p_schedule_number IN NUMBER,
125: FUNCTION finp_get_fps_start_dt(
126: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
127: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
128: p_s_relation_type IN VARCHAR2 ,
129: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
130: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,
131: p_schedule_number IN NUMBER,
132: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
133: p_dai_sequence_num IN NUMBER )
128: p_s_relation_type IN VARCHAR2 ,
129: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
130: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,
131: p_schedule_number IN NUMBER,
132: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
133: p_dai_sequence_num IN NUMBER )
134: RETURN DATE;
135: PRAGMA RESTRICT_REFERENCES(finp_get_fps_start_dt,WNDS,WNPS);
136:
167: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
168: p_effective_dt IN DATE ,
169: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
170: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
171: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
172: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE ,
173: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
174: p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%TYPE )
175: RETURN varchar2;
168: p_effective_dt IN DATE ,
169: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
170: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
171: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
172: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE ,
173: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
174: p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%TYPE )
175: RETURN varchar2;
176: PRAGMA RESTRICT_REFERENCES(finp_get_hecs_pymnt_optn,WNDS,WNPS);
169: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
170: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
171: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
172: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE ,
173: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
174: p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%TYPE )
175: RETURN varchar2;
176: PRAGMA RESTRICT_REFERENCES(finp_get_hecs_pymnt_optn,WNDS,WNPS);
177:
170: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
171: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
172: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE ,
173: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
174: p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%TYPE )
175: RETURN varchar2;
176: PRAGMA RESTRICT_REFERENCES(finp_get_hecs_pymnt_optn,WNDS,WNPS);
177:
178: --