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 42: PROCEDURE fetch_gl_date( p_ra_rec IN ar_receivable_applications%rowtype,

38: ar_receipt_api_pub.attribute_rec_type,
39: x_gdf_rec OUT NOCOPY
40: ar_receipt_api_pub.global_attribute_rec_type);
41: --
42: PROCEDURE fetch_gl_date( p_ra_rec IN ar_receivable_applications%rowtype,
43: p_gl_date OUT NOCOPY DATE);
44: --
45: PROCEDURE initialize_globals IS
46: BEGIN

Line 428: l_app_comments ar_receivable_applications.comments%type :=

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

Line 430: l_application_ref_type ar_receivable_applications.application_ref_type%type;

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

Line 431: l_application_ref_id ar_receivable_applications.application_ref_id%type;

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

Line 432: l_application_ref_num ar_receivable_applications.application_ref_num%type;

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

Line 433: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;

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

Line 434: l_new_ra_rec ar_receivable_applications%rowtype;

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

Line 1021: ar_receivable_applications ra

1017: 'ON-ACCOUNT') rec_proc_option,
1018: ra.amount_applied,
1019: ra.amount_applied_from
1020: FROM
1021: ar_receivable_applications ra
1022: ,ar_cash_receipts cr
1023: ,ar_receipt_methods rm
1024: ,ra_customer_trx inv
1025: WHERE

Line 1040: l_application_ref_type ar_receivable_applications.application_ref_type%type;

1036: ra.amount_applied)) desc,
1037: ra.amount_applied desc;
1038:
1039: -- Local Variables
1040: l_application_ref_type ar_receivable_applications.application_ref_type%type;
1041: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1042: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1043: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1044: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;

Line 1041: l_application_ref_id ar_receivable_applications.application_ref_id%type;

1037: ra.amount_applied desc;
1038:
1039: -- Local Variables
1040: l_application_ref_type ar_receivable_applications.application_ref_type%type;
1041: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1042: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1043: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1044: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1045: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;

Line 1042: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;

1038:
1039: -- Local Variables
1040: l_application_ref_type ar_receivable_applications.application_ref_type%type;
1041: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1042: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1043: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1044: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1045: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;
1046: l_app_comments ar_receivable_applications.comments%type;

Line 1043: l_application_ref_num ar_receivable_applications.application_ref_num%type;

1039: -- Local Variables
1040: l_application_ref_type ar_receivable_applications.application_ref_type%type;
1041: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1042: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1043: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1044: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1045: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;
1046: l_app_comments ar_receivable_applications.comments%type;
1047:

Line 1044: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;

1040: l_application_ref_type ar_receivable_applications.application_ref_type%type;
1041: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1042: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1043: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1044: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1045: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;
1046: l_app_comments ar_receivable_applications.comments%type;
1047:
1048: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1045: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;

1041: l_application_ref_id ar_receivable_applications.application_ref_id%type;
1042: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1043: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1044: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1045: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;
1046: l_app_comments ar_receivable_applications.comments%type;
1047:
1048: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1049: l_msg_count NUMBER;

Line 1046: l_app_comments ar_receivable_applications.comments%type;

1042: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%type;
1043: l_application_ref_num ar_receivable_applications.application_ref_num%type;
1044: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;
1045: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%type;
1046: l_app_comments ar_receivable_applications.comments%type;
1047:
1048: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1049: l_msg_count NUMBER;
1050: l_msg_data VARCHAR2(2000);

Line 1052: l_unapp_amt_remaining ar_receivable_applications.amount_applied%type;

1048: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1049: l_msg_count NUMBER;
1050: l_msg_data VARCHAR2(2000);
1051: l_rid_reason VARCHAR2(2000);
1052: l_unapp_amt_remaining ar_receivable_applications.amount_applied%type;
1053: l_unapp_amount ar_receivable_applications.amount_applied%type;
1054: l_ra_rec ar_receivable_applications%rowtype;
1055: l_unapply_failed EXCEPTION;
1056: l_apply_failed EXCEPTION;

Line 1053: l_unapp_amount ar_receivable_applications.amount_applied%type;

