DBA Data[Home] [Help]

APPS.ARP_LLCA_ADJUST_PKG dependencies on ZX_PRODUCT_OPTIONS

Line 329: -- Bug 5514473 : Handled no data found so that tax_rounding_rule will be defaulted if there is no data in zx_product_options for the org

325: arp_standard.debug('Number of tax lines = ' || l_total_tax_lines);
326: END IF;
327:
328: -- get rounding rule
329: -- Bug 5514473 : Handled no data found so that tax_rounding_rule will be defaulted if there is no data in zx_product_options for the org
330: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options
331: BEGIN
332: SELECT tax_rounding_rule
333: INTO l_rounding_rule

Line 330: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options

326: END IF;
327:
328: -- get rounding rule
329: -- Bug 5514473 : Handled no data found so that tax_rounding_rule will be defaulted if there is no data in zx_product_options for the org
330: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options
331: BEGIN
332: SELECT tax_rounding_rule
333: INTO l_rounding_rule
334: FROM zx_product_options

Line 334: FROM zx_product_options

330: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options
331: BEGIN
332: SELECT tax_rounding_rule
333: INTO l_rounding_rule
334: FROM zx_product_options
335: WHERE application_id = 222;
336: EXCEPTION
337: WHEN NO_DATA_FOUND THEN
338: l_rounding_rule := NULL;

Line 339: arp_util.debug('tax_rounding_rule will be defaulted because there is no row in zx_product_options');

335: WHERE application_id = 222;
336: EXCEPTION
337: WHEN NO_DATA_FOUND THEN
338: l_rounding_rule := NULL;
339: arp_util.debug('tax_rounding_rule will be defaulted because there is no row in zx_product_options');
340: arp_util.debug('Ideal Default Tax Rounding Rule will be : NEAREST');
341: END;
342:
343: -- get currency information