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 2732: --l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;

2728: p_site_use_id IN NUMBER DEFAULT NULL,
2729: p_receipt_date IN DATE DEFAULT trunc(SYSDATE),
2730: p_payment_type IN varchar2 DEFAULT NULL,
2731: p_lookup_code IN varchar2 DEFAULT NULL) IS
2732: --l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;
2733:
2734: l_total_service_charge NUMBER;
2735: l_count NUMBER;
2736: l_payment_amount NUMBER;

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

4000: | HISTORY
4001: | 26-APR-2004 vnb Bug # 3467287 - Added Customer and Customer Site
4002: | as input parameters.
4003: | 19-JUL-2004 vnb Bug # 2830823 - Added exception block to handle exceptions
4004: | 21-SEP-2004 vnb Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
4005: | 22-Mar-2010 nkanchan Bug 8293098 - Service change based on credit card types
4006: |
4007: +=====================================================================*/
4008: FUNCTION get_service_charge ( p_customer_id IN NUMBER,

Line 4014: l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;

4010: p_payment_type IN varchar2 DEFAULT NULL,
4011: p_lookup_code IN varchar2 DEFAULT NULL)
4012: RETURN NUMBER IS
4013:
4014: l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;
4015: l_total_service_charge NUMBER;
4016: l_count NUMBER;
4017: l_currency_code AR_IREC_PAYMENT_LIST_GT.currency_code%TYPE;
4018: l_service_charge NUMBER;

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

4020: l_procedure_name VARCHAR2(30);
4021: l_debug_info VARCHAR2(200);
4022:
4023: --Bug # 3467287 - The Global Temp table must be striped by Customer and Customer Site.
4024: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
4025: CURSOR invoice_list IS
4026: SELECT payment_schedule_id,
4027: payment_amt as payment_amount,
4028: customer_id,

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

4076:
4077: l_invoice_list(l_count).payment_schedule_id := invoice_rec.payment_schedule_id;
4078: l_invoice_list(l_count).payment_amount := invoice_rec.payment_amount;
4079: l_invoice_list(l_count).customer_id := invoice_rec.customer_id;
4080: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
4081: l_invoice_list(l_count).customer_site_use_id:= invoice_rec.customer_site_use_id;
4082: l_invoice_list(l_count).account_number := invoice_rec.account_number;
4083: l_invoice_list(l_count).customer_trx_id := invoice_rec.customer_trx_id;
4084: l_invoice_list(l_count).currency_code := invoice_rec.currency_code;

Line 4114: ARI_SERVICE_CHARGE_PKG.compute_service_charge(l_invoice_list, p_payment_type, p_lookup_code);

4110: -----------------------------------------------------------------------------------------
4111: IF (PG_DEBUG = 'Y') THEN
4112: arp_standard.debug(l_debug_info);
4113: END IF;
4114: ARI_SERVICE_CHARGE_PKG.compute_service_charge(l_invoice_list, p_payment_type, p_lookup_code);
4115:
4116: l_count := l_invoice_list.FIRST;
4117:
4118: WHILE l_count IS NOT NULL

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

4182: | HISTORY
4183: | 26-APR-2004 vnb Bug # 3467287 - Added Customer and Customer Site
4184: | as input parameters.
4185: | 19-JUL-2004 vnb Bug # 2830823 - Added exception block to handle exceptions
4186: | 21-SEP-2004 vnb Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
4187: |
4188: +=====================================================================*/
4189: PROCEDURE apply_service_charge ( p_customer_id IN NUMBER,
4190: p_site_use_id IN NUMBER DEFAULT NULL,

Line 4193: l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;

4189: PROCEDURE apply_service_charge ( p_customer_id IN NUMBER,
4190: p_site_use_id IN NUMBER DEFAULT NULL,
4191: x_return_status OUT NOCOPY VARCHAR2) IS
4192:
4193: l_invoice_list ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE;
4194: l_total_service_charge NUMBER;
4195: l_count NUMBER;
4196: l_return_status VARCHAR2(2);
4197: l_procedure_name VARCHAR2(50);

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

4197: l_procedure_name VARCHAR2(50);
4198: l_debug_info VARCHAR2(200);
4199:
4200: --Bug # 3467287 - The Global Temp table must be striped by Customer and Customer Site.
4201: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
4202: CURSOR invoice_list IS
4203: SELECT payment_schedule_id,
4204: payment_amt as payment_amount,
4205: customer_id,

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

4250: end if;
4251: l_invoice_list(l_count).payment_schedule_id := invoice_rec.payment_schedule_id;
4252: l_invoice_list(l_count).payment_amount := invoice_rec.payment_amount;
4253: l_invoice_list(l_count).customer_id := invoice_rec.customer_id;
4254: --Bug # 3886652 - Added customer site use id to ARI_SERVICE_CHARGE_PKG.INVOICE_LIST_TABTYPE
4255: l_invoice_list(l_count).customer_site_use_id := invoice_rec.customer_site_use_id;
4256: l_invoice_list(l_count).account_number := invoice_rec.account_number;
4257: l_invoice_list(l_count).customer_trx_id := invoice_rec.customer_trx_id;
4258: l_invoice_list(l_count).currency_code := invoice_rec.currency_code;

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

4279: -- Call the service charge compute package
4280: ----------------------------------------------------------------------------------
4281: l_debug_info := 'Apply service charge';
4282: ----------------------------------------------------------------------------------
4283: l_return_status := ARI_SERVICE_CHARGE_PKG.apply_charge(l_invoice_list);
4284:
4285: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4286: -- bug 3672530 - Ensure graceful error handling
4287: x_return_status := FND_API.G_RET_STS_ERROR;