935: --
936: --
937:
938: FUNCTION finp_get_fps_end_dt(
939: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
940: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
941: p_s_relation_type IN VARCHAR2 ,
942: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
943: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
936: --
937:
938: FUNCTION finp_get_fps_end_dt(
939: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
940: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
941: p_s_relation_type IN VARCHAR2 ,
942: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
943: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
944: p_schedule_number IN NUMBER,
938: FUNCTION finp_get_fps_end_dt(
939: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
940: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
941: p_s_relation_type IN VARCHAR2 ,
942: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
943: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
944: p_schedule_number IN NUMBER,
945: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
946: p_dai_sequence_num IN NUMBER )
941: p_s_relation_type IN VARCHAR2 ,
942: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
943: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
944: p_schedule_number IN NUMBER,
945: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
946: p_dai_sequence_num IN NUMBER )
947: RETURN DATE AS
948:
949: BEGIN
952: --
953: --
954:
955: FUNCTION finp_get_fps_start_dt(
956: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
957: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
958: p_s_relation_type IN VARCHAR2 ,
959: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
960: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,
953: --
954:
955: FUNCTION finp_get_fps_start_dt(
956: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
957: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
958: p_s_relation_type IN VARCHAR2 ,
959: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
960: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,
961: p_schedule_number IN NUMBER,
955: FUNCTION finp_get_fps_start_dt(
956: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
957: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
958: p_s_relation_type IN VARCHAR2 ,
959: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
960: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,
961: p_schedule_number IN NUMBER,
962: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
963: p_dai_sequence_num IN NUMBER )
958: p_s_relation_type IN VARCHAR2 ,
959: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
960: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,
961: p_schedule_number IN NUMBER,
962: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
963: p_dai_sequence_num IN NUMBER )
964: RETURN DATE AS
965: /*----------------------------------------------------------------------------
966: || Created By :
1261: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1262: p_effective_dt IN DATE ,
1263: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
1264: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
1265: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
1266: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE,
1267: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
1268: p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%
1269: TYPE )
1262: p_effective_dt IN DATE ,
1263: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
1264: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
1265: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
1266: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE,
1267: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
1268: p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%
1269: TYPE )
1270:
1263: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
1264: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
1265: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
1266: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE,
1267: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
1268: p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%
1269: TYPE )
1270:
1271: RETURN varchar2 AS
1264: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
1265: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
1266: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE,
1267: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
1268: p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%
1269: TYPE )
1270:
1271: RETURN varchar2 AS
1272: