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_ALL

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

337:
338: END chk_chg_adj;
339:
340:
341: PROCEDURE get_retention_params( p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
342: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
343: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
344: p_v_ret_level OUT NOCOPY igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
345: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE) AS

Line 342: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,

338: END chk_chg_adj;
339:
340:
341: PROCEDURE get_retention_params( p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
342: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
343: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
344: p_v_ret_level OUT NOCOPY igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
345: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE) AS
346: /**************************************************************************

Line 343: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

339:
340:
341: PROCEDURE get_retention_params( p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
342: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
343: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
344: p_v_ret_level OUT NOCOPY igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
345: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE) AS
346: /**************************************************************************
347: Created By : Priya Athipatla

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

340:
341: PROCEDURE get_retention_params( p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
342: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
343: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
344: p_v_ret_level OUT NOCOPY igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
345: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE) AS
346: /**************************************************************************
347: Created By : Priya Athipatla
348: Date Created By: 03-Sep-2004

Line 345: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE) AS

341: PROCEDURE get_retention_params( p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
342: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
343: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
344: p_v_ret_level OUT NOCOPY igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
345: p_v_complete_withdr_ret OUT NOCOPY igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE) AS
346: /**************************************************************************
347: Created By : Priya Athipatla
348: Date Created By: 03-Sep-2004
349: Purpose : Procedure to obtain values of columns retention_level_code

Line 358: CURSOR cur_get_ret_params(cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

354: Change History
355: Who When What
356: **************************************************************************/
357:
358: CURSOR cur_get_ret_params(cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
359: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
360: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
361: SELECT retention_level_code,
362: NVL(complete_ret_flag,'N')

Line 359: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

355: Who When What
356: **************************************************************************/
357:
358: CURSOR cur_get_ret_params(cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
359: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
360: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
361: SELECT retention_level_code,
362: NVL(complete_ret_flag,'N')
363: FROM igs_fi_f_typ_ca_inst

Line 360: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS

356: **************************************************************************/
357:
358: CURSOR cur_get_ret_params(cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
359: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
360: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
361: SELECT retention_level_code,
362: NVL(complete_ret_flag,'N')
363: FROM igs_fi_f_typ_ca_inst
364: WHERE fee_type = cp_v_fee_type

Line 599: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

595: p_v_course_cd IN igs_en_su_attempt.course_cd%TYPE,
596: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
597: p_n_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
598: p_n_diff_amount IN NUMBER,
599: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
600: p_v_nonzero_billable_cp_flag IN igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE ) RETURN NUMBER IS
601: /**************************************************************************
602: Created By : Priya Athipatla
603: Date Created By: 03-Sep-2004

Line 600: p_v_nonzero_billable_cp_flag IN igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE ) RETURN NUMBER IS

596: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
597: p_n_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
598: p_n_diff_amount IN NUMBER,
599: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
600: p_v_nonzero_billable_cp_flag IN igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE ) RETURN NUMBER IS
601: /**************************************************************************
602: Created By : Priya Athipatla
603: Date Created By: 03-Sep-2004
604: Purpose : Function to determine the Retention Amount when the

Line 639: cp_v_nz_billable_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE

635: CURSOR cur_unit_attmpt(cp_n_person_id igs_en_su_attempt.person_id%TYPE,
636: cp_v_course_cd igs_en_su_attempt.course_cd%TYPE,
637: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
638: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
639: cp_v_nz_billable_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE
640: ) IS
641: SELECT sua.*, usec.non_std_usec_ind
642: FROM igs_en_su_attempt sua,
643: igs_ps_unit_ofr_opt usec

Line 976: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

972: END get_ns_usec_retention;
973:
974:
975: FUNCTION get_special_retention_amt(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
976: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
977: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
978: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
979: p_d_effective_date IN DATE,
980: p_n_diff_amount IN NUMBER) RETURN NUMBER IS

Line 977: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,

973:
974:
975: FUNCTION get_special_retention_amt(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
976: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
977: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
978: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
979: p_d_effective_date IN DATE,
980: p_n_diff_amount IN NUMBER) RETURN NUMBER IS
981: /**************************************************************************

Line 978: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

974:
975: FUNCTION get_special_retention_amt(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
976: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
977: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
978: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
979: p_d_effective_date IN DATE,
980: p_n_diff_amount IN NUMBER) RETURN NUMBER IS
981: /**************************************************************************
982: Created By : Priya Athipatla