DBA Data[Home] [Help]

APPS.AR_PREPAYMENTS dependencies on AR_RECEIPT_API_PUB

Line 188: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type

184: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
185: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
186: p_ussgl_transaction_code IN ar_receivable_applications.
187: ussgl_transaction_code%TYPE DEFAULT NULL,
188: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
189: DEFAULT ar_receipt_api_pub.attribute_rec_const,
190: -- ******* Global Flexfield parameters *******
191: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
192: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,

Line 189: DEFAULT ar_receipt_api_pub.attribute_rec_const,

185: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
186: p_ussgl_transaction_code IN ar_receivable_applications.
187: ussgl_transaction_code%TYPE DEFAULT NULL,
188: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
189: DEFAULT ar_receipt_api_pub.attribute_rec_const,
190: -- ******* Global Flexfield parameters *******
191: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
192: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
193: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

Line 191: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type

187: ussgl_transaction_code%TYPE DEFAULT NULL,
188: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
189: DEFAULT ar_receipt_api_pub.attribute_rec_const,
190: -- ******* Global Flexfield parameters *******
191: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
192: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
193: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
194:
195: --Multiple Prapayments project, refund of type Credit card or on account

Line 192: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,

188: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
189: DEFAULT ar_receipt_api_pub.attribute_rec_const,
190: -- ******* Global Flexfield parameters *******
191: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
192: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
193: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
194:
195: --Multiple Prapayments project, refund of type Credit card or on account
196: p_refund_type IN VARCHAR2 DEFAULT NULL,

Line 206: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;

202: receivable_application_id%TYPE
203: ) IS
204:
205: l_ra_rec ar_receivable_applications%ROWTYPE;
206: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;
207: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;
208:
209: l_cash_receipt_id NUMBER;
210: l_applied_ps_id NUMBER;

Line 207: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;

203: ) IS
204:
205: l_ra_rec ar_receivable_applications%ROWTYPE;
206: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;
207: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;
208:
209: l_cash_receipt_id NUMBER;
210: l_applied_ps_id NUMBER;
211: l_receivable_application_id NUMBER;

Line 357: ' Calling ar_receipt_api_pub.Unapply_other_account' );

353: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
354:
355: IF PG_DEBUG in ('Y', 'C') THEN
356: arp_util.debug('process_prepayments: ' ||
357: ' Calling ar_receipt_api_pub.Unapply_other_account' );
358: END IF;
359:
360:
361: ar_receipt_api_pub.Unapply_other_account(

Line 361: ar_receipt_api_pub.Unapply_other_account(

357: ' Calling ar_receipt_api_pub.Unapply_other_account' );
358: END IF;
359:
360:
361: ar_receipt_api_pub.Unapply_other_account(
362: --Standard API parameters.
363: p_api_version => p_api_version,
364: p_init_msg_list => p_init_msg_list,
365: p_commit => p_commit ,

Line 395: ' Calling ar_receipt_api_pub.Activity_Application' );

391: l_refund_type = 'CREDIT_CARD' THEN
392:
393: IF PG_DEBUG in ('Y', 'C') THEN
394: arp_util.debug('process_prepayments: ' ||
395: ' Calling ar_receipt_api_pub.Activity_Application' );
396: END IF;
397:
398: -- Issue a credit card Refund
399:

Line 400: ar_receipt_api_pub.Activity_application(

396: END IF;
397:
398: -- Issue a credit card Refund
399:
400: ar_receipt_api_pub.Activity_application(
401: -- Standard API parameters.
402: p_api_version => p_api_version,
403: p_init_msg_list => p_init_msg_list,
404: p_commit => p_commit ,

Line 474: ' Calling ar_receipt_api_pub.Apply_On_Account' );

470:
471:
472: IF PG_DEBUG in ('Y', 'C') THEN
473: arp_util.debug('process_prepayments: ' ||
474: ' Calling ar_receipt_api_pub.Apply_On_Account' );
475: END IF;
476:
477: --put the amount on account
478: ar_receipt_api_pub.Apply_on_account(

Line 478: ar_receipt_api_pub.Apply_on_account(

474: ' Calling ar_receipt_api_pub.Apply_On_Account' );
475: END IF;
476:
477: --put the amount on account
478: ar_receipt_api_pub.Apply_on_account(
479: p_api_version => 1.0,
480: x_return_status => x_return_status,
481: x_msg_count => x_msg_count,
482: x_msg_data => x_msg_data,

Line 503: ar_receipt_api_pub.g_apply_on_account_out_rec.receivable_application_id;

499: -----------------------------------------------------*/
500: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
501:
502: l_on_acc_rec_app_id :=
503: ar_receipt_api_pub.g_apply_on_account_out_rec.receivable_application_id;
504: arp_app_pkg.fetch_p(l_on_acc_rec_app_id, l_ra_refund_rec );
505: l_actual_refund_amount := NVL(l_ra_refund_rec.amount_applied,0);
506: END IF;
507:

Line 601: ar_receipt_api_pub.Apply_other_account(

597:
598: /*----------------------------------------------------
599: Reapply to prepayment
600: -----------------------------------------------------*/
601: ar_receipt_api_pub.Apply_other_account(
602: --Standard API parameters.
603: p_api_version => p_api_version,
604: p_init_msg_list => p_init_msg_list,
605: p_commit => p_commit ,

Line 756: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type

752: p_doc_sequence_value IN NUMBER DEFAULT NULL,
753: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
754: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
755: p_called_from IN VARCHAR2 DEFAULT NULL,
756: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
757: DEFAULT ar_receipt_api_pub.attribute_rec_const,
758: -- ******* Global Flexfield parameters *******
759: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
760: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,

Line 757: DEFAULT ar_receipt_api_pub.attribute_rec_const,

753: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
754: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
755: p_called_from IN VARCHAR2 DEFAULT NULL,
756: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
757: DEFAULT ar_receipt_api_pub.attribute_rec_const,
758: -- ******* Global Flexfield parameters *******
759: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
760: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
761: p_receipt_comments IN VARCHAR2 DEFAULT NULL,

Line 759: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type

755: p_called_from IN VARCHAR2 DEFAULT NULL,
756: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
757: DEFAULT ar_receipt_api_pub.attribute_rec_const,
758: -- ******* Global Flexfield parameters *******
759: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
760: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
761: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
762: -- *** Notes Receivable Additional Information ***
763: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,

Line 760: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,

756: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
757: DEFAULT ar_receipt_api_pub.attribute_rec_const,
758: -- ******* Global Flexfield parameters *******
759: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
760: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
761: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
762: -- *** Notes Receivable Additional Information ***
763: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
764: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,

Line 782: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type

778: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
779: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
780: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
781: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
782: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
783: DEFAULT ar_receipt_api_pub.attribute_rec_const,
784: -- ******* Global Flexfield parameters *******
785: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
786: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,

Line 783: DEFAULT ar_receipt_api_pub.attribute_rec_const,

779: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
780: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
781: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
782: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
783: DEFAULT ar_receipt_api_pub.attribute_rec_const,
784: -- ******* Global Flexfield parameters *******
785: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
786: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
787: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

Line 785: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type

781: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
782: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
783: DEFAULT ar_receipt_api_pub.attribute_rec_const,
784: -- ******* Global Flexfield parameters *******
785: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
786: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
787: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
788: -- processor such as iPayments
789: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,

Line 786: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,

782: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
783: DEFAULT ar_receipt_api_pub.attribute_rec_const,
784: -- ******* Global Flexfield parameters *******
785: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
786: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
787: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
788: -- processor such as iPayments
789: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
790: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,

Line 974: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type

970: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
971: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
972: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
973: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
974: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
975: DEFAULT ar_receipt_api_pub.attribute_rec_const,
976: -- ******* Global Flexfield parameters *******
977: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
978: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,

Line 975: DEFAULT ar_receipt_api_pub.attribute_rec_const,

971: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
972: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
973: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
974: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
975: DEFAULT ar_receipt_api_pub.attribute_rec_const,
976: -- ******* Global Flexfield parameters *******
977: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
978: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
979: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

Line 977: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type

973: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
974: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
975: DEFAULT ar_receipt_api_pub.attribute_rec_const,
976: -- ******* Global Flexfield parameters *******
977: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
978: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
979: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
980: p_payment_set_id IN NUMBER DEFAULT NULL
981: ) IS

Line 978: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,

974: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
975: DEFAULT ar_receipt_api_pub.attribute_rec_const,
976: -- ******* Global Flexfield parameters *******
977: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
978: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
979: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
980: p_payment_set_id IN NUMBER DEFAULT NULL
981: ) IS
982:

Line 1005: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;

1001: l_api_name CONSTANT VARCHAR2(20) := 'Refund_Prepayment';
1002: l_api_version CONSTANT NUMBER := 1.0;
1003:
1004: l_ra_rec ar_receivable_applications%ROWTYPE;
1005: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;
1006: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;
1007:
1008: l_cash_receipt_id NUMBER;
1009: l_applied_ps_id NUMBER;

Line 1006: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;

1002: l_api_version CONSTANT NUMBER := 1.0;
1003:
1004: l_ra_rec ar_receivable_applications%ROWTYPE;
1005: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;
1006: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;
1007:
1008: l_cash_receipt_id NUMBER;
1009: l_applied_ps_id NUMBER;
1010: l_receivable_application_id NUMBER;

Line 1606: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;

1602: l_msg_data VARCHAR2(2000);
1603: l_amount_applied ar_receivable_applications.amount_applied%TYPE := 0;
1604: l_prepay_amount_reapplied ar_receivable_applications.amount_applied%TYPE := 0;
1605: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1606: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;
1607: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;
1608: l_prepayment_exist_flag VARCHAR2(1);
1609: l_complete_applied_flag BOOLEAN := FALSE;
1610:

Line 1607: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;

1603: l_amount_applied ar_receivable_applications.amount_applied%TYPE := 0;
1604: l_prepay_amount_reapplied ar_receivable_applications.amount_applied%TYPE := 0;
1605: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1606: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;
1607: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;
1608: l_prepayment_exist_flag VARCHAR2(1);
1609: l_complete_applied_flag BOOLEAN := FALSE;
1610:
1611: BEGIN

Line 1654: ar_receipt_api_pub.Unapply_other_account(

1650:
1651: p_cash_receipt_id := prepayapp_rec.cash_receipt_id;
1652:
1653: --Unapply the prepayment
1654: ar_receipt_api_pub.Unapply_other_account(
1655: --Standard API parameters.
1656: p_api_version => 1.0,
1657: x_return_status => l_return_status,
1658: x_msg_count => l_msg_count,

Line 1683: ar_receipt_api_pub.Apply(p_api_version => l_api_version,

1679: l_amount_applied := NVL(prepayapp_rec.amount_applied,0);
1680: END IF;
1681:
1682: --Apply to invoice
1683: ar_receipt_api_pub.Apply(p_api_version => l_api_version,
1684: x_return_status => l_return_status,
1685: x_msg_count => l_msg_count,
1686: x_msg_data => l_msg_data,
1687: p_cash_receipt_id => prepayapp_rec.cash_receipt_id,

Line 1751: ar_receipt_api_pub.Apply_other_account(

1747: l_global_attribute_rec.global_attribute18 := prepayapp_rec.global_attribute18;
1748: l_global_attribute_rec.global_attribute19 := prepayapp_rec.global_attribute19;
1749: l_global_attribute_rec.global_attribute20 := prepayapp_rec.global_attribute20;
1750:
1751: ar_receipt_api_pub.Apply_other_account(
1752: -- Standard API parameters.
1753: p_api_version => l_api_version,
1754: x_return_status => l_return_status,
1755: x_msg_count => l_msg_count,