1049: l_msg_count NUMBER;
1050: l_msg_data VARCHAR2(2000);
1051: l_rid_reason VARCHAR2(2000);
1052: l_unapp_amt_remaining ar_receivable_applications.amount_applied%type;
1053: l_unapp_amount ar_receivable_applications.amount_applied%type;
1054: l_ra_rec ar_receivable_applications%rowtype;
1055: l_unapply_failed EXCEPTION;
1056: l_apply_failed EXCEPTION;
1057: l_activity_app_failed EXCEPTION;

Line 1054: l_ra_rec ar_receivable_applications%rowtype;

1050: l_msg_data VARCHAR2(2000);
1051: l_rid_reason VARCHAR2(2000);
1052: l_unapp_amt_remaining ar_receivable_applications.amount_applied%type;
1053: l_unapp_amount ar_receivable_applications.amount_applied%type;
1054: l_ra_rec ar_receivable_applications%rowtype;
1055: l_unapply_failed EXCEPTION;
1056: l_apply_failed EXCEPTION;
1057: l_activity_app_failed EXCEPTION;
1058: l_on_account_app_failed EXCEPTION;

Line 1278: p_ra_rec IN ar_receivable_applications%rowtype) AS

1274: -- which will be used for further processing
1275: --
1276:
1277: PROCEDURE add_ra_to_list(p_ra_info IN app_info_type,
1278: p_ra_rec IN ar_receivable_applications%rowtype) AS
1279: l_cnt NUMBER := app_info.COUNT;
1280: BEGIN
1281: --
1282: IF PG_DEBUG in ('Y', 'C') THEN

Line 1366: FROM AR_RECEIVABLE_APPLICATIONS ra,

1362: sum(DECODE(rm.payment_channel_code, 'CREDIT_CARD', 1, 0))
1363: INTO
1364: l_total_payment_types,
1365: l_total_cc_pmts
1366: FROM AR_RECEIVABLE_APPLICATIONS ra,
1367: ar_cash_receipts cr,
1368: ar_receipt_methods rm
1369: WHERE ra.applied_customer_trx_id = p_inv_customer_trx_id
1370: AND ra.cash_receipt_id = cr.cash_receipt_id

Line 1417: FROM ar_cash_receipts cr, ar_receivable_applications ra

1413: IF x_rec_proc_option = 'REFUND' THEN
1414:
1415: SELECT NVL(amount, 0), NVL(SUM(amount_applied) , 0)
1416: INTO x_receipt_amount, x_refund_amount
1417: FROM ar_cash_receipts cr, ar_receivable_applications ra
1418: WHERE cr.cash_receipt_id = p_cash_receipt_id
1419: AND cr.cash_receipt_id = ra.cash_receipt_id(+)
1420: AND ra.applied_payment_schedule_id(+) = -6
1421: AND ra.display(+) = 'Y'

Line 1427: FROM ar_cash_receipts cr, ar_receivable_applications ra

1423:
1424: ELSIF x_rec_proc_option = 'PAY_REFUND' THEN
1425: SELECT NVL(amount, 0), NVL(SUM(amount_applied) , 0)
1426: INTO x_receipt_amount, x_refund_amount
1427: FROM ar_cash_receipts cr, ar_receivable_applications ra
1428: WHERE cr.cash_receipt_id = p_cash_receipt_id
1429: AND cr.cash_receipt_id = ra.cash_receipt_id(+)
1430: AND ra.applied_payment_schedule_id(+) = -8
1431: AND ra.display(+) = 'Y'

Line 1573: FROM ar_receivable_applications ra

1569: WHERE
1570: EXISTS
1571: (
1572: SELECT 1
1573: FROM ar_receivable_applications ra
1574: WHERE ra.cash_receipt_id = p_cash_receipt_id
1575: AND applied_payment_schedule_id IN (-4, -5)
1576: AND display = 'Y'
1577: );

Line 1670: from ar_receivable_applications app,

1666: END IF;
1667: ---
1668: select count(*)
1669: into l_count
1670: from ar_receivable_applications app,
1671: ra_customer_trx oncm
1672: where app.applied_customer_trx_id = p_customer_trx_id
1673: and app.status = 'APP'
1674: and app.application_type = 'CM'

Line 1726: from ar_receivable_applications app

1722: END IF;
1723: ---
1724: select count(*)
1725: into l_count
1726: from ar_receivable_applications app
1727: where app.applied_customer_trx_id = p_customer_trx_id
1728: and app.status = 'APP'
1729: and app.application_type = 'CASH'
1730: and app.display = 'Y'

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

