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_LL_RCV_SUMMARY_PKG dependencies on ARPCURR

Line 48: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency /* Bug 5189370 */

44: X_lin_dsc in number,
45: x_tax_dsc in number ,
46: X_frt_dsc in number,
47: x_CREATED_BY_MODULE in varchar2
48: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency /* Bug 5189370 */
49: ,x_inv_to_rct_rate in number default 1
50: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
51: ,x_attribute_category IN varchar2 DEFAULT NULL
52: ,x_attribute1 IN varchar2 DEFAULT NULL

Line 50: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency

46: X_frt_dsc in number,
47: x_CREATED_BY_MODULE in varchar2
48: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency /* Bug 5189370 */
49: ,x_inv_to_rct_rate in number default 1
50: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
51: ,x_attribute_category IN varchar2 DEFAULT NULL
52: ,x_attribute1 IN varchar2 DEFAULT NULL
53: ,x_attribute2 IN varchar2 DEFAULT NULL
54: ,x_attribute3 IN varchar2 DEFAULT NULL

Line 144: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency

140: x_tax in number ,
141: X_lin_dsc in number,
142: x_tax_dsc in number ,
143: x_CREATED_BY_MODULE in varchar2
144: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
145: ,x_inv_to_rct_rate in number default 1
146: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
147: ,p_attribute_category IN varchar2 DEFAULT NULL
148: ,p_attribute1 IN varchar2 DEFAULT NULL

Line 146: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency

142: x_tax_dsc in number ,
143: x_CREATED_BY_MODULE in varchar2
144: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
145: ,x_inv_to_rct_rate in number default 1
146: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
147: ,p_attribute_category IN varchar2 DEFAULT NULL
148: ,p_attribute1 IN varchar2 DEFAULT NULL
149: ,p_attribute2 IN varchar2 DEFAULT NULL
150: ,p_attribute3 IN varchar2 DEFAULT NULL

Line 278: --line_2b_applied := arpcurr.currRound(lintax_row.line_rem * nvl(x_lin,0) / all_linrem_tot);

274: if all_linrem_tot > 0 then
275: arp_standard.debug ('i='||to_char(iterator)||'.'||
276: 'NOT LAST, all_linrem_tot<>0. line_run_tot=' || line_run_tot
277: || '. all_linorig_tot=' || all_linorig_tot);
278: --line_2b_applied := arpcurr.currRound(lintax_row.line_rem * nvl(x_lin,0) / all_linrem_tot);
279: x_run_line_amt := x_run_line_amt + lintax_row.line_rem;
280: line_2b_applied := arpcurr.currRound(x_run_line_amt * nvl(x_lin,0) / all_linrem_tot) - line_run_tot;
281: else -- Overappl (all_linrem_tot < 0) should be done at the UI level,
282: -- so this means all_linrem_tot = 0

Line 280: line_2b_applied := arpcurr.currRound(x_run_line_amt * nvl(x_lin,0) / all_linrem_tot) - line_run_tot;

276: 'NOT LAST, all_linrem_tot<>0. line_run_tot=' || line_run_tot
277: || '. all_linorig_tot=' || all_linorig_tot);
278: --line_2b_applied := arpcurr.currRound(lintax_row.line_rem * nvl(x_lin,0) / all_linrem_tot);
279: x_run_line_amt := x_run_line_amt + lintax_row.line_rem;
280: line_2b_applied := arpcurr.currRound(x_run_line_amt * nvl(x_lin,0) / all_linrem_tot) - line_run_tot;
281: else -- Overappl (all_linrem_tot < 0) should be done at the UI level,
282: -- so this means all_linrem_tot = 0
283: arp_standard.debug ('i='||to_char(iterator)||'.'||
284: 'NOT LAST, all_linrem_tot=0. line_run_tot=' || line_run_tot

Line 287: --line_2b_applied := arpcurr.currRound(lintax_row.line_orig * nvl(x_lin,0) / all_linorig_tot);

283: arp_standard.debug ('i='||to_char(iterator)||'.'||
284: 'NOT LAST, all_linrem_tot=0. line_run_tot=' || line_run_tot
285: || '. all_linorig_tot=' || all_linorig_tot);
286: if all_linorig_tot <> 0 then
287: --line_2b_applied := arpcurr.currRound(lintax_row.line_orig * nvl(x_lin,0) / all_linorig_tot);
288: x_run_line_amt := x_run_line_amt + lintax_row.line_orig;
289: line_2b_applied := arpcurr.currRound(x_run_line_amt * nvl(x_lin,0) / all_linorig_tot) - line_run_tot;
290: else
291: line_2b_applied := 0;

Line 289: line_2b_applied := arpcurr.currRound(x_run_line_amt * nvl(x_lin,0) / all_linorig_tot) - line_run_tot;

285: || '. all_linorig_tot=' || all_linorig_tot);
286: if all_linorig_tot <> 0 then
287: --line_2b_applied := arpcurr.currRound(lintax_row.line_orig * nvl(x_lin,0) / all_linorig_tot);
288: x_run_line_amt := x_run_line_amt + lintax_row.line_orig;
289: line_2b_applied := arpcurr.currRound(x_run_line_amt * nvl(x_lin,0) / all_linorig_tot) - line_run_tot;
290: else
291: line_2b_applied := 0;
292: end if;
293: end if;

