DBA Data[Home] [Help]

APPS.IGS_FI_PRC_SP_FEES dependencies on IGS_FI_INV_INT

Line 101: p_v_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,

97: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
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,

Line 104: p_n_source_invoice_id IN igs_fi_inv_int.invoice_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,
107: p_v_ret_status OUT NOCOPY VARCHAR2) AS
108: /******************************************************************

Line 106: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%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,
107: p_v_ret_status OUT NOCOPY VARCHAR2) AS
108: /******************************************************************
109: Created By : Priya Athipatla
110: Date Created By : 15-Oct-2003

Line 292: invoice_id igs_fi_inv_int.invoice_id%TYPE);

288: fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
289: fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
290: old_amount igs_fi_special_fees.fee_amt%TYPE,
291: new_amount igs_fi_special_fees.fee_amt%TYPE,
292: invoice_id igs_fi_inv_int.invoice_id%TYPE);
293:
294: TYPE sp_fees_tab IS TABLE OF sp_fees_rec_type INDEX BY BINARY_INTEGER;
295:
296: -- plsql table initialization

Line 363: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE := NULL;

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;
365: l_n_special_fee_id igs_fi_special_fees.special_fee_id%TYPE := NULL;
366: l_n_net_amount igs_fi_special_fees.fee_amt%TYPE := 0.0;
367: l_n_retention_amt igs_fi_special_fees.fee_amt%TYPE := 0.0;

Line 364: l_n_source_invoice_id igs_fi_inv_int.invoice_id%TYPE := NULL;

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;
365: l_n_special_fee_id igs_fi_special_fees.special_fee_id%TYPE := NULL;
366: l_n_net_amount igs_fi_special_fees.fee_amt%TYPE := 0.0;
367: l_n_retention_amt igs_fi_special_fees.fee_amt%TYPE := 0.0;
368: l_v_unit_section_desc VARCHAR2(4000) := NULL;

Line 381: l_v_invoice_number igs_fi_inv_int_all.invoice_number%TYPE;

377: e_expected_error EXCEPTION;
378:
379: l_b_no_data_found BOOLEAN := FALSE;
380:
381: l_v_invoice_number igs_fi_inv_int_all.invoice_number%TYPE;
382: l_b_chg_decl_rev BOOLEAN;
383:
384: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;
385: l_v_complete_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE;