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

APPS.AR_IREC_PAYMENTS dependencies on ARI_SERVICE_CHARGE_PKG

Line 2599: --l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;

2595: +============================================================*/
2596: PROCEDURE cal_discount_and_service_chrg (p_customer_id IN NUMBER,
2597: p_site_use_id IN NUMBER DEFAULT NULL,
2598: p_receipt_date IN DATE DEFAULT trunc(SYSDATE)) IS
2599: --l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;
2600:
2601: l_total_service_charge NUMBER;
2602: l_count NUMBER;
2603: l_payment_amount NUMBER;

Line 3532: | 21-SEP-2004 vnb Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE

3528: | HISTORY
3529: | 26-APR-2004 vnb Bug # 3467287 - Added Customer and Customer Site
3530: | as input parameters.
3531: | 19-JUL-2004 vnb Bug # 2830823 - Added exception block to handle exceptions
3532: | 21-SEP-2004 vnb Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
3533: |
3534: +=====================================================================*/
3535: FUNCTION get_service_charge ( p_customer_id IN NUMBER,
3536: p_site_use_id IN NUMBER DEFAULT NULL)

Line 3539: l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;

3535: FUNCTION get_service_charge ( p_customer_id IN NUMBER,
3536: p_site_use_id IN NUMBER DEFAULT NULL)
3537: RETURN NUMBER IS
3538:
3539: l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;
3540: l_total_service_charge NUMBER;
3541: l_count NUMBER;
3542: l_currency_code AR_IREC_PAYMENT_LIST_GT.currency_code%TYPE;
3543: l_service_charge NUMBER;

Line 3549: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE

3545: l_procedure_name VARCHAR2(30);
3546: l_debug_info VARCHAR2(200);
3547:
3548: --Bug # 3467287 - The Global Temp table must be striped by Customer and Customer Site.
3549: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
3550: CURSOR invoice_list IS
3551: SELECT payment_schedule_id,
3552: payment_amt as payment_amount,
3553: customer_id,

Line 3601: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE

3597:
3598: l_invoice_list(l_count).payment_schedule_id := invoice_rec.payment_schedule_id;
3599: l_invoice_list(l_count).payment_amount := invoice_rec.payment_amount;
3600: l_invoice_list(l_count).customer_id := invoice_rec.customer_id;
3601: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
3602: l_invoice_list(l_count).customer_site_use_id:= invoice_rec.customer_site_use_id;
3603: l_invoice_list(l_count).account_number := invoice_rec.account_number;
3604: l_invoice_list(l_count).customer_trx_id := invoice_rec.customer_trx_id;
3605: l_invoice_list(l_count).currency_code := invoice_rec.currency_code;

Line 3622: ARI_SERVICE_CHARGE_PKG.compute_service_charge(l_invoice_list);

3618: -----------------------------------------------------------------------------------------
3619: IF (PG_DEBUG = 'Y') THEN
3620: arp_standard.debug(l_debug_info);
3621: END IF;
3622: ARI_SERVICE_CHARGE_PKG.compute_service_charge(l_invoice_list);
3623:
3624: l_count := l_invoice_list.FIRST;
3625:
3626: WHILE l_count IS NOT NULL

Line 3694: | 21-SEP-2004 vnb Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE

3690: | HISTORY
3691: | 26-APR-2004 vnb Bug # 3467287 - Added Customer and Customer Site
3692: | as input parameters.
3693: | 19-JUL-2004 vnb Bug # 2830823 - Added exception block to handle exceptions
3694: | 21-SEP-2004 vnb Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
3695: |
3696: +=====================================================================*/
3697: PROCEDURE apply_service_charge ( p_customer_id IN NUMBER,
3698: p_site_use_id IN NUMBER DEFAULT NULL,

Line 3701: l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;

3697: PROCEDURE apply_service_charge ( p_customer_id IN NUMBER,
3698: p_site_use_id IN NUMBER DEFAULT NULL,
3699: x_return_status OUT NOCOPY VARCHAR2) IS
3700:
3701: l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;
3702: l_total_service_charge NUMBER;
3703: l_count NUMBER;
3704: l_return_status VARCHAR2(2);
3705: l_procedure_name VARCHAR2(50);

Line 3709: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE

3705: l_procedure_name VARCHAR2(50);
3706: l_debug_info VARCHAR2(200);
3707:
3708: --Bug # 3467287 - The Global Temp table must be striped by Customer and Customer Site.
3709: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
3710: CURSOR invoice_list IS
3711: SELECT payment_schedule_id,
3712: payment_amt as payment_amount,
3713: customer_id,

Line 3756: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE

3752: end if;
3753: l_invoice_list(l_count).payment_schedule_id := invoice_rec.payment_schedule_id;
3754: l_invoice_list(l_count).payment_amount := invoice_rec.payment_amount;
3755: l_invoice_list(l_count).customer_id := invoice_rec.customer_id;
3756: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
3757: l_invoice_list(l_count).customer_site_use_id := invoice_rec.customer_site_use_id;
3758: l_invoice_list(l_count).account_number := invoice_rec.account_number;
3759: l_invoice_list(l_count).customer_trx_id := invoice_rec.customer_trx_id;
3760: l_invoice_list(l_count).currency_code := invoice_rec.currency_code;

Line 3770: l_return_status := ARI_SERVICE_CHARGE_PKG.apply_charge(l_invoice_list);

3766: -- Call the service charge compute package
3767: ----------------------------------------------------------------------------------
3768: l_debug_info := 'Apply service charge';
3769: ----------------------------------------------------------------------------------
3770: l_return_status := ARI_SERVICE_CHARGE_PKG.apply_charge(l_invoice_list);
3771:
3772: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3773: -- bug 3672530 - Ensure graceful error handling
3774: x_return_status := FND_API.G_RET_STS_ERROR;