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.ARP_PROCESS_ADJUSTMENT dependencies on ZX_PRODUCT_OPTIONS

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

3365: AND ct.customer_Trx_id = lines.customer_trx_id;
3366: END IF;
3367:
3368: -- Bug 2189230
3369: -- 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
3370: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options
3371: BEGIN
3372: SELECT tax_rounding_rule INTO l_rounding_rule
3373: FROM zx_product_options

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

3366: END IF;
3367:
3368: -- Bug 2189230
3369: -- 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
3370: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options
3371: BEGIN
3372: SELECT tax_rounding_rule INTO l_rounding_rule
3373: FROM zx_product_options
3374: WHERE application_id = 222

Line 3373: FROM zx_product_options

3369: -- 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
3370: -- Bug 5514473 : When application tax options are not defined through tax manager for newly created orgs there will no data in zx_product_options
3371: BEGIN
3372: SELECT tax_rounding_rule INTO l_rounding_rule
3373: FROM zx_product_options
3374: WHERE application_id = 222
3375: AND org_id = arp_global.sysparam.org_id;
3376: EXCEPTION
3377: WHEN NO_DATA_FOUND THEN

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

3375: AND org_id = arp_global.sysparam.org_id;
3376: EXCEPTION
3377: WHEN NO_DATA_FOUND THEN
3378: l_rounding_rule := NULL;
3379: arp_util.debug('tax_rounding_rule will be defaulted because there is no row in zx_product_options');
3380: arp_util.debug('Ideal Default Tax Rounding Rule will be : NEAREST');
3381: END;
3382: arp_util.debug('tax_rounding_rule = ' || l_rounding_rule);
3383: