DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_COVER dependencies on AR_RECEIVABLE_APPLICATIONS

Line 90: p_amount_applied IN ar_receivable_applications.amount_applied%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,
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,

Line 92: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%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,

Line 93: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%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,

Line 94: p_discount IN ar_receivable_applications.earned_discount_taken%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,

Line 95: p_apply_date IN ar_receivable_applications.apply_date%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,

Line 96: p_apply_gl_date IN ar_receivable_applications.gl_date%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 */

Line 97: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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 */
101: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',

Line 98: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%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',
102: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',

Line 103: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_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',
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,

Line 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,

Line 108: p_payment_set_id IN ar_receivable_applications.payment_set_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,
112: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,

Line 109: p_application_ref_type IN ar_receivable_applications.application_ref_type%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,

Line 110: p_application_ref_id IN ar_receivable_applications.application_ref_id%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,

Line 111: p_application_ref_num IN ar_receivable_applications.application_ref_num%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

Line 112: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%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: );

Line 113: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%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: );
117:

Line 114: p_customer_reference IN ar_receivable_applications.customer_reference%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:
118: PROCEDURE Unapply(

Line 115: p_customer_reason IN ar_receivable_applications.customer_reason%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(
119: -- Standard API parameters.

Line 134: p_receivable_application_id IN ar_receivable_applications.receivable_application_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,
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: );

Line 135: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%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: );
139:

Line 198: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

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,

Line 200: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%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,

Line 201: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%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,

Line 202: p_discount IN ar_receivable_applications.earned_discount_taken%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,

Line 203: p_apply_date IN ar_receivable_applications.apply_date%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,

Line 204: p_apply_gl_date IN ar_receivable_applications.gl_date%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 */

Line 205: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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 */
209: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',

Line 206: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%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',
210: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

Line 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,

Line 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:

Line 260: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

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,

Line 261: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

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 *******

Line 262: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

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,

Line 263: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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,
267: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

Line 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'

Line 268: p_application_ref_num IN ar_receivable_applications.application_ref_num%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'
272: );

Line 269: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,

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:

Line 270: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,

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(

Line 286: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

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(

Line 287: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL

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.

Line 302: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

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,

Line 305: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default

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,

Line 306: p_apply_date IN ar_receivable_applications.apply_date%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,
310: -- ******* Global Flexfield parameters *******

Line 307: p_apply_gl_date IN ar_receivable_applications.gl_date%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 *******
311: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,

Line 308: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

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,

Line 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,

Line 314: ar_receivable_applications.application_ref_type%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,

Line 316: ar_receivable_applications.application_ref_id%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,

Line 318: ar_receivable_applications.application_ref_num%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,

Line 320: ar_receivable_applications.secondary_application_ref_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',

Line 321: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,

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'

Line 322: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

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: );

Line 323: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,

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:

Line 340: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

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:

Line 341: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,

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(

Line 354: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

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,

Line 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,

Line 359: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%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,

Line 360: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%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,

Line 361: p_apply_date IN ar_receivable_applications.apply_date%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 ,

Line 362: p_apply_gl_date IN ar_receivable_applications.gl_date%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 ,
366: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,

Line 363: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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 ,
367: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,

Line 364: p_application_ref_type IN ar_receivable_applications.application_ref_type%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 ,
368: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,

Line 365: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,

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,

Line 366: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,

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 *******

Line 367: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,

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,

Line 368: p_payment_set_id IN ar_receivable_applications.payment_set_id%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,
372: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

Line 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'

Line 373: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%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'
377: );

Line 374: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,

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:

Line 375: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

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(

Line 391: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,

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: );

Line 392: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,

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:

Line 456: p_open_rec_app_id IN ar_receivable_applications.receivable_application_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,
460: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 457: p_amount_applied IN ar_receivable_applications.amount_applied%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',

Line 458: p_apply_date IN ar_receivable_applications.apply_date%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',
462: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,

Line 459: p_apply_gl_date IN ar_receivable_applications.gl_date%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,
463: -- ******* Global Flexfield parameters *******

Line 460: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%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 *******
464: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,

Line 465: p_comments IN ar_receivable_applications.comments%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,
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: );

Line 466: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,

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:

Line 467: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

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(

Line 468: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE

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.

Line 480: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,

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;

Line 481: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,

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;