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.

APPS.IGS_FI_GEN_008 dependencies on IGS_FI_F_TYP_CA_INST

Line 61: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

57: --Procedure for checking whether a charge is declared or reversed
58: PROCEDURE chk_chg_adj( p_n_person_id IN hz_parties.party_id%TYPE,
59: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,
60: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
61: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
62: p_v_fee_cat IN igs_fi_fee_as_items.fee_cat%TYPE,
63: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
64: p_v_fee_type IN igs_fi_fee_type.fee_type%TYPE,
65: p_n_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,

Line 63: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

59: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,
60: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
61: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
62: p_v_fee_cat IN igs_fi_fee_as_items.fee_cat%TYPE,
63: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
64: p_v_fee_type IN igs_fi_fee_type.fee_type%TYPE,
65: p_n_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
66: p_v_transaction_type IN igs_fi_inv_int_all.transaction_type%TYPE,
67: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

Line 72: -- Procedure to obtain values of columns retention_level_code and complete_ret_flag from table igs_fi_f_typ_ca_inst

68: p_v_invoice_num OUT NOCOPY igs_fi_inv_int_all.invoice_number%TYPE,
69: p_b_chg_decl_rev OUT NOCOPY BOOLEAN
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,

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