DBA Data[Home] [Help]

APPS.ARP_PROCESS_ADJUSTMENT dependencies on ZX_PRODUCT_OPTIONS

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

3948: AND ct.customer_Trx_id = lines.customer_trx_id;
3949: END IF;
3950:
3951: -- Bug 2189230
3952: -- 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
3953: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options
3954: BEGIN
3955: SELECT tax_rounding_rule INTO l_rounding_rule
3956: FROM zx_product_options

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

3949: END IF;
3950:
3951: -- Bug 2189230
3952: -- 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
3953: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options
3954: BEGIN
3955: SELECT tax_rounding_rule INTO l_rounding_rule
3956: FROM zx_product_options
3957: WHERE application_id = 222

Line 3956: FROM zx_product_options

3952: -- 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
3953: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options
3954: BEGIN
3955: SELECT tax_rounding_rule INTO l_rounding_rule
3956: FROM zx_product_options
3957: WHERE application_id = 222
3958: AND org_id = arp_global.sysparam.org_id;
3959: EXCEPTION
3960: WHEN NO_DATA_FOUND THEN

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

3958: AND org_id = arp_global.sysparam.org_id;
3959: EXCEPTION
3960: WHEN NO_DATA_FOUND THEN
3961: l_rounding_rule := NULL;
3962: arp_util.debug('tax_rounding_rule will be defaulted because there is no row in zx_product_options');
3963: arp_util.debug('Ideal Default Tax Rounding Rule will be : NEAREST');
3964: END;
3965: arp_util.debug('tax_rounding_rule = ' || l_rounding_rule);
3966: