DBA Data[Home] [Help]

APPS.RA_LL_RCV_GROUPS_PKG dependencies on ARPCURR

Line 39: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency

35: x_tax_dsc in number ,
36: x_CREATED_BY_MODULE in varchar2
37: -- Oct 04 added two param below
38: ,x_inv_to_rct_rate in number default 1
39: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
40: ) IS
41:
42: cursor c_lintax
43: is

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

145: if all_linrem_tot > 0 then
146: arp_standard.debug ('i='||to_char(iterator)||'.'||
147: 'NOT LAST, all_linrem_tot<>0. line_run_tot=' || line_run_tot
148: || '. all_linorig_tot=' || all_linorig_tot);
149: line_2b_applied := arpcurr.currRound(lintax_row.line_rem * nvl(x_lin,0) / all_linrem_tot);
150:
151: else -- Overappl (all_linrem_tot < 0) should be done at the UI level,
152: -- so this means all_linrem_tot = 0
153: arp_standard.debug ('i='||to_char(iterator)||'.'||

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

153: arp_standard.debug ('i='||to_char(iterator)||'.'||
154: 'NOT LAST, all_linrem_tot=0. line_run_tot=' || line_run_tot
155: || '. all_linorig_tot=' || all_linorig_tot);
156: if all_linorig_tot <> 0 then
157: line_2b_applied := arpcurr.currRound(lintax_row.line_orig * nvl(x_lin,0) / all_linorig_tot);
158: else
159: line_2b_applied := 0;
160: end if;
161: end if;

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

162:
163: --Prorate the Tax Amount
164:
165: if all_taxrem_tot > 0 then
166: tax_2b_applied := arpcurr.currRound(lintax_row.tax_rem * nvl(x_tax,0) / all_taxrem_tot);
167: else-- Overappl (all_taxrem_tot < 0) should be done at the UI level,
168: -- so this means all_taxrem_tot = 0
169: if all_taxorig_tot <> 0 then
170: tax_2b_applied := arpcurr.currRound(lintax_row.tax_orig * nvl(x_tax,0) / all_taxorig_tot);

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

166: tax_2b_applied := arpcurr.currRound(lintax_row.tax_rem * nvl(x_tax,0) / all_taxrem_tot);
167: else-- Overappl (all_taxrem_tot < 0) should be done at the UI level,
168: -- so this means all_taxrem_tot = 0
169: if all_taxorig_tot <> 0 then
170: tax_2b_applied := arpcurr.currRound(lintax_row.tax_orig * nvl(x_tax,0) / all_taxorig_tot);
171: else
172: tax_2b_applied := 0;
173: end if;
174: end if ;

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

175:
176: -- Added Dec 7, 2005 - Bug 4775656. Discounts are not getting saved from Summary
177: -- Proate in the same ratio as that of the lin2bapplied / all_lin2bapplied_tot
178: if nvl(x_lin,0) <> 0 then
179: lindsc_2b_applied := arpcurr.currRound(x_lin_dsc * nvl(line_2b_applied,0) / nvl(x_lin,0) );
180: else
181: lindsc_2b_applied := 0;
182: end if;
183: -- Proate in the same ratio as that of the tax2bapplied / all_tax2bapplied_tot

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

181: lindsc_2b_applied := 0;
182: end if;
183: -- Proate in the same ratio as that of the tax2bapplied / all_tax2bapplied_tot
184: if nvl(x_tax,0) <> 0 then
185: taxdsc_2b_applied := arpcurr.currRound(x_tax_dsc * nvl(tax_2b_applied,0) / nvl(x_tax,0) );
186: else
187: taxdsc_2b_applied := 0;
188: end if;
189: -- End of additions for bug 4775656

Line 233: arpcurr.currRound(nvl(line_2b_applied ,0)),

229: lintax_row.apply_to,
230: lintax_row.line_id,
231: DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),
232: DECODE(X_GROUP_ID, FND_API.G_MISS_NUM, NULL , X_GROUP_ID),
233: arpcurr.currRound(nvl(line_2b_applied ,0)),
234: arp_util.currRound(nvl(cross_currency_2b_applied,0), x_rct_curr_code ),
235: arpcurr.currRound(nvl(tax_2b_applied ,0)),
236: NVL(FND_GLOBAL.user_id,-1),
237: SYSDATE,

Line 235: arpcurr.currRound(nvl(tax_2b_applied ,0)),

231: DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),
232: DECODE(X_GROUP_ID, FND_API.G_MISS_NUM, NULL , X_GROUP_ID),
233: arpcurr.currRound(nvl(line_2b_applied ,0)),
234: arp_util.currRound(nvl(cross_currency_2b_applied,0), x_rct_curr_code ),
235: arpcurr.currRound(nvl(tax_2b_applied ,0)),
236: NVL(FND_GLOBAL.user_id,-1),
237: SYSDATE,
238: decode(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,
239: FND_GLOBAL.login_id,FND_GLOBAL.conc_login_id),

Line 283: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency

279: x_tax_dsc in number ,
280: x_CREATED_BY_MODULE IN VARCHAR2
281: -- Oct 04 added two param below
282: ,x_inv_to_rct_rate in number default 1
283: ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
284: ) IS
285: begin
286: --insert_lintax_rows ( x_cash_receipt_id, x_customer_Trx_id, x_line_only, x_tax_only,
287: -- x_lin_dsc, x_tax_dsc, x_created_by_module

Line 318: ,x_rct_curr_code in varchar2 := arpcurr.FunctionalCurrency

314: x_tax_dsc in number ,
315: x_CREATED_BY_MODULE in varchar2
316: -- Oct 04 added two param below
317: ,x_inv_to_rct_rate in number default 1
318: ,x_rct_curr_code in varchar2 := arpcurr.FunctionalCurrency
319: ) IS
320: p_rowid rowid;
321: BEGIN
322: delete_Row (x_group_id => x_group_id,