[Home] [Help]
363: ((new_references.fee_cal_type IS NULL) OR
364: (new_references.fee_ci_sequence_number IS NULL) OR
365: (new_references.fee_type IS NULL))) THEN
366: NULL;
367: ELSIF NOT igs_fi_f_typ_ca_inst_pkg.get_pk_for_validation ( new_references.fee_type,
368: new_references.fee_cal_type,
369: new_references.fee_ci_sequence_number ) THEN
370: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
371: igs_ge_msg_stack.add;
1609: FROM igs_fi_fee_type
1610: WHERE fee_type = cp_fee_type;
1611:
1612: -- Getting the Charge Method and GL Code/ CCID's associated for a fee type
1613: CURSOR cur_chg_mthd(cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
1614: cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
1615: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
1616: SELECT s_chg_method_type,
1617: rec_gl_ccid,
1610: WHERE fee_type = cp_fee_type;
1611:
1612: -- Getting the Charge Method and GL Code/ CCID's associated for a fee type
1613: CURSOR cur_chg_mthd(cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
1614: cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
1615: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
1616: SELECT s_chg_method_type,
1617: rec_gl_ccid,
1618: rec_account_cd
1611:
1612: -- Getting the Charge Method and GL Code/ CCID's associated for a fee type
1613: CURSOR cur_chg_mthd(cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
1614: cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
1615: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
1616: SELECT s_chg_method_type,
1617: rec_gl_ccid,
1618: rec_account_cd
1619: FROM igs_fi_f_typ_ca_inst
1615: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
1616: SELECT s_chg_method_type,
1617: rec_gl_ccid,
1618: rec_account_cd
1619: FROM igs_fi_f_typ_ca_inst
1620: WHERE fee_type = cp_fee_type
1621: AND fee_cal_type = cp_fee_cal_type
1622: AND fee_ci_sequence_number = cp_fee_ci_sequence_number;
1623:
1622: AND fee_ci_sequence_number = cp_fee_ci_sequence_number;
1623:
1624: l_cur_chg_mthd cur_chg_mthd%ROWTYPE;
1625:
1626: l_override_dr_rec_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE;
1627: l_override_dr_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE;
1628: l_override_cr_rev_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE;
1629: l_override_cr_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE;
1630:
1623:
1624: l_cur_chg_mthd cur_chg_mthd%ROWTYPE;
1625:
1626: l_override_dr_rec_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE;
1627: l_override_dr_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE;
1628: l_override_cr_rev_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE;
1629: l_override_cr_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE;
1630:
1631: l_rec_installed igs_fi_control_all.rec_installed%TYPE;
1624: l_cur_chg_mthd cur_chg_mthd%ROWTYPE;
1625:
1626: l_override_dr_rec_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE;
1627: l_override_dr_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE;
1628: l_override_cr_rev_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE;
1629: l_override_cr_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE;
1630:
1631: l_rec_installed igs_fi_control_all.rec_installed%TYPE;
1632: l_message_name fnd_new_messages.message_name%TYPE;
1625:
1626: l_override_dr_rec_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE;
1627: l_override_dr_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE;
1628: l_override_cr_rev_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE;
1629: l_override_cr_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE;
1630:
1631: l_rec_installed igs_fi_control_all.rec_installed%TYPE;
1632: l_message_name fnd_new_messages.message_name%TYPE;
1633: