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_PRC_LOCKBOX dependencies on IGS_FI_INV_INT

Line 1909: PROCEDURE val_charge_number_for_app(p_v_charge_code igs_fi_inv_int.invoice_number%TYPE,

1905: END LOOP;
1906: END IF;
1907: END populate_lb_receipts;
1908:
1909: PROCEDURE val_charge_number_for_app(p_v_charge_code igs_fi_inv_int.invoice_number%TYPE,
1910: p_v_party_number hz_parties.party_number%TYPE,
1911: p_n_party_id pls_integer,
1912: p_v_fee_type OUT NOCOPY igs_fi_fee_type.fee_type%TYPE,
1913: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,

Line 1913: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,

1909: PROCEDURE val_charge_number_for_app(p_v_charge_code igs_fi_inv_int.invoice_number%TYPE,
1910: p_v_party_number hz_parties.party_number%TYPE,
1911: p_n_party_id pls_integer,
1912: p_v_fee_type OUT NOCOPY igs_fi_fee_type.fee_type%TYPE,
1913: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,
1914: p_v_message_name OUT NOCOPY VARCHAR2) AS
1915: /******************************************************************
1916: Created By : Amit Gairola
1917: Date Created By : 12-Jun-2003

Line 1924: CURSOR cur_inv(cp_invoice_number igs_fi_inv_int.invoice_number%TYPE,

1920: Known limitations,enhancements,remarks:
1921: Change History
1922: Who When What
1923: ***************************************************************** */
1924: CURSOR cur_inv(cp_invoice_number igs_fi_inv_int.invoice_number%TYPE,
1925: cp_party_id igs_fi_inv_int.person_id%TYPE) IS
1926: SELECT invoice_id,
1927: fee_type
1928: FROM igs_fi_inv_int

Line 1925: cp_party_id igs_fi_inv_int.person_id%TYPE) IS

1921: Change History
1922: Who When What
1923: ***************************************************************** */
1924: CURSOR cur_inv(cp_invoice_number igs_fi_inv_int.invoice_number%TYPE,
1925: cp_party_id igs_fi_inv_int.person_id%TYPE) IS
1926: SELECT invoice_id,
1927: fee_type
1928: FROM igs_fi_inv_int
1929: WHERE person_id = cp_party_id

Line 1928: FROM igs_fi_inv_int

1924: CURSOR cur_inv(cp_invoice_number igs_fi_inv_int.invoice_number%TYPE,
1925: cp_party_id igs_fi_inv_int.person_id%TYPE) IS
1926: SELECT invoice_id,
1927: fee_type
1928: FROM igs_fi_inv_int
1929: WHERE person_id = cp_party_id
1930: AND invoice_number = cp_invoice_number;
1931:
1932: CURSOR cur_ft(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS

Line 1938: l_n_inv_id igs_fi_inv_int.invoice_id%TYPE;

1934: FROM igs_fi_fee_type
1935: WHERE fee_type = cp_fee_type;
1936:
1937: l_v_fee_type igs_fi_fee_type.fee_type%TYPE;
1938: l_n_inv_id igs_fi_inv_int.invoice_id%TYPE;
1939: l_v_designated_pay_flag igs_fi_fee_type.designated_payment_flag%TYPE;
1940: BEGIN
1941:
1942: -- Validate if the Party Id and the charge code exist in the Charges table.

Line 1983: p_v_charge_code igs_fi_inv_int.invoice_number%TYPE,

1979: p_v_fee_type := l_v_fee_type;
1980: END val_charge_number_for_app;
1981:
1982: PROCEDURE invoke_target_appl(p_n_credit_id PLS_INTEGER,
1983: p_v_charge_code igs_fi_inv_int.invoice_number%TYPE,
1984: p_n_target_invoice_id PLS_INTEGER,
1985: p_n_amount_applied NUMBER,
1986: p_d_gl_date DATE,
1987: p_n_act_amnt_applied OUT NOCOPY NUMBER,

Line 1999: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

1995: Known limitations,enhancements,remarks:
1996: Change History
1997: Who When What
1998: ***************************************************************** */
1999: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
2000: SELECT invoice_amount_due
2001: FROM igs_fi_inv_int
2002: WHERE invoice_id = cp_invoice_id;
2003:

Line 2001: FROM igs_fi_inv_int

1997: Who When What
1998: ***************************************************************** */
1999: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
2000: SELECT invoice_amount_due
2001: FROM igs_fi_inv_int
2002: WHERE invoice_id = cp_invoice_id;
2003:
2004:
2005: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;

Line 2005: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;

2001: FROM igs_fi_inv_int
2002: WHERE invoice_id = cp_invoice_id;
2003:
2004:
2005: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
2006: l_n_app_id igs_fi_applications.application_id%TYPE;
2007: l_n_act_apply_amount igs_fi_applications.amount_applied%TYPE;
2008: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
2009: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;

Line 2013: l_n_inv_amount_due igs_fi_inv_int.invoice_amount_due%TYPE;

2009: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
2010: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
2011: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;
2012: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
2013: l_n_inv_amount_due igs_fi_inv_int.invoice_amount_due%TYPE;
2014: l_v_err_msg VARCHAR2(2000);
2015: l_b_status BOOLEAN := FALSE;
2016: BEGIN
2017:

Line 2427: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE;

2423: l_v_message_name VARCHAR2(2000);
2424: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
2425: l_n_ld_seq_num igs_ca_inst.sequence_number%TYPE;
2426: l_v_fee_type igs_fi_fee_type.fee_type%TYPE;
2427: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE;
2428: l_v_message_text VARCHAR2(2000);
2429: l_b_ro_rec_match BOOLEAN;
2430: l_n_rec_err_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;
2431: l_n_credit_id igs_fi_credits.credit_id%TYPE;