APPS.AR_INVOICE_UTILS dependencies on ZX_PRODUCT_OPTIONS

Line 2280: l_tax_use_exempt_flag zx_product_options.tax_use_customer_exempt_flag%type;

2276:
2277: PROCEDURE validate_default_tax (
2278: x_errmsg OUT NOCOPY VARCHAR2,
2279: x_return_status OUT NOCOPY VARCHAR2) AS
2280: l_tax_use_exempt_flag zx_product_options.tax_use_customer_exempt_flag%type;
2281:
2282: BEGIN
2283: IF pg_debug = 'Y'
2284: THEN

Line 2290: /* 4257557 - changed to zx_product_options */

2286: END IF;
2287:
2288: x_return_status := FND_API.G_RET_STS_SUCCESS;
2289: BEGIN
2290: /* 4257557 - changed to zx_product_options */
2291: select nvl(tax_use_customer_exempt_flag,'N')
2292: into l_tax_use_exempt_flag
2293: from zx_product_options
2294: where application_id = 222;

Line 2293: from zx_product_options

2289: BEGIN
2290: /* 4257557 - changed to zx_product_options */
2291: select nvl(tax_use_customer_exempt_flag,'N')
2292: into l_tax_use_exempt_flag
2293: from zx_product_options
2294: where application_id = 222;
2295:
2296: EXCEPTION
2297: WHEN NO_DATA_FOUND THEN

Line 2300: debug (' No rows in zx_product_options' );

2296: EXCEPTION
2297: WHEN NO_DATA_FOUND THEN
2298: IF pg_debug = 'Y'
2299: THEN
2300: debug (' No rows in zx_product_options' );
2301: debug ('AR_INVOICE_UTILS.validate_default_tax(-)' );
2302: END IF;
2303: RETURN;
2304: END;

Line 4216: l_tax_use_exempt_flag zx_product_options.tax_use_customer_exempt_flag%type;

4212:
4213: PROCEDURE validate_tax_exemption (
4214: x_errmsg OUT NOCOPY VARCHAR2,
4215: x_return_status OUT NOCOPY VARCHAR2) IS
4216: l_tax_use_exempt_flag zx_product_options.tax_use_customer_exempt_flag%type;
4217: BEGIN
4218: -- tax handling
4219: -- if tax_exempt flag is 'E' then tax exempt reason is mandatory.
4220: -- tax reason is alterable only if profile ar_allow_trx_line_exemptions

Line 4232: /* 4257557 - changed to zx_product_options */

4228: END IF;
4229:
4230: x_return_status := FND_API.G_RET_STS_SUCCESS;
4231: BEGIN
4232: /* 4257557 - changed to zx_product_options */
4233: select nvl(tax_use_customer_exempt_flag,'N')
4234: into l_tax_use_exempt_flag
4235: from zx_product_options
4236: where application_id = 222;

Line 4235: from zx_product_options

4231: BEGIN
4232: /* 4257557 - changed to zx_product_options */
4233: select nvl(tax_use_customer_exempt_flag,'N')
4234: into l_tax_use_exempt_flag
4235: from zx_product_options
4236: where application_id = 222;
4237: END;
4238: IF pg_debug = 'Y'
4239: THEN