DBA Data[Home] [Help]

APPS.IGS_FI_GEN_001 dependencies on IGS_FI_F_TYP_CA_INST_ALL

Line 114: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,

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 ,

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

Line 117: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,

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 )

Line 120: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%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 )
122: RETURN DATE;
123: PRAGMA RESTRICT_REFERENCES(finp_get_fps_end_dt,WNDS);
124: --

Line 126: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,

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,

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

Line 129: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,

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 )

Line 132: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%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 )
134: RETURN DATE;
135: PRAGMA RESTRICT_REFERENCES(finp_get_fps_start_dt,WNDS,WNPS);
136:

Line 171: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,

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;

Line 172: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%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;
176: PRAGMA RESTRICT_REFERENCES(finp_get_hecs_pymnt_optn,WNDS,WNPS);

Line 173: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,

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:

Line 174: p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%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:
178: --