[Home] [Help]
98: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
99: p_n_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
100: p_n_amount IN igs_fi_invln_int.amount%TYPE,
101: p_v_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,
102: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
103: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
104: p_n_source_invoice_id IN igs_fi_inv_int.invoice_id%TYPE,
105: p_v_sua_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
106: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,
356: AND closed_flag = g_v_no;
357:
358: -- Variables to hold transactional values
359: l_rec_unit_load cur_unit_load%ROWTYPE;
360: l_v_currency_cd igs_fi_control.currency_cd%TYPE := NULL;
361: l_v_currency_desc fnd_currencies_tl.name%TYPE := NULL;
362: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
363: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE := NULL;
364: l_n_source_invoice_id igs_fi_inv_int.invoice_id%TYPE := NULL;
998:
999: l_n_person_id igs_pe_std_todo.person_id%TYPE;
1000: l_dynamic_sql VARCHAR2(32767);
1001: l_v_status VARCHAR2(1);
1002: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE;
1003: l_v_message_name fnd_new_messages.message_name%TYPE;
1004: -- Out Parameters from the Process_special_fees procedure.
1005: l_b_recs_found BOOLEAN;
1006: l_b_person_grp_data_found BOOLEAN;