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,
90: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
91: -- this is the allocated receipt amount
92: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
93: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
94: p_discount IN ar_receivable_applications.earned_discount_taken%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,
90: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
91: -- this is the allocated receipt amount
92: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
93: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
94: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
95: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
96: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
89: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
90: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
91: -- this is the allocated receipt amount
92: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
93: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
94: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
95: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
96: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
97: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
90: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
91: -- this is the allocated receipt amount
92: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
93: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
94: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
95: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
96: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
97: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
98: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
91: -- this is the allocated receipt amount
92: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
93: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
94: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
95: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
96: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
97: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
98: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
99: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
92: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
93: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
94: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
95: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
96: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
97: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
98: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
99: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
100: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
93: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
94: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
95: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
96: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
97: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
98: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
99: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
100: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
101: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
94: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
95: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
96: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
97: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
98: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
99: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
100: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
101: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
102: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
99: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
100: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
101: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
102: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
103: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
104: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
105: -- ******* Global Flexfield parameters *******
106: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
107: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
103: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
104: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
105: -- ******* Global Flexfield parameters *******
106: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
107: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
108: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
109: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
110: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
111: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
104: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
105: -- ******* Global Flexfield parameters *******
106: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
107: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
108: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
109: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
110: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
111: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
112: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
105: -- ******* Global Flexfield parameters *******
106: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
107: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
108: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
109: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
110: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
111: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
112: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
113: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
106: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
107: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
108: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
109: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
110: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
111: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
112: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
113: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
114: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
107: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
108: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
109: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
110: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
111: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
112: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
113: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
114: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
115: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
108: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
109: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
110: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
111: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
112: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
113: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
114: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
115: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
116: );
109: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
110: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
111: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
112: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
113: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
114: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
115: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
116: );
117:
110: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
111: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
112: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
113: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
114: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
115: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
116: );
117:
118: PROCEDURE Unapply(
111: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
112: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
113: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
114: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
115: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
116: );
117:
118: PROCEDURE Unapply(
119: -- Standard API parameters.
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,
134: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
135: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
136: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
137: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y'
138: );
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,
134: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
135: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
136: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
137: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y'
138: );
139:
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,
197: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
198: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
199: -- this is the allocated receipt amount
200: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
201: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
202: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
196: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
197: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
198: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
199: -- this is the allocated receipt amount
200: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
201: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
202: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
203: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
204: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
197: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
198: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
199: -- this is the allocated receipt amount
200: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
201: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
202: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
203: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
204: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
205: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
198: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
199: -- this is the allocated receipt amount
200: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
201: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
202: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
203: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
204: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
205: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
206: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
199: -- this is the allocated receipt amount
200: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
201: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
202: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
203: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
204: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
205: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
206: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
207: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
200: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
201: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
202: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
203: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
204: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
205: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
206: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
207: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
208: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
201: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
202: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
203: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
204: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
205: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
206: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
207: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
208: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
209: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
202: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
203: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
204: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
205: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
206: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
207: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
208: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
209: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
210: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
206: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
207: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
208: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
209: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
210: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
211: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
212: -- ******* Global Flexfield parameters *******
213: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
214: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
210: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
211: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
212: -- ******* Global Flexfield parameters *******
213: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
214: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
215: -- OSTEINME 3/9/2001: added flag that indicates whether to call payment
216: -- processor such as iPayments
217: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE
218:
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,
264: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
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,
264: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
265: -- ******* Global Flexfield 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,
264: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
265: -- ******* Global Flexfield parameters *******
266: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
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,
264: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
265: -- ******* Global Flexfield parameters *******
266: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
267: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
263: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
264: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
265: -- ******* Global Flexfield parameters *******
266: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
267: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
268: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
269: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
270: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
271: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
264: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
265: -- ******* Global Flexfield parameters *******
266: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
267: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
268: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
269: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
270: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
271: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
272: );
265: -- ******* Global Flexfield parameters *******
266: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
267: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
268: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
269: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
270: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
271: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
272: );
273:
266: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
267: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
268: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
269: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
270: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
271: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
272: );
273:
274: PROCEDURE Unapply_on_account(
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:
290: PROCEDURE Activity_application(
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:
290: PROCEDURE Activity_application(
291: -- Standard API parameters.
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
306: p_apply_date IN ar_receivable_applications.apply_date%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
306: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
307: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
308: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
309: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
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
306: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
307: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
308: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
309: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
310: -- ******* Global Flexfield parameters *******
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
306: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
307: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
308: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
309: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
310: -- ******* Global Flexfield parameters *******
311: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
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
306: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
307: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
308: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
309: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
310: -- ******* Global Flexfield parameters *******
311: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
312: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
308: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
309: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
310: -- ******* Global Flexfield parameters *******
311: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
312: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
313: p_application_ref_type IN OUT NOCOPY
314: ar_receivable_applications.application_ref_type%TYPE,
315: p_application_ref_id IN OUT NOCOPY
316: ar_receivable_applications.application_ref_id%TYPE,
310: -- ******* Global Flexfield parameters *******
311: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
312: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
313: p_application_ref_type IN OUT NOCOPY
314: ar_receivable_applications.application_ref_type%TYPE,
315: p_application_ref_id IN OUT NOCOPY
316: ar_receivable_applications.application_ref_id%TYPE,
317: p_application_ref_num IN OUT NOCOPY
318: ar_receivable_applications.application_ref_num%TYPE,
312: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
313: p_application_ref_type IN OUT NOCOPY
314: ar_receivable_applications.application_ref_type%TYPE,
315: p_application_ref_id IN OUT NOCOPY
316: ar_receivable_applications.application_ref_id%TYPE,
317: p_application_ref_num IN OUT NOCOPY
318: ar_receivable_applications.application_ref_num%TYPE,
319: p_secondary_application_ref_id IN OUT NOCOPY
320: ar_receivable_applications.secondary_application_ref_id%TYPE,
314: ar_receivable_applications.application_ref_type%TYPE,
315: p_application_ref_id IN OUT NOCOPY
316: ar_receivable_applications.application_ref_id%TYPE,
317: p_application_ref_num IN OUT NOCOPY
318: ar_receivable_applications.application_ref_num%TYPE,
319: p_secondary_application_ref_id IN OUT NOCOPY
320: ar_receivable_applications.secondary_application_ref_id%TYPE,
321: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
322: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
316: ar_receivable_applications.application_ref_id%TYPE,
317: p_application_ref_num IN OUT NOCOPY
318: ar_receivable_applications.application_ref_num%TYPE,
319: p_secondary_application_ref_id IN OUT NOCOPY
320: ar_receivable_applications.secondary_application_ref_id%TYPE,
321: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
322: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
323: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
324: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
317: p_application_ref_num IN OUT NOCOPY
318: ar_receivable_applications.application_ref_num%TYPE,
319: p_secondary_application_ref_id IN OUT NOCOPY
320: ar_receivable_applications.secondary_application_ref_id%TYPE,
321: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
322: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
323: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
324: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
325: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
318: ar_receivable_applications.application_ref_num%TYPE,
319: p_secondary_application_ref_id IN OUT NOCOPY
320: ar_receivable_applications.secondary_application_ref_id%TYPE,
321: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
322: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
323: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
324: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
325: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
326: );
319: p_secondary_application_ref_id IN OUT NOCOPY
320: ar_receivable_applications.secondary_application_ref_id%TYPE,
321: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
322: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
323: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
324: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
325: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
326: );
327:
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: );
344:
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: );
344:
345: PROCEDURE Apply_other_account(
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: x_return_status OUT NOCOPY VARCHAR2,
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,
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,
362: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
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,
362: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
363: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
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,
362: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
363: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
364: p_application_ref_type IN ar_receivable_applications.application_ref_type%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,
362: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
363: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
364: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
365: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
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,
362: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
363: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
364: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
365: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
366: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
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,
362: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
363: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
364: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
365: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
366: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
367: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
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,
362: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
363: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
364: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
365: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
366: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
367: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
368: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
361: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
362: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
363: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
364: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
365: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
366: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
367: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
368: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
369: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
362: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
363: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
364: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
365: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
366: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
367: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
368: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
369: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
370: -- ******* Global Flexfield parameters *******
363: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
364: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
365: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
366: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
367: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
368: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
369: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
370: -- ******* Global Flexfield parameters *******
371: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
364: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
365: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
366: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
367: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
368: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
369: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
370: -- ******* Global Flexfield parameters *******
371: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
372: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
368: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
369: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
370: -- ******* Global Flexfield parameters *******
371: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
372: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
373: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
374: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
375: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
376: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
369: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
370: -- ******* Global Flexfield parameters *******
371: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
372: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
373: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
374: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
375: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
376: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
377: );
370: -- ******* Global Flexfield parameters *******
371: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
372: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
373: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
374: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
375: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
376: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
377: );
378:
371: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
372: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
373: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
374: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
375: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
376: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
377: );
378:
379: PROCEDURE Unapply_other_account(
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'
395: );
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'
395: );
396:
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,
460: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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,
460: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
461: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
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,
460: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
461: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
462: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
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,
460: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
461: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
462: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
463: -- ******* Global Flexfield parameters *******
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,
460: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
461: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
462: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
463: -- ******* Global Flexfield parameters *******
464: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
461: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
462: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
463: -- ******* Global Flexfield parameters *******
464: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
465: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
466: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
467: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
468: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE
469: );
462: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
463: -- ******* Global Flexfield parameters *******
464: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
465: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
466: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
467: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
468: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE
469: );
470:
463: -- ******* Global Flexfield parameters *******
464: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
465: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
466: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
467: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
468: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE
469: );
470:
471: PROCEDURE Unapply_Open_Receipt(
464: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
465: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
466: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
467: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
468: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE
469: );
470:
471: PROCEDURE Unapply_Open_Receipt(
472: -- Standard API parameters.
476: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
477: x_return_status OUT NOCOPY VARCHAR2 ,
478: x_msg_count OUT NOCOPY NUMBER ,
479: x_msg_data OUT NOCOPY VARCHAR2 ,
480: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
481: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
482: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT');
483:
484: END AR_RECEIPT_API_COVER;
477: x_return_status OUT NOCOPY VARCHAR2 ,
478: x_msg_count OUT NOCOPY NUMBER ,
479: x_msg_data OUT NOCOPY VARCHAR2 ,
480: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
481: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
482: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT');
483:
484: END AR_RECEIPT_API_COVER;