APPS.AR_INVOICE_UTILS dependencies on ZX_PRODUCT_OPTIONS

Line 2357: l_tax_use_exempt_flag zx_product_options.tax_use_customer_exempt_flag%type;

2353:
2354: PROCEDURE validate_default_tax (
2355: x_errmsg OUT NOCOPY VARCHAR2,
2356: x_return_status OUT NOCOPY VARCHAR2) AS
2357: l_tax_use_exempt_flag zx_product_options.tax_use_customer_exempt_flag%type;
2358:
2359: BEGIN
2360: IF pg_debug = 'Y'
2361: THEN

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

2363: END IF;
2364:
2365: x_return_status := FND_API.G_RET_STS_SUCCESS;
2366: BEGIN
2367: /* 4257557 - changed to zx_product_options */
2368: select nvl(tax_use_customer_exempt_flag,'N')
2369: into l_tax_use_exempt_flag
2370: from zx_product_options
2371: where application_id = 222;

Line 2370: from zx_product_options

2366: BEGIN
2367: /* 4257557 - changed to zx_product_options */
2368: select nvl(tax_use_customer_exempt_flag,'N')
2369: into l_tax_use_exempt_flag
2370: from zx_product_options
2371: where application_id = 222;
2372:
2373: EXCEPTION
2374: WHEN NO_DATA_FOUND THEN

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

2373: EXCEPTION
2374: WHEN NO_DATA_FOUND THEN
2375: IF pg_debug = 'Y'
2376: THEN
2377: debug (' No rows in zx_product_options' );
2378: debug ('AR_INVOICE_UTILS.validate_default_tax(-)' );
2379: END IF;
2380: RETURN;
2381: END;

Line 4312: l_tax_use_exempt_flag zx_product_options.tax_use_customer_exempt_flag%type;

4308:
4309: PROCEDURE validate_tax_exemption (
4310: x_errmsg OUT NOCOPY VARCHAR2,
4311: x_return_status OUT NOCOPY VARCHAR2) IS
4312: l_tax_use_exempt_flag zx_product_options.tax_use_customer_exempt_flag%type;
4313: BEGIN
4314: -- tax handling
4315: -- if tax_exempt flag is 'E' then tax exempt reason is mandatory.
4316: -- tax reason is alterable only if profile ar_allow_trx_line_exemptions

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

4324: END IF;
4325:
4326: x_return_status := FND_API.G_RET_STS_SUCCESS;
4327: BEGIN
4328: /* 4257557 - changed to zx_product_options */
4329: select nvl(tax_use_customer_exempt_flag,'N')
4330: into l_tax_use_exempt_flag
4331: from zx_product_options
4332: where application_id = 222;

Line 4331: from zx_product_options

4327: BEGIN
4328: /* 4257557 - changed to zx_product_options */
4329: select nvl(tax_use_customer_exempt_flag,'N')
4330: into l_tax_use_exempt_flag
4331: from zx_product_options
4332: where application_id = 222;
4333:
4334: EXCEPTION /*7448838-Adding Exception Block*/
4335: WHEN NO_DATA_FOUND THEN

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

4334: EXCEPTION /*7448838-Adding Exception Block*/
4335: WHEN NO_DATA_FOUND THEN
4336: IF pg_debug = 'Y'
4337: THEN
4338: debug (' No rows in zx_product_options' );
4339: debug ('AR_INVOICE_UTILS.validate_tax_exemption(-)' );
4340: END IF;
4341: RETURN;
4342: END;