Line 298: --tax_2b_applied := arpcurr.currRound(lintax_row.tax_rem * nvl(x_tax,0) / all_taxrem_tot);

294:
295: --Prorate the Tax Amount
296:
297: if all_taxrem_tot > 0 then
298: --tax_2b_applied := arpcurr.currRound(lintax_row.tax_rem * nvl(x_tax,0) / all_taxrem_tot);
299: x_run_tax_amt := x_run_tax_amt + lintax_row.tax_rem;
300: tax_2b_applied := arpcurr.currRound(x_run_tax_amt * nvl(x_tax,0) / all_taxrem_tot) - tax_run_tot;
301: else-- Overappl (all_taxrem_tot < 0) should be done at the UI level,
302: -- so this means all_taxrem_tot = 0

Line 300: tax_2b_applied := arpcurr.currRound(x_run_tax_amt * nvl(x_tax,0) / all_taxrem_tot) - tax_run_tot;

296:
297: if all_taxrem_tot > 0 then
298: --tax_2b_applied := arpcurr.currRound(lintax_row.tax_rem * nvl(x_tax,0) / all_taxrem_tot);
299: x_run_tax_amt := x_run_tax_amt + lintax_row.tax_rem;
300: tax_2b_applied := arpcurr.currRound(x_run_tax_amt * nvl(x_tax,0) / all_taxrem_tot) - tax_run_tot;
301: else-- Overappl (all_taxrem_tot < 0) should be done at the UI level,
302: -- so this means all_taxrem_tot = 0
303: if all_taxorig_tot <> 0 then
304: --tax_2b_applied := arpcurr.currRound(lintax_row.tax_orig * nvl(x_tax,0) / all_taxorig_tot);

Line 304: --tax_2b_applied := arpcurr.currRound(lintax_row.tax_orig * nvl(x_tax,0) / all_taxorig_tot);

300: tax_2b_applied := arpcurr.currRound(x_run_tax_amt * nvl(x_tax,0) / all_taxrem_tot) - tax_run_tot;
301: else-- Overappl (all_taxrem_tot < 0) should be done at the UI level,
302: -- so this means all_taxrem_tot = 0
303: if all_taxorig_tot <> 0 then
304: --tax_2b_applied := arpcurr.currRound(lintax_row.tax_orig * nvl(x_tax,0) / all_taxorig_tot);
305: x_run_tax_amt := x_run_tax_amt + lintax_row.tax_orig;
306: tax_2b_applied := arpcurr.currRound(x_run_tax_amt * nvl(x_tax,0) / all_taxorig_tot) - tax_run_tot;
307: else
308: tax_2b_applied := 0;

Line 306: tax_2b_applied := arpcurr.currRound(x_run_tax_amt * nvl(x_tax,0) / all_taxorig_tot) - tax_run_tot;

302: -- so this means all_taxrem_tot = 0
303: if all_taxorig_tot <> 0 then
304: --tax_2b_applied := arpcurr.currRound(lintax_row.tax_orig * nvl(x_tax,0) / all_taxorig_tot);
305: x_run_tax_amt := x_run_tax_amt + lintax_row.tax_orig;
306: tax_2b_applied := arpcurr.currRound(x_run_tax_amt * nvl(x_tax,0) / all_taxorig_tot) - tax_run_tot;
307: else
308: tax_2b_applied := 0;
309: end if;
310: end if ;

Line 315: --lindsc_2b_applied := arpcurr.currRound(x_lin_dsc * nvl(line_2b_applied,0) / nvl(x_lin,0) );

311:
312: -- Added Dec 7, 2005 - Bug 4775656. Discounts are not getting saved from Summary
313: -- Proate in the same ratio as that of the lin2bapplied / all_lin2bapplied_tot
314: if nvl(x_lin,0) <> 0 then
315: --lindsc_2b_applied := arpcurr.currRound(x_lin_dsc * nvl(line_2b_applied,0) / nvl(x_lin,0) );
316: lindsc_2b_applied := arpcurr.currRound(x_lin_dsc * nvl(line_run_tot,0) / nvl(x_lin,0) ) - lindsc_run_tot;
317: else
318: lindsc_2b_applied := 0;
319: end if;

Line 316: lindsc_2b_applied := arpcurr.currRound(x_lin_dsc * nvl(line_run_tot,0) / nvl(x_lin,0) ) - lindsc_run_tot;

312: -- Added Dec 7, 2005 - Bug 4775656. Discounts are not getting saved from Summary
313: -- Proate in the same ratio as that of the lin2bapplied / all_lin2bapplied_tot
314: if nvl(x_lin,0) <> 0 then
315: --lindsc_2b_applied := arpcurr.currRound(x_lin_dsc * nvl(line_2b_applied,0) / nvl(x_lin,0) );
316: lindsc_2b_applied := arpcurr.currRound(x_lin_dsc * nvl(line_run_tot,0) / nvl(x_lin,0) ) - lindsc_run_tot;
317: else
318: lindsc_2b_applied := 0;
319: end if;
320: -- Proate in the same ratio as that of the tax2bapplied / all_tax2bapplied_tot

Line 322: --taxdsc_2b_applied := arpcurr.currRound(x_tax_dsc * nvl(tax_2b_applied,0) / nvl(x_tax,0) );

318: lindsc_2b_applied := 0;
319: end if;
320: -- Proate in the same ratio as that of the tax2bapplied / all_tax2bapplied_tot
321: if nvl(x_tax,0) <> 0 then
322: --taxdsc_2b_applied := arpcurr.currRound(x_tax_dsc * nvl(tax_2b_applied,0) / nvl(x_tax,0) );
323: taxdsc_2b_applied := arpcurr.currRound(x_tax_dsc * nvl(tax_run_tot,0) / nvl(x_tax,0) )- taxdsc_run_tot;
324: else
325: taxdsc_2b_applied := 0;
326: end if;

Line 323: taxdsc_2b_applied := arpcurr.currRound(x_tax_dsc * nvl(tax_run_tot,0) / nvl(x_tax,0) )- taxdsc_run_tot;

319: end if;
320: -- Proate in the same ratio as that of the tax2bapplied / all_tax2bapplied_tot
321: if nvl(x_tax,0) <> 0 then
322: --taxdsc_2b_applied := arpcurr.currRound(x_tax_dsc * nvl(tax_2b_applied,0) / nvl(x_tax,0) );
323: taxdsc_2b_applied := arpcurr.currRound(x_tax_dsc * nvl(tax_run_tot,0) / nvl(x_tax,0) )- taxdsc_run_tot;
324: else
325: taxdsc_2b_applied := 0;
326: end if;
327: -- End of additions for bug 4775656

Line 388: arpcurr.currRound(nvl(line_2b_applied ,0),x_inv_curr_code),

384: lintax_row.apply_to,
385: lintax_row.line_id,
386: DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),
387: lintax_row.group_id,
388: arpcurr.currRound(nvl(line_2b_applied ,0),x_inv_curr_code),
389: arp_util.currRound(nvl(cross_currency_2b_applied,0), x_rct_curr_code),
390: arpcurr.currRound(nvl(tax_2b_applied ,0),x_inv_curr_code),
391: NVL(FND_GLOBAL.user_id,-1),
392: SYSDATE,

Line 390: arpcurr.currRound(nvl(tax_2b_applied ,0),x_inv_curr_code),

386: DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),
387: lintax_row.group_id,
388: arpcurr.currRound(nvl(line_2b_applied ,0),x_inv_curr_code),
389: arp_util.currRound(nvl(cross_currency_2b_applied,0), x_rct_curr_code),
390: arpcurr.currRound(nvl(tax_2b_applied ,0),x_inv_curr_code),
391: NVL(FND_GLOBAL.user_id,-1),
392: SYSDATE,
393: decode(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,
394: FND_GLOBAL.login_id,FND_GLOBAL.conc_login_id),

Line 440: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency

436: X_frt in number,
437: X_frt_dsc in number,
438: x_CREATED_BY_MODULE in varchar2
439: -- Oct 04 added two param below
440: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
441: ,x_inv_to_rct_rate in number default 1
442: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
443: ,x_comments in varchar2 default null /* Bug 5453663 */
444: ,p_attribute_category IN varchar2 DEFAULT NULL

Line 442: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency

438: x_CREATED_BY_MODULE in varchar2
439: -- Oct 04 added two param below
440: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
441: ,x_inv_to_rct_rate in number default 1
442: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
443: ,x_comments in varchar2 default null /* Bug 5453663 */
444: ,p_attribute_category IN varchar2 DEFAULT NULL
445: ,p_attribute1 IN varchar2 DEFAULT NULL
446: ,p_attribute2 IN varchar2 DEFAULT NULL

Line 513: frt_2b_applied := arpcurr.currRound(frt_row.frt_rem * x_frt / all_frtrem_tot);

509: if iterator = line_count then
510: frt_2b_applied := x_frt - frt_run_tot;
511: else
512: if all_frtrem_tot > 0 then
513: frt_2b_applied := arpcurr.currRound(frt_row.frt_rem * x_frt / all_frtrem_tot);
514: else -- Overappl (all_frtrem_tot < 0) should be done at the UI level,
515: -- so this means all_frtrem_tot = 0
516: if all_frtorig_tot <> 0 then
517: frt_2b_applied := arpcurr.currRound(frt_row.frt_orig * x_frt / all_frtorig_tot);

Line 517: frt_2b_applied := arpcurr.currRound(frt_row.frt_orig * x_frt / all_frtorig_tot);

513: frt_2b_applied := arpcurr.currRound(frt_row.frt_rem * x_frt / all_frtrem_tot);
514: else -- Overappl (all_frtrem_tot < 0) should be done at the UI level,
515: -- so this means all_frtrem_tot = 0
516: if all_frtorig_tot <> 0 then
517: frt_2b_applied := arpcurr.currRound(frt_row.frt_orig * x_frt / all_frtorig_tot);
518: else
519: frt_2b_applied := 0;
520: end if;
521: end if;

Line 526: frtdsc_2b_applied := arpcurr.currRound(x_frt_dsc * nvl(frt_2b_applied,0) / nvl(x_frt,0) );

