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_CA_INST

Line 596: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,

592:
593:
594: FUNCTION get_complete_withdr_ret_amt( p_n_person_id IN igs_en_su_attempt.person_id%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

Line 597: p_n_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

593:
594: FUNCTION get_complete_withdr_ret_amt( p_n_person_id IN igs_en_su_attempt.person_id%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: /**************************************************************************

Line 637: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,

633: **************************************************************************/
634:
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

Line 638: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,

634:
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,

Line 1067: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,

1063: END get_std_balance;
1064:
1065: PROCEDURE chk_spa_rec_exists(p_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1066: p_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1067: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1068: p_n_load_ci_seq IN igs_ca_inst.sequence_number%TYPE,
1069: p_v_fee_cat IN igs_fi_fee_cat.fee_cat%TYPE,
1070: p_v_status OUT NOCOPY VARCHAR2,
1071: p_v_message OUT NOCOPY VARCHAR2) AS

Line 1068: p_n_load_ci_seq IN igs_ca_inst.sequence_number%TYPE,

1064:
1065: PROCEDURE chk_spa_rec_exists(p_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1066: p_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1067: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1068: p_n_load_ci_seq IN igs_ca_inst.sequence_number%TYPE,
1069: p_v_fee_cat IN igs_fi_fee_cat.fee_cat%TYPE,
1070: p_v_status OUT NOCOPY VARCHAR2,
1071: p_v_message OUT NOCOPY VARCHAR2) AS
1072: /***********************************************************************************************

Line 1085: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,

1081:
1082: -- Cursor for checking if the Charge exists
1083: CURSOR cur_chg(cp_n_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1084: cp_v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1085: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1086: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE) IS
1087: SELECT 'x'
1088: FROM igs_fi_fee_as_all
1089: WHERE person_id = cp_n_person_id

Line 1086: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE) IS

1082: -- Cursor for checking if the Charge exists
1083: CURSOR cur_chg(cp_n_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1084: cp_v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1085: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1086: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE) IS
1087: SELECT 'x'
1088: FROM igs_fi_fee_as_all
1089: WHERE person_id = cp_n_person_id
1090: AND ((course_cd = cp_v_course_cd OR course_cd IS NULL))

Line 1110: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;

1106: AND TRUNC(SYSDATE) BETWEEN TRUNC(rt.start_dt) AND TRUNC(NVL(rt.end_dt,SYSDATE));
1107:
1108: l_b_bool BOOLEAN;
1109: l_v_chr VARCHAR2(1);
1110: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1111: l_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE;
1112:
1113:
1114: BEGIN

Line 1111: l_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE;

1107:
1108: l_b_bool BOOLEAN;
1109: l_v_chr VARCHAR2(1);
1110: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1111: l_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE;
1112:
1113:
1114: BEGIN
1115: p_v_status := 'N';