DBA Data[Home] [Help]

APPS.AR_PREPAYMENTS dependencies on AR_RECEIVABLE_APPLICATIONS

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

105: -- ** OUT NOCOPY variables for Creating receipt
106: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
107: -- Receipt application parameters
108: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
109: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
110: p_application_ref_type IN VARCHAR2 DEFAULT NULL,
111: p_application_ref_id IN OUT NOCOPY NUMBER ,
112: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
113: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,

Line 114: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,

110: p_application_ref_type IN VARCHAR2 DEFAULT NULL,
111: p_application_ref_id IN OUT NOCOPY NUMBER ,
112: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
113: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
114: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
115: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
116: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
117: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
118: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 115: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

111: p_application_ref_id IN OUT NOCOPY NUMBER ,
112: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
113: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
114: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
115: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
116: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
117: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
118: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
119: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',

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

112: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
113: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
114: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
115: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
116: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
117: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
118: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
119: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
120: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',

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

113: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
114: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
115: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
116: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
117: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
118: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
119: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
120: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
121: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type

Line 118: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

114: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
115: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
116: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
117: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
118: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
119: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
120: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
121: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
122: DEFAULT ar_receipt_api_pub.attribute_rec_const,

Line 126: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

122: DEFAULT ar_receipt_api_pub.attribute_rec_const,
123: -- ******* Global Flexfield parameters *******
124: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
125: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
126: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
127: -- processor such as iPayments
128: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
129: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
130: --- Bug: 3220078 Change the p_call_payment_processor to TRUE ---

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

131: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,
132:
133: p_payment_response_error_code OUT NOCOPY VARCHAR2,
134: -- OUT NOCOPY parameter for the Application
135: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
136: p_payment_set_id IN OUT NOCOPY NUMBER,
137: p_org_id IN NUMBER DEFAULT NULL,
138: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE
139: );

Line 181: p_prepay_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_prepay_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
182: p_number_of_refund_receipts OUT NOCOPY NUMBER,
183: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
184: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
185: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

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

181: p_prepay_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
182: p_number_of_refund_receipts OUT NOCOPY NUMBER,
183: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
184: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
185: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
186: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
187: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
188: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
189: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 186: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,

182: p_number_of_refund_receipts OUT NOCOPY NUMBER,
183: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
184: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
185: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
186: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
187: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
188: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
189: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
190: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 187: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

183: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
184: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
185: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
186: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
187: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
188: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
189: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
190: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
191: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type

Line 188: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

184: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
185: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
186: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
187: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
188: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
189: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
190: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
191: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
192: DEFAULT ar_receipt_api_pub.attribute_rec_const,

Line 189: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

185: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
186: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
187: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
188: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
189: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
190: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
191: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
192: DEFAULT ar_receipt_api_pub.attribute_rec_const,
193: -- ******* Global Flexfield parameters *******

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

186: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
187: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
188: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
189: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
190: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
191: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
192: DEFAULT ar_receipt_api_pub.attribute_rec_const,
193: -- ******* Global Flexfield parameters *******
194: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type

Line 196: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

192: DEFAULT ar_receipt_api_pub.attribute_rec_const,
193: -- ******* Global Flexfield parameters *******
194: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
195: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
196: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
197: p_payment_set_id IN NUMBER DEFAULT NULL
198: );
199:
200: PROCEDURE match_prepayment (p_payment_schedule_id IN NUMBER,