APPS.IGS_FI_CRDAPI_UTIL dependencies on IGS_CA_INST

Line 328: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;

324: Added validations for Credit Card status and credit card payee
325: ********************************************************************************************** */
326: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
327: l_n_pay_cr_type_id igs_fi_cr_types.payment_credit_type_id%TYPE;
328: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
329: l_v_ld_ci_seq_num igs_ca_inst.sequence_number%TYPE;
330: l_b_return_status BOOLEAN;
331: l_v_message_name fnd_new_messages.message_name%TYPE;
332: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;

Line 329: l_v_ld_ci_seq_num igs_ca_inst.sequence_number%TYPE;

325: ********************************************************************************************** */
326: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
327: l_n_pay_cr_type_id igs_fi_cr_types.payment_credit_type_id%TYPE;
328: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
329: l_v_ld_ci_seq_num igs_ca_inst.sequence_number%TYPE;
330: l_b_return_status BOOLEAN;
331: l_v_message_name fnd_new_messages.message_name%TYPE;
332: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
333:

Line 995: CURSOR c_cal_inst(cp_cal_type IN igs_ca_inst.cal_type%TYPE,

991: Known limitations,enhancements,remarks:
992: Change History
993: Who When What
994: ********************************************************************************************** */
995: CURSOR c_cal_inst(cp_cal_type IN igs_ca_inst.cal_type%TYPE,
996: cp_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
997: cp_s_cal_cat IN igs_ca_type.s_cal_cat%TYPE)
998: IS
999: SELECT 'x'

Line 996: cp_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

992: Change History
993: Who When What
994: ********************************************************************************************** */
995: CURSOR c_cal_inst(cp_cal_type IN igs_ca_inst.cal_type%TYPE,
996: cp_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
997: cp_s_cal_cat IN igs_ca_type.s_cal_cat%TYPE)
998: IS
999: SELECT 'x'
1000: FROM igs_ca_inst ci,

Line 1000: FROM igs_ca_inst ci,

996: cp_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
997: cp_s_cal_cat IN igs_ca_type.s_cal_cat%TYPE)
998: IS
999: SELECT 'x'
1000: FROM igs_ca_inst ci,
1001: igs_ca_type cat,
1002: igs_ca_stat stat
1003: WHERE ci.cal_type = cp_cal_type
1004: AND ci.sequence_number = cp_ci_sequence_number

Line 1079: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;

1075: Change History
1076: Who When What
1077: ********************************************************************************************** */
1078: l_b_ret BOOLEAN;
1079: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
1080: l_n_ld_seq_number igs_ca_inst.sequence_number%TYPE;
1081: l_v_message_name fnd_new_messages.message_name%TYPE;
1082:
1083: BEGIN

Line 1080: l_n_ld_seq_number igs_ca_inst.sequence_number%TYPE;

1076: Who When What
1077: ********************************************************************************************** */
1078: l_b_ret BOOLEAN;
1079: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
1080: l_n_ld_seq_number igs_ca_inst.sequence_number%TYPE;
1081: l_v_message_name fnd_new_messages.message_name%TYPE;
1082:
1083: BEGIN
1084: