68: ******/
69: FUNCTION get_natural_acct_tax (
70: p_ccid IN NUMBER,
71: p_internal_organization_id IN NUMBER,
72: p_set_of_books_id IN ar_system_parameters.set_of_books_id%TYPE,
73: p_trx_date IN ra_customer_trx.trx_date%TYPE,
74: p_check_override_only IN VARCHAR2)
75: RETURN VARCHAR2;
76:
2076:
2077: FUNCTION get_natural_acct_tax (
2078: p_ccid IN NUMBER
2079: ,p_internal_organization_id IN NUMBER
2080: ,p_set_of_books_id IN ar_system_parameters.set_of_books_id%TYPE
2081: ,p_trx_date IN ra_customer_trx.trx_date%TYPE
2082: ,p_check_override_only IN VARCHAR2 ) RETURN VARCHAR2 IS
2083:
2084:
2428: sysinfo.sysparam.TAX_ROUNDING_ALLOW_OVERRIDE
2429: := sysinfo.ar_product_options_rec.allow_tax_rounding_ovrd_flag;
2430:
2431: --
2432: -- Bug#4625479- get default country code from ar_system_parameters
2433: --
2434: pop_ar_system_param_info(p_internal_organization_id,
2435: p_return_status);
2436:
2580: sysinfo.sysparam.TAX_ROUNDING_ALLOW_OVERRIDE
2581: := sysinfo.pa_product_options_rec.allow_tax_rounding_ovrd_flag;
2582:
2583: --
2584: -- Bug#4625479- get default country code from ar_system_parameters
2585: --
2586: pop_ar_system_param_info(p_internal_organization_id,
2587: p_return_status);
2588:
2617: /*----------------------------------------------------------------------------*
2618: | PROCEDURE pop_ar_system_param_info |
2619: | |
2620: | DESCRIPTION |
2621: | This procedure populates default country from ar_system_parameters |
2622: | |
2623: | RETURNS |
2624: | |
2625: | HISTORY |
2632: IS
2633: CURSOR c_ar_system_param(c_org_id NUMBER)
2634: IS
2635: SELECT default_country
2636: FROM ar_system_parameters_all
2637: WHERE org_id = c_org_id;
2638:
2639: BEGIN
2640:
2650: -- init return status
2651: p_return_status := FND_API.G_RET_STS_SUCCESS;
2652:
2653: --
2654: -- Fetch AR system parameters
2655: --
2656: OPEN c_ar_system_param(p_internal_organization_id);
2657: FETCH c_ar_system_param
2658: INTO sysinfo.sysparam.default_country;