eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_RECEIPT_API_COVER dependencies on AR_CASH_RECEIPTS

Line 84: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: -- Receipt application parameters.
84: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
85: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
86: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
87: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
88: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

Line 85: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: -- Receipt application parameters.
84: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
85: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
86: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
87: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
88: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
89: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

Line 128: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

124: x_return_status OUT NOCOPY VARCHAR2 ,
125: x_msg_count OUT NOCOPY NUMBER ,
126: x_msg_data OUT NOCOPY VARCHAR2 ,
127: -- *** Receipt Info. parameters *****
128: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
129: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
131: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
132: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

Line 129: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

125: x_msg_count OUT NOCOPY NUMBER ,
126: x_msg_data OUT NOCOPY VARCHAR2 ,
127: -- *** Receipt Info. parameters *****
128: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
129: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
131: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
132: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
133: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

Line 151: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,

147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: -- Receipt info. parameters
150: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
151: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
152: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

Line 153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,

149: -- Receipt info. parameters
150: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
151: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
152: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,

Line 154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,

150: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
151: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
152: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

Line 155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

151: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
152: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

Line 156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,

152: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
160: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,

Line 157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,

153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
160: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
161: p_maturity_date IN DATE DEFAULT NULL,

Line 158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
160: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
161: p_maturity_date IN DATE DEFAULT NULL,
162: p_postmark_date IN DATE DEFAULT NULL,

Line 159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
160: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
161: p_maturity_date IN DATE DEFAULT NULL,
162: p_postmark_date IN DATE DEFAULT NULL,
163: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

Line 163: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
160: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
161: p_maturity_date IN DATE DEFAULT NULL,
162: p_postmark_date IN DATE DEFAULT NULL,
163: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
164: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
165: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
166: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
167: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,

Line 166: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,

162: p_postmark_date IN DATE DEFAULT NULL,
163: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
164: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
165: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
166: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
167: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
168: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
169: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
170: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,

Line 171: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,

167: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
168: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
169: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
170: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
171: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
172: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,
174: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
175: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,

Line 172: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,

168: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
169: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
170: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
171: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
172: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,
174: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
175: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
176: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,

Line 173: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,

169: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
170: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
171: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
172: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,
174: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
175: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
176: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
177: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

Line 176: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,

172: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,
174: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
175: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
176: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
177: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
178: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
179: p_doc_sequence_value IN NUMBER DEFAULT NULL,
180: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 177: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

173: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,
174: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
175: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
176: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
177: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
178: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
179: p_doc_sequence_value IN NUMBER DEFAULT NULL,
180: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
181: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,

Line 180: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,

176: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
177: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
178: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
179: p_doc_sequence_value IN NUMBER DEFAULT NULL,
180: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
181: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
182: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
183: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
184: -- ******* Global Flexfield parameters *******

Line 181: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,

177: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
178: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
179: p_doc_sequence_value IN NUMBER DEFAULT NULL,
180: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
181: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
182: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
183: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
184: -- ******* Global Flexfield parameters *******
185: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,

Line 188: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,

184: -- ******* Global Flexfield parameters *******
185: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
186: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
187: -- *** Notes Receivable Additional Information ***
188: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
189: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
190: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
191: -- ** OUT NOCOPY variables for Creating receipt
192: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

Line 189: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,

185: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
186: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
187: -- *** Notes Receivable Additional Information ***
188: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
189: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
190: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
191: -- ** OUT NOCOPY variables for Creating receipt
192: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
193: -- Receipt application parameters

Line 190: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,

186: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
187: -- *** Notes Receivable Additional Information ***
188: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
189: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
190: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
191: -- ** OUT NOCOPY variables for Creating receipt
192: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
193: -- Receipt application parameters
194: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

Line 192: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

188: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
189: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
190: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
191: -- ** OUT NOCOPY variables for Creating receipt
192: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
193: -- Receipt application parameters
194: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
195: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
196: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

