DBA Data[Home] [Help]

APPS.IGS_FI_GEN_001 dependencies on IGS_EN_STDNT_PS_ATT

Line 533: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

529: p_fee_cal_type IN IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE ,
530: p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
531: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
532: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
533: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
534: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
535: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
536: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
537: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

Line 534: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

530: p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
531: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
532: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
533: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
534: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
535: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
536: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
537: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
538: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

Line 535: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,

531: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
532: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
533: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
534: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
535: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
536: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
537: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
538: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
539: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )

Line 536: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,

532: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
533: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
534: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
535: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
536: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
537: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
538: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
539: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
540: RETURN VARCHAR2 AS

Line 537: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

533: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
534: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
535: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
536: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
537: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
538: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
539: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
540: RETURN VARCHAR2 AS
541:

Line 538: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

534: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
535: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
536: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
537: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
538: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
539: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
540: RETURN VARCHAR2 AS
541:
542: BEGIN

Line 539: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )

535: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
536: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
537: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
538: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
539: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
540: RETURN VARCHAR2 AS
541:
542: BEGIN
543: DECLARE

Line 1260: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

1256: RAISE;
1257: END finp_get_hecs_fee;
1258: --
1259: FUNCTION finp_get_hecs_pymnt_optn(
1260: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%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 ,

Line 1261: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

1257: END finp_get_hecs_fee;
1258: --
1259: FUNCTION finp_get_hecs_pymnt_optn(
1260: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%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 ,

Line 1278: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1274: DECLARE
1275: -- cursor to get student IGS_PS_COURSE HECS payment option details
1276: CURSOR c_scho(
1277: cp_effective_dt DATE,
1278: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1279: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1280: SELECT HECS_PAYMENT_OPTION
1281: FROM IGS_EN_STDNTPSHECSOP
1282: WHERE person_id = cp_person_id AND

Line 1279: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

1275: -- cursor to get student IGS_PS_COURSE HECS payment option details
1276: CURSOR c_scho(
1277: cp_effective_dt DATE,
1278: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1279: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1280: SELECT HECS_PAYMENT_OPTION
1281: FROM IGS_EN_STDNTPSHECSOP
1282: WHERE person_id = cp_person_id AND
1283: course_cd = cp_course_cd AND