DBA Data[Home] [Help]

APPS.IGS_FI_GEN_005 dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 39: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

35: p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
36: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
37: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
38: p_effective_dt IN DATE ,
39: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
40: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
41: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
42: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
43: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

Line 40: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

36: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
37: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
38: p_effective_dt IN DATE ,
39: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
40: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
41: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
42: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
43: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
44: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

Line 41: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,

37: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
38: p_effective_dt IN DATE ,
39: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
40: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
41: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
42: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
43: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
44: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
45: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,

Line 42: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,

38: p_effective_dt IN DATE ,
39: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
40: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
41: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
42: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
43: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
44: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
45: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
46: p_trigger_fired OUT NOCOPY VARCHAR2 )

Line 43: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

39: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
40: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
41: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
42: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
43: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
44: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
45: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
46: p_trigger_fired OUT NOCOPY VARCHAR2 )
47: RETURN BOOLEAN;

Line 44: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

40: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
41: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
42: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
43: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
44: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
45: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
46: p_trigger_fired OUT NOCOPY VARCHAR2 )
47: RETURN BOOLEAN;
48: --pragma restrict_references(finp_val_fee_trigger,wnds);

Line 45: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,

41: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
42: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
43: p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
44: p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
45: p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
46: p_trigger_fired OUT NOCOPY VARCHAR2 )
47: RETURN BOOLEAN;
48: --pragma restrict_references(finp_val_fee_trigger,wnds);
49: --

Line 57: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

53: p_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
54: p_fee_type IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
55: p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
56: p_effective_dt DATE ,
57: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
58: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
59: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
60: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
61: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

Line 58: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

54: p_fee_type IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
55: p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
56: p_effective_dt DATE ,
57: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
58: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
59: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
60: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
61: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
62: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

Line 59: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,

55: p_s_fee_trigger_cat IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
56: p_effective_dt DATE ,
57: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
58: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
59: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
60: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
61: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
62: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
63: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )

Line 60: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,

56: p_effective_dt DATE ,
57: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
58: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
59: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
60: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
61: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
62: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
63: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
64: RETURN CHAR ;

Line 61: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

57: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
58: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
59: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
60: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
61: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
62: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
63: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
64: RETURN CHAR ;
65: --pragma restrict_references(fins_val_fee_trigger,wnds);

Line 62: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

58: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
59: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
60: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
61: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
62: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
63: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
64: RETURN CHAR ;
65: --pragma restrict_references(fins_val_fee_trigger,wnds);
66: --

Line 63: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )

59: p_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
60: p_cal_type IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
61: p_location_cd IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
62: p_attendance_mode IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
63: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
64: RETURN CHAR ;
65: --pragma restrict_references(fins_val_fee_trigger,wnds);
66: --
67: --

Line 72: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

68: PROCEDURE finp_set_pymnt_schdl(
69: errbuf out NOCOPY varchar2,
70: retcode out NOCOPY number,
71: P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
72: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
73: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
74: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
75: p_grace_days IN NUMBER ,
76: p_effective_dt_c IN VARCHAR2 ,

Line 74: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,

70: retcode out NOCOPY number,
71: P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
72: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
73: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
74: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
75: p_grace_days IN NUMBER ,
76: p_effective_dt_c IN VARCHAR2 ,
77: p_notification_dt_c IN VARCHAR2 ,
78: p_include_man_entries IN VARCHAR2 DEFAULT 'N',