2546:
2547: CURSOR Cur_organization
2548: IS
2549: SELECT organization_id
2550: FROM mtl_parameters
2551: WHERE organization_id = p_organization_id
2552: AND process_enabled_flag = 'Y';
2553:
2554: /******************
2593: * 20-Oct-2005 Anand Thiyagarajan - Created *
2594: ***************************************************************************************/
2595: FUNCTION Validate_Organization_code
2596: (
2597: p_organization_code IN mtl_parameters.organization_code%TYPE
2598: )
2599: RETURN NUMBER
2600: IS
2601:
2605:
2606: CURSOR Cur_organization
2607: IS
2608: SELECT organization_id
2609: FROM mtl_parameters
2610: WHERE organization_code = p_organization_code;
2611:
2612: /******************
2613: * Local Variables *