DBA Data[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on AR_RATE_ADJUSTMENTS

Line 133: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 152: p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%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:
156: PROCEDURE get_ccids(

Line 153: p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%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(
157: p_receipt_method_id IN NUMBER,

Line 154: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%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,
158: p_remittance_bank_account_id IN NUMBER,