DBA Data[Home] [Help]

APPS.IGS_FI_GEN_005 dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

315: p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
316: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
317: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
318: p_effective_dt IN DATE ,
319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

Line 320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

316: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
317: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
318: p_effective_dt IN DATE ,
319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

Line 321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,

317: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
318: p_effective_dt IN DATE ,
319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
325: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,

Line 322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,

318: p_effective_dt IN DATE ,
319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
325: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
326: p_trigger_fired OUT NOCOPY VARCHAR2 )

Line 323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

319: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
325: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
326: p_trigger_fired OUT NOCOPY VARCHAR2 )
327: RETURN BOOLEAN AS

Line 324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

320: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
325: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
326: p_trigger_fired OUT NOCOPY VARCHAR2 )
327: RETURN BOOLEAN AS
328: /***************************************************************************/

Line 325: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,

321: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
322: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
323: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
324: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
325: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
326: p_trigger_fired OUT NOCOPY VARCHAR2 )
327: RETURN BOOLEAN AS
328: /***************************************************************************/
329: -- Change History:

Line 862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

858: p_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
859: p_fee_type IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
860: p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
861: p_effective_dt DATE ,
862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

Line 863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

859: p_fee_type IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
860: p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
861: p_effective_dt DATE ,
862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

Line 864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,

860: p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
861: p_effective_dt DATE ,
862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )

Line 865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,

861: p_effective_dt DATE ,
862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
869: RETURN CHAR AS

Line 866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

862: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
869: RETURN CHAR AS
870: BEGIN

Line 867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

863: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
869: RETURN CHAR AS
870: BEGIN
871: DECLARE

Line 868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )

864: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
865: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
866: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
867: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
869: RETURN CHAR AS
870: BEGIN
871: DECLARE
872: v_trigger_fired igs_lookups_view.lookup_code%TYPE;

Line 900: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

896: PROCEDURE finp_set_pymnt_schdl(
897: errbuf out NOCOPY varchar2,
898: retcode out NOCOPY number,
899: P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
900: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
901: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
902: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
903: p_grace_days IN NUMBER ,
904: p_effective_dt_c IN VARCHAR2 ,

Line 902: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,

898: retcode out NOCOPY number,
899: P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
900: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
901: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
902: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
903: p_grace_days IN NUMBER ,
904: p_effective_dt_c IN VARCHAR2 ,
905: p_notification_dt_c IN VARCHAR2 ,
906: p_include_man_entries IN VARCHAR2 ,