DBA Data[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on AR_RATE_ADJUSTMENTS

Line 1982: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,

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,

Line 1983: p_new_exchange_rate_type IN ar_rate_adjustments.new_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,

Line 1985: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%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,

Line 1986: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%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,

Line 1987: p_gain_loss IN ar_rate_adjustments.gain_loss%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,

Line 1988: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%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,

Line 1989: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%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,

Line 1990: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%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,

Line 1991: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%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,

Line 1992: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%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,

Line 1993: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%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,

Line 1994: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%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,

Line 1995: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%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,

Line 1996: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%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,

Line 1997: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%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,

Line 1998: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%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,

Line 1999: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%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

Line 2000: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%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
2004:

Line 2001: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%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:
2005: l_radj_rec ar_rate_adjustments%ROWTYPE;

Line 2002: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%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;
2006: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;

Line 2003: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS

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;

Line 2005: l_radj_rec ar_rate_adjustments%ROWTYPE;

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

Line 2006: l_radj_id ar_rate_adjustments.rate_adjustment_id%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
2010: IF PG_DEBUG in ('Y', 'C') THEN