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.ARP_PROCESS_RETURNS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 34: p_ra_rec IN ar_receivable_applications%rowtype);

30: x_refund_amount OUT NOCOPY NUMBER,
31: x_rec_proc_option IN VARCHAR2);
32: --
33: PROCEDURE add_ra_to_list(p_ra_info IN app_info_type,
34: p_ra_rec IN ar_receivable_applications%rowtype);
35: --
36: PROCEDURE populate_dff_and_gdf(p_ra_rec IN ar_receivable_applications%rowtype,
37: x_dff_rec OUT NOCOPY
38: ar_receipt_api_pub.attribute_rec_type,

Line 36: PROCEDURE populate_dff_and_gdf(p_ra_rec IN ar_receivable_applications%rowtype,

32: --
33: PROCEDURE add_ra_to_list(p_ra_info IN app_info_type,
34: p_ra_rec IN ar_receivable_applications%rowtype);
35: --
36: PROCEDURE populate_dff_and_gdf(p_ra_rec IN ar_receivable_applications%rowtype,
37: x_dff_rec OUT NOCOPY
38: ar_receipt_api_pub.attribute_rec_type,
39: x_gdf_rec OUT NOCOPY
40: ar_receipt_api_pub.global_attribute_rec_type);

Line 425: l_app_comments ar_receivable_applications.comments%type :=

421: l_rid_reason VARCHAR2(2000):= null;
422: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
423: l_msg_count NUMBER;
424: l_msg_data VARCHAR2(2000);
425: l_app_comments ar_receivable_applications.comments%type :=
426: arp_standard.fnd_message('AR_RID_PROCESSED_AS_PER_REQ');
427: l_application_ref_type ar_receivable_applications.application_ref_type%type;
428: l_application_ref_id ar_receivable_applications.application_ref_id%type;
429: l_application_ref_num ar_receivable_applications.application_ref_num%type;

Line 427: l_application_ref_type ar_receivable_applications.application_ref_type%type;

423: l_msg_count NUMBER;
424: l_msg_data VARCHAR2(2000);
425: l_app_comments ar_receivable_applications.comments%type :=
426: arp_standard.fnd_message('AR_RID_PROCESSED_AS_PER_REQ');
427: l_application_ref_type ar_receivable_applications.application_ref_type%type;
428: l_application_ref_id ar_receivable_applications.application_ref_id%type;
429: l_application_ref_num ar_receivable_applications.application_ref_num%type;
430: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
431: l_new_ra_rec ar_receivable_applications%rowtype;

Line 428: l_application_ref_id ar_receivable_applications.application_ref_id%type;

424: l_msg_data VARCHAR2(2000);
425: l_app_comments ar_receivable_applications.comments%type :=
426: arp_standard.fnd_message('AR_RID_PROCESSED_AS_PER_REQ');
427: l_application_ref_type ar_receivable_applications.application_ref_type%type;
428: l_application_ref_id ar_receivable_applications.application_ref_id%type;
429: l_application_ref_num ar_receivable_applications.application_ref_num%type;
430: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
431: l_new_ra_rec ar_receivable_applications%rowtype;
432: l_refunding BOOLEAN:=FALSE;

Line 429: l_application_ref_num ar_receivable_applications.application_ref_num%type;

425: l_app_comments ar_receivable_applications.comments%type :=
426: arp_standard.fnd_message('AR_RID_PROCESSED_AS_PER_REQ');
427: l_application_ref_type ar_receivable_applications.application_ref_type%type;
428: l_application_ref_id ar_receivable_applications.application_ref_id%type;
429: l_application_ref_num ar_receivable_applications.application_ref_num%type;
430: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
431: l_new_ra_rec ar_receivable_applications%rowtype;
432: l_refunding BOOLEAN:=FALSE;
433: l_gdf_rec ar_receipt_api_pub.global_attribute_rec_type;

Line 430: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;

426: arp_standard.fnd_message('AR_RID_PROCESSED_AS_PER_REQ');
427: l_application_ref_type ar_receivable_applications.application_ref_type%type;
428: l_application_ref_id ar_receivable_applications.application_ref_id%type;
429: l_application_ref_num ar_receivable_applications.application_ref_num%type;
430: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
431: l_new_ra_rec ar_receivable_applications%rowtype;
432: l_refunding BOOLEAN:=FALSE;
433: l_gdf_rec ar_receipt_api_pub.global_attribute_rec_type;
434: l_dff_rec ar_receipt_api_pub.attribute_rec_type;

Line 431: l_new_ra_rec ar_receivable_applications%rowtype;

427: l_application_ref_type ar_receivable_applications.application_ref_type%type;
428: l_application_ref_id ar_receivable_applications.application_ref_id%type;
429: l_application_ref_num ar_receivable_applications.application_ref_num%type;
430: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
431: l_new_ra_rec ar_receivable_applications%rowtype;
432: l_refunding BOOLEAN:=FALSE;
433: l_gdf_rec ar_receipt_api_pub.global_attribute_rec_type;
434: l_dff_rec ar_receipt_api_pub.attribute_rec_type;
435: l_party_id hz_parties.party_id%type;

Line 1007: ar_receivable_applications ra

1003: 'ON-ACCOUNT') rec_proc_option,
1004: ra.amount_applied,
1005: ra.amount_applied_from
1006: FROM
1007: ar_receivable_applications ra
1008: ,ar_cash_receipts cr
1009: ,ar_receipt_methods rm
1010: ,ra_customer_trx inv
1011: WHERE

Line 1026: l_application_ref_type ar_receivable_applications.application_ref_type%type;

1022: ra.amount_applied)) desc,
1023: ra.amount_applied desc;
1024:
1025: -- Local Variables
1026: l_application_ref_type ar_receivable_applications.application_ref_type%type;
1027: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1028: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1029: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1030: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;

Line 1027: l_application_ref_id ar_receivable_applications.application_ref_id%type;

1023: ra.amount_applied desc;
1024:
1025: -- Local Variables
1026: l_application_ref_type ar_receivable_applications.application_ref_type%type;
1027: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1028: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1029: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1030: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1031: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;

Line 1028: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;

1024:
1025: -- Local Variables
1026: l_application_ref_type ar_receivable_applications.application_ref_type%type;
1027: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1028: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1029: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1030: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1031: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;
1032: l_app_comments ar_receivable_applications.comments%type;

Line 1029: l_application_ref_num ar_receivable_applications.application_ref_num%type;

1025: -- Local Variables
1026: l_application_ref_type ar_receivable_applications.application_ref_type%type;
1027: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1028: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1029: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1030: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1031: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;
1032: l_app_comments ar_receivable_applications.comments%type;
1033:

Line 1030: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;

1026: l_application_ref_type ar_receivable_applications.application_ref_type%type;
1027: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1028: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1029: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1030: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1031: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;
1032: l_app_comments ar_receivable_applications.comments%type;
1033:
1034: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1031: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;

1027: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1028: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1029: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1030: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1031: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;
1032: l_app_comments ar_receivable_applications.comments%type;
1033:
1034: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1035: l_msg_count NUMBER;

Line 1032: l_app_comments ar_receivable_applications.comments%type;

1028: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1029: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1030: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1031: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;
1032: l_app_comments ar_receivable_applications.comments%type;
1033:
1034: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1035: l_msg_count NUMBER;
1036: l_msg_data VARCHAR2(2000);

Line 1038: l_unapp_amt_remaining ar_receivable_applications.amount_applied%type;

1034: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1035: l_msg_count NUMBER;
1036: l_msg_data VARCHAR2(2000);
1037: l_rid_reason VARCHAR2(2000);
1038: l_unapp_amt_remaining ar_receivable_applications.amount_applied%type;
1039: l_unapp_amount ar_receivable_applications.amount_applied%type;
1040: l_ra_rec ar_receivable_applications%rowtype;
1041: l_unapply_failed EXCEPTION;
1042: l_apply_failed EXCEPTION;

Line 1039: l_unapp_amount ar_receivable_applications.amount_applied%type;

1035: l_msg_count NUMBER;
1036: l_msg_data VARCHAR2(2000);
1037: l_rid_reason VARCHAR2(2000);
1038: l_unapp_amt_remaining ar_receivable_applications.amount_applied%type;
1039: l_unapp_amount ar_receivable_applications.amount_applied%type;
1040: l_ra_rec ar_receivable_applications%rowtype;
1041: l_unapply_failed EXCEPTION;
1042: l_apply_failed EXCEPTION;
1043: l_activity_app_failed EXCEPTION;

Line 1040: l_ra_rec ar_receivable_applications%rowtype;

1036: l_msg_data VARCHAR2(2000);
1037: l_rid_reason VARCHAR2(2000);
1038: l_unapp_amt_remaining ar_receivable_applications.amount_applied%type;
1039: l_unapp_amount ar_receivable_applications.amount_applied%type;
1040: l_ra_rec ar_receivable_applications%rowtype;
1041: l_unapply_failed EXCEPTION;
1042: l_apply_failed EXCEPTION;
1043: l_activity_app_failed EXCEPTION;
1044: l_on_account_app_failed EXCEPTION;

Line 1250: p_ra_rec IN ar_receivable_applications%rowtype) AS

1246: -- which will be used for further processing
1247: --
1248:
1249: PROCEDURE add_ra_to_list(p_ra_info IN app_info_type,
1250: p_ra_rec IN ar_receivable_applications%rowtype) AS
1251: l_cnt NUMBER := app_info.COUNT;
1252: BEGIN
1253: --
1254: IF PG_DEBUG in ('Y', 'C') THEN

Line 1338: FROM AR_RECEIVABLE_APPLICATIONS ra,

1334: sum(DECODE(rm.payment_channel_code, 'CREDIT_CARD', 1, 0))
1335: INTO
1336: l_total_payment_types,
1337: l_total_cc_pmts
1338: FROM AR_RECEIVABLE_APPLICATIONS ra,
1339: ar_cash_receipts cr,
1340: ar_receipt_methods rm
1341: WHERE ra.applied_customer_trx_id = p_inv_customer_trx_id
1342: AND ra.cash_receipt_id = cr.cash_receipt_id

Line 1389: FROM ar_cash_receipts cr, ar_receivable_applications ra

1385: IF x_rec_proc_option = 'REFUND' THEN
1386:
1387: SELECT NVL(amount, 0), NVL(SUM(amount_applied) , 0)
1388: INTO x_receipt_amount, x_refund_amount
1389: FROM ar_cash_receipts cr, ar_receivable_applications ra
1390: WHERE cr.cash_receipt_id = p_cash_receipt_id
1391: AND cr.cash_receipt_id = ra.cash_receipt_id(+)
1392: AND ra.applied_payment_schedule_id(+) = -6
1393: AND ra.display(+) = 'Y'

Line 1399: FROM ar_cash_receipts cr, ar_receivable_applications ra

1395:
1396: ELSIF x_rec_proc_option = 'PAY_REFUND' THEN
1397: SELECT NVL(amount, 0), NVL(SUM(amount_applied) , 0)
1398: INTO x_receipt_amount, x_refund_amount
1399: FROM ar_cash_receipts cr, ar_receivable_applications ra
1400: WHERE cr.cash_receipt_id = p_cash_receipt_id
1401: AND cr.cash_receipt_id = ra.cash_receipt_id(+)
1402: AND ra.applied_payment_schedule_id(+) = -8
1403: AND ra.display(+) = 'Y'

Line 1545: FROM ar_receivable_applications ra

1541: WHERE
1542: EXISTS
1543: (
1544: SELECT 1
1545: FROM ar_receivable_applications ra
1546: WHERE ra.cash_receipt_id = p_cash_receipt_id
1547: AND applied_payment_schedule_id IN (-4, -5)
1548: AND display = 'Y'
1549: );

Line 1642: from ar_receivable_applications app,

1638: END IF;
1639: ---
1640: select count(*)
1641: into l_count
1642: from ar_receivable_applications app,
1643: ra_customer_trx oncm
1644: where app.applied_customer_trx_id = p_customer_trx_id
1645: and app.status = 'APP'
1646: and app.application_type = 'CM'

Line 1698: from ar_receivable_applications app

1694: END IF;
1695: ---
1696: select count(*)
1697: into l_count
1698: from ar_receivable_applications app
1699: where app.applied_customer_trx_id = p_customer_trx_id
1700: and app.status = 'APP'
1701: and app.application_type = 'CASH'
1702: and app.display = 'Y'

Line 1797: PROCEDURE populate_dff_and_gdf(p_ra_rec IN ar_receivable_applications%rowtype,

1793: | MODIFICATION HISTORY |
1794: | 27-Jul-03 Ramakant Alat Created |
1795: +===========================================================================*/
1796:
1797: PROCEDURE populate_dff_and_gdf(p_ra_rec IN ar_receivable_applications%rowtype,
1798: x_dff_rec OUT NOCOPY
1799: ar_receipt_api_pub.attribute_rec_type,
1800: x_gdf_rec OUT NOCOPY
1801: ar_receipt_api_pub.global_attribute_rec_type)

Line 1888: l_total_amount ar_receivable_applications.amount_applied%type:=0;

1884: FUNCTION get_amount_applied(p_customer_trx_id IN NUMBER,
1885: p_line_type IN VARCHAR2)
1886: RETURN NUMBER IS
1887:
1888: l_total_amount ar_receivable_applications.amount_applied%type:=0;
1889: l_amt_app_rec amt_app_type;
1890:
1891: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1892: l_tax_amount ar_receivable_applications.amount_applied%type:=0;

Line 1891: l_line_amount ar_receivable_applications.amount_applied%type:=0;

1887:
1888: l_total_amount ar_receivable_applications.amount_applied%type:=0;
1889: l_amt_app_rec amt_app_type;
1890:
1891: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1892: l_tax_amount ar_receivable_applications.amount_applied%type:=0;
1893: l_frt_amount ar_receivable_applications.amount_applied%type:=0;
1894: l_charges_amount ar_receivable_applications.amount_applied%type:=0;
1895: l_applied_amount ar_receivable_applications.amount_applied%type:=0;

Line 1892: l_tax_amount ar_receivable_applications.amount_applied%type:=0;

1888: l_total_amount ar_receivable_applications.amount_applied%type:=0;
1889: l_amt_app_rec amt_app_type;
1890:
1891: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1892: l_tax_amount ar_receivable_applications.amount_applied%type:=0;
1893: l_frt_amount ar_receivable_applications.amount_applied%type:=0;
1894: l_charges_amount ar_receivable_applications.amount_applied%type:=0;
1895: l_applied_amount ar_receivable_applications.amount_applied%type:=0;
1896:

Line 1893: l_frt_amount ar_receivable_applications.amount_applied%type:=0;

1889: l_amt_app_rec amt_app_type;
1890:
1891: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1892: l_tax_amount ar_receivable_applications.amount_applied%type:=0;
1893: l_frt_amount ar_receivable_applications.amount_applied%type:=0;
1894: l_charges_amount ar_receivable_applications.amount_applied%type:=0;
1895: l_applied_amount ar_receivable_applications.amount_applied%type:=0;
1896:
1897: BEGIN

Line 1894: l_charges_amount ar_receivable_applications.amount_applied%type:=0;

1890:
1891: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1892: l_tax_amount ar_receivable_applications.amount_applied%type:=0;
1893: l_frt_amount ar_receivable_applications.amount_applied%type:=0;
1894: l_charges_amount ar_receivable_applications.amount_applied%type:=0;
1895: l_applied_amount ar_receivable_applications.amount_applied%type:=0;
1896:
1897: BEGIN
1898: ---

Line 1895: l_applied_amount ar_receivable_applications.amount_applied%type:=0;

1891: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1892: l_tax_amount ar_receivable_applications.amount_applied%type:=0;
1893: l_frt_amount ar_receivable_applications.amount_applied%type:=0;
1894: l_charges_amount ar_receivable_applications.amount_applied%type:=0;
1895: l_applied_amount ar_receivable_applications.amount_applied%type:=0;
1896:
1897: BEGIN
1898: ---
1899: IF PG_DEBUG in ('Y', 'C') THEN

Line 1939: ar_receivable_applications

1935: l_frt_amount,
1936: l_charges_amount,
1937: l_applied_amount
1938: FROM
1939: ar_receivable_applications
1940: WHERE
1941: applied_customer_trx_id = p_customer_trx_id
1942: AND application_type = 'CASH' -- Consider only receipt applications
1943: AND display = 'Y';