DBA Data[Home] [Help]

APPS.IGS_FI_GEN_001 dependencies on IGS_FI_F_TYP_CA_INST_ALL

Line 939: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,

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 ,

Line 940: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%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,

Line 942: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,

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 )

Line 945: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%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 )
947: RETURN DATE AS
948:
949: BEGIN

Line 956: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,

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,

Line 957: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%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,

Line 959: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,

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 )

Line 962: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%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 )
964: RETURN DATE AS
965: /*----------------------------------------------------------------------------
966: || Created By :

Line 1265: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,

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 )

Line 1266: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%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:

Line 1267: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,

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

Line 1268: p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%

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: