1978: PROCEDURE rate_adjust(
1979: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1980: p_rate_adjust_gl_date IN DATE,
1981: p_new_exchange_date IN DATE,
1982: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
1983: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
1984: p_old_exchange_date IN DATE,
1985: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
1986: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
1979: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1980: p_rate_adjust_gl_date IN DATE,
1981: p_new_exchange_date IN DATE,
1982: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
1983: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
1984: p_old_exchange_date IN DATE,
1985: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
1986: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
1987: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
1981: p_new_exchange_date IN DATE,
1982: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
1983: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
1984: p_old_exchange_date IN DATE,
1985: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
1986: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
1987: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
1988: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
1989: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
1982: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
1983: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
1984: p_old_exchange_date IN DATE,
1985: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
1986: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
1987: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
1988: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
1989: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
1990: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
1983: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
1984: p_old_exchange_date IN DATE,
1985: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
1986: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
1987: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
1988: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
1989: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
1990: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
1991: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
1984: p_old_exchange_date IN DATE,
1985: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
1986: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
1987: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
1988: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
1989: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
1990: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
1991: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
1992: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
1985: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
1986: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
1987: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
1988: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
1989: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
1990: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
1991: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
1992: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
1993: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
1986: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
1987: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
1988: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
1989: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
1990: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
1991: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
1992: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
1993: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
1994: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
1987: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
1988: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
1989: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
1990: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
1991: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
1992: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
1993: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
1994: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
1995: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
1988: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
1989: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
1990: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
1991: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
1992: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
1993: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
1994: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
1995: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
1996: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
1989: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
1990: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
1991: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
1992: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
1993: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
1994: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
1995: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
1996: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
1997: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
1990: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
1991: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
1992: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
1993: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
1994: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
1995: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
1996: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
1997: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
1998: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
1991: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
1992: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
1993: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
1994: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
1995: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
1996: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
1997: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
1998: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
1999: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
1992: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
1993: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
1994: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
1995: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
1996: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
1997: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
1998: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
1999: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2000: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
1993: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
1994: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
1995: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
1996: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
1997: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
1998: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
1999: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2000: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2001: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
1994: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
1995: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
1996: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
1997: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
1998: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
1999: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2000: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2001: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2002: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
1995: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
1996: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
1997: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
1998: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
1999: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2000: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2001: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2002: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2003: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
1996: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
1997: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
1998: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
1999: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2000: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2001: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2002: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2003: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2004:
1997: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
1998: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
1999: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2000: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2001: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2002: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2003: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2004:
2005: l_radj_rec ar_rate_adjustments%ROWTYPE;
1998: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
1999: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2000: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2001: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2002: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2003: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2004:
2005: l_radj_rec ar_rate_adjustments%ROWTYPE;
2006: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
1999: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2000: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2001: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2002: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2003: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2004:
2005: l_radj_rec ar_rate_adjustments%ROWTYPE;
2006: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
2007: l_crh_id_out ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2001: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2002: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2003: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2004:
2005: l_radj_rec ar_rate_adjustments%ROWTYPE;
2006: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
2007: l_crh_id_out ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2008:
2009: BEGIN
2002: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2003: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2004:
2005: l_radj_rec ar_rate_adjustments%ROWTYPE;
2006: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
2007: l_crh_id_out ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2008:
2009: BEGIN
2010: IF PG_DEBUG in ('Y', 'C') THEN