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_WAV_UTILS_002 dependencies on IGS_FI_F_TYP_CA_INST

Line 39: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

35:
36: END log_to_fnd;
37:
38: PROCEDURE call_charges_api( p_n_person_id IN hz_parties.party_id%TYPE,
39: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
40: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
41: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
42: p_v_adj_fee_type IN igs_fi_fee_type.fee_type%TYPE,
43: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,

Line 40: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

36: END log_to_fnd;
37:
38: PROCEDURE call_charges_api( p_n_person_id IN hz_parties.party_id%TYPE,
39: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
40: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
41: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
42: p_v_adj_fee_type IN igs_fi_fee_type.fee_type%TYPE,
43: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
44: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,

Line 212: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

208: END IF;
209: END call_charges_api;
210:
211: PROCEDURE call_credits_api(p_n_person_id IN hz_parties.party_id%TYPE,
212: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
213: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
214: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
215: p_n_credit_type_id IN igs_fi_credits.credit_id%TYPE,
216: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,

Line 213: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

209: END call_charges_api;
210:
211: PROCEDURE call_credits_api(p_n_person_id IN hz_parties.party_id%TYPE,
212: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
213: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
214: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
215: p_n_credit_type_id IN igs_fi_credits.credit_id%TYPE,
216: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
217: p_n_waiver_amt IN NUMBER,

Line 835: p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,

831:
832: END get_waiver_reversal_amount;
833:
834: FUNCTION check_stdnt_wav_assignment(p_n_person_id IN hz_parties.party_id%TYPE,
835: p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
836: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
837: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN IS
838: /******************************************************************
839: Created By : Umesh Udayaprakash

Line 836: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

832: END get_waiver_reversal_amount;
833:
834: FUNCTION check_stdnt_wav_assignment(p_n_person_id IN hz_parties.party_id%TYPE,
835: p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
836: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
837: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN IS
838: /******************************************************************
839: Created By : Umesh Udayaprakash
840: Date Created By : 7/4/2005

Line 837: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN IS

833:
834: FUNCTION check_stdnt_wav_assignment(p_n_person_id IN hz_parties.party_id%TYPE,
835: p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
836: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
837: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN IS
838: /******************************************************************
839: Created By : Umesh Udayaprakash
840: Date Created By : 7/4/2005
841: Purpose : Invokes Charges API for creating a charge

Line 848: CURSOR cur_waiver_pgm_rec_exists(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,

844: Change History
845: Who When What
846: ******************************************************************/
847: --Cursor to Check whether a waiver Record Exists
848: CURSOR cur_waiver_pgm_rec_exists(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
849: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
850: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
851: SELECT fwp.fee_cal_type,
852: fwp.fee_ci_sequence_number,

Line 849: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

845: Who When What
846: ******************************************************************/
847: --Cursor to Check whether a waiver Record Exists
848: CURSOR cur_waiver_pgm_rec_exists(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
849: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
850: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
851: SELECT fwp.fee_cal_type,
852: fwp.fee_ci_sequence_number,
853: fwp.waiver_name,

Line 850: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS

846: ******************************************************************/
847: --Cursor to Check whether a waiver Record Exists
848: CURSOR cur_waiver_pgm_rec_exists(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
849: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
850: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
851: SELECT fwp.fee_cal_type,
852: fwp.fee_ci_sequence_number,
853: fwp.waiver_name,
854: fwp.waiver_method_code

Line 863: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

859: AND fwp.waiver_method_code = 'COMP_RULE';
860: --Cursor to Check whether student Assignment exists for waiver Record
861: CURSOR cur_wav_stud_assg_rec_exists(cp_n_person_id hz_parties.party_id%TYPE,
862: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE,
863: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
864: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
865: SELECT fwsp.waiver_name,
866: fwsp.person_id,
867: fwsp.assignment_status_code

Line 864: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS

860: --Cursor to Check whether student Assignment exists for waiver Record
861: CURSOR cur_wav_stud_assg_rec_exists(cp_n_person_id hz_parties.party_id%TYPE,
862: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE,
863: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
864: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
865: SELECT fwsp.waiver_name,
866: fwsp.person_id,
867: fwsp.assignment_status_code
868: FROM igs_fi_wav_std_pgms fwsp

Line 925: FUNCTION check_fee_type(p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,

921: RETURN l_b_return_flag;
922: END check_stdnt_wav_assignment;
923:
924:
925: FUNCTION check_fee_type(p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
926: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
927: p_n_dest_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN IS
928: /******************************************************************
929: Created By : Umesh Udayaprakash

Line 926: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

922: END check_stdnt_wav_assignment;
923:
924:
925: FUNCTION check_fee_type(p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
926: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
927: p_n_dest_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN IS
928: /******************************************************************
929: Created By : Umesh Udayaprakash
930: Date Created By : 7/4/2005

Line 927: p_n_dest_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN IS

923:
924:
925: FUNCTION check_fee_type(p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
926: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
927: p_n_dest_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN IS
928: /******************************************************************
929: Created By : Umesh Udayaprakash
930: Date Created By : 7/4/2005
931: Purpose : Function Used in the Rollover page to check whether the

Line 939: CURSOR cur_check_fee_type(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,

935: Change History
936: Who When What
937: ******************************************************************/
938: --Cursor to check whether the fee type records exists in the Destination Calendar passed.
939: CURSOR cur_check_fee_type(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
940: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
941: cp_n_dest_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
942: SELECT 'X'
943: FROM igs_fi_f_typ_ca_inst_all

Line 940: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

936: Who When What
937: ******************************************************************/
938: --Cursor to check whether the fee type records exists in the Destination Calendar passed.
939: CURSOR cur_check_fee_type(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
940: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
941: cp_n_dest_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
942: SELECT 'X'
943: FROM igs_fi_f_typ_ca_inst_all
944: WHERE fee_type = cp_v_fee_type

Line 941: cp_n_dest_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS

937: ******************************************************************/
938: --Cursor to check whether the fee type records exists in the Destination Calendar passed.
939: CURSOR cur_check_fee_type(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
940: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
941: cp_n_dest_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
942: SELECT 'X'
943: FROM igs_fi_f_typ_ca_inst_all
944: WHERE fee_type = cp_v_fee_type
945: AND fee_cal_type = cp_v_fee_cal_type

Line 943: FROM igs_fi_f_typ_ca_inst_all

939: CURSOR cur_check_fee_type(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
940: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
941: cp_n_dest_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
942: SELECT 'X'
943: FROM igs_fi_f_typ_ca_inst_all
944: WHERE fee_type = cp_v_fee_type
945: AND fee_cal_type = cp_v_fee_cal_type
946: AND fee_ci_sequence_number = cp_n_dest_fee_ci_seq_number;
947:

Line 966: p_n_dest_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

962:
963:
964: PROCEDURE roll_over_wav_assign(p_rollover_rowid IN VARCHAR2,
965: p_v_stud_rollover_flag IN VARCHAR2,
966: p_n_dest_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
967: p_v_rollover_status OUT NOCOPY VARCHAR2) IS
968: /******************************************************************
969: Created By : Umesh Udayaprakash
970: Date Created By : 7/4/2005

Line 985: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

981: WHERE pgms.rowid = cp_rollover_rowid;
982:
983: --Cursor to select the prereq waiver programs of the waiver program to be rolled over.
984: CURSOR cur_pre_req_wav_programs(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,
985: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
986: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
987: SELECT sup_waiver_name,
988: sub_waiver_name,
989: fee_cal_type,

Line 986: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS

982:
983: --Cursor to select the prereq waiver programs of the waiver program to be rolled over.
984: CURSOR cur_pre_req_wav_programs(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,
985: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
986: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
987: SELECT sup_waiver_name,
988: sub_waiver_name,
989: fee_cal_type,
990: fee_ci_sequence_number

Line 997: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

993: AND fee_cal_type = cp_v_fee_cal_type
994: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_number;
995: --Cursor to Check whether the prereq program already exists in the destincation calendar
996: CURSOR cur_prereq_wav_prgms_exist(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,
997: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
998: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
999: SELECT 'x'
1000: FROM igs_fi_waiver_pgms
1001: WHERE waiver_name = cp_v_waiver_name

Line 998: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS

994: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_number;
995: --Cursor to Check whether the prereq program already exists in the destincation calendar
996: CURSOR cur_prereq_wav_prgms_exist(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,
997: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
998: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
999: SELECT 'x'
1000: FROM igs_fi_waiver_pgms
1001: WHERE waiver_name = cp_v_waiver_name
1002: AND fee_cal_type = cp_v_fee_cal_type

Line 1007: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

1003: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_number;
1004:
1005: --Cursor to select the Student waiver Assignment for Rolling over.
1006: CURSOR cur_stud_waiver_assign(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,
1007: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
1008: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
1009: SELECT stuwavpgm.*
1010: FROM igs_fi_wav_std_pgms stuwavpgm
1011: WHERE stuwavpgm.fee_cal_type = cp_v_fee_cal_type

Line 1008: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS

1004:
1005: --Cursor to select the Student waiver Assignment for Rolling over.
1006: CURSOR cur_stud_waiver_assign(cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE,
1007: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
1008: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
1009: SELECT stuwavpgm.*
1010: FROM igs_fi_wav_std_pgms stuwavpgm
1011: WHERE stuwavpgm.fee_cal_type = cp_v_fee_cal_type
1012: AND stuwavpgm.fee_ci_sequence_number = cp_n_fee_ci_sequence_number