eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_FI_GEN_008 dependencies on IGS_FI_F_TYP_CA_INST_ALL

Line 74: PROCEDURE get_retention_params( p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

70: );
71:
72: -- Procedure to obtain values of columns retention_level_code and complete_ret_flag from table igs_fi_f_typ_ca_inst
73: -- to be used in determing Retention Amount.
74: PROCEDURE get_retention_params( p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
75: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
76: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
77: p_v_ret_level OUT NOCOPY igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
78: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE);

Line 75: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,

71:
72: -- Procedure to obtain values of columns retention_level_code and complete_ret_flag from table igs_fi_f_typ_ca_inst
73: -- to be used in determing Retention Amount.
74: PROCEDURE get_retention_params( p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
75: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
76: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
77: p_v_ret_level OUT NOCOPY igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
78: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE);
79:

Line 76: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

72: -- Procedure to obtain values of columns retention_level_code and complete_ret_flag from table igs_fi_f_typ_ca_inst
73: -- to be used in determing Retention Amount.
74: PROCEDURE get_retention_params( p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
75: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
76: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
77: p_v_ret_level OUT NOCOPY igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
78: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE);
79:
80: -- Function to determine the Retention Amount when the Retention Level is set to Teaching Period

Line 77: p_v_ret_level OUT NOCOPY igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,

73: -- to be used in determing Retention Amount.
74: PROCEDURE get_retention_params( p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
75: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
76: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
77: p_v_ret_level OUT NOCOPY igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
78: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE);
79:
80: -- Function to determine the Retention Amount when the Retention Level is set to Teaching Period
81: FUNCTION get_teach_retention( p_v_fee_cal_type IN igs_fi_tp_ret_schd.fee_cal_type%TYPE,

Line 78: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE);

74: PROCEDURE get_retention_params( p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
75: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
76: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
77: p_v_ret_level OUT NOCOPY igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
78: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE);
79:
80: -- Function to determine the Retention Amount when the Retention Level is set to Teaching Period
81: FUNCTION get_teach_retention( p_v_fee_cal_type IN igs_fi_tp_ret_schd.fee_cal_type%TYPE,
82: p_n_fee_ci_sequence_number IN igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,

Line 103: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

99: p_v_course_cd IN igs_en_su_attempt.course_cd%TYPE,
100: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
101: p_n_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
102: p_n_diff_amount IN NUMBER,
103: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
104: p_v_nonzero_billable_cp_flag IN igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE ) RETURN NUMBER;
105:
106: -- Function to determine the Retention Amount for a Non-Standard Unit Section
107: FUNCTION get_ns_usec_retention(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

Line 104: p_v_nonzero_billable_cp_flag IN igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE ) RETURN NUMBER;

100: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
101: p_n_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
102: p_n_diff_amount IN NUMBER,
103: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
104: p_v_nonzero_billable_cp_flag IN igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE ) RETURN NUMBER;
105:
106: -- Function to determine the Retention Amount for a Non-Standard Unit Section
107: FUNCTION get_ns_usec_retention(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
108: p_v_fee_type IN igs_fi_fee_type.fee_type%TYPE,

Line 114: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

110: p_n_diff_amount IN NUMBER) RETURN NUMBER;
111:
112: -- Function to determine the Retention Amount for Special Fees
113: FUNCTION get_special_retention_amt(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
114: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
115: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
116: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
117: p_d_effective_date IN DATE,
118: p_n_diff_amount IN NUMBER) RETURN NUMBER;

Line 115: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,

111:
112: -- Function to determine the Retention Amount for Special Fees
113: FUNCTION get_special_retention_amt(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
114: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
115: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
116: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
117: p_d_effective_date IN DATE,
118: p_n_diff_amount IN NUMBER) RETURN NUMBER;
119:

Line 116: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

112: -- Function to determine the Retention Amount for Special Fees
113: FUNCTION get_special_retention_amt(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
114: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
115: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
116: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
117: p_d_effective_date IN DATE,
118: p_n_diff_amount IN NUMBER) RETURN NUMBER;
119:
120: -- function to return the latest standard balance of the student for the personid provided