Line 232: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: -- Receipt reversal related parameters
232: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
233: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
234: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
235: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,

Line 233: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: -- Receipt reversal related parameters
232: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
233: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
234: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
235: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
237: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,

Line 234: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,

230: x_msg_data OUT NOCOPY VARCHAR2,
231: -- Receipt reversal related parameters
232: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
233: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
234: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
235: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
237: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
238: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,

Line 237: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,

233: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
234: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
235: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
237: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
238: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
239: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
240: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
241: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',

Line 238: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,

234: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
235: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
237: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
238: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
239: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
240: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
241: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
242: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,

Line 240: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,

236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
237: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
238: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
239: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
240: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
241: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
242: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
243: --p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type_upd DEFAULT ar_receipt_api_pub.global_attribute_rec_upd_cons
244: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const ,

Line 258: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: -- Receipt application parameters.
258: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
259: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
260: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
261: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
262: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 259: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: -- Receipt application parameters.
258: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
259: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
260: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
261: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
262: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
263: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 284: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

280: x_return_status OUT NOCOPY VARCHAR2 ,
281: x_msg_count OUT NOCOPY NUMBER ,
282: x_msg_data OUT NOCOPY VARCHAR2 ,
283: -- *** Receipt Info. parameters *****
284: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
285: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
286: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
287: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL
288: );

Line 285: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

281: x_msg_count OUT NOCOPY NUMBER ,
282: x_msg_data OUT NOCOPY VARCHAR2 ,
283: -- *** Receipt Info. parameters *****
284: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
285: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
286: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
287: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL
288: );
289:

Line 300: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: -- Receipt application parameters.
300: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
301: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
302: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
303: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
304: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

Line 301: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: -- Receipt application parameters.
300: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
301: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
302: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
303: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
304: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
305: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default

Line 338: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

334: x_return_status OUT NOCOPY VARCHAR2 ,
335: x_msg_count OUT NOCOPY NUMBER ,
336: x_msg_data OUT NOCOPY VARCHAR2 ,
337: -- *** Receipt Info. parameters *****
338: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
339: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
340: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
341: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
342: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'

Line 339: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

335: x_msg_count OUT NOCOPY NUMBER ,
336: x_msg_data OUT NOCOPY VARCHAR2 ,
337: -- *** Receipt Info. parameters *****
338: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
339: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
340: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
341: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
342: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
343: );

Line 356: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
355: -- Receipt application parameters.
356: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
357: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
358: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
359: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
360: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,

Line 357: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
355: -- Receipt application parameters.
356: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
357: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
358: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
359: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
360: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
361: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

Line 389: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

385: x_return_status OUT NOCOPY VARCHAR2 ,
386: x_msg_count OUT NOCOPY NUMBER ,
387: x_msg_data OUT NOCOPY VARCHAR2 ,
388: -- *** Receipt Info. parameters *****
389: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
390: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
391: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
392: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
393: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',

Line 390: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

386: x_msg_count OUT NOCOPY NUMBER ,
387: x_msg_data OUT NOCOPY VARCHAR2 ,
388: -- *** Receipt Info. parameters *****
389: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
390: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
391: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
392: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
393: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
394: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'

Line 451: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

447: x_return_status OUT NOCOPY VARCHAR2,
448: x_msg_count OUT NOCOPY NUMBER,
449: x_msg_data OUT NOCOPY VARCHAR2,
450: -- Receipt application parameters.
451: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
452: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
453: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
454: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
455: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

Line 452: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

448: x_msg_count OUT NOCOPY NUMBER,
449: x_msg_data OUT NOCOPY VARCHAR2,
450: -- Receipt application parameters.
451: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
452: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
453: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
454: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
455: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
456: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

Line 454: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

450: -- Receipt application parameters.
451: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
452: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
453: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
454: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
455: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
456: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
457: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
458: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

Line 455: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

451: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
452: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
453: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
454: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
455: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
456: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
457: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
458: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
459: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,