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_AUTOAPPLY_API dependencies on ARP_STANDARD

Line 196: arp_standard.debug('AutoApply: ' || p_msg || ' : ' || TO_CHAR(SYSDATE,'DD/MM/YY hh:mi:ss'));

192: +===========================================================================*/
193:
194: PROCEDURE log(p_msg VARCHAR2) IS
195: BEGIN
196: arp_standard.debug('AutoApply: ' || p_msg || ' : ' || TO_CHAR(SYSDATE,'DD/MM/YY hh:mi:ss'));
197: END;
198:
199: /*===========================================================================+
200: * FUNCTION *

Line 567: G_PROGRAM_ID := arp_standard.profile.program_id;

563: log('Called From : ' || p_called_from);
564: log('Total Workers : ' || p_total_workers);
565: END IF;
566: delete_interim_records; /* Call to delete records from interface table */
567: G_PROGRAM_ID := arp_standard.profile.program_id;
568: G_PROGRAM_APPLICATION_ID := arp_standard.application_id;
569: G_CREATED_BY := arp_standard.profile.user_id;
570: G_LAST_UPDATED_BY := arp_standard.profile.user_id;
571: G_LAST_UPDATE_LOGIN := arp_standard.profile.last_update_login;

Line 568: G_PROGRAM_APPLICATION_ID := arp_standard.application_id;

564: log('Total Workers : ' || p_total_workers);
565: END IF;
566: delete_interim_records; /* Call to delete records from interface table */
567: G_PROGRAM_ID := arp_standard.profile.program_id;
568: G_PROGRAM_APPLICATION_ID := arp_standard.application_id;
569: G_CREATED_BY := arp_standard.profile.user_id;
570: G_LAST_UPDATED_BY := arp_standard.profile.user_id;
571: G_LAST_UPDATE_LOGIN := arp_standard.profile.last_update_login;
572: /* Fetch the data from ar_cash_remit_refs table for the current run

Line 569: G_CREATED_BY := arp_standard.profile.user_id;

565: END IF;
566: delete_interim_records; /* Call to delete records from interface table */
567: G_PROGRAM_ID := arp_standard.profile.program_id;
568: G_PROGRAM_APPLICATION_ID := arp_standard.application_id;
569: G_CREATED_BY := arp_standard.profile.user_id;
570: G_LAST_UPDATED_BY := arp_standard.profile.user_id;
571: G_LAST_UPDATE_LOGIN := arp_standard.profile.last_update_login;
572: /* Fetch the data from ar_cash_remit_refs table for the current run
573: based on the parameters */

Line 570: G_LAST_UPDATED_BY := arp_standard.profile.user_id;

566: delete_interim_records; /* Call to delete records from interface table */
567: G_PROGRAM_ID := arp_standard.profile.program_id;
568: G_PROGRAM_APPLICATION_ID := arp_standard.application_id;
569: G_CREATED_BY := arp_standard.profile.user_id;
570: G_LAST_UPDATED_BY := arp_standard.profile.user_id;
571: G_LAST_UPDATE_LOGIN := arp_standard.profile.last_update_login;
572: /* Fetch the data from ar_cash_remit_refs table for the current run
573: based on the parameters */
574: l_insert_stmt := ' INSERT INTO AR_CASH_REMIT_REFS_INTERIM

Line 571: G_LAST_UPDATE_LOGIN := arp_standard.profile.last_update_login;

567: G_PROGRAM_ID := arp_standard.profile.program_id;
568: G_PROGRAM_APPLICATION_ID := arp_standard.application_id;
569: G_CREATED_BY := arp_standard.profile.user_id;
570: G_LAST_UPDATED_BY := arp_standard.profile.user_id;
571: G_LAST_UPDATE_LOGIN := arp_standard.profile.last_update_login;
572: /* Fetch the data from ar_cash_remit_refs table for the current run
573: based on the parameters */
574: l_insert_stmt := ' INSERT INTO AR_CASH_REMIT_REFS_INTERIM
575: ( REMIT_REFERENCE_ID,

Line 997: p_request_id := arp_standard.profile.request_id;

993: log('arp_autoapply_api.auto_apply_child(+)');
994: log('Worker Number : ' || p_worker_number);
995: END IF;
996: l_worker_number := p_worker_number;
997: p_request_id := arp_standard.profile.request_id;
998:
999: FOR auto_rule_set_var in auto_rule_set_cur(l_worker_number)
1000: LOOP
1001: l_automatch_set_id := auto_rule_set_var.automatch_set_id;

Line 1207: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

1203: , GL_CURRENCY_API.GET_RATE_SQL(
1204: ps.invoice_currency_code,
1205: cr.currency_code,
1206: cr.receipt_date,
1207: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )
1208: )
1209: )
1210: ),38) trans_to_receipt_rate,
1211: NULL amount_applied_from, -- will be calculated later for xcurr app.

Line 1255: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,

1251: AND ps.payment_schedule_id > 0
1252: AND ps.status = 'OP'
1253: AND ps.terms_sequence_number = NVL(ref.installment_reference,
1254: ps.terms_sequence_number)
1255: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
1256: NVL(cr.pay_from_customer, ps.customer_id))
1257: FROM DUAL
1258: UNION ALL
1259: SELECT related_cust_account_id

Line 1264: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

1260: FROM hz_cust_acct_relate_all rel
1261: WHERE rel.cust_account_id = cr.pay_from_customer
1262: AND rel.bill_to_flag = 'Y'
1263: AND rel.status = 'A'
1264: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
1265: UNION ALL
1266: SELECT rel.related_cust_account_id
1267: FROM ar_paying_relationships_v rel,
1268: hz_cust_accounts acc

Line 1273: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )

1269: WHERE acc.cust_account_id = cr.pay_from_customer
1270: AND acc.party_id = rel.party_id
1271: AND cr.receipt_date >= effective_start_date
1272: AND cr.receipt_date <= effective_end_date
1273: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )
1274: AND trx.customer_trx_id = ps.customer_trx_id
1275: AND tr.term_id(+) = ps.term_id
1276: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
1277: l_selected_recos selected_recos_table;

Line 1454: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

1450: , GL_CURRENCY_API.GET_RATE_SQL(
1451: ps.invoice_currency_code,
1452: cr.currency_code,
1453: cr.receipt_date,
1454: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )
1455: )
1456: )
1457: ),38) trans_to_receipt_rate,
1458: NULL amount_applied_from, -- will be calculated later for xcurr app.

Line 1501: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,

1497: AND ps.selected_for_receipt_batch_id IS NULL
1498: AND ps.class NOT IN ('PMT', 'GUAR')
1499: AND ps.payment_schedule_id > 0
1500: AND ps.status = 'OP'
1501: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
1502: NVL(cr.pay_from_customer, ps.customer_id))
1503: FROM DUAL
1504: UNION ALL
1505: SELECT related_cust_account_id

Line 1510: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

1506: FROM hz_cust_acct_relate_all rel
1507: WHERE rel.cust_account_id = cr.pay_from_customer
1508: AND rel.bill_to_flag = 'Y'
1509: AND rel.status = 'A'
1510: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
1511: UNION ALL
1512: SELECT rel.related_cust_account_id
1513: FROM ar_paying_relationships_v rel,
1514: hz_cust_accounts acc

Line 1519: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )

1515: WHERE acc.cust_account_id = cr.pay_from_customer
1516: AND acc.party_id = rel.party_id
1517: AND cr.receipt_date >= effective_start_date
1518: AND cr.receipt_date <= effective_end_date
1519: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )
1520: AND tr.term_id(+) = ps.term_id
1521: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
1522: l_selected_recos selected_recos_table;
1523: l_current_reco selected_recos_table;

Line 1695: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

1691: , GL_CURRENCY_API.GET_RATE_SQL(
1692: ps.invoice_currency_code,
1693: cr.currency_code,
1694: cr.receipt_date,
1695: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )
1696: )
1697: )
1698: ),38) trans_to_receipt_rate,
1699: NULL amount_applied_from, -- will be calculated later for xcurr app.

Line 1746: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,

1742: AND ps.selected_for_receipt_batch_id IS NULL
1743: AND ps.class NOT IN ('PMT', 'GUAR')
1744: AND ps.payment_schedule_id > 0
1745: AND ps.status = 'OP'
1746: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
1747: NVL(cr.pay_from_customer, ps.customer_id))
1748: FROM DUAL
1749: UNION ALL
1750: SELECT related_cust_account_id

Line 1755: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

1751: FROM hz_cust_acct_relate_all rel
1752: WHERE rel.cust_account_id = cr.pay_from_customer
1753: AND rel.bill_to_flag = 'Y'
1754: AND rel.status = 'A'
1755: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
1756: UNION ALL
1757: SELECT rel.related_cust_account_id
1758: FROM ar_paying_relationships_v rel,
1759: hz_cust_accounts acc

Line 1764: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )

1760: WHERE acc.cust_account_id = cr.pay_from_customer
1761: AND acc.party_id = rel.party_id
1762: AND cr.receipt_date >= effective_start_date
1763: AND cr.receipt_date <= effective_end_date
1764: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )
1765: AND tr.term_id(+) = ps.term_id
1766: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
1767: l_selected_recos selected_recos_table;
1768: l_current_reco selected_recos_table;

Line 1939: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

1935: , GL_CURRENCY_API.GET_RATE_SQL(
1936: ps.invoice_currency_code,
1937: cr.currency_code,
1938: cr.receipt_date,
1939: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )
1940: )
1941: )
1942: ),38) trans_to_receipt_rate,
1943: NULL amount_applied_from, -- will be calculated later for xcurr app.

Line 1990: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,

1986: AND ps.selected_for_receipt_batch_id IS NULL
1987: AND ps.class NOT IN ('PMT', 'GUAR')
1988: AND ps.payment_schedule_id > 0
1989: AND ps.status = 'OP'
1990: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
1991: NVL(cr.pay_from_customer, ps.customer_id))
1992: FROM DUAL
1993: UNION ALL
1994: SELECT related_cust_account_id

Line 1999: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

1995: FROM hz_cust_acct_relate_all rel
1996: WHERE rel.cust_account_id = cr.pay_from_customer
1997: AND rel.bill_to_flag = 'Y'
1998: AND rel.status = 'A'
1999: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
2000: UNION ALL
2001: SELECT rel.related_cust_account_id
2002: FROM ar_paying_relationships_v rel,
2003: hz_cust_accounts acc

Line 2008: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )

2004: WHERE acc.cust_account_id = cr.pay_from_customer
2005: AND acc.party_id = rel.party_id
2006: AND cr.receipt_date >= effective_start_date
2007: AND cr.receipt_date <= effective_end_date
2008: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )
2009: AND tr.term_id(+) = ps.term_id
2010: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
2011: l_selected_recos selected_recos_table;
2012: l_current_reco selected_recos_table;

Line 2282: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,

2278: p_trans_format_str,
2279: p_trans_float_str,
2280: p_rem_format_str,
2281: p_rem_float_str,
2282: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,
2283: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,
2284: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag;
2285: LOOP
2286: FETCH select_recos BULK COLLECT INTO l_selected_recos LIMIT G_MAX_ARRAY_SIZE;

Line 2283: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,

2279: p_trans_float_str,
2280: p_rem_format_str,
2281: p_rem_float_str,
2282: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,
2283: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,
2284: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag;
2285: LOOP
2286: FETCH select_recos BULK COLLECT INTO l_selected_recos LIMIT G_MAX_ARRAY_SIZE;
2287: log('Count : '||l_selected_recos.COUNT);

Line 2284: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag;

2280: p_rem_format_str,
2281: p_rem_float_str,
2282: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,
2283: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,
2284: ARP_STANDARD.sysparm.pay_unrelated_invoices_flag;
2285: LOOP
2286: FETCH select_recos BULK COLLECT INTO l_selected_recos LIMIT G_MAX_ARRAY_SIZE;
2287: log('Count : '||l_selected_recos.COUNT);
2288: IF l_selected_recos.COUNT = 0 THEN

Line 2447: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

2443: , GL_CURRENCY_API.GET_RATE_SQL(
2444: ps.invoice_currency_code,
2445: cr.currency_code,
2446: cr.receipt_date,
2447: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )
2448: )
2449: )
2450: ),38) trans_to_receipt_rate,
2451: NULL amount_applied_from, -- will be calculated later for xcurr app.

Line 2494: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,

2490: AND ps.selected_for_receipt_batch_id IS NULL
2491: AND ps.class NOT IN ('PMT', 'GUAR')
2492: AND ps.payment_schedule_id > 0
2493: AND ps.status = 'OP'
2494: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
2495: NVL(cr.pay_from_customer, ps.customer_id))
2496: FROM DUAL
2497: UNION ALL
2498: SELECT related_cust_account_id

Line 2503: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

2499: FROM hz_cust_acct_relate_all rel
2500: WHERE rel.cust_account_id = cr.pay_from_customer
2501: AND rel.bill_to_flag = 'Y'
2502: AND rel.status = 'A'
2503: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
2504: UNION ALL
2505: SELECT rel.related_cust_account_id
2506: FROM ar_paying_relationships_v rel,
2507: hz_cust_accounts acc

Line 2512: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )

2508: WHERE acc.cust_account_id = cr.pay_from_customer
2509: AND acc.party_id = rel.party_id
2510: AND cr.receipt_date >= effective_start_date
2511: AND cr.receipt_date <= effective_end_date
2512: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )
2513: AND tr.term_id(+) = ps.term_id
2514: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
2515: l_selected_recos selected_recos_table;
2516: l_current_reco selected_recos_table;

Line 2669: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

2665: , GL_CURRENCY_API.GET_RATE_SQL(
2666: ps.invoice_currency_code,
2667: cr.currency_code,
2668: cr.receipt_date,
2669: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )
2670: )
2671: )
2672: ),38) trans_to_receipt_rate,
2673: NULL amount_applied_from, -- will be calculated later for xcurr app.

Line 2715: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,

2711: AND ps.selected_for_receipt_batch_id IS NULL
2712: AND ps.class NOT IN ('PMT', 'GUAR')
2713: AND ps.payment_schedule_id > 0
2714: AND ps.status = 'OP'
2715: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
2716: NVL(cr.pay_from_customer, ps.customer_id))
2717: FROM DUAL
2718: UNION ALL
2719: SELECT related_cust_account_id

Line 2724: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

2720: FROM hz_cust_acct_relate_all rel
2721: WHERE rel.cust_account_id = cr.pay_from_customer
2722: AND rel.bill_to_flag = 'Y'
2723: AND rel.status = 'A'
2724: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
2725: UNION ALL
2726: SELECT rel.related_cust_account_id
2727: FROM ar_paying_relationships_v rel,
2728: hz_cust_accounts acc

Line 2733: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )

2729: WHERE acc.cust_account_id = cr.pay_from_customer
2730: AND acc.party_id = rel.party_id
2731: AND cr.receipt_date >= effective_start_date
2732: AND cr.receipt_date <= effective_end_date
2733: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )
2734: AND trx.customer_trx_id = ps.customer_trx_id
2735: AND tr.term_id(+) = ps.term_id
2736: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
2737: l_selected_recos selected_recos_table;

Line 2914: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )

2910: , GL_CURRENCY_API.GET_RATE_SQL(
2911: ps.invoice_currency_code,
2912: cr.currency_code,
2913: cr.receipt_date,
2914: arp_standard.sysparm.CROSS_CURRENCY_RATE_TYPE )
2915: )
2916: )
2917: ),38) trans_to_receipt_rate,
2918: NULL amount_applied_from, -- will be calculated later for xcurr app.

Line 2963: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,

2959: AND ps.payment_schedule_id > 0
2960: AND ps.status = 'OP'
2961: AND ps.terms_sequence_number = NVL(ref.installment_reference,
2962: ps.terms_sequence_number)
2963: AND ps.customer_id IN (SELECT DECODE(ARP_STANDARD.sysparm.pay_unrelated_invoices_flag,'Y', ps.customer_id,
2964: NVL(cr.pay_from_customer, ps.customer_id))
2965: FROM DUAL
2966: UNION ALL
2967: SELECT related_cust_account_id

Line 2972: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

2968: FROM hz_cust_acct_relate_all rel
2969: WHERE rel.cust_account_id = cr.pay_from_customer
2970: AND rel.bill_to_flag = 'Y'
2971: AND rel.status = 'A'
2972: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
2973: UNION ALL
2974: SELECT rel.related_cust_account_id
2975: FROM ar_paying_relationships_v rel,
2976: hz_cust_accounts acc

Line 2981: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )

2977: WHERE acc.cust_account_id = cr.pay_from_customer
2978: AND acc.party_id = rel.party_id
2979: AND cr.receipt_date >= effective_start_date
2980: AND cr.receipt_date <= effective_end_date
2981: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y' )
2982: AND tr.term_id(+) = ps.term_id
2983: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
2984: l_selected_recos selected_recos_table;
2985: l_current_reco selected_recos_table;

Line 3877: p_org_id => ARP_STANDARD.sysparm.org_id);

3873: p_applied_payment_schedule_id => app_line.payment_schedule_id,
3874: p_amount_applied => app_line.amount_applied,
3875: p_amount_applied_from => app_line.amount_applied_from,
3876: p_trans_to_receipt_rate => app_line.trans_to_receipt_rate,
3877: p_org_id => ARP_STANDARD.sysparm.org_id);
3878:
3879: IF (PG_DEBUG IN ('Y', 'C')) THEN
3880: log('Apply API Status :'|| l_return_status);
3881: END IF;

Line 3954: p_org_id => ARP_STANDARD.SYSPARM.org_id);

3950: p_applied_payment_schedule_id => bfb_line.payment_schedule_id,
3951: p_amount_applied => bfb_line.amount_applied,
3952: p_amount_applied_from => bfb_line.amount_applied_from,
3953: p_trans_to_receipt_rate => bfb_line.trans_to_receipt_rate,
3954: p_org_id => ARP_STANDARD.SYSPARM.org_id);
3955:
3956: IF (PG_DEBUG IN ('Y', 'C')) THEN
3957: log('Apply API Status :'|| l_return_status);
3958: END IF;