277: RETURN u_name;
278: END IF;
279: END get_user_name;
280:
281: --get_plan_view and get_import_view are copied from qa_plans_pub to build the view names in the view_name and import_view_name
282: --for a given plan name
283: FUNCTION get_plan_view_name(p_name VARCHAR2) RETURN VARCHAR2 IS
284: BEGIN
285: return 'Q_' || translate(substr(p_name, 1, 26), ' ''', '__') || '_V';
894: RETURN -1;
895: END IF;
896:
897: --call the copy_collection_plan procedure
898: qa_plans_pub.copy_collection_plan(
899: p_api_version => 1.0,
900: p_user_name => user_name,
901: p_plan_name => this_plan.src_name,
902: p_organization_code => src_org_code,