DBA Data[Home] [Help]

APPS.ARP_LLCA_ADJUST_PKG dependencies on ZX_PRODUCT_OPTIONS

Line 330: -- 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

326: arp_standard.debug('Number of tax lines = ' || l_total_tax_lines);
327: END IF;
328:
329: -- get rounding rule
330: -- 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
331: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options
332: BEGIN
333: SELECT tax_rounding_rule
334: INTO l_rounding_rule

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

327: END IF;
328:
329: -- get rounding rule
330: -- 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
331: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options
332: BEGIN
333: SELECT tax_rounding_rule
334: INTO l_rounding_rule
335: FROM zx_product_options

Line 335: FROM zx_product_options

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

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

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