DBA Data[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on AR_RATE_ADJUSTMENTS

Line 1997: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,

1993: PROCEDURE rate_adjust(
1994: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1995: p_rate_adjust_gl_date IN DATE,
1996: p_new_exchange_date IN DATE,
1997: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
1998: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
1999: p_old_exchange_date IN DATE,
2000: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
2001: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,

Line 1998: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,

1994: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1995: p_rate_adjust_gl_date IN DATE,
1996: p_new_exchange_date IN DATE,
1997: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
1998: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
1999: p_old_exchange_date IN DATE,
2000: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
2001: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
2002: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,

Line 2000: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,

1996: p_new_exchange_date IN DATE,
1997: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
1998: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
1999: p_old_exchange_date IN DATE,
2000: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
2001: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
2002: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
2003: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
2004: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,

Line 2001: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,

1997: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
1998: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
1999: p_old_exchange_date IN DATE,
2000: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
2001: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
2002: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
2003: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
2004: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
2005: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,

Line 2002: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,

1998: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
1999: p_old_exchange_date IN DATE,
2000: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
2001: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
2002: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
2003: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
2004: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
2005: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
2006: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,

Line 2003: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,

1999: p_old_exchange_date IN DATE,
2000: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
2001: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
2002: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
2003: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
2004: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
2005: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
2006: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
2007: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,

Line 2004: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,

2000: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
2001: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
2002: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
2003: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
2004: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
2005: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
2006: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
2007: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
2008: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,

Line 2005: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,

2001: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
2002: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
2003: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
2004: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
2005: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
2006: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
2007: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
2008: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
2009: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,

Line 2006: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,

2002: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
2003: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
2004: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
2005: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
2006: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
2007: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
2008: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
2009: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
2010: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,

Line 2007: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,

2003: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
2004: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
2005: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
2006: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
2007: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
2008: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
2009: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
2010: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
2011: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,

Line 2008: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,

2004: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
2005: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
2006: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
2007: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
2008: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
2009: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
2010: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
2011: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
2012: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,

Line 2009: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,

2005: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
2006: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
2007: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
2008: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
2009: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
2010: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
2011: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
2012: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
2013: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,

Line 2010: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,

2006: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
2007: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
2008: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
2009: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
2010: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
2011: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
2012: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
2013: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
2014: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,

Line 2011: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,

2007: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
2008: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
2009: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
2010: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
2011: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
2012: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
2013: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
2014: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2015: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,

Line 2012: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,

2008: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
2009: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
2010: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
2011: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
2012: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
2013: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
2014: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2015: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2016: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,

Line 2013: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,

2009: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
2010: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
2011: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
2012: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
2013: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
2014: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2015: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2016: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2017: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,

Line 2014: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,

2010: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
2011: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
2012: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
2013: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
2014: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2015: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2016: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2017: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2018: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS

Line 2015: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,

2011: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
2012: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
2013: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
2014: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2015: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2016: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2017: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2018: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2019:

Line 2016: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,

2012: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
2013: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
2014: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2015: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2016: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2017: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2018: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2019:
2020: l_radj_rec ar_rate_adjustments%ROWTYPE;

Line 2017: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,

2013: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
2014: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2015: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2016: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2017: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2018: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2019:
2020: l_radj_rec ar_rate_adjustments%ROWTYPE;
2021: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;

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

2014: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
2015: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
2016: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2017: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2018: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2019:
2020: l_radj_rec ar_rate_adjustments%ROWTYPE;
2021: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
2022: l_crh_id_out ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 2020: l_radj_rec ar_rate_adjustments%ROWTYPE;

2016: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
2017: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2018: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2019:
2020: l_radj_rec ar_rate_adjustments%ROWTYPE;
2021: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
2022: l_crh_id_out ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2023:
2024: BEGIN

Line 2021: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;

2017: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
2018: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2019:
2020: l_radj_rec ar_rate_adjustments%ROWTYPE;
2021: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
2022: l_crh_id_out ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2023:
2024: BEGIN
2025: IF PG_DEBUG in ('Y', 'C') THEN