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.FUN_NET_ARAP_PKG dependencies on ARP_DISCOUNTS_API

Line 277: l_applieddisc := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),p_txn_due_date,l_amt_to_net) + l_applieddisc;

273: LOOP
274: fun_net_util.Log_String(g_state_level,l_path,'l_amt_to_net :'|| l_amt_to_net);
275: fun_net_util.Log_String(g_state_level,l_path,'l_amt_remaining('||j||') :'|| l_amt_remaining(j));
276: IF l_amt_remaining(j)>=l_amt_to_net THEN
277: l_applieddisc := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),p_txn_due_date,l_amt_to_net) + l_applieddisc;
278: EXIT;
279: ELSE
280: l_current_discount := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),p_txn_due_date,null);
281: l_applieddisc := l_current_discount + l_applieddisc;

Line 280: l_current_discount := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),p_txn_due_date,null);

276: IF l_amt_remaining(j)>=l_amt_to_net THEN
277: l_applieddisc := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),p_txn_due_date,l_amt_to_net) + l_applieddisc;
278: EXIT;
279: ELSE
280: l_current_discount := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),p_txn_due_date,null);
281: l_applieddisc := l_current_discount + l_applieddisc;
282: l_amt_to_net := l_amt_to_net - (l_amt_remaining(j) - l_current_discount);
283: END IF;
284: fun_net_util.Log_String(g_state_level,l_path,'l_current_discount('||j||') :'|| l_current_discount);

Line 498: sum(arps.amount_due_remaining - ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)) AS OPEN_AMOUNT_AFTERDISC'; -- ADDED FOR ESD ENABLED AGREEMENTS

494: l_trx_select_clause :=
495: 'SELECT rct.customer_trx_id,
496: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,
497: sum(arps.amount_due_remaining) AS open_amount,
498: sum(arps.amount_due_remaining - ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)) AS OPEN_AMOUNT_AFTERDISC'; -- ADDED FOR ESD ENABLED AGREEMENTS
499: END IF;
500: fun_net_util.Log_String(g_state_level,l_path,'SELECT : '||l_trx_select_clause);
501: l_trx_from_clause :=
502: ' FROM ra_customer_trx_all rct,

Line 640: SUM(ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)),:max_roll_days))) AS OPEN_AMOUNT_AFTERDISC,

636: :max_roll_days) AS open_amount,
637: sum(arps.amount_due_remaining) AS txn_curr_open_amt,
638: ((gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,SUM(arps.amount_due_remaining),:max_roll_days))
639: -(gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,
640: SUM(ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)),:max_roll_days))) AS OPEN_AMOUNT_AFTERDISC,
641: sum(arps.amount_due_remaining - ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)) AS TXN_CURR_OPEN_AMOUNT_AFTERDISC'; -- ADDED FOR ESD ENABLED AGREEMENTS
642: END IF;
643: l_trx_group_by_clause := l_trx_group_by_clause ||
644: ',' ||

Line 641: sum(arps.amount_due_remaining - ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)) AS TXN_CURR_OPEN_AMOUNT_AFTERDISC'; -- ADDED FOR ESD ENABLED AGREEMENTS

637: sum(arps.amount_due_remaining) AS txn_curr_open_amt,
638: ((gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,SUM(arps.amount_due_remaining),:max_roll_days))
639: -(gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,
640: SUM(ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)),:max_roll_days))) AS OPEN_AMOUNT_AFTERDISC,
641: sum(arps.amount_due_remaining - ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)) AS TXN_CURR_OPEN_AMOUNT_AFTERDISC'; -- ADDED FOR ESD ENABLED AGREEMENTS
642: END IF;
643: l_trx_group_by_clause := l_trx_group_by_clause ||
644: ',' ||
645: ' rct.invoice_currency_code ';

Line 1753: l_applieddisc(i) := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),g_batch_details.settlement_date,l_amt_to_net) + l_applieddisc(i);

1749: FOR j IN 1..l_pmtno.COUNT
1750: LOOP
1751: fun_net_util.Log_String(g_state_level,l_path,' Inside loop');
1752: IF l_amt_remaining(j)>=l_amt_to_net THEN
1753: l_applieddisc(i) := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),g_batch_details.settlement_date,l_amt_to_net) + l_applieddisc(i);
1754: fun_net_util.Log_String(g_state_level,l_path,' Inside logic to calculate partial discount');
1755: fun_net_util.Log_String(g_state_level,l_path,' l_pmtno(i) = ' || l_pmtno(j));
1756: fun_net_util.Log_String(g_state_level,l_path,' l_amt_to_net = ' || l_amt_to_net);
1757: fun_net_util.Log_String(g_state_level,l_path,' l_applieddisc(i)= 1' || l_applieddisc(i));

Line 1760: l_applieddisc(i) := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),g_batch_details.settlement_date,NULL) + l_applieddisc(i);

1756: fun_net_util.Log_String(g_state_level,l_path,' l_amt_to_net = ' || l_amt_to_net);
1757: fun_net_util.Log_String(g_state_level,l_path,' l_applieddisc(i)= 1' || l_applieddisc(i));
1758: EXIT;
1759: ELSE
1760: l_applieddisc(i) := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),g_batch_details.settlement_date,NULL) + l_applieddisc(i);
1761: --l_applieddisc(i) := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),g_batch_details.settlement_date,l_amt_remaining(j)) + l_applieddisc(i);
1762: l_amt_to_net := l_amt_to_net - (l_amt_remaining(j) - l_applieddisc(i));
1763: fun_net_util.Log_String(g_state_level,l_path,' l_pmtno(i) = ' || l_pmtno(j));
1764: fun_net_util.Log_String(g_state_level,l_path,' l_amt_to_net = ' || l_amt_to_net);

Line 1761: --l_applieddisc(i) := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),g_batch_details.settlement_date,l_amt_remaining(j)) + l_applieddisc(i);

1757: fun_net_util.Log_String(g_state_level,l_path,' l_applieddisc(i)= 1' || l_applieddisc(i));
1758: EXIT;
1759: ELSE
1760: l_applieddisc(i) := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),g_batch_details.settlement_date,NULL) + l_applieddisc(i);
1761: --l_applieddisc(i) := ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(l_pmtno(j),g_batch_details.settlement_date,l_amt_remaining(j)) + l_applieddisc(i);
1762: l_amt_to_net := l_amt_to_net - (l_amt_remaining(j) - l_applieddisc(i));
1763: fun_net_util.Log_String(g_state_level,l_path,' l_pmtno(i) = ' || l_pmtno(j));
1764: fun_net_util.Log_String(g_state_level,l_path,' l_amt_to_net = ' || l_amt_to_net);
1765: fun_net_util.Log_String(g_state_level,l_path,' l_applieddisc(i)= 1' || l_applieddisc(i));