129: PROCEDURE rate_adjust(
130: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
131: p_rate_adjust_gl_date IN DATE,
132: p_new_exchange_date IN DATE,
133: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
134: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
135: p_old_exchange_date IN DATE,
136: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
137: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
130: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
131: p_rate_adjust_gl_date IN DATE,
132: p_new_exchange_date IN DATE,
133: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
134: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
135: p_old_exchange_date IN DATE,
136: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
137: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
138: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
132: p_new_exchange_date IN DATE,
133: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
134: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
135: p_old_exchange_date IN DATE,
136: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
137: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
138: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
139: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
140: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
133: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
134: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
135: p_old_exchange_date IN DATE,
136: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
137: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
138: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
139: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
140: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
141: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
134: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
135: p_old_exchange_date IN DATE,
136: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
137: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
138: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
139: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
140: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
141: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
142: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
135: p_old_exchange_date IN DATE,
136: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
137: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
138: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
139: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
140: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
141: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
142: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
143: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
136: p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
137: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
138: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
139: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
140: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
141: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
142: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
143: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
144: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
137: p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
138: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
139: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
140: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
141: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
142: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
143: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
144: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
145: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
138: p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
139: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
140: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
141: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
142: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
143: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
144: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
145: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
146: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
139: p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
140: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
141: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
142: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
143: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
144: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
145: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
146: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
147: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
140: p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
141: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
142: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
143: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
144: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
145: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
146: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
147: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
148: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
141: p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
142: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
143: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
144: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
145: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
146: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
147: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
148: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
149: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
142: p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
143: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
144: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
145: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
146: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
147: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
148: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
149: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
150: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
143: p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
144: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
145: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
146: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
147: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
148: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
149: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
150: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
151: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
144: p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
145: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
146: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
147: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
148: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
149: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
150: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
151: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
152: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
145: p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
146: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
147: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
148: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
149: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
150: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
151: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
152: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
153: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
146: p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
147: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
148: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
149: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
150: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
151: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
152: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
153: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
154: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE);
147: p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
148: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
149: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
150: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
151: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
152: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
153: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
154: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE);
155:
148: p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
149: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
150: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
151: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
152: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
153: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
154: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE);
155:
156: PROCEDURE get_ccids(
149: p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
150: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
151: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
152: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
153: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
154: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE);
155:
156: PROCEDURE get_ccids(
157: p_receipt_method_id IN NUMBER,
150: p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
151: p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
152: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
153: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
154: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE);
155:
156: PROCEDURE get_ccids(
157: p_receipt_method_id IN NUMBER,
158: p_remittance_bank_account_id IN NUMBER,