1821: | MODIFICATION HISTORY |
1822: | 27-Jul-03 Ramakant Alat Created |
1823: +===========================================================================*/
1824:
1825: PROCEDURE populate_dff_and_gdf(p_ra_rec IN ar_receivable_applications%rowtype,
1826: x_dff_rec OUT NOCOPY
1827: ar_receipt_api_pub.attribute_rec_type,
1828: x_gdf_rec OUT NOCOPY
1829: ar_receipt_api_pub.global_attribute_rec_type)

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

1912: FUNCTION get_amount_applied(p_customer_trx_id IN NUMBER,
1913: p_line_type IN VARCHAR2)
1914: RETURN NUMBER IS
1915:
1916: l_total_amount ar_receivable_applications.amount_applied%type:=0;
1917: l_amt_app_rec amt_app_type;
1918:
1919: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1920: l_tax_amount ar_receivable_applications.amount_applied%type:=0;

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

1915:
1916: l_total_amount ar_receivable_applications.amount_applied%type:=0;
1917: l_amt_app_rec amt_app_type;
1918:
1919: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1920: l_tax_amount ar_receivable_applications.amount_applied%type:=0;
1921: l_frt_amount ar_receivable_applications.amount_applied%type:=0;
1922: l_charges_amount ar_receivable_applications.amount_applied%type:=0;
1923: l_applied_amount ar_receivable_applications.amount_applied%type:=0;

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

1916: l_total_amount ar_receivable_applications.amount_applied%type:=0;
1917: l_amt_app_rec amt_app_type;
1918:
1919: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1920: l_tax_amount ar_receivable_applications.amount_applied%type:=0;
1921: l_frt_amount ar_receivable_applications.amount_applied%type:=0;
1922: l_charges_amount ar_receivable_applications.amount_applied%type:=0;
1923: l_applied_amount ar_receivable_applications.amount_applied%type:=0;
1924:

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

1917: l_amt_app_rec amt_app_type;
1918:
1919: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1920: l_tax_amount ar_receivable_applications.amount_applied%type:=0;
1921: l_frt_amount ar_receivable_applications.amount_applied%type:=0;
1922: l_charges_amount ar_receivable_applications.amount_applied%type:=0;
1923: l_applied_amount ar_receivable_applications.amount_applied%type:=0;
1924:
1925: BEGIN

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

1918:
1919: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1920: l_tax_amount ar_receivable_applications.amount_applied%type:=0;
1921: l_frt_amount ar_receivable_applications.amount_applied%type:=0;
1922: l_charges_amount ar_receivable_applications.amount_applied%type:=0;
1923: l_applied_amount ar_receivable_applications.amount_applied%type:=0;
1924:
1925: BEGIN
1926: ---

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

1919: l_line_amount ar_receivable_applications.amount_applied%type:=0;
1920: l_tax_amount ar_receivable_applications.amount_applied%type:=0;
1921: l_frt_amount ar_receivable_applications.amount_applied%type:=0;
1922: l_charges_amount ar_receivable_applications.amount_applied%type:=0;
1923: l_applied_amount ar_receivable_applications.amount_applied%type:=0;
1924:
1925: BEGIN
1926: ---
1927: IF PG_DEBUG in ('Y', 'C') THEN

Line 1967: ar_receivable_applications

1963: l_frt_amount,
1964: l_charges_amount,
1965: l_applied_amount
1966: FROM
1967: ar_receivable_applications
1968: WHERE
1969: applied_customer_trx_id = p_customer_trx_id
1970: AND application_type = 'CASH' -- Consider only receipt applications
1971: AND display = 'Y';

Line 2014: PROCEDURE fetch_gl_date( p_ra_rec IN ar_receivable_applications%rowtype,

2010: ' occurred in arp_process_returns.get_amount_applied');
2011: RAISE;
2012: END get_amount_applied;
2013:
2014: PROCEDURE fetch_gl_date( p_ra_rec IN ar_receivable_applications%rowtype,
2015: p_gl_date OUT NOCOPY DATE) IS
2016: l_trx_gl_date DATE;
2017: l_rec_gl_date DATE;
2018: l_profile_appln_gl_date_def VARCHAR2(20);