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 521: frt_2b_applied := arpcurr.currRound(frt_row.frt_rem * x_frt / all_frtrem_tot);

517: if iterator = line_count then
518: frt_2b_applied := x_frt - frt_run_tot;
519: else
520: if all_frtrem_tot > 0 then
521: frt_2b_applied := arpcurr.currRound(frt_row.frt_rem * x_frt / all_frtrem_tot);
522: else -- Overappl (all_frtrem_tot < 0) should be done at the UI level,
523: -- so this means all_frtrem_tot = 0
524: if all_frtorig_tot <> 0 then
525: frt_2b_applied := arpcurr.currRound(frt_row.frt_orig * x_frt / all_frtorig_tot);

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

521: frt_2b_applied := arpcurr.currRound(frt_row.frt_rem * x_frt / all_frtrem_tot);
522: else -- Overappl (all_frtrem_tot < 0) should be done at the UI level,
523: -- so this means all_frtrem_tot = 0
524: if all_frtorig_tot <> 0 then
525: frt_2b_applied := arpcurr.currRound(frt_row.frt_orig * x_frt / all_frtorig_tot);
526: else
527: frt_2b_applied := 0;
528: end if;
529: end if;

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

530:
531: end if;
532: -- Proate in the same ratio as that of the lin2bapplied / all_lin2bapplied_tot
533: if nvl(x_frt,0) <> 0 then
534: frtdsc_2b_applied := arpcurr.currRound(x_frt_dsc * nvl(frt_2b_applied,0) / nvl(x_frt,0) );
535: else
536: frtdsc_2b_applied := 0;
537: end if;
538: arp_standard.debug ('i='||to_char(iterator)||'.'||

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

599: frt_row.apply_to,
600: frt_row.line_id,
601: DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),
602: frt_row.GROUP_ID,
603: 0, -- Bug 5189370 arpcurr.currRound(nvl(Frt_2b_applied ,0)),
604: X_COMMENTS,
605: NVL(FND_GLOBAL.user_id,-1),
606: SYSDATE,
607: decode(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,

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

613: 'RA'
614: -- 1 line added below added Oct 26
615: , cross_currency_2b_applied
616: -- 2 lines added below Dec 12
617: , arpcurr.currRound(nvl(Frt_2b_applied ,0),x_inv_curr_code)
618: , arpcurr.currRound(nvl(FrtDsc_2b_applied ,0),x_inv_curr_Code),
619: p_attribute_category,
620: p_attribute1,
621: p_attribute2,

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

614: -- 1 line added below added Oct 26
615: , cross_currency_2b_applied
616: -- 2 lines added below Dec 12
617: , arpcurr.currRound(nvl(Frt_2b_applied ,0),x_inv_curr_code)
618: , arpcurr.currRound(nvl(FrtDsc_2b_applied ,0),x_inv_curr_Code),
619: p_attribute_category,
620: p_attribute1,
621: p_attribute2,
622: p_attribute3,

Line 651: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency

647: X_CASH_RECEIPT_ID IN NUMBER,
648: X_CUSTOMER_TRX_ID IN NUMBER,
649: X_chg in number,
650: x_CREATED_BY_MODULE in varchar2
651: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
652: ,x_inv_to_rct_rate in number default 1
653: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
654: ,p_attribute_category IN varchar2 DEFAULT NULL
655: ,p_attribute1 IN varchar2 DEFAULT NULL

Line 653: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency

649: X_chg in number,
650: x_CREATED_BY_MODULE in varchar2
651: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
652: ,x_inv_to_rct_rate in number default 1
653: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
654: ,p_attribute_category IN varchar2 DEFAULT NULL
655: ,p_attribute1 IN varchar2 DEFAULT NULL
656: ,p_attribute2 IN varchar2 DEFAULT NULL
657: ,p_attribute3 IN varchar2 DEFAULT NULL

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

724: if iterator = line_count then
725: chg_2b_applied := x_chg - chg_run_tot;
726: else
727: if all_chgrem_tot > 0 then
728: chg_2b_applied := arpcurr.currRound(chg_row.chg_rem * x_chg / all_chgrem_tot);
729: else -- Overappl (all_chgrem_tot < 0) should be done at the UI level,
730: -- so this means all_chgrem_tot = 0
731: if all_chgorig_tot <> 0 then
732: chg_2b_applied := arpcurr.currRound(chg_row.chg_orig * x_chg / all_chgorig_tot);

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

728: chg_2b_applied := arpcurr.currRound(chg_row.chg_rem * x_chg / all_chgrem_tot);
729: else -- Overappl (all_chgrem_tot < 0) should be done at the UI level,
730: -- so this means all_chgrem_tot = 0
731: if all_chgorig_tot <> 0 then
732: chg_2b_applied := arpcurr.currRound(chg_row.chg_orig * x_chg / all_chgorig_tot);
733: else
734: chg_2b_applied := 0;
735: end if;
736: end if;

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

798: chg_row.apply_to,
799: chg_row.line_id,
800: DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),
801: chg_row.GROUP_ID,
802: 0, -- Bug 5189370 arpcurr.currRound(nvl(chg_2b_applied ,0)),
803: NVL(FND_GLOBAL.user_id,-1),
804: SYSDATE,
805: decode(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,
806: FND_GLOBAL.login_id,FND_GLOBAL.conc_login_id),

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

811: 'RA'
812: -- 1 line added below Oct 26
813: , cross_currency_2b_applied
814: -- 1 line added below Dec 12
815: , arpcurr.currRound(nvl(chg_2b_applied ,0),x_inv_curr_code),
816: p_attribute_category,
817: p_attribute1,
818: p_attribute2,
819: p_attribute3,

Line 978: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency

974: X_lin_dsc in number,
975: x_tax_dsc in number ,
976: X_frt_dsc in number,
977: x_CREATED_BY_MODULE in varchar2
978: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
979: ,x_inv_to_rct_rate in number default 1
980: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
981: ) IS
982:

Line 980: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency

976: X_frt_dsc in number,
977: x_CREATED_BY_MODULE in varchar2
978: ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency
979: ,x_inv_to_rct_rate in number default 1
980: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
981: ) IS
982:
983: BEGIN
984: -- Bug 7241111 instead of deleting now inserting offset rows