522:
523: end if;
524: -- Proate in the same ratio as that of the lin2bapplied / all_lin2bapplied_tot
525: if nvl(x_frt,0) <> 0 then
526: frtdsc_2b_applied := arpcurr.currRound(x_frt_dsc * nvl(frt_2b_applied,0) / nvl(x_frt,0) );
527: else
528: frtdsc_2b_applied := 0;
529: end if;
530: arp_standard.debug ('i='||to_char(iterator)||'.'||

Line 595: 0, -- Bug 5189370 arpcurr.currRound(nvl(Frt_2b_applied ,0)),

591: frt_row.apply_to,
592: frt_row.line_id,
593: DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),
594: frt_row.GROUP_ID,
595: 0, -- Bug 5189370 arpcurr.currRound(nvl(Frt_2b_applied ,0)),
596: X_COMMENTS,
597: NVL(FND_GLOBAL.user_id,-1),
598: SYSDATE,
599: decode(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,

Line 609: , arpcurr.currRound(nvl(Frt_2b_applied ,0),x_inv_curr_code)

605: 'RA'
606: -- 1 line added below added Oct 26
607: , cross_currency_2b_applied
608: -- 2 lines added below Dec 12
609: , arpcurr.currRound(nvl(Frt_2b_applied ,0),x_inv_curr_code)
610: , arpcurr.currRound(nvl(FrtDsc_2b_applied ,0),x_inv_curr_Code),
611: p_attribute_category,
612: p_attribute1,
613: p_attribute2,

Line 610: , arpcurr.currRound(nvl(FrtDsc_2b_applied ,0),x_inv_curr_Code),

606: -- 1 line added below added Oct 26
607: , cross_currency_2b_applied
608: -- 2 lines added below Dec 12
609: , arpcurr.currRound(nvl(Frt_2b_applied ,0),x_inv_curr_code)
610: , arpcurr.currRound(nvl(FrtDsc_2b_applied ,0),x_inv_curr_Code),
611: p_attribute_category,
612: p_attribute1,
613: p_attribute2,
614: p_attribute3,

Line 643: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency

639: X_CASH_RECEIPT_ID IN NUMBER,
640: X_CUSTOMER_TRX_ID IN NUMBER,
641: X_chg in number,
642: x_CREATED_BY_MODULE in varchar2
643: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
644: ,x_inv_to_rct_rate in number default 1
645: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
646: ,p_attribute_category IN varchar2 DEFAULT NULL
647: ,p_attribute1 IN varchar2 DEFAULT NULL

Line 645: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency

641: X_chg in number,
642: x_CREATED_BY_MODULE in varchar2
643: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
644: ,x_inv_to_rct_rate in number default 1
645: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
646: ,p_attribute_category IN varchar2 DEFAULT NULL
647: ,p_attribute1 IN varchar2 DEFAULT NULL
648: ,p_attribute2 IN varchar2 DEFAULT NULL
649: ,p_attribute3 IN varchar2 DEFAULT NULL

Line 712: chg_2b_applied := arpcurr.currRound(chg_row.chg_rem * x_chg / all_chgrem_tot);

708: if iterator = line_count then
709: chg_2b_applied := x_chg - chg_run_tot;
710: else
711: if all_chgrem_tot > 0 then
712: chg_2b_applied := arpcurr.currRound(chg_row.chg_rem * x_chg / all_chgrem_tot);
713: else -- Overappl (all_chgrem_tot < 0) should be done at the UI level,
714: -- so this means all_chgrem_tot = 0
715: if all_chgorig_tot <> 0 then
716: chg_2b_applied := arpcurr.currRound(chg_row.chg_orig * x_chg / all_chgorig_tot);

Line 716: chg_2b_applied := arpcurr.currRound(chg_row.chg_orig * x_chg / all_chgorig_tot);

712: chg_2b_applied := arpcurr.currRound(chg_row.chg_rem * x_chg / all_chgrem_tot);
713: else -- Overappl (all_chgrem_tot < 0) should be done at the UI level,
714: -- so this means all_chgrem_tot = 0
715: if all_chgorig_tot <> 0 then
716: chg_2b_applied := arpcurr.currRound(chg_row.chg_orig * x_chg / all_chgorig_tot);
717: else
718: chg_2b_applied := 0;
719: end if;
720: end if;

Line 786: 0, -- Bug 5189370 arpcurr.currRound(nvl(chg_2b_applied ,0)),

782: chg_row.apply_to,
783: chg_row.line_id,
784: DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),
785: chg_row.GROUP_ID,
786: 0, -- Bug 5189370 arpcurr.currRound(nvl(chg_2b_applied ,0)),
787: NVL(FND_GLOBAL.user_id,-1),
788: SYSDATE,
789: decode(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,
790: FND_GLOBAL.login_id,FND_GLOBAL.conc_login_id),

Line 799: , arpcurr.currRound(nvl(chg_2b_applied ,0),x_inv_curr_code),

795: 'RA'
796: -- 1 line added below Oct 26
797: , cross_currency_2b_applied
798: -- 1 line added below Dec 12
799: , arpcurr.currRound(nvl(chg_2b_applied ,0),x_inv_curr_code),
800: p_attribute_category,
801: p_attribute1,
802: p_attribute2,
803: p_attribute3,

Line 962: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency

958: X_lin_dsc in number,
959: x_tax_dsc in number ,
960: X_frt_dsc in number,
961: x_CREATED_BY_MODULE in varchar2
962: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
963: ,x_inv_to_rct_rate in number default 1
964: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
965: ) IS
966:

Line 964: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency

960: X_frt_dsc in number,
961: x_CREATED_BY_MODULE in varchar2
962: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
963: ,x_inv_to_rct_rate in number default 1
964: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
965: ) IS
966:
967: BEGIN
968: -- Bug 7241111 instead of deleting now inserting offset rows