2221: l_spec_test_all GMD_SPEC_TESTS_B%ROWTYPE;
2222:
2223: --End Bug#5220513
2224:
2225: --RLNAGARA Bug 4918820 Changed from mtl_organizations to mtl_parameters
2226: CURSOR get_organization_code (l_organization_id NUMBER) IS
2227: SELECT organization_code
2228: FROM mtl_parameters
2229: WHERE organization_id = l_organization_id;
2254: e_sample_fetch_error EXCEPTION;
2255: e_event_spec_disp_insert_error EXCEPTION;
2256: e_sample_spec_disp_insert_err EXCEPTION;
2257: e_spec_results_insert_error EXCEPTION;
2258: l_organization_code mtl_organizations.organization_code%TYPE;
2259:
2260:
2261:
2262: BEGIN